Venture ERP Documentation : TableDefinitionReportMaster

Venture :: Categories :: PageIndex :: RecentChanges :: RecentlyCommented :: Login/Register
Return to: Database Reference Home Page
Return to: Table Definitions Master List

*Table Name*

report_master

*Description*

Reporting Tables

*Schema*

CREATE TABLE report_master (
    "report_id" serial
        PRIMARY KEY,                    -- Primary Key
    "company_id" integer
        NOT NULL                  -- Company ID
        REFERENCES company_master (company_id),
    "created_by" varchar(16),                  -- Who Created this report
    "request_name" varchar(75)
        NOT NULL,         -- Reference to PHP Report include file
    "date_range_start" timestamp,               -- Start of Report Date Range
    "date_range_end" timestamp,      -- End of Report Date Range
    "overwrite_data" BOOLEAN,                  -- Flag to overwrite data if it exists
    "last_run_date" timestamp,            -- Show date when report was last run
    "last_run_by" varchar(16),            -- Last User to run this report
    "report_data" text,        -- Free-form text field to store CSV-style data
    "report_output" varchar(15),                    -- Default Output Type. HTML|PDF (CSV is implied)
    "user_report_id" integer                        -- References user_reports.user_repor
);

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by Wikka Wakka Wiki 1.1.6.3
Page was generated in 0.0423 seconds