[Home] [Help] [Dependency Information]
Object Name: | AR_BASE_GL_ACCT_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_BASE_GL_ACCT_BALANCES |
Subobject Name: | |
Status: | VALID |
Used as a processing table for Cumulative Activity Balance Report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_BASE_GL_ACCT_BALANCES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GL_ACCOUNT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Account identifier |
GL_ACCOUNT | VARCHAR2 | (240) | GL account | |
TRX_TYPE | VARCHAR2 | (30) | Transaction type | |
TRX_NUMBER | VARCHAR2 | (30) | Transaction number | |
TRX_DATE | DATE | Transaction date | ||
ACTIVITY_GL_DATE | DATE | GL Date of the last activity | ||
CUSTOMER_TRX_ID | NUMBER | (15) | Invoice identifier | |
CASH_RECEIPT_ID | NUMBER | (15) | Cash receipt identifier | |
ORG_ID | NUMBER | (15) | Organization identifier | |
ADJUSTMENT_ID | NUMBER | (15) | Adjustment identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. foreign key to FND_USER.USER_ID. |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. Foreign key to FND_USER.USER_ID. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. Foreign key to FND_LOGINS.LOGIN_ID. | |
CURRENCY | VARCHAR2 | (30) | Entered currency | |
ACCTD_AMOUNT_DR | NUMBER | Debit amount in functional currency | ||
ACCTD_AMOUNT_CR | NUMBER | Credit amount in functional currency | ||
AMOUNT_DR | NUMBER | Debit amount in foreign currency | ||
AMOUNT_CR | NUMBER | Credit amount in foreign currency | ||
NATURAL_ACCOUNT | VARCHAR2 | (30) | Natural account segment | |
COMPONENT | VARCHAR2 | (30) | Identifies SQL component that populated this row |
Cut, paste (and edit) the following text to query this object:
SELECT CODE_COMBINATION_ID
, GL_ACCOUNT
, TRX_TYPE
, TRX_NUMBER
, TRX_DATE
, ACTIVITY_GL_DATE
, CUSTOMER_TRX_ID
, CASH_RECEIPT_ID
, ORG_ID
, ADJUSTMENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CURRENCY
, ACCTD_AMOUNT_DR
, ACCTD_AMOUNT_CR
, AMOUNT_DR
, AMOUNT_CR
, NATURAL_ACCOUNT
, COMPONENT
FROM AR.AR_BASE_GL_ACCT_BALANCES;
AR.AR_BASE_GL_ACCT_BALANCES does not reference any database object
AR.AR_BASE_GL_ACCT_BALANCES is referenced by following:
|
|
|