Data for Customer Payment Rule Maintenance is stored in multiple tables.
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 |
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 |
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 |
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 |