Таблица: ST24 - «Sales Contract Statistics». Маска имени таблицы: «ST24%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST24001 | NCHAR | STRING | 10 | 0 | 10 | ContractNumber | Contract Number | |||
ST24002 | NCHAR | STRING | 6 | 0 | 6 | ContractLineNumber | Contract Line Number | |||
ST24003 | NCHAR | STRING | 6 | 0 | 6 | DeliveryScheduleLineNumber | Delivery Schedule Line Number | |||
ST24004 | NCHAR | STRING | 10 | 0 | 10 | ContractCustomer | Contract Customer | |||
ST24005 | NCHAR | STRING | 1 | 0 | 1 | TransactionType | Transaction Type | |||
ST24006 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | 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 | UnitPriceLCU | Unit Price LCU | |||
ST24010 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | UnitPriceOCU | Unit Price OCU | |||
ST24011 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | Discount | Discount | |||
ST24012 | NCHAR | STRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
ST24013 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | LineAmountLCU | Line Amount LCU | |||
ST24014 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | LineAmountOCU | Line Amount OCU | |||
ST24015 | NCHAR | STRING | 10 | 0 | 10 | SalesOrderNumber | Sales Order Number | |||
ST24016 | NCHAR | STRING | 6 | 0 | 6 | SalesOrderLine | Sales Order Line Number | |||
ST24017 | NCHAR | STRING | 6 | 0 | 6 | SalesOrderSubLine | Sales Order Sub Line Number | |||
ST24018 | DATETIME | DATE | 0 | 0 | 8 | TransactionDate | Transaction Date | |||
ST24019 | DATETIME | DATE | 0 | 0 | 8 | AcceptedDate | Accepted Date | |||
ST24020 | DATETIME | DATE | 0 | 0 | 8 | ExpirationDate | Expiration Date | |||
ST24021 | DATETIME | DATE | 0 | 0 | 8 | LastUsedDate | Last Used Date | |||
ST24022 | NCHAR | STRING | 1 | 0 | 1 | Status | Status | |||
ST24023 | NCHAR | STRING | 10 | 0 | 10 | SearchIndex | Search Index | 1 | Да |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Statistics | Sales Contract Statistics