Таблица: SL26 - «Sales Statement Proposal References». Маска имени таблицы: «SL26%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| SL26001 | NVARCHAR | VSTRING | 6 | 0 | 6 | StatPropNo | Statement Proposal Number | 1 | Да | |
| SL26002 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCode | Customer Code | 2 | Да | |
| SL26003 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrCode | Currency Code | 3 | Да | |
| SL26004 | NVARCHAR | VSTRING | 10 | 0 | 10 | SalesStatRefNo | Sales Statement Reference Number | 4 | Да | |
| 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 | Да | |
| 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 |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Sales Statement Proposal References Table
/* */