| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| RPT_PK | Report Id | int | |
| RPT_RPCAT_FK | Report Category Id | int | |
| RPT_RPF_FK | Report Form Id | int | |
| RPT_TITLE | Title | nvarchar | |
| RPT_COMMENTS | Comments | nvarchar | |
| RPT_LAYOUT | Layout | nvarchar | |
| RPT_LAYOUT_SET | Layout Set | bit | |
| RPT_PAGE_BREAK | Page Break | int | |
| RPT_COLUMNS | Columns | int | |
| RPT_ROWS | Rows | int | |
| RPT_SUMMARY_ROWS | Summary Rows | int | |
| RPT_SQL_STATEMENT | SQL Statment | nvarchar | |
| RPT_LANDSCAPE | Landscape | int | |
| RPT_SHOW_LOGO | Indicates if the report is set to show logo | bit | |
| RPT_SHOW_HEADING | Indicates if the report is set to show heading | bit | |
| RPT_SHOW_DEPARTMENT | Indicates if the report is set to show department | bit | |
| RPT_SHOW_CRITERIA | Indicates if the report is set to show criteria | bit | |
| RPT_SHOW_COMPANY | Indicates if the report is set to show company | bit | |
| RPT_DEPARTMENT_LABEL | Department Label | nvarchar | |
| RPT_HEIGHT | Height | nvarchar | |
| RPT_WIDTH | Width | nvarchar | |
| RPT_Chart | Chart | bit | |
| RPT_RUNTIME_SORT | Runtime Sort | bit | |
| RPT_TYPE | Type | nvarchar | |
| RPT_LINK | Link | nvarchar | |
| RPT_MARGIN_LEFT | Margin Left | nvarchar | |
| RPT_MARGIN_RIGHT | Margin Right | nvarchar | |
| RPT_MARGIN_TOP | Margin Top | nvarchar | |
| RPT_MARGIN_BOTTOM | Margin Bottom | nvarchar | |
| RPT_WINDOW_FK | Window Id | int | vr_webtmaWindows |
| RPT_EXTERNALLINK | External Link | varchar | |
| RPT_FilterByPK | Indicates if the report is set to filter by pk value | bit | |
| RPT_TableGrid | Indicates if the report has a table grid | bit | |
| RPT_TableDefaultTemplate | Indicates if the report uses a table default template | bit | |
| RPT_TableCenter | Indicates if the report is set to center table | bit | |
| RPT_reportAccess | Report Access | nvarchar | |
| RPT_private | Indicates if the report is set to private | bit | |
| RPT_creator_fk | User Id (Record Creator) | int | vr_users |
| RPT_createdDate | Created Date | datetime | |
| RPT_modifier_fk | User Id (Record Modifier) | int | vr_users |
| RPT_modifiedDate | Modified Date | datetime | |
| RPT_matBrowseType | Material Browse Type | nvarchar | |
| RPT_TableHeaderLine | Indicates if the report has a table header line | bit | |
| RPT_TableFooterLine | Indicates if the report has a table footer line | bit | |
| RPT_TableGroupLine | Indicates if the report has a table group line | bit | |
| RPT_TableRowLine | Indicates if the report has a table row line | bit | |
| RPT_TableGroupHeaderLine | Indicates if the report has a table group header line | bit | |
| RPT_TableGroupFooterLine | Indicates if the report has a table group footer line | bit | |
| RPT_rc_fk | Repair Center Id | int | vr_RepairCenter |
| RPT_HideHeaderFooter | Indicates if the report is set to hide header and/or footer | bit | |
| RPT_PrintDate | Print Date | datetime | |
| RPT_active | Indicates if the report is active | bit | |
| RPT_IsSubReport | Indicates if the report is a sub report | bit | |
| rpt_TableAllowPageBreaks | Indicates if the report is set to allow page breaks | bit |
community
/hc/en-us/community/topics
/hc/theming_assets/01HZH76HW8NTQYYTTBVVTM979X
Community
**You must be logged in to see any Topics or Posts**
work order, WebTMA7, reporting