| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
STL_APPROVALS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to enable workflow worklist processing for the submission of pending settlements
Y/N Table Edit
Default Value: N
|
| 3 |
STL_APPROV_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate the approval methodology for settlement transactions.
1=Manual
2=Workflow
3=Approval Framework
|
| 4 |
STL_SEL_APPROV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to detemrine if the same user can select and approve a transaction.
Y/N Table Edit
Default Value: Y
|
| 5 |
STL_CREATE_APP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Same User Create and Approve
Y/N Table Edit
Default Value: Y
|
| 6 |
TR_CONFIRM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the automated inbound confirmation feature has been enabled
Y/N Table Edit
Default Value: N
|
| 7 |
TR_CONFO_MAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate than the workflow e-mail delivery feature for rejected deal
Y/N Table Edit
Default Value: N
|
| 8 |
TR_PREAPPR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the deal preview workflow feature has been enabled in the Treasury options
Y/N Table Edit
Default Value: N
|
| 9 |
DEAL_APPRV_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Deal Approval Method
01=Workflow
02=Approval Framework
|
| 10 |
TR_RVL_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
The market rate index selected as applicable to mark-to-market revaluation events.
Prompt Table:
RT_INDEX_FX_VW
|
| 11 |
TR_RVL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The market rate type selected as applicable to mark-to-market revaluation events.
Prompt Table:
RT_TYPE_TBL
|
| 12 |
TR_SCHD_POSN_CREAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows a user to indicate whether the position creation process shall be executed i
Y/N Table Edit
Default Value: N
|
| 13 |
TR_SCHD_RUN_CTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Unique run control key identifier for the background position creation process.
Prompt Table:
PRCSRUNCNTL
|
| 14 |
TR_SCHD_RUNLOCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Designates whether the background position creation process is to be executed on the client or the server
0=Both
1=Client
2=Server
Default Value: 2
|
| 15 |
TR_SCHD_SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Designates the servername for the background position creation process.
Prompt Table:
SERVERDEFN
|
| 16 |
TR_BX_APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the assigned General Ledger journal template associated with bank transfers subject t
Prompt Table:
JRNLGEN_APPL_ID
|
| 17 |
TR_CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
The calendar ID selected as applicable for running the Treasury Automated Accounting process (TR_ACCTG).
Prompt Table:
CAL_DETL_VW
|
| 18 |
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
Y/N Table Edit
Default Value: N
|
| 19 |
HEDGE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of Hedge, either: FAS 133, IAS39, or Economic/Other
133=FAS 133 Hedge
39=IAS39 Hedge
OTH=Economic / Other Hedge
Default Value: 133
|
| 20 |
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.
|
| 21 |
DOC_TYPE_BAX_FROM |
Character(8) |
VARCHAR2(8) NOT NULL |
From Document Type
Prompt Table:
DOC_TYPE_TBL
|
| 22 |
DOC_TYPE_BAX_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
To Document Type
Prompt Table:
DOC_TYPE_TBL
|
| 23 |
TRP_ENTRY_APPR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable same user entry and approval
Y/N Table Edit
Default Value: Y
|
| 24 |
TR_ACCTG_PAID_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
Account for Items Before Paid
Y/N Table Edit
Default Value: N
|
| 25 |
TRA_REVIEW_MAN_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Manual Updates
Y/N Table Edit
Default Value: N
|