QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
BudgetWBSRoster
Budget Topic Forecast
 
 
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
BulkPickC
Warehousing Bulk Pick Control
 
 
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
BulkPickD
Warehousing Bulk Pick Detail
 
 
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
BulkPickDH
Warehousing Bulk Pick Detail History
 
 
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
BulkPickM
Warehousing Bulk Pick Master
 
 
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
BusArea
Business Area
 
 
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
BusAreaComponent
Business Area - Business Component Link
 
 
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
BusinessRelation
Business Relation
 
 
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
BusRelationSafDefault
Business Relation Saf Default
 
 
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
cac_ctrl
Service/Support Call Master Control
 
 
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
cah_hist
Service/Support Call History
 
 
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
cald_det
Calendar Detail
 
 
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
CalendarD
Warehousing Calendar Detail
 
 
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
CalendarM
Warehousing Calendar Master
 
 
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
calh_det
Calendar Holiday Detail
 
 
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
calm_mstr
Calendar Master
 
 
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
cals_det
Shift Detail
 
 
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
cal_det
Calendar Detail
 
 
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
caq_mstr
Service/Support Call Queue Master
 
 
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
CashGroup
Cash Group
 
 
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
CashReport
Cash Report
 
 
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
CashReportGL
Cash Report Account
 
 
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
CashReportGLLine
Cash Report Account Line
 
 
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