REPORT_IDFIELDNAMEY/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
AM_RPT_TEMPLATE(SQL Table) |
Index Back |
|---|---|
AM Report Template TableAM Reporting Template Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Report Identifier |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | FIELD_ORDER | Number(3,0) | SMALLINT NOT NULL | Field Order |
| 4 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit |
| 5 | AMOUNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Total Amount
Y/N Table Edit |
| 6 | ALLOW_OVERRIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Override of Lead Days
Y/N Table Edit |
| 7 | LABEL_OVERRIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Override label heading, Yes or Not
Y/N Table Edit |
| 8 | DISPLAY_LENGTH | Number(2,0) | SMALLINT NOT NULL | Use to determine the ChartField Length to be display. |