SELECT
aicrg.cash_receipt_id CASH_RECEIPT_ID
,aicrg.receipt_number RECEIPT_NUMBER
,aicrg.receipt_date RECEIPT_DATE
,aicrg.receipt_status RECEIPT_STATUS
,aicrg.document_number DOCUMENT_NUMBER
,aicrg.receipt_amount RECEIPT_AMOUNT
,aicrg.currency CURRENCY
,aicrg.credit_card_no CREDIT_CARD_NO
,aicrg.credit_card_type CREDIT_CARD_TYPE
,aicrg.maturity_date MATURITY_DATE
,aicrg.method_name METHOD_NAME
,aicrg.bank_account BANK_ACCOUNT
,aicrg.bank_name BANK_NAME
,aicrg.bank_branch_name BANK_BRANCH_NAME
,aicrg.customer_name CUSTOMER_NAME
,aicrg.customer_number CUSTOMER_NUMBER
,aicrg.tax_registration_number TAX_REGISTRATION_NUMBER
,aicrg.name NAME
,aicrg.cust_account_id CUST_ACCOUNT_ID
,aicrg.cust_acct_site_id CUST_ACCT_SITE_ID
,aicrg.address_line1 ADDRESS_LINE1
,aicrg.address_line2 ADDRESS_LINE2
,aicrg.city CITY
,aicrg.postal_code POSTAL_CODE
,aicrg.copy_or_original COPY_OR_ORIGINAL
,aicrg.user_name USER_NAME
,aicrg.cust_tax_registration_num CUST_TAX_REGISTRATION_NUMBER
FROM AR_IL_CASH_RECEIPTS2_GT aicrg |
