_436_archive_testing.invoices_periods

Field Type Null Default Key Extra Comment
invper_id int(11) NO PRI auto_increment
invper_cus_id int(11) NO 0 MUL
invper_usr_id int(11) NO 0
invper_month varchar(2) NO MUL
invper_year varchar(4) NO MUL
invper_unix_ts_cutoff int(10) NO 0
invper_pdf_path text NO
invper_xls_path text NO
invper_closed tinyint(1) NO 0 MUL
invper_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
invper_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
invper_id
TableColumn
_1.auditsaud_invper_id
_1.audits_archiveaud_invper_id
_1.cpoe_responsescpoe_res_invper_id
_1.hl7_accessionsacc_invper_id
_1.invoices_numbersinvnum_invper_id
_1.radiology_resultsrad_res_invper_id
_1188.auditsaud_invper_id
_1188.audits_archiveaud_invper_id
_1188.cpoe_responsescpoe_res_invper_id
_1188.hl7_accessionsacc_invper_id
_1188.invoices_numbersinvnum_invper_id
_1188.radiology_resultsrad_res_invper_id
_1218.auditsaud_invper_id
_1218.audits_archiveaud_invper_id
_1218.cpoe_responsescpoe_res_invper_id
_1218.hl7_accessionsacc_invper_id
_1218.invoices_numbersinvnum_invper_id
_1218.radiology_resultsrad_res_invper_id
_1548.auditsaud_invper_id
_1548.audits_archiveaud_invper_id
_1548.cpoe_responsescpoe_res_invper_id
_1548.hl7_accessionsacc_invper_id
_1548.invoices_numbersinvnum_invper_id
_1548.radiology_resultsrad_res_invper_id
_435.auditsaud_invper_id
_435.audits_archiveaud_invper_id
_435.cpoe_responsescpoe_res_invper_id
_435.hl7_accessionsacc_invper_id
_435.invoices_numbersinvnum_invper_id
_435.radiology_resultsrad_res_invper_id
_436.auditsaud_invper_id
_436.audits_archiveaud_invper_id
_436.cpoe_responsescpoe_res_invper_id
_436.hl7_accessionsacc_invper_id
_436.invoices_numbersinvnum_invper_id
_436.radiology_resultsrad_res_invper_id
_436_archive_testing.auditsaud_invper_id
_436_archive_testing.audits_archiveaud_invper_id
_436_archive_testing.cpoe_responsescpoe_res_invper_id
_436_archive_testing.hl7_accessionsacc_invper_id
_436_archive_testing.invoices_numbersinvnum_invper_id
_436_archive_testing.radiology_resultsrad_res_invper_id
_437.auditsaud_invper_id
_437.audits_archiveaud_invper_id
_437.cpoe_responsescpoe_res_invper_id
_437.hl7_accessionsacc_invper_id
_437.invoices_numbersinvnum_invper_id
_437.radiology_resultsrad_res_invper_id
_8.auditsaud_invper_id
_8.audits_archiveaud_invper_id
_8.cpoe_responsescpoe_res_invper_id
_8.hl7_accessionsacc_invper_id
_8.invoices_numbersinvnum_invper_id
_8.radiology_resultsrad_res_invper_id
_81.auditsaud_invper_id
_81.audits_archiveaud_invper_id
_81.cpoe_responsescpoe_res_invper_id
_81.hl7_accessionsacc_invper_id
_81.invoices_numbersinvnum_invper_id
_81.radiology_resultsrad_res_invper_id
_999.auditsaud_invper_id
_999.audits_archiveaud_invper_id
_999.cpoe_responsescpoe_res_invper_id
_999.hl7_accessionsacc_invper_id
_999.invoices_numbersinvnum_invper_id
_999.radiology_resultsrad_res_invper_id
common.ahi_auditsaud_invper_id