|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateProgName
|
Program
|
|
x(10)
|
|
|
|
CreateTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
NewQtyAlloc
|
New Allocated
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
NewQtyPick
|
New Picked
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
oid_OrdAllocH
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OldQtyAlloc
|
Old Allocated
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
OldQtyPick
|
Old Picked
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DateIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
CreateDate
|
yes
|
no
|
|
|
|
|
CreateTime
|
yes
|
no
|
|
|
oid_OrdAllocH
|
yes
|
oid_OrdAllocH
|
yes
|
no
|
|
∗
|
OrderIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
Part
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Allocation
|
Allocation
|
|
x(8)
|
|
|
|
AllocNbr
|
Allocation Order
|
|
x(18)
|
|
|
|
AltUM
|
Alternate UM
|
Alt!UM
|
x(2)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
DueDate
|
Due Date
|
|
99/99/99
|
|
|
|
Explicit
|
Explicit Supply
|
Explic
|
yes/no
|
|
|
|
InspReq
|
Inspection Required
|
Insp Req
|
yes/no
|
|
|
|
InternalID
|
Internal User ID
|
Internal!User ID
|
x(50)
|
|
|
|
IssueMethod
|
Issue Method
|
|
x(8)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
LoadID
|
Load ID
|
|
X(8)
|
|
|
|
LoadOpt
|
Load Optimization
|
Load
|
yes/no
|
|
|
|
LocType
|
Location Type
|
Location!Type
|
X(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_OrderD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
OrdStatus
|
Status
|
Stat
|
x(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
Picked
|
Picked
|
Pick
|
yes/no
|
|
|
|
PickStatus
|
Pick Status
|
St
|
x(1)
|
|
|
|
PreShipper
|
PreShipper
|
|
X(8)
|
|
|
|
Priority
|
Priority
|
|
X(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
Route
|
Route
|
|
X(8)
|
|
|
|
Shipper
|
Shipper
|
Shipper
|
x(8)
|
|
|
|
ShipTo
|
Ship To
|
|
x(8)
|
|
|
|
ShipVia
|
Carrier
|
Carrier
|
x(20)
|
|
|
|
Short
|
Short
|
|
yes/no
|
|
|
|
ShortQty
|
Qty Short
|
Qty!Short
|
->,>>>,>>9.9<<<<<<<<
|
2
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User Field Character 1
|
|
x(24)
|
|
|
|
User2
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 1
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Allocation
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Allocation
|
yes
|
no
|
|
|
|
|
DueDate
|
yes
|
no
|
|
|
DueDate
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
DueDate
|
yes
|
no
|
|
|
Internal
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InternalID
|
yes
|
no
|
|
|
|
|
PickStatus
|
yes
|
no
|
|
∗
|
Line
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
OrdSite
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
LoadID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
PickStatus
|
yes
|
no
|
|
|
|
|
LoadID
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
Nbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
oid_OrderD
|
yes
|
oid_OrderD
|
yes
|
no
|
|
|
Part
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Priority
|
yes
|
no
|
|
|
Preship
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
PreShipper
|
yes
|
no
|
|
|
Route
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Route
|
yes
|
no
|
|
|
|
|
Allocation
|
yes
|
no
|
|
|
|
|
DueDate
|
yes
|
no
|
|
|
ShipTo
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
ShipTo
|
yes
|
no
|
|
|
|
|
Allocation
|
yes
|
no
|
|
|
|
|
DueDate
|
yes
|
no
|
|
|
ShipVia
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
ShipVia
|
yes
|
no
|
|
|
|
|
Allocation
|
yes
|
no
|
|
|
|
|
DueDate
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
WhsePick
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
PickStatus
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
DueDate
|
Due Date
|
|
99/99/99
|
|
|
|
LoadSeq
|
Load Sequence
|
Load!Sequence
|
X(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_OrderM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
OrdStatus
|
Status
|
Stat
|
x(8)
|
|
|
|
OrdType
|
Type
|
T
|
x(1)
|
|
|
|
Priority
|
Priority
|
|
X(8)
|
|
|
|
Profile
|
Profile
|
Prof
|
x(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Route
|
Route
|
|
X(8)
|
|
|
|
ShipTo
|
Ship To
|
|
x(8)
|
|
|
|
ShipVia
|
Carrier
|
Carrier
|
x(20)
|
|
|
|
User1
|
User Field Character 1
|
|
x(8)
|
|
|
|
User2
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DSetPriority
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Priority
|
yes
|
no
|
|
|
Nbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
oid_OrderM
|
yes
|
oid_OrderM
|
yes
|
no
|
|
∗
|
OrderIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
OrdSite
|
yes
|
no
|
|
|
OrDType
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
OrdType
|
yes
|
no
|
|
|
Priority
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Priority
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
Profile
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Profile
|
yes
|
no
|
|
|
ShipTo
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ShipTo
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
DueDate
|
Due Date
|
Due
|
99/99/99
|
|
|
|
GrossWeight
|
Gross Weight
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
NetWeight
|
Net Weight
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
oid_OrderSelD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PromiseDate
|
Promise Date
|
Promise
|
99/99/99
|
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Qty
|
Quantity
|
Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
RequiredDate
|
Required Date
|
Required
|
99/99/99
|
|
|
|
Route
|
Route
|
|
x(8)
|
|
|
|
SelNbr
|
Selection Number
|
Sel Nbr
|
x(8)
|
|
|
|
ShipTo
|
Ship To
|
|
x(8)
|
|
|
|
ShipVia
|
Carrier
|
Carrier
|
x(20)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TareWeight
|
Tare Weight
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
UM
|
UM
|
|
x(2)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Volume
|
Volume
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
VolumeUM
|
Volume UM
|
|
x(2)
|
|
|
|
WeightUM
|
Weight UM
|
|
x(2)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Line
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
SelNbr
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
OrdSite
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
oid_OrderSelD
|
yes
|
oid_OrderSelD
|
yes
|
no
|
|
|
OrderLine
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
OrdSite
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExportDate
|
Export Date
|
|
99/99/99
|
|
|
|
ExportProg
|
Export Program
|
|
x(10)
|
|
|
|
ExportTime
|
Export Time
|
|
>>>>>>>9
|
|
|
|
ExportUserID
|
Exported
|
|
x(24)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_OrderSelM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Remark
|
Remark
|
Rmk
|
x(40)
|
|
|
|
SelNbr
|
Selection Number
|
Sel Nbr
|
x(8)
|
|
|
|
SelStatus
|
Selection Status
|
Status
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_OrderSelM
|
yes
|
oid_OrderSelM
|
yes
|
no
|
|
∗
|
SelNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
SelNbr
|
yes
|
no
|
|
|
SelStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SelStatus
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
SiteWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pac_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pac__qadc01
|
|
|
x(8)
|
|
|
|
pac_amt[4]
|
Minimum Amount
|
|
->>>>,>>>,>>9.99
|
10
|
|
|
pac_apr_by[4]
|
Approver
|
|
x(8)
|
|
|
|
pac_code
|
Approval Code
|
Apv Code
|
x(8)
|
|
|
|
pac_desc
|
Description
|
|
x(24)
|
|
|
|
pac_domain
|
Domain
|
|
x(8)
|
|
|
|
pac_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pac_pl
|
Product Line
|
Line
|
x(4)
|
|
|
|
pac_pur_acct
|
Purchases Acct
|
Pur Acct
|
x(8)
|
|
|
|
pac_pur_cc
|
Purchases CC
|
CC
|
x(4)
|
|
|
|
pac_pur_sub
|
Purchases Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
pac_req_by
|
Requested By
|
Req By
|
x(8)
|
|
|
|
pac_site
|
Site
|
|
x(8)
|
|
|
|
pac_user1
|
User1
|
|
x(8)
|
|
|
|
pac_user2
|
User2
|
|
x(8)
|
|
|
|
pac_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pac_mstr
|
yes
|
oid_pac_mstr
|
yes
|
no
|
|
∗
|
pac_code
|
yes
|
pac_domain
|
yes
|
no
|
|
|
|
|
pac_code
|
yes
|
no
|
|
|
pac_index1
|
no
|
pac_domain
|
yes
|
no
|
|
|
|
|
pac_site
|
yes
|
no
|
|
|
|
|
pac_pl
|
yes
|
no
|
|
|
|
|
pac_pur_acct
|
yes
|
no
|
|
|
|
|
pac_pur_sub
|
yes
|
no
|
|
|
|
|
pac_pur_cc
|
yes
|
no
|
|
|
|
|
pac_req_by
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pald_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pald__chr01
|
|
|
x(8)
|
|
|
|
pald__chr02
|
|
|
x(8)
|
|
|
|
pald__chr03
|
|
|
x(8)
|
|
|
|
pald__chr04
|
|
|
x(8)
|
|
|
|
pald__chr05
|
|
|
x(8)
|
|
|
|
pald__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
pald__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
pald_desc
|
Description
|
|
x(24)
|
|
|
|
pald_domain
|
Domain
|
|
x(8)
|
|
|
|
pald_height
|
Height
|
|
>>,>>9.99
|
10
|
|
|
pald_hght_um
|
UM
|
|
x(2)
|
|
|
|
pald_nbr_lay
|
Number of Layers
|
|
>,>>>,>>9
|
|
|
|
pald_pallet
|
Pallet Type
|
Type
|
x(8)
|
|
|
|
pald_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
pald_um
|
UM
|
|
x(2)
|
|
|
|
pald_unit_lay
|
Units per Layer
|
|
>,>>>,>>9
|
|
|
|
pald_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pald_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pald_weight
|
Weight
|
|
>>,>>9.99
|
10
|
|
|
pald_wght_um
|
UM
|
|
x(2)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pald_det
|
yes
|
oid_pald_det
|
yes
|
no
|
|
∗
|
pald_pallet
|
yes
|
pald_domain
|
yes
|
no
|
|
|
|
|
pald_pallet
|
yes
|
no
|
|
|
|
|
pald_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pal_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pal__chr01
|
|
|
x(8)
|
|
|
|
pal__chr02
|
|
|
x(8)
|
|
|
|
pal__chr03
|
|
|
x(8)
|
|
|
|
pal__chr04
|
|
|
x(8)
|
|
|
|
pal__chr05
|
|
|
x(8)
|
|
|
|
pal__dec01
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
pal__dec02
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
pal_desc
|
Description
|
|
x(24)
|
|
|
|
pal_domain
|
Domain
|
|
x(8)
|
|
|
|
pal_height
|
Height
|
|
>>,>>9.99
|
10
|
|
|
pal_hght_um
|
UM
|
|
x(2)
|
|
|
|
pal_nbr_lay
|
Number of Layers
|
|
>,>>>,>>9
|
|
|
|
pal_pallet
|
Pallet Type
|
Type
|
x(8)
|
|
|
|
pal_um
|
UM
|
|
x(2)
|
|
|
|
pal_unit_lay
|
Units per Layer
|
|
>,>>>,>>9
|
|
|
|
pal_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pal_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pal_weight
|
Weight
|
|
>>,>>9.99
|
10
|
|
|
pal_wght_um
|
UM
|
|
x(2)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pal_mstr
|
yes
|
oid_pal_mstr
|
yes
|
no
|
|
∗
|
pal_pallet
|
yes
|
pal_domain
|
yes
|
no
|
|
|
|
|
pal_pallet
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllowInReturn
|
Allow Incoming Returns
|
InRet
|
yes/no
|
|
|
|
AllowIssue
|
Allow Issues
|
Iss
|
yes/no
|
|
|
|
AllowOutReturn
|
Allow Outgoing Returns
|
OutRet
|
yes/no
|
|
|
|
AllowReceipt
|
Allow Receipts
|
Rec
|
yes/no
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CntStatusOpt
|
Count Status Option
|
Cnt!Stat
|
>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_PartSLGM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OPCThreshold
|
OPC Threshold
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PopCode
|
Popularity
|
|
X(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
RecountUM
|
Recount UM
|
Rcnt!UM
|
x(2)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SLocGp
|
Store Loc Group
|
SLocGrp
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_PartSLGM
|
yes
|
oid_PartSLGM
|
yes
|
no
|
|
∗
|
PartSLG
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
SLocGp
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AutoReplen
|
Auto Replenish
|
Auto!Rep
|
yes/no
|
|
|
|
AutoRepPct
|
Auto Replenish %
|
Auto!Rep%
|
->>9.99%
|
2
|
|
|
ByRef
|
By Reference
|
|
yes/no
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Destructive
|
Destructive
|
Destr
|
yes/no
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
IDQty
|
ID Quantity
|
ID!Qty
|
>>>9
|
|
|
|
InspFreqDays
|
Insp Frequency (Days)
|
Insp Freq (D)
|
>>9
|
|
|
|
InspFrequency
|
Insp Frequency
|
Insp Freq.
|
>>>>>>9
|
|
|
|
InspReq
|
Inspection Required
|
Insp Req
|
yes/no
|
|
|
|
InventDays[10]
|
Days From Expiration/Manufacture
|
Days From!Expire/!Manuf.
|
>>,>>9
|
|
|
|
IssueMethod
|
Issue Method
|
Issue!Method
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
LogUM
|
Logistics UM
|
Log!UM
|
x(2)
|
|
|
|
LogUMTolPct
|
Logistics UM Tolerance
|
Log UM Tol
|
->>9.99%
|
2
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_PartWhseM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OPCThreshold
|
OPC Threshold
|
|
->>>,>>9.9<<<<<<
|
10
|
|
|
PalMaxHeight
|
Pallet Max Height
|
|
->>,>>9.99
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PartType
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
PopCode
|
Popularity
|
|
X(8)
|
|
|
|
PrintID
|
Print ID
|
Print!ID
|
yes/no
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI04
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
RandomInspPct
|
Random Inspection %
|
|
->>9.99
|
10
|
|
|
RepType
|
Replenishment Type
|
Rep Type
|
X(8)
|
|
|
|
SameDays[10]
|
Same Day Window
|
Same Day!Window
|
>>,>>9
|
|
|
|
SamplePct
|
Sample %
|
Sample %
|
>>9
|
|
|
|
SampleQty
|
Sample Quantity
|
Sample Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
SingleTrans
|
Single Put-Away Transactions
|
Single!Trans
|
yes/no
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SLGList
|
SLG List
|
|
x(8)
|
|
|
|
SLocGp
|
Store Loc Group
|
SLocGrp
|
x(8)
|
|
|
|
UnpIssPrint
|
Print Unpl Issue Tag
|
|
yes/no
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_PartWhseM
|
yes
|
oid_PartWhseM
|
yes
|
no
|
|
∗
|
PartWhse
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
WhsePartType
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
PartType
|
yes
|
no
|
|
|
WhseRepType
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
RepType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AROverPayCostCentre_ID
|
Link to CostCentre - AR OverPay
|
|
-99999999999
|
|
|
|
AROverPayDivision_ID
|
Link to Division - AR OverPay
|
|
-99999999999
|
|
|
|
AROverPayGL_ID
|
Link to GL - AR OverPay
|
|
-99999999999
|
|
|
|
ARShortPayCostCentre_ID
|
Link to CostCentre - AR ShortPay
|
|
-99999999999
|
|
|
|
ARShortPayDivision_ID
|
Link to Division - AR ShortPay
|
|
-99999999999
|
|
|
|
ARShortPayGL_ID
|
Link to GL - AR ShortPay
|
|
-99999999999
|
|
|
|
BankNumber_ID
|
Link to BankNumber
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DeductionCatLine_ID
|
Link to DeductionCatLine
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayConf_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PayConfAROverPayTolAmtTC
|
TC Over Tolerance Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PayConfAROverPayTolPct
|
Over Tolerance Percent
|
|
->>9.9999
|
4
|
|
|
PayConfARShortPayTolAmtTC
|
TC Short Tolerance Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PayConfARShortPayTolPct
|
Short Tolerance Percent
|
|
->>9.9999
|
4
|
|
|
PayConfARToleranceAmountTC
|
TC Tolerance Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PayConfARTolerancePercent
|
Tolerance Percent
|
|
->>9.9999
|
4
|
|
|
PayConfIsARToleranceAmount
|
Tolerance Amount
|
|
yes/no
|
|
|
|
PayConfIsARTolerancePercent
|
Tolerance Percent
|
|
yes/no
|
|
|
|
PayConfIsPIBFAllCompanyAlloc
|
All Entities Allocation
|
|
yes/no
|
|
|
|
PayConfIsPIBFCreateBE
|
Create Banking Entry
|
|
yes/no
|
|
|
|
PayConfIsPIBFNewDDocAsPaid
|
New Payments As Paid
|
|
yes/no
|
|
|
|
PayConfPIBFNoCustomerAction
|
If customer not found
|
|
x(40)
|
|
|
|
PayConfPIBFNoCustOrDDocAction
|
If customer or payment not found
|
|
x(40)
|
|
|
|
PayConfPIBFNoInvoiceAction
|
If no matching invoice found
|
|
x(40)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DedCatLnIdx
|
no
|
DeductionCatLine_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
OverCCIdx
|
no
|
AROverPayCostCentre_ID
|
yes
|
no
|
|
|
OverDivIdx
|
no
|
AROverPayDivision_ID
|
yes
|
no
|
|
|
OverGLIdx
|
no
|
AROverPayGL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PayConf_ID
|
yes
|
no
|
|
|
ShortCCIdx
|
no
|
ARShortPayCostCentre_ID
|
yes
|
no
|
|
|
ShortDivIdx
|
no
|
ARShortPayDivision_ID
|
yes
|
no
|
|
|
ShortGLIdx
|
no
|
ARShortPayGL_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
BankNumber_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatCode
|
Attribute Value
|
|
x(40)
|
|
|
|
PayFormatCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PayFormatCodeDescription
|
Description
|
|
x(40)
|
|
|
|
PayFormatCodeIsActive
|
Active
|
|
yes/no
|
|
|
|
PayFormatCodeIsDefault
|
Default
|
|
yes/no
|
|
|
|
PayFormatGroup_ID
|
Payment Format Type
|
Type
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
PayFormatCodeIsActive
|
yes
|
no
|
|
|
IsDefault
|
no
|
PayFormatCodeIsDefault
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PayFormatCode_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
PayFormatCode
|
yes
|
no
|
|
|
|
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
PayFormatCodeIsActive
|
yes
|
no
|
|
|
|
|
PayFormatCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PayFormatGroupCode
|
Attribute Name
|
|
x(200)
|
|
|
|
PayFormatGroupDataType
|
Data Type
|
|
x(20)
|
|
|
|
PayFormatGroupDescription
|
Description
|
|
x(40)
|
|
|
|
PayFormatGroupInputOption
|
Input Option
|
|
x(20)
|
|
|
|
PayFormatGroupIsActive
|
Active
|
|
yes/no
|
|
|
|
PayFormatGroupIsMandatory
|
Mandatory
|
|
yes/no
|
|
|
|
PayFormatGroupLevel
|
Level
|
|
x(20)
|
|
|
|
PayFormatGroupSequence
|
Group Code
|
|
->,>>>,>>9
|
|
|
|
PayFormatTypeCode
|
Payment Format Type
|
Type
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
FormatTypeSeq
|
yes
|
PayFormatTypeCode
|
yes
|
no
|
|
|
|
|
PayFormatGroupSequence
|
yes
|
no
|
|
|
GroupType
|
no
|
PayFormatGroupCode
|
yes
|
no
|
|
|
|
|
PayFormatTypeCode
|
yes
|
no
|
|
|
IsActive
|
no
|
PayFormatGroupIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
PayFormatTypeCode
|
yes
|
no
|
|
|
|
|
PayFormatGroupCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
PayFormatGroupIsActive
|
yes
|
no
|
|
|
|
|
PayFormatTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatTypeCode
|
Format Name
|
|
x(20)
|
|
|
|
PayFormatTypeDescription
|
Description
|
|
x(40)
|
|
|
|
PayFormatTypeIsActive
|
Active
|
|
yes/no
|
|
|
|
PayFormatTypeIsSEPA
|
SEPA
|
|
yes/no
|
|
|
|
PayFormatTypeLinesPerPage
|
Invoices per check
|
|
>>>9
|
|
|
|
PayFormatTypeModule
|
Module
|
|
x(20)
|
|
|
|
PayFormatTypeOutFileMask
|
Output File Mask
|
|
x(40)
|
|
|
|
PayFormatTypePayInstrument
|
Payment Instrument
|
|
x(40)
|
|
|
|
PayFormatTypePayType
|
Payment Type
|
|
x(20)
|
|
|
|
PayFormatTypeSubSystem
|
Sub System
|
|
x(40)
|
|
|
|
PayFormatTypeTPAddress
|
TP Address
|
|
x(40)
|
|
|
|
PayFormatTypeTPSite
|
TP Site
|
|
x(40)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
IsActive
|
no
|
PayFormatTypeIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PayFormatTypeCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
PayFormatTypeIsActive
|
yes
|
no
|
|
|
|
|
PayFormatTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BillSchedule_ID
|
Link to BillSchedule
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaymentCondition_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaymentConditionBaseDate
|
Base Date
|
|
99/99/9999
|
|
|
|
PaymentConditionBaseDays
|
Base Days
|
|
->,>>>,>>9
|
|
|
|
PaymentConditionCode
|
Credit Terms Code
|
|
x(8)
|
|
|
|
PaymentConditionDayMthDisc
|
No of Periods
|
|
->,>>>,>>9
|
|
|
|
PaymentConditionDaysMonths
|
No of Periods
|
|
->,>>>,>>9
|
|
|
|
PaymentConditionDescript
|
Description
|
|
x(40)
|
|
|
|
PaymentConditionDueDays
|
Min Due Days
|
|
->,>>>,>>9
|
|
|
|
PaymentConditionGraceDay
|
Grace Days
|
|
->,>>>,>>9
|
|
|
|
PaymentConditionIsActive
|
Active
|
|
yes/no
|
|
|
|
PaymentConditionLateInt
|
Daily Overdue Int Percentage
|
Late Interest
|
->>>9.99
|
2
|
|
|
PaymentConditionPaymentTyp
|
Payment Type
|
Pay Type
|
x(20)
|
|
|
|
PaymentConditionPdDiscType
|
Period Type
|
Type
|
x(20)
|
|
|
|
PaymentConditionPercentage
|
Discount Percentage
|
Percent
|
->,>>>,>>9.99
|
3
|
|
|
PaymentConditionPeriodType
|
Period Type
|
Type
|
x(20)
|
|
|
|
PaymentConditionSupDayDisc
|
Supplementary Days
|
Suppl Days
|
->,>>>,>>9
|
|
|
|
PaymentConditionSupplDays
|
Supplementary Days
|
Suppl Days
|
->,>>>,>>9
|
|
|
|
PaymentConditionTermsInt
|
Terms Interest Percentage
|
Terms Int
|
->>>9.99
|
2
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BillSIdx
|
no
|
BillSchedule_ID
|
yes
|
no
|
|
|
Code
|
yes
|
PaymentConditionCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaymentCondition_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
PaymentConditionIsActive
|
yes
|
no
|
|
|
|
|
PaymentConditionCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaymentCondition_ID
|
Credit Terms Code
|
Cred Trm
|
-99999999999
|
|
|
|
PaymentConditionStaged_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaymentConditionStagedPerc
|
Percentage
|
|
->>>9.99
|
10
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
StagedPaymentCondition_ID
|
Credit Terms
|
Payment Condition
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
LMIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
PayCon
|
no
|
PaymentCondition_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaymentConditionStaged_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
PaymentCondition_ID
|
yes
|
no
|
|
|
|
|
StagedPaymentCondition_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaymentGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaymentGroupCode
|
Payment Group
|
|
x(20)
|
|
|
|
PaymentGroupDescription
|
Description
|
|
x(40)
|
|
|
|
PaymentGroupIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
PaymentGroupCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaymentGroup_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
PaymentGroupIsActive
|
yes
|
no
|
|
|
|
|
PaymentGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankPayFormat_ID
|
Link to BankPayFormat
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
GL_ID
|
Account
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaySel_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaySelApprovalStatus
|
Approval Status
|
|
x(20)
|
|
|
|
PaySelCode
|
Code
|
|
x(20)
|
|
|
|
PaySelDate
|
Execution Date
|
|
99/99/9999
|
|
|
|
PaySelStatus
|
Status
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ApprStatIdx
|
no
|
PaySelApprovalStatus
|
yes
|
no
|
|
|
BankPayFormIdx
|
no
|
BankPayFormat_ID
|
yes
|
no
|
|
|
Code
|
no
|
PaySelCode
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CompanyGLPaySelCode
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
PaySelCode
|
yes
|
no
|
|
|
CompanyPaySelDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PaySelDate
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
PaySelDate
|
no
|
PaySelDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaySel_ID
|
yes
|
no
|
|
|
StatusField
|
no
|
PaySelStatus
|
yes
|
no
|
|
|
UniqueKey
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PaySelCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaySel_ID
|
Link to PaySel
|
|
-99999999999
|
|
|
|
PaySelHistory_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaySelHistoryApprovalComments
|
Approval Comments
|
|
x(255)
|
|
|
|
PaySelHistoryApprovalStatus
|
Approval Status
|
|
x(20)
|
|
|
|
PaySelHistoryDate
|
Date
|
|
99/99/9999
|
|
|
|
PaySelHistoryDescription
|
Description
|
|
x(40)
|
|
|
|
PaySelHistoryOutFileName
|
File
|
|
x(255)
|
|
|
|
PaySelStatus
|
Status
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Usr_ID
|
Login
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
PaySel
|
no
|
PaySel_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaySelHistory_ID
|
yes
|
no
|
|
|
Usr
|
no
|
Usr_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankNumber_ID
|
Link to BankNumber
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatTypeCode
|
Payment format of the payment selection
|
|
x(20)
|
|
|
|
PaySel_ID
|
Link to PaySel
|
|
-99999999999
|
|
|
|
PaySelLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaySelLineAmountTC
|
Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineDiscountTC
|
Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineIntAmtTC
|
TC Interest Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineIsConfirmed
|
Confirmed
|
|
yes/no
|
|
|
|
PaySelLineIsRefInFile
|
Ref in File
|
|
yes/no
|
|
|
|
PaySelLineObjectType
|
Type
|
|
x(20)
|
|
|
|
PaySelLineParentObject_ID
|
Parent Object
|
|
-99999999999
|
|
|
|
PaySelLineWHTAmtCC
|
SC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineWHTAmtLC
|
BC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankNumber
|
no
|
BankNumber_ID
|
yes
|
no
|
|
|
KeyPayFormatType
|
no
|
PayFormatTypeCode
|
yes
|
no
|
|
|
ObjectType
|
no
|
PaySelLineObjectType
|
yes
|
no
|
|
|
ParentObject
|
no
|
PaySelLineParentObject_ID
|
yes
|
no
|
|
|
PaySel
|
no
|
PaySel_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaySelLine_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CInvoiceStage_ID
|
Link to CInvoiceStage
|
|
-99999999999
|
|
|
|
DInvoiceStage_ID
|
Link to DInvoiceStage
|
|
-99999999999
|
|
|
|
PaySel_ID
|
Link to PaySel
|
|
-99999999999
|
|
|
|
PaySelLine_ID
|
Link to PaySelLine
|
|
-99999999999
|
|
|
|
PaySelLineStage_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaySelLineStageDiscAmntTC
|
Discount Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineStageIntAmtTC
|
Interest Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineStageOpenAmntTC
|
Open Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineStageOrigAmntTC
|
Original Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineStagePaymAmntTC
|
Payment Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelLineStageWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CInvoiceStage
|
no
|
CInvoiceStage_ID
|
yes
|
no
|
|
|
DInvoiceStage
|
no
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
PaySel
|
no
|
PaySel_ID
|
yes
|
no
|
|
|
PaySelLine
|
no
|
PaySelLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaySelLineStage_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
PaySelLine_ID
|
yes
|
no
|
|
|
|
|
CInvoiceStage_ID
|
yes
|
no
|
|
|
|
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatCode_ID
|
Link to PayFormatCode
|
|
-99999999999
|
|
|
|
PayFormatGroup_ID
|
Link to PayFormatGroup
|
|
-99999999999
|
|
|
|
PaySel_ID
|
Link to PaySel
|
|
-99999999999
|
|
|
|
PaySelPayCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaySelPayCodeValue
|
Value
|
|
x(40)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
PFCodeIdx
|
no
|
PayFormatCode_ID
|
yes
|
no
|
|
|
PFGroupIdx
|
no
|
PayFormatGroup_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaySelPayCode_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
PaySel_ID
|
yes
|
no
|
|
|
|
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusinessRelation_ID
|
Business Relation
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Cost Center
|
Cost Center
|
-99999999999
|
|
|
|
Creditor_ID
|
Supplier Code
|
Supplier
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
Division_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaySelLine_ID
|
Payment Selection Line
|
|
-99999999999
|
|
|
|
PaySelPrepay_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PaySelPrepayAmountToPayTC
|
Amount to Pay
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PaySelPrepayReferenceText
|
Reference
|
|
x(40)
|
|
|
|
Project_ID
|
Project
|
Project
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusinessRelation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
CCIdx
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Creditor
|
no
|
Creditor_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
Division_ID
|
yes
|
no
|
|
|
PaySelLnIdx
|
no
|
PaySelLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PaySelPrepay_ID
|
yes
|
no
|
|
|
PrjIdx
|
no
|
Project_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
PaySelLine_ID
|
yes
|
no
|
|
|
|
|
Creditor_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pcc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pcc__qadc01
|
|
|
x(8)
|
|
|
|
pcc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
pcc_auto_nbr
|
Auto Number
|
Auto
|
yes/no
|
|
|
|
pcc_cmmt_type
|
Comment Type
|
|
X(2)
|
|
|
|
pcc_comm_lang
|
Common Language
|
|
X(2)
|
|
|
|
pcc_db_seq
|
Common DB Sequence
|
|
>>>9
|
|
|
|
pcc_domain
|
Domain
|
|
x(8)
|
|
|
|
pcc_ecooff_date
|
ECO Off Date
|
|
99/99/99
|
|
|
|
pcc_enforce_seq
|
Enforce PCO Approval Group Sequencing
|
Enforce Seq
|
yes/no
|
|
|
|
pcc_formula_ok
|
Formula OK
|
|
yes/no
|
|
|
|
pcc_initial_date
|
Initialization Date
|
|
99/99/99
|
|
|
|
pcc_max_wkfl
|
Max Workfile
|
|
>>>9
|
|
|
|
pcc_next_pco[12]
|
Next Change Number
|
|
>>>>>>>>9
|
|
|
|
pcc_pco_pre[12]
|
Prefix
|
|
X(3)
|
|
|
|
pcc_process_ok
|
Process OK
|
|
yes/no
|
|
|
|
pcc_qspec_ok
|
PSM OK
|
|
yes/no
|
|
|
|
pcc_quality_ok
|
Quality OK
|
|
yes/no
|
|
|
|
pcc_routing_ok
|
Routings OK
|
|
yes/no
|
|
|
|
pcc_security_on
|
Security On
|
|
yes/no
|
|
|
|
pcc_struct_ok
|
Structures OK
|
|
yes/no
|
|
|
|
pcc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pcc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pcc_ctrl
|
yes
|
oid_pcc_ctrl
|
yes
|
no
|
|
∗
|
pcc_index
|
yes
|
pcc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pcd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pcd__qad01
|
|
|
99/99/99
|
|
|
|
pcd__qad02
|
|
|
x(8)
|
|
|
|
pcd__qad03
|
|
|
yes/no
|
|
|
|
pcd__qad04
|
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
pcd__qad05
|
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
pcd_amt
|
Amount
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
pcd_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
pcd_domain
|
Domain
|
|
x(8)
|
|
|
|
pcd_element
|
Cost Element
|
Element
|
x(8)
|
|
|
|
pcd_line
|
Line
|
Ln
|
>>9
|
|
|
|
pcd_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
pcd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pcd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pcd_det
|
yes
|
oid_pcd_det
|
yes
|
no
|
|
∗
|
pcd_ele
|
yes
|
pcd_domain
|
yes
|
no
|
|
|
|
|
pcd_nbr
|
yes
|
no
|
|
|
|
|
pcd_line
|
yes
|
no
|
|
|
|
|
pcd_element
|
yes
|
no
|