Process
The Auto Credit Info Process is designed to run separately in each company on a regular schedule, configured here. This article describes what occurs in that single process run. All process parameters can be reviewed here.
1a) Ftp Ingest (Optional)
The system checks a configurable folder in an ftp/sftp for files.
If files are found they are downloaded to a local file folder and deleted from the ftp.
1b) Email Ingest (Optional)
The system checks a configurable email inbox for unseen emails containing attachments.
If attachments are found they are downloaded to a local file folder.
All emails in the inbox are then marked as seen.
2a) Company Specific File Processing (Optional)
Each company that uses file ingest has a different file format.
The system validates that the file and data are in the expected format
And transforms them into a generic class used for data validation and ingest.
2b) Company Specific Web API Processing (Optional)
The system cycles through every active customer and queries the agency's Web API for credit info.
It then transforms them into a generic class used for data validation.
3) Generic Data Validation and Transformation
The system performs a collection of error checks on the provided data.
On a basic level it is confirming that the data contains is associated with a valid customer and contains a valid credit score and/or credit limit.
The credit limit is also converted to GBP using the active exchange rate if required.
All errors are sent as a separate email report seen, an example can be seen below.
4a) Generic Credit Info Report
The system uses the ingested data to produce a company wide credit report. This aims to provide a snapshot of the ingested data and anything that requires user action.
It contains a table list of:
Over recommended credit customers - updated today
Over recommended credit customers
Updated Inactive Customers
Credit Decreased Customers
Credit Increased Customers
Updated But Unchanged Customers
Active But Idle Customers
Customers will not appear in this report if they have the no report attribute enabled.
4b) Generic Customer Credit Record Update
The system updates the credit info for all customers that have passed validation.
The fields updated are:
Customer.Date01 = Date of credit info
Customer.ShortChar08 = External credit score
Customer.Number01 = Converted external credit limit
Customer.Number02 = External credit limit
Customers with the stop update attribute will not be updated.
The updated fields are highlighted below in the customer credit manager, but these changes can also be reviewed here.