aurora_standard.items

Field Type Null Default Key Extra Comment
item_num smallint(6) YES
order_num int(11) YES
stock_num smallint(6) YES
manu_code varchar(3) YES
quantity smallint(6) YES
total_price decimal(16,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
quantity
TableColumn
HSPI_CURES2015_B1.cbos_inventory_logcurrent_quantity
HSPI_Central_Hospital.cbos_inventory_logcurrent_quantity
HSPI_Dewitt.cbos_inventory_logcurrent_quantity
HSPI_Fulton.cbos_inventory_logcurrent_quantity
HSPI_Inferno.cbos_inventory_logcurrent_quantity
HSPI_MU2015_E1.cbos_inventory_logcurrent_quantity
HSPI_MU2015_G2.cbos_inventory_logcurrent_quantity
HSPI_MU2015_G9.cbos_inventory_logcurrent_quantity
HSPI_Sandbox.cbos_inventory_logcurrent_quantity
HSPI_Summit_General.cbos_inventory_logcurrent_quantity
HSPI_United_Physicians.cbos_inventory_logcurrent_quantity
MPI.cbos_inventory_logcurrent_quantity
_1.charts_medicationscm_quantity
_1.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1.patients_medicationspms_quantity
_1.patients_prescriptionsprx_quantity
_1188.charts_medicationscm_quantity
_1188.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1188.patients_medicationspms_quantity
_1188.patients_prescriptionsprx_quantity
_1218.charts_medicationscm_quantity
_1218.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1218.patients_medicationspms_quantity
_1218.patients_prescriptionsprx_quantity
_1548.charts_medicationscm_quantity
_1548.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1548.patients_medicationspms_quantity
_1548.patients_prescriptionsprx_quantity
_435.charts_medicationscm_quantity
_435.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_435.patients_medicationspms_quantity
_435.patients_prescriptionsprx_quantity
_436.charts_medicationscm_quantity
_436.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_436.patients_medicationspms_quantity
_436.patients_prescriptionsprx_quantity
_436_archive_testing.charts_medicationscm_quantity
_436_archive_testing.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_436_archive_testing.patients_medicationspms_quantity
_436_archive_testing.patients_prescriptionsprx_quantity
_437.charts_medicationscm_quantity
_437.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_437.patients_medicationspms_quantity
_437.patients_prescriptionsprx_quantity
_8.charts_medicationscm_quantity
_8.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_8.patients_medicationspms_quantity
_8.patients_prescriptionsprx_quantity
_81.charts_medicationscm_quantity
_81.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_81.patients_medicationspms_quantity
_81.patients_prescriptionsprx_quantity
_999.charts_medicationscm_quantity
_999.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_999.patients_medicationspms_quantity
_999.patients_prescriptionsprx_quantity
aurora_standard.hl7ft1trans_quantity
common.test_codes_results_cptstcrc_quantity