|
A/R Submission Layout
ABC-Amega Inc. can accept A/R files in a variety of
formats. File processing is most efficient with our recommended A/R
layout. Even if you cannot use this layout, please refer to it for
descriptions of the required fields. We can also accept files in the
following formats:
-
Files already sent to other credit-reporting
agencies
-
Plain text files
-
Excel
Spreadsheet Files
-
XML
Files
-
Aging reports with addresses, saved as text
-
Separate aging and address reports, saved as text
-
Text files delimited with commas, tabs, or pipes
-
DBF data files
Please check with us for any format not shown. Files should be sent monthly through our SFTP web portal at https://sftp.abc-amega.com/ThinClient. We also have a write-only SFTP site
for A/R file transfer. Please contact us by email at [email protected] for SFTP site details.
|
Field
|
Required
|
Data Type
|
Max Size
|
Position on Member's Feed
|
|
Your Acct #
|
Highly Suggested
|
Alphanumeric
|
20
|
|
|
Customer Name
|
Yes
|
Alphanumeric
|
40
|
|
|
DBA Name
|
|
Alphanumeric
|
40
|
|
|
Contact Name
|
|
Alphanumeric
|
40
|
|
|
Address 1
|
Yes
|
Alphanumeric
|
40
|
|
|
Address 2
|
|
Alphanumeric
|
40
|
|
|
City
|
Yes
|
Alphanumeric
|
40
|
|
|
State/Province
|
Yes
|
Alphanumeric
|
2
|
|
|
Country
|
Recommended
|
Alphanumeric
|
6
|
|
|
Zip/Postal Code
|
Yes
|
Alphanumeric
|
14
|
|
|
Phone
|
Yes
|
Alphanumeric
|
24
|
|
|
Fax
|
|
Alphanumeric
|
20
|
|
|
Tax ID
|
|
Alphanumeric
|
16
|
|
|
E-mail Address
|
|
Alphanumeric
|
50
|
|
|
URL (www)
|
|
Alphanumeric
|
50
|
|
|
First Sale Date
|
Highly suggested
|
YYYYMMDD
|
8
|
|
|
Last Sale Date
|
Highly suggested
|
YYYYMMDD
|
8
|
|
|
Average Days Slow (Beyond terms)
|
Highly suggested
|
Numeric
|
4
|
|
|
High Balance in the last 6-12 Months or Highest
Recent Credit
|
Highly suggested
|
Numeric
|
10
|
|
|
Current (Not Past Due)
|
Yes
|
Numeric
|
10
|
|
|
Past Due 1 - 30
|
Yes
|
Numeric
|
10
|
|
|
Past Due 31 - 60
|
Yes
|
Numeric
|
10
|
|
|
Past Due 61 - 90
|
Yes
|
Numeric
|
10
|
|
|
Past Due Over 90 Days
|
Yes
|
Numeric
|
10
|
|
| Color |
Description |
| Yellow |
Required to submit an AR File with basic information and usually available in
many Aging Reports. It is important to note that the AR Data exchange in the
credit group is desired to be based on Due Date. If your aging is only
available by Invoice Date we would suggest you adjust the aging based on the
average number of days the terms are for that customer.
|
| Blue |
Very Highly Suggested and usually can be obtained by working with your
Technology Team.
|
| Green |
May take a little more research but is intended to help other credit people in
the group understand, on average how the customer traditionally pays in regards
to the agreed upon terms.
|
** Please be sure that your file either contains header rows or
a separate file is included defining your file layout
|
