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 |