One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Statistics»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table ST25 — Lease Statistics

Таблица / Table: ST25 — «Lease Statistics». Маска имени таблицы / Table name mask: «ST25%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 Contractnumber Contract number      
ST25003 NCHAR STRING 10 0 10 MasterContractNum Master contract number      
ST25004 NCHAR STRING 15 0 15 InvoiceNumber Invoice number      
ST25005 DATETIME DATE 0 0 8 InvDate Invoice date      
ST25006 DATETIME DATE 0 0 8 InvFromDate Invoice from date      
ST25007 DATETIME DATE 0 0 8 InvToDate Invoice to date      
ST25008 INT INTEGER 0 0 1 ContractTerm Contract term      
ST25009 DATETIME DATE 0 0 8 CancellationDate Cancelation date      
ST25010 NVARCHAR VSTRING 10 0 10 InvCustomer Invoice customer      
ST25011 NVARCHAR VSTRING 4 0 4 InvCustCategory Invoice customer category      
ST25012 NVARCHAR VSTRING 25 0 25 InvCustGlobalID Invoice customer global ID      
ST25013 NVARCHAR VSTRING 3 0 3 ContractType Contract type      
ST25014 NVARCHAR VSTRING 30 0 30 CustomerPONumber 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 Advertisingcode Advertising code      
ST25018 NVARCHAR VSTRING 4 0 4 CityCode City code      
ST25019 NVARCHAR VSTRING 5 0 5 CNICode CNI code      
ST25020 NVARCHAR VSTRING 6 0 6 Manager Manager      
ST25021 INT INTEGER 0 0 2 LineType Line type      
ST25022 NCHAR STRING 6 0 6 LineNumber Line number      
ST25023 NCHAR STRING 6 0 6 SubLineNum Subline number      
ST25024 NCHAR STRING 6 0 6 SubstructLineNum Substructure line number      
ST25025 NVARCHAR VSTRING 6 0 6 LineGroupCode Line group code      
ST25026 NVARCHAR VSTRING 35 0 35 MasterAssetStockCode Master asset/Stock code      
ST25027 NVARCHAR VSTRING 20 0 20 SerNum Serial number      
ST25028 NVARCHAR VSTRING 10 0 10 ValueComponent Value component      
ST25029 NVARCHAR VSTRING 6 0 6 LeaseGroupProdGrp Lease Group/Product group      
ST25030 NVARCHAR VSTRING 10 0 10 InstallationCustomer Installation customer      
ST25031 NVARCHAR VSTRING 4 0 4 InstallationCustCategory Installation customer category      
ST25032 NCHAR STRING 4 0 4 Site Site      
ST25033 NVARCHAR VSTRING 6 0 6 LineWH Line WH      
ST25034 NVARCHAR VSTRING 10 0 10 LineResource Line Resource      
ST25035 DATETIME DATE 0 0 8 LineStartDate Line start date      
ST25036 DATETIME DATE 0 0 8 LineEndDate Line end date      
ST25037 DATETIME DATE 0 0 8 LineInvoiceFromdate Line Invoice From date      
ST25038 NUMERIC X_NUMERIC 20 8 12 RequestedQtyOR Requested Qty Sales units      
ST25039 DATETIME DATE 0 0 8 RequestedDate Requested Date      
ST25040 NUMERIC X_NUMERIC 20 8 12 InvoicedQtySalesunits Invoiced Qty Sales units      
ST25041 NUMERIC X_NUMERIC 20 8 12 DeliveredQtySalesUnits Delivered Qty Sales Units      
ST25042 DATETIME DATE 0 0 8 DeliveryDate Delivery Date      
ST25043 NUMERIC X_NUMERIC 20 8 12 ReturnedQtySalesUnits Returned Qty Sales Units      
ST25044 DATETIME DATE 0 0 8 ReturnedDate Returned Date      
ST25045 NUMERIC X_NUMERIC 20 8 12 SoldQtySalesunits Sold Qty Sales units      
ST25046 DATETIME DATE 0 0 8 SaleDate Sale Date      
ST25047 NUMERIC X_NUMERIC 20 8 12 ScrappedQtyOR Scrapped Qty sales units      
ST25048 DATETIME DATE 0 0 8 ScrapDate Scrap Date      
ST25049 INT INTEGER 0 0 4 QtySalesUnitcode Qty Sales Unit code      
ST25050 INT INTEGER 0 0 1 PriceType Price Type      
ST25051 NCHAR STRING 2 0 2 PriceList Price List      
ST25052 NUMERIC MONEY 28 8 20 PricePerTimeUnitCCU Price per time unit (CCU)      
ST25053 INT INTEGER 0 0 2 TimeUnit Time Unit      
ST25054 NCHAR STRING 2 0 2 ContractCurrency Contract Currency      
ST25055 NCHAR STRING 2 0 2 InvoiceCurrency Invoice Currency      
ST25056 NUMERIC MONEY 28 8 20 NetLineAmntCapPartICU Net Line Amount / Capital part (ICU)      
ST25057 NUMERIC MONEY 28 8 20 NetLineAmntCapPartLCU Net Line Amount / Capital part (LCU)      
ST25058 NUMERIC MONEY 28 8 20 ChangeValueInterestICU Change Value / Interest part (ICU)      
ST25059 NUMERIC MONEY 28 8 20 ChangeValueInterestLCU Change Value / Interest part (LCU)      
ST25060 NUMERIC MONEY 28 8 20 TotalLineDiscICU Total line discount (ICU)      
ST25061 NUMERIC MONEY 28 8 20 TotalLineDiscLCU Total line discount (LCU)      
ST25062 NUMERIC MONEY 28 8 20 TotalLineCostLCU Total line cost (LCU)      
ST25063 NVARCHAR ACCSTR 120 0 120 AccString Accounting string      
ST25064 NCHAR SWITCH 1 0 1 IncludedFixPrice Included into fixed price      

Навигация / Navigation: