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: GL.JE_BE_VAT_ALLOC_ERRORS#

Source

View Text - Preformatted


select SOURCE SOURCE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, TRANS_ID TRANS_ID, TRANS_LINE_ID TRANS_LINE_ID, OF_TRANS_TYPE OF_TRANS_TYPE, VAT_TRANS_TYPE VAT_TRANS_TYPE, LINE_TYPE LINE_TYPE, TAX_NAME TAX_NAME, AMOUNT AMOUNT, TRANS_DATE TRANS_DATE, ERROR_NUMBER ERROR_NUMBER, ERROR_DESCRIPTION ERROR_DESCRIPTION, POSTED_FLAG POSTED_FLAG, PERIOD_NAME PERIOD_NAME from "GL"."JE_BE_VAT_ALLOC_ERRORS"

View Text - HTML Formatted

SELECT SOURCE SOURCE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TRANS_ID TRANS_ID
, TRANS_LINE_ID TRANS_LINE_ID
, OF_TRANS_TYPE OF_TRANS_TYPE
, VAT_TRANS_TYPE VAT_TRANS_TYPE
, LINE_TYPE LINE_TYPE
, TAX_NAME TAX_NAME
, AMOUNT AMOUNT
, TRANS_DATE TRANS_DATE
, ERROR_NUMBER ERROR_NUMBER
, ERROR_DESCRIPTION ERROR_DESCRIPTION
, POSTED_FLAG POSTED_FLAG
, PERIOD_NAME PERIOD_NAME
FROM "GL"."JE_BE_VAT_ALLOC_ERRORS"