Название Таблицы / 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 |
|
— |