aurora_standard.stoordrd

Field	Type	Null	Key	Extra
doc_no	int(11)	YES	MUL
line_no	smallint(6)	YES
kit_group	smallint(6)	YES
kit_line_no	smallint(6)	YES
last_ship_line	smallint(6)	YES
line_type	varchar(3)	YES
like_type	varchar(3)	YES
hi_stage	varchar(3)	YES
lo_stage	varchar(3)	YES
cm_dm_reason	varchar(3)	YES
our_po_no	varchar(10)	YES
sls_psn_code	varchar(6)	YES
warehouse_code	varchar(10)	YES
item_code	varchar(20)	YES
desc1	varchar(30)	YES
desc2	varchar(30)	YES
alias_code	varchar(20)	YES
vend_code	varchar(6)	YES
interchanged	varchar(1)	YES
serialized	varchar(1)	YES
td_disc_allowed	varchar(1)	YES
tax	varchar(1)	YES
ordr_qty	decimal(10,0)	YES
back_qty	decimal(10,0)	YES
commit_qty	decimal(10,0)	YES
sell_unit	varchar(2)	YES
unit_factor	decimal(6,0)	YES
price	decimal(12,0)	YES
price_code	int(11)	YES
tax_amount	decimal(12,0)	YES
net_amount	decimal(12,0)	YES
ship_weight	decimal(10,0)	YES
inv_acct	int(11)	YES
inv_dept	varchar(3)	YES
sls_acct	int(11)	YES
sls_dept	varchar(3)	YES
cog_acct	int(11)	YES
cog_dept	varchar(3)	YES
intl_lic_no	varchar(30)	YES
price_lock	varchar(1)	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

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

tax

Table	Column
aurora_standard.chmemrxd	sales_tax
aurora_standard.chmutah3	att_phy_tax
aurora_standard.chmutah3	sur_phy_tax
aurora_standard.chmutah3	oth_sur_tax
aurora_standard.chmutah3	ren_phy_tax
aurora_standard.chmutah3	ref_phy_tax
aurora_standard.stpcntrc	disc_tax
aurora_standard.strcntrc	disc_tax
aurora_standard.stxmtaxr	include_tax
aurora_standard.styccovr	pre_tax

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

desc1

Table	Column
aurora_standard.chrschdr	label_desc1
aurora_standard.chshotlr	prob_desc1
aurora_standard.chsmodsr	prob_desc1
aurora_standard.stmmastr	warr_desc1
aurora_standard.styocovc	coverage_desc1
aurora_standard.styosafc	safe_desc1

desc2

Table	Column
aurora_standard.chrschdr	label_desc2
aurora_standard.chshotlr	prob_desc2
aurora_standard.chsmodsr	prob_desc2
aurora_standard.stmaintd	maint_desc2
aurora_standard.stmmastr	warr_desc2
aurora_standard.sturondc	rounding_desc2
aurora_standard.stymesgc	message_desc2
aurora_standard.styocovc	coverage_desc2
aurora_standard.styosafc	safe_desc2

unit_factor

Table	Column
aurora_standard.gary1	calc_unit_factor
aurora_standard.gary2	calc_unit_factor

kit_group

Table	Column
aurora_standard.stoordre	next_kit_group

inv_acct

Table	Column
aurora_standard.sturtrnd	gl_inv_acct

vend_code

Table	Column
aurora_standard.vndxref	old_vend_code
aurora_standard.vndxref	new_vend_code