[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_IG_BANK_ACCOUNTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XTR.XTR_IG_BANK_ACCOUNTS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
XTR_IG_BANK_ACCOUNTS_V contains information on your intercompany bank accounts. This account information is really a subset of columns from the XTR_BANK_ACCOUNTS table. Each row in XTR_IG_BANK_ACCOUNTS corresponds to an intercompany bank account in XTR_BANK_ACCOUNTS. (An intercompany bank account is any account where the party who holds the bank account is cross referenced to a company.)
This view corresponds to the Bank Accounts tabbed region in the Parties window where the party is cross referenced to a company and the Intercompany Accounts tabbed region in the Journal Entry Actions window.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Database row identifier | |
| ACCOUNT_NUMBER | VARCHAR2 | (20) | Yes | Alpha-numeric reference to financial accounts of Treasury parties |
| PARTY_CODE | VARCHAR2 | (7) | Yes | Party code |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
| BANK_NAME | VARCHAR2 | (50) | Bank name | |
| BANK_SHORT_CODE | VARCHAR2 | (80) | Yes | Bank short code |
| LOCATION | VARCHAR2 | (35) | Yes | Bank location |
| STREET | VARCHAR2 | (35) | Yes | Street name |
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
| CREATED_ON | DATE | Yes | Date this record was created | |
| CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
| GL_COMPANY_CODE | VARCHAR2 | (7) | General Ledger company code | |
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| OPENING_BALANCE | NUMBER | Opening balance | ||
| OPENING_BAL_HCE | NUMBER | Opening balance in reporting currency equivalent | ||
| STATEMENT_DATE | DATE | Statement date | ||
| DEFAULT_ACCT | VARCHAR2 | (1) | Flag to indicate if the account is the default account (Y), or not (N) | |
| PARTY_TYPE | VARCHAR2 | (2) | Flag to indicate if the party is a company (C) or counterparty (CP) | |
| AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the bank account is authorized for use (Y), or not (N) | |
| SETOFF | VARCHAR2 | (5) | Setoff code of the nominal account | |
| BANK_CODE | VARCHAR2 | (7) | Bank code | |
| PARTY_PRIN_CCID | NUMBER | (15) | Code combination identifier of the general ledger account used to account for the principal cash flows of an intercompany account | |
| PARTY_INT_CCID | NUMBER | (15) | Code combination identifier of the general ledger account used to account for the interest cash flows of an intercompany account | |
| INTERNAL_PTY | VARCHAR2 | (1) | Flag to indicate if the party is an internal party (Y), or not (N) | |
| SETOFF_COMPANY | VARCHAR2 | (7) | Party code of the nominal account associated with this setoff account | |
| SETOFF_ACCOUNT_YN | VARCHAR2 | (1) | Flag to indicate if the account is a nominal account (Y), or not (null) | |
| INTEREST_CALCULATION_BASIS | VARCHAR2 | (4) | Interest calculation basis (STEP or FLAT) | |
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
| PRIMARY_SETTLEMENT_METHOD | VARCHAR2 | (15) | Not currently used | |
| DIRECT_DEBIT_AUTHORITY | VARCHAR2 | (1) | Flag to indicate whether the company has direct debit authority to this account (Y), or not (N) | |
| EFT_SCRIPT_NAME | VARCHAR2 | (50) | Settlement script | |
| EFT_SCRIPT_OUTPUT_PATH | VARCHAR2 | (50) | EFT script output path | |
| SUB_ACCOUNT_AT | VARCHAR2 | (100) | Not currently used | |
| SUB_ACCOUNT_NUMBER | VARCHAR2 | (20) | Not currently used | |
| CASHFLOWS_TO_CURRENT_DATE | NUMBER | Not currently used | ||
| CURRENT_CASHFLOW_DATE | DATE | Not currently used | ||
| PROJECTED_BALANCE | NUMBER | Projected balance of bank account based on future recorded cashflows | ||
| PROJECTED_BALANCE_DATE | DATE | Projected balance date | ||
| PROJECTED_BALANCE_UPDATED_ON | DATE | Date the projected balance was last updated | ||
| INTEREST_RATE | NUMBER | Interest rate | ||
| CROSS_REF_TO_OTHER_PARTY | VARCHAR2 | (7) | Party cross reference | |
| PARTY_NAME | VARCHAR2 | (50) | Yes | Full name of a party |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ACCOUNT_NUMBER
, PARTY_CODE
, CURRENCY
, BANK_NAME
, BANK_SHORT_CODE
, LOCATION
, STREET
, CREATED_BY
, CREATED_ON
, CODE_COMBINATION_ID
, GL_COMPANY_CODE
, UPDATED_BY
, UPDATED_ON
, OPENING_BALANCE
, OPENING_BAL_HCE
, STATEMENT_DATE
, DEFAULT_ACCT
, PARTY_TYPE
, AUTHORISED
, SETOFF
, BANK_CODE
, PARTY_PRIN_CCID
, PARTY_INT_CCID
, INTERNAL_PTY
, SETOFF_COMPANY
, SETOFF_ACCOUNT_YN
, INTEREST_CALCULATION_BASIS
, AUDIT_INDICATOR
, PORTFOLIO_CODE
, PRIMARY_SETTLEMENT_METHOD
, DIRECT_DEBIT_AUTHORITY
, EFT_SCRIPT_NAME
, EFT_SCRIPT_OUTPUT_PATH
, SUB_ACCOUNT_AT
, SUB_ACCOUNT_NUMBER
, CASHFLOWS_TO_CURRENT_DATE
, CURRENT_CASHFLOW_DATE
, PROJECTED_BALANCE
, PROJECTED_BALANCE_DATE
, PROJECTED_BALANCE_UPDATED_ON
, INTEREST_RATE
, CROSS_REF_TO_OTHER_PARTY
, PARTY_NAME
FROM APPS.XTR_IG_BANK_ACCOUNTS_V;
APPS
XTR_BANK_ACCOUNTS
XTR_PARTY_INFO
APPS.XTR_IG_BANK_ACCOUNTS_V is not referenced by any database object
|
|
|
|