1
|
PC42
|
PC42001
|
PurchaOrdNo
|
STRING
|
10
|
10
|
0
|
Purchase Order Number
|
3
|
PC42
|
PC42002
|
LineNumber
|
STRING
|
6
|
6
|
0
|
Purchase Order Line Number
|
4
|
PC42
|
PC42003
|
StructLineNo
|
STRING
|
6
|
6
|
0
|
Purchase Order Sub-line Number
|
|
PC42
|
PC42004
|
LineType
|
INTEGER
|
1
|
0
|
0
|
Line Type
|
|
PC42
|
PC42005
|
StockCode
|
VSTRING
|
35
|
35
|
0
|
Stock Item Code
|
|
PC42
|
PC42006
|
DescriptLine1
|
VSTRING
|
25
|
25
|
0
|
Description Line 1
|
|
PC42
|
PC42007
|
DescriptLine2
|
VSTRING
|
25
|
25
|
0
|
Description Line 2
|
|
PC42
|
PC42008
|
UnitPrice
|
MONEY
|
20
|
28
|
8
|
Unit Price (Order Currency)
|
|
PC42
|
PC42009
|
UnitCode
|
INTEGER
|
4
|
0
|
0
|
Unit Code
|
|
PC42
|
PC42010
|
PCQtyOrdered
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Ordered
|
|
PC42
|
PC42011
|
PCQtyReceive
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Received
|
|
PC42
|
PC42012
|
PCQtyInvoice
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Invoiced
|
|
PC42
|
PC42013
|
AccountCode1
|
STRING
|
2
|
2
|
0
|
Accounting Code 1
|
|
PC42
|
PC42014
|
FLAGBackOrd
|
SWITCH
|
1
|
1
|
0
|
Back Order
|
|
PC42
|
PC42015
|
Discount
|
X_NUMERIC
|
6
|
14
|
8
|
Discount
|
|
PC42
|
PC42016
|
DelDateCommi
|
DATE
|
8
|
0
|
0
|
Delivery Date Committed
|
|
PC42
|
PC42017
|
DelDateActua
|
DATE
|
8
|
0
|
0
|
Actual Delivery Date
|
|
PC42
|
PC42018
|
QtyUnitInDel
|
X_NUMERIC
|
10
|
18
|
8
|
Items per Package (Purchase)
|
|
PC42
|
PC42019
|
CostPrcMult
|
X_NUMERIC
|
10
|
18
|
8
|
Cost Price Multiplier
|
|
PC42
|
PC42020
|
SPARE
|
VSTRING
|
25
|
25
|
0
|
NomenclatureNo Nomenclature Number
|
|
PC42
|
PC42021
|
TransactSour
|
INTEGER
|
1
|
0
|
0
|
Related Type of Order - Not linked to other order type 1 - Sales Order 2 - Service Order 3 - Work Order
|
|
PC42
|
PC42022
|
ItemType
|
VSTRING
|
1
|
1
|
0
|
Item Type
|
|
PC42
|
PC42023
|
StockStatus
|
INTEGER
|
1
|
0
|
0
|
Stock Item Status
|
|
PC42
|
PC42024
|
BatchCreatDt
|
DATE
|
8
|
0
|
0
|
Date Batch Created
|
|
PC42
|
PC42025
|
DelExchRate
|
X_NUMERIC
|
20
|
28
|
8
|
Delivery Date Exchange Rate
|
|
PC42
|
PC42026
|
Spare
|
VSTRING
|
1
|
1
|
0
|
(obsolete)
|
|
PC42
|
PC42027
|
FLAGNewOrLin
|
STRING
|
1
|
1
|
0
|
New Order Line
|
|
PC42
|
PC42028
|
UserOption2
|
VSTRING
|
1
|
1
|
0
|
UserOption2
|
|
PC42
|
PC42029
|
FlagLineConfirmed
|
VSTRING
|
1
|
1
|
0
|
Line Confirmed
|
|
PC42
|
PC42030
|
DelDateReque
|
DATE
|
8
|
0
|
0
|
Delivery Date Requested
|
|
PC42
|
PC42031
|
DelDatBackOr
|
DATE
|
8
|
0
|
0
|
Delivery Date Back Order
|
|
PC42
|
PC42032
|
NetWeight
|
X_NUMERIC
|
10
|
18
|
8
|
Net Weight
|
|
PC42
|
PC42033
|
GrossWeight
|
X_NUMERIC
|
10
|
18
|
8
|
Gross Weight
|
|
PC42
|
PC42034
|
Volume
|
X_NUMERIC
|
10
|
18
|
8
|
Volume
|
|
PC42
|
PC42035
|
WarehouseID
|
VSTRING
|
6
|
6
|
0
|
Warehouse
|
|
PC42
|
PC42036
|
AccounString
|
ACCSTR
|
120
|
120
|
0
|
Accounting String
|
|
PC42
|
PC42037
|
ProjectRefer
|
VSTRING
|
12
|
12
|
0
|
Project Reference
|
|
PC42
|
PC42038
|
QtyRecDispNt
|
X_NUMERIC
|
12
|
20
|
8
|
Total Received Quantity
|
|
PC42
|
PC42039
|
OrReference
|
VSTRING
|
10
|
10
|
0
|
Order Reference
|
|
PC42
|
PC42040
|
PurchaserDepartment
|
VSTRING
|
9
|
9
|
0
|
Purchaser/Department
|
|
PC42
|
PC42041
|
DelivBatchNo
|
VSTRING
|
12
|
12
|
0
|
Delivery Batch Number
|
|
PC42
|
PC42042
|
UnConvForPur
|
X_NUMERIC
|
10
|
18
|
8
|
Unit Conversion Factor Purchase to Stock
|
|
PC42
|
PC42043
|
DeliverQtySC
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Received (Stock Unit)
|
|
PC42
|
PC42044
|
OrdQtySCunit
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Ordered (Stock Unit)
|
|
PC42
|
PC42045
|
OrdLineRefer
|
STRING
|
14
|
14
|
0
|
Order Line Reference
|
|
PC42
|
PC42046
|
RemainQtySC
|
X_NUMERIC
|
12
|
20
|
8
|
Remaining Quantity (Stock Unit)
|
|
PC42
|
PC42047
|
RemainQtyPC
|
X_NUMERIC
|
12
|
20
|
8
|
Remaining Quantity
|
|
PC42
|
PC42048
|
SubType
|
STRING
|
1
|
1
|
0
|
Sub Type
|
|
PC42
|
PC42049
|
QCQuantity
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity on Quality Control
|
|
PC42
|
PC42050
|
StatusQC
|
STRING
|
1
|
1
|
0
|
Status Quality Control
|
|
PC42
|
PC42051
|
Contract
|
VSTRING
|
27
|
27
|
0
|
Contract
|
|
PC42
|
PC42052
|
Spare1
|
STRING
|
3
|
3
|
0
|
(obsolete)
|
|
PC42
|
PC42053
|
Spare2
|
STRING
|
3
|
3
|
0
|
(obsolete)
|
|
PC42
|
PC42054
|
DelExchRate2
|
X_NUMERIC
|
10
|
18
|
8
|
Delivery Date Exchange Rate 2
|
|
PC42
|
PC42055
|
DelExchRateAlg
|
STRING
|
3
|
3
|
0
|
Delivery Date Exchange Rate Algorithm
|
|
PC42
|
PC42056
|
CurrencyCode
|
INTEGER
|
2
|
0
|
0
|
Currency Code Order
|
|
PC42
|
PC42057
|
OverDeliveryControl
|
STRING
|
1
|
1
|
0
|
Over Delivery Control
|
|
PC42
|
PC42058
|
OverDeliveryPerc
|
X_NUMERIC
|
6
|
14
|
8
|
Over Delivery %
|
|
PC42
|
PC42059
|
OverDeliveryQTY
|
X_NUMERIC
|
12
|
20
|
8
|
Over Delivery Quantity
|
|
PC42
|
PC42060
|
EDIContractSwitch
|
SWITCH
|
1
|
1
|
0
|
EDI-Contract
|
|
PC42
|
PC42061
|
OrigPriceCurCode
|
INTEGER
|
2
|
0
|
0
|
Currency Code Original Price
|
|
PC42
|
PC42062
|
OrigUnitPrice
|
MONEY
|
20
|
28
|
8
|
Original Unit Price
|
|
PC42
|
PC42063
|
SupplierOrderNumber
|
STRING
|
20
|
20
|
0
|
Supplier Order Number
|
|
PC42
|
PC42064
|
SupplierOrderLineRef
|
STRING
|
20
|
20
|
0
|
Supplier Order Line Reference
|
|
PC42
|
PC42065
|
LineNumberOrg
|
STRING
|
12
|
12
|
0
|
Line Number Original Line
|
|
PC42
|
PC42066
|
PCQtyOrderedOrg
|
X_NUMERIC
|
12
|
20
|
8
|
Original Quantity Ordered
|
2
|
PC42
|
PC42067
|
InvoiceNumber
|
VSTRING
|
25
|
25
|
0
|
Invoice Number
|
|
PC42
|
PC42068
|
POReceipt
|
VSTRING
|
1
|
1
|
0
|
Drop Shipment Receipt Rule 0 - Receive into Inventory 1 - Receive into Inventory and hard allocate to sales/service order 2 - Receive into Inventory and issue to sales/service order 3 - Issue to sales/service order without inventory update
|
|
PC42
|
PC42069
|
POAdjustment
|
VSTRING
|
1
|
1
|
0
|
Drop Shipment Adjustment Allowed
|
|
PC42
|
PC42070
|
MarginRule
|
VSTRING
|
1
|
1
|
0
|
Delivery Margin Rule
|
|
PC42
|
PC42071
|
MarginPercent
|
X_NUMERIC
|
6
|
14
|
8
|
Delivery Margin %
|
|
PC42
|
PC42072
|
DSLine
|
VSTRING
|
1
|
1
|
0
|
Drop Shipment Line
|
|
PC42
|
PC42073
|
Owner
|
VSTRING
|
20
|
20
|
0
|
Owner
|
|
PC42
|
PC42074
|
QtyPCUnitLastInvoice
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Last Invoiced
|
|
PC42
|
PC42075
|
QtySCUnitLastInvoice
|
X_NUMERIC
|
12
|
20
|
8
|
Quantity Last Invoiced (Stock Unit)
|
|
PC42
|
PC42076
|
Spare
|
X_NUMERIC
|
20
|
28
|
8
|
(obsolete)
|
|
PC42
|
PC42077
|
Spare
|
X_NUMERIC
|
20
|
28
|
8
|
(obsolete)
|
|
PC42
|
PC42078
|
NodeID_BOM_PC
|
STRING
|
38
|
38
|
0
|
BoM Node ID Purchase Order
|
|
PC42
|
PC42079
|
NodeID_BOM_SC
|
STRING
|
38
|
38
|
0
|
BoM Node ID Stock
|
|
PC42
|
PC42080
|
BlockForProcess
|
STRING
|
1
|
1
|
0
|
BoM Blocked for Processing
|
|
PC42
|
PC42081
|
InstallationCustomer
|
VSTRING
|
10
|
10
|
0
|
Installation Customer
|
|
PC42
|
PC42082
|
InstallationSite
|
VSTRING
|
4
|
4
|
0
|
Installation Site
|
|
PC42
|
PC42083
|
ServiceMasterOrder
|
STRING
|
10
|
10
|
0
|
Service Master Order
|
|
PC42
|
PC42084
|
OriginalConfDD
|
DATE
|
8
|
0
|
0
|
Original Confirmed Delivery Date
|
|
PC42
|
PC42085
|
CreationSource
|
INTEGER
|
1
|
0
|
0
|
Creation Source
|
|
PC42
|
PC42086
|
TaxCode
|
STRING
|
6
|
6
|
0
|
Tax Code
|
|
PC42
|
PC42087
|
ReminderDateFPO
|
DATE
|
8
|
0
|
0
|
Reminder Date FPO
|
|
PC42
|
PC42088
|
LinkedToContract
|
INTEGER
|
1
|
0
|
0
|
Linked to Contract
|
|
PC42
|
PC42089
|
AccountCode2
|
STRING
|
2
|
2
|
0
|
Accounting Code 2
|
|
PC42
|
PC42090
|
ContractNumber
|
VSTRING
|
10
|
10
|
0
|
Contract Number
|
|
PC42
|
PC42091
|
ContractLineNumber
|
STRING
|
6
|
6
|
0
|
Contract Line Number
|
|
PC42
|
PC42092
|
DeliveryScheduleLineNumber
|
STRING
|
6
|
6
|
0
|
Delivery Schedule Line Number
|
|
PC42
|
PC42093
|
OrgReqDeliveryDate
|
DATE
|
8
|
0
|
0
|
Org. Req. Delivery Date
|
|
PC42
|
PC42094
|
CommodityCode
|
VSTRING
|
35
|
35
|
0
|
Commodity code
|
|
PC42
|
PC42095
|
ProductTaxType
|
VSTRING
|
10
|
10
|
0
|
Product Tax Type
|
|
PC42
|
PC42096
|
FinancialOperationCode
|
VSTRING
|
10
|
10
|
0
|
Financial Operation Code
|
|
PC42
|
PC42097
|
ExUserDef1
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 1
|
|
PC42
|
PC42098
|
ExUserDef2
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 2
|
|
PC42
|
PC42099
|
ExUserDef3
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 3
|
|
PC42
|
PC42100
|
ExUserDef4
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 4
|
|
PC42
|
PC42101
|
ExUserDef5
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 5
|
|
PC42
|
PC42102
|
ExUserDef6
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 6
|
|
PC42
|
PC42103
|
ExUserDef7
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 7
|
|
PC42
|
PC42104
|
ExUserDef8
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 8
|
|
PC42
|
PC42105
|
ExUserDef9
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 9
|
|
PC42
|
PC42106
|
ExUserDef10
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 10
|
|
PC42
|
PC42107
|
ExUserDef11
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 11
|
|
PC42
|
PC42108
|
ExUserDef12
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 12
|
|
PC42
|
PC42109
|
ExUserDef13
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 13
|
|
PC42
|
PC42110
|
ExUserDef14
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 14
|
|
PC42
|
PC42111
|
ExUserDef15
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 15
|
|
PC42
|
PC42112
|
ExUserDef16
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 16
|
|
PC42
|
PC42113
|
ExUserDef17
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 17
|
|
PC42
|
PC42114
|
ExUserDef18
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 18
|
|
PC42
|
PC42115
|
ExUserDef19
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 19
|
|
PC42
|
PC42116
|
ExUserDef20
|
VSTRING
|
150
|
150
|
0
|
Extended User-Defined Field 20
|
|
PC42
|
PC42117
|
Requisition
|
VSTRING
|
10
|
10
|
0
|
Requisition
|
|
PC42
|
PC42118
|
RqsnLine
|
STRING
|
4
|
4
|
0
|
Requisition Line
|
|
PC42
|
PC42119
|
DeliveryBlock
|
INTEGER
|
1
|
0
|
0
|
Delivery Block
|
|
PC42
|
PC42120
|
ATP period shift days
|
INTEGER
|
1
|
0
|
0
|
ATPPeriodShiftDays
|
|
PC42
|
PC42121
|
ActualATPPeriodShiftDays
|
INTEGER
|
1
|
0
|
0
|
Actual ATP period shift days
|