[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_PAYMENTS_INTERFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_PAYMENTS_INTERFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
The AR_PAYMENTS_INTERFACE_ALL table stores imported Lockbox information that were not validated. AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. An AutoLockbox operation can process millions of transactions a month.
.
AutoLockbox creates one row in this table for each record in a transmission. When you run the AutoLockbox validation step, Oracle Receivables transfers the information from the AR_PAYMENTS_INTERFACE_ALL table to the AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL tables.
.
Please refer to the appendix of the Oracle Receivables User Guide or online help for more detailed information on Open Interface table columns, including import validation and destination columns.
.
The primary key for this table is TRANSMISSION_RECORD_ID.
Scope: public
Product: AR
Lifecycle: active
Display Name: AR Payments Interface
Category: BUSINESS_ENTITY AR_REMITTANCE
Category: BUSINESS_ENTITY AR_RECEIPT
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_PAYMENTS_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRANSMISSION_RECORD_ID
|
| AR_PAYMENTS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
RECORD_TYPE
|
| AR_PAYMENTS_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ITEM_NUMBER
OVERFLOW_SEQUENCE
|
| AR_PAYMENTS_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CHECK_NUMBER
CUSTOMER_ID
|
| AR_PAYMENTS_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSIT_ROUTING_NUMBER
ACCOUNT
|
| AR_PAYMENTS_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSMISSION_ID
STATUS
RECORD_TYPE
|
| AR_PAYMENTS_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSMISSION_ID
BATCH_NAME
RECORD_TYPE
|
| AR_PAYMENTS_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSMISSION_ID
RECORD_TYPE
ITEM_NUMBER
|
| AR_PAYMENTS_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSMISSION_ID
ITEM_NUMBER
|
| AR_PAYMENTS_INTERFACE_N9 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CHECK_NUMBER
REMITTANCE_AMOUNT
TRANSMISSION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSMISSION_RECORD_ID | NUMBER | (15) | Identifier of the transmission record | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| RECORD_TYPE | VARCHAR2 | (2) | Yes | Identifies the type of a record |
| STATUS | VARCHAR2 | (30) | Status of the transmission record | |
| TRANSMISSION_REQUEST_ID | NUMBER | (15) | Identifies original concurrent request of transmission | |
| DESTINATION_ACCOUNT | VARCHAR2 | (25) | Destination account number | |
| ORIGINATION | VARCHAR2 | (25) | Identifies the bank that sent the transmission | |
| DEPOSIT_DATE | DATE | Date that the items referred to in a record were deposited in the bank | ||
| DEPOSIT_TIME | VARCHAR2 | (8) | Time when the items referred to in a record were deposited in a bank | |
| TRANSMISSION_RECORD_COUNT | NUMBER | (15) | Number of records within the transmission | |
| TRANSMISSION_AMOUNT | NUMBER | Sum of the payments within the transmission | ||
| LOCKBOX_NUMBER | VARCHAR2 | (30) | Number given by the bank to identify a lockbox | |
| LOCKBOX_BATCH_COUNT | NUMBER | Number of batches in the lockbox | ||
| LOCKBOX_RECORD_COUNT | NUMBER | Number of receipts that are associated with the lockbox | ||
| LOCKBOX_AMOUNT | NUMBER | Value should equal the sum of all the payment amounts, as well as the sum of all batch amounts that are contained in a lockbox | ||
| BATCH_NAME | VARCHAR2 | (25) | Batch name that corresponds to the batch | |
| BATCH_AMOUNT | NUMBER | Value should equal the sum of all payment amounts that are contained in a batch | ||
| BATCH_RECORD_COUNT | NUMBER | (15) | Number of records that are associated with a batch | |
| ITEM_NUMBER | NUMBER | Identifies the item number that is associated with the payment record | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code for the amounts in a record | |
| REMITTANCE_AMOUNT | NUMBER | Amount of a payment | ||
| TRANSIT_ROUTING_NUMBER | VARCHAR2 | (25) | Transit routing number on a check | |
| ACCOUNT | VARCHAR2 | (30) | Bank account that a payment is sent from | |
| CHECK_NUMBER | VARCHAR2 | (30) | Receipt number | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Identifies the customer who sent the payment | |
| OVERFLOW_INDICATOR | VARCHAR2 | (1) | Indicates that additional overflow records exist that are associated with the payment | |
| OVERFLOW_SEQUENCE | NUMBER | Specifies the sequence of records in an overflow situation | ||
| INVOICE1 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE2 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE3 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE4 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE5 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE6 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE7 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| INVOICE8 | VARCHAR2 | (50) | Matching number of invoice that a payment is applied to | |
| AMOUNT_APPLIED1 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED2 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED3 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED4 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED5 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED6 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED7 | NUMBER | Amount that is applied in invoice's currency | ||
| AMOUNT_APPLIED8 | NUMBER | Amount that is applied in invoice's currency | ||
| INVOICE1_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE2_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE3_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE4_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE5_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE6_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE7_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| INVOICE8_STATUS | VARCHAR2 | (30) | Status of the specified invoice | |
| GL_DATE | DATE | General Ledger date | ||
| COMMENTS | VARCHAR2 | (240) | Contains text that is transferred to either the AR_BATCHES or the AR_CASH_RECEIPTS table, depending on records - Batch or Payments | |
| CUSTOMER_ID | NUMBER | (15) | Identifier of a customer, also used in the RA_CUSTOMERS table | |
| SPECIAL_TYPE | VARCHAR2 | (20) | Indicates the status of payment, if payment was applied to single or multiple invoices | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| RECEIPT_METHOD | VARCHAR2 | (30) | Method for processing receipts | |
| RECEIPT_METHOD_ID | NUMBER | (15) | Identifies the receipt method, also in the AR_RECEIPT_METHODS table | |
| BILL_TO_LOCATION | VARCHAR2 | (40) | Customer's site that remitted the receipt | |
| CUSTOMER_SITE_USE_ID | NUMBER | (15) | Identifies the customer's site, also in the RA_SITE_USES_ALL table | |
| TRANSFERRED_RECEIPT_COUNT | NUMBER | Number of receipts in this transmission that were transferred to the interim table | ||
| TRANSFERRED_RECEIPT_AMOUNT | NUMBER | Sum of the remittance amounts in this transmission that were transferred to the interim table | ||
| INVOICE1_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE2_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE3_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE4_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE5_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE6_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE7_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| INVOICE8_INSTALLMENT | NUMBER | Transaction's payment schedule | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Conversion type to realize foreign currency | |
| EXCHANGE_RATE | NUMBER | Conversion rate to realize foreign currency | ||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | Identifies the customer's bank account | |
| TRANSMISSION_ID | NUMBER | (15) | Identifies the lockbox transmission, also in the AR_TRANSMISSIONS table | |
| RECEIPT_DATE | DATE | Date when the receipt was created | ||
| ORG_ID | NUMBER | (15) | Organization identifier | |
| ANTICIPATED_CLEARING_DATE | DATE | Date when the receipt is expected to clear the bank | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| CUSTOMER_NAME_ALT | VARCHAR2 | (320) | Customer's alternate name | |
| CUSTOMER_BANK_NAME | VARCHAR2 | (320) | Name of customer's bank | |
| CUSTOMER_BANK_BRANCH_NAME | VARCHAR2 | (320) | Name of customer's bank branch | |
| REMITTANCE_BANK_NAME | VARCHAR2 | (320) | Name of receiving bank | |
| REMITTANCE_BANK_BRANCH_NAME | VARCHAR2 | (320) | Name of receiving bank branch | |
| BANK_TRX_CODE | VARCHAR2 | (30) | Code that the bank uses to identify a transaction | |
| RESOLVED_MATCHING_NUMBER1 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER2 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER3 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER4 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER5 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER6 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER7 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING_NUMBER8 | VARCHAR2 | (20) | Invoice number that corresponds to matching number | |
| RESOLVED_MATCHING1_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING2_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING3_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING4_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING5_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING6_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING7_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING8_INSTALLMENT | NUMBER | Payment schedule for invoice number that is stored in matching number column | ||
| RESOLVED_MATCHING1_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING2_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING3_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING4_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING5_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING6_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING7_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| RESOLVED_MATCHING8_DATE | DATE | Transaction date that corresponds to transaction number that is stored in matching number column | ||
| MATCHING1_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING2_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING3_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING4_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING5_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING6_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING7_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCHING8_DATE | DATE | Date that corresponds to matching number that is stored in Invoice column | ||
| MATCH_RESOLVED_USING | VARCHAR2 | (30) | Method that is used to determine how to apply this receipt | |
| AMOUNT_APPLIED_FROM1 | NUMBER | Amount that is applied to transaction 1, in receipt currency | ||
| AMOUNT_APPLIED_FROM2 | NUMBER | Amount that is applied to transaction 2, in receipt currency | ||
| AMOUNT_APPLIED_FROM3 | NUMBER | Amount that is applied to transaction 3, in receipt currency | ||
| AMOUNT_APPLIED_FROM4 | NUMBER | Amount that is applied to transaction 4, in receipt currency | ||
| AMOUNT_APPLIED_FROM5 | NUMBER | Amount that is applied to transaction 5, in receipt currency | ||
| AMOUNT_APPLIED_FROM6 | NUMBER | Amount that is applied to transaction 6, in receipt currency | ||
| AMOUNT_APPLIED_FROM7 | NUMBER | Amount that is applied to transaction 7, in receipt currency | ||
| AMOUNT_APPLIED_FROM8 | NUMBER | Amount that is applied to transaction 8, in receipt currency | ||
| INVOICE_CURRENCY_CODE1 | VARCHAR2 | (15) | Currency code of transaction 1 | |
| INVOICE_CURRENCY_CODE2 | VARCHAR2 | (15) | Currency code of transaction 2 | |
| INVOICE_CURRENCY_CODE3 | VARCHAR2 | (15) | Currency code of transaction 3 | |
| INVOICE_CURRENCY_CODE4 | VARCHAR2 | (15) | Currency code of transaction 4 | |
| INVOICE_CURRENCY_CODE5 | VARCHAR2 | (15) | Currency code of transaction 5 | |
| INVOICE_CURRENCY_CODE6 | VARCHAR2 | (15) | Currency code of transaction 6 | |
| INVOICE_CURRENCY_CODE7 | VARCHAR2 | (15) | Currency code of transaction 7 | |
| INVOICE_CURRENCY_CODE8 | VARCHAR2 | (15) | Currency code of transaction 8 | |
| TRANS_TO_RECEIPT_RATE1 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE2 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE3 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE4 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE5 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE6 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE7 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TRANS_TO_RECEIPT_RATE8 | NUMBER | Exchange rate that is used to convert the receipt amount to the transaction currency | ||
| TMP_AMT_APPLIED_FROM1 | NUMBER | Temporary amount that is applied to transaction 1, in receipt currency | ||
| TMP_AMT_APPLIED_FROM2 | NUMBER | Temporary amount that is applied to transaction 2, in receipt currency | ||
| TMP_AMT_APPLIED_FROM3 | NUMBER | Temporary amount that is applied to transaction 3, in receipt currency | ||
| TMP_AMT_APPLIED_FROM4 | NUMBER | Temporary amount that is applied to transaction 4, in receipt currency | ||
| TMP_AMT_APPLIED_FROM5 | NUMBER | Temporary amount that is applied to transaction 5, in receipt currency | ||
| TMP_AMT_APPLIED_FROM6 | NUMBER | Temporary amount that is applied to transaction 6, in receipt currency | ||
| TMP_AMT_APPLIED_FROM7 | NUMBER | Temporary amount that is applied to transaction 7, in receipt currency | ||
| TMP_AMT_APPLIED_FROM8 | NUMBER | Temporary amount that is applied to transaction 8, in receipt currency | ||
| TMP_INV_CURRENCY_CODE1 | VARCHAR2 | (15) | Temporary currency code of transaction 1 | |
| TMP_INV_CURRENCY_CODE2 | VARCHAR2 | (15) | Temporary currency code of transaction 2 | |
| TMP_INV_CURRENCY_CODE3 | VARCHAR2 | (15) | Temporary currency code of transaction 3 | |
| TMP_INV_CURRENCY_CODE4 | VARCHAR2 | (15) | Temporary currency code of transaction 4 | |
| TMP_INV_CURRENCY_CODE5 | VARCHAR2 | (15) | Temporary currency code of transaction 5 | |
| TMP_INV_CURRENCY_CODE6 | VARCHAR2 | (15) | Temporary currency code of transaction 6 | |
| TMP_INV_CURRENCY_CODE7 | VARCHAR2 | (15) | Temporary currency code of transaction 7 | |
| TMP_INV_CURRENCY_CODE8 | VARCHAR2 | (15) | Temporary currency code of transaction 8 | |
| TMP_TRANS_TO_RCPT_RATE1 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE2 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE3 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE4 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE5 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE6 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE7 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_TRANS_TO_RCPT_RATE8 | NUMBER | Temporary conversion rate that is used to convert the receipt from the transaction currency to the receipt currency | ||
| TMP_AMT_APPLIED1 | NUMBER | Temporary amount that is applied to transaction 1, in transaction currency | ||
| TMP_AMT_APPLIED2 | NUMBER | Temporary amount that is applied to transaction 2, in transaction currency | ||
| TMP_AMT_APPLIED3 | NUMBER | Temporary amount that is applied to transaction 3, in transaction currency | ||
| TMP_AMT_APPLIED4 | NUMBER | Temporary amount that is applied to transaction 4, in transaction currency | ||
| TMP_AMT_APPLIED5 | NUMBER | Temporary amount that is applied to transaction 5, in transaction currency | ||
| TMP_AMT_APPLIED6 | NUMBER | Temporary amount that is applied to transaction 6, in transaction currency | ||
| TMP_AMT_APPLIED7 | NUMBER | Temporary amount that is applied to transaction 7, in transaction currency | ||
| TMP_AMT_APPLIED8 | NUMBER | Temporary amount that is applied to transaction 8, in transaction currency | ||
| CPG_PURCHASE_ORDER_NUMBER | VARCHAR2 | (30) | Contains the purchase order number of the receipt line, updated for record type 6 | |
| CPG_CUSTOMER_REF_NUMBER | VARCHAR2 | (30) | Contains the promotion number of the receipt line, updated for record type 6 | |
| CPG_SHIP_TO_LOCATION_NUMBER | VARCHAR2 | (30) | Contains the ship-to location number of the receipt line, updated for record type 6 | |
| CPG_TRANSACTION_DATE | DATE | Contains the transaction date of the receipt line, updated for record type 6 | ||
| CPG_PROCESS_STATUS | VARCHAR2 | (1) | No longer used | |
| CPG_RECEIPT_STATUS | VARCHAR2 | (15) | OPEN indicates that some validation errors exist, while PENDING indicates receipt is ready for submission | |
| CPG_BATCH_DATE | DATE | Date of the batch, updated for record type 4 | ||
| CPG_BATCH_STATUS | VARCHAR2 | (15) | Status of the batch | |
| CPG_BATCH_SOURCE | NUMBER | Batch source, used in High Volume Entry EDI and Non-EDI windows, and updated for record type 4 | ||
| CPG_ORIGINAL_TRX_NUMBER | VARCHAR2 | (30) | No longer used | |
| CPG_RECEIPT_COUNT | NUMBER | Number of receipt lines in a receipt line, updated for record type 5 | ||
| CPG_RECEIPT_AMOUNT | NUMBER | Receipt amount, updated for record type 5 | ||
| CPG_ORIG_REMITTANCE_AMOUNT | NUMBER | No longer used | ||
| CPG_NEGATIVE_TRX_INDICATOR | VARCHAR2 | (1) | No longer used | |
| CPG_REASSOCIATION_TRACE_NUM | VARCHAR2 | (30) | Trace number of the receipt or receipt line for EDI batches, updated for record types 5 and 6 | |
| CPG_ASSOCIATION_FLAG | VARCHAR2 | (1) | Y if receipt can be associated with a receipt line or vice versa, N if receipt cannot be associated, or Null if receipt is yet to be associated. Used by the Re-association module and updated for record types 5 and 6. | |
| CPG_TRX_HANDLING_CODE | VARCHAR2 | (1) | Reserved for future use. Applicable only for EDI batches. | |
| CPG_CUST_DEDUCTION_REASON_CODE | VARCHAR2 | (2) | Reserved for future use. Applicable only for EDI batches. | |
| CPG_ORIG_BATCH_NAME | VARCHAR2 | (25) | Batch name that the receipt or receipt line belonged to before association. Used in High Volume Entry - EDI window and updated for record types 5 and 6 for EDI batches. | |
| CPG_ORIG_LOCKBOX_NUMBER | VARCHAR2 | (30) | Lockbox number that the receipt or receipt line belonged to before association. Used in High Volume Entry - EDI window and updated for record types 5 and 6 for EDI batches. | |
| CPG_BATCH_SEQUENCE_NUMBER | NUMBER | Sequence number of the batch within the transmission. Used for display in the Unmatched Payments window and updated in the Lockbox_COVER module. | ||
| CPG_POSTMARK_DATE | DATE | Postmark date of the receipt. Used for discount calculation and updated for record type 6. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE1 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE2 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE3 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE4 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE5 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE6 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE7 | VARCHAR2 | (30) | USSGL Transaction Code | |
| USSGL_TRANSACTION_CODE8 | VARCHAR2 | (30) | USSGL Transaction Code | |
| APPLICATION_NOTES | VARCHAR2 | (2000) | Reference number that could not be matched to a transaction number during AutoLockbox validation. | |
| CUSTOMER_REFERENCE1 | VARCHAR2 | (100) | Customer Reference 1 | |
| CUSTOMER_REFERENCE2 | VARCHAR2 | (100) | Customer Reference 2 | |
| CUSTOMER_REFERENCE3 | VARCHAR2 | (100) | Customer Reference 3 | |
| CUSTOMER_REFERENCE4 | VARCHAR2 | (100) | Customer Reference 4 | |
| CUSTOMER_REFERENCE5 | VARCHAR2 | (100) | Customer Reference 5 | |
| CUSTOMER_REFERENCE6 | VARCHAR2 | (100) | Customer Reference 6 | |
| CUSTOMER_REFERENCE7 | VARCHAR2 | (100) | Customer Reference 7 | |
| CUSTOMER_REFERENCE8 | VARCHAR2 | (100) | Customer Reference 8 | |
| CUSTOMER_REASON1 | VARCHAR2 | (30) | Customer Reason 1 | |
| CUSTOMER_REASON2 | VARCHAR2 | (30) | Customer Reason 2 | |
| CUSTOMER_REASON3 | VARCHAR2 | (30) | Customer Reason 3 | |
| CUSTOMER_REASON4 | VARCHAR2 | (30) | Customer Reason 4 | |
| CUSTOMER_REASON5 | VARCHAR2 | (30) | Customer Reason 5 | |
| CUSTOMER_REASON6 | VARCHAR2 | (30) | Customer Reason 6 | |
| CUSTOMER_REASON7 | VARCHAR2 | (30) | Customer Reason 7 | |
| CUSTOMER_REASON8 | VARCHAR2 | (30) | Customer Reason 8 | |
| SOURCE_TYPE_FLAG | VARCHAR2 | (1) | Indicates interfaced data source | |
| SC_MATCHING_STATUS | VARCHAR2 | (30) | Lookup code for Smart Cash matching status |
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 does not reference any database object
AR.AR_PAYMENTS_INTERFACE_ALL is referenced by following:
AR
AR_PAYMENTS_INTERFACE_ALL#
|
|
|
|