CREATE TABLE ar_automatch_trx_t (
    PAYMENT_SCHEDULE_ID              NUMBER(18, 0) ,
    CUSTOMER_ID                      NUMBER(18, 0) ,
    CUSTOMER_NUMBER                  VARCHAR2(120) ,
    CUSTOMER_SITE_USE_ID             NUMBER(18, 0) ,
    TRX_NUMBER                       VARCHAR2(120) ,
    TRX_DATE                         DATE          ,
    INVOICE_CURRENCY_CODE            VARCHAR2(80)  ,
    CUSTOMER_TRX_ID                  NUMBER(18, 0) ,
    AMOUNT_DUE_REMAINING             NUMBER        ,
    AMOUNT_LINE_ITEMS_REMAINING      NUMBER        ,
    FREIGHT_REMAINING                NUMBER        ,
    TAX_REMAINING                    NUMBER        ,
    RECEIVABLES_CHARGES_REMAINING    NUMBER        ,
    ACTUAL_DATE_CLOSED               DATE          ,
    CONS_INV_ID                      NUMBER(18, 0) ,
    DISCOUNT_GRACE_DAYS              NUMBER        ,
    CALC_DISCOUNT_ON_LINES_FLAG      VARCHAR2(4)   ,
    PARTIAL_DISCOUNT_FLAG            VARCHAR2(4)   ,
    TERM_ID                          NUMBER(18, 0) ,
    TERMS_SEQUENCE_NUMBER            NUMBER(18, 0) ,
    AMOUNT_DUE_ORIGINAL              NUMBER        ,
    DISCOUNT_TAKEN_EARNED            NUMBER        ,
    DISCOUNT_TAKEN_UNEARNED          NUMBER        ,
    AMOUNT_LINE_ITEMS_ORIGINAL       NUMBER        ,
    AMOUNT_IN_DISPUTE                NUMBER        ,
    RULE_SET_ID                      NUMBER(18, 0) ,
    MATCHING_OPTION_1                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_1              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_1             VARCHAR2(4000),
    REMITTANCE_REGEXP_1              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_1            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_1          NUMBER        ,
    TRANSACTION_WEIGHT_1             NUMBER        ,
    CUSTOMER_WEIGHT_1                NUMBER        ,
    AMOUNT_WEIGHT_1                  NUMBER        ,
    NET_TAX_WEIGHT_1                 NUMBER        ,
    NET_FREIGHT_WEIGHT_1             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_1         NUMBER        ,
    NET_UNDISC_WEIGHT_1              NUMBER        ,
    MATCHING_OPTION_2                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_2              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_2             VARCHAR2(4000),
    REMITTANCE_REGEXP_2              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_2            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_2          NUMBER        ,
    TRANSACTION_WEIGHT_2             NUMBER        ,
    CUSTOMER_WEIGHT_2                NUMBER        ,
    AMOUNT_WEIGHT_2                  NUMBER        ,
    NET_TAX_WEIGHT_2                 NUMBER        ,
    NET_FREIGHT_WEIGHT_2             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_2         NUMBER        ,
    NET_UNDISC_WEIGHT_2              NUMBER        ,
    MATCHING_OPTION_3                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_3              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_3             VARCHAR2(4000),
    REMITTANCE_REGEXP_3              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_3            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_3          NUMBER        ,
    TRANSACTION_WEIGHT_3             NUMBER        ,
    CUSTOMER_WEIGHT_3                NUMBER        ,
    AMOUNT_WEIGHT_3                  NUMBER        ,
    NET_TAX_WEIGHT_3                 NUMBER        ,
    NET_FREIGHT_WEIGHT_3             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_3         NUMBER        ,
    NET_UNDISC_WEIGHT_3              NUMBER        ,
    MATCHING_OPTION_4                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_4              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_4             VARCHAR2(4000),
    REMITTANCE_REGEXP_4              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_4            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_4          NUMBER        ,
    TRANSACTION_WEIGHT_4             NUMBER        ,
    CUSTOMER_WEIGHT_4                NUMBER        ,
    AMOUNT_WEIGHT_4                  NUMBER        ,
    NET_TAX_WEIGHT_4                 NUMBER        ,
    NET_FREIGHT_WEIGHT_4             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_4         NUMBER        ,
    NET_UNDISC_WEIGHT_4              NUMBER        ,
    MATCHING_OPTION_5                VARCHAR2(120) ,
    MATCHING_OPTION_6                VARCHAR2(120) ,
    MATCHING_OPTION_7                VARCHAR2(120) ,
    REQUEST_ID                       NUMBER(18, 0) ,
    USE_MATCHING_DATE                VARCHAR2(80)  ,
    PAYMENT_SCHEDULE_ID              NUMBER(18, 0) ,
    CUSTOMER_ID                      NUMBER(18, 0) ,
    CUSTOMER_NUMBER                  VARCHAR2(120) ,
    CUSTOMER_SITE_USE_ID             NUMBER(18, 0) ,
    TRX_NUMBER                       VARCHAR2(120) ,
    TRX_DATE                         DATE          ,
    INVOICE_CURRENCY_CODE            VARCHAR2(80)  ,
    CUSTOMER_TRX_ID                  NUMBER(18, 0) ,
    AMOUNT_DUE_REMAINING             NUMBER        ,
    AMOUNT_LINE_ITEMS_REMAINING      NUMBER        ,
    FREIGHT_REMAINING                NUMBER        ,
    TAX_REMAINING                    NUMBER        ,
    RECEIVABLES_CHARGES_REMAINING    NUMBER        ,
    ACTUAL_DATE_CLOSED               DATE          ,
    CONS_INV_ID                      NUMBER(18, 0) ,
    DISCOUNT_GRACE_DAYS              NUMBER        ,
    CALC_DISCOUNT_ON_LINES_FLAG      VARCHAR2(4)   ,
    PARTIAL_DISCOUNT_FLAG            VARCHAR2(4)   ,
    TERM_ID                          NUMBER(18, 0) ,
    TERMS_SEQUENCE_NUMBER            NUMBER(18, 0) ,
    AMOUNT_DUE_ORIGINAL              NUMBER        ,
    DISCOUNT_TAKEN_EARNED            NUMBER        ,
    DISCOUNT_TAKEN_UNEARNED          NUMBER        ,
    AMOUNT_LINE_ITEMS_ORIGINAL       NUMBER        ,
    AMOUNT_IN_DISPUTE                NUMBER        ,
    RULE_SET_ID                      NUMBER(18, 0) ,
    MATCHING_OPTION_1                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_1              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_1             VARCHAR2(4000),
    REMITTANCE_REGEXP_1              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_1            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_1          NUMBER        ,
    TRANSACTION_WEIGHT_1             NUMBER        ,
    CUSTOMER_WEIGHT_1                NUMBER        ,
    AMOUNT_WEIGHT_1                  NUMBER        ,
    NET_TAX_WEIGHT_1                 NUMBER        ,
    NET_FREIGHT_WEIGHT_1             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_1         NUMBER        ,
    NET_UNDISC_WEIGHT_1              NUMBER        ,
    MATCHING_OPTION_2                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_2              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_2             VARCHAR2(4000),
    REMITTANCE_REGEXP_2              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_2            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_2          NUMBER        ,
    TRANSACTION_WEIGHT_2             NUMBER        ,
    CUSTOMER_WEIGHT_2                NUMBER        ,
    AMOUNT_WEIGHT_2                  NUMBER        ,
    NET_TAX_WEIGHT_2                 NUMBER        ,
    NET_FREIGHT_WEIGHT_2             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_2         NUMBER        ,
    NET_UNDISC_WEIGHT_2              NUMBER        ,
    MATCHING_OPTION_3                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_3              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_3             VARCHAR2(4000),
    REMITTANCE_REGEXP_3              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_3            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_3          NUMBER        ,
    TRANSACTION_WEIGHT_3             NUMBER        ,
    CUSTOMER_WEIGHT_3                NUMBER        ,
    AMOUNT_WEIGHT_3                  NUMBER        ,
    NET_TAX_WEIGHT_3                 NUMBER        ,
    NET_FREIGHT_WEIGHT_3             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_3         NUMBER        ,
    NET_UNDISC_WEIGHT_3              NUMBER        ,
    MATCHING_OPTION_4                VARCHAR2(120) ,
    AUTOMATCH_RULE_ID_4              NUMBER(18, 0) ,
    TRANSACTION_REGEXP_4             VARCHAR2(4000),
    REMITTANCE_REGEXP_4              VARCHAR2(4000),
    MIN_MATCH_THRESHOLD_4            NUMBER        ,
    NUMBER_OF_DAYS_CLOSED_4          NUMBER        ,
    TRANSACTION_WEIGHT_4             NUMBER        ,
    CUSTOMER_WEIGHT_4                NUMBER        ,
    AMOUNT_WEIGHT_4                  NUMBER        ,
    NET_TAX_WEIGHT_4                 NUMBER        ,
    NET_FREIGHT_WEIGHT_4             NUMBER        ,
    NET_TAX_FREIGHT_WEIGHT_4         NUMBER        ,
    NET_UNDISC_WEIGHT_4              NUMBER        ,
    MATCHING_OPTION_5                VARCHAR2(120) ,
    MATCHING_OPTION_6                VARCHAR2(120) ,
    MATCHING_OPTION_7                VARCHAR2(120) ,
    REQUEST_ID                       NUMBER(18, 0) ,
    USE_MATCHING_DATE                VARCHAR2(80)  ,
    CONSTRAINT pk_ar_automatch_trx_t PRIMARY KEY (PAYMENT_SCHEDULE_ID, REQUEST_ID, PAYMENT_SCHEDULE_ID, REQUEST_ID)
);
