| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
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
|
| 6 |
RVSL_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal Date Option
C=Current Date
O=Original Accounting Date
S=Specify Date
|
| 7 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
|
| 8 |
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.
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 10 |
ACCOUNTING_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the unique alphanumeric identifier for treasury-specific accounting entries.
|
| 11 |
ACCOUNTING_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the unique alphanumeric identifier for treasury-specific accounting entries.
|
| 12 |
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
|
| 13 |
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).
|
| 14 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 15 |
TRAN_REF_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Represents the unique transaction identifier in bank reconciliation processing.
|
| 16 |
TRANSACTION_DT |
Date(10) |
DATE |
Transaction date (often used as trade date)
|
| 17 |
ACCTG_EVENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Accounting types for deal capture and hedging
|
| 18 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 19 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 20 |
TRANSACTION_LINE |
Number(3,0) |
SMALLINT NOT NULL |
The separate and distinct base instrument type components of a given deal transaction.
|
| 21 |
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
|
| 22 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 23 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 24 |
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
|
| 25 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 26 |
PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment id
|
| 27 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 28 |
TREAS_HEADER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
|
| 29 |
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.
|
| 30 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
|
| 31 |
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
|
| 32 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 33 |
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
|
| 34 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 35 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 36 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 37 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 38 |
MESSAGE_PARM1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 1
|
| 39 |
MESSAGE_PARM2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 2
|
| 40 |
FIRST_PASS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
First Pass Switch
|
| 41 |
AUTONUM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Automatic Numbering Set ID
|
| 42 |
ACCOUNTING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the unique alphanumeric identifier for treasury-specific accounting entries.
|
| 43 |
ORIG_ACCOUNTING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This fields contains the accounting id of the entries that have been reversed.
|
| 44 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 45 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 46 |
BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
|
| 47 |
MAX_LENGTH |
Number(2,0) |
SMALLINT NOT NULL |
Maximum Length of Auto Number
|
| 48 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 49 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 50 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
Default Value: 0
|
| 51 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
|
| 52 |
ERROR_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Error Status
1=None
2=Unbalanced
3=CF Combo Error
4=No Exchange Rate
5=Acct Not Specified
6=IU Processor Error
7=Document Sequencing Error
|
| 53 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 54 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 55 |
SQLROWS |
Number(5,0) |
INTEGER NOT NULL |
SQL Rows
|
| 56 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 57 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 58 |
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.
|
| 59 |
TR_GL_INTEGRATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Treasury to Enterprise One GL Integration flag
|
| 60 |
INTEGRATION_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Treasury integration status. Used to keep track of status for accounting entries that are passed to EnterpriseOne.
ERR=Error
LOA=Loaded
NA=Not Applicable
PEN=Pending
POS=Posted
REC=Received
SEN=Sent
|
| 61 |
DTTM_STAMP |
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.
|
| 62 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 63 |
XLATLONGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Translate Long Name
|