|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_shph_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
shph__qadc01
|
|
|
x(24)
|
|
|
|
shph__qadc02
|
|
|
x(24)
|
|
|
|
shph_ad_city
|
City
|
|
x(20)
|
|
|
|
shph_ad_country
|
Country
|
|
x(28)
|
|
|
|
shph_ad_name
|
Name
|
|
x(36)
|
|
|
|
shph_ad_state
|
State
|
|
x(4)
|
|
|
|
shph_domain
|
Domain
|
|
x(8)
|
|
|
|
shph_fob
|
FOB
|
|
x(20)
|
|
|
|
shph_master_id
|
Master Bill ID
|
|
x(20)
|
|
|
|
shph_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
shph_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
shph_ord_line
|
Line
|
|
x(8)
|
|
|
|
shph_ord_nbr
|
Order
|
|
x(8)
|
|
|
|
shph_packing_slip
|
Packing Slip
|
|
x(20)
|
|
|
|
shph_program
|
Program
|
|
x(12)
|
|
|
|
shph_ship_type
|
Type
|
|
x(1)
|
|
|
|
shph_shipto
|
Ship-to Id
|
|
x(8)
|
|
|
|
shph_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
shph_shp_from
|
Shipping From
|
|
x(8)
|
|
|
|
shph_shp_id
|
Shipper ID
|
|
x(20)
|
|
|
|
shph_table_name
|
Shipping Table Name
|
|
x(18)
|
|
|
|
shph_timestamp
|
Date/Time
|
|
99/99/9999 HH:MM:SS.SSS
|
|
|
|
shph_trans_type
|
Transaction Type
|
|
x(8)
|
|
|
|
shph_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
shph_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_shph_hist
|
yes
|
oid_shph_hist
|
yes
|
no
|
|
∗
|
shph_timestamp
|
yes
|
shph_domain
|
yes
|
no
|
|
|
|
|
shph_shp_from
|
yes
|
no
|
|
|
|
|
shph_shp_id
|
yes
|
no
|
|
|
|
|
shph_ord_nbr
|
yes
|
no
|
|
|
|
|
shph_ord_line
|
yes
|
no
|
|
|
|
|
shph_packing_slip
|
yes
|
no
|
|
|
|
|
shph_timestamp
|
yes
|
no
|
|
|
shph_trans_time
|
no
|
shph_domain
|
yes
|
no
|
|
|
|
|
shph_trans_type
|
yes
|
no
|
|
|
|
|
shph_timestamp
|
yes
|
no
|