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: AR.AR_CUSTOMER_BALANCE_ITF#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, AS_OF_DATE AS_OF_DATE, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, TAX_REFERENCE_NUM TAX_REFERENCE_NUM, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, CITY CITY, STATE STATE, ZIP ZIP, COUNTRY COUNTRY, TRANS_TYPE TRANS_TYPE, TRX_NUMBER TRX_NUMBER, TRANSACTION_DATE TRANSACTION_DATE, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, TRANS_AMOUNT TRANS_AMOUNT, TRANS_AMOUNT_REMAINING TRANS_AMOUNT_REMAINING, RECEIPT_AMOUNT RECEIPT_AMOUNT, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT, EARNED_DISCOUNT_AMOUNT EARNED_DISCOUNT_AMOUNT, UNEARNED_DISCOUNT_AMOUNT UNEARNED_DISCOUNT_AMOUNT, INVOICE_CREDIT_AMOUNT INVOICE_CREDIT_AMOUNT, BANK_CHARGE BANK_CHARGE, ON_ACCOUNT_CREDIT_AMOUNT ON_ACCOUNT_CREDIT_AMOUNT, ON_ACCOUNT_RECEIPTS ON_ACCOUNT_RECEIPTS, UNAPPLIED_RECEIPTS UNAPPLIED_RECEIPTS from "AR"."AR_CUSTOMER_BALANCE_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, AS_OF_DATE AS_OF_DATE
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, TAX_REFERENCE_NUM TAX_REFERENCE_NUM
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, CITY CITY
, STATE STATE
, ZIP ZIP
, COUNTRY COUNTRY
, TRANS_TYPE TRANS_TYPE
, TRX_NUMBER TRX_NUMBER
, TRANSACTION_DATE TRANSACTION_DATE
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, TRANS_AMOUNT TRANS_AMOUNT
, TRANS_AMOUNT_REMAINING TRANS_AMOUNT_REMAINING
, RECEIPT_AMOUNT RECEIPT_AMOUNT
, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT
, EARNED_DISCOUNT_AMOUNT EARNED_DISCOUNT_AMOUNT
, UNEARNED_DISCOUNT_AMOUNT UNEARNED_DISCOUNT_AMOUNT
, INVOICE_CREDIT_AMOUNT INVOICE_CREDIT_AMOUNT
, BANK_CHARGE BANK_CHARGE
, ON_ACCOUNT_CREDIT_AMOUNT ON_ACCOUNT_CREDIT_AMOUNT
, ON_ACCOUNT_RECEIPTS ON_ACCOUNT_RECEIPTS
, UNAPPLIED_RECEIPTS UNAPPLIED_RECEIPTS
FROM "AR"."AR_CUSTOMER_BALANCE_ITF"