cnsu_mstr

About This Guide > cnsu_mstr

cnsu_mstr

Supplier Consignment Receipt Usage Master


	Field Name	Label	Col-Label	Format	Dec
	cnsu__qadc01			x(24)
	cnsu__qadc02			x(24)
	cnsu_batch	Batch		>>>>>>>>>
	cnsu_cum_qty	Cum Usage Qty	Cum Usage	->>,>>>,>>9.9<<<<<<<<<	10
	cnsu_domain	Domain		x(8)
	cnsu_edi_batch	EDI Batch ID		x(24)
	cnsu_eff_date	Effective Date	Effective	99/99/99
	cnsu_export_flag	Exported		yes/no
	cnsu_lotser	Lot/Serial		x(18)
	cnsu_mod_date	Modified Date	Mod Date	99/99/99
	cnsu_mod_userid	User ID		x(8)
	cnsu_part	Item Number		x(18)
	cnsu_pkey	Primary Key		>>>>>>>>>
	cnsu_po_nbr	Purchase Order	Order	x(8)
	cnsu_pod_line	Line		>>>9
	cnsu_print_flag	Printed		yes/no
	cnsu_qty_used	Usage Qty		->>,>>>,>>9.9<<<<<<<<<	10
	cnsu_ref	Reference	Ref	x(8)
	cnsu_site	Site		x(8)
	cnsu_trans_date	Transaction Date	Transaction	99/99/99
	cnsu_trnbr	Trans Nbr		>>>>>>>>>>
	cnsu_user1	User Field Character 1		x(24)
	cnsu_user2	User Field Character 2		x(24)
	oid_cnsu_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	cnsu_batch	no	cnsu_domain	yes	no
			cnsu_batch	yes	no
			cnsu_trnbr	yes	no
			cnsu_po_nbr	yes	no
			cnsu_pod_line	yes	no
			cnsu_lotser	yes	no
			cnsu_ref	yes	no
	cnsu_edi_batch	no	cnsu_domain	yes	no
			cnsu_edi_batch	yes	no
	cnsu_order	no	cnsu_domain	yes	no
			cnsu_po_nbr	yes	no
			cnsu_pod_line	yes	no
	cnsu_part_site	no	cnsu_domain	yes	no
			cnsu_part	yes	no
			cnsu_site	yes	no
∗	cnsu_primary_key	yes	cnsu_domain	yes	no
			cnsu_pkey	yes	no
	cnsu_trnbr	no	cnsu_domain	yes	no
			cnsu_trnbr	yes	no
	oid_cnsu_mstr	yes	oid_cnsu_mstr	yes	no