GVT_TS_FIELDS

(SQL Table)
Index Back

Transaction Summary config

Main 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