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