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.

[Home] [Help]

VIEW: AX.AX_SLE_HEADERS_ARCH#

Source

View Text - Preformatted


select JOURNAL_SEQUENCE_ID JOURNAL_SEQUENCE_ID, SLE_HEADER_ID SLE_HEADER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, APPLICATION_ID APPLICATION_ID, EVENT_ID EVENT_ID, EFFECTIVE_DATE EFFECTIVE_DATE, PERIOD_NAME PERIOD_NAME, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_4 REFERENCE_4, REFERENCE_5 REFERENCE_5, ORG_ID ORG_ID, LEGAL_SEQUENCE_ID LEGAL_SEQUENCE_ID, LEGAL_SEQUENCE_VALUE LEGAL_SEQUENCE_VALUE, TRANSACTION_DATE TRANSACTION_DATE, REFERENCE_NUM1 REFERENCE_NUM1, REFERENCE_NUM2 REFERENCE_NUM2, REFERENCE_NUM3 REFERENCE_NUM3, REFERENCE_NUM4 REFERENCE_NUM4, REFERENCE_NUM5 REFERENCE_NUM5, REFERENCE_DATE1 REFERENCE_DATE1, REFERENCE_DATE2 REFERENCE_DATE2, REFERENCE_DATE3 REFERENCE_DATE3, REFERENCE_DATE4 REFERENCE_DATE4, REFERENCE_DATE5 REFERENCE_DATE5, DESCRIPTION DESCRIPTION, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, DOC_SEQUENCE_NUMBER DOC_SEQUENCE_NUMBER, GL_TRANSFER_FLAG GL_TRANSFER_FLAG, GL_TRANSFER_DATE GL_TRANSFER_DATE, GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID, GL_CATEGORY GL_CATEGORY, ACCOUNTING_SEQUENCE_ID ACCOUNTING_SEQUENCE_ID from "AX"."AX_SLE_HEADERS_ARCH"

View Text - HTML Formatted

SELECT JOURNAL_SEQUENCE_ID JOURNAL_SEQUENCE_ID
, SLE_HEADER_ID SLE_HEADER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, APPLICATION_ID APPLICATION_ID
, EVENT_ID EVENT_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, PERIOD_NAME PERIOD_NAME
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_4 REFERENCE_4
, REFERENCE_5 REFERENCE_5
, ORG_ID ORG_ID
, LEGAL_SEQUENCE_ID LEGAL_SEQUENCE_ID
, LEGAL_SEQUENCE_VALUE LEGAL_SEQUENCE_VALUE
, TRANSACTION_DATE TRANSACTION_DATE
, REFERENCE_NUM1 REFERENCE_NUM1
, REFERENCE_NUM2 REFERENCE_NUM2
, REFERENCE_NUM3 REFERENCE_NUM3
, REFERENCE_NUM4 REFERENCE_NUM4
, REFERENCE_NUM5 REFERENCE_NUM5
, REFERENCE_DATE1 REFERENCE_DATE1
, REFERENCE_DATE2 REFERENCE_DATE2
, REFERENCE_DATE3 REFERENCE_DATE3
, REFERENCE_DATE4 REFERENCE_DATE4
, REFERENCE_DATE5 REFERENCE_DATE5
, DESCRIPTION DESCRIPTION
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_NUMBER DOC_SEQUENCE_NUMBER
, GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, GL_TRANSFER_DATE GL_TRANSFER_DATE
, GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID
, GL_CATEGORY GL_CATEGORY
, ACCOUNTING_SEQUENCE_ID ACCOUNTING_SEQUENCE_ID
FROM "AX"."AX_SLE_HEADERS_ARCH"