Cash Management Implementation
PeopleSoft Setup Manager enables you to review a list of setup tasks for your organization for the products that you are implementing. The setup tasks include the components that you must set up, listed in the order in which you must enter data into the component tables, and links to the corresponding documentation.
Cash Management also provides component interfaces to help you load data from your existing system into Cash Management tables. Use the Excel to Component Interface utility with the component interfaces to populate the tables.
This table lists all of the components that have component interfaces:
| Component | Component Interfaces | References |
|---|---|---|
|
Account (GL_ACCOUNT) |
ACCOUNT_CF |
|
|
Alternate Account (ALTACCT) |
ALTACCT_CF |
See Application Fundamentals: Adding and Mapping Accounts and Alternate Accounts. |
|
Operating Unit (OPERATING_UNIT) |
OPER_UNIT_CF |
|
|
Department (DEPARTMENT) |
DEPT_CF |
|
|
Fund Code (FUND_DEFINITION) |
FUND_CF |
|
|
Statistics Code (STATISTICS_TBL) |
STATISTICS_CODE |
|
|
Class Field (CLASS_PNL) |
CLASS_CF |
|
|
Budget Reference (BUDREF_PNL) |
BUDGET_REF |
|
|
Program Code (PROGRAM_DEFINITION) |
PROGRAM_CF |
|
|
Scenario (BD_SCENARIO) |
BUDGET_SCENARIO |
|
|
ChartField 1 (CHARTFIELD1) |
CHARTFIELD1 |
|
|
ChartField 2 (CHARTFIELD2) |
CHARTFIELD2 |
|
|
ChartField 3 (CHARTFIELD3) |
CHARTFIELD3 |
|
|
Interunit Template (IU_INTER_TMPLT) |
IU_INTER_TMPLT |
|
|
Intraunit Template (IU_INTRA_TMPLT) |
IU_INTRA_TMPLT |
|
|
Interunit Pair Maintenance (IU_INTER_PR_BASIC) |
IU_INTER_PR_BASIC |
|
|
Ledgers for a Unit (BUSINESS_UNIT_LED) |
EM_BUS_UNIT_LED |
See Application Fundamentals: Defining Ledgers for a Business Unit. |
|
Value Added Tax Code (TAX_CODE_VAT) |
TAX_CODE_VAT |
See PeopleSoft Global Options and Reports: Value Added Tax Code Page. |
|
VAT Accounts by Business Unit (TAX_BU_CODE_VAT) |
TAX_BU_CODE_VAT |
See PeopleSoft General Ledger: General Ledger Definition - VAT Defaults Page. |
|
VAT Entity (VAT_ENTITY_ID) |
VAT_ENTITY_ID |
See PeopleSoft Global Options and Reports: Setting Up VAT Entities. |
|
Vat Defaults CI Component (VAT_DEF_CI) |
VAT_DEF_CI |
See PeopleSoft Global Options and Reports: Establishing VAT Defaults. |
|
Bank Branch Information (BANK_BRANCHPNL) |
TR_BANK_BRANCH_CI |
See PeopleSoft Banks Setup and Processing: Bank Branch Information Page. |
|
Financial Contacts (CONTACTS) |
TR_FINANCIAL_CONTACTS_CI |
See PeopleSoft Banks Setup and Processing: Contact Information Page. |
|
Netting Participants (NET_PARTICIPANT) |
TR_NET_PARTICIPANT_CI |
|
|
Contact Info (CONTACT_INFO) |
CONTACT |
See PeopleSoft Order to Cash Common Information: Setting Up and Maintaining Contacts. |
|
General Information (CUSTOMER_GENERAL) |
CUSTOMER_MAIN_CI |
See PeopleSoft Order to Cash Common Information: Adding General Customer Information. |
|
User Preferences (OPR_DEFAULT) |
OPR_DEFAULT_FIN |
See Application Fundamentals: Defining Cross-Application User Preferences. |
|
Fee Codes (DEFINE_FEE_CODE) |
TR_DEFINE_FEE_CODE_CI |
See Fee Codes Page. |
|
Settlement Instructions (SETTLEMENT_INSTRUC) |
TR_SETTLEMENT_INSTRUCTIONS_CI |
See PeopleSoft Banks Setup and Processing: Beneficiary Bank Page. |
|
Treasury Facility Review (FCLTY_DFN) |
TR_FCLTY_BCI |
See Defining Facilities. |
|
Reconciliation Exceptions (TR_UNRECON_TRANS) |
TR_UNRECON_TRANS |
See PeopleSoft Banks Setup and Processing: Understanding Bank Reconciliation Configuration. |
|
Treasury Position Time Span (POS_TIME_SPAN_PNL) |
TR_POS_TIME_SPAN |
See PeopleSoft Deal Management: Setting Up Dealing Trees and Deal Positions. |
|
Create Position SQL (POS_CREATE_SQL) |
TR_POS_CREATE_SQL |
See PeopleSoft Deal Management: Setting Up Dealing Trees and Deal Positions. |
|
Manual Position Entry (POS_GENERIC_ENTRY) |
TR_MANUAL_POSITION_ENTRY_CI |
See PeopleSoft Deal Management: Setting Up Dealing Trees and Deal Positions. |
|
Netting Accounts (BANK_PNLNET) |
TR_NETTING_ACCOUNTS_CI |
See PeopleSoft Banks Setup and Processing: Defining Netting Accounts. |
|
External Bank Accounts (BANK_EXTERNAL) |
TR_EXTERNAL_ACCOUNTS_CI |
See PeopleSoft Banks Setup and Processing: Defining External Account Information. |
|
External Transactions (GEN_TRAN_UPDT) |
TR_EXTERNAL_TRANSACTIONS_CI |
See PeopleSoft Banks Setup and Processing: Reconciling Externally Generated Transactions. |
Other Sources of Information
In the planning phase of your implementation, take advantage of all Oracle sources of information, including the installation guides and troubleshooting information.
Other resources appear in PeopleTools documentation. See the product documentation for PeopleTools: Setup Manager.
For information about using the Excel-to-Component Interface Utility, see the product documentation for PeopleSoft Enterprise Components.