[Home] [Help]
[Dependency Information]
Object Name: | JG_ZZ_AR_BALANCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Accounting books identifier | |
CODE_COMBINATION_ID | NUMBER | (15) | Key flexfield combination identifier | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency | |
PERIOD_NAME | VARCHAR2 | (15) | Accounting period | |
CUSTOMER_ID | NUMBER | (15) | Customer unique identifier | |
CUSTOMER_SITE_ID | NUMBER | (15) | Customer site unique identifier | |
BEGIN_BAL_ENTERED_DR | NUMBER | Accounting flexfield beginning debit balance in entered currency | ||
BEGIN_BAL_ENTERED_CR | NUMBER | Accounting flexfield beginning credit balance in entered currency | ||
BEGIN_BAL_ACCOUNTED_DR | NUMBER | Accounting flexfield beginning debit balance in base currency | ||
BEGIN_BAL_ACCOUNTED_CR | NUMBER | Accounting flexfield beginning credit balance in base currency | ||
PERIOD_NET_ENTERED_DR | NUMBER | Accounting flexfield period net debit balance in entered currency | ||
PERIOD_NET_ENTERED_CR | NUMBER | Accounting flexfield period net credit balance in entered currency | ||
PERIOD_NET_ACCOUNTED_DR | NUMBER | Accounting flexfield period net debit balance in base currency | ||
PERIOD_NET_ACCOUNTED_CR | NUMBER | Accounting flexfield period net credit balance in base currency | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
POSTED_TO_GL_FLAG | VARCHAR2 | (1) | Flag indicating balance posted to General Ledger |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, BEGIN_BAL_ENTERED_DR
, BEGIN_BAL_ENTERED_CR
, BEGIN_BAL_ACCOUNTED_DR
, BEGIN_BAL_ACCOUNTED_CR
, PERIOD_NET_ENTERED_DR
, PERIOD_NET_ENTERED_CR
, PERIOD_NET_ACCOUNTED_DR
, PERIOD_NET_ACCOUNTED_CR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, POSTED_TO_GL_FLAG
FROM APPS.JG_ZZ_AR_BALANCES_V;
APPS.JG_ZZ_AR_BALANCES_V is not referenced by any database object
|
|
|