Таблица: ST25 - «Lease Statistics». Маска имени таблицы: «ST25%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST25001 | NCHAR | STRING | 12 | 0 | 12 | Counter | Counter | 1 | Да | |
ST25002 | NCHAR | STRING | 10 | 0 | 10 | Contract number | Contract number | |||
ST25003 | NCHAR | STRING | 10 | 0 | 10 | Master contract number | Master contract number | |||
ST25004 | NCHAR | STRING | 15 | 0 | 15 | Invoice number | Invoice number | |||
ST25005 | DATETIME | DATE | 0 | 0 | 8 | Invoice date | Invoice date | |||
ST25006 | DATETIME | DATE | 0 | 0 | 8 | Invoice from date | Invoice from date | |||
ST25007 | DATETIME | DATE | 0 | 0 | 8 | Invoice to date | Invoice to date | |||
ST25008 | INT | INTEGER | 0 | 0 | 1 | Contract term | Contract term | |||
ST25009 | DATETIME | DATE | 0 | 0 | 8 | Cancelation date | Cancelation date | |||
ST25010 | NVARCHAR | VSTRING | 10 | 0 | 10 | Invoice customer | Invoice customer | |||
ST25011 | NVARCHAR | VSTRING | 4 | 0 | 4 | Invoice customer category | Invoice customer category | |||
ST25012 | NVARCHAR | VSTRING | 25 | 0 | 25 | Invoice customer global ID | Invoice customer global ID | |||
ST25013 | NVARCHAR | VSTRING | 3 | 0 | 3 | Contract type | Contract type | |||
ST25014 | NVARCHAR | VSTRING | 20 | 0 | 20 | Customer PO Number | Customer PO Number | |||
ST25015 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
ST25016 | NVARCHAR | VSTRING | 2 | 0 | 2 | District | District | |||
ST25017 | NVARCHAR | VSTRING | 2 | 0 | 2 | Advertising code | Advertising code | |||
ST25018 | NVARCHAR | VSTRING | 4 | 0 | 4 | City code | City code | |||
ST25019 | NVARCHAR | VSTRING | 5 | 0 | 5 | CNI code | CNI code | |||
ST25020 | NVARCHAR | VSTRING | 6 | 0 | 6 | Manager | Manager | |||
ST25021 | INT | INTEGER | 0 | 0 | 2 | Line type | Line type | |||
ST25022 | NCHAR | STRING | 6 | 0 | 6 | Line number | Line number | |||
ST25023 | NCHAR | STRING | 6 | 0 | 6 | Subline number | Subline number | |||
ST25024 | NCHAR | STRING | 6 | 0 | 6 | Substructure line number | Substructure line number | |||
ST25025 | NVARCHAR | VSTRING | 6 | 0 | 6 | Line group code | Line group code | |||
ST25026 | NVARCHAR | VSTRING | 35 | 0 | 35 | Master asset/Stock code | Master asset/Stock code | |||
ST25027 | NVARCHAR | VSTRING | 20 | 0 | 20 | Serial number | Serial number | |||
ST25028 | NVARCHAR | VSTRING | 10 | 0 | 10 | Value component | Value component | |||
ST25029 | NVARCHAR | VSTRING | 6 | 0 | 6 | Lease Group/Product group | Lease Group/Product group | |||
ST25030 | NVARCHAR | VSTRING | 10 | 0 | 10 | Installation customer | Installation customer | |||
ST25031 | NVARCHAR | VSTRING | 4 | 0 | 4 | Installation customer category | Installation customer category | |||
ST25032 | NCHAR | STRING | 4 | 0 | 4 | Site | Site | |||
ST25033 | NVARCHAR | VSTRING | 6 | 0 | 6 | Line WH | Line WH | |||
ST25034 | NVARCHAR | VSTRING | 10 | 0 | 10 | Line Resource | Line Resource | |||
ST25035 | DATETIME | DATE | 0 | 0 | 8 | Line start date | Line start date | |||
ST25036 | DATETIME | DATE | 0 | 0 | 8 | Line end date | Line end date | |||
ST25037 | DATETIME | DATE | 0 | 0 | 8 | Line Invoice From date | Line Invoice From date | |||
ST25038 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Requested Qty Sales units | Requested Qty Sales units | |||
ST25039 | DATETIME | DATE | 0 | 0 | 8 | Requested Date | Requested Date | |||
ST25040 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Invoiced Qty Sales units | Invoiced Qty Sales units | |||
ST25041 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Delivered Qty Sales Units | Delivered Qty Sales Units | |||
ST25042 | DATETIME | DATE | 0 | 0 | 8 | Delivery Date | Delivery Date | |||
ST25043 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Returned Qty Sales Units | Returned Qty Sales Units | |||
ST25044 | DATETIME | DATE | 0 | 0 | 8 | Returned Date | Returned Date | |||
ST25045 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Sold Qty Sales units | Sold Qty Sales units | |||
ST25046 | DATETIME | DATE | 0 | 0 | 8 | Sale Date | Sale Date | |||
ST25047 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Scrapped Qty sales units | Scrapped Qty sales units | |||
ST25048 | DATETIME | DATE | 0 | 0 | 8 | Scrap Date | Scrap Date | |||
ST25049 | INT | INTEGER | 0 | 0 | 4 | Qty Sales Unit code | Qty Sales Unit code | |||
ST25050 | INT | INTEGER | 0 | 0 | 1 | Price Type | Price Type | |||
ST25051 | NCHAR | STRING | 2 | 0 | 2 | Price List | Price List | |||
ST25052 | NUMERIC | MONEY | 28 | 8 | 20 | Price per time unit (CCU) | Price per time unit (CCU) | |||
ST25053 | INT | INTEGER | 0 | 0 | 2 | Time Unit | Time Unit | |||
ST25054 | NCHAR | STRING | 2 | 0 | 2 | Contract Currency | Contract Currency | |||
ST25055 | NCHAR | STRING | 2 | 0 | 2 | Invoice Currency | Invoice Currency | |||
ST25056 | NUMERIC | MONEY | 28 | 8 | 20 | Net Line Amount / Capital part (ICU) | Net Line Amount / Capital part (ICU) | |||
ST25057 | NUMERIC | MONEY | 28 | 8 | 20 | Net Line Amount / Capital part (LCU) | Net Line Amount / Capital part (LCU) | |||
ST25058 | NUMERIC | MONEY | 28 | 8 | 20 | Change Value / Interest part (ICU) | Change Value / Interest part (ICU) | |||
ST25059 | NUMERIC | MONEY | 28 | 8 | 20 | Change Value / Interest part (LCU) | Change Value / Interest part (LCU) | |||
ST25060 | NUMERIC | MONEY | 28 | 8 | 20 | Total line discount (ICU) | Total line discount (ICU) | |||
ST25061 | NUMERIC | MONEY | 28 | 8 | 20 | Total line discount (LCU) | Total line discount (LCU) | |||
ST25062 | NUMERIC | MONEY | 28 | 8 | 20 | Total line cost (LCU) | Total line cost (LCU) | |||
ST25063 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accounting string | Accounting string | |||
ST25064 | NCHAR | SWITCH | 1 | 0 | 1 | Included into fixed price | Included into fixed price |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Statistics | Lease Statistics