Название Таблицы / 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 | — | — | + |
На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2