Таблица: PL03 - «Purchase Ledger» («Книга Закупок»)

Поле Тип поля Scala Длина Scala Комментарий Первич­ный ключ?
PL03001 VSTRING 10 SupplierCode Да
PL03002 VSTRING 15 InvoiceNo Да
PL03003 VSTRING 6 TransactioNo  
PL03004 DATE 8 InvoiceDate  
PL03005 DATE 8 BookEntrDate  
PL03006 DATE 8 DueDate  
PL03007 DATE 8 DiscDate1  
PL03008 VSTRING 5 Discount1  
PL03009 DATE 8 DiscDate2  
PL03010 VSTRING 5 Discount2  
PL03011 DATE 8 DiscDate3  
PL03012 VSTRING 5 Discount3  
PL03013 MONEY 20 InvAmoLocCur  
PL03014 MONEY 20 InvAmoOriCur  
PL03015 VSTRING 2 CurrencyCode  
PL03016 MONEY 20 SalesTaxAmnt  
PL03017 VSTRING 50 AccString  
PL03018 VSTRING 6 TransNoInvoice  
PL03019 DATE 8 BEDateInv  
PL03020 VSTRING 10 SupplBankNo  
PL03021 STRING 2 WayOfPayment  
PL03022 VSTRING 1 PaymBlock  
PL03023 VSTRING 5 AuthorizCod1  
PL03024 VSTRING 15 CommentaryTx  
PL03025 DATE 8 LatePaymDate  
PL03026 MONEY 20 PaidAmounLCU  
PL03027 MONEY 20 PaiAmoOriCur  
PL03028 VSTRING 1 PaymentSent  
PL03029 VSTRING 1 PaymPriority  
PL03030 VSTRING 1 Spare  
PL03031 VSTRING 1 VATDiffBooked  
PL03032 STRING 1 RecurrInvUpd  
PL03033 VSTRING 10 OrderNo  
PL03034 DATE 8 TRDateInv  
PL03035 VSTRING 22 Spare  
PL03036 MONEY 20 ResVATPaiLCU  
PL03037 VSTRING 1 RecurrInv  
PL03038 VSTRING 3 StateBankCode  
PL03039 VSTRING 1 PrelimBooking  
PL03040 VSTRING 6 InternRefNo  
PL03041 VSTRING 2 OrigCompCode  
PL03042 VSTRING 12 ClearingNLAC  
PL03043 VSTRING 40 ReferenComm  
PL03044 VSTRING 1 CurrContract  
PL03045 VSTRING 10 FixExchgRate  
PL03046 VSTRING 15 ContractNo  
PL03047 VSTRING 3 WithHTaxCode  
PL03048 VSTRING 1 PaymentAuth  
PL03049 VSTRING 20 WithholdTax  
PL03050 VSTRING 2 VATCode  
PL03051 VSTRING 5 AuthoriCode2  
PL03052 VSTRING 3 TaxCode  
PL03053 MONEY 20 Amount  
PL03054 VSTRING 4 RepeatInterval  
PL03055 DATE 8 RepStartDate  
PL03056 DATE 8 RepStopDate  
PL03057 MONEY 20 RepAmount  
PL03058 VSTRING 6 RepPercent  
PL03059 X_NUMERIC 5 WHTax  
PL03060 MONEY 20 VATPaid  
PL03061 X_NUMERIC 10 FixedExchgRate2  
PL03062 STRING 3 FixedExchgAlgtm  
PL03063 X_NUMERIC 10 ExchgRate1ByAmo  
PL03064 X_NUMERIC 10 ExchgRate2ByAmo  
PL03065 STRING 3 ExchgAlgtmByAmo  
PL03066 STRING 20 ReferenceNumber  
PL03067 INTEGER 2 RepCurrCode  
PL03068 MONEY 20 PurchaseOrdAmount  
PL03069 MONEY 20 VATDiffAmount  
PL03070 MONEY 20 AmPaidPNLoc  
PL03071 MONEY 20 AmPaidPNOrig  
PL03072 VSTRING 6 PaymPropNo  
PL03073 VSTRING 10 SupDivisionCode  
PL03074 MONEY 20 UnrealizedPrLoss  
PL03075 MONEY 20 Spare  

Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Purchase Ledger (Книга Закупок) | Purchase Ledger (Книга Закупок)