DBA Data[Home] [Help]

VIEW: LNS.LNS_AE_LINES#

Source

View Text - Preformatted

select AE_LINE_ID AE_LINE_ID, AE_HEADER_ID AE_HEADER_ID, AE_LINE_TYPE_CODE AE_LINE_TYPE_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, CURRENCY_CODE CURRENCY_CODE, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT, DESCRIPTION DESCRIPTION, GL_DATE GL_DATE, GL_POSTED_DATE GL_POSTED_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, GL_SL_LINK_ID GL_SL_LINK_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "LNS"."LNS_AE_LINES"
View Text - HTML Formatted

SELECT AE_LINE_ID AE_LINE_ID
, AE_HEADER_ID AE_HEADER_ID
, AE_LINE_TYPE_CODE AE_LINE_TYPE_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, CURRENCY_CODE CURRENCY_CODE
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT
, DESCRIPTION DESCRIPTION
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GL_SL_LINK_ID GL_SL_LINK_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "LNS"."LNS_AE_LINES"