AR_PAYMENTS_INTERFACE_ALL
The AR_PAYMENTS_INTERFACE_ALL table contains imported Lockbox information that is not validated. Lockbox is a service commercial banks offer corporate customers to outsource their accounts receivable payment processing. Lockbox creates one row in this table for each record in a transmission. When Lockbox validation is performed, information transfers from the AR_PAYMENTS_INTERFACE_ALL table to the AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL tables. The primary key for this table is TRANSMISSION_RECORD_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Comments | Flexfield-mapping |
|---|---|---|---|---|---|
| TRANSMISSION_RECORD_ID | NUMBER | 18 | Oracle internal use only. Transmission record identifier. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| RECORD_TYPE | VARCHAR2 | 2 | Record type based on control file. | ||
| STATUS | VARCHAR2 | 30 | Oracle internal use only. Transmission status. | ||
| TRANSMISSION_REQUEST_ID | NUMBER | 18 | Oracle internal use only. Transmission request identifier. | ||
| DESTINATION_ACCOUNT | VARCHAR2 | 25 | Receiving bank for lockbox transmission. Free text field. Not validated. | ||
| ORIGINATION | VARCHAR2 | 25 | Number that uniquely identifies bank branch that sent lockbox transmission. Not validated. | ||
| DEPOSIT_DATE | DATE | Date transmission items are deposited into bank account. Format determined by transmitting bank. | |||
| DEPOSIT_TIME | VARCHAR2 | 8 | Time transmission items are deposited in the remittance bank. Format determined by transmitting bank. | ||
| TRANSMISSION_RECORD_COUNT | NUMBER | 18 | Number of records within transmission. Whole numbers only. Must match actual receipt count and amount from lockbox process. | ||
| TRANSMISSION_AMOUNT | NUMBER | Sum of payments within the transmission. | |||
| LOCKBOX_NUMBER | VARCHAR2 | 30 | Lockbox number. Use Manage Lockboxes task to identify valid values. Must match the number provided by the bank. | ||
| LOCKBOX_BATCH_COUNT | NUMBER | Number of batches in the lockbox. Do not use thousand separators. Use period or comma as decimal separator. Must equal number of batches from lockbox process. | |||
| LOCKBOX_RECORD_COUNT | NUMBER | Number of receipts associated with the lockbox. | |||
| LOCKBOX_AMOUNT | NUMBER | Total value of receipts in the lockbox. Value must equal the sum of all receipt amounts plus the sum of all batch amounts. | |||
| BATCH_NAME | VARCHAR2 | 25 | Batch name. A separate batch of transmission records is created per unique batch name. | ||
| BATCH_AMOUNT | NUMBER | Total value of receipts in the batch. Use period or comma as decimal separator. Must equal the number of batches from lockbox process. | |||
| BATCH_RECORD_COUNT | NUMBER | 18 | Number of records in the batch. Do not use thousand separators. Use period or comma as decimal separator. Must equal number of records in batch. | ||
| ITEM_NUMBER | NUMBER | Number indicating location of receipt or overflow record in the batch. Must be unique within batch, lockbox, or transmission. Overflow records must have the same item number as receipts. Each overflow record must have a value. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code for the amounts in a record. Use Manage Currencies task to identify valid values. Use a three character ISO code. Example: US Dollars is USD. | ||
| REMITTANCE_AMOUNT | NUMBER | Mandatory field for the receipt amount. | |||
| TRANSIT_ROUTING_NUMBER | VARCHAR2 | 25 | Receipt transit routing number from bank account used to originate payment. | ||
| ACCOUNT | VARCHAR2 | 30 | Receipt from bank account used to originate payment. Required if TRANSIT_ROUTING_NUMBER is used. | ||
| CHECK_NUMBER | VARCHAR2 | 30 | Receipt number. Mandatory free text field. | ||
| CUSTOMER_NUMBER | VARCHAR2 | 30 | Customer number. Navigate to Receivables Balances, Manage Customers from the workpane to identify valid values. | ||
| OVERFLOW_INDICATOR | VARCHAR2 | 1 | Overflow indicator. Use Manage Transmission Formats task to identify valid values. | ||
| OVERFLOW_SEQUENCE | NUMBER | Overflow records sequence indicator. Usually begins with 1 within each receipt. Do not use thousand separators. Use period or comma as decimal separator. Not validated. | |||
| INVOICE1 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 1. | ||
| INVOICE2 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 2. | ||
| INVOICE3 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 3. | ||
| INVOICE4 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 4. | ||
| INVOICE5 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 5. | ||
| INVOICE6 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 6. | ||
| INVOICE7 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 7. | ||
| INVOICE8 | VARCHAR2 | 50 | Document reference number to match receipt application with transaction 8. | ||
| AMOUNT_APPLIED1 | NUMBER | Amount applied to transaction 1. Amount based on transaction currency. | |||
| AMOUNT_APPLIED2 | NUMBER | Amount applied to transaction 2. Use transaction currency amount. | |||
| AMOUNT_APPLIED3 | NUMBER | Amount applied to transaction 3. Amount based on transaction currency. | |||
| AMOUNT_APPLIED4 | NUMBER | Amount applied to transaction 4. Amount based on transaction currency. | |||
| AMOUNT_APPLIED5 | NUMBER | Amount applied to transaction 5. Amount based on transaction currency. | |||
| AMOUNT_APPLIED6 | NUMBER | Amount applied to transaction 6. Amount based on transaction currency. | |||
| AMOUNT_APPLIED7 | NUMBER | Amount applied to transaction 7. Amount based on transaction currency. | |||
| AMOUNT_APPLIED8 | NUMBER | Amount applied to transaction 8. Amount based on transaction currency. | |||
| INVOICE1_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 1 status. | ||
| INVOICE2_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 2 status. | ||
| INVOICE3_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 3 status. | ||
| INVOICE4_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 4 status. | ||
| INVOICE5_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 5 status. | ||
| INVOICE6_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 6 status. | ||
| INVOICE7_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 7 status. | ||
| INVOICE8_STATUS | VARCHAR2 | 30 | Oracle internal use only. Transaction 8 status. | ||
| GL_DATE | DATE | Oracle internal use only. Accounting date. | |||
| COMMENTS | VARCHAR2 | 240 | Comments. Free field text. Not validated. | ||
| CUSTOMER_ID | NUMBER | 18 | Oracle internal use only. Customer identifier. | ||
| SPECIAL_TYPE | VARCHAR2 | 20 | Oracle internal use only. Indicates whether receipt was applied to single or multiple invoices. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Payment Interface descriptive flexfield. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Payment Interface descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE15 for the segment values. | Payment Interface (AR_PAYMENTS_INTERFACE) | |
| RECEIPT_METHOD | VARCHAR2 | 30 | Receipt method. Use Manage Receipt Classes and Methods task to identify valid values. Use only receipt methods associated with receipt classes that use a creation method of manual. | ||
| RECEIPT_METHOD_ID | NUMBER | 18 | Oracle internal use only. Receipt method identifier. | ||
| BILL_TO_LOCATION | VARCHAR2 | 40 | Customer bill-to site. Navigate to Receivables Balances, Manage Customers from the taskpane to identify valid values. | ||
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Oracle internal use only. Customer site use identifier. | ||
| TRANSFERRED_RECEIPT_COUNT | NUMBER | Oracle internal use only. Transferred receipt count. | |||
| TRANSFERRED_RECEIPT_AMOUNT | NUMBER | Oracle internal use only. Transferred receipt amount. | |||
| INVOICE1_INSTALLMENT | NUMBER | Installment number: transaction 1. Must be on the same record as transaction 1. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE2_INSTALLMENT | NUMBER | Installment number: transaction 2. Must be on the same record as transaction 2. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE3_INSTALLMENT | NUMBER | Installment number: transaction 3. Must be on the same record as transaction 3. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE4_INSTALLMENT | NUMBER | Installment number: transaction 4. Must be on the same record as transaction 4. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE5_INSTALLMENT | NUMBER | Installment number: transaction 5. Must be on the same record as transaction 5. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE6_INSTALLMENT | NUMBER | Installment number: transaction 6. Must be on the same record as transaction 6. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE7_INSTALLMENT | NUMBER | Installment number: transaction 7. Must be on the same record as transaction 7. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| INVOICE8_INSTALLMENT | NUMBER | Installment number: transaction 8. Must be on the same record as transaction 8. Navigate to the Billing work area, Manage Transactions taskpane to identify valid values. Use whole numbers only. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion type to convert to ledger currency. Use Manage Conversion Rate Types task to identify valid values. | ||
| EXCHANGE_RATE | NUMBER | Exchange rate to convert to ledger currency. Do not use thousand separators. Use only if EXCHANGE_RATE_TYPE is user-defined. Use period or comma as decimal separator. Not validated. | |||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | 18 | Oracle internal use only. Customer bank account identifier. | ||
| TRANSMISSION_ID | NUMBER | 18 | Oracle internal use only. Transmission identifier. | ||
| RECEIPT_DATE | DATE | Receipt creation date. | |||
| ORG_ID | NUMBER | 18 | Business unit identifier. Use Manage Business Units task to identify valid values. | ||
| ANTICIPATED_CLEARING_DATE | DATE | Date on which the receipt is expected to clear the bank. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Segment value for Receipt global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Receipt global descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use GLOBAL_ATTRIBUTE1 to GLOBAL_ATTRIBUTE20 for segment values. | ||
| CUSTOMER_NAME_ALT | VARCHAR2 | 320 | Oracle internal use only. Alternate customer name. | ||
| CUSTOMER_BANK_NAME | VARCHAR2 | 320 | Customer bank name. Use Manage Banks task to identify valid values. | ||
| CUSTOMER_BANK_BRANCH_NAME | VARCHAR2 | 320 | Customer bank branch name. Use Manage Bank Branches task to identify valid values. | ||
| REMITTANCE_BANK_NAME | VARCHAR2 | 320 | Receiving bank name. Use Manage Receipt Classes and Methods task to identify valid values. | ||
| REMITTANCE_BANK_BRANCH_NAME | VARCHAR2 | 320 | Receiving bank branch name. Use Manage Receipt Classes and Methods task to identify valid values. | ||
| BANK_TRX_CODE | VARCHAR2 | 30 | Bank transaction code. Free text field. Not validated. | ||
| RESOLVED_MATCHING_NUMBER1 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 1. | ||
| RESOLVED_MATCHING_NUMBER2 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 2. | ||
| RESOLVED_MATCHING_NUMBER3 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 3. | ||
| RESOLVED_MATCHING_NUMBER4 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 4. | ||
| RESOLVED_MATCHING_NUMBER5 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 5. | ||
| RESOLVED_MATCHING_NUMBER6 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 6. | ||
| RESOLVED_MATCHING_NUMBER7 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 7. | ||
| RESOLVED_MATCHING_NUMBER8 | VARCHAR2 | 20 | Oracle internal use only. Resolved matching number: transaction 8. | ||
| RESOLVED_MATCHING1_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 1. | |||
| RESOLVED_MATCHING2_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 2. | |||
| RESOLVED_MATCHING3_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 3. | |||
| RESOLVED_MATCHING4_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 4. | |||
| RESOLVED_MATCHING5_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 5. | |||
| RESOLVED_MATCHING6_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 6. | |||
| RESOLVED_MATCHING7_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 7. | |||
| RESOLVED_MATCHING8_INSTALLMENT | NUMBER | Oracle internal use only. Payment schedule: transaction 8. | |||
| RESOLVED_MATCHING1_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER1. | |||
| RESOLVED_MATCHING2_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER2. | |||
| RESOLVED_MATCHING3_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER3. | |||
| RESOLVED_MATCHING4_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER4. | |||
| RESOLVED_MATCHING5_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER5. | |||
| RESOLVED_MATCHING6_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER6. | |||
| RESOLVED_MATCHING7_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER7. | |||
| RESOLVED_MATCHING8_DATE | DATE | Oracle internal use only. Transaction date for RESOLVED_MATCHING_NUMBER8. | |||
| MATCHING1_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 1. | |||
| MATCHING2_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 2. | |||
| MATCHING3_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 3. | |||
| MATCHING4_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 4. | |||
| MATCHING5_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 5. | |||
| MATCHING6_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 6. | |||
| MATCHING7_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 7. | |||
| MATCHING8_DATE | DATE | Oracle internal use only. Date used to match lockbox payment: transaction 8. | |||
| MATCH_RESOLVED_USING | VARCHAR2 | 30 | Oracle internal use only. Method used to determine how to apply receipt. | ||
| AMOUNT_APPLIED_FROM1 | NUMBER | Amount applied to transaction 1, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM2 | NUMBER | Amount applied to transaction 2, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM3 | NUMBER | Amount applied to transaction 3, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM4 | NUMBER | Amount applied to transaction 4, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM5 | NUMBER | Amount applied to transaction 5, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM6 | NUMBER | Amount applied to transaction 6, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM7 | NUMBER | Amount applied to transaction 7, in receipt currency. Use if receipt and transaction currencies are different. | |||
| AMOUNT_APPLIED_FROM8 | NUMBER | Amount applied to transaction 8, in receipt currency. Use if receipt and transaction currencies are different. | |||
| INVOICE_CURRENCY_CODE1 | VARCHAR2 | 15 | Currency code: transaction 1. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE2 | VARCHAR2 | 15 | Currency code: transaction 2. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE3 | VARCHAR2 | 15 | Currency code: transaction 3. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE4 | VARCHAR2 | 15 | Currency code: transaction 4. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE5 | VARCHAR2 | 15 | Currency code: transaction 5. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE6 | VARCHAR2 | 15 | Currency code: transaction 6. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE7 | VARCHAR2 | 15 | Currency code: transaction 7. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| INVOICE_CURRENCY_CODE8 | VARCHAR2 | 15 | Currency code: transaction 8. Used for cross-currency receipt applications. Use a three character ISO code. Example: US Dollars is USD. | ||
| TRANS_TO_RECEIPT_RATE1 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 1. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE2 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 2. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE3 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 3. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE4 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 4. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE5 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 5. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE6 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 6. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE7 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 7. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TRANS_TO_RECEIPT_RATE8 | NUMBER | Currency conversion rate to convert receipt amount to the transaction currency: transaction 8. Use for cross-currency receipt applications when receipt and transaction currencies do not have a fixed exchange rate. Do not use thousand separators. Use period or comma as decimal separator. | |||
| TMP_AMT_APPLIED_FROM1 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 1. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM2 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 2. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM3 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 3. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM4 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 4. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM5 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 5. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM6 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 6. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM7 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 7. Use receipt currency. | |||
| TMP_AMT_APPLIED_FROM8 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 8. Use receipt currency. | |||
| TMP_INV_CURRENCY_CODE1 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 1. | ||
| TMP_INV_CURRENCY_CODE2 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 2. | ||
| TMP_INV_CURRENCY_CODE3 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 3. | ||
| TMP_INV_CURRENCY_CODE4 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 4. | ||
| TMP_INV_CURRENCY_CODE5 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 5. | ||
| TMP_INV_CURRENCY_CODE6 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 6. | ||
| TMP_INV_CURRENCY_CODE7 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 7. | ||
| TMP_INV_CURRENCY_CODE8 | VARCHAR2 | 15 | Oracle internal use only. Temporary currency code: transaction 8. | ||
| TMP_TRANS_TO_RCPT_RATE1 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 1. | |||
| TMP_TRANS_TO_RCPT_RATE2 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 2. | |||
| TMP_TRANS_TO_RCPT_RATE3 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 3. | |||
| TMP_TRANS_TO_RCPT_RATE4 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 4. | |||
| TMP_TRANS_TO_RCPT_RATE5 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 5. | |||
| TMP_TRANS_TO_RCPT_RATE6 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 6. | |||
| TMP_TRANS_TO_RCPT_RATE7 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 7. | |||
| TMP_TRANS_TO_RCPT_RATE8 | NUMBER | Oracle internal use only. Temporary conversion rate to convert receipt from transaction currency to receipt currency: transaction 8. | |||
| TMP_AMT_APPLIED1 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 1. Uses transaction currency. | |||
| TMP_AMT_APPLIED2 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 2. Uses transaction currency. | |||
| TMP_AMT_APPLIED3 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 3. Uses transaction currency. | |||
| TMP_AMT_APPLIED4 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 4. Uses transaction currency. | |||
| TMP_AMT_APPLIED5 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 5. Uses transaction currency. | |||
| TMP_AMT_APPLIED6 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 6. Uses transaction currency. | |||
| TMP_AMT_APPLIED7 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 7. Uses transaction currency. | |||
| TMP_AMT_APPLIED8 | NUMBER | Oracle internal use only. Temporary amount applied: transaction 8. Uses transaction currency. | |||
| CPG_PURCHASE_ORDER_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CPG_CUSTOMER_REF_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CPG_SHIP_TO_LOCATION_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CPG_TRANSACTION_DATE | DATE | Oracle internal use only. | |||
| CPG_PROCESS_STATUS | VARCHAR2 | 1 | Oracle internal use only. | ||
| CPG_RECEIPT_STATUS | VARCHAR2 | 15 | Oracle internal use only. | ||
| CPG_BATCH_DATE | DATE | Oracle internal use only. | |||
| CPG_BATCH_STATUS | VARCHAR2 | 15 | Oracle internal use only. | ||
| CPG_BATCH_SOURCE | NUMBER | Oracle internal use only. | |||
| CPG_ORIGINAL_TRX_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CPG_RECEIPT_COUNT | NUMBER | Oracle internal use only. | |||
| CPG_RECEIPT_AMOUNT | NUMBER | Oracle internal use only. | |||
| CPG_ORIG_REMITTANCE_AMOUNT | NUMBER | Oracle internal use only. | |||
| CPG_NEGATIVE_TRX_INDICATOR | VARCHAR2 | 1 | Oracle internal use only. | ||
| CPG_REASSOCIATION_TRACE_NUM | VARCHAR2 | 30 | Oracle internal use only. | ||
| CPG_ASSOCIATION_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| CPG_TRX_HANDLING_CODE | VARCHAR2 | 1 | Oracle internal use only. | ||
| CPG_CUST_DEDUCTION_REASON_CODE | VARCHAR2 | 2 | Oracle internal use only. | ||
| CPG_ORIG_BATCH_NAME | VARCHAR2 | 25 | Oracle internal use only. | ||
| CPG_ORIG_LOCKBOX_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CPG_BATCH_SEQUENCE_NUMBER | NUMBER | Oracle internal use only. | |||
| CPG_POSTMARK_DATE | DATE | Oracle internal use only. | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE1 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE2 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE3 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE4 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE5 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE6 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE7 | VARCHAR2 | 30 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE8 | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLICATION_NOTES | VARCHAR2 | 2000 | Oracle internal use only. Reference number that could not be matched to transaction number during lockbox validation. | ||
| CUSTOMER_REFERENCE1 | VARCHAR2 | 100 | Customer reference information: transaction 1. | ||
| CUSTOMER_REFERENCE2 | VARCHAR2 | 100 | Customer reference information: transaction 2. | ||
| CUSTOMER_REFERENCE3 | VARCHAR2 | 100 | Customer reference information: transaction 3. | ||
| CUSTOMER_REFERENCE4 | VARCHAR2 | 100 | Customer reference information: transaction 4. | ||
| CUSTOMER_REFERENCE5 | VARCHAR2 | 100 | Customer reference information: transaction 5. | ||
| CUSTOMER_REFERENCE6 | VARCHAR2 | 100 | Customer reference information: transaction 6. | ||
| CUSTOMER_REFERENCE7 | VARCHAR2 | 100 | Customer reference information: transaction 7. | ||
| CUSTOMER_REFERENCE8 | VARCHAR2 | 100 | Customer reference information: transaction 8. | ||
| CUSTOMER_REASON1 | VARCHAR2 | 30 | Customized matching rules: transaction 1. | ||
| CUSTOMER_REASON2 | VARCHAR2 | 30 | Customized matching rules: transaction 2. | ||
| CUSTOMER_REASON3 | VARCHAR2 | 30 | Customized matching rules: transaction 3. | ||
| CUSTOMER_REASON4 | VARCHAR2 | 30 | Customized matching rules: transaction 4. | ||
| CUSTOMER_REASON5 | VARCHAR2 | 30 | Customized matching rules: transaction 5. | ||
| CUSTOMER_REASON6 | VARCHAR2 | 30 | Customized matching rules: transaction 6. | ||
| CUSTOMER_REASON7 | VARCHAR2 | 30 | Customized matching rules: transaction 7. | ||
| CUSTOMER_REASON8 | VARCHAR2 | 30 | Customized matching rules: transaction 8. | ||
| SOURCE_TYPE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Source type indicator. | ||
| SC_MATCHING_STATUS | VARCHAR2 | 30 | Oracle internal use only. Lookup code for smart cash matching status. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| AUTOAPPLY_FLAG | VARCHAR2 | 1 | Oracle internal use only. Autoapply process indicator. Valid values: Y, N. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| STRUCTURED_PAYMENT_REFERENCE | VARCHAR2 | 256 | An industry standard reference on receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction, transaction lines, and its payments to the customer and bank. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_PAYMENTS_INTERFACE_ALL | hz_cust_accounts | CUSTOMER_ID |
| AR_PAYMENTS_INTERFACE_ALL | ar_transmissions_all | TRANSMISSION_ID |
| AR_PAYMENTS_INTERFACE_ALL | ar_receipt_methods | RECEIPT_METHOD_ID |
| AR_PAYMENTS_INTERFACE_ALL | hz_cust_site_uses_all | CUSTOMER_SITE_USE_ID |
| AR_PAYMENTS_INTERFACE_ALL | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| AR_PAYMENTS_INTERFACE_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AR_PAYMENTS_INTERFACE_ALL | ar_transmissions_all | TRANSMISSION_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_PAYMENTS_INTERFACE_N1 | Non Unique | Default | RECORD_TYPE |
| AR_PAYMENTS_INTERFACE_N2 | Non Unique | Default | ITEM_NUMBER, OVERFLOW_SEQUENCE |
| AR_PAYMENTS_INTERFACE_N3 | Non Unique | Default | CHECK_NUMBER, CUSTOMER_ID |
| AR_PAYMENTS_INTERFACE_N4 | Non Unique | Default | TRANSIT_ROUTING_NUMBER, ACCOUNT |
| AR_PAYMENTS_INTERFACE_N5 | Non Unique | Default | TRANSMISSION_ID, STATUS, RECORD_TYPE |
| AR_PAYMENTS_INTERFACE_N6 | Non Unique | Default | TRANSMISSION_ID, BATCH_NAME, RECORD_TYPE |
| AR_PAYMENTS_INTERFACE_N7 | Non Unique | Default | TRANSMISSION_ID, RECORD_TYPE, ITEM_NUMBER |
| AR_PAYMENTS_INTERFACE_N8 | Non Unique | Default | CHECK_NUMBER, REMITTANCE_AMOUNT, TRANSMISSION_ID |