VIEW: IGI.IGI_ARC_DRILL_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, JOURNAL_LINE_NUMBER JOURNAL_LINE_NUMBER, ACCOUNT_CODE ACCOUNT_CODE, ACCOUNT_DESC ACCOUNT_DESC, TRX_TYPE_NAME TRX_TYPE_NAME, TRX_NUMBER TRX_NUMBER, TRX_DATE TRX_DATE, THIRD_PARTY_NAME THIRD_PARTY_NAME, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, CURRENCY_CODE CURRENCY_CODE, ACCT_LINE_TYPE_NAME ACCT_LINE_TYPE_NAME, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, PAYMENT_DEPOSIT_DATE PAYMENT_DEPOSIT_DATE, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER, APPLICATION_DATE APPLICATION_DATE, REVERSAL_DATE REVERSAL_DATE, ACCOUNTING_DATE ACCOUNTING_DATE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "IGI"."IGI_ARC_DRILL_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, JOURNAL_LINE_NUMBER JOURNAL_LINE_NUMBER
, ACCOUNT_CODE ACCOUNT_CODE
, ACCOUNT_DESC ACCOUNT_DESC
, TRX_TYPE_NAME TRX_TYPE_NAME
, TRX_NUMBER TRX_NUMBER
, TRX_DATE TRX_DATE
, THIRD_PARTY_NAME THIRD_PARTY_NAME
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, CURRENCY_CODE CURRENCY_CODE
, ACCT_LINE_TYPE_NAME ACCT_LINE_TYPE_NAME
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, PAYMENT_DEPOSIT_DATE PAYMENT_DEPOSIT_DATE
, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER
, APPLICATION_DATE APPLICATION_DATE
, REVERSAL_DATE REVERSAL_DATE
, ACCOUNTING_DATE ACCOUNTING_DATE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "IGI"."IGI_ARC_DRILL_ITF"