[Home] [Help] [Dependency Information]
Object Name: | FUN_BAL_RESULTS_T |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_BAL_RESULTS_T |
Subobject Name: | |
Status: | VALID |
FUN_BAL_RESULTS_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 | |
BAL_SEG_VAL | VARCHAR2 | (25) | ||
ENTERED_AMT_DR | NUMBER | (15) | Entered debit amount | |
ENTERED_AMT_CR | NUMBER | (15) | Entered credit amount | |
ENTERED_CURRENCY_CODE | VARCHAR2 | (15) | Entered currency code | |
EXCHANGE_DATE | DATE | Currency exchange date | ||
EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
ACCOUNTED_AMT_DR | NUMBER | Accounted debit amount | ||
ACCOUNTED_AMT_CR | NUMBER | Accounted credit amount | ||
CCID | NUMBER | (15) | Code combination identifier | |
JGZZ_RECON_STATUS | VARCHAR2 | (1) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_DATE | DATE | GL Reconciliation column. Currently not used. | ||
JGZZ_RECON_ID | NUMBER | (15) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_REF | VARCHAR2 | (240) | GL Reconciliation column. Currently not used. | |
JGZZ_RECON_CONTEXT | VARCHAR2 | (30) | GL Reconciliation column. Currently not used. | |
DR_BSV | VARCHAR2 | (25) | Debit balancing segment value | |
CR_BSV | VARCHAR2 | (25) | Credit balancing segment value | |
ACCT_TYPE | VARCHAR2 | (1) | Account Type | |
TEMPLATE_ID | NUMBER | (15) | Template identifier | |
LE_ID | NUMBER | (15) | Legal entity identifier | |
BALANCING_TYPE | VARCHAR2 | (1) | Balancing type |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, BAL_SEG_VAL
, ENTERED_AMT_DR
, ENTERED_AMT_CR
, ENTERED_CURRENCY_CODE
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, ACCOUNTED_AMT_DR
, ACCOUNTED_AMT_CR
, CCID
, JGZZ_RECON_STATUS
, JGZZ_RECON_DATE
, JGZZ_RECON_ID
, JGZZ_RECON_REF
, JGZZ_RECON_CONTEXT
, DR_BSV
, CR_BSV
, ACCT_TYPE
, TEMPLATE_ID
, LE_ID
, BALANCING_TYPE
FROM FUN.FUN_BAL_RESULTS_T;
FUN.FUN_BAL_RESULTS_T does not reference any database object
FUN.FUN_BAL_RESULTS_T is referenced by following:
|
|
|