One level Up / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Статистика» / Statistics tables structure changes

Название Таблицы / Table Name Описание Таблицы / Table Description Поле / Field Расширенный комментарий / Extended Comment Тип данных / Data Type Длина поля iScala 3.5/ iScala 3.5 Length Точность iScala 3.5/ iScala 3.5 Precision Длина поля iScala 2.2/ iScala 2.2 Length Точность iScala 2.2/ iScala 2.2 Precision Новое поле? / is a New Field?
ST01 Salesmen ST01021 Accounting String NVARCHAR 120   50   —
ST01 Salesmen ST01024 District NVARCHAR 2   — — +
ST01 Salesmen ST01025 Advertising Code NVARCHAR 2   — — +
ST01 Salesmen ST01026 City Code NVARCHAR 4   — — +
ST01 Salesmen ST01027 SNI Code NVARCHAR 5   — — +
ST01 Salesmen ST01028 Product Group NVARCHAR 4   — — +
ST01 Salesmen ST01029 Alternative Product Group NVARCHAR 4   — — +
ST01 Salesmen ST01030 Discount Code NVARCHAR 2   — — +
ST01 Salesmen ST01031 Agent NVARCHAR 1   — — +
ST01 Salesmen ST01032 Email Address NVARCHAR 200   — — +
ST02 Order statistics ST02011 Accounting String NVARCHAR 120   50   —
ST02 Order statistics ST02064 Sales Return Reason Code INT 1   — — +
ST02 Order statistics ST02065 RMA Reference NCHAR 10   — — +
ST02 Order statistics ST02066 Commission Withheld Cost NUMERIC 20 8 — — +
ST02 Order statistics ST02067 Transaction Date DATETIME 8   — — +
ST03 Invoicing Statistics ST03011 Accounting String NVARCHAR 120   50   —
ST03 Invoicing Statistics ST03064 Sales Return Reason Code INT 1   — — +
ST03 Invoicing Statistics ST03065 RMA Reference NCHAR 10   — — +
ST03 Invoicing Statistics ST03066 Commission Withheld Cost NUMERIC 20 8 — — +
ST03 Invoicing Statistics ST03067 Transaction Date DATETIME 8   — — +
ST08 Purchase Statistics ST08005 Accounting String NVARCHAR 120   50   —
ST08 Purchase Statistics ST08024 Invoice Number NVARCHAR 25   15   —
ST08 Purchase Statistics ST08031 Rejected quantity NUMERIC 12 8 — — +
ST08 Purchase Statistics ST08032 Rejection Code NVARCHAR 4   — — +
ST08 Purchase Statistics ST08033 Original Requested Delivery Date DATETIME 8   — — +
ST08 Purchase Statistics ST08034 Invoice Supplier Code NCHAR 10   — — +
ST10 Bookings ST10017 Accounting String NVARCHAR 120   50   —
ST10 Bookings ST10021 Accounting Code 2 NVARCHAR 2   — — +
ST11 Selected Bookings ST11017 Accounting String NVARCHAR 120   50   —
ST11 Selected Bookings ST11021 Accounting Code 2 NVARCHAR 2   — — +
ST12 Yearly Booking File ST12017 Accounting String NVARCHAR 120   50   —
ST12 Yearly Booking File ST12021 Accounting Code 2 NVARCHAR 2   — — +
ST13 Service Statistics ST13046 Order Line Description NVARCHAR 35   25   —
ST13 Service Statistics ST13056 Accounting String NVARCHAR 120   50   —
ST13 Service Statistics ST13059 Discount NUMERIC 20 8 6   —
ST13 Service Statistics ST13065 Commission Witheld Cost NUMERIC 20 8 — — +
ST16 PO Header Lines Statistics ST16011 Accounting String NVARCHAR 120   50   —
ST16 PO Header Lines Statistics ST16017 Contract Number NVARCHAR 10   — — +
ST16 PO Header Lines Statistics ST16018 Contract Line Number NCHAR 6   — — +
ST16 PO Header Lines Statistics ST16019 Accounting code 2 NCHAR 2   — — +
ST16 PO Header Lines Statistics ST16020 Commodity code NVARCHAR 35   — — +
ST17 PO Ordering Statistics ST17018 Contract Number NVARCHAR 10   — — +
ST17 PO Ordering Statistics ST17019 Contract Line Number NCHAR 6   — — +
ST17 PO Ordering Statistics ST17020 Commodity code NVARCHAR 35   — — +
ST18 PO Confirmation Statistics ST18018 Contract Number NVARCHAR 10   — — +
ST18 PO Confirmation Statistics ST18019 Contract Line Number NCHAR 6   — — +
ST18 PO Confirmation Statistics ST18020 Commodity code NVARCHAR 35   — — +
ST19 PO Goods Receipt Statistics ST19022 Commodity code NVARCHAR 35   — — +
ST20 PO Invoice Statistics ST20017 Invoice Number NCHAR 25   15   —
ST20 PO Invoice Statistics ST20021 Commodity code NVARCHAR 35   — — +
ST24 Sales Contract Statistics ST24001 Contract Number NCHAR 10   — — +
ST24 Sales Contract Statistics ST24002 Contract Line Number NCHAR 6   — — +
ST24 Sales Contract Statistics ST24003 Delivery Schedule Line Number NCHAR 6   — — +
ST24 Sales Contract Statistics ST24004 Contract Customer NCHAR 10   — — +
ST24 Sales Contract Statistics ST24005 Transaction Type NCHAR 1   — — +
ST24 Sales Contract Statistics ST24006 Stock Code NVARCHAR 35   — — +
ST24 Sales Contract Statistics ST24007 Warehouse NCHAR 6   — — +
ST24 Sales Contract Statistics ST24008 Quantity NUMERIC 13 8 — — +
ST24 Sales Contract Statistics ST24009 Unit Price LCU NUMERIC 13 8 — — +
ST24 Sales Contract Statistics ST24010 Unit Price OCU NUMERIC 13 8 — — +
ST24 Sales Contract Statistics ST24011 Discount NUMERIC 13 8 — — +
ST24 Sales Contract Statistics ST24012 Currency Code NCHAR 2   — — +
ST24 Sales Contract Statistics ST24013 Line Amount LCU NUMERIC 13 8 — — +
ST24 Sales Contract Statistics ST24014 Line Amount OCU NUMERIC 13 8 — — +
ST24 Sales Contract Statistics ST24015 Sales Order Number NCHAR 10   — — +
ST24 Sales Contract Statistics ST24016 Sales Order Line Number NCHAR 6   — — +
ST24 Sales Contract Statistics ST24017 Sales Order Sub Line Number NCHAR 6   — — +
ST24 Sales Contract Statistics ST24018 Transaction Date DATETIME 8   — — +
ST24 Sales Contract Statistics ST24019 Accepted Date DATETIME 8   — — +
ST24 Sales Contract Statistics ST24020 Expiration Date DATETIME 8   — — +
ST24 Sales Contract Statistics ST24021 Last Used Date DATETIME 8   — — +
ST24 Sales Contract Statistics ST24022 Status NCHAR 1   — — +
ST24 Sales Contract Statistics ST24023 Search Index NCHAR 10   — — +
ST25 Lease Statistics ST25001 Counter NCHAR 12   — — +
ST25 Lease Statistics ST25002 Contract number NCHAR 10   — — +
ST25 Lease Statistics ST25003 Master contract number NCHAR 10   — — +
ST25 Lease Statistics ST25004 Invoice number NCHAR 15   — — +
ST25 Lease Statistics ST25005 Invoice date DATETIME 8   — — +
ST25 Lease Statistics ST25006 Invoice from date DATETIME 8   — — +
ST25 Lease Statistics ST25007 Invoice to date DATETIME 8   — — +
ST25 Lease Statistics ST25008 Contract term INT 1   — — +
ST25 Lease Statistics ST25009 Cancelation date DATETIME 8   — — +
ST25 Lease Statistics ST25010 Invoice customer NVARCHAR 10   — — +
ST25 Lease Statistics ST25011 Invoice customer category NVARCHAR 4   — — +
ST25 Lease Statistics ST25012 Invoice customer global ID NVARCHAR 25   — — +
ST25 Lease Statistics ST25013 Contract type NVARCHAR 3   — — +
ST25 Lease Statistics ST25014 Customer PO Number NVARCHAR 30   — — +
ST25 Lease Statistics ST25015 Salesman NVARCHAR 3   — — +
ST25 Lease Statistics ST25016 District NVARCHAR 2   — — +
ST25 Lease Statistics ST25017 Advertising code NVARCHAR 2   — — +
ST25 Lease Statistics ST25018 City code NVARCHAR 4   — — +
ST25 Lease Statistics ST25019 CNI code NVARCHAR 5   — — +
ST25 Lease Statistics ST25020 Manager NVARCHAR 6   — — +
ST25 Lease Statistics ST25021 Line type INT 2   — — +
ST25 Lease Statistics ST25022 Line number NCHAR 6   — — +
ST25 Lease Statistics ST25023 Subline number NCHAR 6   — — +
ST25 Lease Statistics ST25024 Substructure line number NCHAR 6   — — +
ST25 Lease Statistics ST25025 Line group code NVARCHAR 6   — — +
ST25 Lease Statistics ST25026 Master asset/Stock code NVARCHAR 35   — — +
ST25 Lease Statistics ST25027 Serial number NVARCHAR 20   — — +
ST25 Lease Statistics ST25028 Value component NVARCHAR 10   — — +
ST25 Lease Statistics ST25029 Lease Group/Product group NVARCHAR 6   — — +
ST25 Lease Statistics ST25030 Installation customer NVARCHAR 10   — — +
ST25 Lease Statistics ST25031 Installation customer category NVARCHAR 4   — — +
ST25 Lease Statistics ST25032 Site NCHAR 4   — — +
ST25 Lease Statistics ST25033 Line WH NVARCHAR 6   — — +
ST25 Lease Statistics ST25034 Line Resource NVARCHAR 10   — — +
ST25 Lease Statistics ST25035 Line start date DATETIME 8   — — +
ST25 Lease Statistics ST25036 Line end date DATETIME 8   — — +
ST25 Lease Statistics ST25037 Line Invoice From date DATETIME 8   — — +
ST25 Lease Statistics ST25038 Requested Qty Sales units NUMERIC 12 8 — — +
ST25 Lease Statistics ST25039 Requested Date DATETIME 8   — — +
ST25 Lease Statistics ST25040 Invoiced Qty Sales units NUMERIC 12 8 — — +
ST25 Lease Statistics ST25041 Delivered Qty Sales Units NUMERIC 12 8 — — +
ST25 Lease Statistics ST25042 Delivery Date DATETIME 8   — — +
ST25 Lease Statistics ST25043 Returned Qty Sales Units NUMERIC 12 8 — — +
ST25 Lease Statistics ST25044 Returned Date DATETIME 8   — — +
ST25 Lease Statistics ST25045 Sold Qty Sales units NUMERIC 12 8 — — +
ST25 Lease Statistics ST25046 Sale Date DATETIME 8   — — +
ST25 Lease Statistics ST25047 Scrapped Qty sales units NUMERIC 12 8 — — +
ST25 Lease Statistics ST25048 Scrap Date DATETIME 8   — — +
ST25 Lease Statistics ST25049 Qty Sales Unit code INT 4   — — +
ST25 Lease Statistics ST25050 Price Type INT 1   — — +
ST25 Lease Statistics ST25051 Price List NCHAR 2   — — +
ST25 Lease Statistics ST25052 Price per time unit (CCU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25053 Time Unit INT 2   — — +
ST25 Lease Statistics ST25054 Contract Currency NCHAR 2   — — +
ST25 Lease Statistics ST25055 Invoice Currency NCHAR 2   — — +
ST25 Lease Statistics ST25056 Net Line Amount / Capital part (ICU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25057 Net Line Amount / Capital part (LCU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25058 Change Value / Interest part (ICU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25059 Change Value / Interest part (LCU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25060 Total line discount (ICU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25061 Total line discount (LCU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25062 Total line cost (LCU) NUMERIC 20 8 — — +
ST25 Lease Statistics ST25063 Accounting string NVARCHAR 120   — — +
ST25 Lease Statistics ST25064 Included into fixed price NCHAR 1   — — +
ST30 Stock Item — Packaging Codes ST30001 Stock Code NVARCHAR 35   — — +
ST30 Stock Item — Packaging Codes ST30002 Material Code 1 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30003 Weight 1 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30004 Material Code 2 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30005 Weight 2 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30006 Material Code 3 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30007 Weight 3 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30008 Material Code 4 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30009 Weight 4 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30010 Material Code 5 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30011 Weight 5 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30012 Packaging Code NCHAR 15   — — +
ST30 Stock Item — Packaging Codes ST30013 Material Code 6 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30014 Weight 6 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30015 Material Code 7 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30016 Weight 7 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30017 Material Code 8 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30018 Weight 8 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30019 Material Code 9 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30020 Weight 9 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30021 Material Code 10 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30022 Weight 10 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30023 Material Code 11 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30024 Weight 11 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30025 Material Code 12 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30026 Weight 12 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30027 Material Code 13 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30028 Weight 13 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30029 Material Code 14 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30030 Weight 14 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30031 Material Code 15 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30032 Weight 15 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30033 Material Code 16 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30034 Weight 16 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30035 Material Code 17 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30036 Weight 17 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30037 Material Code 18 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30038 Weight 18 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30039 Material Code 19 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30040 Weight 19 NUMERIC 10 8 — — +
ST30 Stock Item — Packaging Codes ST30041 Material Code 20 NVARCHAR 5   — — +
ST30 Stock Item — Packaging Codes ST30042 Weight 20 NUMERIC 10 8 — — +
ST31 Temporary ST31001 Customer Code NCHAR 10   — — +
ST31 Temporary ST31002 Stock Code NCHAR 35   — — +
ST31 Temporary ST31003 Material Code NCHAR 5   — — +
ST31 Temporary ST31004 Weight NUMERIC 10 8 — — +
ST31 Temporary ST31005 Price LCU NUMERIC 20 8 — — +
ST31 Temporary ST31006 Order No NCHAR 10   — — +
ST31 Temporary ST31007 Qty NUMERIC 12 8 — — +
ST31 Temporary ST31008 Search Index NCHAR 8   — — +
ST40 Packaging Material Cost Statistics ST40001 Date DATETIME 8   — — +
ST40 Packaging Material Cost Statistics ST40002 Invoice Number NVARCHAR 15   — — +
ST40 Packaging Material Cost Statistics ST40003 Customer Code NVARCHAR 10   — — +
ST40 Packaging Material Cost Statistics ST40004 Stock Code NVARCHAR 35   — — +
ST40 Packaging Material Cost Statistics ST40005 Auto Counter INT 10   — — +
ST40 Packaging Material Cost Statistics ST40006 Material Code NVARCHAR 5   — — +
ST40 Packaging Material Cost Statistics ST40007 Weight (Sales Unit) NUMERIC 10 8 — — +
ST40 Packaging Material Cost Statistics ST40008 Cost (LCU) NUMERIC 20 8 — — +
ST40 Packaging Material Cost Statistics ST40009 Units NUMERIC 12 8 — — +
STCS Salesman Commission Setup STCS001 Record Type NVARCHAR 2   — — +
STCS Salesman Commission Setup STCS002 Salesman code NVARCHAR 3   — — +
STCS Salesman Commission Setup STCS003 Customer Ext. Comm. Code NVARCHAR 2   — — +
STCS Salesman Commission Setup STCS004 Line Ext. Comm. Code NVARCHAR 2   — — +
STCS Salesman Commission Setup STCS005 Boundary NUMERIC 20 8 — — +
STCS Salesman Commission Setup STCS006 Commission NUMERIC 20 8 — — +
STST Generic Salesman Group STST001 Object Type NVARCHAR 2   — — +
STST Generic Salesman Group STST002 Object Reference NVARCHAR 50   — — +
STST Generic Salesman Group STST003 Salesman Code NVARCHAR 3   — — +
STST Generic Salesman Group STST004 Salesman Range INT 4   — — +
STST Generic Salesman Group STST005 Distribution % NUMERIC 20 8 — — +
STST Generic Salesman Group STST006 Commission % NUMERIC 20 8 — — +
STST Generic Salesman Group STST007 Commission Amount NUMERIC 20 8 — — +