About This Guide > shp_hist
  
shp_hist
Shipment Performance History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_shp_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
shp__qadc01
 
 
X(24)
 
 
shp__qadc02
 
 
X(24)
 
 
shp_abs_id
Shipper
 
x(20)
 
 
shp_cmtindx
Comment
 
>>>>>>>9
 
 
shp_currency
Currency
 
x(3)
 
 
shp_cust
Customer
 
x(8)
 
 
shp_cust_part
Customer Item
 
x(30)
 
 
shp_customer_source
Customer Source
 
x(3)
 
 
shp_do_req
Requisition
 
x(8)
 
 
shp_domain
Domain
 
x(8)
 
 
shp_due_date
Due Date
 
99/99/99
 
 
shp_ext_price
Extended Price
 
->>>>,>>>,>>9.99<<<
10
 
shp_include
Include in Reporting
 
yes/no
 
 
shp_line
Line
 
>>9
 
 
shp_mod_date
Modified Date
Mod Date
99/99/99
 
 
shp_mod_userid
User ID
 
x(8)
 
 
shp_nbr
Order
 
x(8)
 
 
shp_open_qty
Open Qty
 
->>,>>>,>>9.9<<<<<<<<
10
 
shp_ord_um
UM
 
x(2)
 
 
shp_ord_um_conv
UM Conversion
 
>>>>9.9999<<<<
10
 
shp_order_category
Category
 
x(8)
 
 
shp_part
Item Number
 
x(18)
 
 
shp_perf_date
Performance Date
 
99/99/99
 
 
shp_qty_pct
Shipment Percentage
 
->>9.99
10
 
shp_rel_id
Release
 
x(30)
 
 
shp_req_date
Required Date
 
99/99/99
 
 
shp_sched_time
Schedule Time
 
99:99
 
 
shp_ship_date
Ship Date
 
99/99/99
 
 
shp_ship_price
Ship Price
 
->>>>,>>>,>>9.99<<<
10
 
shp_ship_qty
Ship Qty
 
->>,>>>,>>9.9<<<<<<<<
10
 
shp_ship_time
Ship Time
 
99:99
 
 
shp_ship_um
UM
 
x(2)
 
 
shp_ship_um_conv
UM Conversion
 
>>>>9.9999<<<<
10
 
shp_shipfrom
Ship-From
 
x(8)
 
 
shp_shipto
Ship-To
 
x(8)
 
 
shp_tran_id
Tran ID
 
>>>>>>>>9
 
 
shp_user1
User Field Character 1
 
X(24)
 
 
shp_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_shp_hist
yes
oid_shp_hist
yes
no
 
shp_abs_id
no
shp_domain
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_abs_id
yes
no
 
shp_cust
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_cust
yes
no
 
 
 
shp_shipto
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
 
shp_customer_source
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_customer_source
yes
no
 
 
 
shp_cust
yes
no
 
 
 
shp_shipto
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
 
 
 
shp_ship_date
yes
no
 
shp_part
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_part
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
 
shp_ship_date
no
shp_domain
yes
no
 
 
 
shp_include
yes
no
 
 
 
shp_ship_date
yes
no
 
 
 
shp_shipfrom
yes
no
 
 
 
shp_shipto
yes
no
 
 
 
shp_nbr
yes
no
 
 
 
shp_line
yes
no
shp_tran_id
yes
shp_domain
yes
no
 
 
 
shp_tran_id
yes
no