| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 9999
|
| 4 |
REV_ACCTG_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reverse Accounting Option defines how to identify the accounting entries to be reveresed.
Value 4 (Reverse by Undo Deal) is used by process TR_UNDO_DEAL to reverse accounting for a deactivated deal. It is not a value for on-line selection.
Value 5 (Reverse by Cumulative MTM) is used by process TR_ACCTG to reverse accounting for cumulative Mark-to-Market entries. TR_ACCTG does a schedule process. It is also valid for on-line selection.
1=Reverse by Accounting ID
2=Reverse by Source
3=Reverse by Payment ID
4=Reverse by Undo Deal
5=Reverse by Cumulative MTM
Default Value: 1
|
| 5 |
RVSL_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Date Option
C=Current Date
O=Original Accounting Date
S=Specify Date
Default Value: C
|
| 6 |
REVERSAL_DATE |
Date(10) |
DATE |
Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
Default Value: %date
|
| 7 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
Prompt Table:
TRA_COMBTMPL_VW
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 9 |
ACCOUNTING_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the unique alphanumeric identifier for treasury-specific accounting entries.
Prompt Table:
TRA_ACCTG_VW
|
| 10 |
ACCOUNTING_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the unique alphanumeric identifier for treasury-specific accounting entries.
Prompt Table:
TRA_ACCTG_VW
|
| 11 |
TRA_SOURCE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Cash Flows only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers
|
| 12 |
EVENT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).
Prompt Table:
%EDIT_EVENT_ID
|
| 13 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table:
REV_BNK_ACCT_VW
|
| 14 |
TRAN_REF_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Represents the unique transaction identifier in bank reconciliation processing.
Prompt Table:
REV_TRAN_REF_VW
|
| 15 |
TRANSACTION_DT |
Date(10) |
DATE |
Transaction date (often used as trade date)
|
| 16 |
ACCTG_EVENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Accounting types for deal capture and hedging
|
| 17 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 18 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 19 |
TRANSACTION_LINE |
Number(3,0) |
SMALLINT NOT NULL |
The separate and distinct base instrument type components of a given deal transaction.
|
| 20 |
TRANSACTION_LEG |
Number(1,0) |
SMALLINT NOT NULL |
The separate and distinct business positions of a given deal transaction line.
1=Pay Leg
2=Receive Leg
|
| 21 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
SP_SETID_NONVW
|
| 22 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_EXT_VW
|
| 23 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BANK_ACCT_ACTVE
|
| 24 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 25 |
PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment id
Prompt Table:
%EDITTABLE
|
| 26 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 27 |
TREAS_HEADER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Prompt Table:
TRX_HEADER_TR
|
| 28 |
TREASURY_PORTFOLIO |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier for a position portfolio that may be associated with a given deal transaction.
Prompt Table:
TRX_PORTFLIO_TR
|
| 29 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table:
INSTR_INST_H_VW
|
| 30 |
DEALER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that originally created and saved a given deal tran
Prompt Table:
OPRID_VW
|
| 31 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 32 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
|
| 33 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: N
|
| 34 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 35 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|