[Home] [Help] [Dependency Information]
Object Name: | FUN_BAL_INTER_INT_T |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_BAL_INTER_INT_T |
Subobject Name: | |
Status: | VALID |
FUN_BAL_INTER_INT_T is a temporary table used internally by the Intercompany Balancing API.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | (15) | Group identifier | |
LEDGER_ID | NUMBER | (15) | Ledger identifier | |
GL_DATE | DATE | GL Date | ||
STATUS | VARCHAR2 | (5) | Status | |
DRIVING_DR_LE_ID | NUMBER | (15) | Driving debit legal entity identifier | |
DRIVING_CR_LE_ID | NUMBER | (15) | Driving credit legal entity identifier | |
INTERCOMPANY_MODE | NUMBER | (4) | Intercompany mode | |
LE_ID | NUMBER | (15) | Legal entity identifier | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered currency code | |
ACCOUNTED_AMT_CR | NUMBER | Accounted credit amount | ||
ACCOUNTED_AMT_DR | NUMBER | Accounted debit amount | ||
ENTERED_AMT_CR | NUMBER | Entered credit amount | ||
ENTERED_AMT_DR | NUMBER | Entered debit amount | ||
REC_ACCT | NUMBER | (15) | Receivables account | |
PAY_ACCT | NUMBER | (15) | Payables account | |
BAL_SEG_COLUMN_NAME | VARCHAR2 | (25) | Balancing segment column name | |
REC_BSV | VARCHAR2 | (25) | Receivables balancing segment value | |
PAY_BSV | VARCHAR2 | (25) | Payables balancing segment value | |
EXCHANGE_DATE | DATE | Currency exchange date | ||
EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
TYPE | VARCHAR2 | (1) | Type | |
DRIVING_DR_LE_BSV | VARCHAR2 | (25) | ||
DRIVING_CR_LE_BSV | VARCHAR2 | (25) | ||
LINE_LE_BSV | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, LEDGER_ID
, GL_DATE
, STATUS
, DRIVING_DR_LE_ID
, DRIVING_CR_LE_ID
, INTERCOMPANY_MODE
, LE_ID
, ENTERED_CURRENCY_CODE
, ACCOUNTED_AMT_CR
, ACCOUNTED_AMT_DR
, ENTERED_AMT_CR
, ENTERED_AMT_DR
, REC_ACCT
, PAY_ACCT
, BAL_SEG_COLUMN_NAME
, REC_BSV
, PAY_BSV
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, TYPE
, DRIVING_DR_LE_BSV
, DRIVING_CR_LE_BSV
, LINE_LE_BSV
FROM FUN.FUN_BAL_INTER_INT_T;
FUN.FUN_BAL_INTER_INT_T does not reference any database object
FUN.FUN_BAL_INTER_INT_T is referenced by following:
|
|
|