[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:
FUN
FUN_TRANSFERS#
|
|
|
|