Customer Collection Rule Maintenance Database Information

Customer Code

cust-key in customer-ar

Collection Group

collect-group-key in customer-ar

Collection Division

collect-div-key in customer-ar

Collection Statement Group

collect-statement-key in customer-ar

Collection Letter Group

collect-letter-key in customer-ar

Collection Agency

collect-agency-key in customer-ar

Finance Charge Group

finance-charge-key in customer-ar

Display Currency

currency in glconst

Default

collect-dflt in customer-ar

Refresh Collection Tasks

collect-refresh-tasks in customer-ar, ar-collect-group, and ar-collect-div

Past Due Grace Days

collect-past-due-days in customer-ar, ar-collect-group, and ar-collect-div

Minimum Past Due Balance

collect-min-past-due-bal in customer-ar, ar-collect-group, and ar-collect-div

Minimum Past Due Percentage

collect-min-past-due-pct in customer-ar, ar-collect-group, and ar-collect-div

Due Date Reminder

collect-reminder-task in customer-ar, ar-collect-group, and ar-collect-div

Reminder Minimum Amount

collect-reminder-amt in customer-ar, ar-collect-group, and ar-collect-div

Reminder Lead Days

collect-reminder-num-days in customer-ar, ar-collect-group, and ar-collect-div

Reminder Priority

collect-reminder-priority in customer-ar, ar-collect-group, and ar-collect-div

Offset Unapplied Payments

collect-offset-up in customer-ar, ar-collect-group, and ar-collect-div

Offset Credit Memos

collect-offset-cm in customer-ar, ar-collect-group, and ar-collect-div

Offset On-Accounts

collect-offset-oa in customer-ar, ar-collect-group, and ar-collect-div

Include Debit Memos

collect-incl-dm in customer-ar, ar-collect-group, and ar-collect-div

Include Finance Charges

collect-incl-fc in customer-ar, ar-collect-group, and ar-collect-div

Include Chargebacks

collect-incl-cb in customer-ar, ar-collect-group, and ar-collect-div

Include Disputed Invoices

collect-incl-di in customer-ar, ar-collect-group, and ar-collect-div

Include C.O.D. Invoices

collect-incl-cod in customer-ar, ar-collect-group, and ar-collect-div

Past Due Days

collect-past-due-days in ar-collect-days

Priority

collect-past-due-days-priority in ar-collect-days

Collection Aging

This grid includes the following columns:

• Past Due Bucket # - sort-order in ar-collect-days

• Past Due Days - collect-past-due-days in ar-collect-days

• Past Due Aging Label - collect-past-due-days-label in ar-collect-days

• Priority - collect-past-due-days-priority in ar-collect-days

Statement Option

collect-statement-options in customer-ar and ar-collect-statement-group

Minimum Balance

collect-statement-min-amt in customer-ar and ar-collect-statement-group

Statement Type

collect-statement-type in customer-ar and ar-collect-statement-group

Balance Forward Frequency

collect-statement-freq in customer-ar and ar-collect-statement-group

Balance Forward # of Weeks

collect-statement-bf-weeks in customer-ar and ar-collect-statement-group

Aging Basis

collect-statement-aging in customer-ar and ar-collect-statement-group

Sorting

collect-statement-sort in customer-ar and ar-collect-statement-group

Exclude Credit Memos - Days Prior

collect-statement-excl-cm-days in customer-ar and ar-collect-statement-group

Offset Unapplied Payments

collect-statement-offset-up in customer-ar and ar-collect-statement-group

Offset Credit Memos

collect-statement-offset-cm in customer-ar and ar-collect-statement-group

Offset On-Accounts

collect-statement-offset-oa in customer-ar and ar-collect-statement-group

Include Chargebacks

collect-statement-incl-cb in customer-ar and ar-collect-statement-group

Include Disputed Invoices

collect-statement-incl-di in customer-ar and ar-collect-statement-group

Include C.O.D. Invoices

collect-statement-incl-cod in customer-ar and ar-collect-statement-group

Eligible to Get a Collection Letter

collect-letter-eligible in customer-ar and ar-collect-letter-group

Past Due Balance

collect-letter-balance in customer-ar and ar-collect-letter-group

Collection Letter Report

collect-letter-rpt in customer-ar and ar-collect-letter-group

Past Due Grace Days

collect-letter-grace-days in customer-ar and ar-collect-letter-group

Display Options

collect-letter-options in customer-ar and ar-collect-letter-group

Offset Unapplied Payments

collect-letter-offset-up in customer-ar and ar-collect-letter-group

Offset Credit Memos

collect-letter-offset-cm in customer-ar and ar-collect-letter-group

Offset On-Accounts

collect-letter-offset-oa in customer-ar and ar-collect-letter-group

Include Chargebacks

collect-letter-incl-cb in customer-ar and ar-collect-letter-group

Include Disputed Invoices

collect-letter-incl-di in customer-ar and ar-collect-letter-group

Include C.O.D. Invoices

collect-letter-incl-cod in customer-ar and ar-collect-letter-group

Gets Finance Charge

finance-charge-options in customer-ar and ar-finance-charge

Print Finance Charge Invoices

finance-charge-print in customer-ar and ar-finance-charge

Minimum Finance Charge Amount

finance-charge-min-amt in customer-ar and ar-finance-charge

Annual Finance Charge %

finance-charge-pct in customer-ar and ar-finance-charge

Finance Charge Grace Days

finance-charge-grace-days in customer-ar and ar-finance-charge}

Use Date-Specific Or Average Daily Calculation

finance-charge-type in customer-ar and ar-finance-charge

Finance Charge Payment Terms

finance-charge-terms-key in customer-ar and ar-finance-charge

Offset Unapplied Payments

finance-charge-offset-up in customer-ar and ar-finance-charge

Offset Credit Memos

finance-charge-offset-cm in customer-ar and ar-finance-charge

Offset On-Accounts

finance-charge-offset-oa in customer-ar and ar-finance-charge

Include Debit Memos

finance-charge-incl-cb in customer-dm and ar-finance-charge

Include Finance Charges

finance-charge-incl-fc in customer-dm and ar-finance-charge

Include Chargebacks

finance-charge-incl-cb in customer-ar and ar-finance-charge

Include Disputed Invoices

finance-charge-incl-di in customer-ar and ar-finance-charge

Include C.O.D. Invoices

finance-charge-incl-cod in customer-ar and ar-finance-charge