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

Изменения структуры таблиц модуля «Заказы на Продажу» / Sales Order 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?
OR01 Order Head OR01025 Accounting String NVARCHAR 120   50   —
OR01 Order Head OR01072 Customer Purchase Order Number NVARCHAR 30   20   —
OR01 Order Head OR01108 Internal Debiting Accounting String NVARCHAR 120   50   —
OR01 Order Head OR01168 Invoice Issuer Code NCHAR 6   4   —
OR01 Order Head OR01173 Financial Operation Code 2 NVARCHAR 10   — — +
OR01 Order Head OR01174 Drop Shipment Supplier NCHAR 10   — — +
OR01 Order Head OR01175 Instalment NCHAR 1   — — +
OR01 Order Head OR01176 Interest NVARCHAR 6   — — +
OR01 Order Head OR01177 FinCharge NUMERIC 20 8 — — +
OR01 Order Head OR01178 TaxCodeInterest NCHAR 6   — — +
OR01 Order Head OR01179 TaxCodeFinCharge NCHAR 6   — — +
OR01 Order Head OR01180 ActivateNewInterest DATETIME 8   — — +
OR01 Order Head OR01181 NewInterest% NVARCHAR 6   — — +
OR01 Order Head OR01182 Sales Return Reason Code INT 1   — — +
OR01 Order Head OR01183 RMA Reference NCHAR 10   — — +
OR01 Order Head OR01184 Return Comment NVARCHAR 50   — — +
OR01 Order Head OR01185 Kind of Box NVARCHAR 15   — — +
OR01 Order Head OR01186 Box numbering NVARCHAR 15   — — +
OR01 Order Head OR01187 Number of pallets NVARCHAR 15   — — +
OR01 Order Head OR01188 Transport Company Code NVARCHAR 10   — — +
OR01 Order Head OR01189 Vehicle State/Province NVARCHAR 10   — — +
OR01 Order Head OR01190 Vehicle License Plate NVARCHAR 15   — — +
OR01 Order Head OR01191 Freight Payer NCHAR 1   — — +
OR01 Order Head OR01192 Own Freight Tax Code NCHAR 6   — — +
OR01 Order Head OR01193 Orig Terms Payment NVARCHAR 2   — — +
OR01 Order Head OR01194 Contract Number NCHAR 10   — — +
OR01 Order Head OR01195 Shipment Date Actual DATETIME 8   — — +
OR01 Order Head OR01196 Delivery Date Estimated DATETIME 8   — — +
OR01 Order Head OR01197 Title Pass Date DATETIME 8   — — +
OR01 Order Head OR01198 Delivery Note, sort NCHAR 1   — — +
OR01 Order Head OR01199 Auto print DN NVARCHAR 1   — — +
OR01 Order Head OR01200 Auto send DN NVARCHAR 1   — — +
OR01 Order Head OR01201 Release for withdrawal INT 1   — — +
OR01 Order Head OR01202 Delivery note printing INT 1   — — +
OR01 Order Head OR01203 Invoice printing INT 1   — — +
OR01 Order Head OR01204 Create back-order NCHAR 1   — — +
OR01 Order Head OR01205 Order Pricing Number NCHAR 10   — — +
OR01 Order Head OR01206 Auto print Invoice NVARCHAR 1   — — +
OR01 Order Head OR01207 Auto send Invoice NVARCHAR 1   — — +
OR01 Order Head OR01208 District NVARCHAR 2   — — +
OR01 Order Head OR01209 Advertising Code NVARCHAR 2   — — +
OR01 Order Head OR01210 City Code NVARCHAR 4   — — +
OR01 Order Head OR01211 SNI Code NVARCHAR 5   — — +
OR01 Order Head OR01212 Commision Distribution Method NVARCHAR 1   — — +
OR01 Order Head OR01213 Reason Code INT 3   — — +
OR01 Order Head OR01214 Way of payments NVARCHAR 2   — — +
OR01 Order Head OR01215 Bank Code NVARCHAR 10   — — +
OR01 Order Head OR01216 Payment Address Code NVARCHAR 2   — — +
OR01 Order Head OR01217 Accepted Delivery Date DATETIME 8   — — +
OR01 Order Head OR01218 Planned Delivery Time NVARCHAR 20   — — +
OR01 Order Head OR01219 Accepted Delivery Time NVARCHAR 20   — — +
OR01 Order Head OR01220 Sales Return Order No NCHAR 10   — — +
OR01 Order Head OR01221 Sales Return Invoice No NCHAR 15   — — +
OR01 Order Head OR01222 Email address NVARCHAR 200   — — +
OR01 Order Head OR01223 Invoice Time DATETIME 17   — — +
OR01 Order Head OR01224 Partial Delivery Planning NVARCHAR 1   — — +
OR01 Order Head OR01225 Lock Order Payments INT 1   — — +
OR01 Order Head OR01226 Customer for price NCHAR 1   — — +
OR01 Order Head OR01227 Packaging Tax Amount per kg NUMERIC 20 8 — — +
OR01 Order Head OR01228 Credit check passed NCHAR 1   — — +
OR01 Order Head OR01229 Code ANTT NVARCHAR 10   — — +
OR01 Order Head OR01230 Freight Tax Mode NCHAR 1   — — +
OR01 Order Head OR01231 Fiscal Reference NVARCHAR 50   — — +
OR01 Order Head OR01232 Spesometro Forms NVARCHAR 12   — — +
OR01 Order Head OR01233 TaxPoint NCHAR 1   — — +
OR01 Order Head OR01234 Public Procurement Code1 NVARCHAR 20   — — +
OR01 Order Head OR01235 Public Procurement Code2 NVARCHAR 20   — — +
OR01 Order Head OR01236 Fixed Exchange Rate Flag NCHAR 1   — — +
OR01 Order Head OR01237 OCU Exchange Rate 1 NUMERIC 10 8 — — +
OR01 Order Head OR01238 OCU Exchange Algorithm NCHAR 3   — — +
OR01 Order Head OR01239 OCU Exchange Rate 2 NUMERIC 10 8 — — +
OR01 Order Head OR01240 Own Bank Code 1 NCHAR 2   — — +
OR01 Order Head OR01241 Own Bank Code 2 NCHAR 2   — — +
OR01 Order Head OR01242 Bank Account 1 NVARCHAR 34   — — +
OR01 Order Head OR01243 Bank Code 2 NVARCHAR 10   — — +
OR01 Order Head OR01244 Bank Account 2 NVARCHAR 34   — — +
OR01 Order Head OR01245 Tax Registration Date DATETIME 8   — — +
OR01 Order Head OR01246 Contribution to consolidated invoice NUMERIC 20 8 — — +
OR01 Order Head OR01247 Tax Registration Country NCHAR 3   — — +
OR03 Sales Order Lines OR03010 Unit Code INT 4   2   —
OR03 Sales Order Lines OR03028 Accounting String NVARCHAR 120   50   —
OR03 Sales Order Lines OR03114 Confirmed Delivery Date DATETIME 8   — — +
OR03 Sales Order Lines OR03115 Confirmed Delivery Date Back Order DATETIME 8   — — +
OR03 Sales Order Lines OR03116 Original Confirmed Delivery Date DATETIME 8   — — +
OR03 Sales Order Lines OR03117 NomenclatureNo NVARCHAR 25   — — +
OR03 Sales Order Lines OR03118 Accepted Delivery Date DATETIME 8   — — +
OR03 Sales Order Lines OR03119 Order Customer Code NCHAR 10   — — +
OR03 Sales Order Lines OR03120 FinOperationCode NVARCHAR 10   — — +
OR03 Sales Order Lines OR03121 Order Line Pricing Date DATETIME 8   — — +
OR03 Sales Order Lines OR03122 Order Pricing Number NCHAR 10   — — +
OR03 Sales Order Lines OR03123 Requested Delivery Time NVARCHAR 20   — — +
OR03 Sales Order Lines OR03124 Accepted Delivery Time NVARCHAR 20   — — +
OR03 Sales Order Lines OR03125 External status INT 4   — — +
OR03 Sales Order Lines OR03126 Line Price Type INT 1   — — +
OR03 Sales Order Lines OR03127 Net Unit Price NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03128 Confirmed Production Date DATETIME 8   — — +
OR03 Sales Order Lines OR03129 Exempt Tax Code NCHAR 2   — — +
OR03 Sales Order Lines OR03130 Exempt Limit NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03131 Taxable Price NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03132 Accounting Code 2 NCHAR 2   — — +
OR03 Sales Order Lines OR03133 Delivery block flag NCHAR 1   — — +
OR03 Sales Order Lines OR03134 Export blocked NCHAR 1   — — +
OR03 Sales Order Lines OR03135 Packaging Tax Amount per kg NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03136 Approved credit limit NCHAR 1   — — +
OR03 Sales Order Lines OR03137 Product Tax Type NVARCHAR 10   — — +
OR03 Sales Order Lines OR03138 Line Freight OCU NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03139 Line Freight ICU NUMERIC 20 8 — — +
OR03 Sales Order Lines OR03140 Inv Prefix NCHAR 4   — — +
OR03 Sales Order Lines OR03141 Tax Reason Code NCHAR 3   — — +
OR03 Sales Order Lines OR03142 Confirmed by Planner NCHAR 1   — — +
OR03 Sales Order Lines OR03143 Extended User defined field 1 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03144 Extended User defined field 2 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03145 Extended User defined field 3 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03146 Extended User defined field 4 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03147 Extended User defined field 5 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03148 Extended User defined field 6 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03149 Extended User defined field 7 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03150 Extended User defined field 8 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03151 Extended User defined field 9 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03152 Extended User defined field 10 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03153 Extended User defined field 11 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03154 Extended User defined field 12 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03155 Extended User defined field 13 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03156 Extended User defined field 14 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03157 Extended User defined field 15 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03158 Extended User defined field 16 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03159 Extended User defined field 17 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03160 Extended User defined field 18 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03161 Extended User defined field 19 NVARCHAR 150   — — +
OR03 Sales Order Lines OR03162 Extended User defined field 20 NVARCHAR 150   — — +
OR04 Delivery Addresses OR04017 Country Code NVARCHAR 3   — — +
OR04 Delivery Addresses OR04018 Region Code NVARCHAR 10   — — +
OR04 Delivery Addresses OR04019 State/Province Code NVARCHAR 10   — — +
OR04 Delivery Addresses OR04020 County Code NVARCHAR 10   — — +
OR04 Delivery Addresses OR04021 Email address NVARCHAR 200   — — +
OR04 Delivery Addresses OR04022 Address Line 5 NVARCHAR 35   — — +
OR04 Delivery Addresses OR04023 Address Line 6 NVARCHAR 35   — — +
OR04 Delivery Addresses OR04024 Address Line 7 NVARCHAR 35   — — +
OR04 Delivery Addresses OR04025 Customer code NVARCHAR 10   — — +
OR04 Delivery Addresses OR04026 Address No NVARCHAR 2   — — +
OR04 Delivery Addresses OR04027 Tax Registration No NVARCHAR 20   — — +
OR05 Order Parameters OR05140 Default Structure Query in BOM Configurator NCHAR 1   — — +
OR05 Order Parameters OR05141 Save Invoice Image NCHAR 1   — — +
OR05 Order Parameters OR05142 Milestone related to Delivery Date NCHAR 1   — — +
OR05 Order Parameters OR05143 LT AP start before today NCHAR 1   — — +
OR05 Order Parameters OR05144 Create Invoices with Future Booking Date NCHAR 1   — — +
OR05 Order Parameters OR05145 Close Invoices with Future Booking Date NCHAR 1   — — +
OR05 Order Parameters OR05146 ATP Cancellation Code NVARCHAR 4   — — +
OR05 Order Parameters OR05147 EDI Process Lead Time NUMERIC 10 8 — — +
OR05 Order Parameters OR05148 Distr Charge Tax Switch NCHAR 1   — — +
OR05 Order Parameters OR05149 Update work order INT 1   — — +
OR05 Order Parameters OR05150 Update work order till INT 1   — — +
OR05 Order Parameters OR05151 Cost of drop shipment items before delivery INT 1   — — +
OR05 Order Parameters OR05152 Freight tax code source INT 1   — — +
OR05 Order Parameters OR05153 Cost Check Flag NCHAR 1   — — +
OR05 Order Parameters OR05154 Customer for price NCHAR 1   — — +
OR05 Order Parameters OR05155 Pack. Material charge per Sales Order? NCHAR 1   — — +
OR05 Order Parameters OR05156 Packaging Tax Amount per Order NUMERIC 20 8 — — +
OR05 Order Parameters OR05157 Tax Code, Pack. Material per Order NCHAR 2   — — +
OR05 Order Parameters OR05158 Block conversion quotation to order if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05159 Block Sales Order entry if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05160 Credit check at Sales order line entry NCHAR 1   — — +
OR05 Order Parameters OR05161 Credit check at Sales order exit NCHAR 1   — — +
OR05 Order Parameters OR05162 Block allocation if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05163 Block delivery if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05164 Block drop shipment PO creation if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05165 Skip additional credit checks after order entry NCHAR 1   — — +
OR05 Order Parameters OR05166 Exclude Credit blocked, Direct orders at Purchase proposal creation NCHAR 1   — — +
OR05 Order Parameters OR05167 Block Work Order creation if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05168 Product Tax Type Non Stock Item NVARCHAR 10   — — +
OR05 Order Parameters OR05169 Red Storno Default NCHAR 1   — — +
OR05 Order Parameters OR05170 DefTaxPoint NCHAR 1   — — +
OR05 Order Parameters OR05171 Number of Copies for Return Note INT 2   — — +
OR05 Order Parameters OR05172 Block picking list printing if customer is blocked by credit control NCHAR 1   — — +
OR05 Order Parameters OR05173 Tax Reason Code NCHAR 3   — — +
OR05 Order Parameters OR05174 Confirmation Controlled by Planner NCHAR 1   — — +
OR05 Order Parameters OR05175 Default validity period for quotations INT 3   — — +
OR05 Order Parameters OR05176 Freight Tax Code INT 2   — — +
OR05 Order Parameters OR05177 Control Stock Return NCHAR 1   — — +
OR09 Export Document Parameters OR09002 Exporter Name NVARCHAR 35   32   —
OR09 Export Document Parameters OR09003 Exporter Address Line 1 NVARCHAR 35   32   —
OR09 Export Document Parameters OR09004 Exporter Address Line 2 NVARCHAR 35   32   —
OR09 Export Document Parameters OR09005 Exporter Address Line 3 NVARCHAR 35   32   —
OR09 Export Document Parameters OR09036 Exporter Address Line 4 NVARCHAR 35   — — +
OR09 Export Document Parameters OR09037 Exporter Address Line 5 NVARCHAR 35   — — +
OR09 Export Document Parameters OR09038 Exporter Address Line 6 NVARCHAR 35   — — +
OR09 Export Document Parameters OR09039 Exporter Address Line 7 NVARCHAR 35   — — +
OR09 Export Document Parameters OR09040 Exporter Country Code NVARCHAR 3   — — +
OR10 Transport Document Parameters OR10020 Sender Address Line 3 NVARCHAR 35   — — +
OR10 Transport Document Parameters OR10021 Sender Address Line 4 NVARCHAR 35   — — +
OR10 Transport Document Parameters OR10022 Sender Address Line 5 NVARCHAR 35   — — +
OR10 Transport Document Parameters OR10023 Sender Address Line 6 NVARCHAR 35   — — +
OR10 Transport Document Parameters OR10024 Sender Address Line 7 NVARCHAR 35   — — +
OR10 Transport Document Parameters OR10025 Sender Country Code NVARCHAR 3   — — +
OR12 Order History (Compressed) OR12010 Unit Code INT 4   2   —
OR12 Order History (Compressed) OR12019 Customer Purchase Order Number NVARCHAR 30   20   —
OR14 Order Status OR14003 Status 0 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14005 Status 1 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14007 Status 2 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14009 Status 3 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14011 Status 4 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14013 Status 5 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14015 Status 6 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14017 Status 7 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14019 Status 8 Allowed Functions NVARCHAR 25   20   —
OR14 Order Status OR14021 Status 9 Allowed Functions NVARCHAR 25   20   —
OR16 ECC doc.printout OR16022 UnitCode INT 4   2   —
OR17 Order Text Lines OR17004 Text Line Number NCHAR 6   3   —
OR17 Order Text Lines OR17025 Created by MPC configuration NCHAR 1   — — +
OR17 Order Text Lines OR17026 Serial Number Flag NCHAR 1   — — +
OR18 Order History Text (Compressed) OR18005 Text Line Number NCHAR 6   3   —
OR18 Order History Text (Compressed) OR18024 Created by MPC Configuration NCHAR 1   — — +
OR19 Order Delivery Lines OR19043 DN Issuer Code NCHAR 6   — — +
OR19 Order Delivery Lines OR19044 Confirmed Arrival Date DATETIME 8   — — +
OR20 HI. Order Head OR20025 Accounting String NVARCHAR 120   50   —
OR20 HI. Order Head OR20072 Customer Purchase Order Number NVARCHAR 30   20   —
OR20 HI. Order Head OR20108 Internal Debiting Accounting String NVARCHAR 120   50   —
OR20 HI. Order Head OR20168 Invoice Issuer Code NCHAR 6   4   —
OR20 HI. Order Head OR20173 Financial Operation Code 2 NVARCHAR 10   — — +
OR20 HI. Order Head OR20174 Drop Shipment Supplier NCHAR 10   — — +
OR20 HI. Order Head OR20175 Instalment NCHAR 1   — — +
OR20 HI. Order Head OR20176 Interest NVARCHAR 6   — — +
OR20 HI. Order Head OR20177 FinCharge NUMERIC 20 8 — — +
OR20 HI. Order Head OR20178 TaxCodeInterest NCHAR 6   — — +
OR20 HI. Order Head OR20179 TaxCodeFinCharge NCHAR 6   — — +
OR20 HI. Order Head OR20180 ActivateNewInterest DATETIME 8   — — +
OR20 HI. Order Head OR20181 NewInterest% NVARCHAR 6   — — +
OR20 HI. Order Head OR20182 Sales Return Reason Code INT 1   — — +
OR20 HI. Order Head OR20183 RMA Reference NCHAR 10   — — +
OR20 HI. Order Head OR20184 Return Comment NVARCHAR 50   — — +
OR20 HI. Order Head OR20185 Kind of Box NVARCHAR 15   — — +
OR20 HI. Order Head OR20186 Box numbering NVARCHAR 15   — — +
OR20 HI. Order Head OR20187 Number of pallets NVARCHAR 15   — — +
OR20 HI. Order Head OR20188 Transport Company Code NVARCHAR 10   — — +
OR20 HI. Order Head OR20189 Vehicle State/Province NVARCHAR 10   — — +
OR20 HI. Order Head OR20190 Vehicle License Plate NVARCHAR 15   — — +
OR20 HI. Order Head OR20191 Freight Payer NCHAR 1   — — +
OR20 HI. Order Head OR20192 Own Freight Tax Code NCHAR 6   — — +
OR20 HI. Order Head OR20193 Orig Terms Payment NVARCHAR 2   — — +
OR20 HI. Order Head OR20194 Contract Number NCHAR 10   — — +
OR20 HI. Order Head OR20195 Shipment Date Actual DATETIME 8   — — +
OR20 HI. Order Head OR20196 Delivery Date Estimated DATETIME 8   — — +
OR20 HI. Order Head OR20197 Title Pass Date DATETIME 8   — — +
OR20 HI. Order Head OR20198 Delivery Note, sort NCHAR 1   — — +
OR20 HI. Order Head OR20199 Auto print DN NVARCHAR 1   — — +
OR20 HI. Order Head OR20200 Auto send DN NVARCHAR 1   — — +
OR20 HI. Order Head OR20201 Release for withdrawal INT 1   — — +
OR20 HI. Order Head OR20202 Delivery note printing INT 1   — — +
OR20 HI. Order Head OR20203 Invoice printing INT 1   — — +
OR20 HI. Order Head OR20204 Create back-order NCHAR 1   — — +
OR20 HI. Order Head OR20205 Order Pricing Number NCHAR 10   — — +
OR20 HI. Order Head OR20206 Auto print Invoice NVARCHAR 1   — — +
OR20 HI. Order Head OR20207 Auto send Invoice NVARCHAR 1   — — +
OR20 HI. Order Head OR20208 District NVARCHAR 2   — — +
OR20 HI. Order Head OR20209 Advertising Code NVARCHAR 2   — — +
OR20 HI. Order Head OR20210 City Code NVARCHAR 4   — — +
OR20 HI. Order Head OR20211 SNI Code NVARCHAR 5   — — +
OR20 HI. Order Head OR20212 Commision Distribution Method NVARCHAR 1   — — +
OR20 HI. Order Head OR20213 Reason Code INT 3   — — +
OR20 HI. Order Head OR20214 Way of payments NVARCHAR 2   — — +
OR20 HI. Order Head OR20215 Bank Code NVARCHAR 10   — — +
OR20 HI. Order Head OR20216 Payment Address Code NVARCHAR 2   — — +
OR20 HI. Order Head OR20217 Accepted Delivery Date DATETIME 8   — — +
OR20 HI. Order Head OR20218 Planned Delivery Time NVARCHAR 20   — — +
OR20 HI. Order Head OR20219 Accepted Delivery Time NVARCHAR 20   — — +
OR20 HI. Order Head OR20220 Sales Return Order No NCHAR 10   — — +
OR20 HI. Order Head OR20221 Sales Return Invoice No NCHAR 15   — — +
OR20 HI. Order Head OR20222 Email address NVARCHAR 200   — — +
OR20 HI. Order Head OR20223 Invoice Time DATETIME 17   — — +
OR20 HI. Order Head OR20224 Partial Delivery Planning NVARCHAR 1   — — +
OR20 HI. Order Head OR20225 Lock Order Payments INT 1   — — +
OR20 HI. Order Head OR20226 Customer for price NCHAR 1   — — +
OR20 HI. Order Head OR20227 Packaging Tax Amount per kg NUMERIC 20 8 — — +
OR20 HI. Order Head OR20228 Credit check passed NCHAR 1   — — +
OR20 HI. Order Head OR20229 Code ANTT NVARCHAR 10   — — +
OR20 HI. Order Head OR20230 Freight Tax Mode NCHAR 1   — — +
OR20 HI. Order Head OR20231 Fiscal Reference NVARCHAR 50   — — +
OR20 HI. Order Head OR20232 Spesometro Forms NVARCHAR 12   — — +
OR20 HI. Order Head OR20233 TaxPoint NCHAR 1   — — +
OR20 HI. Order Head OR20234 Public Procurement Code1 NVARCHAR 20   — — +
OR20 HI. Order Head OR20235 Public Procurement Code2 NVARCHAR 20   — — +
OR20 HI. Order Head OR20236 Fixed Exchange Rate Flag NCHAR 1   — — +
OR20 HI. Order Head OR20237 OCU Exchange Rate 1 NUMERIC 10 8 — — +
OR20 HI. Order Head OR20238 OCU Exchange Algorithm NCHAR 3   — — +
OR20 HI. Order Head OR20239 OCU Exchange Rate 2 NUMERIC 10 8 — — +
OR20 HI. Order Head OR20240 Own Bank Code 1 NCHAR 2   — — +
OR20 HI. Order Head OR20241 Own Bank Code 2 NCHAR 2   — — +
OR20 HI. Order Head OR20242 Bank Account 1 NVARCHAR 34   — — +
OR20 HI. Order Head OR20243 Bank Code 2 NVARCHAR 10   — — +
OR20 HI. Order Head OR20244 Bank Account 2 NVARCHAR 34   — — +
OR20 HI. Order Head OR20245 Tax Registration Date DATETIME 8   — — +
OR20 HI. Order Head OR20246 Contribution to consolidated invoice NUMERIC 20 8 — — +
OR20 HI. Order Head OR20247 Tax Registration Country NCHAR 3   — — +
OR21 History Sales Order Lines OR21010 Unit Code INT 4   2   —
OR21 History Sales Order Lines OR21028 Accounting String NVARCHAR 120   50   —
OR21 History Sales Order Lines OR21114 Confirmed Delivery Date DATETIME 8   — — +
OR21 History Sales Order Lines OR21115 Confirmed Delivery Date Back Order DATETIME 8   — — +
OR21 History Sales Order Lines OR21116 Original Confirmed Delivery Date DATETIME 8   — — +
OR21 History Sales Order Lines OR21117 NomenclatureNo NVARCHAR 25   — — +
OR21 History Sales Order Lines OR21118 Accepted Delivery Date DATETIME 8   — — +
OR21 History Sales Order Lines OR21119 Order Customer Code NCHAR 10   — — +
OR21 History Sales Order Lines OR21120 FinOperationCode NVARCHAR 10   — — +
OR21 History Sales Order Lines OR21121 Order Line Pricing Date DATETIME 8   — — +
OR21 History Sales Order Lines OR21122 Order Pricing Number NCHAR 10   — — +
OR21 History Sales Order Lines OR21123 Requested Delivery Time NVARCHAR 20   — — +
OR21 History Sales Order Lines OR21124 Accepted Delivery Time NVARCHAR 20   — — +
OR21 History Sales Order Lines OR21125 External status INT 4   — — +
OR21 History Sales Order Lines OR21126 Line Price Type INT 1   — — +
OR21 History Sales Order Lines OR21127 Net Unit Price NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21128 Confirmed Production Date DATETIME 8   — — +
OR21 History Sales Order Lines OR21129 Exempt Tax Code NCHAR 2   — — +
OR21 History Sales Order Lines OR21130 Exempt Limit NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21131 Taxable Price NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21132 Accounting Code 2 NCHAR 2   — — +
OR21 History Sales Order Lines OR21133 Delivery Blocked NCHAR 1   — — +
OR21 History Sales Order Lines OR21134 Spare NCHAR 1   — — +
OR21 History Sales Order Lines OR21135 Packaging Tax Amount per kg NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21136 Approved credit limit NCHAR 1   — — +
OR21 History Sales Order Lines OR21137 Product Tax Type NVARCHAR 10   — — +
OR21 History Sales Order Lines OR21138 Line Freight OCU NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21139 Line Freight ICU NUMERIC 20 8 — — +
OR21 History Sales Order Lines OR21140 Inv Prefix NCHAR 4   — — +
OR21 History Sales Order Lines OR21141 Tax Reason Code NCHAR 3   — — +
OR21 History Sales Order Lines OR21142 Confirmed by Planner NCHAR 1   — — +
OR21 History Sales Order Lines OR21143 Extended User defined field 1 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21144 Extended User defined field 2 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21145 Extended User defined field 3 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21146 Extended User defined field 4 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21147 Extended User defined field 5 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21148 Extended User defined field 6 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21149 Extended User defined field 7 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21150 Extended User defined field 8 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21151 Extended User defined field 9 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21152 Extended User defined field 10 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21153 Extended User defined field 11 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21154 Extended User defined field 12 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21155 Extended User defined field 13 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21156 Extended User defined field 14 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21157 Extended User defined field 15 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21158 Extended User defined field 16 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21159 Extended User defined field 17 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21160 Extended User defined field 18 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21161 Extended User defined field 19 NVARCHAR 150   — — +
OR21 History Sales Order Lines OR21162 Extended User defined field 20 NVARCHAR 150   — — +
OR22 HI. Delivery Addresses OR22017 Country Code NVARCHAR 3   — — +
OR22 HI. Delivery Addresses OR22018 Region Code NVARCHAR 10   — — +
OR22 HI. Delivery Addresses OR22019 State/Province Code NVARCHAR 10   — — +
OR22 HI. Delivery Addresses OR22020 County Code NVARCHAR 10   — — +
OR22 HI. Delivery Addresses OR22021 Email address NVARCHAR 200   — — +
OR22 HI. Delivery Addresses OR22022 Address Line 5 NVARCHAR 35   — — +
OR22 HI. Delivery Addresses OR22023 Address Line 6 NVARCHAR 35   — — +
OR22 HI. Delivery Addresses OR22024 Address Line 7 NVARCHAR 35   — — +
OR22 HI. Delivery Addresses OR22025 Customer code NVARCHAR 10   — — +
OR22 HI. Delivery Addresses OR22026 Address No NVARCHAR 2   — — +
OR22 HI. Delivery Addresses OR22027 Tax Registration No NVARCHAR 20   — — +
OR23 HI. Order Delivery Lines OR23043 DN Issuer Code NCHAR 6   — — +
OR23 HI. Order Delivery Lines OR23044 Confirmed Arrival Date DATETIME 8   — — +
OR24 HI. Order Text Lines OR24004 Text Line Number NCHAR 6   3   —
OR24 HI. Order Text Lines OR24025 Created by MPC Configuration NCHAR 1   — — +
OR24 HI. Order Text Lines OR24026 Serial Number Flag NCHAR 1   — — +
OR29 Extended order lines (OR History) OR29018 UDMS Code NCHAR 6   — — +
OR29 Extended order lines (OR History) OR29019 Status INT 1   — — +
OR29 Extended order lines (OR History) OR29020 Original Start Date DATETIME 8   — — +
OR29 Extended order lines (OR History) OR29021 Original Finish Date DATETIME 8   — — +
OR2E History Transport Documents OR2E001 Order Number NUMERIC 10   — — +
OR2E History Transport Documents OR2E002 Net Weight NUMERIC 10 8 — — +
OR2E History Transport Documents OR2E003 No of Packages NUMERIC 2   — — +
OR2E History Transport Documents OR2E004 Transport Details Line 1 NVARCHAR 35   — — +
OR2E History Transport Documents OR2E005 Transport Details Line 2 NVARCHAR 35   — — +
OR2E History Transport Documents OR2E006 Transport Details Line 3 NVARCHAR 35   — — +
OR2E History Transport Documents OR2E007 Transport Details Line 4 NVARCHAR 35   — — +
OR2E History Transport Documents OR2E008 Transport Details Line 5 NVARCHAR 35   — — +
OR2E History Transport Documents OR2E009 Place of Discharge NVARCHAR 15   — — +
OR2E History Transport Documents OR2E010 Package Type NCHAR 10   — — +
OR2E History Transport Documents OR2E011 Marks Line 2 NVARCHAR 15   — — +
OR2E History Transport Documents OR2E012 Marks Line 3 NVARCHAR 15   — — +
OR2E History Transport Documents OR2E013 Marks Line 4 NVARCHAR 15   — — +
OR2E History Transport Documents OR2E014 Content Line 2 NVARCHAR 25   — — +
OR2E History Transport Documents OR2E015 Content Line 3 NVARCHAR 25   — — +
OR2E History Transport Documents OR2E016 (obsolete) NVARCHAR 24   — — +
OR2E History Transport Documents OR2E017 (obsolete) NVARCHAR 13   — — +
OR2E History Transport Documents OR2E018 (obsolete) NVARCHAR 13   — — +
OR2E History Transport Documents OR2E019 (obsolete) NVARCHAR 13   — — +
OR2E History Transport Documents OR2E020 (obsolete) NVARCHAR 13   — — +
OR2E History Transport Documents OR2E021 Gross Weight NUMERIC 10 8 — — +
OR2E History Transport Documents OR2E022 Volume NCHAR 10   — — +
OR2E History Transport Documents OR2E023 Destination NVARCHAR 25   — — +
OR2E History Transport Documents OR2E024 Marks Line 1 NVARCHAR 25   — — +
OR2E History Transport Documents OR2E025 Content Line 1 NVARCHAR 25   — — +
OR2E History Transport Documents OR2E026 Fiscal Code NVARCHAR 16   — — +
OR2E History Transport Documents OR2E027 Transport Form Code INT 6   — — +
OR2E History Transport Documents OR2E028 Loading Place NVARCHAR 30   — — +
OR2E History Transport Documents OR2E029 Border Cross Place NVARCHAR 30   — — +
OR2E History Transport Documents OR2E030 Border Cross Code INT 3   — — +
OR2E History Transport Documents OR2E031 Depart Custom Office NVARCHAR 30   — — +
OR2E History Transport Documents OR2E032 Depart Custom Country NCHAR 3   — — +
OR2E History Transport Documents OR2E033 Dest Custom Office NVARCHAR 30   — — +
OR2E History Transport Documents OR2E034 Dest Custom Country NCHAR 3   — — +
OR2E History Transport Documents OR2E035 Foreign Fees (Order Currency) NUMERIC 20 8 — — +
OR2E History Transport Documents OR2E036 Number of Units INT 4   — — +
OR2E History Transport Documents OR2E037 (obsolete) NVARCHAR 37   — — +
OR2E History Transport Documents OR2E038 Invoice Number NCHAR 15   — — +
OR33 Order Discount Lines OR33017 Parent Discount Line Number INT 9   — — +
OR34 Order Discount Line History OR34017 Parent Discount Line Number INT 9   — — +
OR3L Extended order lines (Sales Order) OR3L018 UDMS Code NCHAR 6   — — +
OR3L Extended order lines (Sales Order) OR3L019 Status INT 1   — — +
OR3L Extended order lines (Sales Order) OR3L020 Original Start Date DATETIME 8   — — +
OR3L Extended order lines (Sales Order) OR3L021 Original Finish Date DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40025 Accounting String NVARCHAR 120   50   —
OR40 Sales Order Header Historical Versions OR40072 Customer Purchase Order Number NVARCHAR 30   20   —
OR40 Sales Order Header Historical Versions OR40108 Internal Debiting Accounting String NVARCHAR 120   50   —
OR40 Sales Order Header Historical Versions OR40168 Invoice Issuer Code NCHAR 6   4   —
OR40 Sales Order Header Historical Versions OR40173 Financial Operation Code 2 NVARCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40174 Drop Shipment Supplier NCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40175 Instalment NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40176 Interest NVARCHAR 6   — — +
OR40 Sales Order Header Historical Versions OR40177 FinCharge NUMERIC 20 8 — — +
OR40 Sales Order Header Historical Versions OR40178 TaxCodeInterest NCHAR 6   — — +
OR40 Sales Order Header Historical Versions OR40179 TaxCodeFinCharge NCHAR 6   — — +
OR40 Sales Order Header Historical Versions OR40180 ActivateNewInterest DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40181 NewInterest% NVARCHAR 6   — — +
OR40 Sales Order Header Historical Versions OR40182 Sales Return Reason Code INT 1   — — +
OR40 Sales Order Header Historical Versions OR40183 RMA Reference NCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40184 Return Comment NVARCHAR 50   — — +
OR40 Sales Order Header Historical Versions OR40185 Kind of Box NVARCHAR 15   — — +
OR40 Sales Order Header Historical Versions OR40186 Box numbering NVARCHAR 15   — — +
OR40 Sales Order Header Historical Versions OR40187 Number of pallets NVARCHAR 15   — — +
OR40 Sales Order Header Historical Versions OR40188 Transport Company Code NVARCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40189 Vehicle State/Province NVARCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40190 Vehicle License Plate NVARCHAR 15   — — +
OR40 Sales Order Header Historical Versions OR40191 Freight Payer NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40192 Own Freight Tax Code NCHAR 6   — — +
OR40 Sales Order Header Historical Versions OR40193 Orig Terms Payment NVARCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40194 Contract Number NCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40195 Shipment Date Actual DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40196 Delivery Date Estimated DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40197 Title Pass Date DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40198 Delivery Note, sort NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40199 Auto print DN NVARCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40200 Auto send DN NVARCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40201 Release for withdrawal INT 1   — — +
OR40 Sales Order Header Historical Versions OR40202 Delivery note printing INT 1   — — +
OR40 Sales Order Header Historical Versions OR40203 Invoice printing INT 1   — — +
OR40 Sales Order Header Historical Versions OR40204 Create back-order NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40205 Order Pricing Number NCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40206 Auto print Invoice NVARCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40207 Auto send Invoice NVARCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40208 District NVARCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40209 Advertising Code NVARCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40210 City Code NVARCHAR 4   — — +
OR40 Sales Order Header Historical Versions OR40211 SNI Code NVARCHAR 5   — — +
OR40 Sales Order Header Historical Versions OR40212 Commision Distribution Method NVARCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40213 Reason Code INT 3   — — +
OR40 Sales Order Header Historical Versions OR40214 Way of payments NVARCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40215 Bank Code NVARCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40216 Payment Address Code NVARCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40217 Accepted Delivery Date DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40218 Planned Delivery Time NVARCHAR 20   — — +
OR40 Sales Order Header Historical Versions OR40219 Accepted Delivery Time NVARCHAR 20   — — +
OR40 Sales Order Header Historical Versions OR40220 Sales Return Order No NCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40221 Sales Return Invoice No NCHAR 15   — — +
OR40 Sales Order Header Historical Versions OR40222 Email address NVARCHAR 200   — — +
OR40 Sales Order Header Historical Versions OR40223 Invoice Time DATETIME 17   — — +
OR40 Sales Order Header Historical Versions OR40224 Partial Delivery Planning NVARCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40225 Lock Order Payments INT 1   — — +
OR40 Sales Order Header Historical Versions OR40226 Customer for price NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40227 Packaging Tax Amount per kg NUMERIC 20 8 — — +
OR40 Sales Order Header Historical Versions OR40228 Credit check passed NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40229 Code ANTT NVARCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40230 Freight Tax Mode NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40231 Fiscal Reference NVARCHAR 50   — — +
OR40 Sales Order Header Historical Versions OR40232 Spesometro Forms NVARCHAR 12   — — +
OR40 Sales Order Header Historical Versions OR40233 TaxPoint NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40234 Public Procurement Code1 NVARCHAR 20   — — +
OR40 Sales Order Header Historical Versions OR40235 Public Procurement Code2 NVARCHAR 20   — — +
OR40 Sales Order Header Historical Versions OR40236 Fixed Exchange Rate Flag NCHAR 1   — — +
OR40 Sales Order Header Historical Versions OR40237 OCU Exchange Rate 1 NUMERIC 10 8 — — +
OR40 Sales Order Header Historical Versions OR40238 OCU Exchange Algorithm NCHAR 3   — — +
OR40 Sales Order Header Historical Versions OR40239 OCU Exchange Rate 2 NUMERIC 10 8 — — +
OR40 Sales Order Header Historical Versions OR40240 Own Bank Code 1 NCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40241 Own Bank Code 2 NCHAR 2   — — +
OR40 Sales Order Header Historical Versions OR40242 Bank Account 1 NVARCHAR 34   — — +
OR40 Sales Order Header Historical Versions OR40243 Bank Code 2 NVARCHAR 10   — — +
OR40 Sales Order Header Historical Versions OR40244 Bank Account 2 NVARCHAR 34   — — +
OR40 Sales Order Header Historical Versions OR40245 Tax Registration Date DATETIME 8   — — +
OR40 Sales Order Header Historical Versions OR40246 Contribution to consolidated invoice NUMERIC 20 8 — — +
OR40 Sales Order Header Historical Versions OR40247 Tax Registration Country NCHAR 3   — — +
OR41 Sales Order Lines Historical Versions OR41010 Unit Code INT 4   2   —
OR41 Sales Order Lines Historical Versions OR41028 Accounting String NVARCHAR 120   50   —
OR41 Sales Order Lines Historical Versions OR41114 Confirmed Delivery Date DATETIME 8   — — +
OR41 Sales Order Lines Historical Versions OR41115 Confirmed Delivery Date Back Order DATETIME 8   — — +
OR41 Sales Order Lines Historical Versions OR41116 Original Confirmed Delivery Date DATETIME 8   — — +
OR41 Sales Order Lines Historical Versions OR41117 NomenclatureNo NVARCHAR 25   — — +
OR41 Sales Order Lines Historical Versions OR41118 Accepted Delivery Date DATETIME 8   — — +
OR41 Sales Order Lines Historical Versions OR41119 Order Customer Code NCHAR 10   — — +
OR41 Sales Order Lines Historical Versions OR41120 FinOperationCode NVARCHAR 10   — — +
OR41 Sales Order Lines Historical Versions OR41121 Order Line Pricing Date DATETIME 8   — — +
OR41 Sales Order Lines Historical Versions OR41122 Order Pricing Number NCHAR 10   — — +
OR41 Sales Order Lines Historical Versions OR41123 Requested Delivery Time NVARCHAR 20   — — +
OR41 Sales Order Lines Historical Versions OR41124 Accepted Delivery Time NVARCHAR 20   — — +
OR41 Sales Order Lines Historical Versions OR41125 External status INT 4   — — +
OR41 Sales Order Lines Historical Versions OR41126 Line Price Type INT 1   — — +
OR41 Sales Order Lines Historical Versions OR41127 Net Unit Price NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41128 Confirmed Production Date DATETIME 8   — — +
OR41 Sales Order Lines Historical Versions OR41129 Exempt Tax Code NCHAR 2   — — +
OR41 Sales Order Lines Historical Versions OR41130 Exempt Limit NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41131 Taxable Price NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41132 Accounting Code 2 NCHAR 2   — — +
OR41 Sales Order Lines Historical Versions OR41133 Delivery Blocked NCHAR 1   — — +
OR41 Sales Order Lines Historical Versions OR41134 Spare NCHAR 1   — — +
OR41 Sales Order Lines Historical Versions OR41135 Packaging Tax Amount per kg NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41136 Approved credit limit NCHAR 1   — — +
OR41 Sales Order Lines Historical Versions OR41137 Product Tax Type NVARCHAR 10   — — +
OR41 Sales Order Lines Historical Versions OR41138 Line Freight OCU NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41139 Line Freight ICU NUMERIC 20 8 — — +
OR41 Sales Order Lines Historical Versions OR41140 Inv Prefix NCHAR 4   — — +
OR41 Sales Order Lines Historical Versions OR41141 Tax Reason Code NCHAR 3   — — +
OR41 Sales Order Lines Historical Versions OR41142 Confirmed by Planner NCHAR 1   — — +
OR41 Sales Order Lines Historical Versions OR41143 Extended User defined field 1 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41144 Extended User defined field 2 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41145 Extended User defined field 3 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41146 Extended User defined field 4 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41147 Extended User defined field 5 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41148 Extended User defined field 6 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41149 Extended User defined field 7 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41150 Extended User defined field 8 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41151 Extended User defined field 9 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41152 Extended User defined field 10 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41153 Extended User defined field 11 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41154 Extended User defined field 12 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41155 Extended User defined field 13 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41156 Extended User defined field 14 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41157 Extended User defined field 15 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41158 Extended User defined field 16 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41159 Extended User defined field 17 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41160 Extended User defined field 18 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41161 Extended User defined field 19 NVARCHAR 150   — — +
OR41 Sales Order Lines Historical Versions OR41162 Extended User defined field 20 NVARCHAR 150   — — +
OR42 Sales Order Text Line Historical Versions OR42004 Text Line Number NCHAR 6   3   —
OR42 Sales Order Text Line Historical Versions OR42025 Created by MPC Configuration NCHAR 1   — — +
OR42 Sales Order Text Line Historical Versions OR42026 Serial Number Flag NCHAR 1   — — +
OR43 Sales Order Delivery Address Historical Versions OR43017 Country Code NVARCHAR 3   — — +
OR43 Sales Order Delivery Address Historical Versions OR43018 Region Code NVARCHAR 10   — — +
OR43 Sales Order Delivery Address Historical Versions OR43019 State/Province Code NVARCHAR 10   — — +
OR43 Sales Order Delivery Address Historical Versions OR43020 County Code NVARCHAR 10   — — +
OR43 Sales Order Delivery Address Historical Versions OR43021 Email address NVARCHAR 200   — — +
OR43 Sales Order Delivery Address Historical Versions OR43022 Address Line 5 NVARCHAR 35   — — +
OR43 Sales Order Delivery Address Historical Versions OR43023 Address Line 6 NVARCHAR 35   — — +
OR43 Sales Order Delivery Address Historical Versions OR43024 Address Line 7 NVARCHAR 35   — — +
OR43 Sales Order Delivery Address Historical Versions OR43025 Customer code NVARCHAR 10   — — +
OR43 Sales Order Delivery Address Historical Versions OR43026 Address No NVARCHAR 2   — — +
OR43 Sales Order Delivery Address Historical Versions OR43027 Tax Registration No NVARCHAR 20   — — +
OR44 Sales Order Advanced Discount Line Historical Versions OR44017 Parent Discount Line Number INT 9   — — +
OR45 Sales Order Extended Order Line Historical Versions OR45018 UDMS Code NCHAR 6   — — +
OR45 Sales Order Extended Order Line Historical Versions OR45019 Status INT 1   — — +
OR45 Sales Order Extended Order Line Historical Versions OR45020 Original Start Date DATETIME 8   — — +
OR45 Sales Order Extended Order Line Historical Versions OR45021 Original Finish Date DATETIME 8   — — +
OR50 Packaging Material per Sales Order Line OR50001 Order Number NCHAR 10   — — +
OR50 Packaging Material per Sales Order Line OR50002 Order Line Number NCHAR 6   — — +
OR50 Packaging Material per Sales Order Line OR50003 Structure Line Number NCHAR 6   — — +
OR50 Packaging Material per Sales Order Line OR50004 Material Code 1 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50005 Weight 1 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50006 Material Code 2 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50007 Weight 2 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50008 Material Code 3 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50009 Weight 3 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50010 Material Code 4 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50011 Weight 4 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50012 Material Code 5 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50013 Weight 5 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50014 Material Code 6 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50015 Weight 6 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50016 Material Code 7 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50017 Weight 7 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50018 Material Code 8 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50019 Weight 8 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50020 Material Code 9 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50021 Weight 9 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50022 Material Code 10 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50023 Weight 10 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50024 Material Code 11 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50025 Weight 11 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50026 Material Code 12 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50027 Weight 12 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50028 Material Code 13 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50029 Weight 13 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50030 Material Code 14 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50031 Weight 14 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50032 Material Code 15 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50033 Weight 15 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50034 Material Code 16 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50035 Weight 16 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50036 Material Code 17 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50037 Weight 17 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50038 Material Code 18 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50039 Weight 18 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50040 Material Code 19 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50041 Weight 19 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50042 Material Code 20 NVARCHAR 5   — — +
OR50 Packaging Material per Sales Order Line OR50043 Weight 20 NUMERIC 10 8 — — +
OR50 Packaging Material per Sales Order Line OR50044 Invoice Number (dummy) NCHAR 15   — — +
OR51 Packaging Material per Sales Order Line, history OR51001 Order Number NCHAR 10   — — +
OR51 Packaging Material per Sales Order Line, history OR51002 Order Line Number NCHAR 6   — — +
OR51 Packaging Material per Sales Order Line, history OR51003 Structure Line Number NCHAR 6   — — +
OR51 Packaging Material per Sales Order Line, history OR51004 Material Code 1 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51005 Weight 1 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51006 Material Code 2 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51007 Weight 2 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51008 Material Code 3 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51009 Weight 3 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51010 Material Code 4 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51011 Weight 4 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51012 Material Code 5 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51013 Weight 5 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51014 Material Code 6 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51015 Weight 6 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51016 Material Code 7 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51017 Weight 7 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51018 Material Code 8 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51019 Weight 8 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51020 Material Code 9 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51021 Weight 9 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51022 Material Code 10 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51023 Weight 10 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51024 Material Code 11 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51025 Weight 11 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51026 Material Code 12 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51027 Weight 12 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51028 Material Code 13 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51029 Weight 13 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51030 Material Code 14 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51031 Weight 14 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51032 Material Code 15 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51033 Weight 15 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51034 Material Code 16 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51035 Weight 16 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51036 Material Code 17 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51037 Weight 17 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51038 Material Code 18 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51039 Weight 18 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51040 Material Code 19 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51041 Weight 19 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51042 Material Code 20 NVARCHAR 5   — — +
OR51 Packaging Material per Sales Order Line, history OR51043 Weight 20 NUMERIC 10 8 — — +
OR51 Packaging Material per Sales Order Line, history OR51044 Invoice Number (dummy) NCHAR 15   — — +
OR52 Packaging Material per Sales Order Line, version history OR52001 Order Number NCHAR 10   — — +
OR52 Packaging Material per Sales Order Line, version history OR52002 Order Line Number NCHAR 6   — — +
OR52 Packaging Material per Sales Order Line, version history OR52003 Structure Line Number NCHAR 6   — — +
OR52 Packaging Material per Sales Order Line, version history OR52004 Material Code 1 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52005 Weight 1 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52006 Material Code 2 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52007 Weight 2 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52008 Material Code 3 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52009 Weight 3 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52010 Material Code 4 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52011 Weight 4 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52012 Material Code 5 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52013 Weight 5 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52014 Material Code 6 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52015 Weight 6 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52016 Material Code 7 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52017 Weight 7 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52018 Material Code 8 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52019 Weight 8 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52020 Material Code 9 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52021 Weight 9 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52022 Material Code 10 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52023 Weight 10 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52024 Material Code 11 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52025 Weight 11 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52026 Material Code 12 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52027 Weight 12 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52028 Material Code 13 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52029 Weight 13 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52030 Material Code 14 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52031 Weight 14 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52032 Material Code 15 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52033 Weight 15 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52034 Material Code 16 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52035 Weight 16 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52036 Material Code 17 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52037 Weight 17 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52038 Material Code 18 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52039 Weight 18 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52040 Material Code 19 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52041 Weight 19 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52042 Material Code 20 NVARCHAR 5   — — +
OR52 Packaging Material per Sales Order Line, version history OR52043 Weight 20 NUMERIC 10 8 — — +
OR52 Packaging Material per Sales Order Line, version history OR52044 Version number NCHAR 4   — — +
OR91 Export Invoice OR91038 (dummy) NCHAR 15   — — +
ORB4 OR BOM Branch ORB4017 Unit Code INT 4   2   —
ORH4 BOM Branch ORH4017 Unit Code INT 4   2   —
ORI2 Instalments ORI2001 OrderNumber NCHAR 10   — — +
ORI2 Instalments ORI2002 InstallmentNumber INT 3   — — +
ORI2 Instalments ORI2003 DateCalculation INT 3   — — +
ORI2 Instalments ORI2004 Percentage% NVARCHAR 6   — — +
ORI2 Instalments ORI2005 WayOfPayment NVARCHAR 2   — — +
ORI4 Instalments History ORI4001 OrderNumber NCHAR 10   — — +
ORI4 Instalments History ORI4002 InvoiceNo NCHAR 15   — — +
ORI4 Instalments History ORI4003 InstallmentNumber INT 3   — — +
ORI4 Instalments History ORI4004 DateCalculation INT 3   — — +
ORI4 Instalments History ORI4005 Percentage% NVARCHAR 6   — — +
ORI4 Instalments History ORI4006 WayOfPayment NVARCHAR 2   — — +
ORN1 Order Notes ORN1001 Order Number NCHAR 10   — — +
ORN1 Order Notes ORN1002 Sequence Number INT 4   — — +
ORN1 Order Notes ORN1003 Type INT 4   — — +
ORN1 Order Notes ORN1004 Source NVARCHAR 35   — — +
ORN1 Order Notes ORN1005 Date DATETIME 8   — — +
ORN1 Order Notes ORN1006 Time (hhmm) NCHAR 4   — — +
ORN1 Order Notes ORN1007 Header NVARCHAR 50   — — +
ORN1 Order Notes ORN1008 Body NVARCHAR 256   — — +
ORN1 Order Notes ORN1009 Invoice NCHAR 15   — — +
ORN1 Order Notes ORN1010 Version number NVARCHAR 4   — — +
ORN1 Order Notes ORN1011 Line number NVARCHAR 6   — — +
ORN1 Order Notes ORN1012 Structure Line Number NVARCHAR 6   — — +
ORN2 Order Notes history ORN2001 Order Number NCHAR 10   — — +
ORN2 Order Notes history ORN2002 Sequence Number INT 4   — — +
ORN2 Order Notes history ORN2003 Type INT 4   — — +
ORN2 Order Notes history ORN2004 Source NVARCHAR 35   — — +
ORN2 Order Notes history ORN2005 Date DATETIME 8   — — +
ORN2 Order Notes history ORN2006 Time (hhmm) NCHAR 4   — — +
ORN2 Order Notes history ORN2007 Header NVARCHAR 50   — — +
ORN2 Order Notes history ORN2008 Body NVARCHAR 256   — — +
ORN2 Order Notes history ORN2009 Invoice NCHAR 15   — — +
ORN2 Order Notes history ORN2010 Version number NVARCHAR 4   — — +
ORN2 Order Notes history ORN2011 Line number NVARCHAR 6   — — +
ORN2 Order Notes history ORN2012 Structure Line Number NVARCHAR 6   — — +
ORN3 Notes version history ORN3001 OrderNumber NCHAR 10   — — +
ORN3 Notes version history ORN3002 SequenceNumber INT 4   — — +
ORN3 Notes version history ORN3003 Type INT 4   — — +
ORN3 Notes version history ORN3004 Source NVARCHAR 35   — — +
ORN3 Notes version history ORN3005 Date DATETIME 8   — — +
ORN3 Notes version history ORN3006 Time(hhmm) NCHAR 4   — — +
ORN3 Notes version history ORN3007 Header NVARCHAR 50   — — +
ORN3 Notes version history ORN3008 Body NVARCHAR 256   — — +
ORN3 Notes version history ORN3009 Invoice NCHAR 15   — — +
ORN3 Notes version history ORN3010 Version number NCHAR 4   — — +
ORN3 Notes version history ORN3011 Line number NVARCHAR 6   — — +
ORN3 Notes version history ORN3012 Structure Line Number NVARCHAR 6   — — +
ORR1 Original Order Link ORR1001 Order Number NCHAR 10   — — +
ORR1 Original Order Link ORR1002 Line Number NCHAR 6   — — +
ORR1 Original Order Link ORR1003 Subline Number NCHAR 6   — — +
ORR1 Original Order Link ORR1004 Invoice Number NCHAR 15   — — +
ORR1 Original Order Link ORR1005 Original Order Number NCHAR 10   — — +
ORR1 Original Order Link ORR1006 Original Invoice Number NCHAR 15   — — +
ORR1 Original Order Link ORR1007 Reversed Quantity NUMERIC 20 8 — — +
ORR1 Original Order Link ORR1008 Spare DATETIME 17   — — +
ORR1 Original Order Link ORR1009 Spare NVARCHAR 50   — — +
ORR1 Original Order Link ORR1010 Spare NVARCHAR 50   — — +
ORR2 History Original Order Link ORR2001 Order Number NCHAR 10   — — +
ORR2 History Original Order Link ORR2002 Line Number NCHAR 6   — — +
ORR2 History Original Order Link ORR2003 Subline Number NCHAR 6   — — +
ORR2 History Original Order Link ORR2004 Invoice Number NCHAR 15   — — +
ORR2 History Original Order Link ORR2005 Original Order Number NCHAR 10   — — +
ORR2 History Original Order Link ORR2006 Original Invoice Number NCHAR 15   — — +
ORR2 History Original Order Link ORR2007 Reversed Quantity NUMERIC 20 8 — — +
ORR2 History Original Order Link ORR2008 Spare DATETIME 17   — — +
ORR2 History Original Order Link ORR2009 Spare NVARCHAR 50   — — +
ORR2 History Original Order Link ORR2010 Spare NVARCHAR 50   — — +
ORT1 Sales Order Tax Transactions ORT1001 Order Line Number NVARCHAR 15   — — +
ORT1 Sales Order Tax Transactions ORT1002 Customer Code NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1003 Transaction Type NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1004 TaxCode/RateCode NVARCHAR 2   — — +
ORT1 Sales Order Tax Transactions ORT1005 Transaction Date DATETIME 8   — — +
ORT1 Sales Order Tax Transactions ORT1006 Invoice Date DATETIME 8   — — +
ORT1 Sales Order Tax Transactions ORT1007 Base Amount NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1008 Tax Amount NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1009 Remark NVARCHAR 4   — — +
ORT1 Sales Order Tax Transactions ORT1010 Transaction Number NVARCHAR 9   — — +
ORT1 Sales Order Tax Transactions ORT1011 Cash Method NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1012 Invoice Number Old (Italian Cash Method) NVARCHAR 60   — — +
ORT1 Sales Order Tax Transactions ORT1013 Invoice Date Old (Italian Cash Method) DATETIME 8   — — +
ORT1 Sales Order Tax Transactions ORT1014 Internal Table Version NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1015 Expanded Macro NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1016 Reported NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1017 Transaction Nature NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1018 Sales Tax Percent NVARCHAR 8   — — +
ORT1 Sales Order Tax Transactions ORT1019 Tax Code NCHAR 6   — — +
ORT1 Sales Order Tax Transactions ORT1020 Tax Type NCHAR 6   — — +
ORT1 Sales Order Tax Transactions ORT1021 Transaction Line Number NCHAR 7   — — +
ORT1 Sales Order Tax Transactions ORT1022 Tax Liability Code NCHAR 6   — — +
ORT1 Sales Order Tax Transactions ORT1023 Tax Classification Code NCHAR 2   — — +
ORT1 Sales Order Tax Transactions ORT1024 Tax Certificate NCHAR 15   — — +
ORT1 Sales Order Tax Transactions ORT1025 Payment Number NCHAR 2   — — +
ORT1 Sales Order Tax Transactions ORT1026 Stock Item Code NVARCHAR 35   — — +
ORT1 Sales Order Tax Transactions ORT1027 Original Batch Number NVARCHAR 12   — — +
ORT1 Sales Order Tax Transactions ORT1028 Tax Calculation Method INT 2   — — +
ORT1 Sales Order Tax Transactions ORT1029 Rate Type NCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1030 Tax Base Type INT 2   — — +
ORT1 Sales Order Tax Transactions ORT1031 Tax Exemption Type NCHAR 2   — — +
ORT1 Sales Order Tax Transactions ORT1032 Tax Exemption Rate NUMERIC 12 8 — — +
ORT1 Sales Order Tax Transactions ORT1033 Tax Rate NUMERIC 8 8 — — +
ORT1 Sales Order Tax Transactions ORT1034 Tributary Situation Code NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1035 CVF Code NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1036 Sales Order Number NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1037 Fiscal Text Code NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1038 Tributary Substitution Amount (Local Currency) NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1039 Tributary Substitution Amount (Local Currency) NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1040 Tax Category NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1041 Original Company NVARCHAR 2   — — +
ORT1 Sales Order Tax Transactions ORT1042 Margin Percent NUMERIC 12 8 — — +
ORT1 Sales Order Tax Transactions ORT1043 Fixed Price (Local Currency) NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1044 Accepted Difference NUMERIC 12 8 — — +
ORT1 Sales Order Tax Transactions ORT1045 Resolution Name NVARCHAR 40   — — +
ORT1 Sales Order Tax Transactions ORT1046 Resolution Date DATETIME 8   — — +
ORT1 Sales Order Tax Transactions ORT1047 InvoiceRefer NVARCHAR 25   — — +
ORT1 Sales Order Tax Transactions ORT1048 Original Currency Code NVARCHAR 2   — — +
ORT1 Sales Order Tax Transactions ORT1049 Base Amount (Original Currency) NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1050 VAT Type NVARCHAR 6   — — +
ORT1 Sales Order Tax Transactions ORT1051 Accounting Info NVARCHAR 120   — — +
ORT1 Sales Order Tax Transactions ORT1052 Line Ref SL04 NVARCHAR 7   — — +
ORT1 Sales Order Tax Transactions ORT1053 Financial Year NVARCHAR 4   — — +
ORT1 Sales Order Tax Transactions ORT1054 Ref GL06 NVARCHAR 9   — — +
ORT1 Sales Order Tax Transactions ORT1055 Direct from GL NVARCHAR 1   — — +
ORT1 Sales Order Tax Transactions ORT1056 Surcharge Tax Code NVARCHAR 6   — — +
ORT1 Sales Order Tax Transactions ORT1057 AAS code NVARCHAR 25   — — +
ORT1 Sales Order Tax Transactions ORT1058 Order Line Number NCHAR 12   — — +
ORT1 Sales Order Tax Transactions ORT1059 Reference to PL Invoice NVARCHAR 25   — — +
ORT1 Sales Order Tax Transactions ORT1060 ReferPLSupplier NVARCHAR 10   — — +
ORT1 Sales Order Tax Transactions ORT1061 Actual Tax Base NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1062 Freight Tax Amount NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1063 Destination Rate NUMERIC 8 8 — — +
ORT1 Sales Order Tax Transactions ORT1064 Tax Description NVARCHAR 30   — — +
ORT1 Sales Order Tax Transactions ORT1065 Invoice Line No NVARCHAR 6   — — +
ORT1 Sales Order Tax Transactions ORT1066 Tax Amount OCU NUMERIC 20 8 — — +
ORT1 Sales Order Tax Transactions ORT1067 HMRC Period Key NVARCHAR 4   — — +
ORT1 Sales Order Tax Transactions ORT1068 Tax Registration Country NCHAR 3   — — +
ORTF Order Template foreign description ORTF001 Order Template ID NCHAR 4   — — +
ORTF Order Template foreign description ORTF002 Language Code NCHAR 3   — — +
ORTF Order Template foreign description ORTF003 Description NVARCHAR 25   — — +
ORTH Order Template header ORTH001 Order Template ID NCHAR 4   — — +
ORTH Order Template header ORTH002 Description NVARCHAR 25   — — +
ORTH Order Template header ORTH003 Horizontal scroll NCHAR 1   — — +
ORTH Order Template header ORTH004 Frozen columns INT 2   — — +
ORTH Order Template header ORTH005 Applicable to order type 0 NCHAR 1   — — +
ORTH Order Template header ORTH006 Permission order type 0 INT 2   — — +
ORTH Order Template header ORTH007 Default for order type 0 NCHAR 1   — — +
ORTH Order Template header ORTH008 Applicable to order type 1 NCHAR 1   — — +
ORTH Order Template header ORTH009 Permission order type 1 INT 2   — — +
ORTH Order Template header ORTH010 Default for order type 1 NCHAR 1   — — +
ORTH Order Template header ORTH011 Applicable to order type 2 NCHAR 1   — — +
ORTH Order Template header ORTH012 Permission order type 2 INT 2   — — +
ORTH Order Template header ORTH013 Default for order type 2 NCHAR 1   — — +
ORTH Order Template header ORTH014 Applicable to order type 3 NCHAR 1   — — +
ORTH Order Template header ORTH015 Permission order type 3 INT 2   — — +
ORTH Order Template header ORTH016 Default for order type 3 NCHAR 1   — — +
ORTH Order Template header ORTH017 Applicable to order type 4 NCHAR 1   — — +
ORTH Order Template header ORTH018 Permission order type 4 INT 2   — — +
ORTH Order Template header ORTH019 Default for order type 4 NCHAR 1   — — +
ORTH Order Template header ORTH020 Applicable to order type 5 NCHAR 1   — — +
ORTH Order Template header ORTH021 Permission order type 5 INT 2   — — +
ORTH Order Template header ORTH022 Default for order type 5 NCHAR 1   — — +
ORTH Order Template header ORTH023 Applicable to order type 6 NCHAR 1   — — +
ORTH Order Template header ORTH024 Permission order type 6 INT 2   — — +
ORTH Order Template header ORTH025 Default for order type 6 NCHAR 1   — — +
ORTH Order Template header ORTH026 Applicable to order type 7 NCHAR 1   — — +
ORTH Order Template header ORTH027 Permission order type 7 INT 2   — — +
ORTH Order Template header ORTH028 Default for order type 7 NCHAR 1   — — +
ORTH Order Template header ORTH029 Applicable to order type 8 NCHAR 1   — — +
ORTH Order Template header ORTH030 Permission order type 8 INT 2   — — +
ORTH Order Template header ORTH031 Default for order type 8 NCHAR 1   — — +
ORTH Order Template header ORTH032 Applicable to order type 9 NCHAR 1   — — +
ORTH Order Template header ORTH033 Permission order type 9 INT 2   — — +
ORTH Order Template header ORTH034 Default for order type 9 NCHAR 1   — — +
ORTH Order Template header ORTH035 Template Property 1 NCHAR 1   — — +
ORTH Order Template header ORTH036 Template Property 2 NCHAR 1   — — +
ORTH Order Template header ORTH037 Template Property 3 NCHAR 1   — — +
ORTH Order Template header ORTH038 Template Property 4 NCHAR 1   — — +
ORTH Order Template header ORTH039 Template Property 5 NCHAR 1   — — +
ORTH Order Template header ORTH040 Template Property 6 NCHAR 1   — — +
ORTH Order Template header ORTH041 Foreground rw INT 10   — — +
ORTH Order Template header ORTH042 Background rw INT 10   — — +
ORTH Order Template header ORTH043 Foreground ro + cmd INT 10   — — +
ORTH Order Template header ORTH044 Background ro + cmd INT 10   — — +
ORTH Order Template header ORTH045 Foreground ro INT 10   — — +
ORTH Order Template header ORTH046 Background ro INT 10   — — +
ORTH Order Template header ORTH047 Foreground Linked INT 10   — — +
ORTH Order Template header ORTH048 Background Linked INT 10   — — +
ORTH Order Template header ORTH049 Query Template 0 NCHAR 1   — — +
ORTH Order Template header ORTH050 Query Template 1 NCHAR 1   — — +
ORTH Order Template header ORTH051 Query Template 2 NCHAR 1   — — +
ORTH Order Template header ORTH052 Query Template 3 NCHAR 1   — — +
ORTH Order Template header ORTH053 Query Template 4 NCHAR 1   — — +
ORTH Order Template header ORTH054 Query Template 5 NCHAR 1   — — +
ORTH Order Template header ORTH055 Query Template 6 NCHAR 1   — — +
ORTH Order Template header ORTH056 Query Template 7 NCHAR 1   — — +
ORTH Order Template header ORTH057 Query Template 8 NCHAR 1   — — +
ORTH Order Template header ORTH058 Query Template 9 NCHAR 1   — — +
ORTL Order Template columns ORTL001 Order Template ID NCHAR 4   — — +
ORTL Order Template columns ORTL002 Column INT 3   — — +
ORTL Order Template columns ORTL003 Field number INT 3   — — +
ORTL Order Template columns ORTL004 Field Property 1 NCHAR 1   — — +
ORTL Order Template columns ORTL005 Field Property 2 NCHAR 1   — — +
ORTL Order Template columns ORTL006 Field Property 3 NCHAR 1   — — +
ORTL Order Template columns ORTL007 Field Property 4 NCHAR 1   — — +
ORTL Order Template columns ORTL008 Field Property 5 NCHAR 1   — — +
ORTL Order Template columns ORTL009 Field Property 6 NCHAR 1   — — +
ORV4 BOM Node Branch for version history ORV4017 Unit Code INT 4   2   —
ORWA Order Work A ORWA008 TAGLineNo NVARCHAR 6   3   —
ORXY Closing Ord.Wrk ORXY001 xycodestr NVARCHAR 120   50   —
ORXY Closing Ord.Wrk ORXY006 xy.vat NVARCHAR 6   — — +
ORXY Closing Ord.Wrk ORXY007 xy.vtype NVARCHAR 6   — — +