Customer Credit Rule Maintenance Database Information

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

Fields

Field	Field Name/Table
Customer Code	credit-customer-key in customer-ar
Credit Group	credit-group-key in customer-ar
Dun & Bradstreet Number	db-code in customer-ar
Credit Division	credit-div-key in customer-ar
Display Currency	currency in glconst
Default Rules	credit-dflt in customer-ar

Key Rules Tab Fields

Field	Field Name/Table
Minimum Credit Score	credit-min-score in customer-ar ,ar-credit-div and ar-credit-group Note The date in the New Effective Date field is stored in effective-date in ar-credit-change for the specific credit-customer-key.
Credit Limit	credit-limit in customer-ar ,ar-credit-div and ar-credit-group Note The date in the New Effective Date field is stored in effective-date in ar-credit-change for the specific credit-customer-key.
Credit Limit Overage %	credit-limit-overage-pct in customer-ar ,ar-credit-div and ar-credit-group Note The date in the New Effective Date field is stored in effective-date in ar-credit-change for the specific credit-customer-key.
Credit Insurance	credit-insurance-amt in customer-ar ,ar-credit-div and ar-credit-group Note The date in the New Effective Date field is stored in effective-date in ar-credit-change for the specific credit-customer-key.
Actual Credit Score	credit--score in customer-ar ,ar-credit-div and ar-credit-group Note The date in the New Effective Date field is stored in effective-date in ar-credit-change for the specific credit-customer-key.
Credit Check Update Limit	credit-ck-upd-limit in customer-ar ,ar-credit-div and ar-credit-group
Credit Check Backorders	credit-ck-bo in customer-ar ,ar-credit-div and ar-credit-group
Credit Check Backorder Days	credit-ck-bo-days in customer-ar ,ar-credit-div and ar-credit-group

Payment Terms Tab Fields

Field	Field Name/Table
Standard Payment Terms	terms-code in ar-credit-change for the specific credit-customer-key
Credit Memo Override Payment Terms	cm--terms-code in ar-credit-change for the specific credit-customer-key
Approved for Finance Payment Terms	ft-approved in custname

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 customer-ar ,ar-credit-div and ar-credit-group
Credit Check Option	credit-check-option in customer-ar ,ar-credit-div and ar-credit-group
Future Credit Check Days	credit-future-order-days in customer-ar ,ar-credit-div and ar-credit-group
Inactive Customers Hold	hold-inactive in customer-ar ,ar-credit-div and ar-credit-group
Days Since Last Invoice	hold-inactive-days in customer-ar ,ar-credit-div and ar-credit-group
Order Class Hold	hold-order-class in customer-ar ,ar-credit-div and ar-credit-group
Order Class	credit-order-class in customer-ar ,ar-credit-div and ar-credit-group
Order Class Threshold Amount	credit-order-class-thres-amt in customer-ar ,ar-credit-div and ar-credit-group
Non-Default Payment Terms Hold	hold-default-terms in customer-ar ,ar-credit-div and ar-credit-group
Credit Score Hold	hold-credit-score in customer-ar ,ar-credit-div and ar-credit-group
NSF Payment Hold	hold-nsf in customer-ar ,ar-credit-div and ar-credit-group
Days Since Last NSF Payment	credit-days-nsf in customer-ar ,ar-credit-div and ar-credit-group

Credit Past Due Tab Fields

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

Credit Limit Tab Fields

Field	Field Name/Table
Credit Limit Hold	hold-credit-limit in customer-ar ,ar-credit-div and ar-credit-group
Include Disputed Invoices	credit-incl-limit-di in customer-ar ,ar-credit-div and ar-credit-group
Include Chargebacks	credit-incl-limit-cb in customer-ar ,ar-credit-div and ar-credit-group

Credit Alert Tab Fields

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

Credit Dates Tab Fields

Field	Field Name/Table
Next Credit Review Date	credit-review-date in customer-ar
Next Financial Statement Review Date	credit-financial-date in customer-ar
User Date Fields 1-5	credit-date-1 [thru 5] and credit-date-1-label [thru 5] in customer-ar
Last Invoice Date	last-inv-date in customer-ar