RBB_TRNSTYP_DTL

(SQL Table)
 Index Back

Transaction Type Defintion

Table to store the Transaction Type Defintions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RBB_TRNSTYPE_ID Character(25) VARCHAR2(25) NOT NULL Field to store Transaction Type ID
2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

3 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: RBB_MENU_VW

4 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

Prompt Table: RBB_BARNAME2_VW

5 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

Prompt Table: RBB_ITEMNAME_VW

6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: RBB_PNLGRP_VW

7 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname

Prompt Table: RBB_PAGE_VW

8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RBB_RECDEFN_VW

9 RBB_ROWADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
10 RBB_ROWADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
11 RBB_ROWUPD_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
12 RBB_ROWUPD_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
13 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
14 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time