cph_hist

About This Guide > cph_hist

cph_hist

Customer/Item Sales History


	Field Name	Label	Col-Label	Format	Dec
	cph__chr01			x(8)
	cph__chr02			x(8)
	cph__chr03			x(8)
	cph__chr04			x(8)
	cph__chr05			x(8)
	cph__dec01[12]			>>>>,>>>,>>9.99	10
	cph__dec02[12]			>>>>,>>>,>>9.99	10
	cph__dte01			99/99/99
	cph__dte02			99/99/99
	cph__log01			yes/no
	cph_cost[12]	Cost		->>>>,>>>,>>9	10
	cph_cust	Customer		x(8)
	cph_domain	Domain		x(8)
	cph_part	Item Number		x(18)
	cph_pl	Product Line		x(4)
	cph_qty[12]	Quantity		->,>>>,>>9	10
	cph_sales[12]	Sales		->>>>,>>>,>>9	10
	cph_ship	Ship-To		x(8)
	cph_site	Site		x(8)
	cph_smonth	Start Month		>9
	cph_tot_cost	YTD Cost		->>,>>>,>>>,>>9	10
	cph_tot_qty	YTD Quantity		->>>,>>>,>>9	10
	cph_tot_sale	YTD Sales		->>,>>>,>>>,>>9	10
	cph_type	Ship Type	T	x(1)
	cph_user1	Ufld1		x(8)
	cph_user2	Ufld2		x(8)
	cph_year	Year		9999
	oid_cph_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	cph_cust	yes	cph_domain	yes	no
			cph_cust	yes	no
			cph_ship	yes	no
			cph_pl	yes	no
			cph_part	yes	no
			cph_type	yes	no
			cph_year	yes	no
			cph_site	yes	no
	cph_part	no	cph_domain	yes	no
			cph_part	yes	no
			cph_type	yes	no
			cph_year	yes	no
∗	cph_pl	no	cph_domain	yes	no
			cph_pl	yes	no
			cph_part	yes	no
			cph_type	yes	no
			cph_year	yes	no
	oid_cph_hist	yes	oid_cph_hist	yes	no