[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#;
|
|
|