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

Изменения структуры таблиц модуля «Управление Запасами» / Stock Control 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?
SC01 Stock Item File SC01031 Discount Code INT 3   2   —
SC01 Stock Item File SC01039 Accounting String NVARCHAR 120   50   —
SC01 Stock Item File SC01133 Unit Code Stock INT 4   2   —
SC01 Stock Item File SC01134 Unit Code Purchase INT 4   2   —
SC01 Stock Item File SC01135 Unit Code Sales INT 4   2   —
SC01 Stock Item File SC01136 Unit Code MPC INT 4   2   —
SC01 Stock Item File SC01137 Unit Code Other INT 4   2   —
SC01 Stock Item File SC01160 Extended User defined 1 NVARCHAR 150   — — +
SC01 Stock Item File SC01161 Extended User defined 2 NVARCHAR 150   — — +
SC01 Stock Item File SC01162 Extended User defined 3 NVARCHAR 150   — — +
SC01 Stock Item File SC01163 Extended User defined 4 NVARCHAR 150   — — +
SC01 Stock Item File SC01164 Extended User defined 5 NVARCHAR 150   — — +
SC01 Stock Item File SC01165 Extended User defined 6 NVARCHAR 150   — — +
SC01 Stock Item File SC01166 Extended User defined 7 NVARCHAR 150   — — +
SC01 Stock Item File SC01167 Extended User defined 8 NVARCHAR 150   — — +
SC01 Stock Item File SC01168 Extended User defined 9 NVARCHAR 150   — — +
SC01 Stock Item File SC01169 Extended User defined 10 NVARCHAR 150   — — +
SC01 Stock Item File SC01170 Extended User defined 11 NVARCHAR 150   — — +
SC01 Stock Item File SC01171 Extended User defined 12 NVARCHAR 150   — — +
SC01 Stock Item File SC01172 Extended User defined 13 NVARCHAR 150   — — +
SC01 Stock Item File SC01173 Extended User defined 14 NVARCHAR 150   — — +
SC01 Stock Item File SC01174 Extended User defined 15 NVARCHAR 150   — — +
SC01 Stock Item File SC01175 Extended User defined 16 NVARCHAR 150   — — +
SC01 Stock Item File SC01176 Extended User defined 17 NVARCHAR 150   — — +
SC01 Stock Item File SC01177 Extended User defined 18 NVARCHAR 150   — — +
SC01 Stock Item File SC01178 Extended User defined 19 NVARCHAR 150   — — +
SC01 Stock Item File SC01179 Extended User defined 20 NVARCHAR 150   — — +
SC01 Stock Item File SC01227 BOM default UOM code INT 4   2   —
SC01 Stock Item File SC01230 NCM Sub Code NVARCHAR 25   10   —
SC01 Stock Item File SC01232 Nomenclature Number NVARCHAR 25   10   —
SC01 Stock Item File SC01237 LTM Group — OR NCHAR 6   — — +
SC01 Stock Item File SC01238 LTM Group — PC NCHAR 6   — — +
SC01 Stock Item File SC01239 BOM Cost NUMERIC 20 8 — — +
SC01 Stock Item File SC01240 GTIN Code NVARCHAR 35   — — +
SC01 Stock Item File SC01241 Barcode identities NVARCHAR 150   — — +
SC01 Stock Item File SC01242 DTF INT 3   — — +
SC01 Stock Item File SC01243 Incoming Properties Control NCHAR 1   — — +
SC01 Stock Item File SC01244 Temperature required flag INT 1   — — +
SC01 Stock Item File SC01245 Humidity required flag INT 1   — — +
SC01 Stock Item File SC01246 Temperature enforce flag INT 1   — — +
SC01 Stock Item File SC01247 Humidity enforce flag INT 1   — — +
SC01 Stock Item File SC01248 Temperature unit code INT 2   — — +
SC01 Stock Item File SC01249 Extended Commission Code NCHAR 2   — — +
SC01 Stock Item File SC01250 Export Status INT 1   — — +
SC01 Stock Item File SC01251 Charge Cost for Packaging Materials NCHAR 1   — — +
SC01 Stock Item File SC01252 Fixed charge per weight NCHAR 1   — — +
SC01 Stock Item File SC01253 Packaging Tax Amount per kg NUMERIC 20 8 — — +
SC01 Stock Item File SC01254 Commodity Code NVARCHAR 35   — — +
SC01 Stock Item File SC01255 Created By NVARCHAR 8   — — +
SC01 Stock Item File SC01256 Purchase Tax Code ATE NCHAR 6   — — +
SC01 Stock Item File SC01257 Product Tax Type NVARCHAR 10   — — +
SC01 Stock Item File SC01258 REACH UUID NVARCHAR 45   — — +
SC01 Stock Item File SC01259 REACH Weight NUMERIC 10 8 — — +
SC01 Stock Item File SC01260 REACH Weight Unit INT 4   — — +
SC01 Stock Item File SC01261 REACH From Date DATETIME 8   — — +
SC01 Stock Item File SC01262 REACH To Date DATETIME 8   — — +
SC01 Stock Item File SC01263 Asset Purchase INT 1   — — +
SC01 Stock Item File SC01264 Asset Account NVARCHAR 12   — — +
SC01 Stock Item File SC01265 Asset Per Unit INT 1   — — +
SC01 Stock Item File SC01266 Reason Code for Non-Standard Taxation NCHAR 3   — — +
SC01 Stock Item File SC01267 Deactivated NCHAR 1   — — +
SC03 Warehouse File SC03120 BOM Cost NUMERIC 20 8 — — +
SC05 Serial Numbers SC05023 Contract Line Number NCHAR 6   4   —
SC05 Serial Numbers SC05055 Blocked for Transfer NCHAR 1   — — +
SC05 Serial Numbers SC05056 Default Engineer NVARCHAR 10   — — +
SC05 Serial Numbers SC05057 Category NCHAR 6   — — +
SC07 Stock Transactions SC07012 Accounting String NVARCHAR 120   50   —
SC07 Stock Transactions SC07020 General Ledger Transaction Number NCHAR 9   6   —
SC07 Stock Transactions SC07054 Picking list number NVARCHAR 10   — — +
SC07 Stock Transactions SC07055 Note NVARCHAR 64   — — +
SC07 Stock Transactions SC07056 InvoiceNo NVARCHAR 25   — — +
SC07 Stock Transactions SC07057 Issuer/Receiver Type NVARCHAR 1   — — +
SC07 Stock Transactions SC07058 Issuer/Receiver Code (Supplier or Customer Code) NVARCHAR 10   — — +
SC07 Stock Transactions SC07059 WO Received Batch Number NVARCHAR 12   — — +
SC07 Stock Transactions SC07060 Italy Codes NVARCHAR 11   — — +
SC07 Stock Transactions SC07061 Reason Code/Dispatch Note NVARCHAR 21   — — +
SC07 Stock Transactions SC07062 Delivery Method NCHAR 2   — — +
SC07 Stock Transactions SC07063 Accounting Code 2 NCHAR 2   — — +
SC07 Stock Transactions SC07064 DN Issuer Code NCHAR 6   — — +
SC07 Stock Transactions SC07065 Work Order Material Report Number NCHAR 10   — — +
SC07 Stock Transactions SC07066 Work Order Material Number NCHAR 4   — — +
SC07 Stock Transactions SC07067 Work Order Material Issue Line Number NCHAR 4   — — +
SC07 Stock Transactions SC07068 Red Storno NCHAR 1   — — +
SC07 Stock Transactions SC07069 Search Index from Original Transaction NCHAR 8   — — +
SC07 Stock Transactions SC07070 Document Date DATETIME 8   — — +
SC10 Stock Parameters 1 SC10114 Delay Lock Unit Printing NCHAR 1   — — +
SC10 Stock Parameters 1 SC10115 Stock Transfer Order Number INT 4   — — +
SC10 Stock Parameters 1 SC10116 Stock Transfer Order Delivery Lines Number Interval INT 4   — — +
SC10 Stock Parameters 1 SC10117 Lead Time for Picking INT 4   — — +
SC10 Stock Parameters 1 SC10118 Lead Time for Shipping INT 4   — — +
SC10 Stock Parameters 1 SC10119 One Delivery Note for Picking List NCHAR 1   — — +
SC10 Stock Parameters 1 SC10120 Item/Supplier ID Default from Item NCHAR 1   — — +
SC10 Stock Parameters 1 SC10121 Item/Customer ID Default from Item NCHAR 1   — — +
SC10 Stock Parameters 1 SC10122 Default Nomenclature Number for Intangibles NVARCHAR 25   — — +
SC10 Stock Parameters 1 SC10123 Default Rejection Code NVARCHAR 4   — — +
SC10 Stock Parameters 1 SC10124 Use Scrapped Serial Numbers Flag NCHAR 1   — — +
SC10 Stock Parameters 1 SC10125 Enforce Item/Batch Rule Flag INT 1   — — +
SC10 Stock Parameters 1 SC10126 Default Stock Item Export Status INT 1   — — +
SC10 Stock Parameters 1 SC10127 Number of Classification Levels INT 1   — — +
SC10 Stock Parameters 1 SC10128 Keep Unused Boxes Flag NCHAR 1   — — +
SC10 Stock Parameters 1 SC10129 Include Stock Transfer Transaction into Consumption Calculation NCHAR 1   — — +
SC10 Stock Parameters 1 SC10130 Separate Class Calculation per Warehouse NCHAR 1   — — +
SC10 Stock Parameters 1 SC10131 BE Date in GL Journal INT 1   — — +
SC10 Stock Parameters 1 SC10132 Long Description Language NVARCHAR 3   — — +
SC10 Stock Parameters 1 SC10133 Date on Stock Transaction type 05 INT 1   — — +
SC11 Stock Planning SC11021 Confirmed Delivery Date DATETIME 8   — — +
SC11 Stock Planning SC11022 Reservation End Date DATETIME 8   — — +
SC11 Stock Planning SC11023 Firmed order NCHAR 1   — — +
SC11 Stock Planning SC11024 ATP period shift days INT 1   — — +
SC16 Serial Number History SC16027 Source Warehouse NVARCHAR 6   — — +
SC16 Serial Number History SC16028 Target Warehouse NVARCHAR 6   — — +
SC16 Serial Number History SC16029 External ID NVARCHAR 36   — — +
SC23 Warehouse Addresses SC23010 Accounting String NVARCHAR 120   50   —
SC23 Warehouse Addresses SC23063 Delivery Note Issuer NCHAR 6   4   —
SC23 Warehouse Addresses SC23066 Use Common picking NCHAR 1   — — +
SC23 Warehouse Addresses SC23067 Allocate from picking list NCHAR 1   — — +
SC23 Warehouse Addresses SC23068 Use Release for picking NCHAR 1   — — +
SC23 Warehouse Addresses SC23069 Use merged picking lists NCHAR 1   — — +
SC23 Warehouse Addresses SC23070 Merge different destination NCHAR 1   — — +
SC23 Warehouse Addresses SC23071 Merge different planned picking dates NCHAR 1   — — +
SC23 Warehouse Addresses SC23072 Sort option NCHAR 1   — — +
SC23 Warehouse Addresses SC23073 Direct creation of picking request INT 3   — — +
SC23 Warehouse Addresses SC23074 Print after creation NCHAR 1   — — +
SC23 Warehouse Addresses SC23075 No of copies, picking list INT 2   — — +
SC23 Warehouse Addresses SC23076 No of copies, Delivery note INT 2   — — +
SC23 Warehouse Addresses SC23077 ATP include Customer Reservations NCHAR 1   — — +
SC23 Warehouse Addresses SC23078 ATP include Contract Reservations NCHAR 1   — — +
SC23 Warehouse Addresses SC23079 ATP include Stock Transfer Order Receipts NCHAR 1   — — +
SC23 Warehouse Addresses SC23080 ATP include Stock Transfer Order Issues NCHAR 1   — — +
SC23 Warehouse Addresses SC23081 CountryCode NVARCHAR 3   — — +
SC23 Warehouse Addresses SC23082 Create stock accounting, Depot NVARCHAR 1   — — +
SC23 Warehouse Addresses SC23083 Standard Cost Pooling INT 1   — — +
SC23 Warehouse Addresses SC23084 Allow negative balance in MPC module NCHAR 1   — — +
SC23 Warehouse Addresses SC23085 Primary Warehouse NVARCHAR 6   — — +
SC23 Warehouse Addresses SC23086 Address Line 5 NVARCHAR 35   — — +
SC23 Warehouse Addresses SC23087 Address Line 6 NVARCHAR 35   — — +
SC23 Warehouse Addresses SC23088 MPC, Create Delivery note event NCHAR 1   — — +
SC23 Warehouse Addresses SC23089 Address Line 7 NVARCHAR 35   — — +
SC23 Warehouse Addresses SC23090 Average Cost Group Code NVARCHAR 6   — — +
SC23 Warehouse Addresses SC23091 Landed Cost Pooling INT 1   — — +
SC23 Warehouse Addresses SC23092 Landed Cost Primary Warehouse NVARCHAR 6   — — +
SC23 Warehouse Addresses SC23093 Blocked INT 1   — — +
SC24 Automatic Accounting Table SC SC24006 Accounting code 1 NCHAR 2   — — +
SC24 Automatic Accounting Table SC SC24007 Accounting code 2 NCHAR 2   — — +
SC24 Automatic Accounting Table SC SC24008 Extra code NCHAR 2   — — +
SC25 GL Transactions SC25001 Record Counter NUMERIC 9   8   —
SC25 GL Transactions SC25002 Transaction Number NCHAR 9   6   —
SC25 GL Transactions SC25003 Line Number NCHAR 7   5   —
SC25 GL Transactions SC25006 Accounting String NVARCHAR 120   50   —
SC25 GL Transactions SC25009 Accounting String Line Currency NVARCHAR 120   50   —
SC25 GL Transactions SC25011 Transaction Line Text NVARCHAR 100   25   —
SC25 GL Transactions SC25013 Batch ID NVARCHAR 25   23   —
SC25 GL Transactions SC25024 In Closing Period NCHAR 8   5   —
SC25 GL Transactions SC25026 Unit Code INT 4   2   —
SC25 GL Transactions SC25030 PL Reference NCHAR 9   6   —
SC25 GL Transactions SC25037 Transaction Text Line Currency NVARCHAR 100   25   —
SC25 GL Transactions SC25038 Printed By NCHAR 8   — — +
SC25 GL Transactions SC25039 Date Printed DATETIME 8   — — +
SC25 GL Transactions SC25040 AAS code NVARCHAR 25   — — +
SC25 GL Transactions SC25041 BE-Date DATETIME 8   — — +
SC25 GL Transactions SC25042 Order Number NVARCHAR 10   — — +
SC25 GL Transactions SC25043 Cost Type NCHAR 2   — — +
SC25 GL Transactions SC25044 Transcation Souce NCHAR 1   — — +
SC27 EC Trade Statistics SC27010 Delivery Customer Code NCHAR 10   — — +
SC27 EC Trade Statistics SC27011 Harbour NVARCHAR 4   — — +
SC27 EC Trade Statistics SC27012 Bundesland NVARCHAR 2   — — +
SC27 EC Trade Statistics SC27013 StatManner NVARCHAR 6   — — +
SC27 EC Trade Statistics SC27014 CurrIdentNumber NVARCHAR 2   — — +
SC27 EC Trade Statistics SC27015 ECDepartment NVARCHAR 2   — — +
SC27 EC Trade Statistics SC27016 Regime NVARCHAR 2   — — +
SC27 EC Trade Statistics SC27017 Freight Cost NUMERIC 20 8 — — +
SC27 EC Trade Statistics SC27018 Place Of Delivery NVARCHAR 100   — — +
SC27 EC Trade Statistics SC27019 Incoterm Regulation NVARCHAR 50   — — +
SC28 EC Tax Rep. wrk SC28013 Volume NUMERIC 10 8 — — +
SC2A Work File for EC Tax Reports Definition SC2A012 Order/Invoice Number NCHAR 25   — — +
SC33 Batch Information SC33051 Customs Dispatch Number NVARCHAR 30   — — +
SC33 Batch Information SC33052 Date Imported DATETIME 8   — — +
SC33 Batch Information SC33053 Country of Origin NCHAR 3   — — +
SC33 Batch Information SC33054 Customs Office Code NCHAR 10   — — +
SC33 Batch Information SC33055 Destination Code NCHAR 4   — — +
SC37 Standard Stock Items SC37031 Discount Code INT 3   2   —
SC37 Standard Stock Items SC37039 Accounting String NVARCHAR 120   50   —
SC37 Standard Stock Items SC37133 Unit Code Stock INT 4   2   —
SC37 Standard Stock Items SC37134 Unit Code Purchase INT 4   2   —
SC37 Standard Stock Items SC37135 Unit Code Sales INT 4   2   —
SC37 Standard Stock Items SC37136 Unit Code MPC INT 4   2   —
SC37 Standard Stock Items SC37137 Unit Code Other INT 4   2   —
SC37 Standard Stock Items SC37160 Ext. User defined field 1 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37161 Ext. User defined field 2 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37162 Ext. User defined field 3 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37163 Ext. User defined field 4 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37164 Ext. User defined field 5 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37165 Ext. User defined field 6 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37166 Ext. User defined field 7 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37167 Ext. User defined field 8 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37168 Ext. User defined field 9 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37169 Ext. User defined field 10 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37170 Ext. User defined field 11 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37171 Ext. User defined field 12 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37172 Ext. User defined field 13 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37173 Ext. User defined field 14 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37174 Ext. User defined field 15 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37175 Ext. User defined field 16 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37176 Ext. User defined field 17 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37177 Ext. User defined field 18 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37178 Ext. User defined field 19 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37179 Ext. User defined field 20 NVARCHAR 150   — — +
SC37 Standard Stock Items SC37227 BOM default UOM code INT 4   2   —
SC37 Standard Stock Items SC37230 Tariff Number NVARCHAR 25   10   —
SC37 Standard Stock Items SC37232 Nomenclature No NVARCHAR 25   10   —
SC37 Standard Stock Items SC37237 LTM Group OR NCHAR 6   — — +
SC37 Standard Stock Items SC37238 LTM Group PC NCHAR 6   — — +
SC37 Standard Stock Items SC37239 BOM Cost NUMERIC 20 8 — — +
SC37 Standard Stock Items SC37240 GTIN NVARCHAR 35   — — +
SC37 Standard Stock Items SC37241 Udef Barcode identities NVARCHAR 150   — — +
SC37 Standard Stock Items SC37242 Demand Time Fence INT 3   — — +
SC37 Standard Stock Items SC37243 Incoming Properties Control NCHAR 1   — — +
SC37 Standard Stock Items SC37244 Temperature required flag INT 1   — — +
SC37 Standard Stock Items SC37245 Humidity required flag INT 1   — — +
SC37 Standard Stock Items SC37246 Temperature enforce flag INT 1   — — +
SC37 Standard Stock Items SC37247 Humidity enforce flag INT 1   — — +
SC37 Standard Stock Items SC37248 Temperature unit code INT 2   — — +
SC37 Standard Stock Items SC37249 Extended Commission Code NCHAR 2   — — +
SC37 Standard Stock Items SC37250 Export Status INT 1   — — +
SC37 Standard Stock Items SC37251 Charge Cost per Packaging Materials? NCHAR 1   — — +
SC37 Standard Stock Items SC37252 Fixed charge per weight? NCHAR 1   — — +
SC37 Standard Stock Items SC37253 Packaging Tax Amount per kg NUMERIC 20 8 — — +
SC37 Standard Stock Items SC37254 Commodity Code NVARCHAR 35   — — +
SC37 Standard Stock Items SC37255 Created By NVARCHAR 8   — — +
SC37 Standard Stock Items SC37256 Purchase Tax Code ATE NCHAR 6   — — +
SC37 Standard Stock Items SC37257 Product Tax Type NVARCHAR 10   — — +
SC37 Standard Stock Items SC37258 REACH UUID NVARCHAR 45   — — +
SC37 Standard Stock Items SC37259 REACH Weight NUMERIC 10 8 — — +
SC37 Standard Stock Items SC37260 REACH Weight Unit INT 4   — — +
SC37 Standard Stock Items SC37261 REACH From Date DATETIME 8   — — +
SC37 Standard Stock Items SC37262 REACH To Date DATETIME 8   — — +
SC37 Standard Stock Items SC37263 Asset Purchase INT 1   — — +
SC37 Standard Stock Items SC37264 Asset Account NVARCHAR 12   — — +
SC37 Standard Stock Items SC37265 Asset Per Unit INT 1   — — +
SC37 Standard Stock Items SC37266 Tax Reason Code NCHAR 3   — — +
SC37 Standard Stock Items SC37267 Deactivated NCHAR 1   — — +
SC38 Standard Item Discounts SC38001 Stock Code NVARCHAR 35   1   —
SC38 Standard Item Discounts SC38002 Discount Level 1, Quantity NUMERIC 12 8 45   —
SC38 Standard Item Discounts SC38003 Discount Level 1, Discount NUMERIC 6 8 35   —
SC38 Standard Item Discounts SC38004 Discount Level 1, Price NUMERIC 20 8 25   —
SC38 Standard Item Discounts SC38005 Discount Level 2, Quantity NUMERIC 12 8 25   —
SC38 Standard Item Discounts SC38006 Discount Level 2, Discount NUMERIC 6 8 20   —
SC38 Standard Item Discounts SC38007 Discount Level 2, Price NUMERIC 20 8 2   —
SC38 Standard Item Discounts SC38008 Discount Level 3, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38010 Discount Level 3, Price NUMERIC 20 8 8   —
SC38 Standard Item Discounts SC38011 Discount Level 4, Quantity NUMERIC 12 8 8   —
SC38 Standard Item Discounts SC38012 Discount Level 4, Discount NUMERIC 6 8 12   —
SC38 Standard Item Discounts SC38013 Discount Level 4, Price NUMERIC 20 8 3   —
SC38 Standard Item Discounts SC38015 Discount Level 5, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38016 Discount Level 5, Price NUMERIC 20 8 6 8 —
SC38 Standard Item Discounts SC38017 Discount Level 6, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38018 Discount Level 6, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38019 Discount Level 6, Price NUMERIC 20 8 6 8 —
SC38 Standard Item Discounts SC38020 Discount Level 7, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38021 Discount Level 7, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38022 Discount Level 7, Price NUMERIC 20 8 6 8 —
SC38 Standard Item Discounts SC38023 Discount Level 8, Quantity NUMERIC 12 8 20 8 —
SC38 Standard Item Discounts SC38024 Discount Level 8, Discount NUMERIC 6 8 12 8 —
SC38 Standard Item Discounts SC38025 Discount Level 8, Price NUMERIC 20 8 6 8 —
SC45 Customer Discounts SC45002 Stock Group NCHAR 3   2   —
SC45 Customer Discounts SC45003 Customer Discount Code NCHAR 3   2   —
SC52 Discount Accounting SC52009 Account NVARCHAR 120   50   —
SC63 BoxLine SC63019 Customer Purchase Order Number NVARCHAR 30   20   —
SC69 Counting Proposal Header SC69007 Stock Transaction ID NCHAR 8   — — +
SC72 Counting Proposal Header History SC72007 Stock Transaction ID NCHAR 8   — — +
SC7C Stock Transfer Order Header SC7C001 Order Number NCHAR 10   — — +
SC7C Stock Transfer Order Header SC7C002 Order Date DATETIME 8   — — +
SC7C Stock Transfer Order Header SC7C003 Reference Number NVARCHAR 35   — — +
SC7C Stock Transfer Order Header SC7C004 Source Warehouse ID NVARCHAR 6   — — +
SC7C Stock Transfer Order Header SC7C005 Goods-In-Transit Warehouse ID NVARCHAR 6   — — +
SC7C Stock Transfer Order Header SC7C006 Destination Warehouse ID NVARCHAR 6   — — +
SC7C Stock Transfer Order Header SC7C007 Planned Shipping Date DATETIME 8   — — +
SC7C Stock Transfer Order Header SC7C008 Actual Shipping Date DATETIME 8   — — +
SC7C Stock Transfer Order Header SC7C009 Expected Delivery Date DATETIME 8   — — +
SC7C Stock Transfer Order Header SC7C010 OrderStatus NCHAR 1   — — +
SC7C Stock Transfer Order Header SC7C011 Last printed date-time DATETIME 17   — — +
SC7C Stock Transfer Order Header SC7C012 Printed by NVARCHAR 6   — — +
SC7D Stock Transfer Order Lines SC7D001 Order Number NCHAR 10   — — +
SC7D Stock Transfer Order Lines SC7D002 Order Line Number NCHAR 6   — — +
SC7D Stock Transfer Order Lines SC7D003 Stock Code NVARCHAR 35   — — +
SC7D Stock Transfer Order Lines SC7D004 Ordered Qty NUMERIC 12 8 — — +
SC7D Stock Transfer Order Lines SC7D005 Confirmed Qty NUMERIC 12 8 — — +
SC7D Stock Transfer Order Lines SC7D006 Shipped Qty NUMERIC 12 8 — — +
SC7D Stock Transfer Order Lines SC7D007 Delivered Qty NUMERIC 12 8 — — +
SC7D Stock Transfer Order Lines SC7D008 UoM Code NCHAR 4   — — +
SC7D Stock Transfer Order Lines SC7D009 Release Status INT 1   — — +
SC7D Stock Transfer Order Lines SC7D010 Picking List Number NCHAR 10   — — +
SC7D Stock Transfer Order Lines SC7D011 GRN Number NCHAR 10   — — +
SC7D Stock Transfer Order Lines SC7D012 DN Number NCHAR 10   — — +
SC7E Stock Transfer Order Delivery Lines SC7E001 Order Number NCHAR 10   — — +
SC7E Stock Transfer Order Delivery Lines SC7E002 Order Line Number NCHAR 6   — — +
SC7E Stock Transfer Order Delivery Lines SC7E003 Deliv Line Number NCHAR 6   — — +
SC7E Stock Transfer Order Delivery Lines SC7E004 Source Batch ID NCHAR 12   — — +
SC7E Stock Transfer Order Delivery Lines SC7E005 GIT Batch ID NCHAR 12   — — +
SC7E Stock Transfer Order Delivery Lines SC7E006 Dest Batch ID NCHAR 12   — — +
SC7E Stock Transfer Order Delivery Lines SC7E007 Shipped Qty NUMERIC 12 8 — — +
SC7E Stock Transfer Order Delivery Lines SC7E008 Ship Date DATETIME 8   — — +
SC7E Stock Transfer Order Delivery Lines SC7E009 Delivery Note Number NCHAR 10   — — +
SC7E Stock Transfer Order Delivery Lines SC7E010 Delivered Qty NUMERIC 12 8 — — +
SC7E Stock Transfer Order Delivery Lines SC7E011 Delivery Date DATETIME 8   — — +
SC7E Stock Transfer Order Delivery Lines SC7E012 Receipt Note Number NCHAR 10   — — +
SC7E Stock Transfer Order Delivery Lines SC7E013 PickedQty NUMERIC 12 8 — — +
SC7E Stock Transfer Order Delivery Lines SC7E014 PickConfDate DATETIME 8   — — +
SC7E Stock Transfer Order Delivery Lines SC7E015 PickListNumber NCHAR 10   — — +
SC7E Stock Transfer Order Delivery Lines SC7E016 Destination Bin NCHAR 6   — — +
SC7F STO — linked work orders and purchase orders SC7F001 Order number NCHAR 10   — — +
SC7F STO — linked work orders and purchase orders SC7F002 Order Line Number NCHAR 6   — — +
SC7F STO — linked work orders and purchase orders SC7F003 Line NCHAR 4   — — +
SC7F STO — linked work orders and purchase orders SC7F004 Work order NCHAR 10   — — +
SC7F STO — linked work orders and purchase orders SC7F005 Purchase order NCHAR 10   — — +
SC7G Stock transfer order serial number file SC7G001 Order Number NCHAR 10   — — +
SC7G Stock transfer order serial number file SC7G002 Order Line Number NCHAR 6   — — +
SC7G Stock transfer order serial number file SC7G003 Delivery Line Number NCHAR 6   — — +
SC7G Stock transfer order serial number file SC7G004 Serial Number NVARCHAR 20   — — +
SC7G Stock transfer order serial number file SC7G005 Remark NVARCHAR 30   — — +
SC7G Stock transfer order serial number file SC7G006 Certificate NVARCHAR 20   — — +
SC7G Stock transfer order serial number file SC7G007 Version NCHAR 6   — — +
SC7G Stock transfer order serial number file SC7G008 Release NCHAR 6   — — +
SC7G Stock transfer order serial number file SC7G009 SN updated NCHAR 1   — — +
SC80 Picking list head SC80001 Warehouse NCHAR 6   — — +
SC80 Picking list head SC80002 Picking list Id NCHAR 10   — — +
SC80 Picking list head SC80003 Creation date – time DATETIME 17   — — +
SC80 Picking list head SC80004 Created by NVARCHAR 8   — — +
SC80 Picking list head SC80005 Earliest picking date – time DATETIME 17   — — +
SC80 Picking list head SC80006 Latest picking date – time DATETIME 17   — — +
SC80 Picking list head SC80007 Planned shipment date – time DATETIME 17   — — +
SC80 Picking list head SC80008 Last printed date – time DATETIME 17   — — +
SC80 Picking list head SC80009 Printed by NVARCHAR 8   — — +
SC80 Picking list head SC80010 Status INT 1   — — +
SC80 Picking list head SC80011 Status date DATETIME 17   — — +
SC80 Picking list head SC80012 Request type NCHAR 1   — — +
SC80 Picking list head SC80013 Request Number NVARCHAR 10   — — +
SC80 Picking list head SC80014 Pick type INT 1   — — +
SC80 Picking list head SC80015 Destination type NCHAR 1   — — +
SC80 Picking list head SC80016 Destination Reference 1 NVARCHAR 10   — — +
SC80 Picking list head SC80017 Destination Reference 2 NVARCHAR 10   — — +
SC80 Picking list head SC80018 Destination Reference 3 NVARCHAR 10   — — +
SC80 Picking list head SC80019 Picking list value NUMERIC 20 8 — — +
SC80 Picking list head SC80020 Net weight NUMERIC 10 8 — — +
SC80 Picking list head SC80021 Gross weight NUMERIC 10 8 — — +
SC80 Picking list head SC80022 Volume NUMERIC 10 8 — — +
SC80 Picking list head SC80023 No of items NUMERIC 10 8 — — +
SC80 Picking list head SC80024 Merged picking list id NVARCHAR 10   — — +
SC80 Picking list head SC80025 Line sort definition INT 1   — — +
SC80 Picking list head SC80026 Group number NUMERIC 10 8 — — +
SC80 Picking list head SC80027 Status changed by NVARCHAR 8   — — +
SC80 Picking list head SC80028 Status before OnHold INT 1   — — +
SC80 Picking list head SC80029 Company Code NVARCHAR 2   — — +
SC80 Picking list head SC80030 Language code Picking list NCHAR 3   — — +
SC80 Picking list head SC80031 Language code Delivery note NCHAR 3   — — +
SC80 Picking list head SC80032 Shipment date from LTM or latest pick date if LTM not used. DATETIME 17   — — +
SC80 Picking list head SC80033 Pick List Group and Number inside the Group NVARCHAR 64   — — +
SC81 Picking list line SC81001 Warehouse NCHAR 6   — — +
SC81 Picking list line SC81002 Picking list Id NCHAR 10   — — +
SC81 Picking list line SC81003 Picking list line NCHAR 6   — — +
SC81 Picking list line SC81004 Request type NCHAR 1   — — +
SC81 Picking list line SC81005 Request Reference 1 NVARCHAR 10   — — +
SC81 Picking list line SC81006 Request Reference 2 NVARCHAR 10   — — +
SC81 Picking list line SC81007 Request Reference 3 NVARCHAR 6   — — +
SC81 Picking list line SC81008 Destination type NCHAR 1   — — +
SC81 Picking list line SC81009 Destination Reference 1 NVARCHAR 10   — — +
SC81 Picking list line SC81010 Destination Reference 2 NVARCHAR 10   — — +
SC81 Picking list line SC81011 Destination Reference 3 NVARCHAR 10   — — +
SC81 Picking list line SC81012 Handling instructions NVARCHAR 50   — — +
SC81 Picking list line SC81013 Packing instructions NVARCHAR 50   — — +
SC81 Picking list line SC81014 Stock code NVARCHAR 35   — — +
SC81 Picking list line SC81015 Unit code INT 4   — — +
SC81 Picking list line SC81016 Conversion factor NUMERIC 12 8 — — +
SC81 Picking list line SC81017 Requested quantity (requested unit) NUMERIC 12 8 — — +
SC81 Picking list line SC81018 Requested quantity (stock unit) NUMERIC 12 8 — — +
SC81 Picking list line SC81019 Quantity to pick (requested unit) NUMERIC 12 8 — — +
SC81 Picking list line SC81020 Quantity to pick (stock unit) NUMERIC 12 8 — — +
SC81 Picking list line SC81021 Comment NVARCHAR 50   — — +
SC81 Picking list line SC81022 Default Bin NVARCHAR 6   — — +
SC81 Picking list line SC81023 Sort field NVARCHAR 100   — — +
SC81 Picking list line SC81024 Pick type INT 1   — — +
SC81 Picking list line SC81025 Description 1 NVARCHAR 25   — — +
SC81 Picking list line SC81026 Description 2 NVARCHAR 25   — — +
SC81 Picking list line SC81027 Closed NCHAR 1   — — +
SC81 Picking list line SC81028 Company Code NVARCHAR 2   — — +
SC81 Picking list line SC81029 CWH Picking list Id NVARCHAR 10   — — +
SC81 Picking list line SC81030 Shipment date from LTM or earliest pick date if LTM not used DATETIME 17   — — +
SC81 Picking list line SC81031 Shipment date from LTM or latest pick date if LTM not used DATETIME 17   — — +
SC81 Picking list line SC81032 BackFlush NCHAR 1   — — +
SC82 Picking list line details SC82001 Warehouse NCHAR 6   — — +
SC82 Picking list line details SC82002 Picking list Id NCHAR 10   — — +
SC82 Picking list line details SC82003 Picking list line NCHAR 6   — — +
SC82 Picking list line details SC82004 Picking list detailed line NCHAR 6   — — +
SC82 Picking list line details SC82005 Linked to line NVARCHAR 22   — — +
SC82 Picking list line details SC82006 Batch Id NVARCHAR 12   — — +
SC82 Picking list line details SC82007 Bin number NVARCHAR 6   — — +
SC82 Picking list line details SC82008 Picked date – time DATETIME 17   — — +
SC82 Picking list line details SC82009 Quantity to pick (requested unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82010 Quantity to pick (stock unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82011 Picked quantity (requested unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82012 Picked quantity (stock unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82013 Issued quantity (requested unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82014 Issued quantity (stock unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82015 Shipped quantity (requested unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82016 Shipped quantity (stock unit) NUMERIC 12 8 — — +
SC82 Picking list line details SC82017 Warehouse area NVARCHAR 4   — — +
SC82 Picking list line details SC82018 Label NVARCHAR 35   — — +
SC82 Picking list line details SC82019 Actual shipment date – time DATETIME 17   — — +
SC82 Picking list line details SC82020 Delivery note number NVARCHAR 20   — — +
SC82 Picking list line details SC82021 Comment NVARCHAR 50   — — +
SC82 Picking list line details SC82022 Reported by NVARCHAR 8   — — +
SC82 Picking list line details SC82023 Issued Warehouse NVARCHAR 6   — — +
SC82 Picking list line details SC82024 Delivery note printed NCHAR 1   — — +
SC82 Picking list line details SC82025 Target warehouse NVARCHAR 6   — — +
SC82 Picking list line details SC82026 Target Bin NVARCHAR 6   — — +
SC82 Picking list line details SC82027 Order delivery line NVARCHAR 6   — — +
SC82 Picking list line details SC82028 Reporting no INT 3   — — +
SC82 Picking list line details SC82029 DN Issuer Code NCHAR 6   — — +
SC82 Picking list line details SC82030 Box Number NVARCHAR 10   — — +
SC83 Picking list serial numbers SC83001 Warehouse NCHAR 6   — — +
SC83 Picking list serial numbers SC83002 Picking list Id NCHAR 10   — — +
SC83 Picking list serial numbers SC83003 Picking list line NCHAR 6   — — +
SC83 Picking list serial numbers SC83004 Picking list detailed line NCHAR 6   — — +
SC83 Picking list serial numbers SC83005 Serial number NVARCHAR 20   — — +
SC83 Picking list serial numbers SC83006 Remark NVARCHAR 30   — — +
SC83 Picking list serial numbers SC83007 Certificate NVARCHAR 20   — — +
SC83 Picking list serial numbers SC83008 Version NVARCHAR 6   — — +
SC83 Picking list serial numbers SC83009 Release NVARCHAR 6   — — +
SC83 Picking list serial numbers SC83010 Text1 NVARCHAR 70   — — +
SC83 Picking list serial numbers SC83011 Text 2 NVARCHAR 70   — — +
SC83 Picking list serial numbers SC83012 Print on Invoice NCHAR 1   — — +
SC83 Picking list serial numbers SC83013 Print on Quote NCHAR 1   — — +
SC83 Picking list serial numbers SC83014 Print on Order confirmation NCHAR 1   — — +
SC83 Picking list serial numbers SC83015 Print on Picking list NCHAR 1   — — +
SC83 Picking list serial numbers SC83016 Print on Delivery note NCHAR 1   — — +
SC83 Picking list serial numbers SC83017 Print on Proforma invoice NCHAR 1   — — +
SC83 Picking list serial numbers SC83018 Print on Shipment proposal NCHAR 1   — — +
SC83 Picking list serial numbers SC83019 Print on Order reports NCHAR 1   — — +
SC83 Picking list serial numbers SC83020 Print on Purchase order NCHAR 1   — — +
SC83 Picking list serial numbers SC83021 Spare 1 NCHAR 1   — — +
SC83 Picking list serial numbers SC83022 Spare 2 NCHAR 1   — — +
SC83 Picking list serial numbers SC83023 Spare 3 NCHAR 1   — — +
SC83 Picking list serial numbers SC83024 Print on Discount group NCHAR 1   — — +
SC83 Picking list serial numbers SC83025 Spare 4 NCHAR 1   — — +
SC83 Picking list serial numbers SC83026 Print on Line not saved in history NCHAR 1   — — +
SC83 Picking list serial numbers SC83027 SN updated NCHAR 1   — — +
SC83 Picking list serial numbers SC83028 Text Line number NCHAR 6   — — +
SC85 Picking list head history SC85001 Warehouse NCHAR 6   — — +
SC85 Picking list head history SC85002 Picking list Id NCHAR 10   — — +
SC85 Picking list head history SC85003 Creation date – time DATETIME 17   — — +
SC85 Picking list head history SC85004 Created by NVARCHAR 8   — — +
SC85 Picking list head history SC85005 Earliest picking date – time DATETIME 17   — — +
SC85 Picking list head history SC85006 Latest picking date – time DATETIME 17   — — +
SC85 Picking list head history SC85007 Planned shipment date – time DATETIME 17   — — +
SC85 Picking list head history SC85008 Last printed date – time DATETIME 17   — — +
SC85 Picking list head history SC85009 Printed by NVARCHAR 8   — — +
SC85 Picking list head history SC85010 Status INT 1   — — +
SC85 Picking list head history SC85011 Status date DATETIME 17   — — +
SC85 Picking list head history SC85012 Request type NCHAR 1   — — +
SC85 Picking list head history SC85013 Request Number NVARCHAR 10   — — +
SC85 Picking list head history SC85014 Pick type INT 1   — — +
SC85 Picking list head history SC85015 Destination type NCHAR 1   — — +
SC85 Picking list head history SC85016 Destination Reference 1 NVARCHAR 10   — — +
SC85 Picking list head history SC85017 Destination Reference 2 NVARCHAR 10   — — +
SC85 Picking list head history SC85018 Destination Reference 3 NVARCHAR 10   — — +
SC85 Picking list head history SC85019 Picking list value NUMERIC 20 8 — — +
SC85 Picking list head history SC85020 Net weight NUMERIC 10 8 — — +
SC85 Picking list head history SC85021 Gross weight NUMERIC 10 8 — — +
SC85 Picking list head history SC85022 Volume NUMERIC 10 8 — — +
SC85 Picking list head history SC85023 No of items NUMERIC 10 8 — — +
SC85 Picking list head history SC85024 Merged picking list Id NVARCHAR 10   — — +
SC85 Picking list head history SC85025 Line sort definition INT 1   — — +
SC85 Picking list head history SC85026 Group number NUMERIC 10 8 — — +
SC85 Picking list head history SC85027 Status changed by NVARCHAR 8   — — +
SC85 Picking list head history SC85028 Status before OnHold INT 1   — — +
SC85 Picking list head history SC85029 Company Code NVARCHAR 2   — — +
SC85 Picking list head history SC85030 Language code Picking list NCHAR 3   — — +
SC85 Picking list head history SC85031 Language code Delivery note NCHAR 3   — — +
SC85 Picking list head history SC85032 Shipment date from LTM or latest pick date if LTM not used. DATETIME 17   — — +
SC85 Picking list head history SC85033 Pick List Group and Number inside the Group NVARCHAR 64   — — +
SC86 Picking list line history SC86001 Warehouse NCHAR 6   — — +
SC86 Picking list line history SC86002 Picking list Id NCHAR 10   — — +
SC86 Picking list line history SC86003 Picking list line NCHAR 6   — — +
SC86 Picking list line history SC86004 Request type NCHAR 1   — — +
SC86 Picking list line history SC86005 Request Reference 1 NVARCHAR 10   — — +
SC86 Picking list line history SC86006 Request Reference 2 NVARCHAR 10   — — +
SC86 Picking list line history SC86007 Request Reference 3 NVARCHAR 6   — — +
SC86 Picking list line history SC86008 Destination type NCHAR 1   — — +
SC86 Picking list line history SC86009 Destination Reference 1 NVARCHAR 10   — — +
SC86 Picking list line history SC86010 Destination Reference 2 NVARCHAR 10   — — +
SC86 Picking list line history SC86011 Destination Reference 3 NVARCHAR 10   — — +
SC86 Picking list line history SC86012 Handling instructions NVARCHAR 50   — — +
SC86 Picking list line history SC86013 Packing instructions NVARCHAR 50   — — +
SC86 Picking list line history SC86014 Stock code NVARCHAR 35   — — +
SC86 Picking list line history SC86015 Unit code INT 4   — — +
SC86 Picking list line history SC86016 Conversion factor NUMERIC 12 8 — — +
SC86 Picking list line history SC86017 Requested quantity (requested unit) NUMERIC 12 8 — — +
SC86 Picking list line history SC86018 Requested quantity (stock unit) NUMERIC 12 8 — — +
SC86 Picking list line history SC86019 Quantity to pick (requested unit) NUMERIC 12 8 — — +
SC86 Picking list line history SC86020 Quantity to pick (stock unit) NUMERIC 12 8 — — +
SC86 Picking list line history SC86021 Comment NVARCHAR 50   — — +
SC86 Picking list line history SC86022 Default Bin NVARCHAR 6   — — +
SC86 Picking list line history SC86023 Sort field NVARCHAR 100   — — +
SC86 Picking list line history SC86024 Pick type INT 1   — — +
SC86 Picking list line history SC86025 Description 1 NVARCHAR 25   — — +
SC86 Picking list line history SC86026 Description 2 NVARCHAR 25   — — +
SC86 Picking list line history SC86027 Closed NCHAR 1   — — +
SC86 Picking list line history SC86028 Company Code NVARCHAR 2   — — +
SC86 Picking list line history SC86029 CWH Picking list Id NVARCHAR 10   — — +
SC86 Picking list line history SC86030 Earliest planned shipment date – time DATETIME 17   — — +
SC86 Picking list line history SC86031 Latest planned shipment date – time DATETIME 17   — — +
SC86 Picking list line history SC86032 BackFlush NCHAR 1   — — +
SC87 Picking list line details history SC87001 Warehouse NCHAR 6   — — +
SC87 Picking list line details history SC87002 Picking list Id NCHAR 10   — — +
SC87 Picking list line details history SC87003 Picking list line NCHAR 6   — — +
SC87 Picking list line details history SC87004 Picking list detailed line NCHAR 6   — — +
SC87 Picking list line details history SC87005 Linked to line NVARCHAR 22   — — +
SC87 Picking list line details history SC87006 Batch Id NVARCHAR 12   — — +
SC87 Picking list line details history SC87007 Bin number NVARCHAR 6   — — +
SC87 Picking list line details history SC87008 Picked date – time DATETIME 17   — — +
SC87 Picking list line details history SC87009 Quantity to pick (requested unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87010 Quantity to pick (stock unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87011 Picked quantity (requested unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87012 Picked quantity (stock unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87013 Issued quantity (requested unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87014 Issued quantity (stock unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87015 Shipped quantity (requested unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87016 Shipped quantity (stock unit) NUMERIC 12 8 — — +
SC87 Picking list line details history SC87017 Warehouse area NVARCHAR 4   — — +
SC87 Picking list line details history SC87018 Label NVARCHAR 35   — — +
SC87 Picking list line details history SC87019 Actual shipment date – time DATETIME 17   — — +
SC87 Picking list line details history SC87020 Delivery note number NVARCHAR 20   — — +
SC87 Picking list line details history SC87021 Comment NVARCHAR 50   — — +
SC87 Picking list line details history SC87022 Reported by NVARCHAR 8   — — +
SC87 Picking list line details history SC87023 Issued Warehouse NVARCHAR 6   — — +
SC87 Picking list line details history SC87024 Delivery note printed NCHAR 1   — — +
SC87 Picking list line details history SC87025 Target warehouse NVARCHAR 6   — — +
SC87 Picking list line details history SC87026 Target Bin NVARCHAR 6   — — +
SC87 Picking list line details history SC87027 Order delivery line NVARCHAR 6   — — +
SC87 Picking list line details history SC87028 Reporting no INT 3   — — +
SC87 Picking list line details history SC87029 DN Issuer Code NCHAR 6   — — +
SC87 Picking list line details history SC87030 Box Number NVARCHAR 10   — — +
SC88 Picking list serial numbers history SC88001 Warehouse NCHAR 6   — — +
SC88 Picking list serial numbers history SC88002 Picking list Id NCHAR 10   — — +
SC88 Picking list serial numbers history SC88003 Picking list line NCHAR 6   — — +
SC88 Picking list serial numbers history SC88004 Picking list detailed line NCHAR 6   — — +
SC88 Picking list serial numbers history SC88005 Serial number NVARCHAR 20   — — +
SC88 Picking list serial numbers history SC88006 Remark NVARCHAR 30   — — +
SC88 Picking list serial numbers history SC88007 Certificate NVARCHAR 20   — — +
SC88 Picking list serial numbers history SC88008 Version NVARCHAR 6   — — +
SC88 Picking list serial numbers history SC88009 Release NVARCHAR 6   — — +
SC88 Picking list serial numbers history SC88010 Text 1 NVARCHAR 70   — — +
SC88 Picking list serial numbers history SC88011 Text 2 NVARCHAR 70   — — +
SC88 Picking list serial numbers history SC88012 Print on Invoice NCHAR 1   — — +
SC88 Picking list serial numbers history SC88013 Print on Quote NCHAR 1   — — +
SC88 Picking list serial numbers history SC88014 Print on Order confirmation NCHAR 1   — — +
SC88 Picking list serial numbers history SC88015 Print on Picking list NCHAR 1   — — +
SC88 Picking list serial numbers history SC88016 Print on Delivery note NCHAR 1   — — +
SC88 Picking list serial numbers history SC88017 Print on Proforma invoice NCHAR 1   — — +
SC88 Picking list serial numbers history SC88018 Print on Shipment proposal NCHAR 1   — — +
SC88 Picking list serial numbers history SC88019 Print on Order reports NCHAR 1   — — +
SC88 Picking list serial numbers history SC88020 Print on Purchase order NCHAR 1   — — +
SC88 Picking list serial numbers history SC88021 Spare 1 NCHAR 1   — — +
SC88 Picking list serial numbers history SC88022 Spare 2 NCHAR 1   — — +
SC88 Picking list serial numbers history SC88023 Spare 3 NCHAR 1   — — +
SC88 Picking list serial numbers history SC88024 Print on Discount group NCHAR 1   — — +
SC88 Picking list serial numbers history SC88025 Spare 4 NCHAR 1   — — +
SC88 Picking list serial numbers history SC88026 Print on Line not saved in history NCHAR 1   — — +
SC88 Picking list serial numbers history SC88027 SN updated NCHAR 1   — — +
SC88 Picking list serial numbers history SC88028 Text Line number NCHAR 6   — — +
SC89 Picking, Warehouse settings SC89001 Warehouse NCHAR 6   — — +
SC89 Picking, Warehouse settings SC89002 Request type NCHAR 1   — — +
SC89 Picking, Warehouse settings SC89003 Document code INT 1   — — +
SC89 Picking, Warehouse settings SC89004 External request NCHAR 1   — — +
SC8A Picking list allocation log SC8A001 Warehouse NCHAR 6   — — +
SC8A Picking list allocation log SC8A002 Log number NCHAR 10   — — +
SC8A Picking list allocation log SC8A003 Line NCHAR 6   — — +
SC8A Picking list allocation log SC8A004 Type NCHAR 2   — — +
SC8A Picking list allocation log SC8A005 Property No INT 3   — — +
SC8A Picking list allocation log SC8A006 Property Value NVARCHAR 50   — — +
SC8A Picking list allocation log SC8A007 Request type NCHAR 1   — — +
SC8A Picking list allocation log SC8A008 Printed NCHAR 1   — — +
SC8A Picking list allocation log SC8A009 LifeCyclePhaseID INT 2   — — +
SC8B Merged picking lists SC8B001 Warehouse NCHAR 6   — — +
SC8B Merged picking lists SC8B002 Merged Picking list Id NCHAR 10   — — +
SC8B Merged picking lists SC8B003 Spare NCHAR 10   — — +
SC8B Merged picking lists SC8B004 Printed date DATETIME 17   — — +
SC8B Merged picking lists SC8B005 Printed by NVARCHAR 8   — — +
SC8B Merged picking lists SC8B006 Used sorting NCHAR 1   — — +
SC8B Merged picking lists SC8B007 System Date DATETIME 17   — — +
SC8B Merged picking lists SC8B008 UserId NVARCHAR 8   — — +
SC8B Merged picking lists SC8B009 Company Code NCHAR 2   — — +
SC8C Picking module — links to Picking request line SC8C001 Warehouse NCHAR 6   — — +
SC8C Picking module — links to Picking request line SC8C002 Picking list id NCHAR 10   — — +
SC8C Picking module — links to Picking request line SC8C003 Picking list line NCHAR 6   — — +
SC8C Picking module — links to Picking request line SC8C004 Line NCHAR 4   — — +
SC8C Picking module — links to Picking request line SC8C005 Work order NCHAR 10   — — +
SC8C Picking module — links to Picking request line SC8C006 Purchase order NCHAR 10   — — +
SC8D Box Configurations in CPL SC8D001 Request Type NCHAR 2   — — +
SC8D Box Configurations in CPL SC8D002 Configuration Area NCHAR 2   — — +
SC8D Box Configurations in CPL SC8D003 Configuration Field NVARCHAR 36   — — +
SC8D Box Configurations in CPL SC8D004 Enable Box Handling INT 1   — — +
SC90 Consumed Reservations SC90001 Sales Contract Number (consumed from) NCHAR 10   — — +
SC90 Consumed Reservations SC90002 Sales Contract Line Number NCHAR 6   — — +
SC90 Consumed Reservations SC90003 Sales Contract SubLine Number NCHAR 6   — — +
SC90 Consumed Reservations SC90004 Reservation Type Consumed From NCHAR 1   — — +
SC90 Consumed Reservations SC90005 Reservation Subtype Consumed From NCHAR 1   — — +
SC90 Consumed Reservations SC90006 History Flag Consumed From NCHAR 1   — — +
SC90 Consumed Reservations SC90007 Contract/Order Number (consumed by) NCHAR 10   — — +
SC90 Consumed Reservations SC90008 Contract/Order Line Number NCHAR 6   — — +
SC90 Consumed Reservations SC90009 Contract/Order SubLine Number NCHAR 6   — — +
SC90 Consumed Reservations SC90010 Reservation type NCHAR 1   — — +
SC90 Consumed Reservations SC90011 Reservation subtype NCHAR 1   — — +
SC90 Consumed Reservations SC90012 History flag NCHAR 1   — — +
SC90 Consumed Reservations SC90013 Consumed qty (SC units) NUMERIC 12 8 — — +
SC90 Consumed Reservations SC90014 Consumed qty from Contract (OR units) NUMERIC 12 8 — — +
SC90 Consumed Reservations SC90015 Consumed qty by Contract/Order (OR units) NUMERIC 12 8 — — +
SC90 Consumed Reservations SC90016 Consumed Date DATETIME 8   — — +
SCA1 Rules for MPC WO allocations SCA1005 Unit of Measurement 1 INT 4   2   —
SCA1 Rules for MPC WO allocations SCA1007 Unit o Measurement 2 INT 4   2   —
SCB0 Box Headers SCB0001 Box Number NVARCHAR 10   — — +
SCB0 Box Headers SCB0002 Box Type NVARCHAR 4   — — +
SCB0 Box Headers SCB0003 Description NVARCHAR 25   — — +
SCB0 Box Headers SCB0004 Delivery Method NCHAR 2   — — +
SCB0 Box Headers SCB0005 Box Labels INT 1   — — +
SCB0 Box Headers SCB0006 IsClosed NCHAR 1   — — +
SCB0 Box Headers SCB0007 Box in use NCHAR 1   — — +
SCB0 Box Headers SCB0008 Creation Date DATETIME 8   — — +
SCB0 Box Headers SCB0009 Destination Type NCHAR 1   — — +
SCB0 Box Headers SCB0010 Destination reference1 NVARCHAR 10   — — +
SCB0 Box Headers SCB0011 Destination reference2 NVARCHAR 10   — — +
SCB0 Box Headers SCB0012 Destination reference3 NVARCHAR 10   — — +
SCB0 Box Headers SCB0013 Transport Documents NVARCHAR 100   — — +
SCB4 SC BOM Branch SCB4017 Unit Code INT 4   2   —
SCB6 Work file for ATP Rescheduling SCB6034 Confirmed Date DATETIME 8   — — +
SCB6 Work file for ATP Rescheduling SCB6035 New Confirmed Date DATETIME 8   — — +
SCB7 Temporary Stock planning table,ATP SCB7021 Confirmed Delivery Date DATETIME 8   — — +
SCB8 Work file for splitted lines, ATP SCB8007 Confirmed Delivery Date DATETIME 8   — — +
SCBA Generic Batch Allocations SCBA001 Stock Code NVARCHAR 35   — — +
SCBA Generic Batch Allocations SCBA002 Warehouse Code NCHAR 6   — — +
SCBA Generic Batch Allocations SCBA003 Batch ID NCHAR 12   — — +
SCBA Generic Batch Allocations SCBA004 Record Type NCHAR 2   — — +
SCBA Generic Batch Allocations SCBA005 Reference 1 NCHAR 10   — — +
SCBA Generic Batch Allocations SCBA006 Reference 2 NCHAR 10   — — +
SCBA Generic Batch Allocations SCBA007 Reference 3 NCHAR 10   — — +
SCBA Generic Batch Allocations SCBA008 Reference 4 NCHAR 10   — — +
SCBA Generic Batch Allocations SCBA009 Reference 5 NCHAR 10   — — +
SCBA Generic Batch Allocations SCBA010 Reference 6 NCHAR 10   — — +
SCBA Generic Batch Allocations SCBA011 Auto Line No NCHAR 6   — — +
SCBA Generic Batch Allocations SCBA012 Allocated Qty NUMERIC 12 8 — — +
SCBA Generic Batch Allocations SCBA013 Allocation Date DATETIME 8   — — +
SCBH Box Headers (history) SCBH001 Box Number NVARCHAR 10   — — +
SCBH Box Headers (history) SCBH002 Box Type NVARCHAR 4   — — +
SCBH Box Headers (history) SCBH003 Description NVARCHAR 25   — — +
SCBH Box Headers (history) SCBH004 Delivery Method NCHAR 2   — — +
SCBH Box Headers (history) SCBH005 Box Label INT 1   — — +
SCBH Box Headers (history) SCBH006 IsClosed NCHAR 1   — — +
SCBH Box Headers (history) SCBH007 Box in use NCHAR 1   — — +
SCBH Box Headers (history) SCBH008 Creation Date DATETIME 8   — — +
SCBH Box Headers (history) SCBH009 Destination Type NCHAR 1   — — +
SCBH Box Headers (history) SCBH010 Destination reference1 NVARCHAR 10   — — +
SCBH Box Headers (history) SCBH011 Destination reference2 NVARCHAR 10   — — +
SCBH Box Headers (history) SCBH012 Destination reference3 NVARCHAR 10   — — +
SCBH Box Headers (history) SCBH013 Transport Documents NVARCHAR 100   — — +
SCCF Commodity code description SCCF001 Commodity code NCHAR 35   — — +
SCCF Commodity code description SCCF002 Language Code NCHAR 3   — — +
SCCF Commodity code description SCCF003 Commodity code description NVARCHAR 60   — — +
SCCT Commodity code SCCT001 Commodity code NCHAR 35   — — +
SCCT Commodity code SCCT002 Dummy NCHAR 1   — — +
SCDA Default Accounting Matrix SCDA001 Department NCHAR 6   — — +
SCDA Default Accounting Matrix SCDA002 Requisition Type NCHAR 1   — — +
SCDA Default Accounting Matrix SCDA003 Stock or dot item NCHAR 1   — — +
SCDA Default Accounting Matrix SCDA004 Product Category NCHAR 10   — — +
SCDA Default Accounting Matrix SCDA005 Accounting String NVARCHAR 120   — — +
SCDF Commodity code segment descr. SCDF001 Classification level INT 1   — — +
SCDF Commodity code segment descr. SCDF002 Language Code NCHAR 3   — — +
SCDF Commodity code segment descr. SCDF003 Segment Description NVARCHAR 50   — — +
SCDT Commodity code segment definition SCDT001 Classification level INT 1   — — +
SCDT Commodity code segment definition SCDT002 Segment length INT 1   — — +
SCDT Commodity code segment definition SCDT003 Segment type INT 1   — — +
SCGL HI. GL Transactions SCGL001 Record Counter NUMERIC 9   8   —
SCGL HI. GL Transactions SCGL002 Transaction Number NCHAR 9   6   —
SCGL HI. GL Transactions SCGL003 Line Number NCHAR 7   5   —
SCGL HI. GL Transactions SCGL006 Accounting String NVARCHAR 120   50   —
SCGL HI. GL Transactions SCGL009 Accounting String Line Currency NVARCHAR 120   50   —
SCGL HI. GL Transactions SCGL011 Transaction Line Text NVARCHAR 100   25   —
SCGL HI. GL Transactions SCGL013 Batch ID NVARCHAR 25   23   —
SCGL HI. GL Transactions SCGL024 In Closing Period NCHAR 8   5   —
SCGL HI. GL Transactions SCGL026 Unit Code INT 4   2   —
SCGL HI. GL Transactions SCGL030 Spare NCHAR 9   6   —
SCGL HI. GL Transactions SCGL037 Transaction Text Line Currency NVARCHAR 100   25   —
SCGL HI. GL Transactions SCGL038 Printed By NCHAR 8   — — +
SCGL HI. GL Transactions SCGL039 Date Printed DATETIME 8   — — +
SCGL HI. GL Transactions SCGL040 Transaction Number NCHAR 9   — — +
SCGL HI. GL Transactions SCGL041 BE-Date DATETIME 8   — — +
SCGL HI. GL Transactions SCGL042 Supplier or Customer NVARCHAR 10   — — +
SCH0 Stock Withdrawal Parameters SCH0002 Accounting String NVARCHAR 120   50   —
SCH3 Stock Matrix SCH3003 Accounting String NVARCHAR 120   50   —
SCH4 Credit Account Matrix SCH4003 Accounting String NVARCHAR 120   50   —
SCH5 Department SCH5004 Customer NCHAR 10   — — +
SCH5 Department SCH5005 Approval Group NCHAR 8   — — +
SCI1 Reason Codes descriptions SCI1001 Language Code NCHAR 3   — — +
SCI1 Reason Codes descriptions SCI1002 Reason Code INT 3   — — +
SCI1 Reason Codes descriptions SCI1003 Description Line 1 NVARCHAR 70   — — +
SCI1 Reason Codes descriptions SCI1004 Description Line 2 NVARCHAR 70   — — +
SCI2 Reason Code features SCI2001 Reason Code INT 3   — — +
SCI2 Reason Code features SCI2002 Reason Code Flags NVARCHAR 50   — — +
SCP1 Life Cycle Phase Definition SCP1001 LifeCyclePhaseID INT 2   — — +
SCP1 Life Cycle Phase Definition SCP1002 LinkPermission INT 2   — — +
SCP1 Life Cycle Phase Definition SCP1003 Priority INT 2   — — +
SCP1 Life Cycle Phase Definition SCP1004 ApplytoSalesOrder NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1005 applytoPurchaseOrder NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1006 ApplytoWorkOrders NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1007 ApplytoServiceOrder NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1008 ApplytoBillsOfMaterial NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1009 ApplytoLeaseContracts NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1010 ApplytoAssetTransfer NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1011 ApplytoUndefined1 NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1012 AllowStockWithdrawal NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1013 BomHandling NVARCHAR 1   — — +
SCP1 Life Cycle Phase Definition SCP1014 ScreenLabelReference INT 1   — — +
SCP1 Life Cycle Phase Definition SCP1015 WarningMessageReference INT 1   — — +
SCP1 Life Cycle Phase Definition SCP1016 ErrorMessageReference INT 1   — — +
SCP1 Life Cycle Phase Definition SCP1017 ApplytoRequisitions NVARCHAR 1   — — +
SCP2 Life Cycle Phase Strings SCP2001 LifeCyclePhaseID INT 2   — — +
SCP2 Life Cycle Phase Strings SCP2002 LanguageCode NCHAR 3   — — +
SCP2 Life Cycle Phase Strings SCP2003 ScreenLabel NVARCHAR 100   — — +
SCP2 Life Cycle Phase Strings SCP2004 WarningMessage NVARCHAR 100   — — +
SCP2 Life Cycle Phase Strings SCP2005 ErrorMessage NVARCHAR 100   — — +
SCP3 Stock Item Life Cycle Phase SCP3001 StockCode NVARCHAR 35   — — +
SCP3 Stock Item Life Cycle Phase SCP3002 lifeCyclePhaseID INT 2   — — +
SCP3 Stock Item Life Cycle Phase SCP3003 ApplytoStockItem NVARCHAR 1   — — +
SCP3 Stock Item Life Cycle Phase SCP3004 ActivationDate DATETIME 8   — — +
SCP3 Stock Item Life Cycle Phase SCP3005 DeactivationDate DATETIME 8   — — +
SCP5 Discount per Stock Code SCP5001 Stock Code NVARCHAR 35   — — +
SCP5 Discount per Stock Code SCP5002 Discount Level 1, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5003 Discount Level 1, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5004 Discount Level 1, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5005 Discount Level 2, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5006 Discount Level 2, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5007 Discount Level 2, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5008 Discount Level 3, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5009 Discount Level 3, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5010 Discount Level 3, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5011 Discount Level 4, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5012 Discount Level 4, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5013 Discount Level 4, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5014 Discount Level 5, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5015 Discount Level 5, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5016 Discount Level 5, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5017 Discount Level 6, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5018 Discount Level 6, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5019 Discount Level 6, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5020 Discount Level 7, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5021 Discount Level 7, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5022 Discount Level 7, Price NUMERIC 20 8 — — +
SCP5 Discount per Stock Code SCP5023 Discount Level 8, Quantity NUMERIC 12 8 — — +
SCP5 Discount per Stock Code SCP5024 Discount Level 8, Discount NUMERIC 6 8 — — +
SCP5 Discount per Stock Code SCP5025 Discount Level 8, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6001 Stock Code NVARCHAR 35   — — +
SCP6 Price and Discount per Stock code — Customer SCP6002 Customer Code NVARCHAR 10   — — +
SCP6 Price and Discount per Stock code — Customer SCP6003 Customer Stock Code NVARCHAR 35   — — +
SCP6 Price and Discount per Stock code — Customer SCP6004 Customer Description 1 NVARCHAR 25   — — +
SCP6 Price and Discount per Stock code — Customer SCP6005 Customer Description 2 NVARCHAR 25   — — +
SCP6 Price and Discount per Stock code — Customer SCP6006 Remark NVARCHAR 20   — — +
SCP6 Price and Discount per Stock code — Customer SCP6007 Currency Code INT 2   — — +
SCP6 Price and Discount per Stock code — Customer SCP6008 Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6009 Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6010 Valid from Date DATETIME 8   — — +
SCP6 Price and Discount per Stock code — Customer SCP6011 Valid to Date DATETIME 8   — — +
SCP6 Price and Discount per Stock code — Customer SCP6012 Yearly Budget NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6013 Budget Profile INT 1   — — +
SCP6 Price and Discount per Stock code — Customer SCP6014 Spare NVARCHAR 10   — — +
SCP6 Price and Discount per Stock code — Customer SCP6015 Discount Level 1, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6016 Discount Level 1, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6017 Discount Level 1, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6018 Discount Level 2, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6019 Discount Level 2, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6020 Discount Level 2, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6021 Discount Level 3, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6022 Discount Level 3, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6023 Discount Level 3, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6024 Discount Level 4, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6025 Discount Level 4, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6026 Discount Level 4, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6027 Discount Level 5, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6028 Discount Level 5, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6029 Discount Level 5, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6030 Discount Level 6, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6031 Discount Level 6, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6032 Discount Level 6, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6033 Discount Level 7, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6034 Discount Level 7, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6035 Discount Level 7, Price NUMERIC 20 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6036 Discount Level 8, Quantity NUMERIC 12 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6037 Discount Level 8, Discount NUMERIC 6 8 — — +
SCP6 Price and Discount per Stock code — Customer SCP6038 Discount Level 8, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7001 Stock Code NVARCHAR 35   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7002 Supplier Code NVARCHAR 10   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7003 Supplier Stock Code NVARCHAR 35   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7004 Supplier Description 1 NVARCHAR 25   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7005 Supplier Description 2 NVARCHAR 25   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7006 Remark NVARCHAR 20   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7007 Currency Code INT 2   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7008 Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7009 Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7010 Valid from Date DATETIME 8   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7011 Valid to Date DATETIME 8   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7012 Re-Order Level NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7013 Delivery Time INT 3   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7014 Optimal Purchase Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7015 Discount Level 1, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7016 Discount Level 1, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7017 Discount Level 1, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7018 Discount Level 2, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7019 Discount Level 2, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7020 Discount Level 2, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7021 Discount Level 3, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7022 Discount Level 3, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7023 Discount Level 3, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7024 Discount Level 4, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7025 Discount Level 4, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7026 Discount Level 4, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7027 Discount Level 5, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7028 Discount Level 5, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7029 Discount Level 5, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7030 Discount Level 6, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7031 Discount Level 6, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7032 Discount Level 6, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7033 Discount Level 7, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7034 Discount Level 7, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7035 Discount Level 7, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7036 Discount Level 8, Quantity NUMERIC 12 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7037 Discount Level 8, Discount NUMERIC 6 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7038 Discount Level 8, Price NUMERIC 20 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7039 Delivery Time Unit INT 1   — — +
SCP7 Price and Discount per Stock code — Supplier SCP7040 Price Multiple NUMERIC 10 8 — — +
SCP7 Price and Discount per Stock code — Supplier SCP7041 Multiple for MRP, SRP and MPS NUMERIC 12 8 — — +
SCRE REACH Report SCRE001 Stock Item Code NVARCHAR 35   — — +
SCRE REACH Report SCRE002 REACH Last Report DATETIME 8   — — +
SCRE REACH Report SCRE003 REACH Tot Imported NUMERIC 20 8 — — +
SCRE REACH Report SCRE004 REACH Tot Used NUMERIC 20 8 — — +
SCRE REACH Report SCRE005 REACH Tot Produced NUMERIC 20 8 — — +
SCRE REACH Report SCRE006 REACH Tot Sold NUMERIC 20 8 — — +
SCRE REACH Report SCRE007 REACH Tot Sold Value NUMERIC 20 8 — — +
SCRE REACH Report SCRE008 REACH Start Date DATETIME 8   — — +
SCSW Item/Warehouse/Supplier Information SCSW001 StockCode NVARCHAR 35   — — +
SCSW Item/Warehouse/Supplier Information SCSW002 WarehouseCode NVARCHAR 6   — — +
SCSW Item/Warehouse/Supplier Information SCSW003 SupplierCode NVARCHAR 10   — — +
SCSW Item/Warehouse/Supplier Information SCSW004 EstimOnCost NUMERIC 12 8 — — +
SCT5 Customer/Supplier Control SCT5015 EAN NVARCHAR 35   — — +
SCT5 Customer/Supplier Control SCT5016 GTIN NVARCHAR 35   — — +
SCT5 Customer/Supplier Control SCT5017 Udef Barcode NVARCHAR 150   — — +
SCT9 Workorder Batch Trace Connections SCT9001 Search Index NCHAR 8   — — +
SCT9 Workorder Batch Trace Connections SCT9002 Workorder Received Batch Number NCHAR 12   — — +
SCUC unit codes SCUC001 Unit Code INT 4   — — +
SCUC unit codes SCUC002 Has Parent INT 1   — — +
SCUC unit codes SCUC003 Parent Unit Code INT 4   — — +
SCUC unit codes SCUC004 Link Number INT 4   — — +
SCUC unit codes SCUC005 Number of decimals for unit INT 1   — — +
SCUC unit codes SCUC006 Child Unit Factor NUMERIC 20 8 — — +
SCUC unit codes SCUC007 Effective Unit Factor NUMERIC 20 8 — — +
SCUN unit names in different languages SCUN001 Unit Code INT 4   — — +
SCUN unit names in different languages SCUN002 Language Code NCHAR 3   — — +
SCUN unit names in different languages SCUN003 Unit Name NCHAR 25   — — +
SCW1 Central Warehouse Def SCW1025 Allocation Priority NCHAR 1   — — +
SCW1 Central Warehouse Def SCW1026 Spare NCHAR 1   — — +
SCW1 Central Warehouse Def SCW1027 Spare NCHAR 1   — — +
SCW2 Transaction warehouse definition SCW2030 Spare NCHAR 1   — — +
SCW2 Transaction warehouse definition SCW2031 Spare NCHAR 1   — — +
SCW2 Transaction warehouse definition SCW2032 Spare NCHAR 1   — — +
SCW3 Central Warehouse Pickinglist Head SCW3022 Source of request NCHAR 1   — — +
SCW3 Central Warehouse Pickinglist Head SCW3023 Trade Warehouse NVARCHAR 6   — — +
SCW4 Central Warehouse Order Process Status SCW4009 Source of request NCHAR 1   — — +
SCW5 Central Warehouse PL Invoice Transfer Table SCW5003 Invoice number NVARCHAR 25   15   —
SCW6 Central Warehouse Tax Transaction Transfer SCW6003 Invoice number NVARCHAR 25   15   —
SCW6 Central Warehouse Tax Transaction Transfer SCW6008 Line NVARCHAR 2   — — +
SCW6 Central Warehouse Tax Transaction Transfer SCW6009 Accounting Info NVARCHAR 120   — — +
SCW6 Central Warehouse Tax Transaction Transfer SCW6010 Line Reference NVARCHAR 5   — — +
SCW6 Central Warehouse Tax Transaction Transfer SCW6011 AAS code NVARCHAR 25   — — +
SCW7 Central Warehouse PL Invoice Transaction Transfer SCW7003 Invoice number NVARCHAR 25   15   —
SCW7 Central Warehouse PL Invoice Transaction Transfer SCW7005 Accounting String NVARCHAR 120   50   —
SCW7 Central Warehouse PL Invoice Transaction Transfer SCW7013 AAS code NVARCHAR 25   — — +
SCW8 Central Warehouse Order Head Extension SCW8009 Source of request NCHAR 1   — — +
SCW9 Central Warehouse Order Line Extension SCW9028 Source of request NCHAR 1   — — +
SCW9 Central Warehouse Order Line Extension SCW9029 Unit Code INT 4   — — +
SCW9 Central Warehouse Order Line Extension SCW9030 Trade Warehouse NVARCHAR 6   — — +
SCWA Warehouse Area SCWA010 Skip Item/Batch Placement validation? INT 1   — — +
SCWB Central Warehouse Pickinglist Line SCWB014 Unit Code INT 4   2   —
SCWB Central Warehouse Pickinglist Line SCWB017 Source of request NCHAR 1   — — +
SCWB Central Warehouse Pickinglist Line SCWB018 Trade Warehouse NVARCHAR 6   — — +
SCWE Central Warehouse Purchase Statistics Transfer SCWE003 Invoice number NVARCHAR 25   15   —
SCWE Central Warehouse Purchase Statistics Transfer SCWE008 Accounting string NVARCHAR 120   50   —
SCWE Central Warehouse Purchase Statistics Transfer SCWE027 Invoice Number NVARCHAR 25   15   —
SCWE Central Warehouse Purchase Statistics Transfer SCWE035 Source of request NCHAR 1   — — +
SCWE Central Warehouse Purchase Statistics Transfer SCWE036 AAS code NVARCHAR 25   — — +
SCWF Intercompany Serial Number SCWF009 Source of request NCHAR 1   — — +
SCWG Central Warehouse Delivery Error Log SCWG016 Source of request NCHAR 1   — — +
SCWH Central Warehouse pickinglist allocations SCWH021 Source of request NCHAR 1   — — +
SCWL Central warehouse serial number transfer SCWL007 Source of request NCHAR 1   — — +
SCWM Central Warehouse Delivery Transactions SCWM034 Accounting String NVARCHAR 120   50   —
SCWM Central Warehouse Delivery Transactions SCWM070 Source of request NCHAR 1   — — +
SCWM Central Warehouse Delivery Transactions SCWM071 Delivery Note Printed Date DATETIME 8   — — +
SCWM Central Warehouse Delivery Transactions SCWM072 Accounting Code 1 NCHAR 2   — — +
SCWM Central Warehouse Delivery Transactions SCWM073 AAS code NVARCHAR 25   — — +
SCWM Central Warehouse Delivery Transactions SCWM074 Trade Warehouse NVARCHAR 6   — — +
SCWQ Central warehouse pickinglist log SCWQ005 Text Line 1 NVARCHAR 100   50   —
SCWQ Central warehouse pickinglist log SCWQ006 Text Line 2 NVARCHAR 100   50   —
SCWQ Central warehouse pickinglist log SCWQ007 Text Line 3 NVARCHAR 100   50   —
SCWQ Central warehouse pickinglist log SCWQ008 Source of request NCHAR 1   — — +
SCWW Central Warehouse Intercompany delivery transaction history SCWW022 Currency Exchange Rate Central Warehouse NUMERIC 20 8 10 8 —
SCWW Central Warehouse Intercompany delivery transaction history SCWW023 Currency Exchange Rate 2 Central Warehouse NUMERIC 10 8 20 8 —
SCWW Central Warehouse Intercompany delivery transaction history SCWW026 Currency Exchange Rate Order NUMERIC 20 8 10 8 —
SCWW Central Warehouse Intercompany delivery transaction history SCWW027 Currency Exchange Rate 2 Order NUMERIC 10 8 20 8 —
SCWW Central Warehouse Intercompany delivery transaction history SCWW034 Accounting String NVARCHAR 120   50   —
SCWW Central Warehouse Intercompany delivery transaction history SCWW070 Source of request NCHAR 1   — — +
SCWW Central Warehouse Intercompany delivery transaction history SCWW071 Delivery Note Printed Date DATETIME 8   — — +
SCWW Central Warehouse Intercompany delivery transaction history SCWW072 Accounting Code 2 NCHAR 2   — — +
SCWW Central Warehouse Intercompany delivery transaction history SCWW073 AAS code NVARCHAR 25   — — +
SCWW Central Warehouse Intercompany delivery transaction history SCWW074 Trade Warehouse NVARCHAR 6   — — +
SCZ6 Tax exemption on NCM code SCZ6001 NCM Code NVARCHAR 25   — — +
SCZ6 Tax exemption on NCM code SCZ6002 Tax Type Code NCHAR 6   — — +
SCZ6 Tax exemption on NCM code SCZ6003 Tax Rate Code NCHAR 2   — — +
SCZ6 Tax exemption on NCM code SCZ6004 Exemption Type NCHAR 1   — — +
SCZ6 Tax exemption on NCM code SCZ6005 Fiscal Text Code NVARCHAR 10   — — +
SCZ6 Tax exemption on NCM code SCZ6006 Exemption Rate NUMERIC 20 8 — — +
SCZ6 Tax exemption on NCM code SCZ6007 Start Date DATETIME 8   — — +
SCZ6 Tax exemption on NCM code SCZ6008 Expiry Date DATETIME 8   — — +
SCZ6 Tax exemption on NCM code SCZ6009 Resolution Number NVARCHAR 40   — — +
SCZ6 Tax exemption on NCM code SCZ6010 Resolution Date DATETIME 8   — — +
SCZ6 Tax exemption on NCM code SCZ6011 Exemption Code NCHAR 6   — — +
SCZ6 Tax exemption on NCM code SCZ6012 State Code NVARCHAR 10   — — +