Таблица: 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 (Книга Закупок)