QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
LocM
Warehousing Location Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CheckDigit
Check Digit
Check!Digit
x(8)
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Dedicated
Dedicated
Ded
yes/no
 
 
DimUM
Dimensional UM
UM
x(2)
 
 
Domain
Domain
 
x(8)
 
 
FullPct
% Full
 
->>9.99
10
 
Height
Height
 
>>>,>>9.99
2
 
LastOPC
Last OPC
 
99/99/99
 
 
Length
Length
 
>>>,>>9.99
2
 
Loc
Location
 
x(8)
 
 
LocType
Warehouse Location Type
Warehouse!Location!Type
X(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_LocM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OPCFreq
OPC Frequency
OPC Freq
>>>9
 
 
PickType
Picking Type
 
X(8)
 
 
PopCode
Popularity
 
X(8)
 
 
PrefUM
Preferred UM
Pref
x(2)
 
 
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
 
 
Site
Site
 
x(8)
 
 
SLocGp
Store Loc Group
SLocGrp
x(8)
 
 
StageIn
Stage (In)
 
X(8)
 
 
StageOut
Stage (Out)
 
X(8)
 
 
StoreType
Storage Type
Storage!Type
X(8)
 
 
TravelSeq
Travel Sequence
Travel!Sequence
->,>>>,>>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
 
 
Whse
Warehouse
Whse
x(8)
 
 
Width
Width
 
>>>,>>9.99
2
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_LocM
yes
oid_LocM
yes
no
SiteLoc
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Loc
yes
no
 
SiteWhseLoc
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Loc
yes
no
 
SLGLoc
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLocGp
yes
no
 
 
 
Loc
yes
no
 
SLGPopCode
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLocGp
yes
no
 
 
 
PopCode
yes
no
 
 
 
FullPct
yes
no
 
StoreType
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
StoreType
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
locpd_det
FiFo/LiFo history of unconsumed quantity onhand per period.
 
 
Field Name
Label
Col-Label
Format
Dec
 
locpd__qadc02
 
 
x(24)
 
 
locpd__qadc03
 
 
x(24)
 
 
locpd_acct
Account
Acct
x(8)
 
 
locpd_cc
Cost Center
CC
x(4)
 
 
locpd_mod_date
Modified Date
Mod Date
99/99/99
 
 
locpd_mod_userid
User ID
 
x(8)
 
 
locpd_sub
Sub-Account
Sub-Acct
x(8)
 
 
locpd_uncons_cn_it_qty_oh
Consignment In Transit Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
locpd_uncons_cn_qty_oh
Consignment Qty Unconsumed
 
->,>>>,>>9.9<<<<<<<<
10
 
locpd_uncons_qty_oh
Qty Unconsumed
 
->,>>>,>>9.9<<<<<<<<
10
 
locpd_user1
User Field Character 1
 
x(24)
 
 
locpd_user2
User Field Character 2
 
x(24)
 
 
oid_glccp_det
Identifier Cost Calculation Period
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_locd_det
Identifier Period Ending Inventory Balance
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_locpd_det
Identifier Location Period Detail
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
locpd_glccp_locd
no
oid_glccp_det
yes
no
 
 
 
oid_locd_det
yes
no
 
locpd_loc_glccp
yes
oid_locd_det
yes
no
 
 
 
oid_glccp_det
yes
no
oid_locpd_det
yes
oid_locpd_det
yes
no
LocUMM
Warehousing Location Unit of Measure 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)
 
 
Height
Height
 
>>>,>>9.99
2
 
Length
Length
 
>>>,>>9.99
2
 
Loc
Location
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_LocUMM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
Quantity
Quantity
 
>>>>9.9999<<<<
10
 
Site
Site
 
x(8)
 
 
UM
UM
 
x(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
 
 
Whse
Warehouse
Whse
x(8)
 
 
Width
Width
 
>>>,>>9.99
2
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
LUMMIdx
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Loc
yes
no
 
 
 
Part
yes
no
 
 
 
UM
yes
no
 
LUMMPart
yes
Domain
yes
no
 
 
 
Part
yes
no
 
 
 
UM
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Loc
yes
no
 
oid_LocUMM
yes
oid_LocUMM
yes
no
 
PartWhse
no
Domain
yes
no
 
 
 
Part
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
LocW
Warehousing Location Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
AlgoNbr
Algorithm
Algo
>>9
 
 
AlgoType
Type
 
X(8)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateProgName
Created
 
x(10)
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
InternalID
Internal User ID
Internal!User ID
x(50)
 
 
Loc
Location
 
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_LocW
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
Part
Item Number
 
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
 
 
Quantity
Quantity
 
->>>,>>9.9<<<<<<
10
 
Site
Site
 
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)
 
 
WkSeq
Seq
 
>>9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Location
no
Domain
yes
no
 
 
 
AlgoType
yes
no
 
 
 
Site
yes
no
 
 
 
Loc
yes
no
LWIdx
yes
Domain
yes
no
 
 
 
InternalID
yes
no
 
 
 
AlgoType
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Loc
yes
no
 
oid_LocW
yes
oid_LocW
yes
no
 
SiteSeq
no
Domain
yes
no
 
 
 
InternalID
yes
no
 
 
 
AlgoType
yes
no
 
 
 
Site
yes
no
 
 
 
WkSeq
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
loc_mstr
Location Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
loc__qad01
 
 
yes/no
 
 
loc__qadc01
 
 
x(8)
 
 
loc__qadc02
 
 
x(4)
 
 
loc_cap
Capacity
 
>>>>,>>>,>>9.9<<<<<<<<
10
 
loc_cap_um
Capacity UM
 
x(2)
 
 
loc_date
Date Created
Created
99/99/99
 
 
loc_desc
Description
 
x(24)
 
 
loc_domain
Domain
 
x(8)
 
 
loc_loc
Location
 
x(8)
 
 
loc_perm
Permanent
Perm
yes/no
 
 
loc_phys_addr
Physical Address
Physical
x(8)
 
 
loc_project
Project
 
x(8)
 
 
loc_single
Single Item
Single!Item
yes/no
 
 
loc_site
Site
 
x(8)
 
 
loc_status
Inventory Status
Status
x(8)
 
 
loc_type
Type
 
x(8)
 
 
loc_user1
Ufld1
 
x(8)
 
 
loc_user2
Ufld2
 
x(8)
 
 
loc_xfer_ownership
Transfer Ownership
Transfer!Ownership
yes/no
 
 
oid_loc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
loc_loc
yes
loc_domain
yes
no
 
 
 
loc_site
yes
no
 
 
 
loc_loc
yes
no
 
oid_loc_mstr
yes
oid_loc_mstr
yes
no
lotw_wkfl
Lot Number Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
lotw__qadc01
 
 
x(8)
 
 
lotw_domain
Domain
 
x(8)
 
 
lotw_lotser
Lot/Serial
 
x(18)
 
 
lotw_mfguser
 
 
x(50)
 
 
lotw_part
Item Number
 
x(18)
 
 
lotw_user1
Ufld1
 
x(8)
 
 
lotw_user2
Ufld2
 
x(8)
 
 
lotw_userid
User ID
 
x(50)
 
 
oid_lotw_wkfl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
lot_user_lot
yes
lotw_domain
yes
no
 
 
 
lotw_mfguser
yes
no
 
 
 
lotw_lotser
yes
no
 
 
 
lotw_part
yes
no
lotw_ser_part
yes
lotw_domain
yes
no
 
 
 
lotw_lotser
yes
no
 
 
 
lotw_part
yes
no
 
oid_lotw_wkfl
yes
oid_lotw_wkfl
yes
no
lot_mstr
Lot Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
lot__chr01
Chrfld 1
 
x(8)
 
 
lot__chr02
Chrfld 2
 
x(8)
 
 
lot__chr03
Chrfld 3
 
x(8)
 
 
lot__chr04
Chrfld 4
 
x(8)
 
 
lot__chr05
Chrfld 5
 
x(8)
 
 
lot__chr06
Chrfld 6
 
x(8)
 
 
lot__dec01
Decfld 1
 
->>>,>>>,>>9.99
10
 
lot__dec02
Decfld 2
 
->>>,>>>,>>9.99
10
 
lot__dec03
Decfld 3
 
->>>,>>>,>>9.99
10
 
lot__dec04
Decfld 4
 
->>>,>>>,>>9.99
10
 
lot__dec05
Decfld 5
 
->>>,>>>,>>9.99
10
 
lot__dec06
Decfld 6
 
->>>,>>>,>>9.99
10
 
lot__dte01
Dtefld 1
 
99/99/99
 
 
lot__dte02
Dtefld 2
 
99/99/99
 
 
lot__dte03
Dtefld 3
 
99/99/99
 
 
lot__dte04
Dtefld 4
 
99/99/99
 
 
lot__dte05
Dtefld 5
 
99/99/99
 
 
lot__dte06
Dtefld 6
 
99/99/99
 
 
lot_cmtindx
Comment Index
 
>>>>>>>9
 
 
lot_create
Created
 
99/99/99
 
 
lot_domain
Domain
 
x(8)
 
 
lot_line
Line/ID
 
x(8)
 
 
lot_nbr
Order Number
 
x(18)
 
 
lot_part
Item Number
 
x(18)
 
 
lot_pot_conv
Lot UM Conversion
Lot UM Conv
>>>>9.9999<<<<
10
 
lot_pot_um
Lot UM
UM
x(2)
 
 
lot_serial
Lot/Serial
 
x(18)
 
 
lot_trans
Expired Inv Trans
Trans
x(8)
 
 
lot_user1
Ufld1
 
x(8)
 
 
lot_user2
Ufld2
 
x(8)
 
 
lot_userid
User ID
 
x(8)
 
 
oid_lot_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lot_part_serial
yes
lot_domain
yes
no
 
 
 
lot_part
yes
no
 
 
 
lot_serial
yes
no
 
lot_serial_part
no
lot_domain
yes
no
 
 
 
lot_serial
yes
no
 
 
 
lot_part
yes
no
 
oid_lot_mstr
yes
oid_lot_mstr
yes
no
ls_mstr
Address List Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ls__dec01
 
 
->>>,>>>,>>9.99<
10
 
ls__dec02
 
 
->>>,>>>,>>9.99<
10
 
ls__dte01
 
 
99/99/9999
 
 
ls__dte02
 
 
99/99/9999
 
 
ls__int01
 
 
->>>,>>>,>>9
 
 
ls__int02
 
 
->>>,>>>,>>9
 
 
ls__log01
 
 
yes/no
 
 
ls__log02
 
 
yes/no
 
 
ls__qadc01
 
 
x(8)
 
 
ls__qadc02
 
 
x(8)
 
 
ls__qadc03
 
 
x(8)
 
 
ls__qadc04
 
 
x(8)
 
 
ls__qadd01
 
 
->>>,>>>,>>9.99<
10
 
ls__qadd02
 
 
->>>,>>>,>>9.99<
10
 
ls__qadi01
 
 
->>>,>>>,>>9
 
 
ls__qadi02
 
 
->>>,>>>,>>9
 
 
ls__qadl01
 
 
yes/no
 
 
ls__qadl02
 
 
yes/no
 
 
ls__qadt01
 
 
99/99/9999
 
 
ls__qadt02
 
 
99/99/9999
 
 
ls_addr
Address
 
x(8)
 
 
ls_app_owner
Owner Application
 
x(12)
 
 
ls_domain
Domain
 
x(8)
 
 
ls_type
List Type
List
x(8)
 
 
ls_user1
Ufld1
 
x(8)
 
 
ls_user2
Ufld2
 
x(8)
 
 
oid_ls_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ls_addrtype
yes
ls_domain
yes
no
 
 
 
ls_addr
yes
no
 
 
 
ls_type
yes
no
 
ls_type
yes
ls_domain
yes
no
 
 
 
ls_type
yes
no
 
 
 
ls_addr
yes
no
 
oid_ls_mstr
yes
oid_ls_mstr
yes
no
ltrenvd_det
Logistics Trade Environment Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ltrenvd__qadc01
 
 
x(24)
 
 
ltrenvd__qadc02
 
 
x(24)
 
 
ltrenvd__qadd01
 
 
->>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ltrenvd_desc
Description
 
x(32)
 
 
ltrenvd_domain
Domain
 
x(8)
 
 
ltrenvd_mod_date
Modified Date
Mod Date
99/99/99
 
 
ltrenvd_mod_userid
User ID
 
x(8)
 
 
ltrenvd_shipfrom_zone
Shipfrom Zone
Shipfrom Zn
x(16)
 
 
ltrenvd_shipto_zone
Shipto Zone
Shipto Zn
x(16)
 
 
ltrenvd_trade_env
Logistic Trade Environment
LT Env
x(18)
 
 
ltrenvd_user1
User Field Character 1
 
x(24)
 
 
ltrenvd_user2
User Field Character 2
 
x(24)
 
 
oid_ltrenvd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ltrenvd_env_from
yes
ltrenvd_domain
yes
no
 
 
 
ltrenvd_trade_env
yes
no
 
 
 
ltrenvd_shipfrom_zone
yes
no
 
 
 
ltrenvd_shipto_zone
yes
no
 
ltrenvd_env_to
yes
ltrenvd_domain
yes
no
 
 
 
ltrenvd_trade_env
yes
no
 
 
 
ltrenvd_shipto_zone
yes
no
 
 
 
ltrenvd_shipfrom_zone
yes
no
 
ltrenvd_shipfrom
no
ltrenvd_domain
yes
no
 
 
 
ltrenvd_shipfrom_zone
yes
no
 
 
 
ltrenvd_shipto_zone
yes
no
 
ltrenvd_shipto
no
ltrenvd_domain
yes
no
 
 
 
ltrenvd_shipto_zone
yes
no
 
 
 
ltrenvd_shipfrom_zone
yes
no
 
oid_ltrenvd_det
yes
oid_ltrenvd_det
yes
no
ltrenv_mstr
Logistics Trade Environment
 
 
Field Name
Label
Col-Label
Format
Dec
 
ltrenv__qadc01
 
 
x(24)
 
 
ltrenv__qadc02
 
 
x(24)
 
 
ltrenv__qadd01
 
 
->>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ltrenv_desc
Description
 
x(32)
 
 
ltrenv_domain
Domain
 
x(8)
 
 
ltrenv_mod_date
Modified Date
Mod Date
99/99/99
 
 
ltrenv_mod_userid
User ID
 
x(8)
 
 
ltrenv_trade_env
Logistic Trade Environment
LT Env
x(18)
 
 
ltrenv_user1
User Field Character 1
 
x(24)
 
 
ltrenv_user2
User Field Character 2
 
x(24)
 
 
oid_ltrenv_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ltrenv_env
yes
ltrenv_domain
yes
no
 
 
 
ltrenv_trade_env
yes
no
 
oid_ltrenv_mstr
yes
oid_ltrenv_mstr
yes
no
ltrznd_det
Logistics Trade Zones Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ltrznd__qadc01
 
 
x(24)
 
 
ltrznd__qadc02
 
 
x(24)
 
 
ltrznd__qadd01
 
 
->>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ltrznd_city
City
 
x(20)
 
 
ltrznd_county
County
 
x(20)
 
 
ltrznd_ctry_code
Country Code
Ctry
x(3)
 
 
ltrznd_desc
Description
 
x(32)
 
 
ltrznd_domain
Domain
 
x(8)
 
 
ltrznd_mod_date
Modified Date
Mod Date
99/99/99
 
 
ltrznd_mod_userid
User ID
 
x(8)
 
 
ltrznd_state
State
St
x(4)
 
 
ltrznd_user1
User Field Character 1
 
x(24)
 
 
ltrznd_user2
User Field Character 2
 
x(24)
 
 
ltrznd_zip
Zip
 
x(10)
 
 
ltrznd_zone
Logistic Trade Zone
LT Zone
x(16)
 
 
oid_ltrznd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ltrznd_ctry_code
no
ltrznd_domain
yes
no
 
 
 
ltrznd_ctry_code
yes
no
 
 
 
ltrznd_state
yes
no
 
 
 
ltrznd_county
yes
no
 
 
 
ltrznd_city
yes
no
 
 
 
ltrznd_zip
yes
no
ltrznd_zone
yes
ltrznd_domain
yes
no
 
 
 
ltrznd_zone
yes
no
 
 
 
ltrznd_ctry_code
yes
no
 
 
 
ltrznd_state
yes
no
 
 
 
ltrznd_county
yes
no
 
 
 
ltrznd_city
yes
no
 
 
 
ltrznd_zip
yes
no
 
oid_ltrznd_det
yes
oid_ltrznd_det
yes
no
ltrzn_mstr
Logistics Trade Zones
 
 
Field Name
Label
Col-Label
Format
Dec
 
ltrzn__qadc01
 
 
x(24)
 
 
ltrzn__qadc02
 
 
x(24)
 
 
ltrzn__qadd01
 
 
->>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ltrzn_desc
Description
 
x(32)
 
 
ltrzn_domain
Domain
Domain
x(8)
 
 
ltrzn_mod_date
Modified Date
Mod Date
99/99/99
 
 
ltrzn_mod_userid
User ID
 
x(8)
 
 
ltrzn_user1
User Field Character 1
 
x(24)
 
 
ltrzn_user2
User Field Character 2
 
x(24)
 
 
ltrzn_zone
Logistic Trade Zone
LT Zone
x(16)
 
 
oid_ltrzn_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ltrzn_zone
yes
ltrzn_domain
yes
no
 
 
 
ltrzn_zone
yes
no
 
oid_ltrzn_mstr
yes
oid_ltrzn_mstr
yes
no
maxt_det
Maximum Table Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
maxt__qad01
 
 
yes/no
 
 
maxt__qad02
 
 
x(8)
 
 
maxt__qad03
 
 
x(8)
 
 
maxt_amt
Amount
 
->>,>>>,>>>,>>9.99<
10
 
maxt_beg_date
Beginning Date
Beg Date
99/99/99
 
 
maxt_book
Book
 
x(8)
 
 
maxt_class
Class
Cls
x(3)
 
 
maxt_end_date
Ending Date
End Date
99/99/99
 
 
maxt_entity
Entity
Enty
x(20)
 
 
maxt_field
Field to Apply Maximum To
 
x(32)
 
 
maxt_user1
Ufld1
 
x(8)
 
 
maxt_user2
Ufld2
 
x(8)
 
 
oid_maxt_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
maxt_index
yes
maxt_field
yes
no
 
 
 
maxt_book
yes
no
 
 
 
maxt_entity
yes
no
 
 
 
maxt_class
yes
no
 
 
 
maxt_beg_date
yes
no
 
 
 
maxt_end_date
yes
no
 
oid_maxt_det
yes
oid_maxt_det
yes
no
max_mstr
Maximums Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
max__qad01
 
 
x(4)
 
 
max__qad02
 
 
x(8)
 
 
max_basis
Maximum Basis
 
x(24)
 
 
max_basis_yr
Years
Yrs
99
 
 
max_beg_date
Beginning Date
Beg Date
99/99/99
 
 
max_book
Book
 
x(8)
 
 
max_class
Class
Cls
x(3)
 
 
max_cost
Total Asset Cost
 
->>,>>>,>>>,>>9.99<
10
 
max_desc
Description
 
x(24)
 
 
max_end_date
Ending Date
End Date
99/99/99
 
 
max_field
Field
 
x(32)
 
 
max_max
Maximum
 
->>,>>>,>>>,>>9.99<
10
 
max_mod_date
Modified Date
Mod Date
99/99/99
 
 
max_reduce
Amount to Reduce Maximum by
Reduce Maximum by
->>,>>>,>>>,>>9.99<
10
 
max_table
Type
 
Table/Fixed Amount
 
 
max_used
Amount of Maximum Used
Maximum Amount Used
->>,>>>,>>>,>>9.99<
10
 
max_user1
Ufld1
 
x(8)
 
 
max_user2
Ufld2
 
x(8)
 
 
max_userid
User ID
 
x(8)
 
 
max_yr_cost
Total Asset Cost
 
->>,>>>,>>>,>>9.99<
10
 
max_yr_max
Maximum
 
->>,>>>,>>>,>>9.99<
10
 
oid_max_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
max_ind1
yes
max_field
yes
no
 
 
 
max_book
yes
no
 
 
 
max__qad01
yes
no
 
 
 
max_class
yes
no
 
oid_max_mstr
yes
oid_max_mstr
yes
no
ma_mstr
Mirror Account Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ma__qadc01
 
 
x(8)
 
 
ma_acct1
Account 1
 
x(8)
 
 
ma_acct2
Account 2
 
x(8)
 
 
ma_all_cc
All Cost Centers
All CC
yes/no
 
 
ma_all_sub
All Sub-Accounts
All Sub-Acct
yes/no
 
 
ma_cc1
Cost Ctr
CC
x(4)
 
 
ma_cc2
Cost Ctr 2
CC 2
x(4)
 
 
ma_domain
Domain
 
x(8)
 
 
ma_entity
Entity
 
x(20)
 
 
ma_mr_acct1
Mirror Account 1
Mir Acct1
x(8)
 
 
ma_mr_acct2
Mirror Account 2
Mir Acct 2
x(8)
 
 
ma_mr_cc1
Cost Ctr
CC
x(4)
 
 
ma_mr_cc2
Mirror CC 2
Mir CC 2
x(4)
 
 
ma_mr_sub1
Mirror Sub-Account 1
Sub-Acct
x(8)
 
 
ma_mr_sub2
Mirror Sub-Account 2
Sub-Acct
x(8)
 
 
ma_sub1
Sub-Account 1
Sub-Acct
x(8)
 
 
ma_sub2
Sub-Account 2
Sub-Acct
x(8)
 
 
ma_tr_type
Trans Type
T
x(2)
 
 
ma_user1
Ufld1
 
x(8)
 
 
ma_user2
Ufld2
 
x(8)
 
 
oid_ma_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ma_all_sub_cc
yes
ma_domain
yes
no
 
 
 
ma_entity
yes
no
 
 
 
ma_tr_type
yes
no
 
 
 
ma_acct1
yes
no
 
 
 
ma_acct2
yes
no
 
 
 
ma_sub1
yes
no
 
 
 
ma_sub2
yes
no
 
 
 
ma_cc1
yes
no
 
 
 
ma_cc2
yes
no
 
 
 
ma_all_sub
yes
no
 
 
 
ma_all_cc
yes
no
 
oid_ma_mstr
yes
oid_ma_mstr
yes
no
MessageD
Warehousing Messaging Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserId
Create User Id
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modify Date
 
99/99/99
 
 
ModUserId
Modify User Id
 
x(8)
 
 
MsgNbr
Number
 
>>>>>>>9
 
 
oid_MessageD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
ReadDate
Read Date
 
99/99/99
 
 
ReadTime
Send Time
 
>>>>>>>9
 
 
ReadUserId
Read User
 
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
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_MessageD
yes
oid_MessageD
yes
no
 
ReadDate
no
Domain
yes
no
 
 
 
ReadUserId
yes
no
 
 
 
ReadDate
yes
no
 
 
 
ReadTime
yes
no
ReadUserId
yes
Domain
yes
no
 
 
 
MsgNbr
yes
no
 
 
 
ReadUserId
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
MessageM
Warehousing Messaging Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserId
Create User Id
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modify Date
 
99/99/99
 
 
ModUserId
Modify User Id
 
x(8)
 
 
MsgNbr
Number
 
>>>>>>>9
 
 
MsgSubject
Subject
 
x(40)
 
 
MsgText[15]
Message Text
 
x(76)
 
 
MsgTo
To
 
x(8)
 
 
oid_MessageM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
SendDate
Send Date
 
99/99/99
 
 
SendTime
Send Time
 
>>>>>>>9
 
 
SendUserId
Send User
 
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
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
MsgNbr
yes
Domain
yes
no
 
 
 
MsgNbr
yes
no
 
oid_MessageM
yes
oid_MessageM
yes
no
 
SendDate
no
Domain
yes
no
 
 
 
SendDate
yes
no
 
 
 
SendTime
yes
no
 
SendUserId
no
Domain
yes
no
 
 
 
SendUserId
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
mfc_ctrl
Control Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfc__qadc01
 
 
x(8)
 
 
mfc_char
Character
 
x(24)
 
 
mfc_date
Date
 
99/99/99
 
 
mfc_decimal
Decimal
 
->>>,>>>,>>9.999999999
10
 
mfc_desc
Description
 
x(24)
 
 
mfc_domain
Domain
 
x(8)
 
 
mfc_field
Field Name
 
x(32)
 
 
mfc_integer
Integer
 
>>>>>>>>9
 
 
mfc_label
Label
 
x(24)
 
 
mfc_logical
Logical
 
yes/no
 
 
mfc_module
Module
 
x(4)
 
 
mfc_seq
Sequence
Seq
>>9
 
 
mfc_type
Type
T
x(2)
 
 
mfc_user1
Ufld1
 
x(8)
 
 
mfc_user2
Ufld2
 
x(8)
 
 
oid_mfc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mfc_field
yes
mfc_domain
yes
no
 
 
 
mfc_field
yes
no
 
mfc_mod_seq
yes
mfc_domain
yes
no
 
 
 
mfc_module
yes
no
 
 
 
mfc_seq
yes
no
 
oid_mfc_ctrl
yes
oid_mfc_ctrl
yes
no
mfrel_mstr
Master Table Relationships
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfrel__qadc01
 
 
x(24)
 
 
mfrel__qadc02
 
 
x(24)
 
 
mfrel__qadc03
 
 
x(24)
 
 
mfrel__qadc04
 
 
x(24)
 
 
mfrel__qadc05
 
 
x(24)
 
 
mfrel__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfrel__qadd02
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfrel__qadd03
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfrel__qadd04
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfrel__qadd05
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfrel__qaddt01
 
 
99/99/99
 
 
mfrel__qaddt02
 
 
99/99/99
 
 
mfrel__qadl01
 
 
yes/no
 
 
mfrel__qadl02
 
 
yes/no
 
 
mfrel_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfrel_mod_userid
User ID
 
x(8)
 
 
mfrel_source_key1
Source Key Field 1
 
x(24)
 
 
mfrel_source_key2
Source Key Field 2
 
x(24)
 
 
mfrel_source_key3
Source Key Field 3
 
x(24)
 
 
mfrel_target_key1
Target Key Field 1
 
x(24)
 
 
mfrel_target_key2
Target Key Field 2
 
x(24)
 
 
mfrel_target_key3
Target Key Field 3
 
x(24)
 
 
mfrel_type
Type
 
x(8)
 
 
mfrel_user1
User Field Character 1
 
x(24)
 
 
mfrel_user2
User Field Character 2
 
x(24)
 
 
oid_mfrel_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mfrel_source_targ
yes
mfrel_type
yes
no
 
 
 
mfrel_source_key1
yes
no
 
 
 
mfrel_source_key2
yes
no
 
 
 
mfrel_source_key3
yes
no
 
 
 
mfrel_target_key1
yes
no
 
 
 
mfrel_target_key2
yes
no
 
 
 
mfrel_target_key3
yes
no
 
mfrel_targ_source
yes
mfrel_type
yes
no
 
 
 
mfrel_target_key1
yes
no
 
 
 
mfrel_target_key2
yes
no
 
 
 
mfrel_target_key3
yes
no
 
 
 
mfrel_source_key1
yes
no
 
 
 
mfrel_source_key2
yes
no
 
 
 
mfrel_source_key3
yes
no
 
oid_mfrel_mstr
yes
oid_mfrel_mstr
yes
no
mfscl_mstr
used for logging the changes made for MFS related tables.
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfscl__qadc01
 
 
x(24)
 
 
mfscl__qadc02
 
 
x(24)
 
 
mfscl_domain
Domain
 
x(8)
 
 
mfscl_keyfieldname1
Key Field Name 1
 
x(30)
 
 
mfscl_keyfieldname2
Key Field Name 2
 
x(30)
 
 
mfscl_keyfieldname3
Key Field Name 3
 
x(30)
 
 
mfscl_keyfieldname4
Key Field Name 4
 
x(30)
 
 
mfscl_keyfieldname5
Key Field Name 5
 
x(30)
 
 
mfscl_keyfieldname6
Key Field Name 6
 
x(30)
 
 
mfscl_keyfieldvalue1
Key Field Value 1
 
x(36)
 
 
mfscl_keyfieldvalue2
Key Field Value 2
 
x(36)
 
 
mfscl_keyfieldvalue3
Key Field Value 3
 
x(36)
 
 
mfscl_keyfieldvalue4
Key Field Value 4
 
x(36)
 
 
mfscl_keyfieldvalue5
Key Field Value 5
 
x(36)
 
 
mfscl_keyfieldvalue6
Key Field Value 6
 
x(36)
 
 
mfscl_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfscl_mod_userid
User ID
 
x(8)
 
 
mfscl_operation
Operation
 
x(1)
 
 
mfscl_tablename
Table Name
 
x(14)
 
 
mfscl_timestamp
Time Stamp
 
99/99/9999 HH:MM:SS.SSS
 
 
mfscl_user1
User Field Character 1
 
x(24)
 
 
mfscl_user2
User Field Character 2
 
x(24)
 
 
oid_mfscl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mfscl_tablename
yes
mfscl_domain
yes
no
 
 
 
mfscl_tablename
yes
no
 
 
 
mfscl_keyfieldvalue1
yes
no
 
 
 
mfscl_keyfieldvalue2
yes
no
 
 
 
mfscl_keyfieldvalue3
yes
no
 
 
 
mfscl_keyfieldvalue4
yes
no
 
 
 
mfscl_keyfieldvalue5
yes
no
 
 
 
mfscl_keyfieldvalue6
yes
no
 
mfscl_timestamp
no
mfscl_domain
yes
no
 
 
 
mfscl_timestamp
yes
no
 
oid_mfscl_mstr
yes
oid_mfscl_mstr
yes
no
mfsc_ctrl
QAD Mobile Field Service Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfsc__qadc01
 
 
x(24)
 
 
mfsc__qadc02
 
 
x(24)
 
 
mfsc__qadc03
 
 
x(24)
 
 
mfsc__qadc04
 
 
x(24)
 
 
mfsc__qadd01
 
 
->>>>,>>>,>>9.9
10
 
mfsc__qadd02
 
 
->>>>,>>>,>>9.9
10
 
mfsc__qadi01
 
 
>>>>>>>9
 
 
mfsc__qadi02
 
 
>>>>>>>9
 
 
mfsc__qadl01
 
 
yes/no
 
 
mfsc__qadl02
 
 
yes/no
 
 
mfsc__qadl03
 
 
yes/no
 
 
mfsc__qadl04
 
 
yes/no
 
 
mfsc__qadt01
 
 
99/99/99
 
 
mfsc__qadt02
 
 
99/99/99
 
 
mfsc_attach_url
Attachment Url
 
x(256)
 
 
mfsc_call_header
Prioritize Call Header On Client
 
yes/no
 
 
mfsc_car_process
CAR Processing of Field Reports
 
yes/no
 
 
mfsc_client_doc_ids
Generate Doc IDs On Client
 
yes/no
 
 
mfsc_domain
Domain
 
x(8)
 
 
mfsc_domain_specific
Domain Specific Templates
 
yes/no
 
 
mfsc_environment_name
Environment Name
 
x(40)
 
 
mfsc_erp_auth
ERP Authentication Enabled
 
yes/no
 
 
mfsc_fsr_required
FSR Required
 
yes/no
 
 
mfsc_max_cmt
Max Comment Page
 
>9
 
 
mfsc_max_cost
Max Expense Cost
 
>>>>,>>>,>>9.99<<<
 
 
mfsc_max_dur
Max Labor Duration
 
->>>9.9<<<
 
 
mfsc_min_cmt
Min Comment Page
 
>9
 
 
mfsc_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfsc_mod_userid
User ID
 
x(8)
 
 
mfsc_nonexisting_items
Non-existing Items Allowed
 
yes/no
 
 
mfsc_nonexisting_user
Non-existing End Users Allowed
 
yes/no
 
 
mfsc_prntsyscmnt
Comments On Invoice/Reports
 
yes/no
 
 
mfsc_qxi_recv
MFS Receiver
 
x(20)
 
 
mfsc_qxi_url
QXI Url
 
x(256)
 
 
mfsc_software_loc
Software Update Location
 
x(40)
 
 
mfsc_ssl_enabled
SSL Connection Enabled
 
yes/no
 
 
mfsc_sync_host
Sync Server
 
x(60)
 
 
mfsc_sync_port
Sync Port
 
>>>>9
 
 
mfsc_template_loc
FSR Template Location
 
x(40)
 
 
mfsc_user1
User Field Character 1
 
x(24)
 
 
mfsc_user2
User Field Character 2
 
x(24)
 
 
oid_mfsc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mfsc_domain
yes
mfsc_domain
yes
no
 
oid_mfsc_ctrl
yes
oid_mfsc_ctrl
yes
no
mfsd_det
QAD Mobile Field Service User Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfsd__qadc01
 
 
x(24)
 
 
mfsd__qadc02
 
 
x(24)
 
 
mfsd_active
Active
 
yes/no
 
 
mfsd_ca_mo_pre
Call/MO Unique Prefix
 
x(3)
 
 
mfsd_call_header
Prioritize Call Header On Client
 
yes/no
 
 
mfsd_car_process
CAR Processing of Field Reports
 
yes/no
 
 
mfsd_client_doc_ids
Generate Doc IDs On Client
 
yes/no
 
 
mfsd_default_domain
Default Domain
 
yes/no
 
 
mfsd_domain
Domain
 
x(8)
 
 
mfsd_eng_code
Engineer
 
x(8)
 
 
mfsd_eng_id
Engineer Unique ID
 
x(3)
 
 
mfsd_erp_auth
ERP Authentication Enabled
 
yes/no
 
 
mfsd_loc
Location
 
x(8)
 
 
mfsd_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfsd_mod_userid
User ID
 
x(8)
 
 
mfsd_nonexisting_items
Non-existing Items Allowed
 
yes/no
 
 
mfsd_nonexisting_user
Non-existing End Users Allowed
 
yes/no
 
 
mfsd_prntsyscmnt
Comments On Invoice/Reports
 
yes/no
 
 
mfsd_sa_pre
Contract Prefix
Ct
x(1)
 
 
mfsd_site
Site
 
x(8)
 
 
mfsd_svc_group1
Start Svc Group
 
x(8)
 
 
mfsd_svc_group2
End Svc Group
 
x(8)
 
 
mfsd_sync_auth
Single Sign-on for Sync Engine
 
yes/no
 
 
mfsd_user1
User Field Character 1
 
x(24)
 
 
mfsd_user2
User Field Character 2
 
x(24)
 
 
mfsd_userc03
User Field Character 3
 
x(24)
 
 
mfsd_userc04
User Field Character 4
 
x(24)
 
 
mfsd_userc05
User Field Character 5
 
x(24)
 
 
mfsd_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfsd_userd02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mfsd_userid
User ID
 
x(20)
 
 
mfsd_userl01
User Field Logical 1
 
yes/no
 
 
mfsd_userl02
User Field Logical 2
 
yes/no
 
 
mfsd_usert01
User Field Date 1
 
99/99/99
 
 
mfsd_usert02
User Field Date 2
 
99/99/99
 
 
oid_mfsd_det
OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
mfsd_ca_mo_pre
no
mfsd_ca_mo_pre
yes
no
 
mfsd_eng_id
no
mfsd_eng_id
yes
no
 
mfsd_userdomain
yes
mfsd_userid
yes
no
 
 
 
mfsd_domain
yes
no
mfsd_userid
yes
mfsd_domain
yes
no
 
 
 
mfsd_userid
yes
no
 
oid_mfsd_det
yes
oid_mfsd_det
yes
no