cncix_mstr

About This Guide > cncix_mstr

cncix_mstr

Consigned Shipment Inventory Cross-Reference Master


	Field Name	Label	Col-Label	Format	Dec
	cncix__qadc01			x(24)
	cncix__qadc02			x(24)
	cncix_aged_date	Aged Date	Aged	99/99/99
	cncix_asn_shipper	Shipper		x(20)
	cncix_auth	Authorization		x(24)
	cncix_curr	Currency	Cur	x(3)
	cncix_current_loc	Location		x(8)
	cncix_cust	Sold-To		x(8)
	cncix_cust_dock	Customer Dock		x(30)
	cncix_cust_job	Customer Job		x(30)
	cncix_cust_ref	Customer Reference		x(30)
	cncix_cust_seq	Customer Sequence		x(30)
	cncix_custpart	Customer Item		x(30)
	cncix_domain	Domain		x(8)
	cncix_int_consignment	Internal Consignment		yes/no
	cncix_intransit	In-Transit		yes/no
	cncix_line_feed	Line Feed		x(30)
	cncix_lotser	Lot/Serial		x(18)
	cncix_mod_date	Modified Date	Mod Date	99/99/99
	cncix_mod_userid	User ID		x(8)
	cncix_modelyr	Model Year		x(4)
	cncix_orig_aged_date	Original Aged Date	Original!Aged	99/99/99
	cncix_part	Item		x(18)
	cncix_pkey	Primary Key		>>>>>>>>>
	cncix_po	Customer PO		x(22)
	cncix_price	Price		->>,>>>,>>9.99<<<	10
	cncix_qty_ship	Ship Qty		->>,>>>,>>9.9<<<<<<<<<	10
	cncix_qty_stock	Qty In-Stock	Qty!In-Stock	->>,>>>,>>9.9<<<<<<<<<	10
	cncix_ref	Reference	Ref	x(8)
	cncix_selfbill	Self-Bill		yes/no
	cncix_ship_date	Ship Date		99/99/99
	cncix_ship_trnbr	Trans Nbr		>>>>>>>>>>
	cncix_ship_value	Ship Value		->>>>,>>>,>>9.99<	10
	cncix_shipto	Ship-To		x(8)
	cncix_site	Site		x(8)
	cncix_so_nbr	Sales Order	Order	x(8)
	cncix_sod_line	Line		>>>9
	cncix_stock_um	Stock UM	UM	x(2)
	cncix_user1	User Field Character 1		x(24)
	cncix_user2	User Field Character 2		x(24)
	oid_cncix_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	cncix_loc_part	no	cncix_domain	yes	no
			cncix_site	yes	no
			cncix_current_loc	yes	no
			cncix_part	yes	no
			cncix_ship_date	yes	no
			cncix_lotser	yes	no
			cncix_ref	yes	no
	cncix_order_line	no	cncix_domain	yes	no
			cncix_so_nbr	yes	no
			cncix_sod_line	yes	no
			cncix_aged_date	yes	no
∗	cncix_primary_key	yes	cncix_domain	yes	no
			cncix_pkey	yes	no
	cncix_shipper	no	cncix_domain	yes	no
			cncix_asn_shipper	yes	no
	cncix_site_cust	no	cncix_domain	yes	no
			cncix_site	yes	no
			cncix_cust	yes	no
			cncix_shipto	yes	no
			cncix_so_nbr	yes	no
			cncix_part	yes	no
			cncix_po	yes	no
			cncix_modelyr	yes	no
			cncix_current_loc	yes	no
			cncix_lotser	yes	no
			cncix_ref	yes	no
			cncix_auth	yes	no
	cncix_site_part	no	cncix_domain	yes	no
			cncix_site	yes	no
			cncix_part	yes	no
			cncix_cust	yes	no
			cncix_shipto	yes	no
			cncix_so_nbr	yes	no
			cncix_po	yes	no
			cncix_modelyr	yes	no
			cncix_current_loc	yes	no
			cncix_lotser	yes	no
			cncix_ref	yes	no
			cncix_auth	yes	no
	oid_cncix_mstr	yes	oid_cncix_mstr	yes	no