Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

На один уровень вверх / 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   +