About This Guide > cmh_hist
  
cmh_hist
Customer Sales History
 
 
Field Name
Label
Col-Label
Format
Dec
 
cmh__chr01
 
 
x(8)
 
 
cmh__chr02
 
 
x(8)
 
 
cmh__chr03
 
 
x(8)
 
 
cmh__chr04
 
 
x(8)
 
 
cmh__chr05
 
 
x(8)
 
 
cmh__chr06
 
 
x(8)
 
 
cmh__chr07
 
 
x(8)
 
 
cmh__chr08
 
 
x(8)
 
 
cmh__chr09
 
 
x(8)
 
 
cmh__chr10
 
 
x(8)
 
 
cmh__dec01
 
 
>>>,>>>,>>9.99
10
 
cmh__dec02
 
 
>>>,>>>,>>9.99
10
 
cmh__dte01
 
 
99/99/99
 
 
cmh__dte02
 
 
99/99/99
 
 
cmh__log01
 
 
yes/no
 
 
cmh__log02
 
 
yes/no
 
 
cmh_cust
Customer
 
x(8)
 
 
cmh_domain
Domain
 
x(8)
 
 
cmh_tot_cost
YTD Cost
 
->,>>>,>>>,>>9
10
 
cmh_tot_sale
YTD Sales
 
->,>>>,>>>,>>9
10
 
cmh_type
Ship Type
T
x(1)
 
 
cmh_user1
Ufld1
 
x(8)
 
 
cmh_user2
Ufld2
 
x(8)
 
 
cmh_year
Year
 
9999
 
 
oid_cmh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cmh_custyear
yes
cmh_domain
yes
no
 
 
 
cmh_cust
yes
no
 
 
 
cmh_year
yes
no
cmh_yearcust
yes
cmh_domain
yes
no
 
 
 
cmh_year
yes
no
 
 
 
cmh_cust
yes
no
 
oid_cmh_hist
yes
oid_cmh_hist
yes
no