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_PAYMENTS_INTERFACE_ALL#

Source

View Text - Preformatted


select TRANSMISSION_RECORD_ID TRANSMISSION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, RECORD_TYPE RECORD_TYPE, STATUS STATUS, TRANSMISSION_REQUEST_ID TRANSMISSION_REQUEST_ID, DESTINATION_ACCOUNT DESTINATION_ACCOUNT, ORIGINATION ORIGINATION, DEPOSIT_DATE DEPOSIT_DATE, DEPOSIT_TIME DEPOSIT_TIME, TRANSMISSION_RECORD_COUNT TRANSMISSION_RECORD_COUNT, TRANSMISSION_AMOUNT TRANSMISSION_AMOUNT, LOCKBOX_NUMBER LOCKBOX_NUMBER, LOCKBOX_BATCH_COUNT LOCKBOX_BATCH_COUNT, LOCKBOX_RECORD_COUNT LOCKBOX_RECORD_COUNT, LOCKBOX_AMOUNT LOCKBOX_AMOUNT, BATCH_NAME BATCH_NAME, BATCH_AMOUNT BATCH_AMOUNT, BATCH_RECORD_COUNT BATCH_RECORD_COUNT, ITEM_NUMBER ITEM_NUMBER, CURRENCY_CODE CURRENCY_CODE, REMITTANCE_AMOUNT REMITTANCE_AMOUNT, TRANSIT_ROUTING_NUMBER TRANSIT_ROUTING_NUMBER, ACCOUNT ACCOUNT, CHECK_NUMBER CHECK_NUMBER, CUSTOMER_NUMBER CUSTOMER_NUMBER, OVERFLOW_INDICATOR OVERFLOW_INDICATOR, OVERFLOW_SEQUENCE OVERFLOW_SEQUENCE, INVOICE1 INVOICE1, INVOICE2 INVOICE2, INVOICE3 INVOICE3, INVOICE4 INVOICE4, INVOICE5 INVOICE5, INVOICE6 INVOICE6, INVOICE7 INVOICE7, INVOICE8 INVOICE8, AMOUNT_APPLIED1 AMOUNT_APPLIED1, AMOUNT_APPLIED2 AMOUNT_APPLIED2, AMOUNT_APPLIED3 AMOUNT_APPLIED3, AMOUNT_APPLIED4 AMOUNT_APPLIED4, AMOUNT_APPLIED5 AMOUNT_APPLIED5, AMOUNT_APPLIED6 AMOUNT_APPLIED6, AMOUNT_APPLIED7 AMOUNT_APPLIED7, AMOUNT_APPLIED8 AMOUNT_APPLIED8, INVOICE1_STATUS INVOICE1_STATUS, INVOICE2_STATUS INVOICE2_STATUS, INVOICE3_STATUS INVOICE3_STATUS, INVOICE4_STATUS INVOICE4_STATUS, INVOICE5_STATUS INVOICE5_STATUS, INVOICE6_STATUS INVOICE6_STATUS, INVOICE7_STATUS INVOICE7_STATUS, INVOICE8_STATUS INVOICE8_STATUS, GL_DATE GL_DATE, COMMENTS COMMENTS, CUSTOMER_ID CUSTOMER_ID, SPECIAL_TYPE SPECIAL_TYPE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, RECEIPT_METHOD RECEIPT_METHOD, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, BILL_TO_LOCATION BILL_TO_LOCATION, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, TRANSFERRED_RECEIPT_COUNT TRANSFERRED_RECEIPT_COUNT, TRANSFERRED_RECEIPT_AMOUNT TRANSFERRED_RECEIPT_AMOUNT, INVOICE1_INSTALLMENT INVOICE1_INSTALLMENT, INVOICE2_INSTALLMENT INVOICE2_INSTALLMENT, INVOICE3_INSTALLMENT INVOICE3_INSTALLMENT, INVOICE4_INSTALLMENT INVOICE4_INSTALLMENT, INVOICE5_INSTALLMENT INVOICE5_INSTALLMENT, INVOICE6_INSTALLMENT INVOICE6_INSTALLMENT, INVOICE7_INSTALLMENT INVOICE7_INSTALLMENT, INVOICE8_INSTALLMENT INVOICE8_INSTALLMENT, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE EXCHANGE_RATE, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID, TRANSMISSION_ID TRANSMISSION_ID, RECEIPT_DATE RECEIPT_DATE, ORG_ID ORG_ID, ANTICIPATED_CLEARING_DATE ANTICIPATED_CLEARING_DATE, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, CUSTOMER_NAME_ALT CUSTOMER_NAME_ALT, CUSTOMER_BANK_NAME CUSTOMER_BANK_NAME, CUSTOMER_BANK_BRANCH_NAME CUSTOMER_BANK_BRANCH_NAME, REMITTANCE_BANK_NAME REMITTANCE_BANK_NAME, REMITTANCE_BANK_BRANCH_NAME REMITTANCE_BANK_BRANCH_NAME, BANK_TRX_CODE BANK_TRX_CODE, RESOLVED_MATCHING_NUMBER1 RESOLVED_MATCHING_NUMBER1, RESOLVED_MATCHING_NUMBER2 RESOLVED_MATCHING_NUMBER2, RESOLVED_MATCHING_NUMBER3 RESOLVED_MATCHING_NUMBER3, RESOLVED_MATCHING_NUMBER4 RESOLVED_MATCHING_NUMBER4, RESOLVED_MATCHING_NUMBER5 RESOLVED_MATCHING_NUMBER5, RESOLVED_MATCHING_NUMBER6 RESOLVED_MATCHING_NUMBER6, RESOLVED_MATCHING_NUMBER7 RESOLVED_MATCHING_NUMBER7, RESOLVED_MATCHING_NUMBER8 RESOLVED_MATCHING_NUMBER8, RESOLVED_MATCHING1_INSTALLMENT RESOLVED_MATCHING1_INSTALLMENT, RESOLVED_MATCHING2_INSTALLMENT RESOLVED_MATCHING2_INSTALLMENT, RESOLVED_MATCHING3_INSTALLMENT RESOLVED_MATCHING3_INSTALLMENT, RESOLVED_MATCHING4_INSTALLMENT RESOLVED_MATCHING4_INSTALLMENT, RESOLVED_MATCHING5_INSTALLMENT RESOLVED_MATCHING5_INSTALLMENT, RESOLVED_MATCHING6_INSTALLMENT RESOLVED_MATCHING6_INSTALLMENT, RESOLVED_MATCHING7_INSTALLMENT RESOLVED_MATCHING7_INSTALLMENT, RESOLVED_MATCHING8_INSTALLMENT RESOLVED_MATCHING8_INSTALLMENT, RESOLVED_MATCHING1_DATE RESOLVED_MATCHING1_DATE, RESOLVED_MATCHING2_DATE RESOLVED_MATCHING2_DATE, RESOLVED_MATCHING3_DATE RESOLVED_MATCHING3_DATE, RESOLVED_MATCHING4_DATE RESOLVED_MATCHING4_DATE, RESOLVED_MATCHING5_DATE RESOLVED_MATCHING5_DATE, RESOLVED_MATCHING6_DATE RESOLVED_MATCHING6_DATE, RESOLVED_MATCHING7_DATE RESOLVED_MATCHING7_DATE, RESOLVED_MATCHING8_DATE RESOLVED_MATCHING8_DATE, MATCHING1_DATE MATCHING1_DATE, MATCHING2_DATE MATCHING2_DATE, MATCHING3_DATE MATCHING3_DATE, MATCHING4_DATE MATCHING4_DATE, MATCHING5_DATE MATCHING5_DATE, MATCHING6_DATE MATCHING6_DATE, MATCHING7_DATE MATCHING7_DATE, MATCHING8_DATE MATCHING8_DATE, MATCH_RESOLVED_USING MATCH_RESOLVED_USING, AMOUNT_APPLIED_FROM1 AMOUNT_APPLIED_FROM1, AMOUNT_APPLIED_FROM2 AMOUNT_APPLIED_FROM2, AMOUNT_APPLIED_FROM3 AMOUNT_APPLIED_FROM3, AMOUNT_APPLIED_FROM4 AMOUNT_APPLIED_FROM4, AMOUNT_APPLIED_FROM5 AMOUNT_APPLIED_FROM5, AMOUNT_APPLIED_FROM6 AMOUNT_APPLIED_FROM6, AMOUNT_APPLIED_FROM7 AMOUNT_APPLIED_FROM7, AMOUNT_APPLIED_FROM8 AMOUNT_APPLIED_FROM8, INVOICE_CURRENCY_CODE1 INVOICE_CURRENCY_CODE1, INVOICE_CURRENCY_CODE2 INVOICE_CURRENCY_CODE2, INVOICE_CURRENCY_CODE3 INVOICE_CURRENCY_CODE3, INVOICE_CURRENCY_CODE4 INVOICE_CURRENCY_CODE4, INVOICE_CURRENCY_CODE5 INVOICE_CURRENCY_CODE5, INVOICE_CURRENCY_CODE6 INVOICE_CURRENCY_CODE6, INVOICE_CURRENCY_CODE7 INVOICE_CURRENCY_CODE7, INVOICE_CURRENCY_CODE8 INVOICE_CURRENCY_CODE8, TRANS_TO_RECEIPT_RATE1 TRANS_TO_RECEIPT_RATE1, TRANS_TO_RECEIPT_RATE2 TRANS_TO_RECEIPT_RATE2, TRANS_TO_RECEIPT_RATE3 TRANS_TO_RECEIPT_RATE3, TRANS_TO_RECEIPT_RATE4 TRANS_TO_RECEIPT_RATE4, TRANS_TO_RECEIPT_RATE5 TRANS_TO_RECEIPT_RATE5, TRANS_TO_RECEIPT_RATE6 TRANS_TO_RECEIPT_RATE6, TRANS_TO_RECEIPT_RATE7 TRANS_TO_RECEIPT_RATE7, TRANS_TO_RECEIPT_RATE8 TRANS_TO_RECEIPT_RATE8, TMP_AMT_APPLIED_FROM1 TMP_AMT_APPLIED_FROM1, TMP_AMT_APPLIED_FROM2 TMP_AMT_APPLIED_FROM2, TMP_AMT_APPLIED_FROM3 TMP_AMT_APPLIED_FROM3, TMP_AMT_APPLIED_FROM4 TMP_AMT_APPLIED_FROM4, TMP_AMT_APPLIED_FROM5 TMP_AMT_APPLIED_FROM5, TMP_AMT_APPLIED_FROM6 TMP_AMT_APPLIED_FROM6, TMP_AMT_APPLIED_FROM7 TMP_AMT_APPLIED_FROM7, TMP_AMT_APPLIED_FROM8 TMP_AMT_APPLIED_FROM8, TMP_INV_CURRENCY_CODE1 TMP_INV_CURRENCY_CODE1, TMP_INV_CURRENCY_CODE2 TMP_INV_CURRENCY_CODE2, TMP_INV_CURRENCY_CODE3 TMP_INV_CURRENCY_CODE3, TMP_INV_CURRENCY_CODE4 TMP_INV_CURRENCY_CODE4, TMP_INV_CURRENCY_CODE5 TMP_INV_CURRENCY_CODE5, TMP_INV_CURRENCY_CODE6 TMP_INV_CURRENCY_CODE6, TMP_INV_CURRENCY_CODE7 TMP_INV_CURRENCY_CODE7, TMP_INV_CURRENCY_CODE8 TMP_INV_CURRENCY_CODE8, TMP_TRANS_TO_RCPT_RATE1 TMP_TRANS_TO_RCPT_RATE1, TMP_TRANS_TO_RCPT_RATE2 TMP_TRANS_TO_RCPT_RATE2, TMP_TRANS_TO_RCPT_RATE3 TMP_TRANS_TO_RCPT_RATE3, TMP_TRANS_TO_RCPT_RATE4 TMP_TRANS_TO_RCPT_RATE4, TMP_TRANS_TO_RCPT_RATE5 TMP_TRANS_TO_RCPT_RATE5, TMP_TRANS_TO_RCPT_RATE6 TMP_TRANS_TO_RCPT_RATE6, TMP_TRANS_TO_RCPT_RATE7 TMP_TRANS_TO_RCPT_RATE7, TMP_TRANS_TO_RCPT_RATE8 TMP_TRANS_TO_RCPT_RATE8, TMP_AMT_APPLIED1 TMP_AMT_APPLIED1, TMP_AMT_APPLIED2 TMP_AMT_APPLIED2, TMP_AMT_APPLIED3 TMP_AMT_APPLIED3, TMP_AMT_APPLIED4 TMP_AMT_APPLIED4, TMP_AMT_APPLIED5 TMP_AMT_APPLIED5, TMP_AMT_APPLIED6 TMP_AMT_APPLIED6, TMP_AMT_APPLIED7 TMP_AMT_APPLIED7, TMP_AMT_APPLIED8 TMP_AMT_APPLIED8, CPG_PURCHASE_ORDER_NUMBER CPG_PURCHASE_ORDER_NUMBER, CPG_CUSTOMER_REF_NUMBER CPG_CUSTOMER_REF_NUMBER, CPG_SHIP_TO_LOCATION_NUMBER CPG_SHIP_TO_LOCATION_NUMBER, CPG_TRANSACTION_DATE CPG_TRANSACTION_DATE, CPG_PROCESS_STATUS CPG_PROCESS_STATUS, CPG_RECEIPT_STATUS CPG_RECEIPT_STATUS, CPG_BATCH_DATE CPG_BATCH_DATE, CPG_BATCH_STATUS CPG_BATCH_STATUS, CPG_BATCH_SOURCE CPG_BATCH_SOURCE, CPG_ORIGINAL_TRX_NUMBER CPG_ORIGINAL_TRX_NUMBER, CPG_RECEIPT_COUNT CPG_RECEIPT_COUNT, CPG_RECEIPT_AMOUNT CPG_RECEIPT_AMOUNT, CPG_ORIG_REMITTANCE_AMOUNT CPG_ORIG_REMITTANCE_AMOUNT, CPG_NEGATIVE_TRX_INDICATOR CPG_NEGATIVE_TRX_INDICATOR, CPG_REASSOCIATION_TRACE_NUM CPG_REASSOCIATION_TRACE_NUM, CPG_ASSOCIATION_FLAG CPG_ASSOCIATION_FLAG, CPG_TRX_HANDLING_CODE CPG_TRX_HANDLING_CODE, CPG_CUST_DEDUCTION_REASON_CODE CPG_CUST_DEDUCTION_REASON_CODE, CPG_ORIG_BATCH_NAME CPG_ORIG_BATCH_NAME, CPG_ORIG_LOCKBOX_NUMBER CPG_ORIG_LOCKBOX_NUMBER, CPG_BATCH_SEQUENCE_NUMBER CPG_BATCH_SEQUENCE_NUMBER, CPG_POSTMARK_DATE CPG_POSTMARK_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE1 USSGL_TRANSACTION_CODE1, USSGL_TRANSACTION_CODE2 USSGL_TRANSACTION_CODE2, USSGL_TRANSACTION_CODE3 USSGL_TRANSACTION_CODE3, USSGL_TRANSACTION_CODE4 USSGL_TRANSACTION_CODE4, USSGL_TRANSACTION_CODE5 USSGL_TRANSACTION_CODE5, USSGL_TRANSACTION_CODE6 USSGL_TRANSACTION_CODE6, USSGL_TRANSACTION_CODE7 USSGL_TRANSACTION_CODE7, USSGL_TRANSACTION_CODE8 USSGL_TRANSACTION_CODE8, APPLICATION_NOTES APPLICATION_NOTES, CUSTOMER_REFERENCE1 CUSTOMER_REFERENCE1, CUSTOMER_REFERENCE2 CUSTOMER_REFERENCE2, CUSTOMER_REFERENCE3 CUSTOMER_REFERENCE3, CUSTOMER_REFERENCE4 CUSTOMER_REFERENCE4, CUSTOMER_REFERENCE5 CUSTOMER_REFERENCE5, CUSTOMER_REFERENCE6 CUSTOMER_REFERENCE6, CUSTOMER_REFERENCE7 CUSTOMER_REFERENCE7, CUSTOMER_REFERENCE8 CUSTOMER_REFERENCE8, CUSTOMER_REASON1 CUSTOMER_REASON1, CUSTOMER_REASON2 CUSTOMER_REASON2, CUSTOMER_REASON3 CUSTOMER_REASON3, CUSTOMER_REASON4 CUSTOMER_REASON4, CUSTOMER_REASON5 CUSTOMER_REASON5, CUSTOMER_REASON6 CUSTOMER_REASON6, CUSTOMER_REASON7 CUSTOMER_REASON7, CUSTOMER_REASON8 CUSTOMER_REASON8, SOURCE_TYPE_FLAG SOURCE_TYPE_FLAG, SC_MATCHING_STATUS SC_MATCHING_STATUS from "AR"."AR_PAYMENTS_INTERFACE_ALL"

View Text - HTML Formatted

SELECT TRANSMISSION_RECORD_ID TRANSMISSION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, RECORD_TYPE RECORD_TYPE
, STATUS STATUS
, TRANSMISSION_REQUEST_ID TRANSMISSION_REQUEST_ID
, DESTINATION_ACCOUNT DESTINATION_ACCOUNT
, ORIGINATION ORIGINATION
, DEPOSIT_DATE DEPOSIT_DATE
, DEPOSIT_TIME DEPOSIT_TIME
, TRANSMISSION_RECORD_COUNT TRANSMISSION_RECORD_COUNT
, TRANSMISSION_AMOUNT TRANSMISSION_AMOUNT
, LOCKBOX_NUMBER LOCKBOX_NUMBER
, LOCKBOX_BATCH_COUNT LOCKBOX_BATCH_COUNT
, LOCKBOX_RECORD_COUNT LOCKBOX_RECORD_COUNT
, LOCKBOX_AMOUNT LOCKBOX_AMOUNT
, BATCH_NAME BATCH_NAME
, BATCH_AMOUNT BATCH_AMOUNT
, BATCH_RECORD_COUNT BATCH_RECORD_COUNT
, ITEM_NUMBER ITEM_NUMBER
, CURRENCY_CODE CURRENCY_CODE
, REMITTANCE_AMOUNT REMITTANCE_AMOUNT
, TRANSIT_ROUTING_NUMBER TRANSIT_ROUTING_NUMBER
, ACCOUNT ACCOUNT
, CHECK_NUMBER CHECK_NUMBER
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, OVERFLOW_INDICATOR OVERFLOW_INDICATOR
, OVERFLOW_SEQUENCE OVERFLOW_SEQUENCE
, INVOICE1 INVOICE1
, INVOICE2 INVOICE2
, INVOICE3 INVOICE3
, INVOICE4 INVOICE4
, INVOICE5 INVOICE5
, INVOICE6 INVOICE6
, INVOICE7 INVOICE7
, INVOICE8 INVOICE8
, AMOUNT_APPLIED1 AMOUNT_APPLIED1
, AMOUNT_APPLIED2 AMOUNT_APPLIED2
, AMOUNT_APPLIED3 AMOUNT_APPLIED3
, AMOUNT_APPLIED4 AMOUNT_APPLIED4
, AMOUNT_APPLIED5 AMOUNT_APPLIED5
, AMOUNT_APPLIED6 AMOUNT_APPLIED6
, AMOUNT_APPLIED7 AMOUNT_APPLIED7
, AMOUNT_APPLIED8 AMOUNT_APPLIED8
, INVOICE1_STATUS INVOICE1_STATUS
, INVOICE2_STATUS INVOICE2_STATUS
, INVOICE3_STATUS INVOICE3_STATUS
, INVOICE4_STATUS INVOICE4_STATUS
, INVOICE5_STATUS INVOICE5_STATUS
, INVOICE6_STATUS INVOICE6_STATUS
, INVOICE7_STATUS INVOICE7_STATUS
, INVOICE8_STATUS INVOICE8_STATUS
, GL_DATE GL_DATE
, COMMENTS COMMENTS
, CUSTOMER_ID CUSTOMER_ID
, SPECIAL_TYPE SPECIAL_TYPE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RECEIPT_METHOD RECEIPT_METHOD
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, BILL_TO_LOCATION BILL_TO_LOCATION
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, TRANSFERRED_RECEIPT_COUNT TRANSFERRED_RECEIPT_COUNT
, TRANSFERRED_RECEIPT_AMOUNT TRANSFERRED_RECEIPT_AMOUNT
, INVOICE1_INSTALLMENT INVOICE1_INSTALLMENT
, INVOICE2_INSTALLMENT INVOICE2_INSTALLMENT
, INVOICE3_INSTALLMENT INVOICE3_INSTALLMENT
, INVOICE4_INSTALLMENT INVOICE4_INSTALLMENT
, INVOICE5_INSTALLMENT INVOICE5_INSTALLMENT
, INVOICE6_INSTALLMENT INVOICE6_INSTALLMENT
, INVOICE7_INSTALLMENT INVOICE7_INSTALLMENT
, INVOICE8_INSTALLMENT INVOICE8_INSTALLMENT
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE EXCHANGE_RATE
, CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID
, TRANSMISSION_ID TRANSMISSION_ID
, RECEIPT_DATE RECEIPT_DATE
, ORG_ID ORG_ID
, ANTICIPATED_CLEARING_DATE ANTICIPATED_CLEARING_DATE
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, CUSTOMER_NAME_ALT CUSTOMER_NAME_ALT
, CUSTOMER_BANK_NAME CUSTOMER_BANK_NAME
, CUSTOMER_BANK_BRANCH_NAME CUSTOMER_BANK_BRANCH_NAME
, REMITTANCE_BANK_NAME REMITTANCE_BANK_NAME
, REMITTANCE_BANK_BRANCH_NAME REMITTANCE_BANK_BRANCH_NAME
, BANK_TRX_CODE BANK_TRX_CODE
, RESOLVED_MATCHING_NUMBER1 RESOLVED_MATCHING_NUMBER1
, RESOLVED_MATCHING_NUMBER2 RESOLVED_MATCHING_NUMBER2
, RESOLVED_MATCHING_NUMBER3 RESOLVED_MATCHING_NUMBER3
, RESOLVED_MATCHING_NUMBER4 RESOLVED_MATCHING_NUMBER4
, RESOLVED_MATCHING_NUMBER5 RESOLVED_MATCHING_NUMBER5
, RESOLVED_MATCHING_NUMBER6 RESOLVED_MATCHING_NUMBER6
, RESOLVED_MATCHING_NUMBER7 RESOLVED_MATCHING_NUMBER7
, RESOLVED_MATCHING_NUMBER8 RESOLVED_MATCHING_NUMBER8
, RESOLVED_MATCHING1_INSTALLMENT RESOLVED_MATCHING1_INSTALLMENT
, RESOLVED_MATCHING2_INSTALLMENT RESOLVED_MATCHING2_INSTALLMENT
, RESOLVED_MATCHING3_INSTALLMENT RESOLVED_MATCHING3_INSTALLMENT
, RESOLVED_MATCHING4_INSTALLMENT RESOLVED_MATCHING4_INSTALLMENT
, RESOLVED_MATCHING5_INSTALLMENT RESOLVED_MATCHING5_INSTALLMENT
, RESOLVED_MATCHING6_INSTALLMENT RESOLVED_MATCHING6_INSTALLMENT
, RESOLVED_MATCHING7_INSTALLMENT RESOLVED_MATCHING7_INSTALLMENT
, RESOLVED_MATCHING8_INSTALLMENT RESOLVED_MATCHING8_INSTALLMENT
, RESOLVED_MATCHING1_DATE RESOLVED_MATCHING1_DATE
, RESOLVED_MATCHING2_DATE RESOLVED_MATCHING2_DATE
, RESOLVED_MATCHING3_DATE RESOLVED_MATCHING3_DATE
, RESOLVED_MATCHING4_DATE RESOLVED_MATCHING4_DATE
, RESOLVED_MATCHING5_DATE RESOLVED_MATCHING5_DATE
, RESOLVED_MATCHING6_DATE RESOLVED_MATCHING6_DATE
, RESOLVED_MATCHING7_DATE RESOLVED_MATCHING7_DATE
, RESOLVED_MATCHING8_DATE RESOLVED_MATCHING8_DATE
, MATCHING1_DATE MATCHING1_DATE
, MATCHING2_DATE MATCHING2_DATE
, MATCHING3_DATE MATCHING3_DATE
, MATCHING4_DATE MATCHING4_DATE
, MATCHING5_DATE MATCHING5_DATE
, MATCHING6_DATE MATCHING6_DATE
, MATCHING7_DATE MATCHING7_DATE
, MATCHING8_DATE MATCHING8_DATE
, MATCH_RESOLVED_USING MATCH_RESOLVED_USING
, AMOUNT_APPLIED_FROM1 AMOUNT_APPLIED_FROM1
, AMOUNT_APPLIED_FROM2 AMOUNT_APPLIED_FROM2
, AMOUNT_APPLIED_FROM3 AMOUNT_APPLIED_FROM3
, AMOUNT_APPLIED_FROM4 AMOUNT_APPLIED_FROM4
, AMOUNT_APPLIED_FROM5 AMOUNT_APPLIED_FROM5
, AMOUNT_APPLIED_FROM6 AMOUNT_APPLIED_FROM6
, AMOUNT_APPLIED_FROM7 AMOUNT_APPLIED_FROM7
, AMOUNT_APPLIED_FROM8 AMOUNT_APPLIED_FROM8
, INVOICE_CURRENCY_CODE1 INVOICE_CURRENCY_CODE1
, INVOICE_CURRENCY_CODE2 INVOICE_CURRENCY_CODE2
, INVOICE_CURRENCY_CODE3 INVOICE_CURRENCY_CODE3
, INVOICE_CURRENCY_CODE4 INVOICE_CURRENCY_CODE4
, INVOICE_CURRENCY_CODE5 INVOICE_CURRENCY_CODE5
, INVOICE_CURRENCY_CODE6 INVOICE_CURRENCY_CODE6
, INVOICE_CURRENCY_CODE7 INVOICE_CURRENCY_CODE7
, INVOICE_CURRENCY_CODE8 INVOICE_CURRENCY_CODE8
, TRANS_TO_RECEIPT_RATE1 TRANS_TO_RECEIPT_RATE1
, TRANS_TO_RECEIPT_RATE2 TRANS_TO_RECEIPT_RATE2
, TRANS_TO_RECEIPT_RATE3 TRANS_TO_RECEIPT_RATE3
, TRANS_TO_RECEIPT_RATE4 TRANS_TO_RECEIPT_RATE4
, TRANS_TO_RECEIPT_RATE5 TRANS_TO_RECEIPT_RATE5
, TRANS_TO_RECEIPT_RATE6 TRANS_TO_RECEIPT_RATE6
, TRANS_TO_RECEIPT_RATE7 TRANS_TO_RECEIPT_RATE7
, TRANS_TO_RECEIPT_RATE8 TRANS_TO_RECEIPT_RATE8
, TMP_AMT_APPLIED_FROM1 TMP_AMT_APPLIED_FROM1
, TMP_AMT_APPLIED_FROM2 TMP_AMT_APPLIED_FROM2
, TMP_AMT_APPLIED_FROM3 TMP_AMT_APPLIED_FROM3
, TMP_AMT_APPLIED_FROM4 TMP_AMT_APPLIED_FROM4
, TMP_AMT_APPLIED_FROM5 TMP_AMT_APPLIED_FROM5
, TMP_AMT_APPLIED_FROM6 TMP_AMT_APPLIED_FROM6
, TMP_AMT_APPLIED_FROM7 TMP_AMT_APPLIED_FROM7
, TMP_AMT_APPLIED_FROM8 TMP_AMT_APPLIED_FROM8
, TMP_INV_CURRENCY_CODE1 TMP_INV_CURRENCY_CODE1
, TMP_INV_CURRENCY_CODE2 TMP_INV_CURRENCY_CODE2
, TMP_INV_CURRENCY_CODE3 TMP_INV_CURRENCY_CODE3
, TMP_INV_CURRENCY_CODE4 TMP_INV_CURRENCY_CODE4
, TMP_INV_CURRENCY_CODE5 TMP_INV_CURRENCY_CODE5
, TMP_INV_CURRENCY_CODE6 TMP_INV_CURRENCY_CODE6
, TMP_INV_CURRENCY_CODE7 TMP_INV_CURRENCY_CODE7
, TMP_INV_CURRENCY_CODE8 TMP_INV_CURRENCY_CODE8
, TMP_TRANS_TO_RCPT_RATE1 TMP_TRANS_TO_RCPT_RATE1
, TMP_TRANS_TO_RCPT_RATE2 TMP_TRANS_TO_RCPT_RATE2
, TMP_TRANS_TO_RCPT_RATE3 TMP_TRANS_TO_RCPT_RATE3
, TMP_TRANS_TO_RCPT_RATE4 TMP_TRANS_TO_RCPT_RATE4
, TMP_TRANS_TO_RCPT_RATE5 TMP_TRANS_TO_RCPT_RATE5
, TMP_TRANS_TO_RCPT_RATE6 TMP_TRANS_TO_RCPT_RATE6
, TMP_TRANS_TO_RCPT_RATE7 TMP_TRANS_TO_RCPT_RATE7
, TMP_TRANS_TO_RCPT_RATE8 TMP_TRANS_TO_RCPT_RATE8
, TMP_AMT_APPLIED1 TMP_AMT_APPLIED1
, TMP_AMT_APPLIED2 TMP_AMT_APPLIED2
, TMP_AMT_APPLIED3 TMP_AMT_APPLIED3
, TMP_AMT_APPLIED4 TMP_AMT_APPLIED4
, TMP_AMT_APPLIED5 TMP_AMT_APPLIED5
, TMP_AMT_APPLIED6 TMP_AMT_APPLIED6
, TMP_AMT_APPLIED7 TMP_AMT_APPLIED7
, TMP_AMT_APPLIED8 TMP_AMT_APPLIED8
, CPG_PURCHASE_ORDER_NUMBER CPG_PURCHASE_ORDER_NUMBER
, CPG_CUSTOMER_REF_NUMBER CPG_CUSTOMER_REF_NUMBER
, CPG_SHIP_TO_LOCATION_NUMBER CPG_SHIP_TO_LOCATION_NUMBER
, CPG_TRANSACTION_DATE CPG_TRANSACTION_DATE
, CPG_PROCESS_STATUS CPG_PROCESS_STATUS
, CPG_RECEIPT_STATUS CPG_RECEIPT_STATUS
, CPG_BATCH_DATE CPG_BATCH_DATE
, CPG_BATCH_STATUS CPG_BATCH_STATUS
, CPG_BATCH_SOURCE CPG_BATCH_SOURCE
, CPG_ORIGINAL_TRX_NUMBER CPG_ORIGINAL_TRX_NUMBER
, CPG_RECEIPT_COUNT CPG_RECEIPT_COUNT
, CPG_RECEIPT_AMOUNT CPG_RECEIPT_AMOUNT
, CPG_ORIG_REMITTANCE_AMOUNT CPG_ORIG_REMITTANCE_AMOUNT
, CPG_NEGATIVE_TRX_INDICATOR CPG_NEGATIVE_TRX_INDICATOR
, CPG_REASSOCIATION_TRACE_NUM CPG_REASSOCIATION_TRACE_NUM
, CPG_ASSOCIATION_FLAG CPG_ASSOCIATION_FLAG
, CPG_TRX_HANDLING_CODE CPG_TRX_HANDLING_CODE
, CPG_CUST_DEDUCTION_REASON_CODE CPG_CUST_DEDUCTION_REASON_CODE
, CPG_ORIG_BATCH_NAME CPG_ORIG_BATCH_NAME
, CPG_ORIG_LOCKBOX_NUMBER CPG_ORIG_LOCKBOX_NUMBER
, CPG_BATCH_SEQUENCE_NUMBER CPG_BATCH_SEQUENCE_NUMBER
, CPG_POSTMARK_DATE CPG_POSTMARK_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE1 USSGL_TRANSACTION_CODE1
, USSGL_TRANSACTION_CODE2 USSGL_TRANSACTION_CODE2
, USSGL_TRANSACTION_CODE3 USSGL_TRANSACTION_CODE3
, USSGL_TRANSACTION_CODE4 USSGL_TRANSACTION_CODE4
, USSGL_TRANSACTION_CODE5 USSGL_TRANSACTION_CODE5
, USSGL_TRANSACTION_CODE6 USSGL_TRANSACTION_CODE6
, USSGL_TRANSACTION_CODE7 USSGL_TRANSACTION_CODE7
, USSGL_TRANSACTION_CODE8 USSGL_TRANSACTION_CODE8
, APPLICATION_NOTES APPLICATION_NOTES
, CUSTOMER_REFERENCE1 CUSTOMER_REFERENCE1
, CUSTOMER_REFERENCE2 CUSTOMER_REFERENCE2
, CUSTOMER_REFERENCE3 CUSTOMER_REFERENCE3
, CUSTOMER_REFERENCE4 CUSTOMER_REFERENCE4
, CUSTOMER_REFERENCE5 CUSTOMER_REFERENCE5
, CUSTOMER_REFERENCE6 CUSTOMER_REFERENCE6
, CUSTOMER_REFERENCE7 CUSTOMER_REFERENCE7
, CUSTOMER_REFERENCE8 CUSTOMER_REFERENCE8
, CUSTOMER_REASON1 CUSTOMER_REASON1
, CUSTOMER_REASON2 CUSTOMER_REASON2
, CUSTOMER_REASON3 CUSTOMER_REASON3
, CUSTOMER_REASON4 CUSTOMER_REASON4
, CUSTOMER_REASON5 CUSTOMER_REASON5
, CUSTOMER_REASON6 CUSTOMER_REASON6
, CUSTOMER_REASON7 CUSTOMER_REASON7
, CUSTOMER_REASON8 CUSTOMER_REASON8
, SOURCE_TYPE_FLAG SOURCE_TYPE_FLAG
, SC_MATCHING_STATUS SC_MATCHING_STATUS
FROM "AR"."AR_PAYMENTS_INTERFACE_ALL"