aurora_standard.sticstvr

Field	Type	Null	Key	Extra
hierarchy_no	bigint(20) unsigned	NO	PRI	auto_increment
item_code	varchar(20)	YES	MUL
warehouse_code	varchar(10)	YES
quantity	decimal(10,2)	YES
cost	decimal(12,2)	YES
vend_code	varchar(6)	YES
rec_doc_no	int(11)	YES
rec_line_no	smallint(6)	YES

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
_1188.inventory	inv_cost
_1218.inventory	inv_cost
_1548.inventory	inv_cost
_435.inventory	inv_cost
_436.inventory	inv_cost
_436_archive_testing.inventory	inv_cost
_437.inventory	inv_cost
_8.inventory	inv_cost
_81.inventory	inv_cost
_999.inventory	inv_cost
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

quantity

Table	Column
HSPI_CURES2015_B1.cbos_inventory_log	current_quantity
HSPI_Central_Hospital.cbos_inventory_log	current_quantity
HSPI_Dewitt.cbos_inventory_log	current_quantity
HSPI_Fulton.cbos_inventory_log	current_quantity
HSPI_Inferno.cbos_inventory_log	current_quantity
HSPI_MU2015_E1.cbos_inventory_log	current_quantity
HSPI_MU2015_G2.cbos_inventory_log	current_quantity
HSPI_MU2015_G9.cbos_inventory_log	current_quantity
HSPI_Sandbox.cbos_inventory_log	current_quantity
HSPI_Summit_General.cbos_inventory_log	current_quantity
HSPI_United_Physicians.cbos_inventory_log	current_quantity
MPI.cbos_inventory_log	current_quantity
_1.charts_medications	cm_quantity
_1.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_1.patients_medications	pms_quantity
_1.patients_prescriptions	prx_quantity
_1188.charts_medications	cm_quantity
_1188.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_1188.patients_medications	pms_quantity
_1188.patients_prescriptions	prx_quantity
_1218.charts_medications	cm_quantity
_1218.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_1218.patients_medications	pms_quantity
_1218.patients_prescriptions	prx_quantity
_1548.charts_medications	cm_quantity
_1548.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_1548.patients_medications	pms_quantity
_1548.patients_prescriptions	prx_quantity
_435.charts_medications	cm_quantity
_435.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_435.patients_medications	pms_quantity
_435.patients_prescriptions	prx_quantity
_436.charts_medications	cm_quantity
_436.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_436.patients_medications	pms_quantity
_436.patients_prescriptions	prx_quantity
_436_archive_testing.charts_medications	cm_quantity
_436_archive_testing.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_436_archive_testing.patients_medications	pms_quantity
_436_archive_testing.patients_prescriptions	prx_quantity
_437.charts_medications	cm_quantity
_437.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_437.patients_medications	pms_quantity
_437.patients_prescriptions	prx_quantity
_8.charts_medications	cm_quantity
_8.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_8.patients_medications	pms_quantity
_8.patients_prescriptions	prx_quantity
_81.charts_medications	cm_quantity
_81.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_81.patients_medications	pms_quantity
_81.patients_prescriptions	prx_quantity
_999.charts_medications	cm_quantity
_999.encounters_payments_edi_logs_cpt_codes	epelcc_quantity
_999.patients_medications	pms_quantity
_999.patients_prescriptions	prx_quantity
aurora_standard.hl7ft1	trans_quantity
common.test_codes_results_cpts	tcrc_quantity

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

vend_code

Table	Column
aurora_standard.vndxref	old_vend_code
aurora_standard.vndxref	new_vend_code