AR_AUTOMATCH_TRX_T
This table stores the processing data for the Automatch Process
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_AUTOMATCH_TRX_PK |
REQUEST_ID, PAYMENT_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Yes | Payment Schedule Identifier | |
| CUSTOMER_ID | NUMBER | 18 | Customer Identifier | ||
| CUSTOMER_NUMBER | VARCHAR2 | 30 | Customer Number | ||
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Customer Site Use Identifier | ||
| TRX_NUMBER | VARCHAR2 | 30 | Transaction Number | ||
| TRX_DATE | DATE | Transaction Date | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 20 | Currency code of the transaction | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | Transaction Identifier | ||
| AMOUNT_DUE_REMAINING | NUMBER | Amount remaining in the payment schedule | |||
| AMOUNT_LINE_ITEMS_REMAINING | NUMBER | Line amount balance on the invoice | |||
| FREIGHT_REMAINING | NUMBER | Freight amount remaining on the transaction | |||
| TAX_REMAINING | NUMBER | Tax amount remaining on the transaction | |||
| RECEIVABLES_CHARGES_REMAINING | NUMBER | Charges remaining on the invoice balance | |||
| ACTUAL_DATE_CLOSED | DATE | Date on which the payment schedule is closed | |||
| CONS_INV_ID | NUMBER | 18 | Balance Forward Bill Identifier | ||
| DISCOUNT_GRACE_DAYS | NUMBER | Grace days to get discount after the eligible date | |||
| CALC_DISCOUNT_ON_LINES_FLAG | VARCHAR2 | 1 | Discount basis depending on the term of the invoice | ||
| PARTIAL_DISCOUNT_FLAG | VARCHAR2 | 1 | Flag to decide whether or not to give discount on partial payment | ||
| TERM_ID | NUMBER | 18 | Payment Term Identifier | ||
| TERMS_SEQUENCE_NUMBER | NUMBER | 18 | Installment number on the payment schedule. | ||
| AMOUNT_DUE_ORIGINAL | NUMBER | Amount due on the invoice before any application | |||
| DISCOUNT_TAKEN_EARNED | NUMBER | Earned Discount taken already on the invoice | |||
| DISCOUNT_TAKEN_UNEARNED | NUMBER | Unearned Discount taken already on the invoice | |||
| AMOUNT_LINE_ITEMS_ORIGINAL | NUMBER | Amount due on the line items of invoice before any application | |||
| AMOUNT_IN_DISPUTE | NUMBER | Amount in dispute | |||
| RULE_SET_ID | NUMBER | 18 | Application rule set identifier | ||
| MATCHING_OPTION_1 | VARCHAR2 | 30 | Matching Option at Customer Site | ||
| AUTOMATCH_RULE_ID_1 | NUMBER | 18 | Automatch Rule Identifier at Customer Site | ||
| TRANSACTION_REGEXP_1 | VARCHAR2 | 1000 | Regular Expression to unpadded Transaction String for the auto match rule on Customer Site Profile | ||
| REMITTANCE_REGEXP_1 | VARCHAR2 | 1000 | Regular Expression to unpadded Remittance String for the auto match rule on Customer Site Profile | ||
| MIN_MATCH_THRESHOLD_1 | NUMBER | Minimum matching threshold for automatch rule on Customer Site Profile | |||
| NUMBER_OF_DAYS_CLOSED_1 | NUMBER | Number of closed days for automatch rule on Customer Site Profile | |||
| TRANSACTION_WEIGHT_1 | NUMBER | Transaction weight defined on the AutoMatch rule associated to customer site profile. | |||
| CUSTOMER_WEIGHT_1 | NUMBER | Customer weight defined on the AutoMatch rule associated to customer site profile. | |||
| AMOUNT_WEIGHT_1 | NUMBER | Amount weight defined on the AutoMatch rule associated to customer site profile. | |||
| NET_TAX_WEIGHT_1 | NUMBER | Net of tax amount weight defined on the AutoMatch rule associated to customer site profile. | |||
| NET_FREIGHT_WEIGHT_1 | NUMBER | Net of freight amount weight defined on the AutoMatch rule associated to customer site profile. | |||
| NET_TAX_FREIGHT_WEIGHT_1 | NUMBER | Net of tax and freight amount weight defined on the AutoMatch rule associated to customer site profile. | |||
| NET_UNDISC_WEIGHT_1 | NUMBER | Net of unearned discount amount weight defined on the AutoMatch rule associated to customer site profile. | |||
| MATCHING_OPTION_2 | VARCHAR2 | 30 | Matching Option at Customer Account | ||
| AUTOMATCH_RULE_ID_2 | NUMBER | 18 | Automatch Rule Identifier at Customer Account | ||
| TRANSACTION_REGEXP_2 | VARCHAR2 | 1000 | Regular Expression to unpadded Transaction String for the auto match rule on Customer Account Profile | ||
| REMITTANCE_REGEXP_2 | VARCHAR2 | 1000 | Regular Expression to unpadded Remittance String for the auto match rule on Customer Account Profile | ||
| MIN_MATCH_THRESHOLD_2 | NUMBER | Minimum matching threshold for automatch rule on Customer Account Profile | |||
| NUMBER_OF_DAYS_CLOSED_2 | NUMBER | Number of closed days for automatch rule on Customer Account Profile | |||
| TRANSACTION_WEIGHT_2 | NUMBER | Transaction weight defined on the AutoMatch rule associated to customer account profile. | |||
| CUSTOMER_WEIGHT_2 | NUMBER | Customer weight defined on the AutoMatch rule associated to customer account profile. | |||
| AMOUNT_WEIGHT_2 | NUMBER | Customer weight defined on the AutoMatch rule associated to customer account profile. | |||
| NET_TAX_WEIGHT_2 | NUMBER | Net of tax amount weight defined on the AutoMatch rule associated to customer account profile. | |||
| NET_FREIGHT_WEIGHT_2 | NUMBER | Net of freight amount weight defined on the AutoMatch rule associated to customer account profile. | |||
| NET_TAX_FREIGHT_WEIGHT_2 | NUMBER | Net of tax and freight amount weight defined on the AutoMatch rule associated to customer account profile. | |||
| NET_UNDISC_WEIGHT_2 | NUMBER | Net of unearned discount amount weight defined on the AutoMatch rule associated to customer account profile. | |||
| MATCHING_OPTION_3 | VARCHAR2 | 30 | Matching Option at Lockbox | ||
| AUTOMATCH_RULE_ID_3 | NUMBER | 18 | Automatch Rule Identifier at Lockbox | ||
| TRANSACTION_REGEXP_3 | VARCHAR2 | 1000 | Regular Expression to unpadded Transaction String for the auto match rule on Lockbox | ||
| REMITTANCE_REGEXP_3 | VARCHAR2 | 1000 | Regular Expression to unpadded Remittance String for the auto match rule on Lockbox | ||
| MIN_MATCH_THRESHOLD_3 | NUMBER | Minimum matching threshold for automatch rule on Lockbox | |||
| NUMBER_OF_DAYS_CLOSED_3 | NUMBER | Number of closed days for automatch rule on Lockbox | |||
| TRANSACTION_WEIGHT_3 | NUMBER | Transaction weight defined on the AutoMatch rule associated to lockbox setup. | |||
| CUSTOMER_WEIGHT_3 | NUMBER | Customer weight defined on the AutoMatch rule associated to lockbox setup. | |||
| AMOUNT_WEIGHT_3 | NUMBER | Amount weight defined on the AutoMatch rule associated to lockbox setup. | |||
| NET_TAX_WEIGHT_3 | NUMBER | Net of tax amount weight defined on the AutoMatch rule associated to lockbox setup. | |||
| NET_FREIGHT_WEIGHT_3 | NUMBER | Net of freight amount weight defined on the AutoMatch rule associated to lockbox setup. | |||
| NET_TAX_FREIGHT_WEIGHT_3 | NUMBER | Net of tax and freight amount weight defined on the AutoMatch rule associated to lockbox setup. | |||
| NET_UNDISC_WEIGHT_3 | NUMBER | Net of unearned discount amount weight defined on the AutoMatch rule associated to lockbox setup. | |||
| MATCHING_OPTION_4 | VARCHAR2 | 30 | Matching Option at Business Unit Option 1 | ||
| AUTOMATCH_RULE_ID_4 | NUMBER | 18 | Automatch Rule Identifier at Business Unit | ||
| TRANSACTION_REGEXP_4 | VARCHAR2 | 1000 | Regular Expression to unpadded Transaction String for the auto match rule on Business Unit | ||
| REMITTANCE_REGEXP_4 | VARCHAR2 | 1000 | Regular Expression to unpadded Remittance String for the auto match rule on Business Unit | ||
| MIN_MATCH_THRESHOLD_4 | NUMBER | Minimum matching threshold for automatch rule on Business Unit | |||
| NUMBER_OF_DAYS_CLOSED_4 | NUMBER | Number of closed days for automatch rule on Business Unit | |||
| TRANSACTION_WEIGHT_4 | NUMBER | Transaction weight defined on the AutoMatch rule associated to business unit setup. | |||
| CUSTOMER_WEIGHT_4 | NUMBER | Customer weight defined on the AutoMatch rule associated to business unit setup. | |||
| AMOUNT_WEIGHT_4 | NUMBER | Amount weight defined on the AutoMatch rule associated to business unit setup. | |||
| NET_TAX_WEIGHT_4 | NUMBER | Net of tax amount weight defined on the AutoMatch rule associated to business unit setup. | |||
| NET_FREIGHT_WEIGHT_4 | NUMBER | Net of freight amount weight defined on the AutoMatch rule associated to business unit setup. | |||
| NET_TAX_FREIGHT_WEIGHT_4 | NUMBER | Net of tax and freight amount weight defined on the AutoMatch rule associated to business unit setup. | |||
| NET_UNDISC_WEIGHT_4 | NUMBER | Net of unearned discount amount weight defined on the AutoMatch rule associated to business unit setup. | |||
| MATCHING_OPTION_5 | VARCHAR2 | 30 | Matching Option at Business Unit Option 2 | ||
| MATCHING_OPTION_6 | VARCHAR2 | 30 | Matching Option at Business Unit Option 3 | ||
| MATCHING_OPTION_7 | VARCHAR2 | 30 | Matching Option at Business Unit Option 4 | ||
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| USE_MATCHING_DATE | VARCHAR2 | 20 | Determine whether to use date for matching in lockbox |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_AUTOMATCH_TRX_T | ar_cons_inv_all | CONS_INV_ID |
| AR_AUTOMATCH_TRX_T | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| AR_AUTOMATCH_TRX_T | ar_automatch_rules | AUTOMATCH_RULE_ID_1 |
| AR_AUTOMATCH_TRX_T | ar_automatch_rules | AUTOMATCH_RULE_ID_2 |
| AR_AUTOMATCH_TRX_T | ar_automatch_rules | AUTOMATCH_RULE_ID_3 |
| AR_AUTOMATCH_TRX_T | ar_automatch_rules | AUTOMATCH_RULE_ID_4 |
| AR_AUTOMATCH_TRX_T | hz_cust_accounts | CUSTOMER_ID |
| AR_AUTOMATCH_TRX_T | hz_cust_site_uses_all | CUSTOMER_SITE_USE_ID |
| AR_AUTOMATCH_TRX_T | ra_customer_trx_all | CUSTOMER_TRX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_AUTOMATCH_TRX_U1 | Unique | Default | REQUEST_ID, PAYMENT_SCHEDULE_ID |