About This Guide > ser_mstr
  
ser_mstr
Item serial IDs and package serial IDs
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_loc_mstr
Location Master OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_ser_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_ser_mstr_parent
Parent Serial Master OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ser__qadc01
 
 
x(24)
 
 
ser__qadc02
 
 
x(24)
 
 
ser_domain
Domain
 
x(8)
 
 
ser_gross_weight
Gross Weight
 
->>,>>9.99<<<<
10
 
ser_gross_weight_um
Gross Weight UM
 
x(2)
 
 
ser_loc
Location
 
x(8)
 
 
ser_lotser
Lot/Serial
 
x(18)
 
 
ser_mod_date
Modified Date
Mod Date
99/99/99
 
 
ser_mod_userid
User ID
 
x(8)
 
 
ser_pack_code
Pack Code
 
x(18)
 
 
ser_part
Item
 
x(18)
 
 
ser_phantom
Phantom Pack
 
yes/no
 
 
ser_prt_lbl
Serial ID Printed
 
yes/no
 
 
ser_qty_avail
Avail Pack Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
ser_qty_pck
Std Pack Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
ser_ref
Reference
 
x(8)
 
 
ser_serial_id
Serial ID
 
x(40)
 
 
ser_ship_wt
Ship Weight
 
->>,>>9.99<<<<
10
 
ser_ship_wt_um
Ship Weight UM
UM
x(2)
 
 
ser_site
Site
 
x(8)
 
 
ser_size
Volume
 
->>,>>9.99
10
 
ser_size_um
Volume UM
UM
x(2)
 
 
ser_stage
Stage
 
x(10)
 
 
ser_truck_loaded
Truck Loaded
 
yes/no
 
 
ser_um
UM
 
x(2)
 
 
ser_unloaded
Unloaded
 
yes/no
 
 
ser_user1
User Field Character 1
 
x(24)
 
 
ser_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ser_mstr
yes
oid_ser_mstr
yes
no
 
oid_ser_mstr_ld
no
oid_ld_det
yes
no
 
oid_ser_mstr_loc
no
oid_loc_mstr
yes
no
 
oid_ser_mstr_parent
no
oid_ser_mstr_parent
yes
no
ser_domain_serial
yes
ser_domain
yes
no
 
 
 
ser_serial_id
yes
no
 
ser_pt_loc_lot
no
ser_domain
yes
no
 
 
 
ser_part
yes
no
 
 
 
ser_site
yes
no
 
 
 
ser_loc
yes
no
 
 
 
ser_lotser
yes
no
 
 
 
ser_ref
yes
no
 
ser_pt_stg
no
ser_domain
yes
no
 
 
 
ser_part
yes
no
 
 
 
ser_stage
yes
no
 
ser_serial_id
yes
ser_serial_id
yes
no
 
ser_stg_site_loc
no
ser_domain
yes
no
 
 
 
ser_stage
yes
no
 
 
 
ser_site
yes
no
 
 
 
ser_loc
yes
no