Таблица | Table: SL26 - «Sales Statement Proposal References». Маска имени таблицы | Table Name Mask: «SL26%cc00»
| Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
| SL26001 | NVARCHAR | VSTRING | 6 | 0 | 6 | StatPropNo | Statement Proposal Number | 1 | Да / Yes | |
| SL26002 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCode | Customer Code | 2 | Да / Yes | |
| SL26003 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrCode | Currency Code | 3 | Да / Yes | |
| SL26004 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesStatRefNo | Sales Statement Reference Number | 4 | Да / Yes | |
| SL26005 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesStatNo | Sales Statement Number | |||
| SL26006 | NCHAR | STRING | 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 |
||
| SL26007 | NCHAR | STRING | 1 | 0 | 1 | InvTypeFlag2 | (obsolete) | |||
| SL26008 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 5 | Да / Yes | |
| SL26009 | NCHAR | STRING | 1 | 0 | 1 | InclInStat | Included in Statement | |||
| SL26010 | NCHAR | STRING | 1 | 0 | 1 | ExclFromBill | Excluded from Billing | |||
| SL26011 | NCHAR | STRING | 12 | 0 | 12 | OrderNo | Order Number | |||
| SL26012 | NCHAR | STRING | 1 | 0 | 1 | Spare | Source for Invoice |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Ledger | Sales Statement Proposal References Table
/* */