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