| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 2 |
POOL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table:
TRP_POOL_ACT_VW
|
| 3 |
PARTICIPANT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Participant Id
Prompt Table:
TRP_PART_AC2_VW
|
| 4 |
PARTICIPANT_ACCT |
Character(25) |
VARCHAR2(25) NOT NULL |
Participant Account
Prompt Table:
TRP_PART_ACH_VW
|
| 5 |
TRP_ACCOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account type
D=Deposit
I=Income
|
| 6 |
TRANSACTIONID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Identifier
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
TRP_TXN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
D=Deposit
F=Fees
I=Income
M=Market Value
T=Transfer
W=Withdrawal
|
| 9 |
TRANSACTION_DT |
Date(10) |
DATE NOT NULL |
Transaction date (often used as trade date)
Default Value: %date
|
| 10 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
TRP_POOL_CUR_VW
|
| 12 |
TRP_ACCOUNT_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
To account
Prompt Table:
TRP_PART_ACH_VW
|
| 13 |
ACCOUNT_TO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account type
D=Deposit
I=Income
|
| 14 |
TRP_TXN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status
A=Approved
D=Denied
P=Pending
Default Value: P
|
| 15 |
ACCTG_TMPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table:
TRA_PL_TMPL_VW
|
| 16 |
TR_WR_TEMPLATE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Wires / Treasury Wire Templates
This uniquely identifies templates within a Business Unit.
Default Value: TRP_PART_ACCT_D.TR_WR_TEMPLATE_ID
Prompt Table:
TR_WR_TMPL_VW
|
| 17 |
ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered by
|
| 18 |
ENTERED_ON |
DateTime(26) |
TIMESTAMP |
Entered On
|
| 19 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
DOC_TYPE_TBL
|