[Home] [Help] [Dependency Information]
Object Name: | GL_RX_TRIAL_BALANCE_ITF# |
---|---|
Object Type: | VIEW |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
PERIOD_NAME | VARCHAR2 | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
LEDGER_NAME | VARCHAR2 | (30) | ||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
BALANCING_SEGMENT | VARCHAR2 | (25) | ||
ACCOUNT_SEGMENT | VARCHAR2 | (25) | ||
BALANCING_DESCRIPTION | VARCHAR2 | (240) | ||
ACCOUNT_DESCRIPTION | VARCHAR2 | (240) | ||
SUMMARY_FLAG | VARCHAR2 | (1) | ||
BEGIN_YEAR_BALANCE_DR | NUMBER | |||
BEGIN_YEAR_BALANCE_CR | NUMBER | |||
BEGIN_ADJ_PERIOD_NET_DR | NUMBER | |||
BEGIN_ADJ_PERIOD_NET_CR | NUMBER | |||
PRIOR_PERIODS_NET_DR | NUMBER | |||
PRIOR_PERIODS_NET_CR | NUMBER | |||
BEGIN_PERIOD_BALANCE_DR | NUMBER | |||
BEGIN_PERIOD_BALANCE_CR | NUMBER | |||
PERIOD_NET_DR | NUMBER | |||
PERIOD_NET_CR | NUMBER | |||
YEAR_TO_DATE_BALANCE_DR | NUMBER | |||
YEAR_TO_DATE_BALANCE_CR | NUMBER | |||
YEAR_TO_DATE_NET_DIFFERENCE_DR | NUMBER | |||
YEAR_TO_DATE_NET_DIFFERENCE_CR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, PERIOD_NAME
, LEDGER_ID
, LEDGER_NAME
, CHART_OF_ACCOUNTS_ID
, CURRENCY_CODE
, BALANCING_SEGMENT
, ACCOUNT_SEGMENT
, BALANCING_DESCRIPTION
, ACCOUNT_DESCRIPTION
, SUMMARY_FLAG
, BEGIN_YEAR_BALANCE_DR
, BEGIN_YEAR_BALANCE_CR
, BEGIN_ADJ_PERIOD_NET_DR
, BEGIN_ADJ_PERIOD_NET_CR
, PRIOR_PERIODS_NET_DR
, PRIOR_PERIODS_NET_CR
, BEGIN_PERIOD_BALANCE_DR
, BEGIN_PERIOD_BALANCE_CR
, PERIOD_NET_DR
, PERIOD_NET_CR
, YEAR_TO_DATE_BALANCE_DR
, YEAR_TO_DATE_BALANCE_CR
, YEAR_TO_DATE_NET_DIFFERENCE_DR
, YEAR_TO_DATE_NET_DIFFERENCE_CR
FROM GL.GL_RX_TRIAL_BALANCE_ITF#;
|
|
|