[Home] [Help] [Dependency Information]
Object Name: | FUN_INTER_ACCOUNTS_ADDL |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_INTER_ACCOUNTS_ADDL |
Subobject Name: | |
Status: | VALID |
FUN_INTER_ACCOUNTS_addl table stores the accounts generated by balancing API after replacing the intercompany and balancing segment value from the Intercompany receivables and payables accounts with the trading partner and transacting BSV
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FUN_INTER_ACCOUNTS_ADDL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FROM_LE_ID
LEDGER_ID TO_LE_ID DEFAULT_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_LE_ID | NUMBER | (15) | Yes | Transacting or Initiating Legal Entity identifier |
LEDGER_ID | NUMBER | (15) | Yes | Transacting or Originating Ledger identifier |
TO_LE_ID | NUMBER | (15) | Yes | Trading or Receiving Legal Entity identifier |
CCID | NUMBER | (15) | Yes | Code combination of account |
TYPE | VARCHAR2 | (30) | Yes | Type of account. Valid values are - R (Intercompany Receivables) and P (Intercompany Payables) |
ACCT_DESC | VARCHAR2 | (240) | Natural account segment description. Currently not Used. | |
START_DATE | DATE | Yes | Start date for accounts | |
END_DATE | DATE | End date for accounts | ||
DEFAULT_FLAG | VARCHAR2 | (1) | Flag to indicate the default account to be used in case of multiple accounts being setup for the same rule. | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
TRANS_BSV | VARCHAR2 | (150) | Transaction or Initiating balancing segment value | |
TP_BSV | VARCHAR2 | (150) | Trading or receiving balancing segment value |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_LE_ID
, LEDGER_ID
, TO_LE_ID
, CCID
, TYPE
, ACCT_DESC
, START_DATE
, END_DATE
, DEFAULT_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TRANS_BSV
, TP_BSV
FROM FUN.FUN_INTER_ACCOUNTS_ADDL;
FUN.FUN_INTER_ACCOUNTS_ADDL does not reference any database object
FUN.FUN_INTER_ACCOUNTS_ADDL is referenced by following:
|
|
|