common.reports_queue_orders

Field Type Null Default Key Extra Comment
rqo_id int(11) NO PRI auto_increment
rqo_cus_id int(11) NO MUL Customer ID#
rqo_cli_id int(11) NO MUL Client ID#
rqo_usr_id int(11) NO MUL User ID#
rqo_rq_id int(11) NO MUL Reports Queue ID#
rqo_rcron_id int(11) YES
rqo_rqt_id int(11) NO MUL Reports Queue Type ID#
rqo_rqs_id int(11) NO MUL Report Queue Status id
rqo_br_id int(11) NO 0 MUL Billing Report ID#
rqo_br_key varchar(100) NO Billing reports key
rqo_title text NO Selected report title
rqo_name text NO Name of report
rqo_key varchar(250) YES Key for report
rqo_path text NO Path to report file
rqo_params longtext NO Parameters uses to build reports.
rqo_extensions text NO File extension(s) of report
rqo_complexity_estimate int(11) YES 1
rqo_after_hours char(1) NO 0 MUL Report Queue After Hours Filter
rqo_is_daily_report tinyint(1) NO 0 Indicates report is a Daily Report
rqo_job_done char(1) NO 0 MUL Flag for processing status
rqo_complete_dt datetime YES MUL Time report completed
rqo_start_dt datetime YES MUL Time report started
rqo_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
rqo_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
rqo_id
TableColumn
common.reports_filters_options_maprfom_rqo_id
common.reports_queue_orders_accessrqoa_rqo_id