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

VIEW: JL.JL_CO_GL_TRX#

Object Details
Object Name: JL_CO_GL_TRX#
Object Type: VIEW
Owner: JL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Yes
PROCESS_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
NIT_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
PERIOD_YEAR NUMBER (15) Yes
PERIOD_NUM NUMBER (15) Yes
JE_BATCH_ID NUMBER (15) Yes
JE_HEADER_ID NUMBER (15) Yes
JE_LINE_NUM NUMBER (15) Yes
ACCOUNT_CODE VARCHAR2 (25) Yes
PERIOD_NAME VARCHAR2 (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CATEGORY VARCHAR2 (25) Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
ACCOUNTING_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
SUBLEDGER_DOC_NUMBER NUMBER

DOCUMENT_NUMBER VARCHAR2 (240)
ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

ENTERED_DR NUMBER

ENTERED_CR NUMBER

Query Text

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


SELECT TRANSACTION_ID
,      PROCESS_ID
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      NIT_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      PERIOD_YEAR
,      PERIOD_NUM
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      ACCOUNT_CODE
,      PERIOD_NAME
,      CURRENCY_CODE
,      CATEGORY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      ACCOUNTING_DATE
,      LAST_UPDATE_LOGIN
,      SUBLEDGER_DOC_NUMBER
,      DOCUMENT_NUMBER
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ENTERED_DR
,      ENTERED_CR
FROM JL.JL_CO_GL_TRX#;

Dependencies

[top of page]

JL.JL_CO_GL_TRX# references the following:

SchemaJL
TableJL_CO_GL_TRX
JL.JL_CO_GL_TRX# is referenced by following:

SchemaAPPS
SynonymJL_CO_GL_TRX