Accounts Receivable ARDBEXPS Help - Elliott Business Software

Export D&B Customer File

The program exports your A/R Customer File to a Text file for submission to Dunn & Bradstreet.

A/R Main Menu Ò Util-Setup Ò Export D&B File

Run Date: Oct 30, 2001 - 11:22pm Elliott Demonstration Company Page 1

EXPORTED DB CUSTOMER FILE LAYOUT (DBCUST.TXT)

Field Name Length Position Comment

DB-CUST-CUSTOMER-NO 20 1 - 20 1ST 6 DIGITS, ALPHA NUMERICAL

DB-CUST-CUSTOMER-NAME 25 21 - 45 ALPHA NUMERICAL

DB-CUST-CUSTOMER-ADDRESS-1 25 46 - 70 ALPHA NUMERICAL

DB-CUST-CUSTOMER-ADDRESS-2 25 71 - 95 ALPHA NUMERICAL

DB-CUST-CUSTOMER-ADDRESS-3 25 96 - 120 CITY, STATE ZIPCODE

DB-CUST-CUSTOMER-ADDRESS-4 25 121 - 145 COUNTRY

DB-CUST-TELEPHONE-NUMBER 16 146 - 161 1ST 12 DIGITS, ALPHA NUMERICAL

DB-CUST-TERMS-DESCRIPTION 13 162 - 174 MACOLA'S LENGTH IS 15 DIGITS

DB-CUST-PAYMENT-EXPERIENCE 13 175 - 187 CUSTOMER-NOTE-5

DB-CUST-DAYS-SLOW 3 188 - 190 AVG-DAYS-PAY-YTD - TERMS

DB-CUST-DATE-OF-LAST-INVOICE 8 191 - 198 YYMMDD

DB-CUST-HIGH-CREDIT-DATE 8 199 - 206 BLANK, NOT AVAILABLE IN MACOLA

DB-CUST-AVERAGE-DAYS-TO-PAY 4 207 - 210 AVG-DAYS-PAY-YTD

DB-CUST-HIGH-CREDIT 10 211 - 220 NUMERICAL, NO DECIMAL

DB-CUST-AGING-CATEGORY-1 10 221 - 230 Current NO DECIMAL

DB-CUST-AGING-CATEGORY-2 10 231 - 240 31-60 Days NO DECIMAL

DB-CUST-AGING-CATEGORY-3 10 241 - 250 61-90 Days NO DECIMAL

DB-CUST-AGING-CATEGORY-4 10 251 - 260 Over 90 Days NO DECIMAL

DB-CUST-AGING-CATEGORY-5 10 261 - 270 ZEROS, NOT AVAILABLE IN MACOLA

DB-CUST-AGING-CATEGORY-6 10 271 - 280 ZEROS, NOT AVAILABLE IN MACOLA

This file is in LINE SEQUENTIAL ASCII format

Record Length: 280

Total Export Count: 22

Exported Layout Format