aurora_standard.sturqstd

Field	Type	Null	Key	Extra
doc_no	int(11)	YES	MUL
line_no	smallint(6)	YES
line_type	varchar(3)	YES
line_stage	varchar(3)	YES
item_code	varchar(20)	YES
desc1	varchar(30)	YES
desc2	varchar(30)	YES
unit	varchar(2)	YES
ordr_qty	decimal(12,2)	YES
instruct_code	varchar(6)	YES
reference_no	varchar(13)	YES
whse_shipto	varchar(10)	YES
whse_billto	varchar(10)	YES
vend_code	varchar(6)	YES
requestor_code	varchar(6)	YES
request_no	varchar(10)	YES
request_date	date	YES
authorization_code	varchar(6)	YES
acct_no	int(11)	YES
req_post_no	int(11)	YES
po_doc_no	int(11)	YES
po_line_no	smallint(6)	YES
recv_qty	decimal(12,2)	YES
ref_type	varchar(2)	YES
ref_doc_no	int(11)	YES
ref_line_no	int(11)	YES
ref_ship_no	int(11)	YES
vend_item_code	varchar(20)	YES
case_qty	int(11)	YES
cost	decimal(12,2)	YES
bus_name	varchar(30)	YES
catalog_info	varchar(30)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

unit

Table	Column
HSPI_Bastrop.charge_master_codes	ndcQuantity_unit
HSPI_Bastrop.claim_items	quantity_unit
HSPI_Bastrop.claim_supporting_info	valueQuantity_unit
HSPI_Bastrop.conditions	onsetAge_unit
HSPI_Bastrop.examples	exampleQuantity_unit
HSPI_Bastrop.immunizations	quantity_unit
HSPI_Bastrop.medication_requests	dosage_quantity_unit
HSPI_Bastrop.medication_requests	dispense_quantity_unit
HSPI_Bastrop.medication_requests	dispense_duration_unit
HSPI_Bastrop.medications	quantity_unit
HSPI_Bastrop.observations	quantity_unit
HSPI_Bastrop.observations	range_low_unit
HSPI_Bastrop.observations	range_high_unit
HSPI_Bastrop.observations_components	quantity_unit
HSPI_Bastrop.observations_components	range_low_unit
HSPI_Bastrop.observations_components	range_high_unit
HSPI_Bastrop.specimens	quantity_unit
HSPI_CURES2015_B1.charge_master_codes	ndcQuantity_unit
HSPI_CURES2015_B1.claim_items	quantity_unit
HSPI_CURES2015_B1.claim_supporting_info	valueQuantity_unit
HSPI_CURES2015_B1.conditions	onsetAge_unit
HSPI_CURES2015_B1.examples	exampleQuantity_unit
HSPI_CURES2015_B1.immunizations	quantity_unit
HSPI_CURES2015_B1.medication_requests	dosage_quantity_unit
HSPI_CURES2015_B1.medication_requests	dispense_quantity_unit
HSPI_CURES2015_B1.medication_requests	dispense_duration_unit
HSPI_CURES2015_B1.medications	quantity_unit
HSPI_CURES2015_B1.observations	quantity_unit
HSPI_CURES2015_B1.observations	range_low_unit
HSPI_CURES2015_B1.observations	range_high_unit
HSPI_CURES2015_B1.observations_components	quantity_unit
HSPI_CURES2015_B1.observations_components	range_low_unit
HSPI_CURES2015_B1.observations_components	range_high_unit
HSPI_CURES2015_B1.specimens	quantity_unit
HSPI_Central_Hospital.charge_master_codes	ndcQuantity_unit
HSPI_Central_Hospital.claim_items	quantity_unit
HSPI_Central_Hospital.claim_supporting_info	valueQuantity_unit
HSPI_Central_Hospital.conditions	onsetAge_unit
HSPI_Central_Hospital.examples	exampleQuantity_unit
HSPI_Central_Hospital.immunizations	quantity_unit
HSPI_Central_Hospital.medication_requests	dosage_quantity_unit
HSPI_Central_Hospital.medication_requests	dispense_quantity_unit
HSPI_Central_Hospital.medication_requests	dispense_duration_unit
HSPI_Central_Hospital.medications	quantity_unit
HSPI_Central_Hospital.observations	quantity_unit
HSPI_Central_Hospital.observations	range_low_unit
HSPI_Central_Hospital.observations	range_high_unit
HSPI_Central_Hospital.observations_components	quantity_unit
HSPI_Central_Hospital.observations_components	range_low_unit
HSPI_Central_Hospital.observations_components	range_high_unit
HSPI_Central_Hospital.specimens	quantity_unit
HSPI_Dewitt.charge_master_codes	ndcQuantity_unit
HSPI_Dewitt.claim_items	quantity_unit
HSPI_Dewitt.claim_supporting_info	valueQuantity_unit
HSPI_Dewitt.conditions	onsetAge_unit
HSPI_Dewitt.examples	exampleQuantity_unit
HSPI_Dewitt.immunizations	quantity_unit
HSPI_Dewitt.medication_requests	dosage_quantity_unit
HSPI_Dewitt.medication_requests	dispense_quantity_unit
HSPI_Dewitt.medication_requests	dispense_duration_unit
HSPI_Dewitt.medications	quantity_unit
HSPI_Dewitt.observations	quantity_unit
HSPI_Dewitt.observations	range_low_unit
HSPI_Dewitt.observations	range_high_unit
HSPI_Dewitt.observations_components	quantity_unit
HSPI_Dewitt.observations_components	range_low_unit
HSPI_Dewitt.observations_components	range_high_unit
HSPI_Dewitt.specimens	quantity_unit
HSPI_Fulton.charge_master_codes	ndcQuantity_unit
HSPI_Fulton.claim_items	quantity_unit
HSPI_Fulton.claim_supporting_info	valueQuantity_unit
HSPI_Fulton.conditions	onsetAge_unit
HSPI_Fulton.examples	exampleQuantity_unit
HSPI_Fulton.immunizations	quantity_unit
HSPI_Fulton.medication_requests	dosage_quantity_unit
HSPI_Fulton.medication_requests	dispense_quantity_unit
HSPI_Fulton.medication_requests	dispense_duration_unit
HSPI_Fulton.medications	quantity_unit
HSPI_Fulton.observations	quantity_unit
HSPI_Fulton.observations	range_low_unit
HSPI_Fulton.observations	range_high_unit
HSPI_Fulton.observations_components	quantity_unit
HSPI_Fulton.observations_components	range_low_unit
HSPI_Fulton.observations_components	range_high_unit
HSPI_Fulton.specimens	quantity_unit
HSPI_Inferno.charge_master_codes	ndcQuantity_unit
HSPI_Inferno.claim_items	quantity_unit
HSPI_Inferno.claim_supporting_info	valueQuantity_unit
HSPI_Inferno.conditions	onsetAge_unit
HSPI_Inferno.examples	exampleQuantity_unit
HSPI_Inferno.immunizations	quantity_unit
HSPI_Inferno.medication_requests	dosage_quantity_unit
HSPI_Inferno.medication_requests	dispense_quantity_unit
HSPI_Inferno.medication_requests	dispense_duration_unit
HSPI_Inferno.medications	quantity_unit
HSPI_Inferno.observations	quantity_unit
HSPI_Inferno.observations	range_low_unit
HSPI_Inferno.observations	range_high_unit
HSPI_Inferno.observations_components	quantity_unit
HSPI_Inferno.observations_components	range_low_unit
HSPI_Inferno.observations_components	range_high_unit
HSPI_Inferno.specimens	quantity_unit
HSPI_MU2015_E1.charge_master_codes	ndcQuantity_unit
HSPI_MU2015_E1.claim_items	quantity_unit
HSPI_MU2015_E1.claim_supporting_info	valueQuantity_unit
HSPI_MU2015_E1.conditions	onsetAge_unit
HSPI_MU2015_E1.examples	exampleQuantity_unit
HSPI_MU2015_E1.immunizations	quantity_unit
HSPI_MU2015_E1.medication_requests	dosage_quantity_unit
HSPI_MU2015_E1.medication_requests	dispense_quantity_unit
HSPI_MU2015_E1.medication_requests	dispense_duration_unit
HSPI_MU2015_E1.medications	quantity_unit
HSPI_MU2015_E1.observations	quantity_unit
HSPI_MU2015_E1.observations	range_low_unit
HSPI_MU2015_E1.observations	range_high_unit
HSPI_MU2015_E1.observations_components	quantity_unit
HSPI_MU2015_E1.observations_components	range_low_unit
HSPI_MU2015_E1.observations_components	range_high_unit
HSPI_MU2015_E1.specimens	quantity_unit
HSPI_MU2015_G2.charge_master_codes	ndcQuantity_unit
HSPI_MU2015_G2.claim_items	quantity_unit
HSPI_MU2015_G2.claim_supporting_info	valueQuantity_unit
HSPI_MU2015_G2.conditions	onsetAge_unit
HSPI_MU2015_G2.examples	exampleQuantity_unit
HSPI_MU2015_G2.immunizations	quantity_unit
HSPI_MU2015_G2.medication_requests	dosage_quantity_unit
HSPI_MU2015_G2.medication_requests	dispense_quantity_unit
HSPI_MU2015_G2.medication_requests	dispense_duration_unit
HSPI_MU2015_G2.medications	quantity_unit
HSPI_MU2015_G2.observations	quantity_unit
HSPI_MU2015_G2.observations	range_low_unit
HSPI_MU2015_G2.observations	range_high_unit
HSPI_MU2015_G2.observations_components	quantity_unit
HSPI_MU2015_G2.observations_components	range_low_unit
HSPI_MU2015_G2.observations_components	range_high_unit
HSPI_MU2015_G2.specimens	quantity_unit
HSPI_MU2015_G9.charge_master_codes	ndcQuantity_unit
HSPI_MU2015_G9.claim_items	quantity_unit
HSPI_MU2015_G9.claim_supporting_info	valueQuantity_unit
HSPI_MU2015_G9.conditions	onsetAge_unit
HSPI_MU2015_G9.examples	exampleQuantity_unit
HSPI_MU2015_G9.immunizations	quantity_unit
HSPI_MU2015_G9.medication_requests	dosage_quantity_unit
HSPI_MU2015_G9.medication_requests	dispense_quantity_unit
HSPI_MU2015_G9.medication_requests	dispense_duration_unit
HSPI_MU2015_G9.medications	quantity_unit
HSPI_MU2015_G9.observations	quantity_unit
HSPI_MU2015_G9.observations	range_low_unit
HSPI_MU2015_G9.observations	range_high_unit
HSPI_MU2015_G9.observations_components	quantity_unit
HSPI_MU2015_G9.observations_components	range_low_unit
HSPI_MU2015_G9.observations_components	range_high_unit
HSPI_MU2015_G9.specimens	quantity_unit
HSPI_Ness.conditions	onsetAge_unit
HSPI_Ness.immunizations	quantity_unit
HSPI_Ness.medications	quantity_unit
HSPI_Ness.observations	quantity_unit
HSPI_Ness.observations	range_low_unit
HSPI_Ness.observations	range_high_unit
HSPI_Ness.observations_components	quantity_unit
HSPI_Ness.observations_components	range_low_unit
HSPI_Ness.observations_components	range_high_unit
HSPI_Ness.specimens	quantity_unit
HSPI_Sandbox.charge_master_codes	ndcQuantity_unit
HSPI_Sandbox.claim_items	quantity_unit
HSPI_Sandbox.claim_supporting_info	valueQuantity_unit
HSPI_Sandbox.conditions	onsetAge_unit
HSPI_Sandbox.examples	exampleQuantity_unit
HSPI_Sandbox.immunizations	quantity_unit
HSPI_Sandbox.medication_requests	dosage_quantity_unit
HSPI_Sandbox.medication_requests	dispense_quantity_unit
HSPI_Sandbox.medication_requests	dispense_duration_unit
HSPI_Sandbox.medications	quantity_unit
HSPI_Sandbox.observations	quantity_unit
HSPI_Sandbox.observations	range_low_unit
HSPI_Sandbox.observations	range_high_unit
HSPI_Sandbox.observations_components	quantity_unit
HSPI_Sandbox.observations_components	range_low_unit
HSPI_Sandbox.observations_components	range_high_unit
HSPI_Sandbox.specimens	quantity_unit
HSPI_Summit_General.charge_master_codes	ndcQuantity_unit
HSPI_Summit_General.claim_items	quantity_unit
HSPI_Summit_General.claim_supporting_info	valueQuantity_unit
HSPI_Summit_General.conditions	onsetAge_unit
HSPI_Summit_General.examples	exampleQuantity_unit
HSPI_Summit_General.immunizations	quantity_unit
HSPI_Summit_General.medication_requests	dosage_quantity_unit
HSPI_Summit_General.medication_requests	dispense_quantity_unit
HSPI_Summit_General.medication_requests	dispense_duration_unit
HSPI_Summit_General.medications	quantity_unit
HSPI_Summit_General.observations	quantity_unit
HSPI_Summit_General.observations	range_low_unit
HSPI_Summit_General.observations	range_high_unit
HSPI_Summit_General.observations_components	quantity_unit
HSPI_Summit_General.observations_components	range_low_unit
HSPI_Summit_General.observations_components	range_high_unit
HSPI_Summit_General.specimens	quantity_unit
HSPI_United_Physicians.charge_master_codes	ndcQuantity_unit
HSPI_United_Physicians.claim_items	quantity_unit
HSPI_United_Physicians.claim_supporting_info	valueQuantity_unit
HSPI_United_Physicians.conditions	onsetAge_unit
HSPI_United_Physicians.examples	exampleQuantity_unit
HSPI_United_Physicians.immunizations	quantity_unit
HSPI_United_Physicians.medication_requests	dosage_quantity_unit
HSPI_United_Physicians.medication_requests	dispense_quantity_unit
HSPI_United_Physicians.medication_requests	dispense_duration_unit
HSPI_United_Physicians.medications	quantity_unit
HSPI_United_Physicians.observations	quantity_unit
HSPI_United_Physicians.observations	range_low_unit
HSPI_United_Physicians.observations	range_high_unit
HSPI_United_Physicians.observations_components	quantity_unit
HSPI_United_Physicians.observations_components	range_low_unit
HSPI_United_Physicians.observations_components	range_high_unit
HSPI_United_Physicians.specimens	quantity_unit
MPI.charge_master_codes	ndcQuantity_unit
MPI.claim_items	quantity_unit
MPI.claim_supporting_info	valueQuantity_unit
MPI.conditions	onsetAge_unit
MPI.examples	exampleQuantity_unit
MPI.immunizations	quantity_unit
MPI.medication_requests	dosage_quantity_unit
MPI.medication_requests	dispense_quantity_unit
MPI.medication_requests	dispense_duration_unit
MPI.medications	quantity_unit
MPI.observations	quantity_unit
MPI.observations	range_low_unit
MPI.observations	range_high_unit
MPI.observations_components	quantity_unit
MPI.observations_components	range_low_unit
MPI.observations_components	range_high_unit
MPI.specimens	quantity_unit
_1.charts_medications	cm_dose_unit
_1.clinical_interventions	ci_pat_age_unit
_1.encounters_soap_labels_components	eslc_unit
_1.hl7_results_obx_map	obxm_unit
_1.patients_medications	pms_dose_unit
_1.patients_prescriptions	prx_dose_unit
_1.radiology_results_test_codes_results	rrtcres_observ_unit
_1.systems_components	scmp_default_unit
_1188.charts_medications	cm_dose_unit
_1188.clinical_interventions	ci_pat_age_unit
_1188.encounters_soap_labels_components	eslc_unit
_1188.hl7_results_obx_map	obxm_unit
_1188.patients_medications	pms_dose_unit
_1188.patients_prescriptions	prx_dose_unit
_1188.radiology_results_test_codes_results	rrtcres_observ_unit
_1188.systems_components	scmp_default_unit
_1218.charts_medications	cm_dose_unit
_1218.clinical_interventions	ci_pat_age_unit
_1218.encounters_soap_labels_components	eslc_unit
_1218.hl7_results_obx_map	obxm_unit
_1218.patients_medications	pms_dose_unit
_1218.patients_prescriptions	prx_dose_unit
_1218.radiology_results_test_codes_results	rrtcres_observ_unit
_1218.systems_components	scmp_default_unit
_1548.charts_medications	cm_dose_unit
_1548.clinical_interventions	ci_pat_age_unit
_1548.encounters_soap_labels_components	eslc_unit
_1548.hl7_results_obx_map	obxm_unit
_1548.patients_medications	pms_dose_unit
_1548.patients_prescriptions	prx_dose_unit
_1548.radiology_results_test_codes_results	rrtcres_observ_unit
_1548.systems_components	scmp_default_unit
_435.charts_medications	cm_dose_unit
_435.clinical_interventions	ci_pat_age_unit
_435.encounters_soap_labels_components	eslc_unit
_435.hl7_results_obx_map	obxm_unit
_435.patients_medications	pms_dose_unit
_435.patients_prescriptions	prx_dose_unit
_435.radiology_results_test_codes_results	rrtcres_observ_unit
_435.systems_components	scmp_default_unit
_436.charts_medications	cm_dose_unit
_436.clinical_interventions	ci_pat_age_unit
_436.encounters_soap_labels_components	eslc_unit
_436.hl7_results_obx_map	obxm_unit
_436.patients_medications	pms_dose_unit
_436.patients_prescriptions	prx_dose_unit
_436.radiology_results_test_codes_results	rrtcres_observ_unit
_436.systems_components	scmp_default_unit
_436_archive_testing.charts_medications	cm_dose_unit
_436_archive_testing.clinical_interventions	ci_pat_age_unit
_436_archive_testing.encounters_soap_labels_components	eslc_unit
_436_archive_testing.hl7_results_obx_map	obxm_unit
_436_archive_testing.patients_medications	pms_dose_unit
_436_archive_testing.patients_prescriptions	prx_dose_unit
_436_archive_testing.radiology_results_test_codes_results	rrtcres_observ_unit
_436_archive_testing.systems_components	scmp_default_unit
_437.charts_medications	cm_dose_unit
_437.clinical_interventions	ci_pat_age_unit
_437.encounters_soap_labels_components	eslc_unit
_437.hl7_results_obx_map	obxm_unit
_437.patients_medications	pms_dose_unit
_437.patients_prescriptions	prx_dose_unit
_437.radiology_results_test_codes_results	rrtcres_observ_unit
_437.systems_components	scmp_default_unit
_8.charts_medications	cm_dose_unit
_8.clinical_interventions	ci_pat_age_unit
_8.encounters_soap_labels_components	eslc_unit
_8.hl7_results_obx_map	obxm_unit
_8.patients_medications	pms_dose_unit
_8.patients_prescriptions	prx_dose_unit
_8.radiology_results_test_codes_results	rrtcres_observ_unit
_8.systems_components	scmp_default_unit
_81.charts_medications	cm_dose_unit
_81.clinical_interventions	ci_pat_age_unit
_81.encounters_soap_labels_components	eslc_unit
_81.hl7_results_obx_map	obxm_unit
_81.patients_medications	pms_dose_unit
_81.patients_prescriptions	prx_dose_unit
_81.radiology_results_test_codes_results	rrtcres_observ_unit
_81.systems_components	scmp_default_unit
_999.charts_medications	cm_dose_unit
_999.clinical_interventions	ci_pat_age_unit
_999.encounters_soap_labels_components	eslc_unit
_999.hl7_results_obx_map	obxm_unit
_999.patients_medications	pms_dose_unit
_999.patients_prescriptions	prx_dose_unit
_999.radiology_results_test_codes_results	rrtcres_observ_unit
_999.systems_components	scmp_default_unit
aurora_standard.bdcdm	issue_unit
aurora_standard.c7cdm	issue_unit
aurora_standard.c8cdm	issue_unit
aurora_standard.chmhcahp	dis_unit
aurora_standard.chmhstmr	sub_unit
aurora_standard.chmhstrm	sub_unit
aurora_standard.chmpricc	issue_unit
aurora_standard.gary13	calc_avg_unit_cost
aurora_standard.gary14	calc_avg_unit_cost
aurora_standard.gary2	avg_unit_cost
aurora_standard.glsprice	issue_unit
aurora_standard.hl7ft1	trans_amt_unit
aurora_standard.oeitmcatc	itm_unit
aurora_standard.ohorx	sale_unit
aurora_standard.pharm1	per_unit
aurora_standard.pharm1	pricc_unit_cost
aurora_standard.stiinvtr	weight_unit
aurora_standard.stiinvtr	sell_unit
aurora_standard.stiinvtr	bill_unit
aurora_standard.stiinvtr	stock_unit
aurora_standard.stiinvtr	purch_unit
aurora_standard.stilocar	avg_unit_cost
aurora_standard.stilocar	purch_unit_cost
aurora_standard.stipurcd	purch_unit_cost
aurora_standard.stoordrd	sell_unit
aurora_standard.stoordre	recur_unit
aurora_standard.stoshipd	sell_unit
aurora_standard.stuabcd	issue_unit
aurora_standard.stuctlgd	purch_unit
aurora_standard.stuordrd	sell_unit
aurora_standard.stuordrd	purch_unit
aurora_standard.stuordrd	stock_unit
aurora_standard.stuprice	purch_unit
aurora_standard.tmpctlgd	purch_unit
aurora_standard.tmplocar	avg_unit_cost
aurora_standard.tmplocar	purch_unit_cost
aurora_standard.ttiinvtr	weight_unit
aurora_standard.ttiinvtr	sell_unit
aurora_standard.ttiinvtr	bill_unit
aurora_standard.ttiinvtr	stock_unit
aurora_standard.ttiinvtr	purch_unit
common.cqm_conditions	cqc_duration_unit
common.cqm_conditions	cqc_target_att_modifier_unit
common.cqm_conditions	cqc_target2_att_modifier_unit

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.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.stfasstr	asset_cost
aurora_standard.stfmtncd	actual_cost
aurora_standard.stiadjmd	adj_cost
aurora_standard.stiinvtr	contract_cost
aurora_standard.stilocar	last_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	last_cost
aurora_standard.ttiinvtr	contract_cost

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

acct_no

Table	Column
aurora_standard.chmcashd	non_pat_acct_no
aurora_standard.chmnbcgd	non_pat_acct_no
aurora_standard.chmnbpyd	non_pat_acct_no
aurora_standard.chmnchgd	non_pat_acct_no
aurora_standard.chmnpatr	non_pat_acct_no
aurora_standard.chmnpayd	non_pat_acct_no
aurora_standard.chmrefnd	contr_acct_no
aurora_standard.chpcashr	cash_acct_no
aurora_standard.chpcobpd	cash_acct_no
aurora_standard.chpcobpd	bal_acct_no
aurora_standard.chrcntrc	rx_inv_acct_no
aurora_standard.chrcntrc	rx_exp_acct_no
aurora_standard.curs_temp	cash_acct_no
aurora_standard.np_statm	non_pat_acct_no
aurora_standard.sticntrc	inv_acct_no
aurora_standard.sticntrc	sales_acct_no
aurora_standard.sticntrc	cog_acct_no
aurora_standard.sticntrc	adj_acct_no
aurora_standard.sticntrc	count_acct_no
aurora_standard.sticntrc	hold_acct_no
aurora_standard.stiinvtr	inv_acct_no
aurora_standard.stiinvtr	cog_acct_no
aurora_standard.stiinvtr	sales_acct_no
aurora_standard.stiinvtr	supp_acct_no
aurora_standard.stitrand	exp_acct_no
aurora_standard.stiwhser	inv_acct_no
aurora_standard.stpcntrc	ap_acct_no
aurora_standard.stpcntrc	cd_cash_acct_no
aurora_standard.stpcntrc	cd_disc_acct_no
aurora_standard.stpinvce	disc_acct_no
aurora_standard.stpinvce	ap_acct_no
aurora_standard.stpinvce	cash_acct_no
aurora_standard.stpopend	ap_acct_no
aurora_standard.stpopend	cash_acct_no
aurora_standard.stpvendr	cash_acct_no
aurora_standard.stpvendr	exp_acct_no
aurora_standard.stpvendr	hosp_acct_no
aurora_standard.strcntrc	ar_acct_no
aurora_standard.strcntrc	ar_sales_acct_no
aurora_standard.strcntrc	ar_tax_acct_no
aurora_standard.strcntrc	ar_frght_acct_no
aurora_standard.strcntrc	ar_misc_acct_no
aurora_standard.strcntrc	ar_fc_acct_no
aurora_standard.strcntrc	cr_cash_acct_no
aurora_standard.strcntrc	cr_disc_acct_no
aurora_standard.strinvce	disc_acct_no
aurora_standard.strinvce	tax_acct_no
aurora_standard.strinvce	frght_acct_no
aurora_standard.strinvce	misc_acct_no
aurora_standard.strinvce	ar_acct_no
aurora_standard.stropend	ar_acct_no
aurora_standard.stucntrc	ap_acct_no
aurora_standard.stucntrc	disc_acct_no
aurora_standard.stucntrc	frght_acct_no
aurora_standard.stucntrc	misc_acct_no
aurora_standard.stucntrc	inv_acct_no
aurora_standard.stucntrc	adj_acct_no
aurora_standard.stucntrc	prepaid_acct_no
aurora_standard.stucntrc	supp_acct_no
aurora_standard.stucntrc	cap_acct_no
aurora_standard.stucntrc	non_acct_no
aurora_standard.stucntrc	diff_acct_no
aurora_standard.stucntrc	cash_acct_no
aurora_standard.stucntrc	ret_acct_no
aurora_standard.stucntrc	ret_fee_acct_no
aurora_standard.stuinvcd	gl_acct_no
aurora_standard.stultypr	gl_acct_no
aurora_standard.stuordrd	gl_acct_no
aurora_standard.stxcurrr	ex_diff_acct_no
aurora_standard.stxfinsd	fin_acct_no
aurora_standard.stxinfor	src_acct_no
aurora_standard.stxmtaxr	ar_acct_no
aurora_standard.stxmtaxr	ar_disc_acct_no
aurora_standard.stxmtaxr	ap_acct_no
aurora_standard.stxmtaxr	ap_disc_acct_no
aurora_standard.stycntrc	co_bank_acct_no
aurora_standard.styddepd	bank_acct_no
aurora_standard.styemplr	bank_acct_no
aurora_standard.styempod	bal_acct_no
aurora_standard.stypayod	bal_acct_no
aurora_standard.stypayre	cash_acct_no
aurora_standard.stypddrd	bank_acct_no
aurora_standard.styrevsd	cash_acct_no
aurora_standard.stytypod	bal_acct_no
aurora_standard.styuimmr	ui_acct_no
aurora_standard.ttiinvtr	inv_acct_no
aurora_standard.ttiinvtr	cog_acct_no
aurora_standard.ttiinvtr	sales_acct_no
aurora_standard.ttiinvtr	supp_acct_no
aurora_standard.wkactvv	inv_acct_no

request_date

Table	Column
aurora_standard.chmdtopd	pat_request_date

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

recv_qty

Table	Column
aurora_standard.gary2	sum_recv_qty

line_stage

Table	Column
aurora_standard.sturtrnd	po_line_stage

vend_code

Table	Column
aurora_standard.vndxref	old_vend_code
aurora_standard.vndxref	new_vend_code