Таблица: SL03 - «Sales Ledger». Маска имени таблицы: «SL03%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL03001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да | |
SL03002 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 2 | Да | |
SL03003 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactNo | Transaction Number | |||
SL03004 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
SL03005 | DATETIME | DATE | 0 | 0 | 8 | BookEntryDate | Book-Entry Date | |||
SL03006 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
SL03007 | DATETIME | DATE | 0 | 0 | 8 | DiscntDate1 | Discount Date 1 | |||
SL03008 | NVARCHAR | VSTRING | 5 | 0 | 5 | Discount1 | Discount 1 % | |||
SL03009 | DATETIME | DATE | 0 | 0 | 8 | DiscntDate2 | Discount Date 2 | |||
SL03010 | NVARCHAR | VSTRING | 5 | 0 | 5 | Discount | Discount 2 % | |||
SL03011 | DATETIME | DATE | 0 | 0 | 8 | DiscntDate3 | Discount Date 3 | |||
SL03012 | NVARCHAR | VSTRING | 5 | 0 | 5 | Discount3 | Discount 3 % | |||
SL03013 | NUMERIC | MONEY | 28 | 8 | 20 | InvAmoLocCur | Invoice Amount (Local Currency) | |||
SL03014 | NUMERIC | MONEY | 28 | 8 | 20 | InvAmoOriCur | Invoice Amount (Invoice Currency) | |||
SL03015 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurencyCode | Currency Code Invoice | |||
SL03016 | NUMERIC | MONEY | 28 | 8 | 20 | SalesTaxAmo | Sales Tax Amount (Local Currency) | |||
SL03017 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccntString | Accounting String | |||
SL03018 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesTaxPercent | Sales Tax Percentage | Only used for US (country code 1) | ||
SL03019 | NUMERIC | MONEY | 28 | 8 | 20 | VATPaidLCU | (obsolete) | |||
SL03020 | NVARCHAR | VSTRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SL03021 | NVARCHAR | VSTRING | 1 | 0 | 1 | InterestBlck | Interest Blocked | |||
SL03022 | NVARCHAR | VSTRING | 1 | 0 | 1 | ReminderBlck | Reminder Blocked | |||
SL03023 | NVARCHAR | VSTRING | 2 | 0 | 2 | ReminderSent | Number of Reminders Sent | |||
SL03024 | NVARCHAR | VSTRING | 15 | 0 | 15 | CommentaryTx | Commentary Text | |||
SL03025 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Storno Invoice | Indicates if the invoice was created by reversing a previously entered invoice, in this case the accounting transactions created for the invoice is booked with reversed sign (negative amounts are booked as debit and positive amounts are booked as credit).
0 - The invoice is a normally entered/created invoice. 1 - The invoice was created as a storno invoice (booked with reversed sings). |
||
SL03026 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Point of Title Passage | Only used for US (country code 1) in interface with external tax application. | ||
SL03027 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvTypeFlag1 | Invoice Type | Used in combination with periodic billing statements:
0 - Regular invoice 1 - Credit note 2 - Re-invoice 3 - Discount 4 - Other Discount |
||
SL03028 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvTypeFlag2 | (obsolete) | |||
SL03029 | NVARCHAR | VSTRING | 1 | 0 | 1 | ExclFormBillingFlag | Included into Billing | |||
SL03030 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvoicePaidFlag | Invoice Paid | |||
SL03031 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03032 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03033 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03034 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03035 | NVARCHAR | VSTRING | 1 | 0 | 1 | SourceForInv | Source for Invoice | Invoice created by:
1 - Sales order 2 - On-account invoice for service order 4 - Project 5 - Service order 6 - Contract invoice 8 - Merge invoice in sales ledger |
||
SL03036 | NVARCHAR | VSTRING | 12 | 0 | 12 | OrderNumber | Order Number | Order number is assigned depending on the source of the invoice, it might be a sales order number, service order number, project number or contract number. | ||
SL03037 | NVARCHAR | VSTRING | 1 | 0 | 1 | UseField51 | (obsolete) | |||
SL03038 | DATETIME | DATE | 0 | 0 | 8 | LatestIntDate | Last Interest Date | |||
SL03039 | NVARCHAR | VSTRING | 20 | 0 | 20 | TotIntOriCur | Total Interest Charged (Invoice Currency) | |||
SL03040 | NVARCHAR | VSTRING | 1 | 0 | 1 | TransactType | Transaction Type | 0 - Normal invoice
1 - Interest invoice 9 - Temporary value assigned during entry of invoices, indicates that entry of invoice has not been completed. |
||
SL03041 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
SL03042 | NVARCHAR | VSTRING | 1 | 0 | 1 | CollectInvoice | Collection Invoice | Indicates if the invoice has been sent for collection or not.
0 - Invoice has not been sent for collection. 1 - Invoice is in collection status. |
||
SL03043 | NVARCHAR | VSTRING | 2 | 0 | 2 | OrigCompComp | Original Company Code | Used for central sales ledger to specify the company where the invoice was created. | ||
SL03044 | NVARCHAR | VSTRING | 12 | 0 | 12 | ClearNLAC | Clearing Account | Used for central sales ledger to specify the clearing account that was used as debt to the subsidiary company. | ||
SL03045 | NVARCHAR | VSTRING | 1 | 0 | 1 | CurrContract | Currency Contract | |||
SL03046 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | FixExchRate | Fixed Exchange Rate | |||
SL03047 | NVARCHAR | VSTRING | 15 | 0 | 15 | ContractNo | Currency Contract Number | |||
SL03048 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03049 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03050 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03051 | NVARCHAR | VSTRING | 1 | 0 | 1 | PaymentLedger | (obsolete) | |||
SL03052 | NVARCHAR | VSTRING | 2 | 0 | 2 | SalesTaxCode | VAT Code | |||
SL03053 | NUMERIC | MONEY | 28 | 8 | 20 | TotPaydAmLCU | Paid Amount (Local Currency) | |||
SL03054 | NUMERIC | MONEY | 28 | 8 | 20 | TotPaydAmORG | Paid Amount (Invoice Currency) | |||
SL03055 | DATETIME | DATE | 0 | 0 | 8 | LastPaymDate | Last Payment Date | |||
SL03056 | NVARCHAR | VSTRING | 6 | 0 | 6 | InterLatePayment | Interest Late Payment % | |||
SL03057 | NCHAR | STRING | 2 | 0 | 2 | WayOfPayment | Way of Payment | |||
SL03058 | NUMERIC | MONEY | 28 | 8 | 20 | DTASentAmount | Sent Payment Amount (Local Currency) | |||
SL03059 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | FixedExchgRate2 | Fixed Exchange Rate 2 | |||
SL03060 | NCHAR | STRING | 3 | 0 | 3 | FixedExchgAlgtm | Fixed Exchange Algorithm | |||
SL03061 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate1ByAmo | Exchange Rate 1 | |||
SL03062 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate2ByAmo | Exchange Rate 2 | |||
SL03063 | NCHAR | STRING | 3 | 0 | 3 | ExchgAlgtm | Exchange Algorithm | |||
SL03064 | NCHAR | SWITCH | 1 | 0 | 1 | EDIContractSwitch | EDI-Contract | |||
SL03065 | NCHAR | STRING | 20 | 0 | 20 | ReferenceNumber | Reference Number | |||
SL03066 | INT | INTEGER | 0 | 0 | 2 | RepCurrCode | Currency Code Reporting | |||
SL03067 | NUMERIC | MONEY | 28 | 8 | 20 | SalesOrdAmount | Purchase Order Amount | |||
SL03068 | NUMERIC | MONEY | 28 | 8 | 20 | AmPaidPNLoc | Total Paid by PN/PDC (Local Currency) | |||
SL03069 | NUMERIC | MONEY | 28 | 8 | 20 | AmPaidPNOrig | Total Paid by PN/PDC (Invoice Currency) | |||
SL03070 | NVARCHAR | VSTRING | 6 | 0 | 6 | PaymPropNo | Payment Proposal Number | |||
SL03071 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalStatNo | Periodic Billing - Statement Number | |||
SL03072 | NVARCHAR | VSTRING | 15 | 0 | 15 | RefToInvNo | Periodic Billing - Reference | |||
SL03073 | NVARCHAR | VSTRING | 10 | 0 | 10 | RefToStatNo | Reference to Statement Number | |||
SL03074 | NUMERIC | MONEY | 28 | 8 | 20 | UnrealizedPrLoss | Unrealized Profit/Loss (Local Currency) | |||
SL03075 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | (obsolete) | |||
SL03076 | DATETIME | DATE | 0 | 0 | 8 | HistInvDate | Historical Invoice Date | |||
SL03077 | DATETIME | DATE | 0 | 0 | 8 | HistDueDate | Historical Due Date | |||
SL03078 | DATETIME | DATE | 0 | 0 | 8 | HistDiscDate1 | Historical Discount Date 1 | |||
SL03079 | NVARCHAR | VSTRING | 5 | 0 | 5 | HistDisc1 | Historical Discount 1 % | |||
SL03080 | DATETIME | DATE | 0 | 0 | 8 | HistDiscDate2 | Historical Discount Date 2 | |||
SL03081 | NVARCHAR | VSTRING | 5 | 0 | 5 | HistDisc2 | Historical Discount 2 % | |||
SL03082 | DATETIME | DATE | 0 | 0 | 8 | HistDiscDate3 | Historical Discount Date 3 | |||
SL03083 | NVARCHAR | VSTRING | 5 | 0 | 5 | HistDisc3 | Historical Discount 3 % | |||
SL03084 | NVARCHAR | VSTRING | 15 | 0 | 15 | GlobalLocationCode | Global Location Code | |||
SL03085 | NCHAR | STRING | 6 | 0 | 6 | SubObjectNo | Sub-object Number | |||
SL03086 | NVARCHAR | VSTRING | 6 | 0 | 6 | Original transaction number | Original Transaction Number | |||
SL03087 | NVARCHAR | VSTRING | 10 | 0 | 10 | InvOrdCust | Customer Code Order | |||
SL03088 | NCHAR | STRING | 2 | 0 | 2 | Document Type | Document Type | |||
SL03089 | NCHAR | STRING | 6 | 0 | 6 | TaxLiabilityCode | Tax Liability Code | |||
SL03090 | NVARCHAR | VSTRING | 10 | 0 | 10 | CFOPCode | CFOP Code | |||
SL03091 | NVARCHAR | VSTRING | 10 | 0 | 10 | OperationType | Operation Code | |||
SL03092 | NVARCHAR | VSTRING | 10 | 0 | 10 | FiscalTextCode | Fiscal Text Code | |||
SL03093 | NVARCHAR | VSTRING | 10 | 0 | 10 | SerialCode | Serial Invoice Prefix | |||
SL03094 | NVARCHAR | VSTRING | 10 | 0 | 10 | CityCode | City Code | |||
SL03095 | NVARCHAR | VSTRING | 1 | 0 | 1 | Detail | Detail | |||
SL03096 | NVARCHAR | VSTRING | 1 | 0 | 1 | CashMethod | Cash Method [0/1] | |||
SL03097 | NUMERIC | MONEY | 28 | 8 | 20 | WithholdTaxLocCur | With-holding Tax Amount (Local Currency) | |||
SL03098 | NUMERIC | MONEY | 28 | 8 | 20 | WithholdTaxOriCur | With-holding Tax Amount (Original Currency) | |||
SL03099 | NVARCHAR | VSTRING | 20 | 0 | 20 | BankNoteNo | Bank Note Number | |||
SL03100 | NUMERIC | MONEY | 28 | 8 | 20 | NetInvAmntLCU | Net Invoice Amount in Local Currency | |||
SL03101 | NUMERIC | MONEY | 28 | 8 | 20 | NetInvAmntOCU | Net Invoice Amount in Original Currency | |||
SL03102 | NCHAR | SWITCH | 1 | 0 | 1 | Instalments | Instalments | |||
SL03103 | INT | INTEGER | 0 | 0 | 1 | SalesReturnReasonCode | Sales Return Reason Code | |||
SL03104 | NVARCHAR | VSTRING | 15 | 0 | 15 | TaxNoteNo | TaxNoteNo | |||
SL03105 | NVARCHAR | VSTRING | 10 | 0 | 10 | FinOperationCode2 | FinOperationCode2 | |||
SL03106 | NCHAR | STRING | 1 | 0 | 1 | EDIStatus | EDI Status | |||
SL03107 | INT | INTEGER | 0 | 0 | 3 | NumberOfPages | NumberOfPages | |||
SL03108 | NVARCHAR | VSTRING | 16 | 0 | 16 | IssuerExtCode | IssuerExtCode | |||
SL03109 | DATETIME | DATE | 0 | 0 | 8 | IssuerExpDate | IssuerExpDate | |||
SL03110 | NCHAR | STRING | 1 | 0 | 1 | POSMachine | POSMachine | |||
SL03111 | DATETIME | DATE | 0 | 0 | 8 | TaxNoteRegDate | TaxNoteRegDate | The date of tax note registration. |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Ledger | Sales Ledger Invoices