DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_GL_ACCT_BALANCES

Object Details
Object Name: AR_GL_ACCT_BALANCES
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_GL_ACCT_BALANCES
Subobject Name:
Status: VALID


Used as a processing table for Cumulative Activity Balance Report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_GL_ACCT_BALANCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_ACCOUNT
Columns
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
Query Text

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_GL_ACCT_BALANCES;

Dependencies

[top of page]

AR.AR_GL_ACCT_BALANCES does not reference any database object

AR.AR_GL_ACCT_BALANCES is referenced by following:

SchemaAR
ViewAR_GL_ACCT_BALANCES#