QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
vef_ctrl
Supplier Performance Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vef_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vef__qadc01
QAD Field
 
X(8)
0
 
vef__qadc02
QAD Field
 
X(8)
0
 
vef__qadc03
QAD Field
 
X(8)
0
 
vef__qadc04
QAD Field
 
X(8)
0
 
vef__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vef__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vef__qadi01
 
 
>>>>>>9
 
 
vef__qadi02
 
 
>>>>>>9
 
 
vef__qadi03
 
 
->>>>>>>9
 
 
vef__qadl01
 
 
yes/no
 
 
vef__qadl02
 
 
yes/no
 
 
vef__qadt01
 
 
99/99/99
 
 
vef__qadt02
 
 
99/99/99
 
 
vef_asn_data
ASN Information
 
X(8)
 
 
vef_asn_leadtime
Maximum ASN Lead-Time
 
99:99
 
 
vef_days_early
Acceptable Days Early
 
>>9
 
 
vef_days_late
Acceptable Days Late
 
>>9
 
 
vef_do_only_flag
Include DO Orders Only
 
yes/no
 
 
vef_do_receipts
DO Receipts
 
X(8)
 
 
vef_domain
Domain
 
x(8)
 
 
vef_dup_asn
Duplicate ASN
 
X(8)
 
 
vef_early_rcpt
Early Receipt
 
X(8)
 
 
vef_enable_inv_xfer
Enable Inv Transfer
 
yes/no
 
 
vef_enable_po_rtn
Enable PO Return
 
yes/no
 
 
vef_fifth_level_max
Maximum Value
 
>>>
 
 
vef_fifth_level_title
Fifth Interval Title
 
x(12)
 
 
vef_first_level_max
Maximum Value
 
>>>
 
 
vef_first_level_title
First Interval Title
 
x(12)
 
 
vef_fourth_level_max
Maximum Value
 
>>>
 
 
vef_fourth_level_title
Fourth Interval Title
 
x(12)
 
 
vef_late_asn
Late ASN
 
X(8)
 
 
vef_late_rcpt
Late Receipt
 
X(8)
 
 
vef_matl_quality
Material Quality
 
X(8)
 
 
vef_miss_ship_as_of_date
Missed Shipment As-of
 
99/99/99
 
 
vef_miss_ship_run_date
Last Missed Shipment Run
 
99/99/99
 
 
vef_missed_ship
Missed Shipment
 
X(8)
 
 
vef_mod_date
Modified Date
Mod Date
99/99/99
 
 
vef_mod_userid
User ID
 
x(8)
 
 
vef_over_ship
Over Shipment
 
X(8)
 
 
vef_overship_pct
Acceptable Over Shipment
 
>>9.99
10
 
vef_overship_pct_cost
Acceptable Over Shipment
 
>>9.99
10
 
vef_overship_qty
Acceptable Over Shipment
 
>>,>>9
 
 
vef_overship_qty_cost
Acceptable Over Shipment
 
>>>>,>>>,>>9.99<<<<<<<<
10
 
vef_po_only_flag
Include PO Orders Only
 
yes/no
 
 
vef_po_receipts
PO Receipts
 
X(8)
 
 
vef_points
Default Points
 
>>>>,>>9.99
10
 
vef_pp_counter
Parts-Per Counter
 
Events/Quantity
 
 
vef_pp_factor
Parts-Per Factor
 
>,>>>,>>>,>>9
 
 
vef_rts_receipts
RTS Receipts
 
X(8)
 
 
vef_same_day_receipts
Net Same Day Receipts
 
yes/no
 
 
vef_second_level_max
Maximum Value
 
>>>
 
 
vef_second_level_title
Second Interval Title
 
x(12)
 
 
vef_third_level_max
Maximum Value
 
>>>
 
 
vef_third_level_title
Third Interval Title
 
x(12)
 
 
vef_under_ship
Under Shipment
 
X(8)
 
 
vef_undership_pct
Acceptable Under Shipment
 
>>9.99
10
 
vef_undership_qty
Acceptable Under Shipment
 
>>,>>9
 
 
vef_use_shippct
Use Shipment Percent
 
yes/no
 
 
vef_use_shippct_cost
Use Shipment Percent Cost
 
yes/no
 
 
vef_use_shipqty
Use Shipment Quantity
 
yes/no
 
 
vef_use_shipqty_cost
Use Shipment Quantity Cost
 
yes/no
 
 
vef_user1
Ufld1
 
x(8)
 
 
vef_user2
Ufld2
 
x(8)
 
 
vef_user3
 
 
x(8)
 
 
vef_user4
 
 
x(8)
 
 
vef_using_sup_perf
Use Supplier Performance
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vef_ctrl
yes
oid_vef_ctrl
yes
no
vef_index1
yes
vef_domain
yes
no
VendPartM
Warehousing Supplier/Item Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
Addr
Address
 
x(8)
 
 
ByRef
Ref
 
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Destructive
Destructive
Destr
yes/no
 
 
Domain
Domain
 
x(8)
 
 
InspFreqDays
Insp Frequency (Days)
Insp Freq (D)
>>9
 
 
InspFrequency
Insp Frequency
Insp Freq
>>>>>>9
 
 
InspReq
Inspection Required
Insp Req
yes/no
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_VendPartM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadC05
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
 
 
QadI04
QAD Field
 
->,>>>,>>9
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
Quantity
Quantity
 
->>>,>>9.9<<<<<<
10
 
RandomInspPct
Random Inspection %
 
->>9.99
10
 
SamplePct
Sample %
Sample %
>>9
 
 
SampleQty
Sample Quantity
Sample Qty
->,>>>,>>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
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
AddrPart
yes
Domain
yes
no
 
 
 
Addr
yes
no
 
 
 
Part
yes
no
 
oid_VendPartM
yes
oid_VendPartM
yes
no
 
PartAddr
no
Domain
yes
no
 
 
 
Part
yes
no
 
 
 
Addr
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
vepd_det
Supplier Performance Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vepd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vepd__qadc01
QAD Field
 
X(8)
0
 
vepd__qadc02
QAD Field
 
X(8)
0
 
vepd__qadc03
QAD Field
 
X(8)
0
 
vepd__qadc04
QAD Field
 
X(8)
0
 
vepd__qadd01
 
 
->>,>>>,>>9.9<<<<<<<<<
10
 
vepd__qadd02
 
 
->>,>>>,>>9.9<<<<<<<<<
10
 
vepd__qadi01
 
 
>>>>>>9
 
 
vepd__qadi02
 
 
>>>>>>9
 
 
vepd__qadl01
 
 
yes/no
 
 
vepd__qadl02
 
 
yes/no
 
 
vepd__qadt01
 
 
99/99/99
 
 
vepd__qadt02
 
 
99/99/99
 
 
vepd_category
Category
 
x(8)
 
 
vepd_cmtindx
Comments
 
>>>>>>>9
 
 
vepd_doc_nbr
Doc Nbr
Doc
x(16)
 
 
vepd_domain
Domain
 
x(8)
 
 
vepd_event
Event
 
x(8)
 
 
vepd_event_qty
Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
vepd_mod_date
Modified Date
Mod Date
99/99/99
 
 
vepd_mod_userid
User ID
 
x(8)
 
 
vepd_reason_code
Reason
 
x(8)
 
 
vepd_seq_nbr
Sequence
Seq
>>>>>>>>
 
 
vepd_site
Site
 
x(8)
 
 
vepd_temp_missed_flag
Missed
 
yes/no
 
 
vepd_tran_date
Transaction Date
Tran Date
99/99/99
 
 
vepd_tran_id
Transaction ID
Tran ID
>>>>>>>>
 
 
vepd_user1
Ufld1
 
x(8)
 
 
vepd_user2
Ufld2
 
x(8)
 
 
vepd_user3
 
 
x(8)
 
 
vepd_user4
 
 
x(8)
 
 
vepd_vendor
Supplier
 
x(8)
 
 
vepd_vendor_source
Supplier Source
Source
x(3)
 
 
vepd_vep_tran_date
Receipt Transaction Date
 
99/99/99
 
 
vepd_vep_tran_id
Receipt Transaction ID
 
>>>>>>>>
 
 
vepd_weight_code
Weight Code
Weight
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
missed_event_order
no
vepd_domain
yes
no
 
 
 
vepd_temp_missed_flag
yes
no
 
 
 
vepd_vendor
yes
no
 
 
 
vepd_vendor_source
yes
no
 
 
 
vepd_site
yes
no
 
oid_vepd_det
yes
oid_vepd_det
yes
no
transaction_order
yes
vepd_domain
yes
no
 
 
 
vepd_tran_id
yes
no
 
 
 
vepd_tran_date
yes
no
 
 
 
vepd_vendor
yes
no
 
 
 
vepd_vendor_source
yes
no
 
 
 
vepd_site
yes
no
 
vendor_event_order
no
vepd_domain
yes
no
 
 
 
vepd_vendor
yes
no
 
 
 
vepd_vendor_source
yes
no
 
 
 
vepd_category
yes
no
 
 
 
vepd_event
yes
no
 
 
 
vepd_site
yes
no
 
vepd_vendor_order
yes
vepd_domain
yes
no
 
 
 
vepd_vendor
yes
no
 
 
 
vepd_vendor_source
yes
no
 
 
 
vepd_vep_tran_date
yes
no
 
 
 
vepd_vep_tran_id
yes
no
 
 
 
vepd_category
yes
no
 
 
 
vepd_seq_nbr
yes
no
 
 
 
vepd_site
yes
no
vep_mstr
Supplier Performance Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vep_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vep__qadc01
QAD Field
 
X(8)
0
 
vep__qadc02
QAD Field
 
X(8)
0
 
vep__qadc03
QAD Field
 
X(8)
0
 
vep__qadc04
QAD Field
 
X(8)
0
 
vep__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vep__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vep__qadi01
 
 
>>>>>>9
 
 
vep__qadi02
 
 
>>>>>>9
 
 
vep__qadl01
 
 
yes/no
 
 
vep__qadl02
 
 
yes/no
 
 
vep__qadt01
 
 
99/99/99
 
 
vep__qadt02
 
 
99/99/99
 
 
vep_abs_id
Shipper ID
Shipper
x(20)
 
 
vep_acct
Pur Acct
 
x(8)
 
 
vep_asn_arr_date
ASN Arrival Date
ASN!Arrival
99/99/99
 
 
vep_asn_arr_time
ASN Arrival Time
ASN!Arrival
>>>>>>>9
 
 
vep_asn_create_date
ASN Create Date
ASN!Create
99/99/99
 
 
vep_asn_create_time
ASN Create Time
ASN!Create
>>>>>>>9
 
 
vep_asn_ship_date
ASN Ship Date
ASN!Ship
99/99/99
 
 
vep_asn_ship_qty
ASN Ship Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
vep_asn_ship_time
ASN Ship Time
ASN!Ship
>>>>>>>9
 
 
vep_buyer
Buyer
 
x(8)
 
 
vep_cc
Cost Ctr
CC
x(4)
 
 
vep_comm_code
Commodity Code
Commodity
x(20)
 
 
vep_db
DB Number
DB
x(16)
 
 
vep_disc_pct
Disc%
 
->9.99%
10
 
vep_domain
Domain
 
x(8)
 
 
vep_fsm_type
FSM Type
 
x(1)
 
 
vep_line
Line
Ln
>>>
 
 
vep_loc
Loc
 
x(8)
 
 
vep_lotser
Lot/Serial
L/S
x(18)
 
 
vep_mod_date
Modified Date
Mod Date
99/99/99
 
 
vep_mod_userid
User ID
 
x(8)
 
 
vep_nbr
Order Nbr
Order
x(8)
 
 
vep_open_qty
Open Qty
Qty!Open
->,>>>,>>9.9<<<<<<<<
10
 
vep_order_source
Order Source
Source
x(3)
 
 
vep_part
Item Number
Item
x(18)
 
 
vep_per_date
Perform Date
Perform
99/99/99
 
 
vep_pod_sched
Scheduled
Sched
yes/no
 
 
vep_pur_cost
Unit Cost
Unit!Cost
->>>,>>>,>>9.99
10
 
vep_qty_ord
Qty Ordered
Qty!Ordered
->,>>>,>>9.9<<<<<<<<
10
 
vep_rcp_date
Receipt Date
Receipt
99/99/99
 
 
vep_rcp_time
Receipt Time
Receipt
>>>>>>>9
 
 
vep_rcp_type
Receipt Type
R
x(1)
 
 
vep_rcvd_qty
Receipt Qty
Qty!Received
->,>>>,>>9.9<<<<<<<<
10
 
vep_receiver
Receiver
 
x(8)
 
 
vep_ref
Ref
 
x(8)
 
 
vep_req_nbr
Requisition
Req
x(8)
 
 
vep_site
Site
 
x(8)
 
 
vep_sub
Pur Sub-Acct
Sub-Acct
x(8)
 
 
vep_sub_type
Subcontract Type
Sub Type
x(12)
 
 
vep_temp_missed_flag
Missed
 
yes/no
 
 
vep_tran_date
Transaction Date
Tran Date
99/99/99
 
 
vep_tran_id
Transaction ID
Tran ID
>>>>>>>>
 
 
vep_type
Type
 
x(1)
 
 
vep_um
UM
 
x(2)
 
 
vep_user1
Ufld1
 
x(8)
 
 
vep_user2
Ufld2
 
x(8)
 
 
vep_user3
 
 
x(8)
 
 
vep_user4
 
 
x(8)
 
 
vep_vendor
Supplier
 
x(8)
 
 
vep_vendor_source
Supplier Source
Source
x(3)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
missed_event_order
no
vep_domain
yes
no
 
 
 
vep_temp_missed_flag
yes
no
 
 
 
vep_vendor
yes
no
 
 
 
vep_vendor_source
yes
no
 
 
 
vep_site
yes
no
 
oid_vep_mstr
yes
oid_vep_mstr
yes
no
 
vendor_date_order
no
vep_domain
yes
no
 
 
 
vep_vendor
yes
no
 
 
 
vep_vendor_source
yes
no
 
 
 
vep_site
yes
no
 
 
 
vep_nbr
yes
no
 
 
 
vep_line
yes
no
 
 
 
vep_tran_date
yes
no
 
 
 
vep_receiver
yes
no
 
 
 
vep_abs_id
yes
no
 
 
 
vep_part
yes
no
vendor_site_order
yes
vep_domain
yes
no
 
 
 
vep_vendor
yes
no
 
 
 
vep_vendor_source
yes
no
 
 
 
vep_tran_date
yes
no
 
 
 
vep_tran_id
yes
no
 
 
 
vep_site
yes
no
 
vep_vendor_nbr_order
no
vep_domain
yes
no
 
 
 
vep_vendor
yes
no
 
 
 
vep_vendor_source
yes
no
 
 
 
vep_site
yes
no
 
 
 
vep_nbr
yes
no
 
 
 
vep_receiver
yes
no
 
 
 
vep_line
yes
no
 
 
 
vep_abs_id
yes
no
 
 
 
vep_part
yes
no
 
vep_vendor_part
no
vep_domain
yes
no
 
 
 
vep_vendor
yes
no
 
 
 
vep_vendor_source
yes
no
 
 
 
vep_site
yes
no
 
 
 
vep_part
yes
no
 
 
 
vep_type
yes
no
 
 
 
vep_sub_type
yes
no
 
 
 
vep_tran_date
yes
no
VerbH
Warehousing Verbosity History
 
 
Field Name
Label
Col-Label
Format
Dec
 
Comments
Comments
 
x(64)
 
 
CreateDate
Create Date
 
99/99/99
 
 
createETime
Elapsed Time
Elap!Time
>>,>>9.99
2
 
CreateProgName
Created ProgName
 
x(10)
 
 
CreateTime
Created Time
 
->,>>>,>>9
 
 
CreateUserID
Created UserID
 
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_VerbH
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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)
 
 
SLocGp
Store Loc Group
SLocGrp
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
 
 
VerbID
ID
 
X(8)
 
 
VerbLevel
Verbosity Level
Verb!Level
>>9
 
 
VerbType
Type
 
X(2)
 
 
Whse
Warehouse
Whse
x(8)
 
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
DateTime
no
Domain
yes
no
 
 
 
CreateDate
yes
no
 
 
 
CreateTime
yes
no
 
Location
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Loc
yes
no
 
oid_VerbH
yes
oid_VerbH
yes
no
 
SLG
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
SLocGp
yes
no
 
UserIdx
no
Domain
yes
no
 
 
 
CreateUserID
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
WLG
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
WLocGp
yes
no
verd_det
Supplier Performance Registration Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_verd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
verd__qadc01
QAD Field
 
X(8)
0
 
verd__qadc02
QAD Field
 
X(8)
0
 
verd__qadc03
QAD Field
 
X(8)
0
 
verd__qadc04
QAD Field
 
X(8)
0
 
verd__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
verd__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
verd__qadi01
 
 
>>>>>>9
 
 
verd__qadi02
 
 
>>>>>>9
 
 
verd__qadl01
 
 
yes/no
 
 
verd__qadl02
 
 
yes/no
 
 
verd__qadt01
 
 
99/99/99
 
 
verd__qadt02
 
 
99/99/99
 
 
verd_active_flag
Use Category
 
yes/no
 
 
verd_category
Category
 
x(8)
 
 
verd_domain
Domain
 
x(8)
 
 
verd_mod_date
Modified Date
Mod Date
99/99/99
 
 
verd_mod_userid
User ID
 
x(8)
 
 
verd_site
Site
 
x(8)
 
 
verd_user1
Ufld1
 
x(8)
 
 
verd_user2
Ufld2
 
x(8)
 
 
verd_user3
 
 
x(8)
 
 
verd_user4
 
 
x(8)
 
 
verd_vendor
Supplier
 
x(8)
 
 
verd_vendor_source
Supplier Source
 
x(3)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_verd_det
yes
oid_verd_det
yes
no
verd_vendor
yes
verd_domain
yes
no
 
 
 
verd_vendor
yes
no
 
 
 
verd_vendor_source
yes
no
 
 
 
verd_site
yes
no
 
 
 
verd_category
yes
no
VerifyStatusTrans
Verify Status Transition
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
VerifyStatusTrans_ID
Record ID
 
-99999999999
 
 
VerifyStatusTransFrStatus
From Status
 
x(40)
 
 
VerifyStatusTransToStatus
To Status
 
x(40)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Company
no
Company_ID
yes
no
 ∗
Prim
yes
VerifyStatusTrans_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
VerifyStatusTransFrStatus
yes
no
 
 
 
VerifyStatusTransToStatus
yes
no
ver_mstr
Supplier Performance Registration Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ver_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ver__qadc01
QAD Field
 
X(8)
0
 
ver__qadc02
QAD Field
 
X(8)
0
 
ver__qadc03
QAD Field
 
X(8)
0
 
ver__qadc04
QAD Field
 
X(8)
0
 
ver__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
ver__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
ver__qadi01
 
 
>>>>>>9
 
 
ver__qadi02
 
 
>>>>>>9
 
 
ver__qadl01
 
 
yes/no
 
 
ver__qadl02
 
 
yes/no
 
 
ver__qadt01
 
 
99/99/99
 
 
ver__qadt02
 
 
99/99/99
 
 
ver_active_flag
Use Supplier Performance
 
yes/no
 
 
ver_asn_leadtime
Maximum ASN Lead-Time
 
99:99
 
 
ver_comm_code
Commodity Code
 
x(20)
 
 
ver_contact
Contact
 
X(24)
 
 
ver_days_early
Acceptable Days Early
 
>>9
 
 
ver_days_late
Acceptable Days Late
 
>>9
 
 
ver_domain
Domain
 
x(8)
 
 
ver_email_address
E-mail Address
 
X(60)
 
 
ver_end
End Effective
 
99/99/99
 
 
ver_mod_date
Modified Date
Mod Date
99/99/99
 
 
ver_mod_userid
User ID
 
x(8)
 
 
ver_overship_pct
Acceptable Over Shipment
 
>>9.99
10
 
ver_overship_pct_cost
Acceptable Over Shipment
 
>>9.99
10
 
ver_overship_qty
Acceptable Over Shipment
 
>>,>>9
 
 
ver_overship_qty_cost
Acceptable Over Shipment
 
>>>>,>>>,>>9.99<<<<<<<<
10
 
ver_part
Item Number
 
x(18)
 
 
ver_site
Site
 
x(8)
 
 
ver_start
Start Effective
 
99/99/99
 
 
ver_undership_pct
Acceptable Under Shipment
 
>>9.99
10
 
ver_undership_qty
Acceptable Under Shipment
 
>>,>>9
 
 
ver_use_shippct
Use Shipment Percent
 
yes/no
 
 
ver_use_shippct_cost
Use Shipment Percent Cost
 
yes/no
 
 
ver_use_shipqty
Use Shipment Quantity
 
yes/no
 
 
ver_use_shipqty_cost
Use Shipment Quantity Cost
 
yes/no
 
 
ver_user1
Ufld1
 
x(8)
 
 
ver_user2
Ufld2
 
x(8)
 
 
ver_user3
 
 
x(8)
 
 
ver_user4
 
 
x(8)
 
 
ver_vendor
Supplier
 
x(8)
 
 
ver_vendor_source
Supplier Source
 
x(3)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ver_mstr
yes
oid_ver_mstr
yes
no
 
ver_comm_code
no
ver_domain
yes
no
 
 
 
ver_comm_code
yes
no
 
 
 
ver_vendor
yes
no
 
 
 
ver_vendor_source
yes
no
 
 
 
ver_site
yes
no
 
 
 
ver_part
yes
no
 
ver_part
no
ver_domain
yes
no
 
 
 
ver_part
yes
no
 
 
 
ver_vendor
yes
no
 
 
 
ver_vendor_source
yes
no
 
 
 
ver_site
yes
no
 
 
 
ver_comm_code
yes
no
 
ver_site
no
ver_domain
yes
no
 
 
 
ver_site
yes
no
 
 
 
ver_part
yes
no
 
 
 
ver_comm_code
yes
no
ver_vendor
yes
ver_domain
yes
no
 
 
 
ver_vendor
yes
no
 
 
 
ver_vendor_source
yes
no
 
 
 
ver_site
yes
no
 
 
 
ver_part
yes
no
 
 
 
ver_comm_code
yes
no
vesd_det
Supplier Performance Summary Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vesd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vesd__qadc01
QAD Field
 
X(8)
0
 
vesd__qadc02
QAD Field
 
X(8)
0
 
vesd__qadc03
QAD Field
 
X(8)
0
 
vesd__qadc04
QAD Field
 
X(8)
0
 
vesd__qadd01
 
 
->>,>>>,>>9.9<<<<<<<<<
10
 
vesd__qadd02
 
 
->>,>>>,>>9.9<<<<<<<<<
10
 
vesd__qadi01
 
 
>>>>>>9
 
 
vesd__qadi02
 
 
>>>>>>9
 
 
vesd__qadl01
 
 
yes/no
 
 
vesd__qadl02
 
 
yes/no
 
 
vesd__qadt01
 
 
99/99/99
 
 
vesd__qadt02
 
 
99/99/99
 
 
vesd_category
Category
 
x(8)
 
 
vesd_domain
Domain
 
x(8)
 
 
vesd_event
Event
 
x(8)
 
 
vesd_event_qty
Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
vesd_mod_date
Modified Date
Mod Date
99/99/99
 
 
vesd_mod_userid
User ID
 
x(8)
 
 
vesd_part
Item Number
Item
x(18)
 
 
vesd_rec_type
Rec Type
 
x(8)
 
 
vesd_site
Site
 
x(8)
 
 
vesd_sub_type
Subcontract Type
Sub Type
x(12)
 
 
vesd_tran_date
Transaction Date
Tran Date
99/99/99
 
 
vesd_tran_id
Transaction ID
Tran ID
>>>>>>>>
 
 
vesd_type
Type
 
x(1)
 
 
vesd_user1
Ufld1
 
x(8)
 
 
vesd_user2
Ufld2
 
x(8)
 
 
vesd_user3
 
 
x(8)
 
 
vesd_user4
 
 
x(8)
 
 
vesd_vendor
Supplier
 
x(8)
 
 
vesd_vendor_source
Supplier Source
Source
x(3)
 
 
vesd_ves_from_date
From Date
 
99/99/99
 
 
vesd_ves_to_date
To Date
 
99/99/99
 
 
vesd_weight_code
Weight Code
Weight
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vesd_det
yes
oid_vesd_det
yes
no
vesd_vendor_order
yes
vesd_domain
yes
no
 
 
 
vesd_vendor
yes
no
 
 
 
vesd_vendor_source
yes
no
 
 
 
vesd_ves_from_date
yes
no
 
 
 
vesd_ves_to_date
yes
no
 
 
 
vesd_site
yes
no
 
 
 
vesd_part
yes
no
 
 
 
vesd_rec_type
yes
no
 
 
 
vesd_type
yes
no
 
 
 
vesd_sub_type
yes
no
 
 
 
vesd_category
yes
no
 
 
 
vesd_tran_id
yes
no
ves_mstr
Supplier Performance Summary Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ves_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ves__qadc01
QAD Field
 
X(8)
0
 
ves__qadc02
QAD Field
 
X(8)
0
 
ves__qadc03
QAD Field
 
X(8)
0
 
ves__qadc04
QAD Field
 
X(8)
0
 
ves__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
ves__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
ves__qadi01
 
 
>>>>>>9
 
 
ves__qadi02
 
 
>>>>>>9
 
 
ves__qadl01
 
 
yes/no
 
 
ves__qadl02
 
 
yes/no
 
 
ves__qadt01
 
 
99/99/99
 
 
ves__qadt02
 
 
99/99/99
 
 
ves_comm_code
Commodity Code
Commodity
x(20)
 
 
ves_db
DB Number
DB
x(16)
 
 
ves_domain
Domain
 
x(8)
 
 
ves_from_date
From Date
 
99/99/99
 
 
ves_mod_date
Modified Date
Mod Date
99/99/99
 
 
ves_mod_userid
User ID
 
x(8)
 
 
ves_occurance_count
Occurance
 
>>>>,>>>,>>9
 
 
ves_part
Item Number
Item
x(18)
 
 
ves_rcvd_qty
Receipt Qty
Qty!Received
>>>>,>>>,>>>,>>9.9<<<<<<<<<
10
 
ves_rec_type
Rec Type
 
x(8)
 
 
ves_site
Site
 
x(8)
 
 
ves_sub_type
Subcontract Type
Sub Type
x(12)
 
 
ves_to_date
To Date
 
99/99/99
 
 
ves_type
Type
 
x(1)
 
 
ves_user1
Ufld1
 
x(8)
 
 
ves_user2
Ufld2
 
x(8)
 
 
ves_user3
 
 
x(8)
 
 
ves_user4
 
 
x(8)
 
 
ves_vendor
Supplier
 
x(8)
 
 
ves_vendor_source
Supplier Source
Source
x(3)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ves_mstr
yes
oid_ves_mstr
yes
no
ves_vendor_order
yes
ves_domain
yes
no
 
 
 
ves_vendor
yes
no
 
 
 
ves_vendor_source
yes
no
 
 
 
ves_from_date
yes
no
 
 
 
ves_to_date
yes
no
 
 
 
ves_site
yes
no
 
 
 
ves_part
yes
no
 
 
 
ves_rec_type
yes
no
 
 
 
ves_type
yes
no
 
 
 
ves_sub_type
yes
no
vew_mstr
Supplier Performance Weighting Factor Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vew_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vew__qadc01
QAD Field
 
X(8)
0
 
vew__qadc02
QAD Field
 
X(8)
0
 
vew__qadc03
QAD Field
 
X(8)
0
 
vew__qadc04
QAD Field
 
X(8)
0
 
vew__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vew__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vew__qadi01
 
 
>>>>>>9
 
 
vew__qadi02
 
 
>>>>>>9
 
 
vew__qadl01
 
 
yes/no
 
 
vew__qadl02
 
 
yes/no
 
 
vew__qadt01
 
 
99/99/99
 
 
vew__qadt02
 
 
99/99/99
 
 
vew_desc
Description
 
x(24)
 
 
vew_domain
Domain
 
x(8)
 
 
vew_mod_date
Modified Date
Mod Date
99/99/99
 
 
vew_mod_userid
User ID
 
x(8)
 
 
vew_name
Name
 
x(12)
 
 
vew_user1
Ufld1
 
x(8)
 
 
vew_user2
Ufld2
 
x(8)
 
 
vew_user3
 
 
x(8)
 
 
vew_user4
 
 
x(8)
 
 
vew_weight_code
Weight Code
 
x(8)
 
 
vew_weight_factor
Weight Factor
 
>,>>9.99
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vew_mstr
yes
oid_vew_mstr
yes
no
vew_weight_code
yes
vew_domain
yes
no
 
 
 
vew_weight_code
yes
no
vex_mstr
Supplier Performance Cross-Reference Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vex_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vex__qadc01
QAD Field
 
X(8)
0
 
vex__qadc02
QAD Field
 
X(8)
0
 
vex__qadc03
QAD Field
 
X(8)
0
 
vex__qadc04
QAD Field
 
X(8)
0
 
vex__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vex__qadd02
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
vex__qadi01
 
 
>>>>>>9
 
 
vex__qadi02
 
 
>>>>>>9
 
 
vex__qadl01
 
 
yes/no
 
 
vex__qadl02
 
 
yes/no
 
 
vex__qadt01
 
 
99/99/99
 
 
vex__qadt02
 
 
99/99/99
 
 
vex_domain
Domain
 
x(8)
 
 
vex_mod_date
Modified Date
Mod Date
99/99/99
 
 
vex_mod_userid
User ID
 
x(8)
 
 
vex_site
Site
 
x(8)
 
 
vex_to_site
To-Site
 
x(8)
 
 
vex_to_vendor
To-Supplier
 
x(8)
 
 
vex_to_vendor_source
To-Supplier Source
 
x(3)
 
 
vex_user1
Ufld1
 
x(8)
 
 
vex_user2
Ufld2
 
x(8)
 
 
vex_user3
 
 
x(8)
 
 
vex_user4
 
 
x(8)
 
 
vex_vendor
Supplier
 
x(8)
 
 
vex_vendor_source
Supplier Source
 
x(3)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vex_mstr
yes
oid_vex_mstr
yes
no
vex_site
yes
vex_domain
yes
no
 
 
 
vex_site
yes
no
 
 
 
vex_vendor
yes
no
 
 
 
vex_vendor_source
yes
no
 
vex_to_site
no
vex_domain
yes
no
 
 
 
vex_to_site
yes
no
 
 
 
vex_vendor
yes
no
 
 
 
vex_vendor_source
yes
no
vph_hist
Voucher Invoice History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vph_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vph__qadc01
 
 
x(24)
 
 
vph__qadc02
 
 
x(24)
 
 
vph__qadi01
 
 
->>>>>>>9
 
 
vph_acct
Account
 
x(8)
 
 
vph_adj_amt
Cost Adjustment
 
->>>>,>>>,>>9.99<
10
 
vph_adj_inv
Inventory/Variance
 
Inventory/Variance
 
 
vph_adj_prv_cst
Previous Cost
 
->>>>,>>>,>>9.99<<<
10
 
vph_adj_wip
WIP/Variance
 
WIP/Variance
 
 
vph_amt
Amount
 
->>>>,>>>,>>9.99
10
 
vph_avg_post
Post To
 
x(4)
 
 
vph_cc
Cost Ctr
CC
x(4)
 
 
vph_cf_adj_amt
Confirmed Adjustment
 
->>>>,>>>,>>9.99<
10
 
vph_cf_dscr_amt
Confirmed Discrepancy
 
->>>>,>>>,>>9.99<
10
 
vph_cinvoice_id
Invoice ID
 
-99999999999
 
 
vph_costadj_acct
Cost Adj Acct
Cost Adj
x(8)
 
 
vph_costadj_cc
Cost Adj CC
CC
x(4)
 
 
vph_costadj_sub
Cost Adj Sub
Sub-Acct
x(8)
 
 
vph_curr_amt
Currency Amount
Curr Amt
->,>>>,>>>,>>9.99<<<
10
 
vph_domain
Domain
 
x(8)
 
 
vph_dscr_acct
Inventory Dscr Acct
Dscr Acct
x(8)
 
 
vph_dscr_amt
Cost Discrepancy
 
->>>>,>>>,>>9.99<
10
 
vph_dscr_cc
Inventory Dscr CC
CC
x(4)
 
 
vph_dscr_sub
Inventory Dscr Sub-Acct
Sub-Acct
x(8)
 
 
vph_element
Cost Element
Element
x(8)
 
 
vph_inv_cost
Invoice Cost
 
->,>>>,>>>,>>9.99<<<
10
 
vph_inv_date
Invoice Date
Inv Date
99/99/99
 
 
vph_inv_qty
Invoice Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
vph_nbr
PO Nbr
 
x(8)
 
 
vph_project
Project
 
x(8)
 
 
vph_pvo_id
Pending Voucher ID
 
>>>>>>>>>
 
 
vph_pvod_id_line
Line
Ln
>>>>>>>9
 
 
vph_qoh_at_adj
QOH at adjustment
 
->>,>>>,>>9.9<<<<<<<<<
10
 
vph_ref
Voucher
 
x(22)
 
 
vph_sub
Sub-Account
Sub-Acct
x(8)
 
 
vph_user1
Ufld1
 
x(8)
 
 
vph_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vph_hist
yes
oid_vph_hist
yes
no
 
vph_nbr
no
vph_domain
yes
no
 
 
 
vph_nbr
yes
no
 
vph_pvo_id
no
vph_domain
yes
no
 
 
 
vph_pvo_id
yes
no
 
 
 
vph_pvod_id_line
yes
no
 
 
 
vph_ref
yes
no
vph_ref
yes
vph_domain
yes
no
 
 
 
vph_ref
yes
no
 
 
 
vph_pvo_id
yes
no
 
 
 
vph_pvod_id_line
yes
no
 
vph_refnbr
no
vph_domain
yes
no
 
 
 
vph_ref
yes
no
 
 
 
vph_nbr
yes
no
vpo_det
Voucher Purchase Order Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vpo_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vpo__qadc01
 
 
x(8)
 
 
vpo_domain
Domain
 
x(8)
 
 
vpo_po
PO Number
PO
x(8)
 
 
vpo_ref
Voucher
 
x(8)
 
 
vpo_user1
Ufld1
 
x(8)
 
 
vpo_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vpo_det
yes
oid_vpo_det
yes
no
vpo_refpo
yes
vpo_domain
yes
no
 
 
 
vpo_ref
yes
no
 
 
 
vpo_po
yes
no
vp_mstr
Supplier Item Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vp__chr01
 
 
x(8)
 
 
vp__chr02
 
 
x(8)
 
 
vp__chr03
 
 
x(8)
 
 
vp__chr04
 
 
x(8)
 
 
vp__chr05
 
 
x(8)
 
 
vp__dec01
 
 
>>>,>>>,>>9.99
10
 
vp__dec02
 
 
>>>,>>>,>>9.99
10
 
vp__dte01
 
 
99/99/99
 
 
vp__dte02
 
 
99/99/99
 
 
vp__log01
 
 
yes/no
 
 
vp_appr_date
Approve Date
Approve
99/99/99
 
 
vp_bkage_amt
Brokerage Amt
 
->>,>>>,>>9.99
10
 
vp_comment
Comment
 
x(40)
 
 
vp_curr
Currency
Cur
x(3)
 
 
vp_domain
Domain
 
x(8)
 
 
vp_duty_amt
Duty Amt
 
->>,>>>,>>9.99
10
 
vp_duty_type
Duty Type
Dty
x(1)
 
 
vp_frt_amt
Freight Amt
 
->>,>>>,>>9.99
10
 
vp_ins_rqd
Inspect
Ins!Req
yes/no
 
 
vp_mfgr
Manufacturer
Mfg
x(8)
 
 
vp_mfgr_part
Manufacturer Item
 
x(18)
 
 
vp_mod_date
Modified Date
Mod Date
99/99/99
 
 
vp_part
Item Number
 
x(18)
 
 
vp_pkg_code
Pkg Code
 
x(18)
 
 
vp_pr_list
Price List
List
x(8)
 
 
vp_q_date
Quote Date
Quote
99/99/99
 
 
vp_q_price
Quote Price
 
>>>>,>>>,>>9.99<<<
10
 
vp_q_qty
Quote Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
vp_rcpt_stat
Receipt Status
Status
x(8)
 
 
vp_sch_pct
Schedule
Sch
>>9.99%
10
 
vp_tp_pct
SO Price Reduction
Ext %
>>9.99%
10
 
vp_tp_use_pct
Use SO Reduction Price
Use Trans Price
yes/no
 
 
vp_um
UM
 
x(2)
 
 
vp_user1
Ufld1
 
x(8)
 
 
vp_user2
Ufld2
 
x(8)
 
 
vp_userid
User ID
 
x(8)
 
 
vp_vend
Supplier
 
x(8)
 
 
vp_vend_lead
Supplier Lead Time
LT
>>9
 
 
vp_vend_part
Supplier Item
 
x(30)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vp_mstr
yes
oid_vp_mstr
yes
no
 
vp_mfgr
no
vp_domain
yes
no
 
 
 
vp_mfgr
yes
no
 
vp_mfgr_part
no
vp_domain
yes
no
 
 
 
vp_mfgr_part
yes
no
vp_partvend
yes
vp_domain
yes
no
 
 
 
vp_part
yes
no
 
 
 
vp_vend
yes
no
 
 
 
vp_vend_part
yes
no
 
vp_vend_part
no
vp_domain
yes
no
 
 
 
vp_vend
yes
no
 
 
 
vp_vend_part
yes
no
vw_mstr
Viewer Enabled Fields Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_vw_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
vw__qadc01
 
 
x(24)
 
 
vw__qadc02
 
 
x(24)
 
 
vw__qadd01
 
 
->>>>,>>>,>>9.99<<<<<<<<
10
 
vw__qadi01
 
 
->>>>>>>9
 
 
vw__qadl01
 
 
yes/no
 
 
vw__qadt01
 
 
99/99/99
 
 
vw_field
Enabled Field Name
 
x(22)
 
 
vw_frame
Frame Name
 
x(40)
 
 
vw_mod_date
Modified Date
Mod Date
99/99/99
 
 
vw_mod_userid
User ID
 
x(8)
 
 
vw_pgm
Viewer Program Name
 
x(12)
 
 
vw_table
Table Name
 
x(16)
 
 
vw_user1
User Field Character 1
 
x(24)
 
 
vw_user2
User Field character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_vw_mstr
yes
oid_vw_mstr
yes
no
vw_pgm
yes
vw_pgm
yes
no
 
 
 
vw_table
yes
no
 
 
 
vw_field
yes
no
 
 
 
vw_frame
yes
no
WaveC
Warehousing Wave Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
ActivateRG
Activate RG in Wave Release
Activate RG!in Wave Release
yes/no
 
 
AllowSplit
Allow Split
Split
yes/no
 
 
AutoAll
Auto Allocation
 
yes/no
 
 
AvoidRelease
Avoid Release Without Replen
 
yes/no
 
 
ChangeInc
Change Include
Change!Inc
yes/no
 
 
ContMultTrans
Mult Trans for Boxes
Mult Trans!for Boxes
yes/no
 
 
ContUM
Box Pick UM
Box!Pick UM
x(2)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateRG
Create RG in Wave Release
RG in Wave!Release
yes/no
 
 
CreateUserID
Created
 
x(8)
 
 
DaysNewPreship
New Preshipper if older (days)
 
->,>>>,>>9
 
 
DefaultIncl
Default Include
Def Incl
yes/no
 
 
DisplayAll
Display Qty Alloc/Open
Alloc/Open
Alloc/Open
 
 
Domain
Domain
 
x(8)
 
 
DOOnlyAlloc
Only Alloc DO
 
yes/no
 
 
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)
 
 
FullBox
Pick Boxes in Pallet Area
Pick Boxes!Pallet Area
yes/no
 
 
GenerateRG
Def Generate Release Groups
Gen RG
yes/no
 
 
LaneAlgo
Lane Algorithm
Lane Algo
>>9
 
 
LaneGroup
Default Lane Group
Def Lane Grp
x(8)
 
 
LaneLoadOpt
Lane Load Algo
Lane Load!Algo
>>9
 
 
LinesPerRG
Order Lines per Rel Group
Lines per RG
>>,>>9
 
 
LoadAlgo
WorkLoad Algorithm
Load Algo
>>9
 
 
LoadGroup
Default Workload Group
Def Grp
x(8)
 
 
MaxLines
Def Max Order Lines
Max Lines
->,>>>,>>9
 
 
ModDate
Modified
 
99/99/99
 
 
ModDetail
Modify Details
Det
yes/no
 
 
ModUserID
Modified
 
x(8)
 
 
NewPreshipWave
New Preshipper by Wave
 
yes/no
 
 
NextNbr
Next Number
Next Nbr
>>>>>>>9
 
 
NoLimit
Use Limit in Add Frame
Limit
yes/no
 
 
oid_WaveC
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OnlyAlloc
Display Only Allocated Lines
Only Alloc
yes/no
 
 
OpenQty
Open Qty Calculation
Open Qty
>9
 
 
PalPickEnd
Pallet SLG Level
Pallet SLG Level
>>9
 
 
PalPickStart
Pallet SLG Level
Pallet SLG Level
>>9
 
 
PickMulti
Pick Multi-Item Pal (Step1)
 
yes/no
 
 
PickPct
Def Pick Trigger %
Pick!Trigger
>>9
 
 
PlUM
Pallet UM
Pallet UM
x(2)
 
 
Prefix
Prefix
Pre
x(8)
 
 
PreventRelease
Avoid Release Without Replen
 
yes/no
 
 
Priority
Order Priority
Priority
>>>>>>>9
 
 
PriorityAA
Def Priority After Activ
Pri AA
>>9
 
 
PriorityTC
Def Pri at Task Creation
Pri TC
>>9
 
 
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
 
 
RelAlgo
Release Group Algo
RG Algo
>>9
 
 
RepAllowSplit
Allow Split Replen
Allow Split!Replen
yes/no
 
 
ReplenPrio
Std Repl Task Priority
 
>>>>>>>9
 
 
RepList
Replenishment List
Rep List
X(8)
 
 
RepMultTrans
Replen Mult Trans
Replen!Mult Trans
yes/no
 
 
RepMultUM
Replen Pick UM
Rep!Pick UM
x(2)
 
 
RepOverPick
Replenishment OverPick
Rep!OverPick
yes/no
 
 
RepPriority
Def Pal/Box Init Priority
Pallet/Nox!Priority
>>9
 
 
RoundAbove
Round Above/Below
Above/Below
Above/Below
 
 
Site
Site
 
x(8)
 
 
SOPickFirst
SO Pick First
SO Pick!First
yes/no
 
 
SortAlgo
Default Sort Algorithm
Def Sort Algo
>>9
 
 
SplitMulti
Spl.Mult-Item Pal(Step1)
 
yes/no
 
 
TimePerPick
Time Per Pick (min)
Pick (min)
>9.99
2
 
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)
 
 
UseDefAlgo
Use Def WL Algo
Def WL Algo
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
 
 
WavePause
Pause Between Waves (s)
Pause!Waves
>>>9
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WaveC
yes
oid_WaveC
yes
no
 ∗
SiteWhse
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WaveD
Warehousing Wave Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
DSet
Data Set
 
x(12)
 
 
DueDate
Due Date
 
99/99/99
 
 
FromDate
From Date
From
99/99/99
 
 
FromRef
From Reference
From Ref
x(24)
 
 
FromTime
From Time
 
x(20)
 
 
Incl
Included
Incl
yes/no
 
 
Line
Line/ID
 
x(8)
 
 
LoadOpt
Load Optimized
Load
yes/no
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
Nbr
Order
 
x(18)
 
 
NetWeight
Net Weight
Net Wgt
->>,>>9.99
2
 
oid_WaveD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrdSite
Order Site
Order!Site
x(8)
 
 
OrdStatus
Order Line Status
Status
x(8)
 
 
Part
Item Number
 
x(18)
 
 
PartType
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
Priority
Priority
 
X(8)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
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
 
 
QtyAlloc
Quantity Allocated
Qty All
->,>>>,>>9.9<<<<<<<<
2
 
QtyOpen
Qty Open
Open
->,>>>,>>9.9<<<<<<<<
2
 
Route
Route
 
X(8)
 
 
ShipVia
Carrier
Carrier
x(20)
 
 
Site
Site
 
x(8)
 
 
ToDate
To Date
To
99/99/99
 
 
ToRef
To Reference
To Ref
x(24)
 
 
ToTime
To Time
 
x(20)
 
 
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
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Include
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Incl
yes
no
 
LoadOpt
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
LoadOpt
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
OrdSite
yes
no
 
 
 
ShipVia
yes
no
 
 
 
Line
yes
no
 
oid_WaveD
yes
oid_WaveD
yes
no
 
OrderIdx
no
Domain
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
Line
yes
no
 
 
 
OrdSite
yes
no
 
 
 
WaveNbr
yes
no
 ∗
OrderLine
yes
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
OrdSite
yes
no
 
 
 
ShipVia
yes
no
 
 
 
Line
yes
no
 
OrdStatus
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
OrdStatus
yes
no
 
Part
no
Domain
yes
no
 
 
 
Part
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
ReleaseGroup
no
Domain
yes
no
 
 
 
DueDate
yes
no
 
 
 
ShipVia
yes
no
 
 
 
PartType
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
WavePart
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Part
yes
no
WaveLoadD
Warehousing Wave Load Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CarrierRef
Carrier Shipment Ref
 
x(20)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
DropOffSeq
Drop Off Sequence
Drop Off
>>>>>9
 
 
DSet
Data Set
 
x(12)
 
 
Incl
Included
Incl
yes/no
 
 
Line
Line/ID
 
x(8)
 
 
LoadNbr
Load Number
Load Nbr
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
Nbr
Order
 
x(18)
 
 
NetWeight
Net Weight
Net Wgt
->>,>>9.99
2
 
oid_WaveLoadD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrdSite
Order Site
Order!Site
x(8)
 
 
Part
Item Number
 
x(18)
 
 
QadC01
QAD Field
 
x(24)
0
 
QadC02
QAD Field
 
x(24)
0
 
QadC03
QAD Field
 
x(24)
0
 
QadC04
QAD Field
 
x(24)
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
 
 
QtyOpen
Quantity
Qty
->,>>>,>>9.9<<<<<<<<
10
 
QtyPicked
Qty Picked
Pick
->,>>>,>>9.9<<<<<<<<
10
 
SelNbr
Selection Number
Sel Nbr
x(8)
 
 
ShipTo
Ship To
 
x(8)
 
 
ShipVia
Carrier
Carrier
x(20)
 
 
Site
Site
 
x(8)
 
 
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
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Include
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Incl
yes
no
 
LoadIdx
no
Domain
yes
no
 
 
 
LoadNbr
yes
no
 
 
 
DropOffSeq
yes
no
 
 
 
CarrierRef
yes
no
 
 
 
SelNbr
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
OrdSite
yes
no
 
 
 
Part
yes
no
 
 
 
Line
yes
no
 
 
 
WaveNbr
yes
no
LoadLine
yes
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
OrdSite
yes
no
 
 
 
ShipVia
yes
no
 
 
 
Line
yes
no
 
 
 
LoadNbr
yes
no
 
 
 
DropOffSeq
yes
no
 
 
 
CarrierRef
yes
no
 
 
 
SelNbr
yes
no
 
oid_WaveLoadD
yes
oid_WaveLoadD
yes
no
 
OrderIdx
no
Domain
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
Line
yes
no
 
 
 
OrdSite
yes
no
 
 
 
WaveNbr
yes
no
 
Part
no
Domain
yes
no
 
 
 
Part
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
UserC01
yes
no
 
 
 
UserC02
yes
no
WaveM
Warehousing Wave Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
DSet
Data Set
 
x(12)
 
 
DueDate
Due Date
 
99/99/99
 
 
Incl
Included
Incl
yes/no
 
 
Lines
Number of Lines
Lines
->,>>>,>>9
 
 
LoadOptLines
Optimized Lines
Optimized
->,>>>,>>9
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
Nbr
Order
 
x(18)
 
 
NetWeight
Net Weight
Net Wgt
->>,>>9.99
2
 
oid_WaveM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrdSite
Order Site
Order!Site
x(8)
 
 
OrdStatus
Status
Stat
x(8)
 
 
Priority
Priority
 
X(8)
 
 
Profile
Profile
Prof
x(8)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
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
 
 
Route
Route
 
X(8)
 
 
Seq
Sequence
Seq
>,>>>,>>9
 
 
ShipTo
Ship To
Ship To
x(8)
 
 
ShipVia
Carrier
Carrier
x(20)
 
 
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
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DueDate
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
DueDate
yes
no
 
 
 
Nbr
yes
no
 
Include
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Incl
yes
no
 
NetWeight
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
NetWeight
yes
no
 
 
 
Nbr
yes
no
 
oid_WaveM
yes
oid_WaveM
yes
no
 ∗
OrderIdx
yes
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
DSet
yes
no
 
 
 
Nbr
yes
no
 
 
 
OrdSite
yes
no
 
 
 
ShipVia
yes
no
 
OrdStatus
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
OrdStatus
yes
no
 
 
 
Nbr
yes
no
 
Profile
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Profile
yes
no
 
 
 
Nbr
yes
no
 
Route
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Route
yes
no
 
 
 
Nbr
yes
no
 
Seq
yes
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
Seq
yes
no
 
ShipTo
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
ShipTo
yes
no
 
 
 
Nbr
yes
no
 
ShipVia
no
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
 
 
ShipVia
yes
no
 
 
 
Nbr
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WaveMasterM
Warehousing Wave Master Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
FromDate
From Date
From
99/99/99
 
 
FromRef
From Reference
From Ref
x(24)
 
 
FromTime
From Time
 
x(20)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_WaveMasterM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PickComp
Pick Complete%
Pick%
->>,>>9.99
2
 
Priority
Order Priority
Priority
>,>>>,>>9
 
 
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
 
 
Remark
Remark
Rmk
x(40)
 
 
RepComp
Replenishment Complete%
Rep Comp%
->>,>>9.99
2
 
ReplenDate
Replenishment Date
 
99/99/99
 
 
ReplenTime
Replenishment Date
 
->>,>>9.99
10
 
Site
Site
 
x(8)
 
 
SizeLines
Number of Order Lines
#Lines
->,>>>,>>9
 
 
SizeOrders
Number of Orders
#Orders
->,>>>,>>9
 
 
ToDate
To Date
To
99/99/99
 
 
ToRef
To Reference
To Ref
x(24)
 
 
ToTime
To Time
 
x(20)
 
 
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
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
WaveStatus
Wave Status
Status
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_WaveMasterM
yes
oid_WaveMasterM
yes
no
 
SiteWhse
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
WaveNbr
yes
Domain
yes
no
 
 
 
WaveNbr
yes
no
 
WaveStatus
no
Domain
yes
no
 
 
 
WaveStatus
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no