Таблица: SL18 - «Invoice Consolidation». Маска имени таблицы: «SL18%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL18001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да | |
SL18002 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code Document | 2 | Да | |
SL18003 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 3 | Да | |
SL18004 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceRefNo | Invoice Reference Number | 4 | Да | |
SL18005 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactioNo | Transaction Number | |||
SL18006 | DATETIME | DATE | 0 | 0 | 8 | OrgInvoiDate | Original Invoice Date | |||
SL18007 | NUMERIC | MONEY | 28 | 8 | 20 | OrgInvAmoLCU | Original Invoice Amount (Local Currency) | |||
SL18008 | NUMERIC | MONEY | 28 | 8 | 20 | OrgInvAmoORG | Original Invoice Amount (Document Currency) | |||
SL18009 | NUMERIC | MONEY | 28 | 8 | 20 | SalesTaxAmnt | Sales Tax Amount (Local Currency) | |||
SL18010 | NVARCHAR | VSTRING | 20 | 0 | 20 | CommentaryTx | Commentary Text | |||
SL18011 | NVARCHAR | VSTRING | 1 | 0 | 1 | UseField23 | (obsolete) | |||
SL18012 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
SL18013 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
SL18014 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | |||
SL18015 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Slip Type | 0 - Normal invoice
1 - Discount 2 - Cash discount |
||
SL18016 | NVARCHAR | VSTRING | 1 | 0 | 1 | Source_Module_Sign | Source Module Type | Specifies the module where the merge invoice was created:
0 - Sales order 1 - Project 2 - Service Order |
||
SL18017 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Merge Proposal Printed | |||
SL18018 | NVARCHAR | VSTRING | 1 | 0 | 1 | MergeType | Merge Type | 1 - Merge/Consolidate per week
2 - Merge/Consolidate per month |
||
SL18019 | NVARCHAR | VSTRING | 20 | 0 | 20 | CustomerRef | Customer Reference | |||
SL18020 | NVARCHAR | VSTRING | 20 | 0 | 20 | OurReference | Our Reference | |||
SL18021 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubObjectNo | Source Sub-object | For merge invoices created from project management, this field will hold the sub-project code if invoicing was done on sub-project level. | ||
SL18022 | NVARCHAR | VSTRING | 25 | 0 | 25 | TextLine1 | Text Line 1 | |||
SL18023 | NVARCHAR | VSTRING | 25 | 0 | 25 | TextLine2 | Text Line 2 | |||
SL18024 | NVARCHAR | VSTRING | 2 | 0 | 2 | VATCode | VAT Code | |||
SL18025 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate1 | Exchange Rate 1 | |||
SL18026 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate2 | Exchange Rate 2 | |||
SL18027 | NCHAR | STRING | 3 | 0 | 3 | ExchgAlgtm | Exchange Algorithm | |||
SL18028 | NVARCHAR | VSTRING | 12 | 0 | 12 | ExtendedObject | Source Object | Value is dependent on the source module type (SL18016) and can be a sales order, service order or a project number. | ||
SL18029 | NCHAR | STRING | 6 | 0 | 6 | LiabilityCode | Tax Liability Code |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Ledger | Invoice Consolidation