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

Изменения структуры таблиц модуля «Заказ на Закупку» / Purchase 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?
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