QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
OrdAllocH
Warehousing Order Allocation History
 
 
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
OrderD
Warehousing Order Detail
 
 
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
OrderM
Warehousing Order Master
 
 
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
OrderSelD
Warehousing Order Batch Selection Detail
 
 
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
OrderSelM
Warehousing Order Batch Selection Master
 
 
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
pac_mstr
Purchase Approval Code Master
 
 
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
pald_det
Pallet Detail
 
 
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
pal_mstr
Pallet Master
 
 
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
PartSLGM
Warehousing Item/Storage Location Group Master
 
 
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
PartWhseM
Warehousing Item/Warehouse Master
 
 
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
PayConf
Payment Configuration
 
 
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
PayFormatCode
Payment Format Code
 
 
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
PayFormatGroup
Payment Format Group
 
 
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
PayFormatType
Payment Format Type
 
 
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
PaymentCondition
Credit Terms
 
 
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
PaymentConditionStaged
Staged Payment
 
 
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
PaymentGroup
Payment Group
 
 
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
PaySel
Payment Selection
 
 
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
PaySelHistory
Payment Selection History
 
 
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
PaySelLine
Payment Selection Line
 
 
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
PaySelLineStage
Payment Selection Line Stage
 
 
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
PaySelPayCode
Payment Selection Payment Code
 
 
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
PaySelPrepay
Payment Selection Prepayment
 
 
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
pcc_ctrl
Product Change Control
 
 
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
pcd_det
Purchase Order Line Cost Element Detail
 
 
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