VIEW: AR.AR_RECEIPTS_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, BATCH_ID BATCH_ID, BATCH_NAME BATCH_NAME, CASH_RECEIPT_ID CASH_RECEIPT_ID, RECEIPT_NUMBER RECEIPT_NUMBER, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_TYPE EXCHANGE_TYPE, DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, DEPOSIT_DATE DEPOSIT_DATE, RECEIPT_DATE RECEIPT_DATE, RECEIPT_TYPE RECEIPT_TYPE, RECEIPT_STATUS RECEIPT_STATUS, MISC_PAYMENT_SOURCE MISC_PAYMENT_SOURCE, TAX_CODE TAX_CODE, REFERENCE_TYPE REFERENCE_TYPE, ANTICIPATED_CLEARING_DATE ANTICIPATED_CLEARING_DATE, BANK_NAME BANK_NAME, BANK_NAME_ALT BANK_NAME_ALT, BANK_BRANCH_NAME BANK_BRANCH_NAME, BANK_BRANCH_NAME_ALT BANK_BRANCH_NAME_ALT, BANK_NUMBER BANK_NUMBER, BANK_BRANCH_NUMBER BANK_BRANCH_NUMBER, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT, BANK_ACCOUNT_CURRENCY BANK_ACCOUNT_CURRENCY, RECEIPT_METHOD RECEIPT_METHOD, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID, GL_DATE GL_DATE, RECEIPT_AMOUNT RECEIPT_AMOUNT, RECEIPT_HISTORY_STATUS RECEIPT_HISTORY_STATUS, ACCTD_RECEIPT_AMOUNT ACCTD_RECEIPT_AMOUNT, FACTOR_DISCOUNT_AMOUNT FACTOR_DISCOUNT_AMOUNT, ACCTD_FACTOR_DISCOUNT_AMOUNT ACCTD_FACTOR_DISCOUNT_AMOUNT, ACCOUNT_CODE_COMBINATION_ID ACCOUNT_CODE_COMBINATION_ID, DEBIT_ACCOUNT DEBIT_ACCOUNT, DEBIT_ACCOUNT_DESC DEBIT_ACCOUNT_DESC, DEBIT_BALANCING DEBIT_BALANCING, DEBIT_BALANCING_DESC DEBIT_BALANCING_DESC, DEBIT_NATACCT DEBIT_NATACCT, DEBIT_NATACCT_DESC DEBIT_NATACCT_DESC, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NAME_ALT CUSTOMER_NAME_ALT, CUSTOMER_NUMBER CUSTOMER_NUMBER, RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID, APPLY_DATE APPLY_DATE, APPLICATION_STATUS APPLICATION_STATUS, AMOUNT_APPLIED_TO AMOUNT_APPLIED_TO, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM, ACCTD_AMOUNT_APPLIED_TO ACCTD_AMOUNT_APPLIED_TO, ACCTD_AMOUNT_APPLIED_FROM ACCTD_AMOUNT_APPLIED_FROM, EARNED_DISCOUNT_TAKEN EARNED_DISCOUNT_TAKEN, UNEARNED_DISCOUNT_TAKEN UNEARNED_DISCOUNT_TAKEN, ACCTD_EARNED_DISCOUNT_TAKEN ACCTD_EARNED_DISCOUNT_TAKEN, ACCTD_UNEARNED_DISCOUNT_TAKEN ACCTD_UNEARNED_DISCOUNT_TAKEN, APPLIED_CUSTOMER_TRX_ID APPLIED_CUSTOMER_TRX_ID, TRX_NUMBER TRX_NUMBER, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, TRX_DATE TRX_DATE, TRX_AMOUNT TRX_AMOUNT, ACCTD_TRX_AMOUNT ACCTD_TRX_AMOUNT, RECEIPT_GAIN_LOSS RECEIPT_GAIN_LOSS, MISC_PERCENT MISC_PERCENT, MISC_AMOUNT MISC_AMOUNT, BATCH_SOURCE BATCH_SOURCE, RELATED_CUSTOMER RELATED_CUSTOMER, ON_ACCOUNT_AMOUNT ON_ACCOUNT_AMOUNT, UNAPP_AMOUNT UNAPP_AMOUNT, CLAIM_AMOUNT CLAIM_AMOUNT, PREPAY_AMOUNT PREPAY_AMOUNT, TOTAL_UNRESOLVED_AMOUNT TOTAL_UNRESOLVED_AMOUNT, FORMAT_CURRENCY_CODE FORMAT_CURRENCY_CODE, ACTIVITY_NAME ACTIVITY_NAME, ACCOUNT_NUMBER ACCOUNT_NUMBER, ACCOUNTING_FLEXFIELD ACCOUNTING_FLEXFIELD, APPLICATION_REF_TYPE APPLICATION_REF_TYPE, APPLICATION_REF_NUMBER APPLICATION_REF_NUMBER, AMOUNT_APPLIED AMOUNT_APPLIED, REMIT_BATCH_NAME REMIT_BATCH_NAME from "AR"."AR_RECEIPTS_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, BATCH_ID BATCH_ID
, BATCH_NAME BATCH_NAME
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, RECEIPT_NUMBER RECEIPT_NUMBER
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_TYPE EXCHANGE_TYPE
, DOC_SEQUENCE_NAME DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, DEPOSIT_DATE DEPOSIT_DATE
, RECEIPT_DATE RECEIPT_DATE
, RECEIPT_TYPE RECEIPT_TYPE
, RECEIPT_STATUS RECEIPT_STATUS
, MISC_PAYMENT_SOURCE MISC_PAYMENT_SOURCE
, TAX_CODE TAX_CODE
, REFERENCE_TYPE REFERENCE_TYPE
, ANTICIPATED_CLEARING_DATE ANTICIPATED_CLEARING_DATE
, BANK_NAME BANK_NAME
, BANK_NAME_ALT BANK_NAME_ALT
, BANK_BRANCH_NAME BANK_BRANCH_NAME
, BANK_BRANCH_NAME_ALT BANK_BRANCH_NAME_ALT
, BANK_NUMBER BANK_NUMBER
, BANK_BRANCH_NUMBER BANK_BRANCH_NUMBER
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, BANK_ACCOUNT_CURRENCY BANK_ACCOUNT_CURRENCY
, RECEIPT_METHOD RECEIPT_METHOD
, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID
, GL_DATE GL_DATE
, RECEIPT_AMOUNT RECEIPT_AMOUNT
, RECEIPT_HISTORY_STATUS RECEIPT_HISTORY_STATUS
, ACCTD_RECEIPT_AMOUNT ACCTD_RECEIPT_AMOUNT
, FACTOR_DISCOUNT_AMOUNT FACTOR_DISCOUNT_AMOUNT
, ACCTD_FACTOR_DISCOUNT_AMOUNT ACCTD_FACTOR_DISCOUNT_AMOUNT
, ACCOUNT_CODE_COMBINATION_ID ACCOUNT_CODE_COMBINATION_ID
, DEBIT_ACCOUNT DEBIT_ACCOUNT
, DEBIT_ACCOUNT_DESC DEBIT_ACCOUNT_DESC
, DEBIT_BALANCING DEBIT_BALANCING
, DEBIT_BALANCING_DESC DEBIT_BALANCING_DESC
, DEBIT_NATACCT DEBIT_NATACCT
, DEBIT_NATACCT_DESC DEBIT_NATACCT_DESC
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NAME_ALT CUSTOMER_NAME_ALT
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID
, APPLY_DATE APPLY_DATE
, APPLICATION_STATUS APPLICATION_STATUS
, AMOUNT_APPLIED_TO AMOUNT_APPLIED_TO
, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
, ACCTD_AMOUNT_APPLIED_TO ACCTD_AMOUNT_APPLIED_TO
, ACCTD_AMOUNT_APPLIED_FROM ACCTD_AMOUNT_APPLIED_FROM
, EARNED_DISCOUNT_TAKEN EARNED_DISCOUNT_TAKEN
, UNEARNED_DISCOUNT_TAKEN UNEARNED_DISCOUNT_TAKEN
, ACCTD_EARNED_DISCOUNT_TAKEN ACCTD_EARNED_DISCOUNT_TAKEN
, ACCTD_UNEARNED_DISCOUNT_TAKEN ACCTD_UNEARNED_DISCOUNT_TAKEN
, APPLIED_CUSTOMER_TRX_ID APPLIED_CUSTOMER_TRX_ID
, TRX_NUMBER TRX_NUMBER
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, TRX_DATE TRX_DATE
, TRX_AMOUNT TRX_AMOUNT
, ACCTD_TRX_AMOUNT ACCTD_TRX_AMOUNT
, RECEIPT_GAIN_LOSS RECEIPT_GAIN_LOSS
, MISC_PERCENT MISC_PERCENT
, MISC_AMOUNT MISC_AMOUNT
, BATCH_SOURCE BATCH_SOURCE
, RELATED_CUSTOMER RELATED_CUSTOMER
, ON_ACCOUNT_AMOUNT ON_ACCOUNT_AMOUNT
, UNAPP_AMOUNT UNAPP_AMOUNT
, CLAIM_AMOUNT CLAIM_AMOUNT
, PREPAY_AMOUNT PREPAY_AMOUNT
, TOTAL_UNRESOLVED_AMOUNT TOTAL_UNRESOLVED_AMOUNT
, FORMAT_CURRENCY_CODE FORMAT_CURRENCY_CODE
, ACTIVITY_NAME ACTIVITY_NAME
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACCOUNTING_FLEXFIELD ACCOUNTING_FLEXFIELD
, APPLICATION_REF_TYPE APPLICATION_REF_TYPE
, APPLICATION_REF_NUMBER APPLICATION_REF_NUMBER
, AMOUNT_APPLIED AMOUNT_APPLIED
, REMIT_BATCH_NAME REMIT_BATCH_NAME
FROM "AR"."AR_RECEIPTS_REP_ITF"