Таблица | Table: ST25 - «Lease Statistics». Маска имени таблицы | Table Name Mask: «ST25%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
ST25001 NCHAR STRING 12 0 12 Counter Counter   1 Да / Yes
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      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Statistics | Lease Statistics