GVT_TS_FIELDS(SQL Table) |
Index Back |
|---|---|
Transaction Summary configMain record to store transaction summary configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | Component Name | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Market | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code | |
| 4 | Number(3,0) | SMALLINT NOT NULL | Sequence Number | |
| 5 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 6 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 9 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 10 | TS_LBL_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override field label
Y/N Table Edit |
| 11 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Text ID
Prompt Table: TS_SSTEXT_VW |
| 12 | TS_LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label text |
| 13 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| 14 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
| 15 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 16 | RECNAME_3 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 17 | SHOW_RELATED | Character(1) | VARCHAR2(1) NOT NULL |
Show related information
Y/N Table Edit |
| 18 | RELATED_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Used in SS Framework
Prompt Table: PSRECDEFN |
| 19 | RELATED_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Used in SS Framework
Prompt Table: GVT_RECFIELD_VW |
| 20 | PNLFLDID | Number(4,0) | SMALLINT NOT NULL | Page Field ID |
| 21 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 22 | TS_GROUP_HEADER | Character(1) | VARCHAR2(1) NOT NULL |
Transaction summary group header
Y/N Table Edit |
| 23 | TS_GROUP_NBR | Number(3,0) | SMALLINT NOT NULL | Transaction summary group number |