_1.inventory

Field Type Null Default Key Extra Comment
inv_id int(11) NO PRI auto_increment
inv_loc_id int(11) YES MUL
inv_cus_id int(11) YES MUL
inv_cli_id int(11) YES MUL
inv_type_id int(11) YES MUL
inv_comp_id int(11) NO
inv_name varchar(100) NO MUL
inv_manufacturer varchar(100) NO
inv_brand_name varchar(50) NO Brand name for immunizations
inv_lot_number varchar(32) NO
inv_product_number varchar(32) NO
inv_ndc_code varchar(30) NO
inv_ndc_unit_count varchar(10) NO
inv_ndc_units_of_measure varchar(2) NO
inv_init_amt decimal(8,2) NO 0.00 Initial amount
inv_cost varchar(10) NO The cost paid for the inventory item.
inv_available decimal(8,2) NO 0.00 Amount currently available
inv_minimum decimal(8,2) NO 1.00 Minimum amount
inv_received_date date YES
inv_expiration_date date YES
inv_usr_id_created int(11) NO 0 MUL
inv_usr_created_dt datetime YES
inv_notes text YES
inv_invc_id int(11) NO 0 MUL
inv_administered_location_id int(11) NO 0 Default location for administered items.
inv_administered_location_other varchar(45) NO Free text administered location.
inv_administered_route_id int(11) NO 0 Default route for administered items.
inv_administered_route_other varchar(45) YES Free text route.
inv_disabled char(1) YES 0
inv_modified datetime YES CURRENT_TIMESTAMP
inv_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
inv_id
TableColumn
_1.auditsaud_inv_id
_1.audits_archiveaud_inv_id
_1.immunizations_cpt_mapicm_inv_id
_1.immunizations_icd_mapiim_inv_id
_1.immunizations_vis_mapivm_inv_id
_1.inventory_cpt_mapinvcpt_inv_id
_1.inventory_icd_mapinvicd_inv_id
_1.patients_immunizationspim_inv_id
_1.patients_inventorypinv_inv_id
_1188.auditsaud_inv_id
_1188.audits_archiveaud_inv_id
_1188.immunizations_cpt_mapicm_inv_id
_1188.immunizations_icd_mapiim_inv_id
_1188.immunizations_vis_mapivm_inv_id
_1188.inventory_cpt_mapinvcpt_inv_id
_1188.inventory_icd_mapinvicd_inv_id
_1188.patients_immunizationspim_inv_id
_1188.patients_inventorypinv_inv_id
_1218.auditsaud_inv_id
_1218.audits_archiveaud_inv_id
_1218.immunizations_cpt_mapicm_inv_id
_1218.immunizations_icd_mapiim_inv_id
_1218.immunizations_vis_mapivm_inv_id
_1218.inventory_cpt_mapinvcpt_inv_id
_1218.inventory_icd_mapinvicd_inv_id
_1218.patients_immunizationspim_inv_id
_1218.patients_inventorypinv_inv_id
_1548.auditsaud_inv_id
_1548.audits_archiveaud_inv_id
_1548.immunizations_cpt_mapicm_inv_id
_1548.immunizations_icd_mapiim_inv_id
_1548.immunizations_vis_mapivm_inv_id
_1548.inventory_cpt_mapinvcpt_inv_id
_1548.inventory_icd_mapinvicd_inv_id
_1548.patients_immunizationspim_inv_id
_1548.patients_inventorypinv_inv_id
_435.auditsaud_inv_id
_435.audits_archiveaud_inv_id
_435.immunizations_cpt_mapicm_inv_id
_435.immunizations_icd_mapiim_inv_id
_435.immunizations_vis_mapivm_inv_id
_435.inventory_cpt_mapinvcpt_inv_id
_435.inventory_icd_mapinvicd_inv_id
_435.patients_immunizationspim_inv_id
_435.patients_inventorypinv_inv_id
_436.auditsaud_inv_id
_436.audits_archiveaud_inv_id
_436.immunizations_cpt_mapicm_inv_id
_436.immunizations_icd_mapiim_inv_id
_436.immunizations_vis_mapivm_inv_id
_436.inventory_cpt_mapinvcpt_inv_id
_436.inventory_icd_mapinvicd_inv_id
_436.patients_immunizationspim_inv_id
_436.patients_inventorypinv_inv_id
_436_archive_testing.auditsaud_inv_id
_436_archive_testing.audits_archiveaud_inv_id
_436_archive_testing.immunizations_cpt_mapicm_inv_id
_436_archive_testing.immunizations_icd_mapiim_inv_id
_436_archive_testing.immunizations_vis_mapivm_inv_id
_436_archive_testing.inventory_cpt_mapinvcpt_inv_id
_436_archive_testing.inventory_icd_mapinvicd_inv_id
_436_archive_testing.patients_immunizationspim_inv_id
_436_archive_testing.patients_inventorypinv_inv_id
_437.auditsaud_inv_id
_437.audits_archiveaud_inv_id
_437.immunizations_cpt_mapicm_inv_id
_437.immunizations_icd_mapiim_inv_id
_437.immunizations_vis_mapivm_inv_id
_437.inventory_cpt_mapinvcpt_inv_id
_437.inventory_icd_mapinvicd_inv_id
_437.patients_immunizationspim_inv_id
_437.patients_inventorypinv_inv_id
_8.auditsaud_inv_id
_8.audits_archiveaud_inv_id
_8.immunizations_cpt_mapicm_inv_id
_8.immunizations_icd_mapiim_inv_id
_8.immunizations_vis_mapivm_inv_id
_8.inventory_cpt_mapinvcpt_inv_id
_8.inventory_icd_mapinvicd_inv_id
_8.patients_immunizationspim_inv_id
_8.patients_inventorypinv_inv_id
_81.auditsaud_inv_id
_81.audits_archiveaud_inv_id
_81.immunizations_cpt_mapicm_inv_id
_81.immunizations_icd_mapiim_inv_id
_81.immunizations_vis_mapivm_inv_id
_81.inventory_cpt_mapinvcpt_inv_id
_81.inventory_icd_mapinvicd_inv_id
_81.patients_immunizationspim_inv_id
_81.patients_inventorypinv_inv_id
_999.auditsaud_inv_id
_999.audits_archiveaud_inv_id
_999.immunizations_cpt_mapicm_inv_id
_999.immunizations_icd_mapiim_inv_id
_999.immunizations_vis_mapivm_inv_id
_999.inventory_cpt_mapinvcpt_inv_id
_999.inventory_icd_mapinvicd_inv_id
_999.patients_immunizationspim_inv_id
_999.patients_inventorypinv_inv_id
inv_name
TableColumn
_1.patients_immunizationspim_inv_name
_1188.patients_immunizationspim_inv_name
_1218.patients_immunizationspim_inv_name
_1548.patients_immunizationspim_inv_name
_435.patients_immunizationspim_inv_name
_436.patients_immunizationspim_inv_name
_436_archive_testing.patients_immunizationspim_inv_name
_437.patients_immunizationspim_inv_name
_8.patients_immunizationspim_inv_name
_81.patients_immunizationspim_inv_name
_999.patients_immunizationspim_inv_name