| # |
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 |
BUSINESS_UNIT_SEL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit entered as a run time parameter when executing the automat
|
| 5 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 6 |
TR_CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
The calendar ID selected as applicable for running the Treasury Automated Accounting process (TR_ACCTG).
|
| 7 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 8 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 9 |
ACCRUAL_DATE |
Date(10) |
DATE |
The date upon which a periodic accounting accrual is to be generated for a given treasury transaction.
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 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).
|
| 13 |
EVENT_DT |
Date(10) |
DATE |
The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
|
| 14 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 15 |
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
|
| 16 |
ACCTG_EVENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Accounting types for deal capture and hedging
|
| 17 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 18 |
TRAN_REF_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Represents the unique transaction identifier in bank reconciliation processing.
|
| 19 |
CASH_FLOW_LINE |
Number(15,0) |
DECIMAL(15) NOT NULL |
A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
|
| 20 |
TRANSACTION_LINE |
Number(3,0) |
SMALLINT NOT NULL |
The separate and distinct base instrument type components of a given deal transaction.
|
| 21 |
TRANS_LEG |
Number(1,0) |
SMALLINT NOT NULL |
The separate and distinct business positions of a given deal transaction line.
|
| 22 |
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.
|
| 23 |
ACCTG_TMPL_LINE |
Number(3,0) |
SMALLINT NOT NULL |
A sequential number that indicates the number of accounting debit or credit lines defined within a giv
|
| 24 |
AMOUNT_CALC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Represents the formula by which an accounting entry monetary amount is calculated for a given accounting template
|
| 25 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 26 |
BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
|
| 27 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 28 |
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
|
| 29 |
BANK_ACCT_LED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
The general ledger account type associated with a given bank/counterparty account.
12/04/02 VL Added Translate Dit - AR for JFMIP RM1.1
A=Cash - AR
B=Bank Charge
C=Cash - AP
D=Draft - AP
F=Fees
G=Control
H=Cash
I=Interest
L=Cntrl - AP
P=Dep - AR
R=Cntrl - AR
S=Draft - AR
T=Disc - AR
U=AROffSetDr
V=AROffSetCr
W=Dit - AR
|
| 30 |
TEST_ATTRIBUTE |
Character(18) |
VARCHAR2(18) NOT NULL |
Represents the treasury deal transaction attribute that is subject to a predefined accounting template
|
| 31 |
SET_CF |
Character(18) |
VARCHAR2(18) NOT NULL |
Represents a treasury accounting template substitution rule that determines which General Ledger chartfield is
|
| 32 |
TRA_ATTR_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
The desired source transaction attribute value defined as a substitution rule within a given accounting entry.
|
| 33 |
TRA_CHRTFLD_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
The desired accounting chartfield value defined as a substitution rule within a given accounting entry.
|
| 34 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 35 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 36 |
CURRENCY_CD_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency code 2
|
| 37 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 38 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 39 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 40 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
|
| 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 |
ACCOUNTING_LINE |
Number(5,0) |
INTEGER NOT NULL |
The specific unique numeric identifier that distinguishes debit and credits for a given treasury accounting ent
|
| 44 |
TRANSACT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"The nominal
|
| 45 |
TRANSACTION_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The nominal or actual deal transaction amount.
|
| 46 |
INT_ACCR_AMT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The accrued interest for a given deal transaction as of a given date.
|
| 47 |
INT_ACCR_AMT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The accrued interest for the second leg of a given deal transaction as of a given date.
|
| 48 |
ACCRUED_UP_TO_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
"An internal work field utilized for calculating the interest
|
| 49 |
ACCRUED_UP_TO_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
"An internal work field utilized for calculating the interest
|
| 50 |
TR_RVL_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
The market rate index selected as applicable to mark-to-market revaluation events.
|
| 51 |
TR_RVL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The market rate type selected as applicable to mark-to-market revaluation events.
|
| 52 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 53 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 54 |
TRANSACTION_DT |
Date(10) |
DATE |
Transaction date (often used as trade date)
|
| 55 |
TRA_REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that an accounting entry for a given accounting template is subject to
|
| 56 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
|
| 57 |
ACCTG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the state of a set of accounting entries.
C=Needs Correction
E=Error
F=Final
P=Provisional
|
| 58 |
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
|
| 59 |
ACCTG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work flag utilized in automated accounting processing.
|
| 60 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 61 |
TRA_ALL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing switch for selecting all transaction types which include Bank Statements, Bank Transfers, Deals Transactions, Facility Fees and Treasury Wires.
|
| 62 |
TRA_BANK_ALL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Bank Statements and Bank Transfers.
|
| 63 |
TRA_BANK_STMT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Bank Statements
|
| 64 |
TRA_BANK_TRANSF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Bank Transfers
|
| 65 |
TRA_DEALS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Deals
|
| 66 |
TRA_FAC_FEES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Facility Fees
|
| 67 |
TRA_TR_WIRES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Treasury Wires
|
| 68 |
TRA_INT_ACT_INT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal Account Interest
|
| 69 |
TRA_HEDGES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Deals
|
| 70 |
TRA_POOLS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Investment Pools
|
| 71 |
TRA_SOURCE_CHECKED |
Character(100) |
VARCHAR2(100) NOT NULL |
Storing the source codes selected for accounting run in format acceptable for AE.
|
| 72 |
TRA_ALL_EVENTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding all accrual Accounting Event Types.
|
| 73 |
TRA_EVENT_09_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 09 - Interest Accrual.
|
| 74 |
TRA_EVENT_10_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 10 - Discount Accrual.
|
| 75 |
TRA_EVENT_11_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 11 - Forward Points Accrual.
|
| 76 |
TRA_EVENT_12_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 12 - Fee Accrual.
|
| 77 |
TRA_EVENT_17_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 17 - Option Premium Accrual.
|
| 78 |
TRA_EVENT_CHECKED |
Character(100) |
VARCHAR2(100) NOT NULL |
Storing the excluded accounting events types selected for accounting run in a format acceptable for AE.
|
| 79 |
TRA_DEAL_OPT_INSTR |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Instrument Type run options
|
| 80 |
TRA_DEAL_OPT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Treasury Accounting Deal OPRID run options
|
| 81 |
TRA_DEAL_OPT_PORTF |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Portfolio run options
|
| 82 |
TRA_DEAL_OPT_TRDID |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Portfolio run options
|
| 83 |
TRA_ACCT_FR_DT |
Date(10) |
DATE |
Treasury Automated Accounting From Date
|
| 84 |
TRA_ACCT_TO_DT |
Date(10) |
DATE |
Treasury Automated accounting To Date field
|
| 85 |
TRA_1_EVENT_RUN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Event ID
|
| 86 |
TRA_DEAL_OPT_EVENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Single Event run options
|
| 87 |
SCHED_PROC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This is called from process scheduler and is a y/n edit box
|
| 88 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 89 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 90 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 91 |
CF_INHERIT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: CF_INHERIT_TBL.CF_INHERIT_GRP.SearchInit
APCA=Payables Header Level Entries
APEA=Payables Distrib Level Entries
APPE=Payables Period End Accruals
APVN=Payables VAT Non-Recoverable
ARBI=Receivables and Billing
ARRE=Receivables Revaluation
DMAC=Deduction Management Accounts
EXCA=Expenses Control Accounts
EXCR=Expenses Cash Advance Recon
EXPY=Expenses Payroll Offset
EXVN=Expenses VAT Non-Recoverable
GLVI=GL Journal VAT Input Other
GLVN=GL Journal VAT Non-Recoverable
GLVO=GL Journal VAT Output
POCA=Purchasing Control Accounts
POEA=Purchasing Expense Accounts
POVN=Purchasing VAT Non-Recoverable
TDAC=Promotions Mgmt. Accounts
TRVI=Treasury VAT Input Other
TRVN=Treasury VAT Non-Recoverable
TRVO=Treasury VAT Output
|
| 92 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 93 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 94 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 95 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 96 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 97 |
ORIG_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the original creation and saving of a given transaction.
|
| 98 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 99 |
SQLROWS |
Number(5,0) |
INTEGER NOT NULL |
SQL Rows
|
| 100 |
BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
|
| 101 |
MAX_LENGTH |
Number(2,0) |
SMALLINT NOT NULL |
Maximum Length of Auto Number
|
| 102 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 103 |
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.
|
| 104 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
Default Value: 0
|
| 105 |
TR_GL_INTEGRATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Treasury to Enterprise One GL Integration flag
|
| 106 |
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.
|
| 107 |
SUB_RULE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
The unique key identifier for a given accounting template substitution rule.
|
| 108 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
|
| 109 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 110 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 111 |
LENGTH_MAX |
Number(5,0) |
INTEGER NOT NULL |
Maximum Length
|
| 112 |
MC_AMOUNT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi Curreny Amount Switch Flag
Default Value: N
|
| 113 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 114 |
AMOUNT_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used by Golden Tax Adapter, created by SOS
|