Data for Group Collection Rule Maintenance is stored in multiple tables.
|
Field |
Field Name/Table |
|
Display Currency |
currency in glconst |
|
Collection Group ID/Collection Division ID |
collect-group-code in ar-collect-group; collect-div-code in ar-collect-div |
|
Name |
collect-group-name in ar-collect-group; collect-div-name in ar-collect-div |
|
Sequence |
collect-group-seq in ar-collect-group; collect-div-seq in ar-collect-div |
|
Field |
Field Name/Table |
|
Refresh Collection Tasks |
collect-refresh-tasks in ar-collect-group and ar-collect-div |
|
Past Due Grace Days |
collect-past-due-days in ar-collect-group and ar-collect-div |
|
Minimum Past Due Balance |
collect-min-past-due-bal in ar-collect-group and ar-collect-div |
|
Minimum Past Due Percentage |
collect-min-past-due-pct in ar-collect-group and ar-collect-div |
|
Due Date Reminder |
collect-reminder-task in ar-collect-group and ar-collect-div |
|
Reminder Minimum Amount |
collect-reminder-amt in ar-collect-group and ar-collect-div |
|
Reminder Lead Days |
collect-reminder-num-days in ar-collect-group and ar-collect-div |
|
Reminder Priority |
collect-reminder-priority in ar-collect-group and ar-collect-div |
|
Field |
Field Name/Table |
|
Offset Unapplied Payments |
collect-offset-up in ar-collect-group and ar-collect-div |
|
Offset Credit Memos |
collect-offset-cm in ar-collect-group and ar-collect-div |
|
Offset On-Accounts |
collect-offset-oa in ar-collect-group and ar-collect-div |
|
Include Debit Memos |
collect-incl-dm in ar-collect-group and ar-collect-div |
|
Include Finance Charges |
collect-incl-fc in ar-collect-group and ar-collect-div |
|
Include Chargebacks |
collect-incl-cb in ar-collect-group and ar-collect-div |
|
Include Disputed Invoices |
collect-incl-di in ar-collect-group and ar-collect-div |
|
Include C.O.D. Invoices |
collect-incl-cod in ar-collect-group and ar-collect-div |
|
Field |
Field Name/Table |
|
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:
|