[Home] [Help] [Dependency Information]
Object Name: | FUN_TRANSFERS |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_TRANSFERS |
Subobject Name: | |
Status: | VALID |
This table is no longer used.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FUN_TRANSFERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRX_ID
PARTY_TYPE_FLAG |
FUN_TRANSFERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRX_ID |
FUN_TRANSFERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_TYPE_FLAG |
FUN_TRANSFERS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY | VARCHAR2 | (15) | Deprecated | |
BATCH_NUMBER | VARCHAR2 | (20) | Deprecated | |
INITIATOR_NAME | VARCHAR2 | (360) | Deprecated | |
RECIPIENT_NAME | VARCHAR2 | (360) | Deprecated | |
TRX_TYPE_NAME | VARCHAR2 | (25) | Deprecated | |
TRX_TYPE_CODE | VARCHAR2 | (15) | Deprecated | |
PERIOD_NAME | VARCHAR2 | (15) | Deprecated | |
LEDGER_NAME | VARCHAR2 | (30) | Deprecated | |
TRX_STATUS | VARCHAR2 | (30) | Deprecated | |
AMOUNT_CR | NUMBER | Deprecated | ||
AMOUNT_DR | NUMBER | Deprecated | ||
DESCRIPTION | VARCHAR2 | (240) | Deprecated | |
PARTY_TYPE_FLAG | VARCHAR2 | (1) | Deprecated | |
ERROR_MSG | VARCHAR2 | (2000) | Deprecated | |
APPROVER | VARCHAR2 | (2000) | Deprecated | |
GL_DATE | DATE | Deprecated | ||
BATCH_DATE | DATE | Deprecated | ||
CUSTOMER | VARCHAR2 | (50) | Deprecated | |
SUPPLIER | VARCHAR2 | (80) | Deprecated | |
INVOICE_NUMBER | VARCHAR2 | (50) | Deprecated | |
ORG_ID | NUMBER | (15) | Deprecated | |
ORG_NAME | VARCHAR2 | (360) | Deprecated | |
REQUEST_ID | NUMBER | (15) | Deprecated | |
TRX_ID | NUMBER | (15) | Deprecated | |
INITIATOR_ID | NUMBER | (15) | Deprecated | |
RECIPIENT_ID | NUMBER | (15) | Deprecated | |
LEDGER_ID | NUMBER | (15) | Deprecated | |
ERROR_CODE | VARCHAR2 | (30) | Deprecated | |
PAYABLES_CCID | NUMBER | (15) | Deprecated | |
BATCH_ID | NUMBER | (15) | ||
LE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CURRENCY
, BATCH_NUMBER
, INITIATOR_NAME
, RECIPIENT_NAME
, TRX_TYPE_NAME
, TRX_TYPE_CODE
, PERIOD_NAME
, LEDGER_NAME
, TRX_STATUS
, AMOUNT_CR
, AMOUNT_DR
, DESCRIPTION
, PARTY_TYPE_FLAG
, ERROR_MSG
, APPROVER
, GL_DATE
, BATCH_DATE
, CUSTOMER
, SUPPLIER
, INVOICE_NUMBER
, ORG_ID
, ORG_NAME
, REQUEST_ID
, TRX_ID
, INITIATOR_ID
, RECIPIENT_ID
, LEDGER_ID
, ERROR_CODE
, PAYABLES_CCID
, BATCH_ID
, LE_ID
FROM FUN.FUN_TRANSFERS;
FUN.FUN_TRANSFERS does not reference any database object
FUN.FUN_TRANSFERS is referenced by following:
|
|
|