The following table contains the legend for the Cash Inflow Source Types table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| R = Required | ARR = Customer Receipts | OII = Open Interface Inflow |
| O = Optional | XTRI = Treasury Inflow | CEI = Cash Management Inflow |
| Y = Required if Include Overdue Transactions is Yes | UDI = User-Defined Inflow |
The following table displays characteristics, such as required or optional, of the applicable fields for each source type you can enter in the Cash Position Worksheet page.
| ARR | XTRI | UDI | OII | CEI | |
|---|---|---|---|---|---|
| Description | O | O | O | O | O |
| Bank Account | O | ||||
| Transaction Type | O | ||||
| Include Indicative Exposures? | R | ||||
| External Source Type | R | ||||
| Forecast Selection Criteria Descriptive Flexfield | O | ||||
| Receipt Method | O | O | |||
| Transaction Subtype | |||||
| Include Cleared Transactions? | R | R | R | ||
| Include Overdue Transactions? | R | R | R | ||
| Cut Off Days | Y | Y | Y | ||
| Amount | O |
The following table contains the legend for the Cash Outflow Source Types table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| R = Required | APP = Supplier Payments | UDO = User-Defined Outflow |
| O = Optional | PAY = Payroll Expenses | OIO = Open Interface Outflow |
| Y = Required if Include Overdue Transactions is Yes | XTRO = Treasury Outflow | CEO = Cash Management Outflow |
The following table displays characteristics, such as required or optional, of the applicable fields for each source type you can enter in the Cash Position Worksheet page.
| APP | PAY | XTRO | UDO | OIO | CEO | |
|---|---|---|---|---|---|---|
| Description | O | O | O | O | O | O |
| Business Group | O | |||||
| Payroll Name | O | |||||
| Bank Account | O | |||||
| Include Indicative Exposures? | R | |||||
| Transaction Type | O | |||||
| External Source Type | R | |||||
| Forecast Selection Criteria Descriptive Flexfield | O | |||||
| Receipt Method | O | O | ||||
| Transaction Subtype | O | |||||
| Include Cleared Transactions? | R | R | R | |||
| Include Overdue Transactions? | R | R | R | |||
| Cut Off Days | Y | Y | Y | |||
| Amount | O |
Worksheet Name: A unique name for your cash position worksheet.
Number of Columns Displayed in Results: The number of columns that should be displayed in each page of your cash position results. The default is 20.
Use Calculated Prior Day Cash Flow and Overdue Transactions Balances: Indicates if you want to use calculated or real-time prior day cash flow and overdue transactions balances. The default is No.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Legal Entity: (Optional) A legal entity that you want to generate the cash position for. You can select a legal entity or leave this field blank to collect source data for all legal entities. You can have multiple rows of a bank account balance in your worksheet. Each row can be for a different legal entity, or you can have one row represent all legal entities.
Bank: (Optional) The bank whose transactions you want to include in the cash position. You can select a bank name or leave this field blank to include all banks.
Bank Account: (Optional) The bank account whose transactions you want to include in the cash position. You can select a bank account or leave the Bank Account field blank to include all bank accounts. The list of values is controlled by CE: Bank Account Security profile option. See: Profile Options in Cash Management.
Attention: If you selected a bank name in the Bank field and/or a legal entity, you should include bank accounts that belong to the selected bank and legal entity.
Balance Type: Select a value in this field to indicate the type of balance to be used for the opening balance of the bank accounts included in the cash pool. Options include: Available Balance, Value Dated Balance, and Ledger Balance.
Float Type: Select a value in this field to adjust your opening bank account balance. Options include: Add One Day Float, Add Two Day Float, None, Subtract One Day Float, and Subtract Two Day Float.
Cash Pool Name: The name of the cash pool.
Balance Type: The type of balance to be used for the opening balance for the bank accounts included in the cash pool. Options include: Available Balance, Value Dated Balance, and Ledger Balance.
Float Type: Select a value in this field to adjust the opening balance of the bank accounts included in the cash pool. Options include: Add One Day Float, Add Two Day Float, None, Subtract One Day Float, and Subtract Two Day Float.
Include intra-day activities in the Cash Position. Choose to include or exclude intra-day activities from the cash position results. Choices include No, Display but do not include in closing balance, and Display and include in closing balance.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Transaction Type: The type of transactions that you want to include in your cash position for the intra-day activities source. Choices include: All, Miscellaneous Payment, Miscellaneous Receipt, Non-Sufficient Funds, Payment, Receipt, Rejected, Statement, and Stopped.
Description (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Payment Method (Optional) The user-defined Receivables choice to account for receipt entries and applications.
Include Cleared Transactions? : (Optional) Indicates if you want to include transactions that have been cleared on the As of Date.
Include Overdue Transactions? : (Optional) Indicates if you want to include or exclude open transactions that have a cash activity date before the cash position As Of Date.
Cut Off Days: If you choose to include overdue transactions, you must enter a value. The value you enter determines how far back to include overdue transactions.
Attention: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long, and you are including many historical transactions, then the position may take longer to generate.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Transaction Type: The type of transactions that you want to include in your cash position for the Treasury Inflow and Outflow sources. The list of values displays the transaction types that are seeded in Oracle Treasury.
Include Indicative Exposures: For Treasury Inflow and Outflow, if you select Yes, you can include transactions in the cash position as follows:
Yes: Indicative. Include all transactions including those that may or may not occur.
No: Firm. Include only transactions that definitely have occurred or will occur.
Include Cleared Transactions? : (Optional) Indicates if you want to include transactions that have been cleared on the As of Date.
Include Overdue Transactions? : (Optional) Indicates if you want to include or exclude open transactions that have a cash activity date before the cash position As Of Date.
Cut Off Days: If you chose to include overdue transactions, you must enter a value. The value you enter determines how far back to include overdue transactions.
Attention: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long and you are including many historical transactions, then the position may take longer to generate.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
External Source Type: Indicates the user-defined external source type for Open Interface Inflow or Open Interface Outflow. The list of values is from the Context field of the Forecast Selection Criteria Descriptive flexfield you created during setup of the External Cashflow Open Interface.
Forecast Selection Criteria: The descriptive flexfield that indicates the external forecast selection criteria based on the external source type you entered in the previous field for Open Interface Inflow or Open Interface Outflow sources. The list of values is from the segments you defined for the Forecast Selection Criteria Descriptive flexfield.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Amount: (Optional) The amount of the user-defined inflow and outflow. The user can now update the amount as desired at any point to decide the cash position.
Bank Account: (Optional) The bank account to which the user-defined inflow and outflow amounts belong. This could be valid for all banks or a specific bank marked in the worksheet..
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Payment Method: (Optional) Payment methods predefined in Oracle Payables for how suppliers' invoices can be paid. Choices include: Check, Electronic, Wire, Future Dated, Manual Future Dated, and Clearing.
Include Cleared Transactions? : (Optional) Indicates if you want to include transactions that have been cleared on the As Of Date.
Include Overdue Transactions? : (Optional) Indicates if you want to include or exclude open transactions that have a cash activity date before the cash position As Of Date.
Cut Off Days: If you chose to include overdue transactions, you must enter a value. The value you enter in the determines how far back to include overdue transactions.
Attention: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long and you are including many historical transactions, then the position may take longer to generate.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Payroll Name: (Optional) Indicates the name of the payroll to include in the cash position. Leave this field blank to include cash flows from all payrolls.
Payment Method: (Optional) Predefined and user-defined payment methods in Oracle Payroll for how employees' payroll can be paid. Predefined choices include: Cash, Check, and NACHA (National Automated Clearing House Association).