ABC-Amega Inc
ABC-Amega Inc

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