|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|