Таблица: SL31 - «Prepayment Allocation Lines». Маска имени таблицы: «SL31%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL31001 | NVARCHAR | VSTRING | 2 | 0 | 2 | ObjectType | Object Type | 01=Sales Order
02=Service Order 03=Project 04=Direct Invoice 05=Contract |
1 | Да |
SL31002 | NVARCHAR | VSTRING | 15 | 0 | 15 | ObjectNumber | Object Number | 2 | Да | |
SL31003 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProjectCode | Sub-Project Code | 3 | Да | |
SL31004 | NCHAR | STRING | 6 | 0 | 6 | LineNumber | Line Number | 4 | Да | |
SL31005 | NCHAR | STRING | 1 | 0 | 1 | LineType | Line Type | 0-Request
1-Linked Prepayment 2-Adv Invoice |
||
SL31006 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | |||
SL31007 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNumberPayment | Invoice Number Payment | Invoice Number of the Prepayment | ||
SL31008 | NUMERIC | MONEY | 28 | 8 | 20 | AllocatedAmount | Allocated Amount | |||
SL31009 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | AdvancePercentage | Advance Percentage | Used for Line type = 2 and Alloc Amnt = 0 | ||
SL31010 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNumber | Invoice Number | |||
SL31011 | DATETIME | DATE | 0 | 0 | 8 | InvDate | Invoice Date | |||
SL31012 | NCHAR | STRING | 1 | 0 | 1 | InvoiceStatus | Invoice Status | 0-not ready;
1-Print; 2-Printed; 3-Updated |
||
SL31013 | NCHAR | STRING | 1 | 0 | 1 | Deduction | Deduction | 0-On-hold for deduction;
1-Deduct 2-Never deduct (service and advances) |
||
SL31014 | NCHAR | SWITCH | 1 | 0 | 1 | BaseInclTax | Base includes tax | 0-Alloc Amnt dont include tax;
1-Alloc Amnt includes tax |
||
SL31015 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | Currency Code | Currency Allocation | ||
SL31016 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | Due date for Request/Advance Invoice | ||
SL31017 | NCHAR | STRING | 1 | 0 | 1 | Distribution | Distribution | Prepayment tax allocation | ||
SL31018 | NVARCHAR | VSTRING | 40 | 0 | 40 | RemarkText | Remark text | |||
SL31019 | NCHAR | STRING | 6 | 0 | 6 | IssuerCode | Issuer Code | |||
SL31020 | NVARCHAR | VSTRING | 15 | 0 | 15 | TaxNoteNumber | Tax note number |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Prepayment Allocation Lines