Treasury Definitions Center

Treasury Definitions Center

Access links, grouped by logical function, to setup pages for Treasury Management products. For easier retrieval, you can save this page in the My Favorites folder on the portal navigation menu.

Banks

Click Banks.

Access pages to set up comprehensive bank information (such as bank, bank account, and bank branch information).

See Setting Up Banks.

See Setting Up Counterparties.

See Setting Up External, Internal, and Netting Accounts.

See Defining Internal Account Information.

See Defining Common Journal Definitions.

Business Unit Related

Click Business Unit Related.

Access the Treasury Options page and specify Treasury Management-specific options for your business units.

See Defining Treasury Business Unit Options.

Fees

Click Fees.

Access pages to set up fee codes, tables, and structures.

See Setting Up Fee Structures.

Facilities

Click Facilities.

Access pages to set up and update facility information.

See Defining Facilities.

Settlements/Netting

Click Settlements/Netting.

Access pages to set up bilateral netting rules, participants, and contracts.

See Setting Up Bilateral Nets.

Position Worksheet

Click Position Worksheet.

Access pages to set up field types, position sources, SQL, and time spans for position worksheets.

See Setting Up Trees and Positions.

Funds Transfer

Click Funds Transfer.

Access pages to set up and approve funds transfer templates.

See Creating and Approving Funds Transfer Templates.

Bank Integration

Click Bank Integration.

Access pages to define and manage integration information between PeopleSoft and your banks, for your bank statement and payment activities.

See Setting Up Electronic Banking Using Financial Gateway.

Rates

Click Rates.

Access pages to set up exchange rate, market rates, rate reset codes, and currency/holiday cross-reference information.

See Defining Cross-Referenced Currency Codes and Holiday List IDs.

See Defining Market Rates.

Accounting

Click Accounting.

Access pages to set up accounting templates and events.

See Establishing Accounting Templates.

Investment Pools

Click Investment Pools.

Access pages to set up and update investment pool and participant information.

See Managing Investment Pools.

Deals and Instrument Types

Click Deals/Instrument Types.

Define deal instruments and templates, and perform deal portfolio activities.

See Defining Instrument Types and Instrument Templates.

See Capturing Deals and Trade Tickets.

Analytics

Click Analytics.

Define risk management analytic functions, calculations, and vendor information.

See Analyzing Risk.

Hedges

Click Hedges.

Set up hedge groups, item sources, and strategies.

See Creating and Maintaining Hedges.

Installation Options – Treasury

Set Up Financials/Supply Chain, Install, Installation Options, Treasury

Define integration options for accounting, EnterpriseOne integration, and Financial Gateway functionality.

See Defining Treasury Installation Options.

Business Calendar

Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Business Calendar

Indicate business days, nonbusiness days, and holidays for use in Cash Management and Deal Management processing functions.

See Defining Business Calendars.

Bank Statement Accounting

Banking, Administer Reconciliation, Bank Statement Accounting

Define bank statement accounting match rules. The system searches the bank statement addenda for the transactional text you define, and automatically assigns a default accounting template to the transaction.

See Setting Up Cash Management Bank Statement Accounting Functionality.

ChartField Security

Set Up Financials/Supply Chain, Security, ChartField Security

Set up ChartField security for Treasury components.

See Securing ChartFields.

Treasury Options

BUS_UNIT_OPT_TR

Set Up Financials/Supply Chain, Business Unit Related, Treasury, Treasury Options

Set up default processing options specific to your Treasury business units.

Enable WF Deal Preview (enable workflow deal preview)

Select to enable deal preview workflow processes. The system uses this option to generate workflow notification for three deals workflows (if you have implemented workflow).

With this option selected, the following workflows are activated when meeting certain conditions:

• When the deal approval status is Submitted this activates the Deal Preapprovals workflow.

• When the Auto Preview flag on the Instrument Detail page is Yes, and the deal status is Not Reviewed, this activates the Review Deal Terms workflow.

• When the Review at Confirmation box is checked on the Instrument Detail page (set to Yes), the deal confirmation review status is Not Reviewed, and the deal status is Open or Sold/Bought back, this activates the Review at Confirmation workflow.

Enable WF Auto Confo Worklist (enable workflow automatic confirmation worklist)

Select to enable automated inbound deal confirmation workflow processes.

Enable WF Invalid Confo Mail (enable workflow invalid confirmation mail)

Select to enable workflow-based electronic mail processes for invalid or unmatched deal terms found during online confirmation.

Calendar ID

Select a detail calendar for the business unit.

Note. You must define calendars for business units that you intend to "soft-close" using the Cash Management Fiscal Period Closure functionality.

See Maintaining Fiscal Period Closure.

Internal Entity Code

Select the inbound entity code to use for business units.

External Entity Code

Select the outbound entity code to use for counterparties.

Market Rate Index and Exchange Rate Type

Select the appropriate index for each field. The system uses these fields to calculate base currency equivalents for foreign currency amounts when accounting entries are generated from accounting templates.

Require Review

Select to force accounting transactions that use this template to be reviewed. The system assigns error-free accounting entries using this template a Provisional status. You can then manually finalize the entry on the Review/Approve Entries page. If this check box is deselected, the system assigns error-free accounting entries using this template a Final status.

Journal Template

Select the journal template this business unit uses for its bank transfer accounting builds.

BU Doc Sequencing Enabled

Select to activate document sequencing functionality for this business unit's transactions.

See Defining Document Sequencing.

From Document Type

If using document sequencing, define the document type to be used for assigning a document sequence number to the outbound bank account transfer transaction.

To Document Type

If using document sequencing, define the document type to be used for assigning a document sequence number to the inbound bank account transfer transaction.

Settlement Approvals and Approval Method

Select to require approval for settlements involving this business unit. In the Approval Method field, select the type of approval, either Manual (manual approvals) or Workflow (approvals based on PeopleSoft Workflow).

Same User Select and Approve

Select to enable the same user to both select and approve settlements.

Auto-Schedule Position Update

You must process a position update request for each deal to create the required records for position management, cash flows, and accounting events for your deals. If you select the check box, the system automatically processes a position update request, which creates the required records for position management and accounting, when you save an active deal. We recommend that you select this check box.

Position Update Run Control ID

Enter the run control ID to use for the automatically created position update requests; for example, enter AUTO-POSITION. Specify this run control on the Treasury Options page.

Server Name

Specify the name of the PeopleSoft Process Scheduler server that runs position update request processes. If you leave this field blank, the system uses the Default Operating System field as specified on the System Settings page to determine which server to run the process on.

Hedge Type

Select the accounting method used for the business unit's reporting of hedge and derivative transactions. The options are:

• Economic / Other Hedge: Select if using a hedging accounting treatment other than IAS 39 or FAS 133.

• IAS 39 Hedge: Complies with the IAS 39 accounting regulations as defined by the International Accounting Standards Committee for financial reporting of derivatives and hedging transactions.

• FAS 133 Hedge: Complies with the FAS 133 accounting regulations as defined by the Financial Accounting Standards Board for financial reporting of derivatives and hedging transactions.

Note. A Treasury business unit can comply to only one set of accounting regulations. Treasury does not support multibook accounting.

Treasury VAT Options

Click to access the Treasury BU VAT Options page and specify default VAT options for this business unit. The Treasury VAT Options link is available only if the General Ledger business unit that represents the Treasury Management business unit is linked to a VAT entity.

See Defining Treasury Business Unit VAT Options.

VAT Defaults

Click to access the VAT Defaults Setup page.

The VAT Defaults Setup page is a common page used to set up VAT defaulting for all PeopleSoft applications processing VAT transactions. On this page you can define Treasury business unit defaults as applicable.

See Working with VAT.

Currency Code - Holiday List ID Cross Reference

CUR_HOL_ID_XREF

Set Up Financials/Supply Chain, Product Related, Treasury, Currency/Holiday List X-Ref

Associate a holiday list with a particular currency.

Holiday List ID

Associate a holiday list ID with a specified currency code. You can also create additional currency codes and associate holiday list IDs to them.

Market/Exchange Code

TRX_EXCHANGE_CD

Set Up Financials/Supply Chain, Product Related, Treasury, Market/Exchange Codes

Define market and exchange information for a code.

Market Rates

RT_RATE_TBL

Set Up Financials/Supply Chain, Product Related, Treasury, Market Rates

Specify criteria by which to review rates and to add or update rates.

Market Rates - Market Rate

RT_RATE_PNL

Set Up Financials/Supply Chain, Common Definitions, Market Rates, Market Rates - Market Rate

Click Edit on the Market Rates page.

View details of a market rate, add a new market rate, and view exchange rate detail information.

Note. To set up history rates for existing market rates, use the component in Set Up Financials/Supply Chain - Common Definitions - Market Rates.

Rate Definition

RT_RATE_DEF_SEC

Click Rate Definition on the Market Rates - Market Rates page.

Edit the maximum variance and error type information.

Exchange Rate Detail

EXCH_RT_DTL

Click the Exchange Rate Detail icon on the Market Rates - Market Rates page.

View exchange rate detail information.

Rate Reset Codes

TRX_RT_RESET_CD

Set Up Financials/Supply Chain, Product Related, Treasury, Rate Reset Codes

Define and associate a holiday list ID to a rate reset code.

Term

Specify a term code, indicating the length of time the rate is effective.

Rate Type

Select a market rate or exchange rate type.

From Cur (from currency) and To Cur (to currency)

Select the original and conversion currencies of the market rate.

Include History

Select to view market rate history for returned results.

Add New Market Rate

Click to access the Market Rates detail page and add a new rate type. The market rate definition (and, in the case of exchange rates, the currency quotation method for the from currency and to currency) must already exist.

Click the Edit button to access the Market Rates - Market Rate page, and edit effective date and rate information.

Note. To set up history rates for existing market rates, use the component in Set Up Financials/Supply Chain - Common Definitions - Market Rates.

Click the Rate Defn (rate definition) button to access the Rate Definition page, and view information on the rate's maximum variance, error type, and day count basis.

Click the Rate Detail button to access the Exchange Rate Detail page, and view exchange rate detail information.

Maximum Variance

The variance value validates the rates read from the market rate loader process. The system compares the prior historical rate to the one read and ensures that it's within a specified variance. If not, you are alerted with the specified error type. Enter a new Maximum Variance, and specify an Error Type of None, Stop, or Warning.