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: PA.PA_GL_REV_XFER_AUDIT_REP#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, LINE_TYPE LINE_TYPE, PERIOD_NAME PERIOD_NAME, PROJECT_ID PROJECT_ID, PROJECT_NUMBER PROJECT_NUMBER, DRAFT_REV_NUMBER DRAFT_REV_NUMBER, TRANSFERRED_DATE TRANSFERRED_DATE, GL_DATE GL_DATE, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_DATE TRANSACTION_DATE, TASK_ID TASK_ID, TASK_NUMBER TASK_NUMBER, EMP_OR_ORG_NAME EMP_OR_ORG_NAME, JE_BATCH_NAME JE_BATCH_NAME, JE_BATCH_ID JE_BATCH_ID, JE_REP_BATCH_NAME JE_REP_BATCH_NAME, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, RDL_LINE_NUM RDL_LINE_NUM, RDL_EVENT_NUM RDL_EVENT_NUM, DEBIT_AMOUNT DEBIT_AMOUNT, CREDIT_AMOUNT CREDIT_AMOUNT from "PA"."PA_GL_REV_XFER_AUDIT_REP"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, LINE_TYPE LINE_TYPE
, PERIOD_NAME PERIOD_NAME
, PROJECT_ID PROJECT_ID
, PROJECT_NUMBER PROJECT_NUMBER
, DRAFT_REV_NUMBER DRAFT_REV_NUMBER
, TRANSFERRED_DATE TRANSFERRED_DATE
, GL_DATE GL_DATE
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, TASK_ID TASK_ID
, TASK_NUMBER TASK_NUMBER
, EMP_OR_ORG_NAME EMP_OR_ORG_NAME
, JE_BATCH_NAME JE_BATCH_NAME
, JE_BATCH_ID JE_BATCH_ID
, JE_REP_BATCH_NAME JE_REP_BATCH_NAME
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, RDL_LINE_NUM RDL_LINE_NUM
, RDL_EVENT_NUM RDL_EVENT_NUM
, DEBIT_AMOUNT DEBIT_AMOUNT
, CREDIT_AMOUNT CREDIT_AMOUNT
FROM "PA"."PA_GL_REV_XFER_AUDIT_REP"