Accounts Receivable ARDBEXPS Help - Elliott Business Software



Export D&B Customer File

Export D&B Customer File

 

 

Application Overview

 

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

 

 

Run Instructions

 

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



Elliott Business Software
| Add-ons | Services
3rd Party Solutions | News & Events
Technical Support | Company Profile