VIEW: AP.JG_ZZ_AP_IR_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME, INVOICE_ID INVOICE_ID, LIABILITY_CCID LIABILITY_CCID, LIABILITY_ACCOUNT LIABILITY_ACCOUNT, LIABILITY_DESC LIABILITY_DESC, LIABILITY_NATACC LIABILITY_NATACC, LIABILITY_NATACC_DESC LIABILITY_NATACC_DESC, INVOICE_TYPE INVOICE_TYPE, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, DISTRIBUTION_CCID DISTRIBUTION_CCID, DISTRIBUTION_ACCOUNT DISTRIBUTION_ACCOUNT, DISTRIBUTION_ACCOUNT_DESC DISTRIBUTION_ACCOUNT_DESC, DISTRIBUTION_NATACC DISTRIBUTION_NATACC, DISTRIBUTION_NATACC_DESC DISTRIBUTION_NATACC_DESC, DIST_NUMBER DIST_NUMBER, DIST_TYPE DIST_TYPE, ACCOUNTING_DATE ACCOUNTING_DATE from "AP"."JG_ZZ_AP_IR_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
, INVOICE_ID INVOICE_ID
, LIABILITY_CCID LIABILITY_CCID
, LIABILITY_ACCOUNT LIABILITY_ACCOUNT
, LIABILITY_DESC LIABILITY_DESC
, LIABILITY_NATACC LIABILITY_NATACC
, LIABILITY_NATACC_DESC LIABILITY_NATACC_DESC
, INVOICE_TYPE INVOICE_TYPE
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, DISTRIBUTION_CCID DISTRIBUTION_CCID
, DISTRIBUTION_ACCOUNT DISTRIBUTION_ACCOUNT
, DISTRIBUTION_ACCOUNT_DESC DISTRIBUTION_ACCOUNT_DESC
, DISTRIBUTION_NATACC DISTRIBUTION_NATACC
, DISTRIBUTION_NATACC_DESC DISTRIBUTION_NATACC_DESC
, DIST_NUMBER DIST_NUMBER
, DIST_TYPE DIST_TYPE
, ACCOUNTING_DATE ACCOUNTING_DATE
FROM "AP"."JG_ZZ_AP_IR_REP_ITF"