Lyon Mercantile Group Ltd. Receivable File Specifications

Credit Info

Receivable File Specifications

Content

Please note that each bullet indicates information that must be in a separate field.

General Account Information:

Account Number
Name
Address
City
State / Province
ZIP Code / Postal Code
Telephone Number

Accounts Receivable Information:

Preferred fields (Please include the last 12 months' history on each account if available):

High Credit
Amount Owing
Amount Past Due
Days Slow (Averaging of this field is acceptable)
Terms
Last Activity Date

Aging information is acceptable in lieu of the above fields:

0-30 days slow
31-60 days slow
61-90 days slow
[et cetera]

Acceptable File Formats

Microsoft Excel
Delimited
Fixed-width

With your first file, you must submit a layout indicating the position of your fields. If your file is tab-delimited, a simple list will suffice; if your file is fixed width, please use the following table as an example:

Position	Category
1-7	Customer Number
8-38	Customer Name
39-50	Customer Telephone Number

(et cetera)

Send Your File To:

mis@lyoncredit.com