eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMF.GL_SUBR_TST

Object Details

Object Name:	GL_SUBR_TST
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GL_SUBR_TST
Subobject Name:
Status:	VALID

Subsidiary ledger test run work table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_SUBR_TST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBLEDGER_ID
GL_SUBR_TST_I1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CO_CODE FISCAL_YEAR PERIOD GL_TRANS_DATE
GL_SUBR_TST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_TYPE DOC_ID LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUBLEDGER_ID	NUMBER		Yes	subsidiary ledger key.
DOC_TYPE	VARCHAR2	(4)	Yes	document type.
DOC_ID	NUMBER		Yes	document identifier within doc type.
LINE_ID	NUMBER		Yes	detail line identifier.
SUB_EVENT_TYPE	NUMBER		Yes	transaction identifier.
CO_CODE	VARCHAR2	(4)	Yes	company of transaction.
TRANS_SOURCE_TYPE	NUMBER	(5)	Yes	subsystem of transaction.
LEDGER_CODE	VARCHAR2	(4)	Yes	gl ledger to which to post.
CURRENCY_BASE	VARCHAR2	(4)	Yes	base currency of transaction.
CURRENCY_TRANS	VARCHAR2	(4)	Yes	Currency of transaction.
FISCAL_YEAR	NUMBER		Yes	fiscal year of gl posting.
PERIOD	NUMBER		Yes	period of gl posting.
VOUCHER_ID	NUMBER			GL journal voucher identifier.
ACCT_ID	NUMBER		Yes	OPM Account identifier.
ACCTG_UNIT_ID	NUMBER		Yes	OPM Accounting unit identifier.
AMOUNT_BASE	NUMBER		Yes	GL amount in base currency.
AMOUNT_TRANS	NUMBER		Yes	GL amount in Transaction currency.
TAXABLE_BASE	NUMBER			*** OBSOLETE COLUMN ***
TAXABLE_TRANS	NUMBER			*** OBSOLETE COLUMN ***
DEBIT_CREDIT_SIGN	NUMBER		Yes	Debit or Credit indicator for the Amounts: -1=credit; =1=debit.
PROJECT_NO	VARCHAR2	(16)		po project number.
QUANTITY	NUMBER			quantity of gl account key.
QUANTITY_UM	VARCHAR2	(4)		unit of measure of quantity.
EXCHANGE_RATE	NUMBER			exchange rate for transaction currency to base.
MUL_DIV_SIGN	NUMBER			0=Multiply amount by exchange rate to convert to the base currency; 1=Divide amount by exchange rate to convert to base currency.
GL_TRANS_DATE	DATE		Yes	GL TRANSACTION DATE.
REVERSAL_FLAG	NUMBER			*** OBSOLETE COLUMN ***
FRONT_CURR_IND	NUMBER			*** OBSOLETE COLUMN ***
TAXAUTH_ID	NUMBER			Identifier for the Tax Authority
REFERENCE_NO	NUMBER		Yes	The Subsidiary Ledger Run reference number.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
BATCH_NAME	VARCHAR2	(100)		Oracle GL Batch name.
EXPORTED_DATE	DATE			Date when bookings are exported to GL via OPM GL Update Process
TRANS_CNT	NUMBER	(10)		Not currently used
ACCT_TTL_TYPE	NUMBER	(10)	Yes	Account Title Type of Journal Line.
GL_DOC_DATE	DATE		Yes	Date of the OPM Transaction (OPM document date)
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUBLEDGER_ID
,      DOC_TYPE
,      DOC_ID
,      LINE_ID
,      SUB_EVENT_TYPE
,      CO_CODE
,      TRANS_SOURCE_TYPE
,      LEDGER_CODE
,      CURRENCY_BASE
,      CURRENCY_TRANS
,      FISCAL_YEAR
,      PERIOD
,      VOUCHER_ID
,      ACCT_ID
,      ACCTG_UNIT_ID
,      AMOUNT_BASE
,      AMOUNT_TRANS
,      TAXABLE_BASE
,      TAXABLE_TRANS
,      DEBIT_CREDIT_SIGN
,      PROJECT_NO
,      QUANTITY
,      QUANTITY_UM
,      EXCHANGE_RATE
,      MUL_DIV_SIGN
,      GL_TRANS_DATE
,      REVERSAL_FLAG
,      FRONT_CURR_IND
,      TAXAUTH_ID
,      REFERENCE_NO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BATCH_NAME
,      EXPORTED_DATE
,      TRANS_CNT
,      ACCT_TTL_TYPE
,      GL_DOC_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMF.GL_SUBR_TST;

Dependencies

[top of page]

GMF.GL_SUBR_TST does not reference any database object

GMF.GL_SUBR_TST is referenced by following:

GMF: GL_SUBR_TST#