EX_TRANS_RTGLST(SQL Table) |
Index Back |
|---|---|
Transaction Approval RoutingTransaction Approval Routing. This record stores the transaction routing list header information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | APPR_TRANS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Approval Transaction Type.
CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report |
| 3 | APPRVR_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Approver type used to cross reference an AWE process id and stage. |
| 4 | APPROVER_PROFILE |
Character(15) | VARCHAR2(15) NOT NULL |
Approver profile name
Prompt Table:
EX_PROF_ACT_VW
|
| 5 | SEQ_NBR_3 |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 6 | ALL_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
Tree Level All Values flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 7 | CHARTFIELD_FROM | Character(30) | VARCHAR2(30) NOT NULL |
Starting chartfield
Prompt Table: %EDITTABLECF |
| 8 | CHARTFIELD_TO | Character(30) | VARCHAR2(30) NOT NULL |
Ending chartfield
Prompt Table: %EDITTABLECF |
| 9 | ALL_AMOUNTS | Character(1) | VARCHAR2(1) NOT NULL |
All Amounts
Y/N Table Edit Default Value: N |
| 10 | AMOUNT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |
| 11 | AMOUNT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |