| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 4 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 5 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
Prompt Table:
TRA_COMBTMPL_VW
|
| 6 |
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.
Y/N Table Edit
Default Value: Y
|
| 7 |
TRA_BANK_ALL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Bank Statements and Bank Transfers.
Y/N Table Edit
Default Value: N
|
| 8 |
TRA_BANK_STMT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Bank Statements
Y/N Table Edit
Default Value: N
|
| 9 |
TRA_BANK_TRANSF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Bank Transfers
Y/N Table Edit
Default Value: N
|
| 10 |
TRA_DEALS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Deals
Y/N Table Edit
Default Value: N
|
| 11 |
TRA_FAC_FEES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Facility Fees
Y/N Table Edit
Default Value: N
|
| 12 |
TRA_TR_WIRES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Treasury Wires
Y/N Table Edit
Default Value: N
|
| 13 |
TRA_INT_ACT_INT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal Account Interest
Y/N Table Edit
Default Value: N
|
| 14 |
TRA_HEDGES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Deals
Y/N Table Edit
Default Value: N
|
| 15 |
TRA_DEAL_FEES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Deal Fees.
Y/N Table Edit
Default Value: N
|
| 16 |
TRA_WIRE_FEES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Wire Fees.
Y/N Table Edit
Default Value: N
|
| 17 |
TRA_LC_FEES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for selecting Letter of Crediit Fees.
Y/N Table Edit
Default Value: N
|
| 18 |
TRA_POOLS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Investment Pools
Y/N Table Edit
Default Value: N
|
| 19 |
TRA_SOURCE_CHECKED |
Character(100) |
VARCHAR2(100) NOT NULL |
Storing the source codes selected for accounting run in format acceptable for AE.
|
| 20 |
TRA_DEAL_OPT_INSTR |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Instrument Type run options
|
| 21 |
TRA_DEAL_OPT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Treasury Accounting Deal OPRID run options
|
| 22 |
TRA_DEAL_OPT_PORTF |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Portfolio run options
|
| 23 |
TRA_DEAL_OPT_TRDID |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Portfolio run options
|
| 24 |
TRA_ACCT_FR_DT |
Date(10) |
DATE |
Treasury Automated Accounting From Date
|
| 25 |
TRA_ACCT_TO_DT |
Date(10) |
DATE |
Treasury Automated accounting To Date field
Default Value: %date
|
| 26 |
TRA_1_EVENT_RUN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Event ID
|
| 27 |
TRA_DEAL_OPT_EVENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Treasury Accounting Deal Single Event run options
|
| 28 |
SCHED_PROC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This is called from process scheduler and is a y/n edit box
Y/N Table Edit
Default Value: N
|
| 29 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 30 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DETL_VW
|
| 31 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
Prompt Table:
CAL_DETP_FY_VW
|
| 32 |
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.
Prompt Table:
CAL_DETP_PER_VW
|
| 33 |
TRA_ALL_EVENTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding all accrual Accounting Event Types.
Y/N Table Edit
Default Value: N
|
| 34 |
TRA_EVENT_09_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 09 - Interest Accrual.
Y/N Table Edit
Default Value: N
|
| 35 |
TRA_EVENT_10_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 10 - Discount Accrual.
Y/N Table Edit
Default Value: N
|
| 36 |
TRA_EVENT_11_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 11 - Forward Points Accrual.
Y/N Table Edit
Default Value: N
|
| 37 |
TRA_EVENT_12_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 12 - Fee Accrual.
Y/N Table Edit
Default Value: N
|
| 38 |
TRA_EVENT_17_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting processing selection switch for excluding Accounting Event Type 17 - Option Premium Accrual.
Y/N Table Edit
Default Value: N
|
| 39 |
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.
|