Название Таблицы / 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? |
PC01 | Purchase Order Head | PC01017 | Our Reference | NVARCHAR | 35 | 20 | — | ||
PC01 | Purchase Order Head | PC01018 | Your Reference | NVARCHAR | 35 | 20 | — | ||
PC01 | Purchase Order Head | PC01033 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PC01 | Purchase Order Head | PC01058 | Customer Purchase Order Number | NVARCHAR | 30 | 20 | — | ||
PC01 | Purchase Order Head | PC01066 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC01 | Purchase Order Head | PC01073 | User ID for entry | NVARCHAR | 8 | — | — | + | |
PC01 | Purchase Order Head | PC01074 | Tax Liability | NCHAR | 6 | — | — | + | |
PC01 | Purchase Order Head | PC01075 | Operation Type | NVARCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01076 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01077 | Fiscal Text Code | NVARCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01078 | Number of printed Fiscal Note | NVARCHAR | 25 | — | — | + | |
PC01 | Purchase Order Head | PC01079 | Date of printed Fiscal Note | DATETIME | 8 | — | — | + | |
PC01 | Purchase Order Head | PC01080 | Instalment | NCHAR | 1 | — | — | + | |
PC01 | Purchase Order Head | PC01081 | Net Weight | NUMERIC | 10 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01082 | Gross Weight | NUMERIC | 10 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01083 | Number of Boxes | NUMERIC | 10 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01084 | Kind of Box | NVARCHAR | 15 | — | — | + | |
PC01 | Purchase Order Head | PC01085 | Box numbering | NVARCHAR | 15 | — | — | + | |
PC01 | Purchase Order Head | PC01086 | Number of pallets | NVARCHAR | 15 | — | — | + | |
PC01 | Purchase Order Head | PC01087 | Transport Company Code | NVARCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01088 | Freight Amount | NUMERIC | 20 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01089 | Packing Amount | NUMERIC | 20 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01090 | Insurance Amount | NUMERIC | 20 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01091 | Invoicing Fee | NUMERIC | 20 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01092 | Own Freight Amount | NUMERIC | 20 | 8 | — | — | + |
PC01 | Purchase Order Head | PC01093 | Vehicle State/Province | NVARCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01094 | Vehicle License Plate | NVARCHAR | 15 | — | — | + | |
PC01 | Purchase Order Head | PC01095 | Freight Tax Code | NCHAR | 6 | — | — | + | |
PC01 | Purchase Order Head | PC01096 | Packing Tax Code | NCHAR | 6 | — | — | + | |
PC01 | Purchase Order Head | PC01097 | Insurance Tax Code | NCHAR | 6 | — | — | + | |
PC01 | Purchase Order Head | PC01098 | Invoicing Tax Code | NCHAR | 6 | — | — | + | |
PC01 | Purchase Order Head | PC01099 | Own Freight Tax Code | NCHAR | 6 | — | — | + | |
PC01 | Purchase Order Head | PC01100 | Reason Code | INT | 3 | — | — | + | |
PC01 | Purchase Order Head | PC01101 | Email address | NVARCHAR | 200 | — | — | + | |
PC01 | Purchase Order Head | PC01102 | Org. Req. Delivery Date | DATETIME | 8 | — | — | + | |
PC01 | Purchase Order Head | PC01103 | Code ANTT | NVARCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01104 | Red Storno Order | NCHAR | 1 | — | — | + | |
PC01 | Purchase Order Head | PC01105 | Tax Point | NCHAR | 1 | — | — | + | |
PC01 | Purchase Order Head | PC01106 | Public Procurement Code1 | NVARCHAR | 20 | — | — | + | |
PC01 | Purchase Order Head | PC01107 | Public Procurement Code2 | NVARCHAR | 20 | — | — | + | |
PC01 | Purchase Order Head | PC01108 | Invoice Supplier Code | NCHAR | 10 | — | — | + | |
PC01 | Purchase Order Head | PC01109 | Payment Flag | NCHAR | 1 | — | — | + | |
PC03 | Purchase Order Lines | PC03009 | Unit Code | INT | 4 | 2 | — | ||
PC03 | Purchase Order Lines | PC03020 | Nomenclature Number | NVARCHAR | 25 | 3 | — | ||
PC03 | Purchase Order Lines | PC03036 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PC03 | Purchase Order Lines | PC03067 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC03 | Purchase Order Lines | PC03084 | Original Confirmed Delivery Date | DATETIME | 8 | — | — | + | |
PC03 | Purchase Order Lines | PC03085 | Creation Source | INT | 1 | — | — | + | |
PC03 | Purchase Order Lines | PC03086 | Tax Code | NCHAR | 6 | — | — | + | |
PC03 | Purchase Order Lines | PC03087 | Reminder Date FPO | DATETIME | 8 | — | — | + | |
PC03 | Purchase Order Lines | PC03088 | Linked to contract | INT | 1 | — | — | + | |
PC03 | Purchase Order Lines | PC03089 | Accounting Code 2 | NCHAR | 2 | — | — | + | |
PC03 | Purchase Order Lines | PC03090 | Contract Number | NVARCHAR | 10 | — | — | + | |
PC03 | Purchase Order Lines | PC03091 | Contract Line Number | NCHAR | 6 | — | — | + | |
PC03 | Purchase Order Lines | PC03092 | Delivery Schedule Line Number | NCHAR | 6 | — | — | + | |
PC03 | Purchase Order Lines | PC03093 | Org. Req. Delivery Date | DATETIME | 8 | — | — | + | |
PC03 | Purchase Order Lines | PC03094 | Commodity code | NVARCHAR | 35 | — | — | + | |
PC03 | Purchase Order Lines | PC03095 | Product Tax Type | NVARCHAR | 10 | — | — | + | |
PC03 | Purchase Order Lines | PC03096 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PC03 | Purchase Order Lines | PC03097 | Extended User-Defined Field 1 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03098 | Extended User-Defined Field 2 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03099 | Extended User-Defined Field 3 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03100 | Extended User-Defined Field 4 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03101 | Extended User-Defined Field 5 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03102 | Extended User-Defined Field 6 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03103 | Extended User-Defined Field 7 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03104 | Extended User-Defined Field 8 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03105 | Extended User-Defined Field 9 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03106 | Extended User-Defined Field 10 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03107 | Extended User-Defined Field 11 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03108 | Extended User-Defined Field 12 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03109 | Extended User-Defined Field 13 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03110 | Extended User-Defined Field 14 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03111 | Extended User-Defined Field 15 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03112 | Extended User-Defined Field 16 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03113 | Extended User-Defined Field 17 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03114 | Extended User-Defined Field 18 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03115 | Extended User-Defined Field 19 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03116 | Extended User-Defined Field 20 | NVARCHAR | 150 | — | — | + | |
PC03 | Purchase Order Lines | PC03117 | Requisition | NVARCHAR | 10 | — | — | + | |
PC03 | Purchase Order Lines | PC03118 | Requisition Line | NCHAR | 4 | — | — | + | |
PC03 | Purchase Order Lines | PC03119 | Delivery Block | INT | 1 | — | — | + | |
PC03 | Purchase Order Lines | PC03120 | ATP period shift days | INT | 1 | — | — | + | |
PC03 | Purchase Order Lines | PC03121 | Actual ATP period shift days | INT | 1 | — | — | + | |
PC04 | Delivery Addresses | PC04010 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC04 | Delivery Addresses | PC04012 | CityCode | NVARCHAR | 10 | — | — | + | |
PC04 | Delivery Addresses | PC04013 | Country Code | NCHAR | 3 | — | — | + | |
PC04 | Delivery Addresses | PC04014 | Region Code | NVARCHAR | 10 | — | — | + | |
PC04 | Delivery Addresses | PC04015 | State/Province Code | NVARCHAR | 10 | — | — | + | |
PC04 | Delivery Addresses | PC04016 | County Code | NVARCHAR | 10 | — | — | + | |
PC04 | Delivery Addresses | PC04017 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PC04 | Delivery Addresses | PC04018 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PC04 | Delivery Addresses | PC04019 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PC05 | Purchase Order Parameters | PC05087 | Default Structure Query in BOM Configurator | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05088 | Milestone related to Delivery Date | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05089 | LT AP start before today | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05090 | Renew supplier and price in requisition | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05091 | Automatic Requisition Conversion | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05092 | Picking Request upon Authorisation | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05093 | Create allocations during creation of picking request | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05094 | Tax Code Non Stock Item | NCHAR | 6 | — | — | + | |
PC05 | Purchase Order Parameters | PC05095 | Automatic printing of Product Labels | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05096 | Automatic Product Labels Print Channel | NVARCHAR | 255 | — | — | + | |
PC05 | Purchase Order Parameters | PC05097 | Priority Supplier Selection in Requisitions | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05098 | Commodity code activation | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05099 | Product Tax Type Non Stock Item | NVARCHAR | 10 | — | — | + | |
PC05 | Purchase Order Parameters | PC05100 | Source of Supplier Invoice BE Date | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05101 | Source of Electronic Invoice BE Date | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05102 | Red Storno Default | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05103 | Manual Conversion of Requisitions | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05104 | Adjust Supplier and Price | NCHAR | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05105 | Spare | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05106 | Spare | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05107 | Purchase Budget | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05108 | Budget Accumulation | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05109 | Budget Control Date | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05110 | Option For Absence of Budget | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05111 | Accounting Segment 1 | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05112 | Accounting Segment 2 | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05113 | Accounting Segment 3 | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05114 | Delivery Block | INT | 1 | — | — | + | |
PC05 | Purchase Order Parameters | PC05115 | ATP period shift days | INT | 1 | — | — | + | |
PC11 | Import Document Parameter File | PC11037 | Importer Address Line 4 | NVARCHAR | 35 | — | — | + | |
PC11 | Import Document Parameter File | PC11038 | Importer Address Line 5 | NVARCHAR | 35 | — | — | + | |
PC11 | Import Document Parameter File | PC11039 | Importer Address Line 6 | NVARCHAR | 35 | — | — | + | |
PC11 | Import Document Parameter File | PC11040 | Importer Address Line 7 | NVARCHAR | 35 | — | — | + | |
PC11 | Import Document Parameter File | PC11041 | Importer Country Code | NVARCHAR | 3 | — | — | + | |
PC12 | Purchase Coding Slips | PC12002 | Invoice Transaction Number | NCHAR | 9 | 6 | — | ||
PC12 | Purchase Coding Slips | PC12003 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PC12 | Purchase Coding Slips | PC12008 | Supplier Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC12 | Purchase Coding Slips | PC12014 | AAS code | NVARCHAR | 25 | — | — | + | |
PC14 | Order Line Del. | PC14053 | Customs Dispatch Note Number | NVARCHAR | 30 | — | — | + | |
PC14 | Order Line Del. | PC14054 | Date Imported | DATETIME | 8 | — | — | + | |
PC14 | Order Line Del. | PC14055 | Country of Origin | NCHAR | 3 | — | — | + | |
PC14 | Order Line Del. | PC14056 | Customs Office Code | NCHAR | 10 | — | — | + | |
PC14 | Order Line Del. | PC14057 | Rejected quantity | NUMERIC | 12 | 8 | — | — | + |
PC14 | Order Line Del. | PC14058 | Rejection Code | NVARCHAR | 4 | — | — | + | |
PC14 | Order Line Del. | PC14059 | Temperature | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14060 | Humidity | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14061 | User def. 1 | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14062 | User def. 2 | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14063 | User def. 3 | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14064 | User def. 4 | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14065 | User def. 5 | NVARCHAR | 12 | — | — | + | |
PC14 | Order Line Del. | PC14066 | DestinationCode | NCHAR | 4 | — | — | + | |
PC17 | Purchase Order Text Lines | PC17004 | Text Line Number | NCHAR | 6 | 3 | — | ||
PC17 | Purchase Order Text Lines | PC17022 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC19 | Purchase Order Delivery Lines | PC19034 | Purchase On-charge | NUMERIC | 12 | 8 | 6 | 8 | — |
PC19 | Purchase Order Delivery Lines | PC19044 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC19 | Purchase Order Delivery Lines | PC19052 | Product Label Printed | NCHAR | 1 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19053 | Rejected quantity | NUMERIC | 12 | 8 | — | — | + |
PC19 | Purchase Order Delivery Lines | PC19054 | Rejection Code | NVARCHAR | 4 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19055 | Temperature | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19056 | Humidity | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19057 | User def. 1 | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19058 | User def. 2 | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19059 | User def. 3 | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19060 | User def. 4 | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19061 | User def. 5 | NVARCHAR | 12 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19062 | Subcontract cost | NUMERIC | 20 | 8 | — | — | + |
PC19 | Purchase Order Delivery Lines | PC19063 | Tax Reg. Status | NCHAR | 1 | — | — | + | |
PC19 | Purchase Order Delivery Lines | PC19064 | Tax Reg. Date | DATETIME | 8 | — | — | + | |
PC20 | Invoice Costs | PC20002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC20 | Invoice Costs | PC20005 | Link | NVARCHAR | 7 | — | — | + | |
PC21 | Invoice Terms | PC21002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC22 | Invoice Header | PC22001 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC22 | Invoice Header | PC22016 | Central Bank Code | NCHAR | 4 | 3 | — | ||
PC22 | Invoice Header | PC22018 | Withholding Tax Code | NVARCHAR | 8 | 3 | — | ||
PC22 | Invoice Header | PC22034 | Tax Liability | NCHAR | 6 | — | — | + | |
PC22 | Invoice Header | PC22035 | Operation Type | NVARCHAR | 10 | — | — | + | |
PC22 | Invoice Header | PC22036 | Fin Operation Code | NVARCHAR | 10 | — | — | + | |
PC22 | Invoice Header | PC22037 | Net Invoice Amount in OCU | NUMERIC | 20 | 8 | — | — | + |
PC22 | Invoice Header | PC22038 | Payment Block Reason | INT | 3 | — | — | + | |
PC22 | Invoice Header | PC22039 | Reference Number | NVARCHAR | 25 | — | — | + | |
PC22 | Invoice Header | PC22040 | Withholding Tax Base | NUMERIC | 20 | 8 | — | — | + |
PC22 | Invoice Header | PC22041 | Withholding Tax Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PC22 | Invoice Header | PC22042 | WH Tax Amount XML Flag | NCHAR | 4 | — | — | + | |
PC22 | Invoice Header | PC22043 | Exchange Rate | NUMERIC | 10 | 8 | — | — | + |
PC22 | Invoice Header | PC22044 | Document Type | NVARCHAR | 3 | — | — | + | |
PC22 | Invoice Header | PC22045 | Ext. User defined 1 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22046 | Ext. User defined 2 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22047 | Ext. User defined 3 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22048 | Ext. User defined 4 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22049 | Ext. User defined 5 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22050 | Ext. User defined 6 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22051 | Ext. User defined 7 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22052 | Ext. User defined 8 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22053 | Ext. User defined 9 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22054 | Ext. User defined 10 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22055 | Ext. User defined 11 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22056 | Ext. User defined 12 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22057 | Ext. User defined 13 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22058 | Ext. User defined 14 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22059 | Ext. User defined 15 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22060 | Ext. User defined 16 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22061 | Ext. User defined 17 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22062 | Ext. User defined 18 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22063 | Ext. User defined 19 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22064 | Ext. User defined 20 | NVARCHAR | 150 | — | — | + | |
PC22 | Invoice Header | PC22065 | Original invoice number | NVARCHAR | 35 | — | — | + | |
PC22 | Invoice Header | PC22066 | Corrective Number | NCHAR | 1 | — | — | + | |
PC22 | Invoice Header | PC22067 | TaxDate | DATETIME | 8 | — | — | + | |
PC22 | Invoice Header | PC22068 | PO3 Sub type | NCHAR | 2 | — | — | + | |
PC22 | Invoice Header | PC22069 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PC23 | Invoice Line | PC23002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC23 | Invoice Line | PC23019 | Rejected quantity | NUMERIC | 12 | 8 | — | — | + |
PC23 | Invoice Line | PC23020 | Rejection Code | NVARCHAR | 4 | — | — | + | |
PC23 | Invoice Line | PC23021 | Temperature | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23022 | Humidity | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23023 | User def. 1 | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23024 | User def. 2 | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23025 | User def. 3 | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23026 | User def. 4 | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23027 | User def. 5 | NVARCHAR | 12 | — | — | + | |
PC23 | Invoice Line | PC23028 | Link | NVARCHAR | 7 | — | — | + | |
PC24 | Invoice Taxes | PC24002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC24 | Invoice Taxes | PC24003 | Tax Line Number | INT | 4 | 2 | — | ||
PC24 | Invoice Taxes | PC24009 | Tax Liability | NCHAR | 6 | — | — | + | |
PC24 | Invoice Taxes | PC24010 | Tax Type | NCHAR | 6 | — | — | + | |
PC24 | Invoice Taxes | PC24011 | Tax Code | NCHAR | 6 | — | — | + | |
PC24 | Invoice Taxes | PC24012 | Link | NVARCHAR | 7 | — | — | + | |
PC24 | Invoice Taxes | PC24013 | Tax Trans Type | NCHAR | 1 | — | — | + | |
PC24 | Invoice Taxes | PC24014 | TaxDate | DATETIME | 8 | — | — | + | |
PC25 | Supplier Statistics Data | PC25016 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PC28 | Spare | PC28022 | UnitCode | INT | 4 | 2 | — | ||
PC29 | Transport document parameters | PC29021 | Sender Address Line 3 | NVARCHAR | 35 | — | — | + | |
PC29 | Transport document parameters | PC29022 | Sender Address Line 4 | NVARCHAR | 35 | — | — | + | |
PC29 | Transport document parameters | PC29023 | Sender Address Line 5 | NVARCHAR | 35 | — | — | + | |
PC29 | Transport document parameters | PC29024 | Sender Address Line 6 | NVARCHAR | 35 | — | — | + | |
PC29 | Transport document parameters | PC29025 | Sender Address Line 7 | NVARCHAR | 35 | — | — | + | |
PC29 | Transport document parameters | PC29026 | Senders Country Code | NVARCHAR | 3 | — | — | + | |
PC2S | Purchase Invoice Self-Invoice Description Lines | PC2S001 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PC2S | Purchase Invoice Self-Invoice Description Lines | PC2S002 | Invoice No | NVARCHAR | 25 | — | — | + | |
PC2S | Purchase Invoice Self-Invoice Description Lines | PC2S003 | Sort Order | INT | 3 | — | — | + | |
PC2S | Purchase Invoice Self-Invoice Description Lines | PC2S004 | Description | NVARCHAR | 80 | — | — | + | |
PC2T | PO Invoice Text Lines | PC2T002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC3L | Extended order lines (Purchase Order) | PC3L013 | Invoice Number | NCHAR | 25 | 15 | — | ||
PC3L | Extended order lines (Purchase Order) | PC3L017 | Spare | NCHAR | 4 | — | — | + | |
PC3L | Extended order lines (Purchase Order) | PC3L018 | UDMS Code | NCHAR | 6 | — | — | + | |
PC3L | Extended order lines (Purchase Order) | PC3L019 | Status | INT | 1 | — | — | + | |
PC3L | Extended order lines (Purchase Order) | PC3L020 | Original Start Date | DATETIME | 8 | — | — | + | |
PC3L | Extended order lines (Purchase Order) | PC3L021 | Original Finish Date | DATETIME | 8 | — | — | + | |
PC41 | Purchase Order Head History | PC41017 | Our Reference | NVARCHAR | 35 | 20 | — | ||
PC41 | Purchase Order Head History | PC41018 | Your Reference | NVARCHAR | 35 | 20 | — | ||
PC41 | Purchase Order Head History | PC41033 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PC41 | Purchase Order Head History | PC41058 | Customer Purchase Order Number | NVARCHAR | 30 | 20 | — | ||
PC41 | Purchase Order Head History | PC41066 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC41 | Purchase Order Head History | PC41073 | User ID for entry | NVARCHAR | 8 | — | — | + | |
PC41 | Purchase Order Head History | PC41074 | Tax Liability | NCHAR | 6 | — | — | + | |
PC41 | Purchase Order Head History | PC41075 | Operation Type | NVARCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41076 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41077 | Fiscal Text Code | NVARCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41078 | Fiscal Note Number | NVARCHAR | 25 | — | — | + | |
PC41 | Purchase Order Head History | PC41079 | Fiscal Note Date | DATETIME | 8 | — | — | + | |
PC41 | Purchase Order Head History | PC41080 | Instalment | NCHAR | 1 | — | — | + | |
PC41 | Purchase Order Head History | PC41081 | Net Weight | NUMERIC | 10 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41082 | Gross Weight | NUMERIC | 10 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41083 | Number of Boxes | NUMERIC | 10 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41084 | Kind of Box | NVARCHAR | 15 | — | — | + | |
PC41 | Purchase Order Head History | PC41085 | Box numbering | NVARCHAR | 15 | — | — | + | |
PC41 | Purchase Order Head History | PC41086 | Number of pallets | NVARCHAR | 15 | — | — | + | |
PC41 | Purchase Order Head History | PC41087 | Transport Company Code | NVARCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41088 | Freight Amount | NUMERIC | 20 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41089 | Packing Amount | NUMERIC | 20 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41090 | Insurance Amount | NUMERIC | 20 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41091 | Invoicing Fee | NUMERIC | 20 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41092 | Own Freight Amount | NUMERIC | 20 | 8 | — | — | + |
PC41 | Purchase Order Head History | PC41093 | Vehicle State/Province | NVARCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41094 | Vehicle License Plate | NVARCHAR | 15 | — | — | + | |
PC41 | Purchase Order Head History | PC41095 | Freight Tax Code | NCHAR | 6 | — | — | + | |
PC41 | Purchase Order Head History | PC41096 | Packing Tax Code | NCHAR | 6 | — | — | + | |
PC41 | Purchase Order Head History | PC41097 | Insurance Tax Code | NCHAR | 6 | — | — | + | |
PC41 | Purchase Order Head History | PC41098 | Invoicing Tax Code | NCHAR | 6 | — | — | + | |
PC41 | Purchase Order Head History | PC41099 | Own Freight Tax Code | NCHAR | 6 | — | — | + | |
PC41 | Purchase Order Head History | PC41100 | Reason Code | INT | 3 | — | — | + | |
PC41 | Purchase Order Head History | PC41101 | Email address | NVARCHAR | 200 | — | — | + | |
PC41 | Purchase Order Head History | PC41102 | Org. Req. Delivery Date | DATETIME | 8 | — | — | + | |
PC41 | Purchase Order Head History | PC41103 | Code ANTT | NVARCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41104 | Red Storno Order | NCHAR | 1 | — | — | + | |
PC41 | Purchase Order Head History | PC41105 | Tax Point | NCHAR | 1 | — | — | + | |
PC41 | Purchase Order Head History | PC41106 | Public Procurement Code1 | NVARCHAR | 20 | — | — | + | |
PC41 | Purchase Order Head History | PC41107 | Public Procurement Code2 | NVARCHAR | 20 | — | — | + | |
PC41 | Purchase Order Head History | PC41108 | Invoice Supplier Code | NCHAR | 10 | — | — | + | |
PC41 | Purchase Order Head History | PC41109 | Payment Flag | NCHAR | 1 | — | — | + | |
PC42 | Purchase Order Lines History | PC42009 | Unit Code | INT | 4 | 2 | — | ||
PC42 | Purchase Order Lines History | PC42020 | NomenclatureNo | NVARCHAR | 25 | 3 | — | ||
PC42 | Purchase Order Lines History | PC42036 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PC42 | Purchase Order Lines History | PC42067 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC42 | Purchase Order Lines History | PC42084 | Original Confirmed Delivery Date | DATETIME | 8 | — | — | + | |
PC42 | Purchase Order Lines History | PC42085 | Creation Source | INT | 1 | — | — | + | |
PC42 | Purchase Order Lines History | PC42086 | Tax Code | NCHAR | 6 | — | — | + | |
PC42 | Purchase Order Lines History | PC42087 | Reminder Date FPO | DATETIME | 8 | — | — | + | |
PC42 | Purchase Order Lines History | PC42088 | Linked to Contract | INT | 1 | — | — | + | |
PC42 | Purchase Order Lines History | PC42089 | Accounting Code 2 | NCHAR | 2 | — | — | + | |
PC42 | Purchase Order Lines History | PC42090 | Contract Number | NVARCHAR | 10 | — | — | + | |
PC42 | Purchase Order Lines History | PC42091 | Contract Line Number | NCHAR | 6 | — | — | + | |
PC42 | Purchase Order Lines History | PC42092 | Delivery Schedule Line Number | NCHAR | 6 | — | — | + | |
PC42 | Purchase Order Lines History | PC42093 | Org. Req. Delivery Date | DATETIME | 8 | — | — | + | |
PC42 | Purchase Order Lines History | PC42094 | Commodity code | NVARCHAR | 35 | — | — | + | |
PC42 | Purchase Order Lines History | PC42095 | Product Tax Type | NVARCHAR | 10 | — | — | + | |
PC42 | Purchase Order Lines History | PC42096 | Financial Operation Code | NVARCHAR | 10 | — | — | + | |
PC42 | Purchase Order Lines History | PC42097 | Extended User-Defined Field 1 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42098 | Extended User-Defined Field 2 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42099 | Extended User-Defined Field 3 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42100 | Extended User-Defined Field 4 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42101 | Extended User-Defined Field 5 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42102 | Extended User-Defined Field 6 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42103 | Extended User-Defined Field 7 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42104 | Extended User-Defined Field 8 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42105 | Extended User-Defined Field 9 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42106 | Extended User-Defined Field 10 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42107 | Extended User-Defined Field 11 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42108 | Extended User-Defined Field 12 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42109 | Extended User-Defined Field 13 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42110 | Extended User-Defined Field 14 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42111 | Extended User-Defined Field 15 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42112 | Extended User-Defined Field 16 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42113 | Extended User-Defined Field 17 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42114 | Extended User-Defined Field 18 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42115 | Extended User-Defined Field 19 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42116 | Extended User-Defined Field 20 | NVARCHAR | 150 | — | — | + | |
PC42 | Purchase Order Lines History | PC42117 | Requisition | NVARCHAR | 10 | — | — | + | |
PC42 | Purchase Order Lines History | PC42118 | Requisition Line | NCHAR | 4 | — | — | + | |
PC42 | Purchase Order Lines History | PC42119 | Delivery Block | INT | 1 | — | — | + | |
PC42 | Purchase Order Lines History | PC42120 | ATPPeriodShiftDays | INT | 1 | — | — | + | |
PC42 | Purchase Order Lines History | PC42121 | Actual ATP period shift days | INT | 1 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43034 | Purchase On-charge | NUMERIC | 12 | 8 | 6 | 8 | — |
PC43 | Purchase Order Delivery Lines History | PC43044 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC43 | Purchase Order Delivery Lines History | PC43052 | Product Label Printed | NCHAR | 1 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43053 | Rejected quantity | NUMERIC | 12 | 8 | — | — | + |
PC43 | Purchase Order Delivery Lines History | PC43054 | Rejection Code | NVARCHAR | 4 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43055 | Temperature | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43056 | Humidity | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43057 | User def. 1 | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43058 | User def. 2 | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43059 | User def. 3 | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43060 | User def. 4 | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43061 | User def. 5 | NVARCHAR | 12 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43062 | Subcontract cost | NUMERIC | 20 | 8 | — | — | + |
PC43 | Purchase Order Delivery Lines History | PC43063 | Tax Reg. Status | NCHAR | 1 | — | — | + | |
PC43 | Purchase Order Delivery Lines History | PC43064 | Tax Reg. Date | DATETIME | 8 | — | — | + | |
PC44 | Purchase Order TextLines History | PC44004 | Text Line Number | NCHAR | 6 | 3 | — | ||
PC44 | Purchase Order TextLines History | PC44022 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC45 | Delivery Address History | PC45010 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC45 | Delivery Address History | PC45012 | CityCode | NVARCHAR | 10 | — | — | + | |
PC45 | Delivery Address History | PC45013 | Country Code | NCHAR | 3 | — | — | + | |
PC45 | Delivery Address History | PC45014 | Region Code | NVARCHAR | 10 | — | — | + | |
PC45 | Delivery Address History | PC45015 | State/Province Code | NVARCHAR | 10 | — | — | + | |
PC45 | Delivery Address History | PC45016 | County Code | NVARCHAR | 10 | — | — | + | |
PC45 | Delivery Address History | PC45017 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PC45 | Delivery Address History | PC45018 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PC45 | Delivery Address History | PC45019 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PC46 | Extended order lines (PC History) | PC46013 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PC46 | Extended order lines (PC History) | PC46017 | Spare | NCHAR | 4 | — | — | + | |
PC46 | Extended order lines (PC History) | PC46018 | UDMS Code | NCHAR | 6 | — | — | + | |
PC46 | Extended order lines (PC History) | PC46019 | Status | INT | 1 | — | — | + | |
PC46 | Extended order lines (PC History) | PC46020 | Original Start Date | DATETIME | 8 | — | — | + | |
PC46 | Extended order lines (PC History) | PC46021 | Original Finish Date | DATETIME | 8 | — | — | + | |
PCB4 | BOM Branch | PCB4017 | Unit Code | INT | 4 | 2 | — | ||
PCBD | Budget Reservations | PCBD001 | Type | INT | 1 | — | — | + | |
PCBD | Budget Reservations | PCBD002 | Requisition/Order Number | NCHAR | 10 | — | — | + | |
PCBD | Budget Reservations | PCBD003 | Line Number | NCHAR | 6 | — | — | + | |
PCBD | Budget Reservations | PCBD004 | Sub Line Number | NCHAR | 6 | — | — | + | |
PCBD | Budget Reservations | PCBD005 | Reserved Amount | NUMERIC | 20 | 8 | — | — | + |
PCBD | Budget Reservations | PCBD006 | Invoiced Amount | NUMERIC | 20 | 8 | — | — | + |
PCBD | Budget Reservations | PCBD007 | Account | NCHAR | 12 | — | — | + | |
PCBD | Budget Reservations | PCBD008 | Segment 1 | NCHAR | 12 | — | — | + | |
PCBD | Budget Reservations | PCBD009 | Segment 2 | NCHAR | 12 | — | — | + | |
PCBD | Budget Reservations | PCBD010 | Segment 3 | NCHAR | 12 | — | — | + | |
PCBD | Budget Reservations | PCBD011 | Year | INT | 2 | — | — | + | |
PCBD | Budget Reservations | PCBD012 | Period | INT | 2 | — | — | + | |
PCBD | Budget Reservations | PCBD013 | Budget Date | DATETIME | 8 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1001 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1002 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1003 | Electronic Invoice Number | NVARCHAR | 25 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1004 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1005 | Status | NCHAR | 1 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1006 | Fiscal Key for Invoice | NVARCHAR | 50 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1007 | Date Fiscal Key received | DATETIME | 8 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1008 | Date of Entry | DATETIME | 8 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1009 | Closed | NCHAR | 1 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1010 | Broker Invoice Number | NVARCHAR | 25 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1011 | Place of Clearance | NVARCHAR | 30 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1012 | State of Clearance | NCHAR | 2 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1013 | Clearance Date | DATETIME | 8 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1014 | Exporter Code | NCHAR | 10 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1015 | Fiscal Key Request Number | NCHAR | 10 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1016 | Fixed Tax Amount 1 | NUMERIC | 20 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1017 | Fixed Tax Amount 2 | NUMERIC | 20 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1018 | Fixed Tax Amount 3 | NUMERIC | 20 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1019 | Fixed Tax Amount 4 | NUMERIC | 20 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1020 | Fixed Tax Amount 5 | NUMERIC | 20 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1021 | Additional Invoice Flag | INT | 1 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1022 | E-Invoice Date | DATETIME | 8 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1023 | Currency Code | INT | 2 | — | — | + | |
PCD1 | Customs Declaration Header | PCD1024 | Exchange Rate | NUMERIC | 20 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1025 | Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PCD1 | Customs Declaration Header | PCD1026 | Exchange Algorithm | NCHAR | 3 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2001 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2002 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2003 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2004 | Invoice Number | NVARCHAR | 25 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2005 | Purchase Order No | NVARCHAR | 10 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2006 | Purchase Order Line No | NVARCHAR | 12 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2007 | Accounting String | NVARCHAR | 120 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2008 | PL Line Type | NVARCHAR | 1 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2009 | Flag «Cost Allocation on GRN» | NVARCHAR | 1 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2010 | Flag «PR Activity Type» | NVARCHAR | 1 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2011 | Delivered/Invoice Quantity [PC Unit] | NUMERIC | 12 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2012 | Amount/Unit Price Local Currency | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2013 | Amount/Unit Price Orig. Currency | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2014 | Order Quantity [PC Unit] | NUMERIC | 12 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2015 | Cost Distribution Key | NVARCHAR | 1 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2016 | Cost Type | NVARCHAR | 2 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2017 | Transaction Text | NVARCHAR | 35 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2018 | Purchase Price Update | NVARCHAR | 1 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2019 | Distribution Base | NVARCHAR | 10 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2020 | Adjusted Order Price | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2021 | Delivery Date Backordered Qty | NVARCHAR | 10 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2022 | Purchase Charge [%] | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2023 | Purchase Order for Transactions | NVARCHAR | 10 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2024 | Delivered/Invoice Quantity [SC Unit] | NUMERIC | 12 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2025 | Order Quantity [SC Unit] | NUMERIC | 12 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2026 | Sub-Project Code | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2027 | Activity Code | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2028 | Rate/Vat Code | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2029 | Tax Type | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2030 | Tax Array Index | INT | 4 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2031 | AAS code | NVARCHAR | 25 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2032 | Tax Code | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2033 | Tax Rate | NVARCHAR | 6 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2034 | Line Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2035 | Line Amount OCU with Discount | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2036 | Line Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2037 | Line Amount LCU with Discount | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2038 | Tax OCU | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2039 | Tax OCU with Discount | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2040 | Tax LCU | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2041 | Tax LCU with Discount | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2042 | Discount OCU | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2043 | Discount LCU | NUMERIC | 20 | 8 | — | — | + |
PCD2 | Customs Declaration Lines | PCD2044 | Nomenclature Number (NCM code) | NVARCHAR | 25 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2045 | Group Number | NCHAR | 3 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2046 | Additional Invoice Flag | INT | 1 | — | — | + | |
PCD2 | Customs Declaration Lines | PCD2047 | Tax Code 2 | NCHAR | 6 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3001 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3002 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3003 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3004 | Invoice Number | NVARCHAR | 25 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3005 | Order Number | NCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3006 | Line Number | NCHAR | 6 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3007 | Structure Line Number | NCHAR | 6 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3008 | AutoSubStructLineNo | NCHAR | 4 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3009 | Batch Number | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3010 | Quantity Invoiced | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3011 | Quantity Delivered | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3012 | Delivery Date Actual | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3013 | Delivery Note Number | NVARCHAR | 20 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3014 | Unit Cost Price | NUMERIC | 20 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3015 | Bin Number | NVARCHAR | 6 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3016 | LockStatus09 | INT | 1 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3017 | Search Field | NVARCHAR | 20 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3018 | Date Received | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3019 | Date Manufactured | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3020 | Date Best Before | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3021 | Date Ship Before | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3022 | Supplier Batch ID | NVARCHAR | 20 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3023 | UserDefFld1 | NVARCHAR | 20 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3024 | UserDefFld2 | NVARCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3025 | UserDefFld3 | NVARCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3026 | UserDefFld4 | NVARCHAR | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3027 | UserDefFld5 | NVARCHAR | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3028 | UserDefFld6 | NVARCHAR | 4 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3029 | UserDefFld7 | NVARCHAR | 4 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3030 | UserDefFld8 | NVARCHAR | 2 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3031 | UserDefFld9 | NVARCHAR | 2 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3032 | UserDefFld10 | NVARCHAR | 1 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3033 | Net Weight | NUMERIC | 10 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3034 | Gross Weight | NUMERIC | 10 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3035 | Volume | NUMERIC | 10 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3036 | Delivery Date Requested | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3037 | Delivery Date Committed | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3038 | Delivery Date Exchange Rate | NUMERIC | 20 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3039 | Delivered Quantity SC | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3040 | Delivery Date Back Order | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3041 | PurchSurcharge | NUMERIC | 6 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3042 | Discount | NUMERIC | 6 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3043 | Invoiced Quantity PC | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3044 | QtyDelTimePC | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3045 | QtyDelTimeSC | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3046 | QtyInvTimePC | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3047 | QtyInvTimeSC | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3048 | BatchDelExis | INT | 1 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3049 | Delivery Date Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3050 | Delivery Date Exhchange Algorithm | NCHAR | 3 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3051 | Currency Code | INT | 2 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3052 | AutoDelNoteNo | NVARCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3053 | Original Batch ID | NCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3054 | QC Category | NCHAR | 2 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3055 | PotencyFactor | NUMERIC | 6 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3056 | Date of Expiry | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3057 | Customs Despatch Note Number | NCHAR | 25 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3058 | Date Imported | DATETIME | 8 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3059 | Country of Origin | NCHAR | 3 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3060 | Customs Office Code | NCHAR | 10 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3061 | Rejected quantity | NUMERIC | 12 | 8 | — | — | + |
PCD3 | Customs Declaration Batch Lines | PCD3062 | Rejection Code | NVARCHAR | 4 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3063 | Temperature | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3064 | Humidity | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3065 | User def. 1 | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3066 | User def. 2 | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3067 | User def. 3 | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3068 | User def. 4 | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3069 | User def. 5 | NVARCHAR | 12 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3070 | Destination Code | NCHAR | 4 | — | — | + | |
PCD3 | Customs Declaration Batch Lines | PCD3071 | Additional Invoice Flag | INT | 1 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4001 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4002 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4003 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4004 | Invoice Number | NVARCHAR | 25 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4005 | Session number | NVARCHAR | 4 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4006 | Purchase Order number | NVARCHAR | 10 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4007 | Order line number | NVARCHAR | 6 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4008 | Sub Line number | NVARCHAR | 6 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4009 | Auto line number | NVARCHAR | 4 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4010 | Invoice number | NVARCHAR | 25 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4011 | Accounting string | NVARCHAR | 120 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4012 | Accounting code 1 | NVARCHAR | 2 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4013 | Batch ID | NVARCHAR | 12 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4014 | Transaction amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4015 | Transaction amount ICU | NUMERIC | 20 | 8 | — | — | + |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4016 | Work QTY SC units | NUMERIC | 12 | 8 | — | — | + |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4017 | Accounting code 2 | NVARCHAR | 2 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4018 | TaxIndex | NVARCHAR | 2 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4019 | AAS Code | NVARCHAR | 25 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4020 | Additional Invoice Flag | INT | 1 | — | — | + | |
PCD4 | Customs Declaration Cost Allocation Lines | PCD4021 | Supplier Code 2 | NCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7001 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7002 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7003 | Invoice Number | NVARCHAR | 25 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7004 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7005 | Transaction Type | NVARCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7006 | Rate Code | NVARCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7007 | Line Number | NVARCHAR | 7 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7008 | Transaction Date | DATETIME | 8 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7009 | Invoice Date | DATETIME | 8 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7010 | Base Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7011 | Tax Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7012 | Remark | NVARCHAR | 4 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7013 | Transaction Number | NVARCHAR | 9 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7014 | Cash Method | NVARCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7015 | Deductible % | NVARCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7016 | Expanded Macro | NVARCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7017 | Reported | NVARCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7018 | Deductible Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7019 | Booked Cost Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7020 | VAT Diff Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7021 | Line Number | NVARCHAR | 9 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7022 | Tax Type | NVARCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7023 | Tax Liability | NVARCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7024 | Tax Code | NCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7025 | Document Type | NCHAR | 3 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7026 | Tax Classification | NCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7027 | Tax Certificate | NVARCHAR | 15 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7028 | TaxCertifFlag | NCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7029 | Payment Number | NCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7030 | Payment Sub-Number | NCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7031 | Stock Item | NVARCHAR | 35 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7032 | Original Batch Number | NVARCHAR | 12 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7033 | Tax Rate | NUMERIC | 12 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7034 | Tax Calculation Method | INT | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7035 | Rate Type | NCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7036 | Tax Base Type | INT | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7037 | Tax Exemption | NCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7038 | Tax Exemption Rate | NUMERIC | 12 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7039 | Purchase Order Number | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7040 | Fiscal Text Code | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7041 | Tributary Site Code | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7042 | CVF Code | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7043 | ST Base Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7044 | ST Tax Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7045 | Tax Category | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7046 | Original Company | NVARCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7047 | Margin Percent | NUMERIC | 12 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7048 | Fixed Price | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7049 | Accepted Difference | NUMERIC | 12 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7050 | Resolution Name | NVARCHAR | 40 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7051 | Resolution Date | DATETIME | 8 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7052 | Invoice Reference | NVARCHAR | 25 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7053 | Original Currency Code | NVARCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7054 | Base Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7055 | Tax Slip No | NVARCHAR | 15 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7056 | Tax Slip Line | NVARCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7057 | Accounting Info | NVARCHAR | 120 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7058 | Line Reference | NVARCHAR | 7 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7059 | Financial Year | NVARCHAR | 4 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7060 | Ref GL06 | NVARCHAR | 9 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7061 | Direct from GL | NVARCHAR | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7062 | Issuer Code | NCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7063 | Order Line Number | NCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7064 | AAS code | NVARCHAR | 25 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7065 | Third Party Supplier | NVARCHAR | 10 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7066 | ProRataAmount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7067 | Reference SL Invoice | NVARCHAR | 25 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7068 | Certificate Date | DATETIME | 8 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7069 | Non Deductible Amount | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7070 | Order Subline No | NVARCHAR | 6 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7071 | Actual Tax Base | NUMERIC | 20 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7072 | Actual Tax Rate | NUMERIC | 12 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7073 | Additional Invoice Flag | INT | 1 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7074 | Destination Rate | NUMERIC | 8 | 8 | — | — | + |
PCD7 | Customs Declaration Taxes | PCD7075 | Cost Type | NCHAR | 2 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7076 | HMRC Period Key | NVARCHAR | 4 | — | — | + | |
PCD7 | Customs Declaration Taxes | PCD7077 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PCD8 | Customs Declaration’s NCM codes | PCD8001 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PCD8 | Customs Declaration’s NCM codes | PCD8002 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PCD8 | Customs Declaration’s NCM codes | PCD8003 | Nomenclature Number (NCM code) | NVARCHAR | 25 | — | — | + | |
PCD8 | Customs Declaration’s NCM codes | PCD8004 | Group Number | NCHAR | 3 | — | — | + | |
PCD8 | Customs Declaration’s NCM codes | PCD8005 | Additional Invoice Flag | INT | 1 | — | — | + | |
PCH4 | BOM Branch | PCH4017 | Unit Code | INT | 4 | 2 | — | ||
PCI2 | Instalments | PCI2001 | OrderNumber | NCHAR | 10 | — | — | + | |
PCI2 | Instalments | PCI2002 | InstallmentNumber | INT | 3 | — | — | + | |
PCI2 | Instalments | PCI2003 | DateCalculation | INT | 3 | — | — | + | |
PCI2 | Instalments | PCI2004 | Percentage% | NVARCHAR | 6 | — | — | + | |
PCI4 | Instalments History | PCI4001 | OrderNumber | NCHAR | 10 | — | — | + | |
PCI4 | Instalments History | PCI4002 | InvoiceNo | NVARCHAR | 25 | — | — | + | |
PCI4 | Instalments History | PCI4003 | InstallmentNumber | INT | 3 | — | — | + | |
PCI4 | Instalments History | PCI4004 | DateCalculation | INT | 3 | — | — | + | |
PCI4 | Instalments History | PCI4005 | Percentage% | NVARCHAR | 6 | — | — | + | |
PCR1 | Requisition Header | PCR1012 | From Bin | NVARCHAR | 6 | — | — | + | |
PCR2 | Requisition Line | PCR2013 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PCR2 | Requisition Line | PCR2020 | Unit Code | INT | 4 | 2 | — | ||
PCR2 | Requisition Line | PCR2026 | Was Supplier manually changed? | NCHAR | 1 | — | — | + | |
PCR2 | Requisition Line | PCR2027 | Was Price manually changed? | NCHAR | 1 | — | — | + | |
PCR2 | Requisition Line | PCR2028 | Creation Source | INT | 1 | — | — | + | |
PCR2 | Requisition Line | PCR2029 | Picking List Id | NCHAR | 10 | — | — | + | |
PCR2 | Requisition Line | PCR2030 | From Bin | NVARCHAR | 6 | — | — | + | |
PCR2 | Requisition Line | PCR2031 | To Bin | NVARCHAR | 6 | — | — | + | |
PCR2 | Requisition Line | PCR2032 | Picking Status | INT | 1 | — | — | + | |
PCR2 | Requisition Line | PCR2033 | Issued (Delivered) Quantity | NUMERIC | 12 | 8 | — | — | + |
PCR2 | Requisition Line | PCR2034 | OR Reference | NCHAR | 10 | — | — | + | |
PCR2 | Requisition Line | PCR2035 | OR Line Reference | NCHAR | 14 | — | — | + | |
PCR2 | Requisition Line | PCR2036 | Extended User-Defined Field 1 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2037 | Extended User-Defined Field 2 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2038 | Extended User-Defined Field 3 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2039 | Extended User-Defined Field 4 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2040 | Extended User-Defined Field 5 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2041 | Extended User-Defined Field 6 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2042 | Extended User-Defined Field 7 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2043 | Extended User-Defined Field 8 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2044 | Extended User-Defined Field 9 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2045 | Extended User-Defined Field 10 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2046 | Extended User-Defined Field 11 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2047 | Extended User-Defined Field 12 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2048 | Extended User-Defined Field 13 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2049 | Extended User-Defined Field 14 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2050 | Extended User-Defined Field 15 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2051 | Extended User-Defined Field 16 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2052 | Extended User-Defined Field 17 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2053 | Extended User-Defined Field 18 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2054 | Extended User-Defined Field 19 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2055 | Extended User-Defined Field 20 | NVARCHAR | 150 | — | — | + | |
PCR2 | Requisition Line | PCR2056 | Contract ID | NVARCHAR | 10 | — | — | + | |
PCR2 | Requisition Line | PCR2057 | Contract Line | NCHAR | 6 | — | — | + | |
PCR3 | Requisition Template Header | PCR3012 | From Bin | NVARCHAR | 6 | — | — | + | |
PCR4 | Requisition Template Line | PCR4013 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PCR4 | Requisition Template Line | PCR4020 | Unit Code | INT | 4 | 2 | — | ||
PCR4 | Requisition Template Line | PCR4026 | Was Supplier manually changed? | NCHAR | 1 | — | — | + | |
PCR4 | Requisition Template Line | PCR4027 | Was Price manually changed? | NCHAR | 1 | — | — | + | |
PCR4 | Requisition Template Line | PCR4028 | Creation Source | INT | 1 | — | — | + | |
PCR4 | Requisition Template Line | PCR4029 | Picking List Id | NCHAR | 10 | — | — | + | |
PCR4 | Requisition Template Line | PCR4030 | From Bin | NVARCHAR | 6 | — | — | + | |
PCR4 | Requisition Template Line | PCR4031 | To Bin | NVARCHAR | 6 | — | — | + | |
PCR4 | Requisition Template Line | PCR4032 | Picking Status | INT | 1 | — | — | + | |
PCR4 | Requisition Template Line | PCR4033 | Issued (Delivered) Quantity | NUMERIC | 12 | 8 | — | — | + |
PCR4 | Requisition Template Line | PCR4034 | OR Reference | NCHAR | 10 | — | — | + | |
PCR4 | Requisition Template Line | PCR4035 | OR Line Ref | NCHAR | 14 | — | — | + | |
PCR4 | Requisition Template Line | PCR4036 | Extended User-Defined Field 1 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4037 | Extended User-Defined Field 2 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4038 | Extended User-Defined Field 3 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4039 | Extended User-Defined Field 4 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4040 | Extended User-Defined Field 5 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4041 | Extended User-Defined Field 6 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4042 | Extended User-Defined Field 7 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4043 | Extended User-Defined Field 8 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4044 | Extended User-Defined Field 9 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4045 | Extended User-Defined Field 10 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4046 | Extended User-Defined Field 11 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4047 | Extended User-Defined Field 12 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4048 | Extended User-Defined Field 13 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4049 | Extended User-Defined Field 14 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4050 | Extended User-Defined Field 15 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4051 | Extended User-Defined Field 16 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4052 | Extended User-Defined Field 17 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4053 | Extended User-Defined Field 18 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4054 | Extended User-Defined Field 19 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4055 | Extended User-Defined Field 20 | NVARCHAR | 150 | — | — | + | |
PCR4 | Requisition Template Line | PCR4056 | Contract ID | NVARCHAR | 10 | — | — | + | |
PCR4 | Requisition Template Line | PCR4057 | Contract Line | NCHAR | 6 | — | — | + | |
PCR5 | Requisition History Lines | PCR5013 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PCR5 | Requisition History Lines | PCR5028 | Unit Code | INT | 4 | 2 | — | ||
PCR5 | Requisition History Lines | PCR5033 | Was Supplier manually changed? | NCHAR | 1 | — | — | + | |
PCR5 | Requisition History Lines | PCR5034 | Was Price manually changed? | NCHAR | 1 | — | — | + | |
PCR5 | Requisition History Lines | PCR5035 | Picking List Id | NCHAR | 10 | — | — | + | |
PCR5 | Requisition History Lines | PCR5036 | From Bin | NVARCHAR | 6 | — | — | + | |
PCR5 | Requisition History Lines | PCR5037 | To Bin | NVARCHAR | 6 | — | — | + | |
PCR5 | Requisition History Lines | PCR5038 | Picking Status | INT | 1 | — | — | + | |
PCR5 | Requisition History Lines | PCR5039 | Spare | NUMERIC | 12 | 8 | — | — | + |
PCR5 | Requisition History Lines | PCR5040 | OR Reference | NCHAR | 10 | — | — | + | |
PCR5 | Requisition History Lines | PCR5041 | OR Line Ref | NCHAR | 14 | — | — | + | |
PCR5 | Requisition History Lines | PCR5042 | Extended User-Defined Field 1 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5043 | Extended User-Defined Field 2 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5044 | Extended User-Defined Field 3 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5045 | Extended User-Defined Field 4 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5046 | Extended User-Defined Field 5 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5047 | Extended User-Defined Field 6 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5048 | Extended User-Defined Field 7 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5049 | Extended User-Defined Field 8 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5050 | Extended User-Defined Field 9 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5051 | Extended User-Defined Field 10 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5052 | Extended User-Defined Field 11 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5053 | Extended User-Defined Field 12 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5054 | Extended User-Defined Field 13 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5055 | Extended User-Defined Field 14 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5056 | Extended User-Defined Field 15 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5057 | Extended User-Defined Field 16 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5058 | Extended User-Defined Field 17 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5059 | Extended User-Defined Field 18 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5060 | Extended User-Defined Field 19 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5061 | Extended User-Defined Field 20 | NVARCHAR | 150 | — | — | + | |
PCR5 | Requisition History Lines | PCR5062 | Contract ID | NVARCHAR | 10 | — | — | + | |
PCR5 | Requisition History Lines | PCR5063 | Contract Line | NCHAR | 6 | — | — | + | |
PCR6 | Requisition Type Setup | PCR6004 | Serial Num Status | INT | 1 | — | — | + | |
PCR6 | Requisition Type Setup | PCR6005 | Serial Num Qty Check | INT | 1 | — | — | + | |
PCR7 | Requisition Type/Stock Item Status Setup | PCR7001 | Requisition Type | NCHAR | 1 | — | — | + | |
PCR7 | Requisition Type/Stock Item Status Setup | PCR7002 | Stock Item Status | NCHAR | 1 | — | — | + | |
PCR7 | Requisition Type/Stock Item Status Setup | PCR7003 | Allowed combination? | NCHAR | 1 | — | — | + | |
PCR8 | Requisition Header History | PCR8001 | Requisition Number | NVARCHAR | 10 | — | — | + | |
PCR8 | Requisition Header History | PCR8002 | Description | NVARCHAR | 35 | — | — | + | |
PCR8 | Requisition Header History | PCR8003 | Department Code | NVARCHAR | 6 | — | — | + | |
PCR8 | Requisition Header History | PCR8004 | Requisition Date | DATETIME | 8 | — | — | + | |
PCR8 | Requisition Header History | PCR8005 | Required Delivery Date | DATETIME | 8 | — | — | + | |
PCR8 | Requisition Header History | PCR8006 | Warehouse | NVARCHAR | 6 | — | — | + | |
PCR8 | Requisition Header History | PCR8007 | Requisition Type | NVARCHAR | 1 | — | — | + | |
PCR8 | Requisition Header History | PCR8008 | User Code | NVARCHAR | 8 | — | — | + | |
PCR8 | Requisition Header History | PCR8009 | Pickup Time | DATETIME | 17 | — | — | + | |
PCR8 | Requisition Header History | PCR8010 | Requisition Edit Time | DATETIME | 17 | — | — | + | |
PCR8 | Requisition Header History | PCR8011 | Line Printed | NVARCHAR | 1 | — | — | + | |
PCR8 | Requisition Header History | PCR8012 | From Bin | NVARCHAR | 6 | — | — | + | |
PCR9 | Approval Matrix | PCR9001 | Department | NCHAR | 6 | — | — | + | |
PCR9 | Approval Matrix | PCR9002 | Requisition Type | NCHAR | 1 | — | — | + | |
PCR9 | Approval Matrix | PCR9003 | Product Category | NCHAR | 10 | — | — | + | |
PCR9 | Approval Matrix | PCR9004 | Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCR9 | Approval Matrix | PCR9005 | Required Approval Level | INT | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1001 | Order Line Number | NVARCHAR | 25 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1002 | Customer Code | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1003 | Transaction Type | NVARCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1004 | Tax Code/Tax Rate | NVARCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1005 | Line Number | NVARCHAR | 7 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1006 | Transaction Date | DATETIME | 8 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1007 | Invoice Date | DATETIME | 8 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1008 | Base Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1009 | Tax Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1010 | Remark | NVARCHAR | 4 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1011 | Invoice Reference Number | NVARCHAR | 9 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1012 | Cash Method | NVARCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1013 | Deductable | NVARCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1014 | Expanded Macro | NVARCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1015 | Reported | NVARCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1016 | Deductible Amount | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1017 | Booked Cost Amount | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1018 | VAT Difference Amount | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1019 | Transaction Number | NVARCHAR | 9 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1020 | Tax Type | NCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1021 | Tax Liability Code | NCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1022 | Tax Code | NCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1023 | Document Type | NCHAR | 3 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1024 | Tax Classification | NCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1025 | Tax Certificate | NVARCHAR | 15 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1026 | Tax Certificate Print Status | NCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1027 | Payment Number | NCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1028 | Payment Sub Number | NCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1029 | Stock Item Code | NVARCHAR | 35 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1030 | Original Batch Number | NVARCHAR | 12 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1031 | Tax Rate | NUMERIC | 12 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1032 | Tax Calculation Method | INT | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1033 | Rate Type | NCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1034 | Tax Base Type | INT | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1035 | Tax Exemption | NCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1036 | Tax Exemption Rate | NUMERIC | 12 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1037 | Purch Order Number | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1038 | Fiscal Text Code | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1039 | Tributary Situation Code | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1040 | CVF Code | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1041 | ST Base Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1042 | Tributary Substitution Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1043 | Tax Category | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1044 | Original Company | NVARCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1045 | Margin Percent | NUMERIC | 12 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1046 | Fixed Price LCU | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1047 | Accepted Difference | NUMERIC | 12 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1048 | Resolution Name | NVARCHAR | 40 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1049 | Resolution Date | DATETIME | 8 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1050 | InvoiceRefer | NVARCHAR | 25 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1051 | Original Currency Code | NVARCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1052 | Base Amount (Original Currency) | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1053 | Tax Slip No | NVARCHAR | 15 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1054 | Tax Slip Line | NVARCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1055 | Accounting Info | NVARCHAR | 120 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1056 | Line Reference | NVARCHAR | 7 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1057 | Financial Year | NVARCHAR | 4 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1058 | Ref GL06 | NVARCHAR | 9 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1059 | Direct from GL | NVARCHAR | 1 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1060 | Issuer Code | NCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1061 | Order Line Number | NCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1062 | AAS code | NVARCHAR | 25 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1063 | ThirdPartySupplier | NVARCHAR | 10 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1064 | ProRataAmount | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1065 | Reference to SL Invoice | NVARCHAR | 25 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1066 | Certificate Date | DATETIME | 8 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1067 | Non Deductible Amount | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1068 | OrderSubLineNo | NVARCHAR | 6 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1069 | Actual Tax Base | NUMERIC | 20 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1070 | Actual Tax Rate | NUMERIC | 12 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1071 | Destination Rate | NUMERIC | 8 | 8 | — | — | + |
PCT1 | PC VAT Transactions | PCT1072 | Cost Type | NCHAR | 2 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1073 | HMRC Period Key | NVARCHAR | 4 | — | — | + | |
PCT1 | PC VAT Transactions | PCT1074 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PCTF | Order Template foreign descriptions | PCTF001 | Order Template ID | NCHAR | 4 | — | — | + | |
PCTF | Order Template foreign descriptions | PCTF002 | Language code | NCHAR | 3 | — | — | + | |
PCTF | Order Template foreign descriptions | PCTF003 | Description | NVARCHAR | 25 | — | — | + | |
PCTF | Order Template foreign descriptions | PCTF004 | Template Type | NCHAR | 2 | — | — | + | |
PCTH | Order Template Header | PCTH001 | Order Template ID | NCHAR | 4 | — | — | + | |
PCTH | Order Template Header | PCTH002 | Description | NVARCHAR | 25 | — | — | + | |
PCTH | Order Template Header | PCTH003 | Horizontal scroll | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH004 | Frozen Columns | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH005 | Applicable to order type 0 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH006 | Permission order type 0 | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH007 | Default for order type 0 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH008 | Applicable to order type 1 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH009 | Permission order type 1 | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH010 | Default for order type 1 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH011 | Applicable to order type 2 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH012 | Permission order type 2 | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH013 | Default for order type 2 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH014 | Applicable to order type 3 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH015 | Permission order type 3 | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH016 | Default for order type 3 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH017 | Applicable to order type 4 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH018 | Permission order type 4 | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH019 | Default for order type 4 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH020 | Spare | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH021 | Spare | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH022 | Spare | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH023 | Applicable to order type 6 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH024 | Permission order type 6 | INT | 2 | — | — | + | |
PCTH | Order Template Header | PCTH025 | Default for order type 6 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH026 | Template property 1 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH027 | Template property 2 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH028 | Template property 3 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH029 | Template property 4 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH030 | Template property 5 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH031 | Template property 6 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH032 | Foreground RW | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH033 | Background RW | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH034 | Foreground RO + cmd | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH035 | Background RO + cmd | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH036 | Foreground RO | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH037 | Background RO | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH038 | Foreground Linked | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH039 | Background Linked | INT | 10 | — | — | + | |
PCTH | Order Template Header | PCTH040 | Query Template 0 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH041 | Query Template 1 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH042 | Query Template 2 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH043 | Query Template 3 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH044 | Query Template 4 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH045 | Query Template 5 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH046 | Query Template 6 | NCHAR | 1 | — | — | + | |
PCTH | Order Template Header | PCTH047 | Template Type | NCHAR | 2 | — | — | + | |
PCTL | Order Template columns | PCTL001 | Order Template ID | NCHAR | 4 | — | — | + | |
PCTL | Order Template columns | PCTL002 | Column | INT | 3 | — | — | + | |
PCTL | Order Template columns | PCTL003 | Field Number | INT | 3 | — | — | + | |
PCTL | Order Template columns | PCTL004 | Field Property 1 | NCHAR | 1 | — | — | + | |
PCTL | Order Template columns | PCTL005 | Field Property 2 | NCHAR | 1 | — | — | + | |
PCTL | Order Template columns | PCTL006 | Field Property 3 | NCHAR | 1 | — | — | + | |
PCTL | Order Template columns | PCTL007 | Field Property 4 | NCHAR | 1 | — | — | + | |
PCTL | Order Template columns | PCTL008 | Field Property 5 | NCHAR | 1 | — | — | + | |
PCTL | Order Template columns | PCTL009 | Field Property 6 | NCHAR | 1 | — | — | + | |
PCTL | Order Template columns | PCTL010 | Template Type | NCHAR | 2 | — | — | + | |
PCWT | Purchase Invoice WH Taxes | PCWT001 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PCWT | Purchase Invoice WH Taxes | PCWT002 | Invoice No | NVARCHAR | 25 | — | — | + | |
PCWT | Purchase Invoice WH Taxes | PCWT003 | Withholding Tax Code | NVARCHAR | 8 | — | — | + | |
PCWT | Purchase Invoice WH Taxes | PCWT004 | Sort Order | INT | 3 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX003 | PwoData2 | NVARCHAR | 120 | 50 | — | ||
PCXX | P.Ord.Inv.Entry | PCXX013 | PwoData12 | NVARCHAR | 100 | 35 | — | ||
PCXX | P.Ord.Inv.Entry | PCXX024 | Rate/VAT Code | NVARCHAR | 6 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX025 | Tax Type | NVARCHAR | 6 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX026 | Tax Array Index | INT | 4 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX027 | AAS code | NVARCHAR | 25 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX028 | Tax code | NVARCHAR | 6 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX029 | Tax rate | NVARCHAR | 6 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX030 | Line Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX031 | Line Amount OCU with discount | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX032 | Line Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX033 | Line Amount LCU with discount | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX034 | Tax OCU | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX035 | Tax OCU with discount | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX036 | Tax LCU | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX037 | Tax LCU with discount | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX038 | Discount OCU | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX039 | Discount LCU | NUMERIC | 20 | 8 | — | — | + |
PCXX | P.Ord.Inv.Entry | PCXX040 | Nomenclature Number (NCM code) | NVARCHAR | 25 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX041 | Group Number | NCHAR | 3 | — | — | + | |
PCXX | P.Ord.Inv.Entry | PCXX042 | Tax Code 2 | NCHAR | 6 | — | — | + | |
PCXY | Purchase Inv.w. | PCXY001 | xycodestr | NVARCHAR | 92 | 88 | — |
Не забудьте посетить страницу «Наши услуги» и заказать интеграцию 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