aurora_standard.tmpctlgd

Field	Type	Null	Key	Extra
vendor_code	varchar(6)	YES
item_code	varchar(20)	YES
cost	decimal(12,0)	YES
vend_item_code	varchar(20)	YES
primary_vendor	varchar(1)	YES
currency_code	varchar(6)	YES
purch_unit	varchar(2)	YES
case_qty	int(11)	YES
brand_name	varchar(10)	YES
active_flag	varchar(1)	YES
manufact_no	varchar(30)	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
_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

brand_name

Table	Column
_1.inventory	inv_brand_name
_1.patients_immunizations	pim_brand_name
_1.patients_implantable_devices	pid_brand_name
_1188.inventory	inv_brand_name
_1188.patients_immunizations	pim_brand_name
_1188.patients_implantable_devices	pid_brand_name
_1218.inventory	inv_brand_name
_1218.patients_immunizations	pim_brand_name
_1218.patients_implantable_devices	pid_brand_name
_1548.inventory	inv_brand_name
_1548.patients_immunizations	pim_brand_name
_1548.patients_implantable_devices	pid_brand_name
_435.inventory	inv_brand_name
_435.patients_immunizations	pim_brand_name
_435.patients_implantable_devices	pid_brand_name
_436.inventory	inv_brand_name
_436.patients_immunizations	pim_brand_name
_436.patients_implantable_devices	pid_brand_name
_436_archive_testing.inventory	inv_brand_name
_436_archive_testing.patients_immunizations	pim_brand_name
_436_archive_testing.patients_implantable_devices	pid_brand_name
_437.inventory	inv_brand_name
_437.patients_immunizations	pim_brand_name
_437.patients_implantable_devices	pid_brand_name
_8.inventory	inv_brand_name
_8.patients_immunizations	pim_brand_name
_8.patients_implantable_devices	pid_brand_name
_81.inventory	inv_brand_name
_81.patients_immunizations	pim_brand_name
_81.patients_implantable_devices	pid_brand_name
_999.inventory	inv_brand_name
_999.patients_immunizations	pim_brand_name
_999.patients_implantable_devices	pid_brand_name
common.drugs	drg_brand_name
common.vaccines_manufacturers_map	vmm_brand_name

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.tmplvl2	vend_item_code
aurora_standard.tmplvl3	vend_item_code
aurora_standard.tmpparlvl	vend_item_code

vendor_code

Table	Column
aurora_standard.hhtclokd	inv_vendor_code
aurora_standard.stmaintd	maint_vendor_code

currency_code

Table	Column
aurora_standard.stxdcrtr	from_currency_code
aurora_standard.stxdcrtr	to_currency_code
aurora_standard.stxpcrtr	from_currency_code
aurora_standard.stxpcrtr	to_currency_code