|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BudgetWBS_ID
|
Link to BudgetWBS
|
|
-99999999999
|
|
|
|
BudgetWBSRoster_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BudgetWBSRosterDate
|
Date
|
|
99/99/9999
|
|
|
|
BudgetWBSRosterPercOfComp
|
Percentage (ETC)
|
|
->>>,>>>,>>9.99
|
3
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BudgetWBSDate
|
yes
|
BudgetWBSRosterDate
|
yes
|
no
|
|
|
|
|
BudgetWBS_ID
|
yes
|
no
|
|
|
BudgetWBSIdx
|
no
|
BudgetWBS_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
BudgetWBSRoster_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AutoApprove
|
Auto Approve
|
Auto!Appr
|
yes/no
|
|
|
|
AutoReselect
|
Automatically Reselect BPs
|
Auto BP
|
yes/no
|
|
|
|
BPNRID
|
Bulk Pick NR ID
|
BP NR ID
|
X(8)
|
|
|
|
BulkPickHistory
|
Bulk Pick History
|
Hist
|
yes/no
|
|
|
|
CompAlloc
|
Compon Alloc
|
|
yes/no
|
|
|
|
CreateBP
|
Create Bulk Picking Orders
|
Create!BP
|
yes/no
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
LoadNRID
|
Load NR ID
|
|
X(8)
|
|
|
|
MinWOStatus
|
Min Status for WO Selection
|
|
x(1)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
NetWtUM
|
Net Weight UM
|
Net!UM
|
x(2)
|
|
|
|
oid_BulkPickC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OWPartial
|
Overwrite Partial
|
|
yes/no
|
|
|
|
PickSheets
|
Bulk Pick-Sheets
|
Pick!Sheet
|
yes/no
|
|
|
|
PreShippers
|
Pre-Shippers
|
PreShip
|
yes/no
|
|
|
|
PreShipSeqID
|
Preshipper Sequence ID
|
|
X(8)
|
|
|
|
PrintPSList
|
Print Pre-Ship List
|
|
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
|
|
|
|
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
|
|
|
|
QuantityUM
|
Quantity UM
|
Qty!UM
|
x(2)
|
|
|
|
SelByCode
|
Select By
|
Sel
|
x(1)
|
|
|
|
SelByPri
|
Select by Priority
|
Pri!Sel
|
yes/no
|
|
|
|
SelectAll
|
Select All
|
Sel!All
|
yes/no
|
|
|
|
ShipWtUM
|
Ship Weight UM
|
Ship!UM
|
x(2)
|
|
|
|
SOAutoAlloc
|
Auto All Sales Orders
|
|
yes/no
|
|
|
|
UniqueID
|
|
|
9
|
|
|
|
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
|
|
|
|
VolumeUM
|
Volume UM
|
Vol!UM
|
x(2)
|
|
|
|
WORelease
|
Release Work Orders
|
Rel!WO
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_BulkPickC
|
yes
|
oid_BulkPickC
|
yes
|
no
|
|
∗
|
UniqueID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
UniqueID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AllocNbr
|
Allocation Order
|
|
x(18)
|
|
|
|
BPStatus
|
Status
|
|
x(8)
|
|
|
|
BulkPick
|
Bulk Pick
|
Bulk!Pick
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
FailRmks
|
Fail Remarks
|
|
x(24)
|
|
|
|
IssueMethod
|
Issue Method
|
|
x(8)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
LoadID
|
Load ID
|
|
X(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_BulkPickD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PreShipper
|
PreShipper
|
|
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
|
|
|
|
QtyPick
|
Quantity Picked
|
Quantity!Picked
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
Route
|
Route
|
|
X(8)
|
|
|
|
ShipData
|
Shipping Data
|
Ship Data
|
x(8)
|
|
|
|
Shipper
|
Shipper
|
Shipper
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
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
|
|
|
|
Weight
|
Weight
|
Wt
|
>>,>>9.99
|
2
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
BPDIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
AllocNbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
LoadID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
LoadID
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
oid_BulkPickD
|
yes
|
oid_BulkPickD
|
yes
|
no
|
|
|
OrderIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
AllocNbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
PreShipper
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
PreShipper
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
AllocNbr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
Shipper
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Shipper
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
AllocNbr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
TrNbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
BPStatus
|
Status
|
|
x(8)
|
|
|
|
BulkPick
|
Bulk Pick
|
Bulk!Pick
|
x(8)
|
|
|
|
CloseDate
|
Closed
|
|
99/99/99
|
|
|
|
CloseUserID
|
Closed
|
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DNbr
|
Order Nbr
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
FailRmks
|
Fail Remarks
|
|
x(24)
|
|
|
|
IssueMethod
|
Issue Method
|
|
x(8)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
LoadID
|
Load ID
|
|
X(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_BulkPickDH
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PreShipper
|
PreShipper
|
|
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
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QtyPick
|
Quantity Picked
|
Quantity!Picked
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
Route
|
Route
|
|
X(8)
|
|
|
|
ShipData
|
Shipping Data
|
Ship Data
|
x(8)
|
|
|
|
Shipper
|
Shipper
|
Shipper
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
BPDHIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
BPDOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
LoadID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
LoadID
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
oid_BulkPickDH
|
yes
|
oid_BulkPickDH
|
yes
|
no
|
|
|
PreShipper
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
PreShipper
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
Shipper
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Shipper
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
TrNbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BulkPick
|
Bulk Pick
|
Bulk!Pick
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>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_BulkPickM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
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
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
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
|
|
∗
|
BulkPick
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
BulkPick
|
yes
|
no
|
|
|
oid_BulkPickM
|
yes
|
oid_BulkPickM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusArea_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BusAreaAccelerator
|
Accelerator
|
|
>>>9
|
|
|
|
BusAreaCode
|
Code
|
|
x(40)
|
|
|
|
BusAreaIsActive
|
Active
|
|
yes/no
|
|
|
|
BusAreaIsCustomised
|
Customised
|
|
yes/no
|
|
|
|
BusAreaIsSysDef
|
System Defined
|
|
yes/no
|
|
|
|
BusAreaLabel
|
Label
|
|
x(40)
|
|
|
|
BusAreaSequence
|
Sequence
|
Seq
|
>>>9
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
BusAreaCode
|
yes
|
no
|
|
|
LabelIdx
|
yes
|
BusAreaLabel
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BusArea_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusArea_ID
|
Business Area
|
|
-99999999999
|
|
|
|
BusAreaCompIsCustomised
|
Customised
|
|
yes/no
|
|
|
|
BusAreaComponent_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BusAreaComponentSequence
|
Sequence
|
Seq
|
>>>9
|
|
|
|
BusComponent_ID
|
Business Component
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Arera
|
no
|
BusArea_ID
|
yes
|
no
|
|
|
Component
|
no
|
BusComponent_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BusAreaComponent_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusinessRelation_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BusinessRelationAVRCode
|
AVR Code
|
|
x(20)
|
|
|
|
BusinessRelationCode
|
Business Relation
|
Business Relation Code
|
x(20)
|
|
|
|
BusinessRelationComRegisterNbr
|
Commercial Register ID
|
|
x(20)
|
|
|
|
BusinessRelationEANCode
|
EAN Code
|
|
x(20)
|
|
|
|
BusinessRelationICCode
|
Intercompany Code
|
|
x(20)
|
|
|
|
BusinessRelationInstCode
|
Institution Code
|
|
x(20)
|
|
|
|
BusinessRelationInstNbr
|
Institution ID
|
|
x(20)
|
|
|
|
BusinessRelationIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
BusinessRelationIsCompens
|
Customer/Supplier Compensation Allowed
|
DR/CR Compensation
|
yes/no
|
|
|
|
BusinessRelationIsDomRestr
|
Domain Restricted
|
|
yes/no
|
|
|
|
BusinessRelationIsInComp
|
Internal Entity
|
|
yes/no
|
|
|
|
BusinessRelationIsInterco
|
Intercompany
|
|
yes/no
|
|
|
|
BusinessRelationIsLastFill
|
Last Filing
|
|
yes/no
|
|
|
|
BusinessRelationIsTaxRep
|
Tax Report
|
|
yes/no
|
|
|
|
BusinessRelationName1
|
Name
|
Business Relation Name
|
x(36)
|
|
|
|
BusinessRelationName2
|
Second Name
|
|
x(36)
|
|
|
|
BusinessRelationName3
|
Third Name
|
|
x(60)
|
|
|
|
BusinessRelationNameCtrl
|
Name Control
|
|
x(5)
|
|
|
|
BusinessRelationOrgType
|
Organization Type
|
|
x(20)
|
|
|
|
BusinessRelationSearchName
|
Search Name
|
|
x(28)
|
|
|
|
CorporateGroup_ID
|
Group Name
|
|
-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
|
|
|
|
CustomDate5
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate6
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate7
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate8
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate9
|
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)
|
|
|
|
Domain_ID
|
Link to Domains
|
|
-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)
|
|
|
|
Lng_ID
|
Language Code
|
Lang
|
-99999999999
|
|
|
|
ObsoleteCostPriceList_ID
|
Costing Price List
|
|
-99999999999
|
|
|
|
ObsoletePurchPriceList_ID
|
Purchase Price List
|
|
-99999999999
|
|
|
|
ObsoleteSalesPriceList_ID
|
Sales Price List
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActName1
|
no
|
BusinessRelationIsActive
|
yes
|
no
|
|
|
|
|
BusinessRelationName1
|
yes
|
no
|
|
|
ActName2
|
no
|
BusinessRelationIsActive
|
yes
|
no
|
|
|
|
|
BusinessRelationName2
|
yes
|
no
|
|
|
ActName3
|
no
|
BusinessRelationIsActive
|
yes
|
no
|
|
|
|
|
BusinessRelationName3
|
yes
|
no
|
|
|
ActSearch
|
no
|
BusinessRelationIsActive
|
yes
|
no
|
|
|
|
|
BusinessRelationSearchName
|
yes
|
no
|
|
|
BusinessRel
|
yes
|
BusinessRelationCode
|
yes
|
no
|
|
|
CorporateGrp
|
no
|
CorporateGroup_ID
|
yes
|
no
|
|
|
DomainIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
IntercoCode
|
no
|
BusinessRelationICCode
|
yes
|
no
|
|
|
IsDomRestr
|
no
|
BusinessRelationIsDomRestr
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
LngIdx
|
no
|
Lng_ID
|
yes
|
no
|
|
|
Name1
|
no
|
BusinessRelationName1
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BusinessRelation_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
BusinessRelationIsActive
|
yes
|
no
|
|
|
|
|
BusinessRelationCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
BusRelationSafDefault_ID
|
Record ID
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusRel
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BusRelationSafDefault_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafConc
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
SafConcept_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cac__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
cac__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
cac__qadi01
|
|
|
->>>>>>>9
|
|
|
|
cac__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
cac__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
cac_contract_price
|
Contract Price From
|
|
x(8)
|
|
|
|
cac_domain
|
Domain
|
|
x(8)
|
|
|
|
cac_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
cac_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cac_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
cac_mulskill_wnd
|
Multiple Skills
|
|
yes/no
|
|
|
|
cac_nbr
|
Next Call Id
|
|
99999999
|
|
|
|
cac_quote
|
Next Quote Id
|
|
99999999
|
|
|
|
cac_quote_days
|
Days Until Expire
|
|
->,>>>,>>9
|
|
|
|
cac_quote_pre
|
Quote Prefix
|
|
x(3)
|
|
|
|
cac_quote_que
|
Default Quote Queue
|
|
x(8)
|
|
|
|
cac_upd_isb
|
Calls Update ISB
|
Update ISB
|
yes/no
|
|
|
|
cac_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cac_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cac_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cac_index1
|
yes
|
cac_domain
|
yes
|
no
|
|
|
oid_cac_ctrl
|
yes
|
oid_cac_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cah__chr01
|
|
|
x(8)
|
|
|
|
cah__chr02
|
|
|
x(8)
|
|
|
|
cah__chr03
|
|
|
x(8)
|
|
|
|
cah__chr04
|
|
|
x(8)
|
|
|
|
cah__chr05
|
|
|
x(8)
|
|
|
|
cah__chr06
|
|
|
x(8)
|
|
|
|
cah__chr07
|
|
|
x(8)
|
|
|
|
cah__chr08
|
|
|
x(8)
|
|
|
|
cah__chr09
|
|
|
x(8)
|
|
|
|
cah__chr10
|
|
|
x(8)
|
|
|
|
cah__chr11
|
User Field #11
|
|
x(8)
|
|
|
|
cah__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
cah__dec02
|
|
|
->>,>>9.99
|
10
|
|
|
cah__dec03
|
|
|
->>,>>9.99
|
10
|
|
|
cah__dte01
|
|
|
99/99/99
|
|
|
|
cah__dte02
|
|
|
99/99/99
|
|
|
|
cah__dte03
|
|
|
99/99/99
|
|
|
|
cah__dte04
|
|
|
99/99/99
|
|
|
|
cah__dte05
|
|
|
99/99/99
|
|
|
|
cah__log01
|
|
|
yes/no
|
|
|
|
cah__log02
|
|
|
yes/no
|
|
|
|
cah__log03
|
|
|
yes/no
|
|
|
|
cah__log04
|
|
|
yes/no
|
|
|
|
cah__log05
|
|
|
yes/no
|
|
|
|
cah__qadc01
|
|
|
x(8)
|
|
|
|
cah__qadc02
|
|
|
x(8)
|
|
|
|
cah__qadc03
|
|
|
x(8)
|
|
|
|
cah__qadd01
|
|
|
->>,>>9.99
|
10
|
|
|
cah__qadd02
|
|
|
->>,>>9.99
|
10
|
|
|
cah__qadd03
|
|
|
->>,>>9.99
|
10
|
|
|
cah__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
cah__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
cah__qadi03
|
|
|
->,>>>,>>9
|
|
|
|
cah__qadl01
|
|
|
yes/no
|
|
|
|
cah__qadl02
|
|
|
yes/no
|
|
|
|
cah__qadl03
|
|
|
yes/no
|
|
|
|
cah__qadt01
|
|
|
99/99/99
|
|
|
|
cah__qadt02
|
|
|
99/99/99
|
|
|
|
cah__qadt03
|
|
|
99/99/99
|
|
|
|
cah_area
|
Area
|
|
x(8)
|
|
|
|
cah_assign
|
Assigned
|
|
x(8)
|
0
|
|
|
cah_billed
|
Billed
|
|
yes/no
|
|
|
|
cah_category
|
Category
|
|
x(8)
|
0
|
|
|
cah_cmmt_mod
|
Comments Modified
|
Cmt
|
yes/no
|
|
|
|
cah_cmtindx
|
Index
|
|
>>>>>>>9
|
|
|
|
cah_code
|
|
|
x(8)
|
|
|
|
cah_contract
|
Contract
|
|
x(8)
|
|
|
|
cah_date_stmp
|
Date
|
|
99/99/99
|
|
|
|
cah_desc
|
Description
|
|
x(60)
|
|
|
|
cah_domain
|
Domain
|
|
x(8)
|
|
|
|
cah_eng_area
|
Engineer Area
|
|
x(8)
|
|
|
|
cah_eng_group
|
Group
|
|
x(8)
|
|
|
|
cah_enter_by
|
Entered by
|
|
x(8)
|
|
|
|
cah_es_nbr
|
Escalation
|
Esc
|
x(8)
|
0
|
|
|
cah_es_seq
|
Sequence
|
Seq
|
>>9
|
|
|
|
cah_escalate
|
Escalate
|
Esc
|
x(2)
|
|
|
|
cah_eu_date
|
End User Date
|
|
99/99/99
|
|
|
|
cah_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
cah_eu_time
|
End User Time
|
|
99:99
|
|
|
|
cah_evt_date
|
Event Date
|
Evt Date
|
99/99/99
|
|
|
|
cah_evt_time
|
Event Time
|
Time
|
99:99
|
|
|
|
cah_from_que
|
From Que
|
Fr Que
|
x(8)
|
|
|
|
cah_int_type
|
Work Code
|
WK Code
|
x(8)
|
|
|
|
cah_name
|
Caller Name
|
Name
|
x(24)
|
|
|
|
cah_nbr
|
Call Id
|
|
x(8)
|
|
|
|
cah_nxt_act
|
Next Status
|
Nxt Sts
|
x(8)
|
|
|
|
cah_nxt_date
|
Next Status Date
|
Nxt Date
|
99/99/99
|
|
|
|
cah_nxt_time
|
Next Status Time
|
Time
|
99:99
|
|
|
|
cah_opn_date
|
Open Date
|
|
99/99/99
|
|
|
|
cah_part
|
Part No
|
|
x(18)
|
|
|
|
cah_phone
|
Phone
|
|
x(16)
|
|
|
|
cah_pri
|
Priority
|
Pri
|
>>>9
|
|
|
|
cah_problem
|
Prob/Skill
|
Prob
|
x(8)
|
|
|
|
cah_que
|
Queue
|
|
x(8)
|
0
|
|
|
cah_ref
|
ISB Ref
|
|
>>>>>9
|
|
|
|
cah_resolve
|
Resolution
|
|
x(8)
|
|
|
|
cah_seq
|
Sequence
|
Seq
|
>>>>>>9
|
|
|
|
cah_serial
|
Serial
|
|
x(18)
|
|
|
|
cah_severity
|
Severity
|
|
x(8)
|
|
|
|
cah_snt_date
|
|
|
99/99/99
|
|
|
|
cah_snt_time
|
|
|
->,>>>,>>9
|
|
|
|
cah_status
|
Status
|
|
x(8)
|
|
|
|
cah_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
cah_time_log
|
Time Spent
|
|
>>9.99
|
10
|
|
|
cah_time_stmp
|
Time
|
|
99:99
|
|
|
|
cah_trv_dist
|
Travel Distance
|
Trvl Dst
|
->,>>>,>>9
|
|
|
|
cah_trv_um
|
Travel UM
|
UM
|
x(2)
|
|
|
|
cah_type
|
Type
|
|
x(8)
|
0
|
|
|
cah_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cah_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_cah_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cah_nbr
|
yes
|
cah_domain
|
yes
|
no
|
|
|
|
|
cah_nbr
|
yes
|
no
|
|
|
|
|
cah_opn_date
|
yes
|
no
|
|
|
|
|
cah_seq
|
yes
|
no
|
|
|
cah_part
|
no
|
cah_domain
|
yes
|
no
|
|
|
|
|
cah_part
|
yes
|
no
|
|
|
oid_cah_hist
|
yes
|
oid_cah_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cald__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
cald__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
cald_end
|
End
|
|
99/99/99
|
|
|
|
cald_hours
|
Daily Hours
|
Hours
|
->>,>>9.99
|
10
|
|
|
cald_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cald_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cald_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
cald_shift1
|
Shift_1
|
|
->>,>>9.99
|
10
|
|
|
cald_shift2
|
Shift_2
|
|
->>,>>9.99
|
10
|
|
|
cald_shift3
|
Shift_3
|
|
->>,>>9.99
|
10
|
|
|
cald_shift4
|
Shift_4
|
|
->>,>>9.99
|
10
|
|
|
cald_start
|
Start
|
|
99/99/99
|
|
|
|
cald_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cald_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_cald_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_calm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cald_oid_calm_mstr
|
yes
|
oid_calm_mstr
|
yes
|
no
|
|
|
|
|
cald_ref
|
yes
|
no
|
|
|
|
|
cald_start
|
yes
|
no
|
|
|
oid_cald_det
|
yes
|
oid_cald_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Calendar
|
Calendar
|
Calendar
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DayID
|
Weekday
|
Week!Day
|
9
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
EndTime
|
EndTime
|
EndTime
|
>9.99
|
2
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_CalendarD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
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
|
|
|
|
Seq
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
StartTime
|
StartTime
|
StartTime
|
>9.99
|
2
|
|
|
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
|
|
∗
|
Calendar
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Calendar
|
yes
|
no
|
|
|
|
|
Seq
|
yes
|
no
|
|
|
|
|
DayID
|
yes
|
no
|
|
|
oid_CalendarD
|
yes
|
oid_CalendarD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Calendar
|
Calendar
|
Calendar
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
EndDate
|
End Date
|
End
|
99/99/99
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_CalendarM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
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
|
|
|
|
StartDate
|
Start Date
|
Start
|
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
|
|
∗
|
Calendar
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Calendar
|
yes
|
no
|
|
|
oid_CalendarM
|
yes
|
oid_CalendarM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
calh__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
calh__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
calh_date
|
Date
|
|
99/99/99
|
|
|
|
calh_desc
|
Holiday
|
|
x(24)
|
|
|
|
calh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
calh_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
calh_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
calh_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_calh_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_calm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
calh_oid_calm_mstr
|
yes
|
oid_calm_mstr
|
yes
|
no
|
|
|
|
|
calh_date
|
yes
|
no
|
|
|
oid_calh_det
|
yes
|
oid_calh_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
calm__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
calm__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
calm_domain
|
Domain
|
|
x(8)
|
|
|
|
calm_hours[7]
|
Daily Hours
|
Hours
|
->>,>>9.99
|
10
|
|
|
calm_key1
|
Key 1
|
|
x(8)
|
|
|
|
calm_key2
|
Key 2
|
|
x(8)
|
|
|
|
calm_key3
|
Key 3
|
|
x(8)
|
|
|
|
calm_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
calm_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
calm_shifts[7]
|
Shifts
|
|
yes/no
|
|
|
|
calm_type
|
|
|
>>>>>>>9
|
|
|
|
calm_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
calm_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
calm_wdays[7]
|
Workdays
|
|
yes/no
|
|
|
|
oid_calm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
calm_mstr
|
yes
|
calm_domain
|
yes
|
no
|
|
|
|
|
calm_type
|
yes
|
no
|
|
|
|
|
calm_key1
|
yes
|
no
|
|
|
|
|
calm_key2
|
yes
|
no
|
|
|
|
|
calm_key3
|
yes
|
no
|
|
|
oid_calm_mstr
|
yes
|
oid_calm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cals__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
cals__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
cals_day
|
Day of Week
|
Day
|
9
|
|
|
|
cals_hour1
|
Hours
|
|
>,>>9.9<
|
10
|
|
|
cals_hour2
|
Hours
|
|
>,>>9.9<
|
10
|
|
|
cals_hour3
|
Hours
|
|
>,>>9.9<
|
10
|
|
|
cals_hour4
|
Hours
|
|
>,>>9.9<
|
10
|
|
|
cals_load1
|
Load
|
|
>>9.99%
|
10
|
|
|
cals_load2
|
Load
|
|
>>9.99%
|
10
|
|
|
cals_load3
|
Load
|
|
>>9.99%
|
10
|
|
|
cals_load4
|
Load
|
|
>>9.99%
|
10
|
|
|
cals_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cals_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cals_pat1
|
Pattern
|
|
x(8)
|
|
|
|
cals_pat2
|
Pattern
|
|
x(8)
|
|
|
|
cals_pat3
|
Pattern
|
|
x(8)
|
|
|
|
cals_pat4
|
Pattern
|
|
x(8)
|
|
|
|
cals_start1
|
Start Time
|
Start
|
>,>>9.9<<
|
10
|
|
|
cals_start2
|
Start Time
|
Start
|
>,>>9.9<<
|
10
|
|
|
cals_start3
|
Start Time
|
Start
|
>,>>9.9<<
|
10
|
|
|
cals_start4
|
Start Time
|
Start
|
>,>>9.9<<
|
10
|
|
|
cals_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
cals_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_calm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_cals_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cals_oid_calm_mstr
|
yes
|
oid_calm_mstr
|
yes
|
no
|
|
|
|
|
cals_day
|
yes
|
no
|
|
|
oid_cals_det
|
yes
|
oid_cals_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cal__qadc01
|
|
|
x(8)
|
|
|
|
cal_domain
|
Domain
|
|
x(8)
|
|
|
|
cal_end
|
End
|
End
|
99/99/99
|
|
|
|
cal_hours
|
Daily Hours
|
Hours
|
->>,>>9.99
|
10
|
|
|
cal_mch
|
Machine
|
|
x(8)
|
|
|
|
cal_ref
|
Reference
|
Ref
|
x(18)
|
|
|
|
cal_shift1
|
Shift1
|
|
->>,>>9.99
|
10
|
|
|
cal_shift2
|
Shift2
|
|
->>,>>9.99
|
10
|
|
|
cal_shift3
|
Shift3
|
|
->>,>>9.99
|
10
|
|
|
cal_shift4
|
Shift4
|
|
->>,>>9.99
|
10
|
|
|
cal_site
|
Site
|
|
x(8)
|
|
|
|
cal_start
|
Start
|
Start
|
99/99/99
|
|
|
|
cal_user1
|
Ufld1
|
|
x(8)
|
|
|
|
cal_user2
|
Ufld2
|
|
x(8)
|
|
|
|
cal_wkctr
|
Work Center
|
Work Ctr
|
x(8)
|
|
|
|
oid_cal_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
cal_det
|
yes
|
cal_domain
|
yes
|
no
|
|
|
|
|
cal_site
|
yes
|
no
|
|
|
|
|
cal_wkctr
|
yes
|
no
|
|
|
|
|
cal_mch
|
yes
|
no
|
|
|
|
|
cal_ref
|
yes
|
no
|
|
|
|
|
cal_start
|
yes
|
no
|
|
|
cal_start
|
yes
|
cal_domain
|
yes
|
no
|
|
|
|
|
cal_site
|
yes
|
no
|
|
|
|
|
cal_wkctr
|
yes
|
no
|
|
|
|
|
cal_mch
|
yes
|
no
|
|
|
|
|
cal_start
|
yes
|
no
|
|
|
|
|
cal_ref
|
yes
|
no
|
|
|
oid_cal_det
|
yes
|
oid_cal_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
caq__chr01
|
|
|
x(8)
|
|
|
|
caq__chr02
|
|
|
x(8)
|
|
|
|
caq__chr03
|
|
|
x(8)
|
|
|
|
caq__dec01
|
|
|
->>,>>9.99
|
10
|
|
|
caq__dec02
|
|
|
->>,>>9.99
|
10
|
|
|
caq__dte01
|
|
|
99/99/99
|
|
|
|
caq__dte02
|
|
|
99/99/99
|
|
|
|
caq__log01
|
|
|
yes/no
|
|
|
|
caq__log02
|
|
|
yes/no
|
|
|
|
caq_3rd_party
|
Third Party
|
|
yes/no
|
|
|
|
caq_area
|
Area
|
|
x(8)
|
|
|
|
caq_area_pri
|
Schedule by Area
|
|
yes/no
|
|
|
|
caq_area_sc
|
Schedule by Area
|
|
yes/no
|
|
|
|
caq_create_bom
|
Create BOM
|
|
yes/no
|
|
|
|
caq_create_rte
|
Create Routing
|
|
yes/no
|
|
|
|
caq_create_wo
|
Create WO
|
|
yes/no
|
|
|
|
caq_default_rte
|
Default Routing
|
|
x(8)
|
|
|
|
caq_depot
|
Repair Center
|
|
Depot/Field
|
|
|
|
caq_desc
|
Description
|
|
x(24)
|
|
|
|
caq_domain
|
Domain
|
|
x(8)
|
|
|
|
caq_field
|
Field Visits
|
|
yes/no
|
|
|
|
caq_file_type
|
Type
|
|
x(8)
|
|
|
|
caq_node
|
Site
|
|
x(16)
|
|
|
|
caq_prob_pri
|
Schedule by Problem
|
|
yes/no
|
|
|
|
caq_que
|
Queue
|
|
x(8)
|
|
|
|
caq_user1
|
Ufld1
|
|
x(8)
|
|
|
|
caq_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_caq_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
caq_que
|
yes
|
caq_domain
|
yes
|
no
|
|
|
|
|
caq_que
|
yes
|
no
|
|
|
|
|
caq_file_type
|
yes
|
no
|
|
|
oid_caq_mstr
|
yes
|
oid_caq_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CashGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CashGroupCode
|
Cash Group
|
|
x(20)
|
|
|
|
CashGroupDescription
|
Description
|
|
x(40)
|
|
|
|
CashGroupIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
CashGroupIsActive
|
yes
|
no
|
|
|
Code
|
yes
|
CashGroupCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CashGroup_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
CashGroupIsActive
|
yes
|
no
|
|
|
|
|
CashGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CashReport_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CashReportActualsDate
|
Actuals to
|
|
99/99/9999
|
|
|
|
CashReportCode
|
Code
|
|
x(20)
|
|
|
|
CashReportCurrencyView
|
Currency View
|
|
x(40)
|
|
|
|
CashReportDaysInterval
|
Days Interval
|
|
>>>9
|
|
|
|
CashReportDescription
|
Description
|
|
x(40)
|
|
|
|
CashReportLastSavedDate
|
Last Saved Date
|
|
99/99/9999
|
|
|
|
CashReportNumberOfPeriods
|
Number of GL Periods
|
|
>9
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
Division_ID
|
Sub-Account Code
|
Sub-Acct
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TillPeriod_ID
|
GL Period
|
GL Pd
|
-99999999999
|
|
|
|
Usr_ID
|
Login
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
no
|
CashReportCode
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CashReport_ID
|
yes
|
no
|
|
|
TillPeriod
|
no
|
TillPeriod_ID
|
yes
|
no
|
|
|
UniqueKey
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
CashReportCode
|
yes
|
no
|
|
|
Usr
|
no
|
Usr_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CashReport_ID
|
Link to CashReport
|
|
-99999999999
|
|
|
|
CashReportGL_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CashReportGLActualAmountCC
|
SC Actuals Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLActualAmountLC
|
BC Actuals Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLActualAmountTC
|
TC Actuals Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLAmountCC
|
SC Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLAmountLC
|
BC Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLAmountTC
|
TC Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLAmountType
|
Amount Type
|
|
x(20)
|
|
|
|
CashReportGLCorrAmountCC
|
SC Correction Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLCorrAmountLC
|
BC Correction Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLCorrAmountTC
|
TC Correction Amount GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLCurrencyView
|
GL Currency View
|
|
x(40)
|
|
|
|
CashReportGLDescription
|
Description
|
|
x(40)
|
|
|
|
CashReportGLIsAccount
|
GL Account
|
|
yes/no
|
|
|
|
CashReportGLIsCumul
|
Cumul
|
|
yes/no
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-99999999999
|
|
|
|
GL_ID
|
Cash Group
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CashReport
|
no
|
CashReport_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
NonUniquKey
|
no
|
CashReport_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CashReportGL_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CashReport_ID
|
Link to CashReport
|
|
-99999999999
|
|
|
|
CashReportGL_ID
|
Link to CashReportGL
|
|
-99999999999
|
|
|
|
CashReportGLLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CashReportGLLineCC
|
Line SC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLLineCurrView
|
Line Curr View
|
|
x(40)
|
|
|
|
CashReportGLLineDate
|
GL Line Date
|
|
99/99/9999
|
|
|
|
CashReportGLLineLC
|
BC Line GL
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CashReportGLLinePerc
|
GL Line %
|
|
->>9.99
|
2
|
|
|
CashReportGLLineSeq
|
GL Line Seq
|
|
>>>9
|
|
|
|
CashReportGLLineTC
|
Line SC
|
TC Line GL
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
Currency_ID
|
Link to Currency
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CashRep
|
no
|
CashReport_ID
|
yes
|
no
|
|
|
CashReportGL
|
no
|
CashReportGL_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
LineDate
|
no
|
CashReportGLLineDate
|
yes
|
no
|
|
|
LineSeq
|
no
|
CashReportGLLineSeq
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CashReportGLLine_ID
|
yes
|
no
|
|
|
UniqueKey
|
yes
|
CashReportGL_ID
|
yes
|
no
|
|
|
|
|
CashReportGLLineSeq
|
yes
|
no
|