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: IGI.IGI_AP_TRAN_TEMP#

Source

View Text - Preformatted


select INV_ID INV_ID, DIST_ID DIST_ID, DIST_LINE_NUM DIST_LINE_NUM, LINE_TYPE LINE_TYPE, VAT_CODE VAT_CODE, AMOUNT AMOUNT, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, TAX_CODE_OVERRIDE_FLAG TAX_CODE_OVERRIDE_FLAG, JE_UK_VAT_LINK_TO_LINE_TO_LNK JE_UK_VAT_LINK_TO_LINE_TO_LNK, JE_UK_VAT_LINK_TO_LINE_NUM JE_UK_VAT_LINK_TO_LINE_NUM, JE_UK_VAT_RECLAIM_TYPE JE_UK_VAT_RECLAIM_TYPE, ORG_ID ORG_ID from "IGI"."IGI_AP_TRAN_TEMP"

View Text - HTML Formatted

SELECT INV_ID INV_ID
, DIST_ID DIST_ID
, DIST_LINE_NUM DIST_LINE_NUM
, LINE_TYPE LINE_TYPE
, VAT_CODE VAT_CODE
, AMOUNT AMOUNT
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG
, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG
, TAX_CODE_OVERRIDE_FLAG TAX_CODE_OVERRIDE_FLAG
, JE_UK_VAT_LINK_TO_LINE_TO_LNK JE_UK_VAT_LINK_TO_LINE_TO_LNK
, JE_UK_VAT_LINK_TO_LINE_NUM JE_UK_VAT_LINK_TO_LINE_NUM
, JE_UK_VAT_RECLAIM_TYPE JE_UK_VAT_RECLAIM_TYPE
, ORG_ID ORG_ID
FROM "IGI"."IGI_AP_TRAN_TEMP"