Credit Change History Inquiry Database Information

Click here to see this page in full context

Credit Change History Inquiry Database Information

Data for Credit Change History Inquiry is stored in multiple tables.

Select Tab Fields

Field	Field Name/Table
Credit Customer Code/Credit Group ID/Credit Division ID	credit-customer-key, credit-group-key or credit-div-key in ar-credit-change
Customer Code	cust-key in ar-credit-change
From	effective-date in ar-credit-change
To	effective-date in ar-credit-change
Min Cr. Score	credit-change-type in ar-credit-change
Act Cr. Score	credit-change-type in ar-credit-change
Cr. Insurance	credit-change-type in ar-credit-change
Credit Limit	credit-change-type in ar-credit-change
Overage	credit-change-type in ar-credit-change
Terms	credit-change-type in ar-credit-change
CM Terms	credit-change-type in ar-credit-change
Override	credit-change-source in ar-credit-change
Credit Group	credit-change-source in ar-credit-change
Credit Division	credit-change-source in ar-credit-change

Results Tab Fields

Field

Field Name/Table

Results

This grid includes the following columns:

Type - credit-change-type in ar-credit-change
Value - credit-change-amount or terms-code in ar-credit-change
Effective Date - effective-date in ar-credit-change
Source - credit-change-source in ar-credit-change
Created By - created-by in ar-credit-change
Created Date - created-date in ar-credit-change
Updated Time - update-time in ar-credit-change
Updated Date - update-date in ar-credit-change