aurora_standard.tmplocar

Field	Type	Null	Key	Extra
item_code	varchar(20)	YES
warehouse_code	varchar(10)	YES
line_no	smallint(6)	YES
count_cycle	varchar(1)	YES
purchase_date	date	YES
count_date	date	YES
sold_date	date	YES
obsolete	varchar(1)	YES
inactive_date	date	YES
lst_act_date	date	YES
loc_aisle	varchar(4)	YES
loc_row	varchar(3)	YES
loc_bin	varchar(3)	YES
stock_location	varchar(12)	YES
avg_unit_cost	decimal(12,0)	YES
purch_unit_cost	decimal(12,0)	YES
last_cost	decimal(12,0)	YES
comm_code	varchar(6)	YES
price	decimal(12,0)	YES
allow_bo	varchar(1)	YES
taxable	varchar(1)	YES
terms_disc	varchar(1)	YES
trade_disc	varchar(1)	YES
vend_code	varchar(6)	YES
vend_prod_no	varchar(20)	YES
abc_code	varchar(1)	YES
reorder_point	decimal(10,0)	YES
qty_reorder	decimal(10,0)	YES
safety_stock	decimal(10,0)	YES
safety_factor	decimal(6,0)	YES
qty_on_hand	decimal(10,0)	YES
last_qty	decimal(10,0)	YES
stk_out_date	date	YES
seasonal	varchar(1)	YES
avg_ld_tm	decimal(5,2)	YES
lst_ld_tm	smallint(6)	YES
pri_ld_tm	smallint(6)	YES
freez_flag	varchar(1)	YES
freez_date	date	YES
freez_expir	date	YES
consign_qty	decimal(10,0)	YES
usage_rate	decimal(10,0)	YES
brand_name	varchar(10)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

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_cost_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_cost_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_cost_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_cost_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_cost_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_cost_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_cost_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_cost_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_cost_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_cost_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_cost_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

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

inactive_date

Table	Column
_1.patients_allergies	palg_inactive_date
_1188.patients_allergies	palg_inactive_date
_1218.patients_allergies	palg_inactive_date
_1548.patients_allergies	palg_inactive_date
_435.patients_allergies	palg_inactive_date
_436.patients_allergies	palg_inactive_date
_436_archive_testing.patients_allergies	palg_inactive_date
_437.patients_allergies	palg_inactive_date
_8.patients_allergies	palg_inactive_date
_81.patients_allergies	palg_inactive_date
_999.patients_allergies	palg_inactive_date

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

comm_code

Table	Column
aurora_standard.chrdrugc	default_comm_code

avg_unit_cost

Table	Column
aurora_standard.gary13	calc_avg_unit_cost
aurora_standard.gary14	calc_avg_unit_cost

taxable

Table	Column
aurora_standard.oddpayre	inc_taxable
aurora_standard.odhpayre	inc_taxable
aurora_standard.stpinvce	internet_taxable
aurora_standard.stpopend	internet_taxable
aurora_standard.stuinvce	internet_taxable
aurora_standard.stypayre	inc_taxable

obsolete

Table	Column
aurora_standard.stiinvtr	item_obsolete
aurora_standard.ttiinvtr	item_obsolete

vend_code

Table	Column
aurora_standard.vndxref	old_vend_code
aurora_standard.vndxref	new_vend_code