aurora_standard.stiactvd

Field	Type	Null	Key	Extra
orig_journal	varchar(2)	YES	MUL
doc_no	int(11)	YES	MUL
line_no	smallint(6)	YES
item_code	varchar(20)	YES	MUL
warehouse_code	varchar(10)	YES
qty	decimal(10,2)	YES
cost	decimal(12,2)	YES
price	decimal(12,2)	YES
comm_code	varchar(6)	YES
item_class	varchar(6)	YES
in_statistics	varchar(1)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

cost

Table	Column
HSPI_Bastrop.examples	example_cost
HSPI_CURES2015_B1.examples	example_cost
HSPI_Central_Hospital.examples	example_cost
HSPI_Dewitt.examples	example_cost
HSPI_Fulton.examples	example_cost
HSPI_Inferno.examples	example_cost
HSPI_MU2015_E1.examples	example_cost
HSPI_MU2015_G2.examples	example_cost
HSPI_MU2015_G9.examples	example_cost
HSPI_Sandbox.examples	example_cost
HSPI_Summit_General.examples	example_cost
HSPI_United_Physicians.examples	example_cost
MPI.examples	example_cost
_1.inventory	inv_cost
_1.labs_orders	lo_cost_price
_1188.inventory	inv_cost
_1188.labs_orders	lo_cost_price
_1218.inventory	inv_cost
_1218.labs_orders	lo_cost_price
_1548.inventory	inv_cost
_1548.labs_orders	lo_cost_price
_435.inventory	inv_cost
_435.labs_orders	lo_cost_price
_436.inventory	inv_cost
_436.labs_orders	lo_cost_price
_436_archive_testing.inventory	inv_cost
_436_archive_testing.labs_orders	lo_cost_price
_437.inventory	inv_cost
_437.labs_orders	lo_cost_price
_8.inventory	inv_cost
_8.labs_orders	lo_cost_price
_81.inventory	inv_cost
_81.labs_orders	lo_cost_price
_999.inventory	inv_cost
_999.labs_orders	lo_cost_price
aurora_standard.audpchgd	direct_cost
aurora_standard.audpchgd	indirect_cost
aurora_standard.audroomd	direct_cost
aurora_standard.audroomd	indirect_cost
aurora_standard.axlscdm	unit_cost
aurora_standard.axlscdm	other_cost
aurora_standard.c7cdm	unit_cost
aurora_standard.c8cdm	unit_cost
aurora_standard.c8cdm	other_cost
aurora_standard.chmadmtr	tot_cost
aurora_standard.chmmbc41	oth_carrier_cost
aurora_standard.chmmhbcd	oth_cost
aurora_standard.chmnetwd	implants_cost
aurora_standard.chmpchgd	direct_cost
aurora_standard.chmpchgd	indirect_cost
aurora_standard.chmprchd	last_cost
aurora_standard.chmpricc	unit_cost
aurora_standard.chmpricc	other_cost
aurora_standard.chmroomd	direct_cost
aurora_standard.chmroomd	indirect_cost
aurora_standard.chpinsrc	insrv_cost
aurora_standard.chpvacid	vac_phy_cost
aurora_standard.chsfacon	asset_cost
aurora_standard.gary13	calc_avg_unit_cost
aurora_standard.gary14	calc_avg_unit_cost
aurora_standard.gary2	avg_unit_cost
aurora_standard.glsprice	unit_cost
aurora_standard.glsprice	other_cost
aurora_standard.hl7dg1	outlier_cost
aurora_standard.hl7ft1	unit_cost
aurora_standard.item1	unit_cost
aurora_standard.ohonet	asst_cost
aurora_standard.pharm1	pricc_unit_cost
aurora_standard.stfasstr	asset_cost
aurora_standard.stfmtncd	actual_cost
aurora_standard.stiadjmd	adj_cost
aurora_standard.stiinvtr	contract_cost
aurora_standard.stilocar	avg_unit_cost
aurora_standard.stilocar	purch_unit_cost
aurora_standard.stilocar	last_cost
aurora_standard.stipurcd	purch_unit_cost
aurora_standard.stmaintd	maint_est_cost
aurora_standard.stmaintd	maint_actual_cost
aurora_standard.stmmastr	purch_cost
aurora_standard.stoshipd	item_cost
aurora_standard.sturated	from_cost
aurora_standard.sturated	to_cost
aurora_standard.sturtrnd	return_cost
aurora_standard.tmplocar	avg_unit_cost
aurora_standard.tmplocar	purch_unit_cost
aurora_standard.tmplocar	last_cost
aurora_standard.ttiinvtr	contract_cost

price

Table	Column
_1.clients_fee_schedules_map	cfsm_price
_1.cpt_analysis_codes	cac_price
_1.hl7_orders	ord_lo_list_price
_1.labs_orders	lo_list_price
_1.labs_orders_clients_pricing	locp_client_price
_1188.clients_fee_schedules_map	cfsm_price
_1188.cpt_analysis_codes	cac_price
_1188.hl7_orders	ord_lo_list_price
_1188.labs_orders	lo_list_price
_1188.labs_orders_clients_pricing	locp_client_price
_1218.clients_fee_schedules_map	cfsm_price
_1218.cpt_analysis_codes	cac_price
_1218.hl7_orders	ord_lo_list_price
_1218.labs_orders	lo_list_price
_1218.labs_orders_clients_pricing	locp_client_price
_1548.clients_fee_schedules_map	cfsm_price
_1548.cpt_analysis_codes	cac_price
_1548.hl7_orders	ord_lo_list_price
_1548.labs_orders	lo_list_price
_1548.labs_orders_clients_pricing	locp_client_price
_435.clients_fee_schedules_map	cfsm_price
_435.cpt_analysis_codes	cac_price
_435.hl7_orders	ord_lo_list_price
_435.labs_orders	lo_list_price
_435.labs_orders_clients_pricing	locp_client_price
_436.clients_fee_schedules_map	cfsm_price
_436.cpt_analysis_codes	cac_price
_436.hl7_orders	ord_lo_list_price
_436.labs_orders	lo_list_price
_436.labs_orders_clients_pricing	locp_client_price
_436_archive_testing.clients_fee_schedules_map	cfsm_price
_436_archive_testing.cpt_analysis_codes	cac_price
_436_archive_testing.hl7_orders	ord_lo_list_price
_436_archive_testing.labs_orders	lo_list_price
_436_archive_testing.labs_orders_clients_pricing	locp_client_price
_437.clients_fee_schedules_map	cfsm_price
_437.cpt_analysis_codes	cac_price
_437.hl7_orders	ord_lo_list_price
_437.labs_orders	lo_list_price
_437.labs_orders_clients_pricing	locp_client_price
_8.clients_fee_schedules_map	cfsm_price
_8.cpt_analysis_codes	cac_price
_8.hl7_orders	ord_lo_list_price
_8.labs_orders	lo_list_price
_8.labs_orders_clients_pricing	locp_client_price
_81.clients_fee_schedules_map	cfsm_price
_81.cpt_analysis_codes	cac_price
_81.hl7_orders	ord_lo_list_price
_81.labs_orders	lo_list_price
_81.labs_orders_clients_pricing	locp_client_price
_999.clients_fee_schedules_map	cfsm_price
_999.cpt_analysis_codes	cac_price
_999.hl7_orders	ord_lo_list_price
_999.labs_orders	lo_list_price
_999.labs_orders_clients_pricing	locp_client_price
aurora_standard.chrdrugc	awp_unit_price
aurora_standard.chrdrugc	dp_unit_price
aurora_standard.chrrater	minimum_price
aurora_standard.chrrater	round_price
aurora_standard.gary13	sum_price
aurora_standard.gary2	sum_net_price
aurora_standard.items	total_price
aurora_standard.lngdrg	wac_cur_price
aurora_standard.lngdrg	wac_cur_unit_price
aurora_standard.lngdrg	awp_cur_price
aurora_standard.lngdrg	awp_cur_unit_price
aurora_standard.lngdrg	dp_cur_price
aurora_standard.lngdrg	dp_cur_unit_price
aurora_standard.lngdrg	ful_cur_price
aurora_standard.lngdrg	ful_cur_unit_price
aurora_standard.lngdrg	srp_cur_price
aurora_standard.lngdrg	srp_cur_unit_price
aurora_standard.stiinvtr	market_price
aurora_standard.stock	unit_price
aurora_standard.stoshipd	orig_price
aurora_standard.stoshipd	retail_price
aurora_standard.stuabcd	orig_price
aurora_standard.stuabcd	printback_price
aurora_standard.stuinvcd	net_price
aurora_standard.stultypr	update_price
aurora_standard.stuordrd	net_price
aurora_standard.stuprche	old_price
aurora_standard.stuprche	new_price
aurora_standard.ttiinvtr	market_price
common.test_codes	tco_x_price
common.users_permissions	upr_fee_schedule_override_price

doc_no

Table	Column
aurora_standard.audpadjd	py_doc_no
aurora_standard.chmgltrc	ar_doc_no
aurora_standard.chmgltrc	rm_doc_no
aurora_standard.chmgltrc	ip_doc_no
aurora_standard.chmgltrc	op_doc_no
aurora_standard.chmgltrc	r3_doc_no
aurora_standard.chmgltrc	r4_doc_no
aurora_standard.chmgltrc	cr_doc_no
aurora_standard.chmgltrc	aj_doc_no
aurora_standard.chmgltrc	nr_doc_no
aurora_standard.chmgltrc	nc_doc_no
aurora_standard.chmgltrc	fc_doc_no
aurora_standard.chmpadjd	py_doc_no
aurora_standard.chmrefnd	check_doc_no
aurora_standard.discounts	inv_doc_no
aurora_standard.odhpaydd	py_doc_no
aurora_standard.odhpayid	py_doc_no
aurora_standard.odhpayod	py_doc_no
aurora_standard.odhpayre	py_doc_no
aurora_standard.stfcntrc	fa_doc_no
aurora_standard.stgcntrc	genjrn_doc_no
aurora_standard.stgcntrc	stdent_doc_no
aurora_standard.sticstvr	rec_doc_no
aurora_standard.stoinvce	inv_doc_no
aurora_standard.stoordre	orig_doc_no
aurora_standard.stoordre	inv_doc_no
aurora_standard.stoshipd	inv_doc_no
aurora_standard.stoshipd	po_doc_no
aurora_standard.stpactvd	inv_doc_no
aurora_standard.stpactvv	inv_doc_no
aurora_standard.stpcashd	inv_doc_no
aurora_standard.stpcntrc	ap_doc_no
aurora_standard.stpcntrc	cd_doc_no
aurora_standard.stpvoidr	chk_doc_no
aurora_standard.stractvd	inv_doc_no
aurora_standard.stractvv	inv_doc_no
aurora_standard.strcashd	inv_doc_no
aurora_standard.strcntrc	ar_doc_no
aurora_standard.strcntrc	cr_doc_no
aurora_standard.stucntrc	req_doc_no
aurora_standard.stucntrc	po_doc_no
aurora_standard.stucntrc	rec_doc_no
aurora_standard.stucntrc	inv_doc_no
aurora_standard.stucntrc	ret_doc_no
aurora_standard.stuinvcd	inv_doc_no
aurora_standard.stuinvcd	po_doc_no
aurora_standard.stuinvce	inv_doc_no
aurora_standard.stuinvce	po_doc_no
aurora_standard.stuordrd	order_doc_no
aurora_standard.stuordre	orig_doc_no
aurora_standard.stuordre	order_doc_no
aurora_standard.stuprche	inv_doc_no
aurora_standard.sturectd	rec_doc_no
aurora_standard.sturectd	po_doc_no
aurora_standard.sturecte	rec_doc_no
aurora_standard.sturecte	po_doc_no
aurora_standard.sturqstd	po_doc_no
aurora_standard.sturqstd	ref_doc_no
aurora_standard.sturtrnd	ret_doc_no
aurora_standard.sturtrnd	po_doc_no
aurora_standard.sturtrnd	rec_doc_no
aurora_standard.sturtrnd	inv_doc_no
aurora_standard.sturtrne	ret_doc_no
aurora_standard.stxmtaxd	inv_doc_no
aurora_standard.stxtaxld	inv_doc_no
aurora_standard.stycdedd	py_doc_no
aurora_standard.stycincd	py_doc_no
aurora_standard.stycntrc	py_doc_no
aurora_standard.stypayar	py_doc_no
aurora_standard.stypddrd	py_doc_no
aurora_standard.styvoide	pay_doc_no

item_code

Table	Column
aurora_standard.chmbitmd	vend_item_code
aurora_standard.chmschgd	vend_item_code
aurora_standard.glstrack	p_item_code
aurora_standard.glstrack	m_item_code
aurora_standard.icactvv	vend_item_code
aurora_standard.stiixref	vend_item_code
aurora_standard.stmaintd	maint_po_item_code
aurora_standard.stuctlgd	vend_item_code
aurora_standard.sturqstd	vend_item_code
aurora_standard.tmpctlgd	vend_item_code
aurora_standard.tmplvl2	vend_item_code
aurora_standard.tmplvl3	vend_item_code
aurora_standard.tmpparlvl	vend_item_code

line_no

Table	Column
aurora_standard.chmmbc41	service_line_no
aurora_standard.sticstvr	rec_line_no
aurora_standard.stmnoted	note_line_no
aurora_standard.stmwarrd	warr_line_no
aurora_standard.stoordrd	kit_line_no
aurora_standard.stuinvcd	inv_line_no
aurora_standard.stuinvcd	po_line_no
aurora_standard.stuordrd	order_line_no
aurora_standard.stuprche	inv_line_no
aurora_standard.sturectd	rec_line_no
aurora_standard.sturectd	po_line_no
aurora_standard.sturqstd	po_line_no
aurora_standard.sturqstd	ref_line_no
aurora_standard.sturtrnd	ret_line_no
aurora_standard.sturtrnd	po_line_no
aurora_standard.sturtrnd	rec_line_no
aurora_standard.sturtrnd	inv_line_no

qty

Table	Column
aurora_standard.chmpricc	ndc_qty
aurora_standard.chrdrugc	pack_qty
aurora_standard.gary13	sum_qty
aurora_standard.gary2	sum_recv_qty
aurora_standard.item1	ordr_qty
aurora_standard.sthcadjd	adj_qty
aurora_standard.sthcadjd	count_qty
aurora_standard.stiadjmd	adj_qty
aurora_standard.sticadjd	adj_qty
aurora_standard.sticadjd	count_qty
aurora_standard.stiinvtr	case_qty
aurora_standard.stilocar	last_qty
aurora_standard.stilocar	consign_qty
aurora_standard.stipurcd	purch_qty
aurora_standard.stiselld	sell_qty
aurora_standard.stiserla	lot_qty
aurora_standard.stiserld	lot_qty
aurora_standard.stiserle	lot_qty
aurora_standard.stitrand	tran_qty
aurora_standard.stoordrd	ordr_qty
aurora_standard.stoordrd	back_qty
aurora_standard.stoordrd	commit_qty
aurora_standard.stopricd	disc_qty
aurora_standard.stoshipd	ship_qty
aurora_standard.stoshipd	commit_qty
aurora_standard.stuctlgd	case_qty
aurora_standard.stuinvcd	cost_qty
aurora_standard.stuordrd	ordr_qty
aurora_standard.stuordrd	rlse_qty
aurora_standard.stuordrd	rjct_qty
aurora_standard.stuordrd	recv_qty
aurora_standard.stuordrd	cost_qty
aurora_standard.stuordrd	acpt_qty
aurora_standard.stuordrd	exp_rec_qty
aurora_standard.stuordrd	exp_inv_qty
aurora_standard.stuprche	cost_qty
aurora_standard.stupricd	disc_qty
aurora_standard.sturectd	recv_qty
aurora_standard.sturectd	rjct_qty
aurora_standard.sturqstd	ordr_qty
aurora_standard.sturqstd	recv_qty
aurora_standard.sturqstd	case_qty
aurora_standard.sturtrnd	return_qty
aurora_standard.tmpctlgd	case_qty
aurora_standard.tmplocar	last_qty
aurora_standard.tmplocar	consign_qty
aurora_standard.tmplvl2	consign_qty
aurora_standard.tmplvl3	consign_qty
aurora_standard.tmpparlvl	consign_qty
aurora_standard.ttiinvtr	case_qty

item_class

Table	Column
aurora_standard.chrcntrc	rx_item_class

comm_code

Table	Column
aurora_standard.chrdrugc	default_comm_code