Таблица: SL28 - «Billing Proposal Header». Маска имени таблицы: «SL28%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL28001 | NVARCHAR | VSTRING | 6 | 0 | 6 | StatPropNo | Statement Proposal Number | 1 | Да | |
SL28002 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserIdOwner | Owner | |||
SL28003 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
SL28004 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
SL28005 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
SL28006 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
SL28007 | NVARCHAR | VSTRING | 10 | 0 | 10 | MinCustCode | Minimum Customer Code | |||
SL28008 | NVARCHAR | VSTRING | 10 | 0 | 10 | MaxCustCode | Maximum Customer Code | |||
SL28009 | NVARCHAR | VSTRING | 2 | 0 | 2 | MinCurrCode | Minimum Currency Code | |||
SL28010 | NVARCHAR | VSTRING | 2 | 0 | 2 | MaxCurrCode | Maximum Currency Code | |||
SL28011 | NVARCHAR | VSTRING | 15 | 0 | 15 | MinInvNumber | Minimum Invoice Number | |||
SL28012 | NVARCHAR | VSTRING | 15 | 0 | 15 | MaxInvNumber | Maximum Invoice Number | |||
SL28013 | DATETIME | DATE | 0 | 0 | 8 | MinInvDate | Minimum Invoice Date | |||
SL28014 | DATETIME | DATE | 0 | 0 | 8 | MaxInvDate | Maximum Invoice Date | |||
SL28015 | NVARCHAR | ACCSTR | 50 | 0 | 50 | MinAccSegment | Accounting String Minimum | |||
SL28016 | NVARCHAR | ACCSTR | 50 | 0 | 50 | MaxAccSegment | Accounting String Maximum | |||
SL28017 | DATETIME | DATE | 0 | 0 | 8 | SelectDate | Selection Date | |||
SL28018 | NCHAR | STRING | 1 | 0 | 1 | IncludSuspended | Include Suspended Invoices | |||
SL28019 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | (obsolete) | |||
SL28020 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | (obsolete) | |||
SL28021 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) | |||
SL28022 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | (obsolete) |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Billing Proposal