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 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
3 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
4 | SEQNUM | 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 |