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_ALLOCATIONS#

Source

View Text - Preformatted


select ALLOCATION_ID ALLOCATION_ID, 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, VAT_REPORT_BOX VAT_REPORT_BOX, DECLARATION_ID DECLARATION_ID from "GL"."JE_BE_VAT_ALLOCATIONS"

View Text - HTML Formatted

SELECT ALLOCATION_ID ALLOCATION_ID
, 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
, VAT_REPORT_BOX VAT_REPORT_BOX
, DECLARATION_ID DECLARATION_ID
FROM "GL"."JE_BE_VAT_ALLOCATIONS"