cncu_mstr

About This Guide > cncu_mstr

cncu_mstr

Customer Consignment Shipment Usage Master


	Field Name	Label	Col-Label	Format	Dec
	cncu__qadc01			x(24)
	cncu__qadc02			x(24)
	cncu_auth	Authorization		x(24)
	cncu_batch	Batch		>>>>>>>>>
	cncu_cum_qty	Cum Usage Qty	Cum Usage	->>,>>>,>>9.9<<<<<<<<<	10
	cncu_cust	Sold-To		x(8)
	cncu_cust_job	Customer Job		x(30)
	cncu_cust_ref	Customer Reference		x(30)
	cncu_cust_seq	Customer Sequence		x(30)
	cncu_cust_usage_date	Customer Usage Date	Customer!Usage Date	99/99/99
	cncu_cust_usage_ref	Customer Usage Ref	Customer!Usage Ref	x(20)
	cncu_custpart	Customer Item		x(30)
	cncu_domain	Domain		x(8)
	cncu_eff_date	Effective Date	Effective	99/99/99
	cncu_invoice	Invoice		x(8)
	cncu_lotser	Lot/Serial		x(18)
	cncu_manual_qty	Manual Qty		->>,>>>,>>9.9<<<<<<<<<	10
	cncu_mod_date	Modified Date	Mod Date	99/99/99
	cncu_mod_userid	User ID		x(8)
	cncu_modelyr	Model Year		x(4)
	cncu_origin	Origin		x(8)
	cncu_part	Item		x(18)
	cncu_pkey	Primary Key		>>>>>>>>>
	cncu_po	Customer PO		x(22)
	cncu_ref	Reference	Ref	x(8)
	cncu_selfbill_auth	SelfBill Auth	Self-Bill Authorization	x(24)
	cncu_shipto	Ship-To		x(8)
	cncu_site	Ship-From		x(8)
	cncu_so_nbr	Sales Order	Order	x(8)
	cncu_sod_line	Line		>>>9
	cncu_trans_date	Transaction Date	Transaction	99/99/99
	cncu_trnbr	Trans Nbr		>>>>>>>>>>
	cncu_usage_qty	Usage Qty		->>,>>>,>>9.9<<<<<<<<<	10
	cncu_usage_so_um_conv	Usage SO UM Conv		>>>>9.9999<<<<	10
	cncu_usage_um	Usage UM		x(2)
	cncu_usage_um_conv	Usage UM Conv		>>>>9.9999<<<<	10
	cncu_user1	User Field Character 1		x(24)
	cncu_user2	User Field Character 2		x(24)
	oid_cncu_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	cncu_batch	no	cncu_domain	yes	no
			cncu_batch	yes	no
			cncu_so_nbr	yes	no
			cncu_sod_line	yes	no
			cncu_lotser	yes	no
			cncu_ref	yes	no
			cncu_auth	yes	no
	cncu_invoice	no	cncu_domain	yes	no
			cncu_invoice	yes	no
	cncu_order	no	cncu_domain	yes	no
			cncu_so_nbr	yes	no
			cncu_sod_line	yes	no
	cncu_origin	no	cncu_domain	yes	no
			cncu_origin	yes	no
			cncu_so_nbr	yes	no
			cncu_sod_line	yes	no
			cncu_trans_date	yes	no
∗	cncu_primary_key	yes	cncu_domain	yes	no
			cncu_pkey	yes	no
	cncu_shipfrom	no	cncu_domain	yes	no
			cncu_site	yes	no
			cncu_shipto	yes	no
			cncu_cust_usage_ref	yes	no
			cncu_cust_usage_date	yes	no
			cncu_so_nbr	yes	no
			cncu_sod_line	yes	no
			cncu_lotser	yes	no
			cncu_ref	yes	no
			cncu_auth	yes	no
	cncu_trnbr	no	cncu_domain	yes	no
			cncu_trnbr	yes	no
	oid_cncu_mstr	yes	oid_cncu_mstr	yes	no