Customer Payment Rule Maintenance Database Information

Data for Customer Payment Rule Maintenance is stored in multiple tables.

Fields

Field

Field Name/Table

Customer Code

billing-customer-key in custname

Chargeback Group

chrgbck-group-key in customer-ar

Chargeback Division

chrgbck-div-key in customer-ar

Default Rules

chrgbck-dflt in customer-ar

Display Currency

currency in glconst

Payments Tab Fields

Field

Field Name/Table

Payment Discount Grace Days

cb-pay-disc-grace-days in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Payment Discount Tolerance %

cb-pay-disc-tolerance-per in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Payment Discount Tolerance Amount

cb-pay-disc-tolerance-amt in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Reference Payment Absorption Tolerance %

cb-refer-pay-absorb-per in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Ref Payment Absorption Tolerance Amount

cb-refer-pay-absorb-amt in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Payment Maximum Absorption Amount

absorption-max-amt in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Available Algorithms

payment-algorithms-eligible in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Chargebacks Tab Fields

Field

Field Name/Table

Automatic Chargeback for Ineligible Discounts

cb-inelig-disc in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Auto Chargeback Minimum Threshold Amount

cb-inelig-pay-disc-min in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Chargeback Absorption Tolerance %

cb-absorb-per in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Chargeback Absorption Tolerance Amount

cb-absorb-amount in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Default Chargeback Date to Payment Date

cb-dflt-date in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Default Chargeback Due Days

cb-dflt-due-days in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Chargeback Default # of Expiration Days

cb-dflt-exp-days in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Chargeback Default Status Code

chrgbck-status-key in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

Chargeback Default Reason Code

chrgbck-reason-key in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

NSF Payments Tab Field Name/Table

Field

Description

NSF Payment Charge %

cb-nsf-per in customer-ar, ar-chrgbck-group, and ar-chrgbck-div

NSF Payment Minimum Charge Amount

cb-nsf-amt in customer-ar, ar-chrgbck-group, and ar-chrgbck-div