QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
WaveTranspC
Warehousing Wave Transportation Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
DefaultIncl
Default Include
Def Incl
yes/no
 
 
Domain
Domain
 
x(8)
 
 
ExportAlgo
Export Algorithm
Exp Algo
>>9
 
 
FromDays
Def From Due Date
From Days
>,>>9
 
 
FromSign
Def From Due Sign
From Sign
x(1)
 
 
FromType
From Order Type
From!Type
x(2)
 
 
LoadHeaderCmmts
Load Header Comments
 
yes/no
 
 
LoadLineCmmts
Load Line Comments
 
yes/no
 
 
MaxLines
Def Max Order Lines
Max Lines
->,>>>,>>9
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
NoLimit
Use Limit in Add Frame
Limit
yes/no
 
 
oid_WaveTranspC
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OnlyAlloc
Select Only Allocated Lines
Only Alloc
yes/no
 
 
QadC01
QAD Field
 
x(24)
0
 
QadC02
QAD Field
 
x(24)
0
 
QadC03
QAD Field
 
x(24)
0
 
QadC04
QAD Field
 
x(24)
0
 
QadC05
QAD Field
 
x(24)
0
 
QadC06
QAD Field
 
x(24)
0
 
QadC07
QAD Field
 
x(24)
0
 
QadC08
QAD Field
 
x(24)
0
 
QadC09
QAD Field
 
x(24)
0
 
QadC10
QAD Field
 
x(24)
0
 
QadC11
QAD Field
 
x(24)
0
 
QadC12
QAD Field
 
x(24)
0
 
QadC13
QAD Field
 
x(24)
0
 
QadC14
QAD Field
 
x(24)
0
 
QadC15
QAD Field
 
x(24)
0
 
QadC16
QAD Field
 
x(24)
0
 
QadC17
QAD Field
 
x(24)
0
 
QadC18
QAD Field
 
x(24)
0
 
QadC19
QAD Field
 
x(24)
0
 
QadC20
QAD Field
 
x(24)
0
 
QadC21
QAD Field
 
x(24)
0
 
QadC22
QAD Field
 
x(24)
0
 
QadC23
QAD Field
 
x(24)
0
 
QadC24
QAD Field
 
x(24)
0
 
QadC25
QAD Field
 
x(24)
0
 
QadC26
QAD Field
 
x(24)
0
 
QadC27
QAD Field
 
x(24)
0
 
QadC28
QAD Field
 
x(24)
0
 
QadC29
QAD Field
 
x(24)
0
 
QadC30
QAD Field
 
x(24)
0
 
QadC31
QAD Field
 
x(24)
0
 
QadC32
QAD Field
 
x(24)
0
 
QadC33
QAD Field
 
x(24)
0
 
QadC34
QAD Field
 
x(24)
0
 
QadC35
QAD Field
 
x(24)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD04
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD05
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD06
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD07
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD08
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD09
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD10
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadI04
QAD Field
 
->,>>>,>>9
 
 
QadI05
QAD Field
 
->,>>>,>>9
 
 
QadI06
QAD Field
 
->,>>>,>>9
 
 
QadI07
QAD Field
 
->,>>>,>>9
 
 
QadI08
QAD Field
 
->,>>>,>>9
 
 
QadI09
QAD Field
 
->,>>>,>>9
 
 
QadI10
QAD Field
 
->,>>>,>>9
 
 
QadI11
QAD Field
 
->,>>>,>>9
 
 
QadI12
QAD Field
 
->,>>>,>>9
 
 
QadI13
QAD Field
 
->,>>>,>>9
 
 
QadI14
QAD Field
 
->,>>>,>>9
 
 
QadI15
QAD Field
 
->,>>>,>>9
 
 
QadI16
QAD Field
 
->,>>>,>>9
 
 
QadI17
QAD Field
 
->,>>>,>>9
 
 
QadI18
QAD Field
 
->,>>>,>>9
 
 
QadI19
QAD Field
 
->,>>>,>>9
 
 
QadI20
QAD Field
 
->,>>>,>>9
 
 
QadI21
QAD Field
 
->,>>>,>>9
 
 
QadI22
QAD Field
 
->,>>>,>>9
 
 
QadI23
QAD Field
 
->,>>>,>>9
 
 
QadI24
QAD Field
 
->,>>>,>>9
 
 
QadI25
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadL03
QAD Field
 
yes/no
 
 
QadL04
QAD Field
 
yes/no
 
 
QadL05
QAD Field
 
yes/no
 
 
QadL06
QAD Field
 
yes/no
 
 
QadL07
QAD Field
 
yes/no
 
 
QadL08
QAD Field
 
yes/no
 
 
QadL09
QAD Field
 
yes/no
 
 
QadL10
QAD Field
 
yes/no
 
 
QadL11
QAD Field
 
yes/no
 
 
QadL12
QAD Field
 
yes/no
 
 
QadL13
QAD Field
 
yes/no
 
 
QadL14
QAD Field
 
yes/no
 
 
QadL15
QAD Field
 
yes/no
 
 
QadL16
QAD Field
 
yes/no
 
 
QadL17
QAD Field
 
yes/no
 
 
QadL18
QAD Field
 
yes/no
 
 
QadL19
QAD Field
 
yes/no
 
 
QadL20
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
QadT04
QAD Field
 
99/99/99
 
 
QadT05
QAD Field
 
99/99/99
 
 
QadT06
QAD Field
 
99/99/99
 
 
QadT07
QAD Field
 
99/99/99
 
 
QadT08
QAD Field
 
99/99/99
 
 
QadT09
QAD Field
 
99/99/99
 
 
QadT10
QAD Field
 
99/99/99
 
 
Site
Site
 
x(8)
 
 
ToDays
Def To Due Date
To Days
>,>>9
 
 
ToSign
Def To Due Sign
To Sign
x(1)
 
 
ToType
To Order Type
To!Type
x(2)
 
 
UserC01
User Field Character 1
 
x(24)
 
 
UserC02
User Field Character 2
 
x(24)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 2
 
99/99/99
 
 
VolumeUM
Volume UM
UM
x(2)
 
 
WeightUM
Net Weight UM
UM
x(2)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WaveTranspC
yes
oid_WaveTranspC
yes
no
 ∗
SiteWhse
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
UserC01
yes
no
 
 
 
UserC02
yes
no
wcr_route
Work Center Routing Standards
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wcr_route
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wcr__qadc01
 
 
x(8)
 
 
wcr_domain
Domain
 
x(8)
 
 
wcr_mch
Machine
 
x(8)
 
 
wcr_op
Op
 
>>>>>9
 
 
wcr_part
Routing Code
 
x(18)
 
 
wcr_rate
Std Prod Rate
Std Rate
->,>>>,>>9
 
 
wcr_user1
Ufld1
 
x(8)
 
 
wcr_user2
Ufld2
 
x(8)
 
 
wcr_wkctr
Work Center
Work Ctr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wcr_route
yes
oid_wcr_route
yes
no
 
wcr_part
yes
wcr_domain
yes
no
 
 
 
wcr_part
yes
no
 
 
 
wcr_op
yes
no
 
 
 
wcr_wkctr
yes
no
 
 
 
wcr_mch
yes
no
wcr_route
yes
wcr_domain
yes
no
 
 
 
wcr_wkctr
yes
no
 
 
 
wcr_mch
yes
no
 
 
 
wcr_part
yes
no
 
 
 
wcr_op
yes
no
wc_mstr
Work Center Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wc__chr01
User Character Field 1
 
X(8)
 
 
wc__chr02
User Character Field 2
 
X(8)
 
 
wc__chr03
User character Field 3
 
X(8)
 
 
wc__dec01
User Decimal Field 1
 
->>>,>>9.99<
10
 
wc__dec02
User Decimal Field 2
 
->>>,>>9.99<
10
 
wc__log01
User Logical Field 1
 
yes/no
 
 
wc__qad01
 
 
>,>>9.9
10
 
wc__qad02
 
 
>>,>>9.999
10
 
wc__qadc01
QAD Character Field 1
 
X(8)
 
 
wc__qadc02
QAD Character Field 2
 
X(8)
 
 
wc__qadc03
QAD Character Field 3
 
X(8)
 
 
wc__qade01
QAD Decimal Field 1
 
->>>,>>9.99<<
10
 
wc__qade02
QAD Decimal Field 2
 
->>>,>>9.99<<
10
 
wc__qadl01
QAD Logical Field 1
 
yes/no
 
 
wc_autofirm
Auto Firm
 
yes/no
 
 
wc_bdn_pct
Lbr Bdn %
 
>>9.99%
10
 
wc_bdn_rate
Lbr Bdn Rate
 
>>>,>>9.99
10
 
wc_bdn_supct
Setup Bdn %
 
>>9.99%
10
 
wc_bdn_surate
Setup Bdn Rate
 
>>>,>>9.99
10
 
wc_dept
Department
Dept
x(8)
 
 
wc_desc
Description
 
x(24)
 
 
wc_domain
Domain
 
x(8)
 
 
wc_fsm_type
FSM Type
 
x(8)
 
 
wc_hrz_end_nbr
Horizon End No Periods
 
>>9
 
 
wc_hrz_end_period
Horizon End Period
 
x(8)
 
 
wc_last_autofirm
Last Auto Firm
 
99/99/99
 
 
wc_lbr_rate
Labor Rate
 
>>>,>>9.99
10
 
wc_mch
Machine
 
x(8)
 
 
wc_mch_bdn
Mach Bdn Rate
Mach Bdn
>>>,>>9.99
10
 
wc_mch_op
Mach/Op
 
>>9
 
 
wc_mch_subdn
Mach Setup Bdn Rate
Mach Bdn
>>>,>>9.99
10
 
wc_mch_wkctr
Mach/Wk Ctr
 
>>9.999
10
 
wc_men_mch
Run Crew
 
>>9.999
10
 
wc_mod_date
Modified Date
Mod Date
99/99/99
 
 
wc_pct_eff
Percent Efficiency
 
->,>>9.999
10
 
wc_pct_util
Percent Utilization
 
->,>>9.999
10
 
wc_queue
Queue Time
Queue
>,>>9.9<<
10
 
wc_scheduler
Scheduler ID
 
x(8)
 
 
wc_setup_men
Setup Crew
 
->>,>>9.99
10
 
wc_setup_rte
Setup Rate
 
>>>,>>9.99
10
 
wc_user1
Ufld1
 
x(8)
 
 
wc_user2
Ufld2
 
x(8)
 
 
wc_userid
User ID
 
x(8)
 
 
wc_wait
Wait Time
Wait
>,>>9.9<<
10
 
wc_wk_loc
Work Location
 
x(4)
 
 
wc_wkctr
Work Center
Work Ctr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wc_mstr
yes
oid_wc_mstr
yes
no
 
wc_dept
no
wc_domain
yes
no
 
 
 
wc_dept
yes
no
 
wc_desc
yes
wc_domain
yes
no
 
 
 
wc_desc
yes
no
 
 
 
wc_wkctr
yes
no
 
 
 
wc_mch
yes
no
 
wc_fsm_type
no
wc_domain
yes
no
 
 
 
wc_fsm_type
yes
no
 
 
 
wc_wkctr
yes
no
wc_wkctr
yes
wc_domain
yes
no
 
 
 
wc_wkctr
yes
no
 
 
 
wc_mch
yes
no
whl_mstr
Warehouse Location Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_whl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
whl__chr01
Reserved
 
x(8)
 
 
whl__dec01
 
 
9.99
10
 
whl__dte01
 
 
99/99/99
 
 
whl__log01
 
 
yes/no
 
 
whl__qadc01
 
 
x(8)
 
 
whl__qadc02
 
 
x(8)
 
 
whl__qadd03
 
 
9.99
10
 
whl__qadl05
 
 
yes/no
 
 
whl__qadt04
 
 
99/99/99
 
 
whl_act
Active
 
yes/no
 
 
whl_cust_exp
Customer
 
yes/no
 
 
whl_cust_item_nbr_exp
Cust Number
Customer!Number
yes/no
 
 
whl_date
Date Created
Created
99/99/99
 
 
whl_do_cmt_exp
Comments
 
yes/no
 
 
whl_do_exp
Distribution Order
Distribution!Order
yes/no
 
 
whl_do_req_cmt_exp
Comments
 
yes/no
 
 
whl_do_req_exp
Intersite Request
Intersite!Request
yes/no
 
 
whl_domain
Domain
 
x(8)
 
 
whl_loc
Location
 
x(8)
 
 
whl_po_cmt_exp
Comments
 
yes/no
 
 
whl_po_exp
Purchase Order
Purchase!Order
yes/no
 
 
whl_pt_exp
Item
 
yes/no
 
 
whl_rps_exp
Repetitive Picklist
Repetitive!Picklist
yes/no
 
 
whl_site
Site
 
x(8)
 
 
whl_so_cmt_exp
Comments
 
yes/no
 
 
whl_so_exp
Sales Order
Sales!Order
yes/no
 
 
whl_src_dest_id
External Warehouse
 
X(18)
 
 
whl_sup_exp
Supplier
 
yes/no
 
 
whl_sup_item_nbr_exp
Supplier Number
 
yes/no
 
 
whl_um_exp
UM
 
yes/no
 
 
whl_user1
Ufld1
 
x(8)
 
 
whl_user2
Ufld2
 
x(8)
 
 
whl_wo_cmt_exp
Comments
 
yes/no
 
 
whl_wo_exp
Work Order
Work!Order
yes/no
 
 
whl_wo_rcpt_exp
Work Order Receipt
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_whl_mstr
yes
oid_whl_mstr
yes
no
 
whl_dest
no
whl_domain
yes
no
 
 
 
whl_src_dest_id
yes
no
whl_site
yes
whl_domain
yes
no
 
 
 
whl_site
yes
no
 
 
 
whl_loc
yes
no
WhseC
Warehouse Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
AllowLotSerRef
Allow Lot/Ser Ref Switch
 
yes/no
 
 
AllowQtyDec
Allow Quantity Decrease
Qty!Dec
yes/no
 
 
AllowQtyInc
Allow Quantity Increase
Qty!Inc
yes/no
 
 
AllowSwitch
Allow Task Switching
Switch
yes/no
 
 
AltUMOpt
Alternative UM Option
AltUM
>9
 
 
AutoReplen
Auto Replenish
Auto!Rep
yes/no
 
 
AutoRepPct
Auto Replenish %
Auto!Rep%
>>9.99%
2
 
BlindLoc
Blind Location
 
yes/no
 
 
CheckDigits
Check Digits
Chk
yes/no
 
 
CntPriInc
Count Increment
Count!Increment
->,>>>,>>9
 
 
CntPriority
Count Priority
Count!Priority
->,>>>,>>9
 
 
CntStatusOpt
Count Status Option
Cnt!Stat
>9
 
 
CntSystem
Count System Code
Cnt!Sys
x(2)
 
 
CntTask
Count Task
Count!Task
x(8)
 
 
CompOpt
Completion Option
Comp
>9
 
 
CountOnFail
Count on Fail
Count
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ExpDate
Expire Date (Days)
Expire Date!(Days)
>>>9
 
 
Ext132
132 Mode (External)
Ext!132
yes/no
 
 
ExtAcross
External Printer - Number Across
Ext!Across
>9
 
 
ExtDevPrinter
External Device Printer
External!Device!Printer
X(8)
 
 
ExtDown
External Printer - Lines of Each
Ext!Down
>9
 
 
ExtWidth
External Printer - Width of Each
Ext!Width
>>9
 
 
FailOpt
Fail Option
Fail
>9
 
 
FailStatus
Fail Status
Fail
X(8)
 
 
Form132
132 Mode (Form)
Form!132
yes/no
 
 
FormPrinter
Form Printer
Form!Printer
X(8)
 
 
FormUseExt
Use External
Ext
yes/no
 
 
FromLocOpt
From Location Option
From!Loc
>9
 
 
FromLotOpt
From Lot/Serial Option
From!Lot
>9
 
 
FromPartOpt
From Item Option
From!Item
>9
 
 
FromRefOpt
From Reference Option
From!Ref
>9
 
 
HoldAllowCycle
Allow Cycle Counts
Cycle
yes/no
 
 
HoldAllowInReturn
Allow Incoming Returns
InRet
yes/no
 
 
HoldAllowIssue
Allow Issues
Iss
yes/no
 
 
HoldAllowOutReturn
Allow Outgoing Returns
OutRet
yes/no
 
 
HoldAllowPick
Allow Picking
Pick
yes/no
 
 
HoldAllowReceipt
Allow Receipts
Rec
yes/no
 
 
HoldTime
Hold Time (Min)
Hld!Time
>>>>>>>9
 
 
ID132
132 Mode (ID)
ID!132
yes/no
 
 
IDAcross
ID Printer - Number Across
ID!Across
>9
 
 
IDDown
ID Printer - Lines of Each
ID!Down
>9
 
 
IDPrinter
ID Printer
ID!Printer
X(8)
 
 
IDUseExt
Use External
Ext
yes/no
 
 
IDWidth
ID Printer - Width of Each
ID!Width
>>9
 
 
Insp132
132 Mode (Insp)
Insp!132
yes/no
 
 
InspAcross
Insp Printer - Number Across
Insp!Across
>9
 
 
InspDown
Insp Printer - Lines of Each
Insp!Down
>9
 
 
InspPrinter
Insp Printer
 
x(8)
 
 
InspUseExt
Use External
Ext
yes/no
 
 
InspWidth
Insp Printer - Width of Each
Insp!Width
>>9
 
 
KeepFromStatus
Keep From Status
Keep!From!Status
yes/no
 
 
LocThreshPct
Location Capacity Threshold
Location!Capacity!Threshold
>>9.99%
2
 
LogUMTolPct
Logistics UM Tolerance
Log UM Tol
>>9.99%
2
 
ManCode
Man Code
 
X(8)
0
 
MaxTrans
Max Transactions
 
->>>,>>9.9<<<<<<
10
 
MBAssign
Flav C Hard/Soft Assign.
 
Hard/Soft
 
 
MBPrintID
Def ID Print Flavor C
 
yes/no
 
 
MBSort
Multi-bin Pick flav C Sort.
 
9
 
 
MixStatus
Allow Mixed Status Codes
Mix!Status
yes/no
 
 
ModDate
Modified
 
99/99/99
 
 
ModeM
Mode
 
X(8)
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WhseC
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OneLevelPick
Single Level Picking
Single!Level!Pick
yes/no
 
 
OPCActive
Opportunity Counts
OPC
yes/no
 
 
OPCFreq
OPC Frequency
OPC Freq
>>>9
 
 
Optimized
Optimized Storage
Optim
yes/no
 
 
PickEnd
End Picking Level
Pick!End
>>9
 
 
PickStart
Start Picking Level
Pick!Start
>>9
 
 
PLDSync
Inventory Account Sync
Inv!Acct!Sync
x(1)
 
 
PrintByWLG
Print By Work Location Group
Print!By WLG
yes/no
 
 
PrintException
Print Exceptions
Print!Except
yes/no
 
 
PrintFlavor
Print Flavor
Prt!Flv
x(1)
 
 
PrintID
Print ID
Print!ID
yes/no
 
 
PrintModeCl
Print Mode (Confirmed Tasks)
Print!Mode Cl
X(8)
 
 
PrintModeCr
Print Mode (Created Tasks)
Print!Mode Cr
X(8)
 
 
PrintModeEx
Print Mode (Exceptions)
Print!Mode Ex
X(8)
 
 
PrintModeID
Print Mode (ID)
Print!Mode ID
X(8)
 
 
PrintModeInsp
Print Mode (ID)
Print!Mode ID
X(8)
 
 
PrintTaskCl
Print Confirmed Tasks
Print!Cl Task
yes/no
 
 
PrintTaskCr
Print Created Tasks
Print!Cr Task
yes/no
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
QtyOpt
Quantity Change Option
Qty
>9
 
 
RcntPriInc
Recount Increment
Recount!Increment
->,>>>,>>9
 
 
RcntPriority
Recount Priority
Recount!Priority
->,>>>,>>9
 
 
RcntSystem
Recount System Code
Rcnt!Sys
x(2)
 
 
RcntTask
Recount Task
Recount!Task
x(8)
 
 
RefNRID
Reference NR ID
Ref NR ID
X(8)
 
 
RepickOpt
Repick Option
Repick
>9
 
 
RepickType
Repick Tran Type
Repick!Tran Type
x(8)
 
 
SearchWindow
Transaction Search Window
Trans!Window
>>9
 
 
SystemCode
System Code
Sys
x(2)
 
 
SystemFlavor
Flavor
Flv
x(1)
 
 
Task
Task
 
x(8)
 
 
Task132
132 Mode (Task)
Task!132
yes/no
 
 
TaskAcross
Task Printer - Number Across
Task!Across
>9
 
 
TaskDown
Task Printer - Lines of Each
Task!Down
>9
 
 
TaskPrinter
Task Printer
Task!Printer
X(8)
 
 
TaskUseExt
Use External
Ext
yes/no
 
 
TaskWidth
Task Printer - Width of Each
Task!Width
>>9
 
 
ToLocOpt
To Location Option
To!Loc
>9
 
 
ToLotOpt
To Lot/Serial Option
To!Lot
>9
 
 
ToPartOpt
To Item Option
To!Item
>9
 
 
ToRefOpt
To Reference Option
To!Ref
>9
 
 
TrPriInc
Increment
 
->,>>>,>>9
 
 
TrPriority
Priority
 
->,>>>,>>9
 
 
TwoPhase
Two Phase
2Ph
yes/no
 
 
UniqueID
 
 
9
 
 
UseFrom
Confirmed at Source
Conf!Src
yes/no
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UseRecntUM
Use Recount UM of SLG
Use!Rcnt!UM
yes/no
 
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
WhseInvStatus
Default Whse Inv Status
Whse!Inv Stat
X(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WhseC
yes
oid_WhseC
yes
no
 ∗
UniqueID
yes
Domain
yes
no
 
 
 
UniqueID
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WhseListD
Warehouse Master List Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ListSeq
Seq
 
>>9
 
 
Loc
Location
 
x(8)
 
 
MasterList
Master List
Master!List
X(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_WhseListD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
Site
Site
 
x(8)
 
 
TrType
Type
 
x(8)
 
 
UltSite
Ultimate Site
Ultimate!Site
x(8)
 
 
UltWhse
Ultimate Warehouse
Ultimate!Whse
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WhseListD
yes
oid_WhseListD
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
Whse
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
MasterList
yes
no
 
 
 
TrType
yes
no
 
 
 
Whse
yes
no
WMLDIdx
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
MasterList
yes
no
 
 
 
TrType
yes
no
 
 
 
ListSeq
yes
no
WhseListM
Warehouse Master List Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
MasterList
Master List
Master!List
X(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WhseListM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WhseListM
yes
oid_WhseListM
yes
no
 ∗
SiteList
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
MasterList
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WhseM
Warehouse Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
Active
Active
Act
yes/no
 
 
Addr
Address
 
x(8)
 
 
AllowLotSerRef
Allow Lot/Ser Ref Switch
 
yes/no
 
 
AllowQtyDec
Allow Quantity Decrease
Qty!Dec
yes/no
 
 
AllowQtyInc
Allow Quantity Increase
Qty!Inc
yes/no
 
 
AllowSwitch
Allow Task Switching
Switch
yes/no
 
 
AltUMOpt
Alternative UM Option
AltUM
>9
 
 
AutoBPOD
Automatically Recreate BPs
Auto BP
yes/no
 
 
AutoReplen
Auto Replenish
Auto!Rep
yes/no
 
 
AutoRepPct
Auto Replenish %
Auto!Rep%
>>9.99%
2
 
BaseUMOnly
Base UM Only
 
yes/no
 
 
BlindLoc
Blind Location
 
yes/no
 
 
CanRun
Roles
 
x(189)
 
 
CheckDigits
Check Digits
Chk
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CntPriInc
Count Increment
Count!Increment
->,>>>,>>9
 
 
CntPriority
Count Priority
Count!Priority
->,>>>,>>9
 
 
CntStatusOpt
Count Status Option
Cnt!Stat
>9
 
 
CntSystem
Count System Code
Cnt!Sys
x(2)
 
 
CntTask
Count Task
Count!Task
x(8)
 
 
CompOpt
Completion Option
Comp
>9
 
 
CountOnFail
Count on Fail
Count
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
ExpDate
Expire Date (Days)
Expire Date!(Days)
>>>9
 
 
Ext132
132 Mode (External)
Ext!132
yes/no
 
 
ExtAcross
External Printer - Number Across
Ext!Across
>9
 
 
ExtDevPrinter
External Device Printer
External!Device!Printer
X(8)
 
 
ExtDown
External Printer - Lines of Each
Ext!Down
>9
 
 
ExtWidth
External Printer - Width of Each
Ext!Width
>>9
 
 
FailOpt
Fail Option
Fail
>9
 
 
FailStatus
Fail Status
Fail
X(8)
 
 
Form132
132 Mode (Form)
Form!132
yes/no
 
 
FormPrinter
Form Printer
Form!Printer
X(8)
 
 
FormUseExt
Use External
Ext
yes/no
 
 
FromLocOpt
From Location Option
From!Loc
>9
 
 
FromLotOpt
From Lot/Serial Option
From!Lot
>9
 
 
FromPartOpt
From Item Option
From!Item
>9
 
 
FromRefOpt
From Reference Option
From!Ref
>9
 
 
HoldAllowCycle
Allow Cycle Counts
Cycle
yes/no
 
 
HoldAllowInReturn
Allow Incoming Returns
InRet
yes/no
 
 
HoldAllowIssue
Allow Issues
Iss
yes/no
 
 
HoldAllowOutReturn
Allow Outgoing Returns
OutRet
yes/no
 
 
HoldAllowPick
Allow Picking
Pick
yes/no
 
 
HoldAllowReceipt
Allow Receipts
Rec
yes/no
 
 
HoldTime
Hold Time (Min)
Hld!Time
>>>>>>>9
 
 
ID132
132 Mode (ID)
ID!132
yes/no
 
 
IDAcross
ID Printer - Number Across
ID!Across
>9
 
 
IDDown
ID Printer - Lines of Each
ID!Down
>9
 
 
IDPrinter
ID Printer
ID!Printer
X(8)
 
 
IDUseExt
Use External
Ext
yes/no
 
 
IDWidth
ID Printer - Width of Each
ID!Width
>>9
 
 
Insp132
132 Mode (Insp)
Insp!132
yes/no
 
 
InspAcross
Insp Printer - Number Across
Insp!Across
>9
 
 
InspDown
Insp Printer - Lines of Each
Insp!Down
>9
 
 
InspPrinter
Insp Printer
 
x(8)
 
 
InspUseExt
Use External
Ext
yes/no
 
 
InspWidth
Insp Printer - Width of Each
Insp!Width
>>9
 
 
KeepFromStatus
Keep From Status
Keep!From!Status
yes/no
 
 
LocThreshPct
Location Capacity Threshold
Location!Capacity!Threshold
>>9.99%
2
 
LogUMTolPct
Logistics UM Tolerance
Log UM Tol
>>9.99%
2
 
ManCode
Man Code
 
X(8)
0
 
MaxTrans
Max Trans
 
->>,>>9.99
10
 
MBAssign
Flav C Hard/Soft Assign.
 
Hard/Soft
 
 
MBPrintID
Def ID Print Flavor C
 
yes/no
 
 
MBSort
Multi-bin Pick flav C Sort.
 
9
 
 
MixStatus
Allow Mixed Status Codes
Mix!Status
yes/no
 
 
ModDate
Modified
 
99/99/99
 
 
ModeM
Mode
 
X(8)
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WhseM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OneLevelPick
Single Level Picking
Single!Level!Pick
yes/no
 
 
OPCActive
Opportunity Counts
OPC
yes/no
 
 
OPCFreq
OPC Frequency
OPC Freq
>>>9
 
 
Optimized
Optimized Storage
Optim
yes/no
 
 
PackNrID
Packaging Seq ID
Pck!Seq!ID
x(8)
 
 
PickEnd
End Picking Level
Pick!End
>>9
 
 
PickStart
Start Picking Level
Pick!Start
>>9
 
 
PLDSync
Inventory Account Sync
Inv!Acct!Sync
x(1)
 
 
PrintByWLG
Print By Work Location Group
Print!By WLG
yes/no
 
 
PrintException
Print Exceptions
Print!Except
yes/no
 
 
PrintFlavor
Print Flavor
Prt!Flv
x(1)
 
 
PrintID
Print ID
Print!ID
yes/no
 
 
PrintModeCl
Print Mode (Confirmed Tasks)
Print!Mode Cl
X(8)
 
 
PrintModeCr
Print Mode (Created Tasks)
Print!Mode Cr
X(8)
 
 
PrintModeEx
Print Mode (Exceptions)
Print!Mode Ex
X(8)
 
 
PrintModeID
Print Mode (ID)
Print!Mode ID
X(8)
 
 
PrintModeInsp
Print Mode (ID)
Print!Mode ID
X(8)
 
 
PrintTaskCl
Print Confirmed Tasks
Print!Cl Task
yes/no
 
 
PrintTaskCr
Print Created Tasks
Print!Cr Task
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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
QtyOpt
Quantity Change Option
Qty
>9
 
 
RcntPriInc
Recount Increment
Recount!Increment
->,>>>,>>9
 
 
RcntPriority
Recount Priority
Recount!Priority
->,>>>,>>9
 
 
RcntSystem
Recount System Code
Rcnt!Sys
x(2)
 
 
RcntTask
Recount Task
Recount!Task
x(8)
 
 
RefNRID
Reference Seq ID
Ref Sq ID
X(8)
 
 
RepickOpt
Repick Option
Repick
>9
 
 
RepickType
Repick Tran Type
Repick!Tran Type
x(8)
 
 
SearchWindow
Transaction Search Window
Trans!Window
>>9
 
 
Site
Site
 
x(8)
 
 
SystemCode
System Code
Sys
x(2)
 
 
SystemFlavor
Flavor
Flv
x(1)
 
 
Task
Task
 
x(8)
 
 
Task132
132 Mode (Task)
Task!132
yes/no
 
 
TaskAcross
Task Printer - Number Across
Task!Across
>9
 
 
TaskDown
Task Printer - Lines of Each
Task!Down
>9
 
 
TaskPrinter
Task Printer
Task!Printer
X(8)
 
 
TaskUseExt
Use External
Ext
yes/no
 
 
TaskWidth
Task Printer - Width of Each
Task!Width
>>9
 
 
ToLocOpt
To Location Option
To!Loc
>9
 
 
ToLotOpt
To Lot/Serial Option
To!Lot
>9
 
 
ToPartOpt
To Item Option
To!Item
>9
 
 
ToRefOpt
To Reference Option
To!Ref
>9
 
 
TrPriInc
Increment
 
->,>>>,>>9
 
 
TrPriority
Priority
 
->,>>>,>>9
 
 
TwoPhase
Two Phase
2Ph
yes/no
 
 
UseFrom
Confirmed at Source
Conf!Src
yes/no
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UseRecntUM
Use Recount UM of SLG
Use!Rcnt!UM
yes/no
 
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WhseM
yes
oid_WhseM
yes
no
 ∗
SiteWhse
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WhseTferOrdD
Warehouse Transfer Order Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
Conv
Conversion
Conv
>>>>9.9999<<<<
10
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_WhseTferOrdD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
QtyOrd
Quantity Ordered
Quantity!Ordered
->,>>>,>>9.9<<<<<<<<
10
 
QtyPick
Quantity Picked
Quantity!Picked
->,>>>,>>9.9<<<<<<<<
10
 
QtyShip
Quantity Shipped
Quantity!Shipped
->,>>>,>>9.9<<<<<<<<
10
 
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
WTLine
Line
 
>>>9
 
 
WTOrder
Order
 
X(8)
 
 
WTPart
Item Number
 
x(18)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WhseTferOrdD
yes
oid_WhseTferOrdD
yes
no
 ∗
OrderLine
yes
Domain
yes
no
 
 
 
WTOrder
yes
no
 
 
 
WTLine
yes
no
 
Part
no
Domain
yes
no
 
 
 
WTPart
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WhseTferOrdM
Warehouse Transfer Order Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
FromAddr
From Address
From!Address
x(8)
 
 
FromSite
From Site
From!Site
x(8)
 
 
FromWhse
From Whse
From!Whse
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WhseTferOrdM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
ReqDate
Required
 
99/99/99
 
 
ShipDate
Shipped
 
99/99/99
 
 
ToAddr
To Address
To!Address
x(8)
 
 
ToSite
To Site
 
x(8)
 
 
ToWhse
To Whse
 
x(8)
 
 
Transport
Transport
 
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
WTOrder
Order
 
X(8)
 
 
WTStatus
Status
St
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
FromWhse
no
Domain
yes
no
 
 
 
FromSite
yes
no
 
 
 
FromWhse
yes
no
 
oid_WhseTferOrdM
yes
oid_WhseTferOrdM
yes
no
 
ToWhse
no
Domain
yes
no
 
 
 
ToSite
yes
no
 
 
 
ToWhse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WTOrder
yes
Domain
yes
no
 
 
 
WTOrder
yes
no
 
WTStatus
no
Domain
yes
no
 
 
 
WTStatus
yes
no
 
 
 
ReqDate
yes
no
WhseTrTypeM
Warehouse/Transaction Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
Consolidate
Consolidate
Cons
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModeM
Mode
 
X(8)
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WhseTrTypeM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OneLevelPick
Single Level Picking
Single!Level!Pick
yes/no
 
 
OverPick
Over Pick
Over!Pick
yes/no
 
 
PickEnd
End Picking Level
Pick!End
>>9
 
 
PickStart
Start Picking Level
Pick!Start
>>9
 
 
PrintProcCode
Print Procedure Code
Print!Proc
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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
SearchWindow
Transaction Search Window
Trans!Window
>>9
 
 
ShortAction
Shortage Action
Short!Act
>>9
 
 
ShortDef
Shortage Definition
Short!Def
>>9
 
 
ShortQtyDef
Shortage Quantity Definition
Short!Qty Def
>>9
 
 
ShortWindow
Shortage Window
Short!Wind
>>9
 
 
Site
Site
 
x(8)
 
 
SLGListSearchExt
SLG List Search Extension
SLG List Ext
yes/no
 
 
SLGOPControl
Control Over-Pick at SLG
 
yes/no
 
 
SLGSearchExt
SLG Search Extension
SLG Ext
yes/no
 
 
TrType
Type
 
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
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WhseTrTypeM
yes
oid_WhseTrTypeM
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WhseTrType
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
TrType
yes
no
WHT
Withholding Tax
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankStateAlloc_ID
Link to BankStateAlloc
 
-99999999999
 
 
CACInvoice_ID
Link to CA-CInvoice
 
-99999999999
 
 
CDocumentInvoiceXref_ID
Link to CDocumentInvoiceXref
 
-99999999999
 
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceWHT_ID
Link to CInvoiceWHT
 
-99999999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
CostCentre_ID
Link to CostCentre
 
-99999999999
 
 
Creditor_ID
Link to Creditor
 
-99999999999
 
 
Currency_ID
Link to Currency
 
-99999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
Division_ID
Link to Division
 
-99999999999
 
 
GL_ID
Link to GL
 
-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)
 
 
OIAdjustLn_ID
Link to OIAdjustLn
 
-99999999999
 
 
Project_ID
Link to Project
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Vat_ID
Link to Vat
 
-99999999999
 
 
WHT_ID
Record ID
 
-99999999999
 
 
WHTAdditionalNumber
Additional WHT Number
 
999999999
 
 
WHTAmtCreditCC
WHT Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTAmtCreditLC
WHT Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTAmtCreditTC
WHT Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTAmtDebitCC
WHT Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTAmtDebitLC
WHT Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTAmtDebitTC
WHT Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTCertFormat_ID
Link to WHTCertFormat
 
-99999999999
 
 
WHTChargeAmtCreditCC
Charge Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTChargeAmtCreditLC
Charge Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTChargeAmtCreditTC
Charge Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTChargeAmtDebitCC
Charge Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTChargeAmtDebitLC
Charge Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTChargeAmtDebitTC
Charge Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTChargeType
Charge Type
 
x(20)
 
 
WHTCInvoicePostingDate
Invoice Posting Date
 
99/99/9999
 
 
WHTCInvoiceReference
Invoice Reference
 
x(50)
 
 
WHTCompanyCode
Entity Code
 
x(20)
 
 
WHTCompanyLCCurrencyCode
Base Currency
 
x(3)
 
 
WHTCreditorCode
Supplier Code
 
x(8)
 
 
WHTCreditorSharedSetCode
Supplier Shared Set Code
 
x(20)
 
 
WHTIsPrinted
Printed
 
yes/no
 
 
WHTNumber
WHT Number
 
999999999
 
 
WHTPaidAmtCreditCC
Paid Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTPaidAmtCreditLC
Paid Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTPaidAmtCreditTC
Paid Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTPaidAmtDebitCC
Paid Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTPaidAmtDebitLC
Paid Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTPaidAmtDebitTC
Paid Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTPaymentDate
Payment Date
 
99/99/9999
 
 
WHTPaymentReference
Payment Reference
 
x(40)
 
 
WHTPercentage
WHT Tax Rate Perc
 
->>9.99
2
 
WHTPeriodPeriod
GL Period
GL Pd
99
 
 
WHTPeriodYear
GL Calendar Year
GL Cal Year
9999
 
 
WHTRetainedAmtCreditCC
Retained Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTRetainedAmtCreditLC
Retained Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTRetainedAmtCreditTC
Retained Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTRetainedAmtDebitCC
Retained Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTRetainedAmtDebitLC
Retained Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTRetainedAmtDebitTC
Retained Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTSettlementDate
Settlement Date
 
99/99/9999
 
 
WHTStatus
WHT Status
 
x(20)
 
 
WHTTaxableFeesCreditCC
Taxable Fee Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTaxableFeesCreditLC
Taxable Fee Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTaxableFeesCreditTC
Taxable Fee Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTaxableFeesDebitCC
Taxable Fee Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTaxableFeesDebitLC
Taxable Fee Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTaxableFeesDebitTC
Taxable Fee Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTaxType
Tax Type
 
x(16)
 
 
WHTTotAmtCreditCC
Total Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTotAmtCreditLC
Total Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTotAmtCreditTC
Total Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTotAmtDebitCC
Total Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTotAmtDebitLC
Total Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTTotAmtDebitTC
Total Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTVATAmtCreditCC
Tax Amount Cr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTVATAmtCreditLC
Tax Amount Cr BC
 
->>>,>>>,>>>,>>9.99
4
 
WHTVATAmtCreditTC
Tax Amount Cr TC
 
->>>,>>>,>>>,>>9.99
4
 
WHTVATAmtDebitCC
Tax Amount Dr SC
 
->>>,>>>,>>>,>>9.99
4
 
WHTVATAmtDebitLC
Tax Amount Dr LC
 
->>>,>>>,>>>,>>9.99
4
 
WHTVATAmtDebitTC
Tax Amount Dr TC
 
->>>,>>>,>>>,>>9.99
4
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankStateAlloc
no
BankStateAlloc_ID
yes
no
 
CACInvoice
no
CACInvoice_ID
yes
no
 
CDoxInvXRef
no
CDocumentInvoiceXref_ID
yes
no
 
CInvoice
no
CInvoice_ID
yes
no
 
CInvoiceWHT
no
CInvoiceWHT_ID
yes
no
 
Company
no
Company_ID
yes
no
 
CostCentre
no
CostCentre_ID
yes
no
 
Creditor
no
Creditor_ID
yes
no
 
CreditorIdx
no
WHTCreditorCode
yes
no
 
Currency
no
Currency_ID
yes
no
 
CyIdx
no
WHTCompanyCode
yes
no
 
Division
no
Division_ID
yes
no
 
GL
no
GL_ID
yes
no
 
OIAdj
no
OIAdjustLn_ID
yes
no
 
PaymentDate
no
Company_ID
yes
no
 
 
 
WHTPaymentDate
yes
no
 
PeriodIdx
no
WHTPeriodYear
yes
no
 
 
 
WHTPeriodPeriod
yes
no
 
PostingDate
no
Company_ID
yes
no
 
 
 
WHTCInvoicePostingDate
yes
no
 ∗
Prim
yes
WHT_ID
yes
no
 
PrjIdx
no
Project_ID
yes
no
 
SSCurrIdx
no
WHTCreditorSharedSetCode
yes
no
 
 
 
WHTCompanyLCCurrencyCode
yes
no
 
TaxTypeIdx
no
WHTTaxType
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
CInvoiceWHT_ID
yes
no
 
 
 
BankStateAlloc_ID
yes
no
 
 
 
CDocumentInvoiceXref_ID
yes
no
 
 
 
OIAdjustLn_ID
yes
no
 
 
 
CACInvoice_ID
yes
no
 
 
 
WHTChargeType
yes
no
 
Vat
no
Vat_ID
yes
no
 
WHTCertFormat
no
WHTCertFormat_ID
yes
no
 
WHTNumber
no
WHTNumber
yes
no
WHTCertFormat
WHTCertFormat
 
 
Field Name
Label
Col-Label
Format
Dec
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
WHTCertFormat_ID
Record ID
 
-99999999999
 
 
WHTCertFormatCode
Format Code
Format Code
x(20)
 
 
WHTCertFormatDescription
Description
 
x(40)
 
 
WHTCertFormatIsActive
Active
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Code
yes
WHTCertFormatCode
yes
no
 
IsActive
no
WHTCertFormatIsActive
yes
no
 ∗
Prim
yes
WHTCertFormat_ID
yes
no
wlbd_det
WIP Lot Trace BOM Control Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wlbd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wlbd__chr01
 
 
X(16)
 
 
wlbd__chr02
 
 
X(16)
 
 
wlbd__chr03
 
 
X(16)
 
 
wlbd__chr04
 
 
X(16)
 
 
wlbd__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbd__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbd__dte01
 
 
99/99/99
 
 
wlbd__dte02
 
 
99/99/99
 
 
wlbd__int01
 
 
->,>>>,>>9
 
 
wlbd__int02
 
 
->,>>>,>>9
 
 
wlbd__log01
 
 
yes/no
 
 
wlbd__log02
 
 
yes/no
 
 
wlbd__qadc01
 
 
X(16)
 
 
wlbd__qadc02
 
 
X(16)
 
 
wlbd__qadc03
 
 
X(16)
 
 
wlbd__qadc04
 
 
X(16)
 
 
wlbd__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbd__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbd__qadi01
 
 
->,>>>,>>9
 
 
wlbd__qadi02
 
 
->,>>>,>>9
 
 
wlbd__qadl01
 
 
yes/no
 
 
wlbd__qadl02
 
 
yes/no
 
 
wlbd__qadt01
 
 
99/99/99
 
 
wlbd__qadt02
 
 
99/99/99
 
 
wlbd_bom_code
BOM Code
 
x(18)
 
 
wlbd_comp
Component Item
 
X(18)
 
 
wlbd_comp_cmb_ok
Combine Component Lots
Combine!Component Lots
yes/no
 
 
wlbd_domain
Domain
 
x(8)
 
 
wlbd_mod_date
Modified Date
Mod Date
99/99/99
 
 
wlbd_mod_userid
User ID
 
x(8)
 
 
wlbd_start
Start Date
Start
99/99/99
 
 
wlbd_trc_comps
Trace Components
Trace!Components
yes/no
 
 
wlbd_trc_ref
Trace Reference
Trace!Reference
yes/no
 
 
wlbd_user1
Ufld1
 
X(16)
 
 
wlbd_user2
Ufld2
 
X(16)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wlbd_det
yes
oid_wlbd_det
yes
no
wlbd_bom_code
yes
wlbd_domain
yes
no
 
 
 
wlbd_bom_code
yes
no
 
 
 
wlbd_start
yes
no
 
 
 
wlbd_comp
yes
no
wlbm_mstr
WIP Lot Trace BOM Control Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wlbm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wlbm__chr01
 
 
X(16)
 
 
wlbm__chr02
 
 
X(16)
 
 
wlbm__chr03
 
 
X(16)
 
 
wlbm__chr04
 
 
X(16)
 
 
wlbm__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbm__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbm__dte01
 
 
99/99/99
 
 
wlbm__dte02
 
 
99/99/99
 
 
wlbm__int01
 
 
->,>>>,>>9
 
 
wlbm__int02
 
 
->,>>>,>>9
 
 
wlbm__log01
 
 
yes/no
 
 
wlbm__log02
 
 
yes/no
 
 
wlbm__qadc01
 
 
X(16)
 
 
wlbm__qadc02
 
 
X(16)
 
 
wlbm__qadc03
 
 
X(16)
 
 
wlbm__qadc04
 
 
X(16)
 
 
wlbm__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbm__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlbm__qadi01
 
 
->,>>>,>>9
 
 
wlbm__qadi02
 
 
->,>>>,>>9
 
 
wlbm__qadl01
 
 
yes/no
 
 
wlbm__qadl02
 
 
yes/no
 
 
wlbm__qadt01
 
 
99/99/99
 
 
wlbm__qadt02
 
 
99/99/99
 
 
wlbm_bom_code
BOM Code
 
x(18)
 
 
wlbm_comp_cmb_ok
Combine Component Lots
Combine!Component Lots
yes/no
 
 
wlbm_domain
Domain
 
x(8)
 
 
wlbm_end
End Date
End
99/99/99
 
 
wlbm_mod_date
Modified Date
Mod Date
99/99/99
 
 
wlbm_mod_userid
User ID
 
x(8)
 
 
wlbm_start
Start Date
Start
99/99/99
 
 
wlbm_trc_comps
Trace Components
Trace!Components
yes/no
 
 
wlbm_trc_ref
Trace Reference
Trace!Reference
yes/no
 
 
wlbm_user1
Ufld1
 
X(16)
 
 
wlbm_user2
Ufld2
 
X(16)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wlbm_mstr
yes
oid_wlbm_mstr
yes
no
wlbm_bom_code
yes
wlbm_domain
yes
no
 
 
 
wlbm_bom_code
yes
no
 
 
 
wlbm_start
yes
no
wlc_ctrl
WIP Lot Trace Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wlc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wlc__chr01
 
 
X(16)
 
 
wlc__chr02
 
 
X(16)
 
 
wlc__chr03
 
 
X(16)
 
 
wlc__chr04
 
 
X(16)
 
 
wlc__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlc__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlc__dte01
 
 
99/99/99
 
 
wlc__dte02
 
 
99/99/99
 
 
wlc__int01
 
 
->,>>>,>>9
 
 
wlc__int02
 
 
->,>>>,>>9
 
 
wlc__log01
 
 
yes/no
 
 
wlc__log02
 
 
yes/no
 
 
wlc__qadc01
 
 
X(16)
 
 
wlc__qadc02
 
 
X(16)
 
 
wlc__qadc03
 
 
X(16)
 
 
wlc__qadc04
 
 
X(16)
 
 
wlc__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlc__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlc__qadi01
 
 
->,>>>,>>9
 
 
wlc__qadi02
 
 
->,>>>,>>9
 
 
wlc__qadi03
 
 
->>>>>>>9
 
 
wlc__qadl01
 
 
yes/no
 
 
wlc__qadl02
 
 
yes/no
 
 
wlc__qadt01
 
 
99/99/99
 
 
wlc__qadt02
 
 
99/99/99
 
 
wlc_comp_cmb_ok
Combine Component Lots
 
yes/no
 
 
wlc_domain
Domain
 
x(8)
 
 
wlc_enable_wlt
Enable WIP Lot Trace
 
yes/no
 
 
wlc_maxlotsize
Max Lot Size
 
>>>,>>>,>>9.9
10
 
wlc_mod_date
Modified Date
Mod Date
99/99/99
 
 
wlc_mod_userid
User ID
 
x(8)
 
 
wlc_nrm_id
WIP Lot Number Sequence ID
 
x(8)
 
 
wlc_overissue
WIP Lot Overissue
 
yes/no
 
 
wlc_trc_comps
Trace Components
Trace!Components
yes/no
 
 
wlc_trc_parents
Trace Parents
Trace!Parents
yes/no
 
 
wlc_trc_ref
Trace Reference
Trace!Reference
yes/no
 
 
wlc_user1
Ufld1
 
X(16)
 
 
wlc_user2
Ufld2
 
X(16)
 
 
wlc_wip_cmb_ok
Combine WIP Lots
 
yes/no
 
 
wlc_wip_split_ok
Split WIP Lots
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wlc_ctrl
yes
oid_wlc_ctrl
yes
no
wlc_index1
yes
wlc_domain
yes
no
wld_det
WIP Lot Inventory Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wld__chr01
 
 
X(16)
 
 
wld__chr02
 
 
X(16)
 
 
wld__chr03
 
 
X(16)
 
 
wld__chr04
 
 
X(16)
 
 
wld__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wld__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wld__dte01
 
 
99/99/99
 
 
wld__dte02
 
 
99/99/99
 
 
wld__int01
 
 
->,>>>,>>9
 
 
wld__int02
 
 
->,>>>,>>9
 
 
wld__log01
 
 
yes/no
 
 
wld__log02
 
 
yes/no
 
 
wld__qadc01
 
 
X(16)
 
 
wld__qadc02
 
 
X(16)
 
 
wld__qadc03
 
 
X(16)
 
 
wld__qadc04
 
 
X(16)
 
 
wld__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wld__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wld__qadi01
 
 
->,>>>,>>9
 
 
wld__qadi02
 
 
->,>>>,>>9
 
 
wld__qadl01
 
 
yes/no
 
 
wld__qadl02
 
 
yes/no
 
 
wld__qadt01
 
 
99/99/99
 
 
wld__qadt02
 
 
99/99/99
 
 
wld_alloc_id
Alloc To WO ID
 
x(8)
 
 
wld_alloc_op
Operation
Op
>>>>9
 
 
wld_alloc_que
Queue
 
x(8)
 
 
wld_domain
Domain
 
x(8)
 
 
wld_lotser
Lot/Serial
 
x(18)
 
 
wld_mch
Machine
 
x(8)
 
 
wld_mod_date
Modified Date
Mod Date
99/99/99
 
 
wld_mod_userid
User ID
 
x(8)
 
 
wld_prodby_id
Produced By ID
Prod ID
x(8)
 
 
wld_prodby_op
Produced By Op
Prod Op
>>>>9
 
 
wld_qty_oh
Qty On Hand
 
->,>>>,>>9.9<<<<<<<<
10
 
wld_ref
Reference
Ref
x(8)
 
 
wld_site
Site
 
x(8)
 
 
wld_user1
Ufld1
 
X(16)
 
 
wld_user2
Ufld2
 
X(16)
 
 
wld_wkctr
Work Center
Work Ctr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wld_det
yes
oid_wld_det
yes
no
 
wld_alloc_loc
no
wld_domain
yes
no
 
 
 
wld_alloc_id
yes
no
 
 
 
wld_alloc_op
yes
no
 
 
 
wld_alloc_que
yes
no
 
 
 
wld_site
yes
no
 
 
 
wld_wkctr
yes
no
 
 
 
wld_mch
yes
no
 
 
 
wld_prodby_id
yes
no
 
 
 
wld_prodby_op
yes
no
 
 
 
wld_lotser
yes
no
 
 
 
wld_ref
yes
no
wld_id
yes
wld_domain
yes
no
 
 
 
wld_prodby_id
yes
no
 
 
 
wld_prodby_op
yes
no
 
 
 
wld_lotser
yes
no
 
 
 
wld_ref
yes
no
 
 
 
wld_site
yes
no
 
 
 
wld_wkctr
yes
no
 
 
 
wld_mch
yes
no
 
 
 
wld_alloc_id
yes
no
 
 
 
wld_alloc_op
yes
no
 
 
 
wld_alloc_que
yes
no
 
wld_lotser
no
wld_domain
yes
no
 
 
 
wld_lotser
yes
no
 
 
 
wld_ref
yes
no
 
 
 
wld_prodby_id
yes
no
 
 
 
wld_prodby_op
yes
no
 
 
 
wld_site
yes
no
 
 
 
wld_wkctr
yes
no
 
 
 
wld_mch
yes
no
 
 
 
wld_alloc_id
yes
no
 
 
 
wld_alloc_op
yes
no
 
 
 
wld_alloc_que
yes
no
WLGM
Work Location Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
AllowSwitch
Allow Task Switching
Switch
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CntPriInc
Count Increment
Count!Increment
->,>>>,>>9
 
 
CntPriority
Count Priority
Count!Priority
->,>>>,>>9
 
 
CntSystem
Count System Code
Cnt!Sys
x(2)
 
 
CntTask
Count Task
Count!Task
x(8)
 
 
CountOnFail
Count on Fail
Count
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
DevCode
Device
 
X(8)
 
 
Domain
Domain
 
x(8)
 
 
Ext132
132 Mode (External)
Ext!132
yes/no
 
 
ExtAcross
External Printer - Number Across
Ext!Across
>9
 
 
ExtDevPrinter
External Device Printer
External!Device!Printer
X(8)
 
 
ExtDown
External Printer - Lines of Each
Ext!Down
>9
 
 
ExtWidth
External Printer - Width of Each
Ext!Width
>>9
 
 
Form132
132 Mode (Form)
Form!132
yes/no
 
 
FormPrinter
Form Printer
Form!Printer
X(8)
 
 
FormUseExt
Use External
Ext
yes/no
 
 
ID132
132 Mode (ID)
ID!132
yes/no
 
 
IDAcross
ID Printer - Number Across
ID!Across
>9
 
 
IDDown
ID Printer - Lines of Each
ID!Down
>9
 
 
IDPrinter
ID Printer
ID!Printer
X(8)
 
 
IDUseExt
Use External
Ext
yes/no
 
 
IDWidth
ID Printer - Width of Each
ID!Width
>>9
 
 
Insp132
132 Mode (Insp)
Insp!132
yes/no
 
 
InspAcross
Insp Printer - Number Across
Insp!Across
>9
 
 
InspDown
Insp Printer - Lines of Each
Insp!Down
>9
 
 
InspPrinter
Insp Printer
 
x(8)
 
 
InspUseExt
Use External
Ext
yes/no
 
 
InspWidth
Insp Printer - Width of Each
Insp!Width
>>9
 
 
KeepFromStatus
Keep From Status
Keep!From!Status
yes/no
 
 
ManCode
Man Code
 
X(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WLGM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PrintException
Print Exceptions
Print!Except
yes/no
 
 
PrintFlavor
Print Flavor
Prt!Flv
x(1)
 
 
PrintID
Print ID
 
yes/no
 
 
PrintModeCl
Print Mode (Confirmed Tasks)
Print!Mode Cl
X(8)
 
 
PrintModeCr
Print Mode (Created Tasks)
Print!Mode Cr
X(8)
 
 
PrintModeEx
Print Mode (Exceptions)
Print!Mode Ex
X(8)
 
 
PrintModeID
Print Mode ID
 
x(8)
 
 
PrintModeInsp
Print Mode (ID)
Print!Mode ID
X(8)
 
 
PrintTaskCl
Print Confirmed Tasks
Print!Cl Task
yes/no
 
 
PrintTaskCr
Print Created Tasks
Print!Cr Task
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
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
RcntPriInc
Recount Increment
Recount!Increment
->,>>>,>>9
 
 
RcntPriority
Recount Priority
Recount!Priority
->,>>>,>>9
 
 
RcntSystem
Recount System Code
Rcnt!Sys
x(2)
 
 
RcntTask
Recount Task
Recount!Task
x(8)
 
 
Site
Site
 
x(8)
 
 
SystemCode
System Code
Sys
x(2)
 
 
SystemFlavor
Flavor
Flv
x(1)
 
 
Task
Task
 
x(8)
 
 
Task132
132 Mode (Task)
Task!132
yes/no
 
 
TaskAcross
Task Printer - Number Across
Task!Across
>9
 
 
TaskDown
Task Printer - Lines of Each
Task!Down
>9
 
 
TaskPrinter
Task Printer
Task!Printer
X(8)
 
 
TaskUseExt
Use External
Ext
yes/no
 
 
TaskWidth
Task Printer - Width of Each
Task!Width
>>9
 
 
TrPriInc
Increment
 
->,>>>,>>9
 
 
TrPriority
Priority
 
->,>>>,>>9
 
 
TwoPhase
Two Phase
2Ph
yes/no
 
 
UseFrom
Confirmed at Source
Conf!Src
yes/no
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WLGM
yes
oid_WLGM
yes
no
 ∗
SiteWhseWLocGp
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
WLocGp
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
wlrd_det
WIP Lot Trace Routing Control Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wlrd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wlrd__chr01
 
 
X(16)
 
 
wlrd__chr02
 
 
X(16)
 
 
wlrd__chr03
 
 
X(16)
 
 
wlrd__chr04
 
 
X(16)
 
 
wlrd__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrd__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrd__dte01
 
 
99/99/99
 
 
wlrd__dte02
 
 
99/99/99
 
 
wlrd__int01
 
 
->,>>>,>>9
 
 
wlrd__int02
 
 
->,>>>,>>9
 
 
wlrd__log01
 
 
yes/no
 
 
wlrd__log02
 
 
yes/no
 
 
wlrd__qadc01
 
 
X(16)
 
 
wlrd__qadc02
 
 
X(16)
 
 
wlrd__qadc03
 
 
X(16)
 
 
wlrd__qadc04
 
 
X(16)
 
 
wlrd__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrd__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrd__qadi01
 
 
->,>>>,>>9
 
 
wlrd__qadi02
 
 
->,>>>,>>9
 
 
wlrd__qadl01
 
 
yes/no
 
 
wlrd__qadl02
 
 
yes/no
 
 
wlrd__qadt01
 
 
99/99/99
 
 
wlrd__qadt02
 
 
99/99/99
 
 
wlrd_domain
Domain
 
x(8)
 
 
wlrd_mod_date
Modified Date
Mod Date
99/99/99
 
 
wlrd_mod_userid
User ID
 
x(8)
 
 
wlrd_op
Operation
Op
>>>>9
 
 
wlrd_overissue
WIP Lot Overissue
WIP Lot!Overissue
yes/no
 
 
wlrd_routing
Routing Code
 
x(18)
 
 
wlrd_start
Start Date
Start
99/99/99
 
 
wlrd_user1
Ufld1
 
X(16)
 
 
wlrd_user2
Ufld2
 
X(16)
 
 
wlrd_wip_cmb_ok
Combine WIP Lots
Combine!WIP Lots
yes/no
 
 
wlrd_wip_split_ok
Split WIP Lots
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wlrd_det
yes
oid_wlrd_det
yes
no
wlrd_routing
yes
wlrd_domain
yes
no
 
 
 
wlrd_routing
yes
no
 
 
 
wlrd_start
yes
no
 
 
 
wlrd_op
yes
no
wlrm_mstr
WIP Lot Trace Routing Control Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wlrm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wlrm__chr01
 
 
X(16)
 
 
wlrm__chr02
 
 
X(16)
 
 
wlrm__chr03
 
 
X(16)
 
 
wlrm__chr04
 
 
X(16)
 
 
wlrm__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrm__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrm__dte01
 
 
99/99/99
 
 
wlrm__dte02
 
 
99/99/99
 
 
wlrm__int01
 
 
->,>>>,>>9
 
 
wlrm__int02
 
 
->,>>>,>>9
 
 
wlrm__log01
 
 
yes/no
 
 
wlrm__log02
 
 
yes/no
 
 
wlrm__qadc01
 
 
X(16)
 
 
wlrm__qadc02
 
 
X(16)
 
 
wlrm__qadc03
 
 
X(16)
 
 
wlrm__qadc04
 
 
X(16)
 
 
wlrm__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrm__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlrm__qadi01
 
 
->,>>>,>>9
 
 
wlrm__qadi02
 
 
->,>>>,>>9
 
 
wlrm__qadl01
 
 
yes/no
 
 
wlrm__qadl02
 
 
yes/no
 
 
wlrm__qadt01
 
 
99/99/99
 
 
wlrm__qadt02
 
 
99/99/99
 
 
wlrm_domain
Domain
 
x(8)
 
 
wlrm_end
End Date
End
99/99/99
 
 
wlrm_lt_startop
Lot Trace Start Op
Lot Trace!Start Op
>>>>9
 
 
wlrm_maxlotsize
Max Lot Size
 
>>>,>>>,>>9.9
10
 
wlrm_mod_date
Modified Date
Mod Date
99/99/99
 
 
wlrm_mod_userid
User ID
 
x(8)
 
 
wlrm_nrm_id
WIP Lot Number Sequence ID
 
x(8)
 
 
wlrm_overissue
WIP Lot Overissue
WIP Lot!Overissue
yes/no
 
 
wlrm_routing
Routing Code
 
x(18)
 
 
wlrm_ser_startop
Serialized WIP Start Op
Serialized WIP!Start Op
>>>>9
 
 
wlrm_start
Start Date
Start
99/99/99
 
 
wlrm_trc_parent
Trace Parents
Trace!Parents
yes/no
 
 
wlrm_user1
Ufld1
 
X(16)
 
 
wlrm_user2
Ufld2
 
X(16)
 
 
wlrm_wip_cmb_ok
Combine WIP Lots
Combine!WIP Lots
yes/no
 
 
wlrm_wip_split_ok
Split WIP Lots
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wlrm_mstr
yes
oid_wlrm_mstr
yes
no
wlrm_routing
yes
wlrm_domain
yes
no
 
 
 
wlrm_routing
yes
no
 
 
 
wlrm_start
yes
no
wlt_mstr
WIP Lot Trace Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wlt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wlt__chr01
 
 
X(16)
 
 
wlt__chr02
 
 
X(16)
 
 
wlt__chr03
 
 
X(16)
 
 
wlt__chr04
 
 
X(16)
 
 
wlt__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlt__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlt__dte01
 
 
99/99/99
 
 
wlt__dte02
 
 
99/99/99
 
 
wlt__int01
 
 
->,>>>,>>9
 
 
wlt__int02
 
 
->,>>>,>>9
 
 
wlt__log01
 
 
yes/no
 
 
wlt__log02
 
 
yes/no
 
 
wlt__qadc01
 
 
X(16)
 
 
wlt__qadc02
 
 
X(16)
 
 
wlt__qadc03
 
 
X(16)
 
 
wlt__qadc04
 
 
X(16)
 
 
wlt__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlt__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wlt__qadi01
 
 
->,>>>,>>9
 
 
wlt__qadi02
 
 
->,>>>,>>9
 
 
wlt__qadl01
 
 
yes/no
 
 
wlt__qadl02
 
 
yes/no
 
 
wlt__qadt01
 
 
99/99/99
 
 
wlt__qadt02
 
 
99/99/99
 
 
wlt_cr_date
Date Created
 
99/99/99
 
 
wlt_cr_time
Time Created
 
>>>>>>9
 
 
wlt_domain
Domain
 
x(8)
 
 
wlt_lotser
Lot/Serial
 
x(18)
 
 
wlt_mod_date
Modified Date
Mod Date
99/99/99
 
 
wlt_mod_time
Time Modified
 
>>>>>>>9
 
 
wlt_mod_userid
User ID
 
x(8)
 
 
wlt_mtl_type
Material Type
Type
x(12)
 
 
wlt_part
Item Number
 
x(18)
 
 
wlt_prcons_ind
Produced/Consumed
Prod/Cons
Prod/Cons
 
 
wlt_prodby_id
Produced By ID
Prod ID
x(8)
 
 
wlt_prodby_op
Produced By Op
Prod Op
>>>>9
 
 
wlt_qty
Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
wlt_ref
Reference
Ref
x(8)
 
 
wlt_tr_type
Trans Type
 
x(8)
 
 
wlt_trnbr
Trans
 
>>>>>>>>>9
 
 
wlt_user1
Ufld1
 
X(16)
 
 
wlt_user2
Ufld2
 
X(16)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wlt_mstr
yes
oid_wlt_mstr
yes
no
 
wlt_prcons
no
wlt_domain
yes
no
 
 
 
wlt_prcons_ind
yes
no
 
 
 
wlt_mtl_type
yes
no
 
 
 
wlt_prodby_id
yes
no
 
 
 
wlt_prodby_op
yes
no
 
 
 
wlt_part
yes
no
 
 
 
wlt_lotser
yes
no
 
 
 
wlt_ref
yes
no
 
 
 
wlt_tr_type
yes
no
 
 
 
wlt_trnbr
yes
no
wlt_tr_type
yes
wlt_domain
yes
no
 
 
 
wlt_tr_type
yes
no
 
 
 
wlt_trnbr
yes
no
 
 
 
wlt_prcons_ind
yes
no
 
 
 
wlt_mtl_type
yes
no
 
 
 
wlt_prodby_id
yes
no
 
 
 
wlt_prodby_op
yes
no
 
 
 
wlt_part
yes
no
 
 
 
wlt_lotser
yes
no
 
 
 
wlt_ref
yes
no
wl_mstr
WIP Lot Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wl__chr01
 
 
X(16)
 
 
wl__chr02
 
 
X(16)
 
 
wl__chr03
 
 
X(16)
 
 
wl__chr04
 
 
X(16)
 
 
wl__dec01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wl__dec02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wl__dte01
 
 
99/99/99
 
 
wl__dte02
 
 
99/99/99
 
 
wl__int01
 
 
->,>>>,>>9
 
 
wl__int02
 
 
->,>>>,>>9
 
 
wl__log01
 
 
yes/no
 
 
wl__log02
 
 
yes/no
 
 
wl__qadc01
 
 
X(16)
 
 
wl__qadc02
 
 
X(16)
 
 
wl__qadc03
 
 
X(16)
 
 
wl__qadc04
 
 
X(16)
 
 
wl__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wl__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
wl__qadi01
 
 
->,>>>,>>9
 
 
wl__qadi02
 
 
->,>>>,>>9
 
 
wl__qadl01
 
 
yes/no
 
 
wl__qadl02
 
 
yes/no
 
 
wl__qadt01
 
 
99/99/99
 
 
wl__qadt02
 
 
99/99/99
 
 
wl_cert_status
Cert Status
 
x(8)
 
 
wl_cr_date
Date Created
 
99/99/99
 
 
wl_cr_time
Time Created
 
>>>>>>9
 
 
wl_domain
Domain
 
x(8)
 
 
wl_lotser
Lot/Serial
 
x(18)
 
 
wl_mod_date
Modified Date
Mod Date
99/99/99
 
 
wl_mod_time
Time Modified
 
>>>>>>>9
 
 
wl_mod_userid
User ID
 
x(8)
 
 
wl_prodby_id
Produced By ID
Prod ID
x(8)
 
 
wl_prodby_op
Produced By Op
Prod Op
>>>>9
 
 
wl_qty_cumadj
Cum Adjusted
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumcons
Cum Consumed
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumprod
Cum Produced
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumrjct
Cum Rejected
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumrwrk
Cum Reworked
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumscrap
Cum Scrapped
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumtrin
Cum Trans In
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_qty_cumtrout
Cum Trans Out
 
->,>>>,>>9.9<<<<<<<<
10
 
wl_user1
Ufld1
 
X(16)
 
 
wl_user2
Ufld2
 
X(16)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wl_mstr
yes
oid_wl_mstr
yes
no
 
wl_lotser
no
wl_domain
yes
no
 
 
 
wl_lotser
yes
no
 
 
 
wl_prodby_id
yes
no
 
 
 
wl_prodby_op
yes
no
wl_prodby_id
yes
wl_domain
yes
no
 
 
 
wl_prodby_id
yes
no
 
 
 
wl_prodby_op
yes
no
 
 
 
wl_lotser
yes
no
woc_ctrl
Work Order Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_woc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
woc__qadi01
 
 
>>>>>>>9
 
 
woc__qadi02
 
 
->>>>>>>9
 
 
woc__qadl01
 
 
yes/no
 
 
woc__qadl02
 
 
yes/no
 
 
woc_auto_nbr
Auto W/O Numbers
 
yes/no
 
 
woc_bdn_up
Update Current Burden Cost
 
yes/no
 
 
woc_domain
Domain
 
x(8)
 
 
woc_gl_bdn
Create GL for Burden Variance
 
yes/no
 
 
woc_gl_lbr
Create GL for Labor Variance
 
yes/no
 
 
woc_lbr_up
Update Current Labor Cost
 
yes/no
 
 
woc_move
Move First Operation
 
yes/no
 
 
woc_nbr
Next W/O Nbr
Next WO
>>>>>>>9
 
 
woc_nbr_pre
WO Prefix
Pre
x(3)
 
 
woc_paper_lt
Paperwork LT
Paper LT
>>9
 
 
woc_rcmmts
Routing Comments
 
yes/no
 
 
woc_sched
Oper Sched Method (Back/Fwd)
Sched
x(1)
 
 
woc_time_ind
Time Indicator
Time
x(1)
 
 
woc_user1
Ufld1
 
x(8)
 
 
woc_user2
Ufld2
 
x(8)
 
 
woc_var
Post variances at SFC
 
yes/no
 
 
woc_wcmmts
Work Order Comments
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_woc_ctrl
yes
oid_woc_ctrl
yes
no
woc_index1
yes
woc_domain
yes
no
wod_det
Work Order Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wod_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wod__chr01
 
 
x(8)
 
 
wod__chr02
 
 
x(8)
 
 
wod__chr03
 
 
x(8)
 
 
wod__chr04
 
 
x(8)
 
 
wod__chr05
 
 
x(8)
 
 
wod__dec01
 
 
>>>,>>>,>>9.99
10
 
wod__dec02
 
 
>>>,>>>,>>9.99
10
 
wod__dte01
 
 
99/99/99
 
 
wod__dte02
 
 
99/99/99
 
 
wod__log01
 
 
yes/no
 
 
wod__qadc01
QAD Character Field 1
 
X(8)
 
 
wod__qadc02
QAD Character Field 2
 
X(8)
 
 
wod__qadc03
QAD Character Field 3
 
X(8)
 
 
wod__qade01
QAD Decimal Field 1
 
->>>,>>9.99<
10
 
wod__qade02
QAD Decimal Field 2
 
->>>,>>9.99<
10
 
wod__qadl01
QAD Logical Field 1
 
yes/no
 
 
wod__qadl02
QAD L ogical Field 2
 
yes/no
 
 
wod__qadt01
QAD Date Field 1
 
99/99/99
 
 
wod__qadt02
QAD Date Field 2
 
99/99/99
 
 
wod_bo_chg
Qty B/O
 
->,>>>,>>9.9<<<<<<<<
10
 
wod_bom_amt
Frozen BOM Cost
BOM Cost
->>>,>>9.999
10
 
wod_bom_qty
Frozen BOM Qty
BOM Qty
->,>>>,>>9.9<<<<<<<<
10
 
wod_ca_int_type
Work Code
 
x(8)
0
 
wod_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
wod_covered_amt
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
wod_covered_post
 
 
>>>>,>>>,>>9.99<<<
10
 
wod_critical
Critical
 
yes/no
 
 
wod_deliver
Deliver To
 
x(8)
 
 
wod_doc_id
Document ID
 
x(24)
 
 
wod_domain
Domain
 
x(8)
 
 
wod_eng_code
Engineer
 
x(8)
 
 
wod_exg_price
Exchange Price
 
>>>>,>>>,>>9.99<<<
10
 
wod_fcg_code
Charge Code
Charge
x(8)
 
 
wod_fcg_index
 
 
->,>>>,>>9
 
 
wod_fis_column
 
 
>>9
 
 
wod_fis_sort
 
 
x(18)
 
 
wod_from_loc
Location
 
x(8)
 
 
wod_from_site
Site
 
x(8)
 
 
wod_fsc_code
Service Category
Svc Cat
x(8)
 
 
wod_fsm_type
FSM Type
 
x(8)
 
 
wod_isb_ref
Installed Base Reference
Ref
>>>>>>>9
 
 
wod_iss_date
Issue Date
Iss Date
99/99/99
 
 
wod_itm_line
 
 
>>>>9
 
 
wod_line_price
Line Total
 
>>>>,>>>,>>9.99<<<
10
 
wod_list_pr
List Price
 
>>>>,>>>,>>9.99<<<
10
 
wod_loc
Location
 
x(8)
 
 
wod_lot
ID
 
x(8)
 
 
wod_mtl_totx
Material
 
->>>,>>>,>>9.99<<<
10
 
wod_mvrte_accr
Mtl Rate Accrued
Accrued
->>>>,>>9.99
10
 
wod_mvrte_post
Mtl Rate Posted
Posted
->>>>,>>9.99
10
 
wod_mvrte_rval
Mtl Rate Revalued
Revalued
->>>>,>>9.99
10
 
wod_mvuse_accr
Mtl Use Accrued
Accrued
->>>>,>>9.99
10
 
wod_mvuse_post
Mtl Use Posted
Posted
->>>>,>>9.99
10
 
wod_mvuse_rval
Mtl Use Revalue
Revalued
->>>>,>>9.99
10
 
wod_nbr
Work Order
 
x(18)
 
 
wod_op
Operation
Op
>>>>>>
 
 
wod_part
Item Number
 
x(18)
 
 
wod_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
wod_prod_line
Product Line
Line
x(4)
 
 
wod_project
Project
 
x(8)
 
 
wod_qty_all
Qty Allocated
 
->,>>>,>>9.9<<<<<<<<
10
 
wod_qty_chg
Qty to Issue
 
->,>>>,>>9.9<<<<<<<<
10
 
wod_qty_iss
Qty Issued
 
->,>>>,>>9.9<<<<<<<<
10
 
wod_qty_pick
Qty Picked
 
->,>>>,>>9.9<<<<<<<<
10
 
wod_qty_posted
 
 
->,>>>,>>9.9<
10
 
wod_qty_req
Qty Required
 
->,>>>,>>9.9<<<<<<<<
10
 
wod_qty_ret
Qty Returned
Qty Ret
->,>>9.9
10
 
wod_ref
Ref
Reference
x(8)
 
 
wod_ret_iss
 
 
->,>>9.9
10
 
wod_ret_loc
Return Location
 
x(8)
 
 
wod_ret_ref
Inventory Reference
Inv Ref
X(8)
 
 
wod_ret_serial
Return Lot/Serial
 
x(18)
 
 
wod_ret_site
Return Site
 
x(8)
 
 
wod_seo_load
Loaded from MO
 
yes/no
 
 
wod_serial
Lot/Serial
 
x(18)
 
 
wod_site
Site
 
x(8)
 
 
wod_sod_line
Line
Ln
>>9
 
 
wod_sod_nbr
Sales Order
Order
x(8)
 
 
wod_status
Status
 
x(8)
 
 
wod_std_cost
Unit Cost
 
->>>,>>9.999
10
 
wod_sv_code
Service Type Used
 
x(8)
 
 
wod_tot_std
Std Cost
 
->>>,>>9.999
10
 
wod_user1
Ufld1
 
x(8)
 
 
wod_user2
Ufld2
 
x(8)
 
 
wod_yield_pct
Yield%
 
>>9.99%
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_wod_det
yes
oid_wod_det
yes
no
wod_det
yes
wod_domain
yes
no
 
 
 
wod_lot
yes
no
 
 
 
wod_part
yes
no
 
 
 
wod_op
yes
no
 
wod_iss_part
no
wod_domain
yes
no
 
 
 
wod_iss_date
yes
no
 
 
 
wod_part
yes
no
 
wod_nbrpart
no
wod_domain
yes
no
 
 
 
wod_nbr
yes
no
 
 
 
wod_lot
yes
no
 
 
 
wod_part
yes
no
 
wod_op
yes
wod_domain
yes
no
 
 
 
wod_lot
yes
no
 
 
 
wod_op
yes
no
 
 
 
wod_part
yes
no
 
wod_part
no
wod_domain
yes
no
 
 
 
wod_part
yes
no
wopd_det
Periodwise (Cost calculation) components details
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_wod_det
Identifier WO Detail
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_wopd_det
Identifier WO Detail (WIP) Periodwise(Cost calculation)
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_wopm_det
Identifier WO Master (WIP) Periodwise(Cost calculation)
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
wopd__qadc01
 
 
x(24)
 
 
wopd__qadc02
 
 
x(24)
 
 
wopd_mod_date
Modified Date
Mod Date
99/99/99
 
 
wopd_mod_userid
User ID
 
x(8)
 
 
wopd_qty_iss
WO Period Qty Issued
 
->,>>>,>>9.9<<<<<<<<
10
 
wopd_qty_iss_tot
WO Total Qty Issued
 
->,>>>,>>9.9<<<<<<<<
10
 
wopd_user1
User Field Character 1
 
x(24)
 
 
wopd_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
oid_wopd_det
yes
oid_wopd_det
yes
no
 
wopd_wopm_wod
yes
oid_wopm_det
yes
no
 
 
 
oid_wod_det
yes
no