qlcoa_mstr

About This Guide > qlcoa_mstr

qlcoa_mstr

Quality Certificate of Analysis Master


	Field Name	Label	Col-Label	Format	Dec
	oid_qlcoa_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
	qlcoa__qadc01			x(24)
	qlcoa__qadc02			x(24)
	qlcoa_approve_date	Approve Date		99/99/99
	qlcoa_approver_name	Approver Name		x(36)
	qlcoa_approver_userid	Approved By		x(8)
	qlcoa_assay	Assay %		>>9.99%	10
	qlcoa_certificate_date	Certificate Date		99/99/99
	qlcoa_complete_date	Completed Date		99/99/99
	qlcoa_completed_userid	Completed By		x(8)
	qlcoa_cust	Sold-To		x(8)
	qlcoa_cust_name	Cust Name		x(36)
	qlcoa_doc_type	Doc Type		x(8)
	qlcoa_domain	Domain		x(8)
	qlcoa_expire	Expire Date	Expire	99/99/99
	qlcoa_grade	Grade		x(2)
	qlcoa_id	Certificate		x(24)
	qlcoa_item_desc1	Description		x(24)
	qlcoa_lot	Lot		x(18)
	qlcoa_mfg_date	Mfg Date		99/99/99
	qlcoa_mod_date	Modified Date	Mod Date	99/99/99
	qlcoa_mod_userid	User ID		x(8)
	qlcoa_mtl_disposition	Material Disposition		x(8)
	qlcoa_mtl_disposition_date	Disposition Date		99/99/99
	qlcoa_part	Item Number		x(18)
	qlcoa_print_assay	Print Assay%		yes/no
	qlcoa_print_expire	Print Expire		yes/no
	qlcoa_print_grade	Print Grade		yes/no
	qlcoa_print_mfg_date	Print Manufacture		yes/no
	qlcoa_ql_id	Document Order		x(24)
	qlcoa_ship	Ship-To		x(8)
	qlcoa_ship_name	Ship-To Name		x(36)
	qlcoa_site	Site		x(8)
	qlcoa_so_nbr	Sales Order		x(8)
	qlcoa_sod_line	Line	Ln	>>9
	qlcoa_sublot	Sublot		x(18)
	qlcoa_test_result_status	COA Result		x(8)
	qlcoa_user1	User Field Character 1		x(24)
	qlcoa_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_qlcoa_mstr	yes	oid_qlcoa_mstr	yes	no
∗	qlcoa_id	yes	qlcoa_domain	yes	no
			qlcoa_id	yes	no
	qlcoa_lot_part	no	qlcoa_domain	yes	no
			qlcoa_doc_type	yes	no
			qlcoa_lot	yes	no
			qlcoa_sublot	yes	no
			qlcoa_part	yes	no
			qlcoa_site	yes	no
			qlcoa_certificate_date	yes	no
	qlcoa_part_so	no	qlcoa_domain	yes	no
			qlcoa_doc_type	yes	no
			qlcoa_site	yes	no
			qlcoa_part	yes	no
			qlcoa_lot	yes	no
			qlcoa_sublot	yes	no
			qlcoa_so_nbr	yes	no
			qlcoa_sod_line	yes	no
			qlcoa_certificate_date	yes	no
	qlcoa_qlid_so	no	qlcoa_domain	yes	no
			qlcoa_doc_type	yes	no
			qlcoa_ql_id	yes	no
			qlcoa_so_nbr	yes	no
			qlcoa_sod_line	yes	no
			qlcoa_certificate_date	yes	no
	qlcoa_sod_line	no	qlcoa_domain	yes	no
			qlcoa_doc_type	yes	no
			qlcoa_so_nbr	yes	no
			qlcoa_sod_line	yes	no
			qlcoa_lot	yes	no
			qlcoa_sublot	yes	no
			qlcoa_certificate_date	yes	no