Group Credit Rule Maintenance Database Information

Data for Group Credit Rule Maintenance is stored in multiple tables.

Fields

Field	Field Name/Table
Display Currency	currency in glconst
Credit Group ID/Credit Division ID	credit-group-code in ar-credit-group; credit-div-code in ar-credit-div
Name	credit-group-name in ar-credit-group; credit-div-name in ar-credit-div
Sequence	credit -group-seq in ar-credit-group; credit-div-seq in ar-credit-div

Key Rules Tab Fields

Field	Field Name/Table
Credit Check Update Limit	credit-ck-upd-limit in ar-credit-div or ar-credit-group
Credit Check Backorders	credit-ck-bo in ar-credit-div or ar-credit-group
Credit Check Backorder Days	credit-ck-bo-days in ar-credit-div or ar-credit-group
Credit Insurance Amounts	credit-insurance-amt in ar-credit-div or ar-credit-group

Payment Terms Tab Fields

Field	Field Name/Table
Standard Payment Terms	terms-code in ar-credit-div or ar-credit-group
Credit Memo Payment Terms	cm-terms-code in ar-credit-div or ar-credit-group
Approved for Finance Payment Terms	ft-approved in ar-credit-div or ar-credit-group

Credit Aging Tab Fields

Field	Field Name/Table
Past Due Days	credit-past-due-days in ar-credit-days
Credit Priority	credit-past-due-days-priority in ar-credit-days
Credit Aging	This grid includes the following columns: Past Due Bucket # - sort-order in ar-credit-days Past Due Days - credit-past-due-days in ar-credit-days Past Due Aging Label - credit-past-due-days-label in ar-credit-days Priority - credit-past-due-days-priority in ar-credit-days

Credit Options Tab Fields

Field	Field Name/Table
Allowed to Place Orders	credit-can-place-order in ar-credit-div or ar-credit-group
Credit Check Option	credit-check-option in ar-credit-div or ar-credit-group
Future Credit Check Days	credit-future-order-days in ar-credit-div or ar-credit-group
Credit Score Hold	hold-credit-score in ar-credit-div or ar-credit-group
Minimum Credit Score	credit-min-score in ar-credit-div or ar-credit-group
Inactive Customers Hold	hold-inactive in ar-credit-div or ar-credit-group
Days Since Last Invoice	hold-inactive-days in ar-credit-div or ar-credit-group
NSF Payment Hold	hold-nsf in ar-credit-div or ar-credit-group
Days Since Last NSF Payment	credit-days-nsf in ar-credit-div or ar-credit-group
Order Class Hold	hold-order-class in ar-credit-div or ar-credit-group
Order Class	credit-order-class in ar-credit-div or ar-credit-group
Order Class Threshold Amount	credit-order-class-thres-amt in ar-credit-div or ar-credit-group
Non-Default Payment Terms Hold	hold-default-terms in ar-credit-div or ar-credit-group

Credit Past Due Tab Fields

Field	Field Name/Table
Past Due Hold	hold-past-due in ar-credit-div or ar-credit-group
Grace Days	credit-grace-days in ar-credit-div or ar-credit-group
Minimum Past Due Balance	credit-min-amt in ar-credit-div or ar-credit-group
Minimum Past Due Percentage	credit-min-pct in ar-credit-div or ar-credit-group
Include Finance Charges	credit-incl-past-due-fc in ar-credit-div or ar-credit-group
Include Disputed Invoices	credit-incl-past-due-di in ar-credit-div or ar-credit-group
Include Chargebacks	credit-incl-past-due-cb in ar-credit-div or ar-credit-group
Offset Unapplied Payments	credit-offset-up in ar-credit-div or ar-credit-group
Offset On-Accounts	credit-offset-oa in ar-credit-div or ar-credit-group
Offset Credit Memos	credit-offset-cm in ar-credit-div or ar-credit-group
Collection Team Past Due Credit Release Option for Group	credit-allow-coll-team in ar-credit-div or ar-credit-group

Credit Limit Tab Fields

Field	Field Name/Table
Credit Limit Hold	hold-credit-limit in ar-credit-div or ar-credit-group
Credit Limit Amount	credit-limit in ar-credit-div or ar-credit-group
Credit Limit Overage %	credit-limit-overage-pct in ar-credit-div or ar-credit-group
Include Disputed Invoices	credit-incl-limit-di in ar-credit-div or ar-credit-group
Include Chargebacks	credit-incl-limit-cb in ar-credit-div or ar-credit-group

Credit Alert Tab Fields

Field	Field Name/Table
Use Credit Alerts	use-credit-alerts in ar-credit-div or ar-credit-group
Comparison Months	credit-comp-periods in ar-credit-div or ar-credit-group
Average Days to Pay (Low Trigger Amount)	credit-adtp-low-amt in ar-credit-div or ar-credit-group
Average Days to Pay (High Trigger Amount)	credit-adtp-high-amt in ar-credit-div or ar-credit-group
Average Days to Pay (Trend Lower %)	credit-adtp-trend-low-pct in ar-credit-div or ar-credit-group
Average Days to Pay (Trend Higher %)	credit-adtp-trend-high-pct in ar-credit-div or ar-credit-group
Weighted Average Days to Pay (Low Trigger Amount)	credit-wadtp-low-amt in ar-credit-div or ar-credit-group
Weighted Average Days to Pay (High Trigger Amount)	credit-wadtp-high-amt in ar-credit-div or ar-credit-group
Weighted Average Days to Pay (Trend Lower %)	credit-wadtp-trend-low-pct in ar-credit-div or ar-credit-group
Weighted Average Days to Pay (Trend Higher %)	credit-wadtp-trend-high-pct in ar-credit-div or ar-credit-group
Average Days Past Due (Low Trigger Amount)	credit-adpd-low-amt in ar-credit-div or ar-credit-group
Average Days Past Due (High Trigger Amount)	credit-adpd-high-amt in ar-credit-div or ar-credit-group
Average Days Past Due (Trend Lower %)	credit-adpd-trend-low-pct in ar-credit-div or ar-credit-group
Average Days Past Due (Trend Higher %)	credit-adpd-trend-high-pct in ar-credit-div or ar-credit-group
Weighted Average Days Past Due (Low Trigger Amount)	credit-wadpd-low-amt in ar-credit-div or ar-credit-group
Weighted Average Days Past Due (High Trigger Amount)	credit-wadpd-high-amt in ar-credit-div or ar-credit-group
Weighted Average Days Past Due (Trend Lower %)	credit-wadpd-trend-low-pct in ar-credit-div or ar-credit-group
Weighted Average Days Past Due (Trend Higher %)	credit-wadpd-trend-high-pct in ar-credit-div or ar-credit-group
Days Sales Outstanding (Low Trigger Amount)	credit-dso-low-amt in ar-credit-div or ar-credit-group
Days Sales Outstanding (High Trigger Amount)	credit-dso-high-amt in ar-credit-div or ar-credit-group
Days Sales Outstanding (Trend Lower %)	credit-dso-trend-low-pct in ar-credit-div or ar-credit-group
Days Sales Outstanding (Trend Higher %)	credit-dso-trend-high-pct in ar-credit-div or ar-credit-group