Таблица: ST24 - «Sales Contract Statistics». Маска имени таблицы: «ST24%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST24001 | NCHAR | STRING | 10 | 0 | 10 | Contract Number | Contract Number | |||
ST24002 | NCHAR | STRING | 6 | 0 | 6 | Contract Line Number | Contract Line Number | |||
ST24003 | NCHAR | STRING | 6 | 0 | 6 | Delivery Schedule Line Number | Delivery Schedule Line Number | |||
ST24004 | NCHAR | STRING | 10 | 0 | 10 | Contract Customer | Contract Customer | |||
ST24005 | NCHAR | STRING | 1 | 0 | 1 | Transaction Type | Transaction Type | |||
ST24006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Stock Code | Stock Code | |||
ST24007 | NCHAR | STRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
ST24008 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Quantity | Quantity | |||
ST24009 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Unit Price LCU | Unit Price LCU | |||
ST24010 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Unit Price OCU | Unit Price OCU | |||
ST24011 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Discount | Discount | |||
ST24012 | NCHAR | STRING | 2 | 0 | 2 | Currency Code | Currency Code | |||
ST24013 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Line Amount LCU | Line Amount LCU | |||
ST24014 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Line Amount OCU | Line Amount OCU | |||
ST24015 | NCHAR | STRING | 10 | 0 | 10 | Sales Order Number | Sales Order Number | |||
ST24016 | NCHAR | STRING | 6 | 0 | 6 | Sales Order Line Number | Sales Order Line Number | |||
ST24017 | NCHAR | STRING | 6 | 0 | 6 | Sales Order Sub Line Number | Sales Order Sub Line Number | |||
ST24018 | DATETIME | DATE | 0 | 0 | 8 | Transaction Date | Transaction Date | |||
ST24019 | DATETIME | DATE | 0 | 0 | 8 | Accepted Date | Accepted Date | |||
ST24020 | DATETIME | DATE | 0 | 0 | 8 | Expiration Date | Expiration Date | |||
ST24021 | DATETIME | DATE | 0 | 0 | 8 | Last Used Date | Last Used Date | |||
ST24022 | NCHAR | STRING | 1 | 0 | 1 | Status | Status | |||
ST24023 | NCHAR | STRING | 10 | 0 | 10 | Search Index | Search Index | 1 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Statistics | Sales Contract Statistics