Таблица / Table: SL03 — «Sales Ledger». Маска имени таблицы / Table name mask: «SL03%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
SL03001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да / Yes | |
SL03002 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 2 | Да / Yes | |
SL03003 | NVARCHAR | VSTRING | 9 | 0 | 9 | 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 | 50 | 0 | 50 | 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 | InvTypeFlag3 | Invoice Type Flag3 | |||
SL03032 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL03033 | NVARCHAR | VSTRING | 1 | 0 | 1 | TaxDiscFlag | Tax Discount Flag | |||
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 | Insoluto | Insoluto (Bill in Suspense) | Insoluto (Bill in Suspense) | ||
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 | NVARCHAR | VSTRING | 25 | 0 | 25 | 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 | 9 | 0 | 9 | OrigTransNum | Original Transaction Number | |||
SL03087 | NVARCHAR | VSTRING | 10 | 0 | 10 | InvOrdCust | Customer Code Order | |||
SL03088 | NCHAR | STRING | 3 | 0 | 3 | DocumentType | 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. | ||
SL03112 | NCHAR | STRING | 6 | 0 | 6 | IssuerCode | Issuer Code | |||
SL03113 | NUMERIC | MONEY | 28 | 8 | 20 | CommisionBase | Commision Base | |||
SL03114 | NUMERIC | MONEY | 28 | 8 | 20 | CommisionWithheldCost | Commision Withheld Cost | |||
SL03115 | NVARCHAR | VSTRING | 1 | 0 | 1 | CommissionDistrMethod | Commision Distribution Method | |||
SL03116 | INT | INTEGER | 0 | 0 | 1 | DueDateDefinition | Due Date Definition | |||
SL03117 | NVARCHAR | VSTRING | 2 | 0 | 2 | PaymentTermCode | Payment Term Code | |||
SL03118 | INT | INTEGER | 0 | 0 | 1 | LockPaymentsInvoices | Lock Payments Invoices | 0 – Default. Payment can be matched against invoices or Sales Orders. 1 – Payment is ‘locked’ for linking to Sales Order or to matching against invoices. |
||
SL03119 | INT | INTEGER | 0 | 0 | 3 | CorrectionNumber | Correction Number | Number of corrective Tax Note for Corrective Tax Notes. | ||
SL03120 | NVARCHAR | VSTRING | 50 | 0 | 50 | FiscalReference | Fiscal Reference | |||
SL03121 | NVARCHAR | VSTRING | 12 | 0 | 12 | SpesometroForms | Spesometro Forms | |||
SL03122 | DATETIME | DATE | 0 | 0 | 8 | ReminderDate | Reminder Date | |||
SL03123 | NCHAR | STRING | 2 | 0 | 2 | PO3Subtype | PO3 Sub type | |||
SL03124 | NCHAR | STRING | 3 | 0 | 3 | PaymentCode | Payment Code | |||
SL03125 | NCHAR | STRING | 1 | 0 | 1 | TaxRegStatus | TaxRegStatus | |||
SL03126 | NVARCHAR | VSTRING | 20 | 0 | 20 | PublicProcuremCode1 | Public Procurement Code1 | |||
SL03127 | NVARCHAR | VSTRING | 20 | 0 | 20 | PublicProcuremCode2 | Public Procurement Code2 | |||
SL03128 | NCHAR | STRING | 2 | 0 | 2 | AdvPrepFlag | Advance/Prepayment Flag | |||
SL03129 | NUMERIC | MONEY | 28 | 8 | 20 | AdvPrepDedAmntLCU | Deducted Advance/Prepayment Amount LCU | |||
SL03130 | NUMERIC | MONEY | 28 | 8 | 20 | AdvPrepDedAmntOCU | Deducted Advance/Prepayment Amount OCU |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»