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