[Home] [Help] [Dependency Information]
Object Name: | JL_CO_GL_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_CO_GL_BALANCES |
Subobject Name: | |
Status: | VALID |
This table contains transaction balances by Third Party Identifier. A record will exist for each fiscal period for which there are transactions for the period. Balances will be kept only in the functional currency and are maintained by the Third Party Balances program.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_CO_GL_BALANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NIT_ID
CODE_COMBINATION_ID PERIOD_NAME SET_OF_BOOKS_ID |
JL_CO_GL_BALANCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOUNT_CODE |
JL_CO_GL_BALANCES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BALANCE_ID | NUMBER | (15) | Yes | Sequence generated ID |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | GL set of books Identifier |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Account code combination ID |
NIT_ID | NUMBER | (15) | Yes | ID of associated third party identifier |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
ACCOUNT_CODE | VARCHAR2 | (25) | Yes | Natural Account Segment Value |
PERIOD_NUM | NUMBER | (15) | Yes | Accounting Period Number |
PERIOD_YEAR | NUMBER | (15) | Yes | Accounting Period year |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Functional Currency Code |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting Period |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
BEGIN_BALANCE_CR | NUMBER | Beginning Credit Balance | ||
BEGIN_BALANCE_DR | NUMBER | Beginning Debit Balance | ||
PERIOD_NET_CR | NUMBER | Beginning net Credit Balance | ||
PERIOD_NET_DR | NUMBER | Beginning net debit Balance |
Cut, paste (and edit) the following text to query this object:
SELECT BALANCE_ID
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, NIT_ID
, CREATED_BY
, ACCOUNT_CODE
, PERIOD_NUM
, PERIOD_YEAR
, LAST_UPDATED_BY
, CURRENCY_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, PERIOD_NAME
, LAST_UPDATE_LOGIN
, BEGIN_BALANCE_CR
, BEGIN_BALANCE_DR
, PERIOD_NET_CR
, PERIOD_NET_DR
FROM JL.JL_CO_GL_BALANCES;
JL.JL_CO_GL_BALANCES does not reference any database object
JL.JL_CO_GL_BALANCES is referenced by following:
|
|
|