[Home] [Help] [Dependency Information]
Object Name: | XTR_EXTERNAL_CASHFLOWS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_EXTERNAL_CASHFLOWS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_EXTERNAL_CASHFLOWS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
COMPANY_CODE
LEVEL_OF_SUMMARY TRX_TYPE AMOUNT_DATE CURRENCY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_CODE | VARCHAR2 | (7) | Yes | |
AMOUNT_DATE | DATE | Yes | ||
AMOUNT | NUMBER | Yes | ||
CURRENCY | VARCHAR2 | (15) | Yes | |
TRX_TYPE | VARCHAR2 | (240) | Yes | |
LEVEL_OF_SUMMARY | VARCHAR2 | (30) | Yes | |
AP_BANK_ACCOUNT_ID | NUMBER | AP Bank Account Reference |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_CODE
, AMOUNT_DATE
, AMOUNT
, CURRENCY
, TRX_TYPE
, LEVEL_OF_SUMMARY
, AP_BANK_ACCOUNT_ID
FROM XTR.XTR_EXTERNAL_CASHFLOWS;
XTR.XTR_EXTERNAL_CASHFLOWS does not reference any database object
XTR.XTR_EXTERNAL_CASHFLOWS is referenced by following:
|
|
|