Extracting Customer/Vendor Details in Peachtree format
Reference : 22372 A9HC184835
(V 02.00.03-00)
Details
Note : With effect from version 02.00.03-00, the existing feature Update Records present in the Invoicing module, which is used for extracting Customer/ Vendor and Equipment Details will be renamed as Extract Customer/Vendor Equipment Details.
In Cr2, while extracting Customer/Vendor Details in Peach Tree format using Invoicing Module - Extract Customer/Vendor Equipment Details feature, system will generate the export file Vendor.CSV in addition to the export file Customer.CSV file which is generated.
Refer Table 1.0 for the list of fields present in Vendor.CSV
Table 1.0 Vendor.CSV field reference Table
Field Position | Field |
1 | Customer ID |
2 | Customer Name |
3 | Contact Name |
4 | Billing Address Line 1 |
5 | Billing Address Line 2 |
6 | Billing City |
7 | Billing State |
8 | Billing Zip |
9 | Billing Country |
10 | Shipping Allocation Desc |
11 | Shipping Address Line 1 |
12 | Shipping Address Line 2 |
13 | Ship City |
14 | Ship State |
15 | Ship Zip |
16 | Ship Country |
17 | Member Group ID |
18 | Contact Phone |
19 | Mobile Phone |
20 | Contact Fax Number |
21 | Contact Email ID |
22 | Customer Web Address |
23 | Sales Person ID |
24 | Customer Tax Cert. No. |
25 | Customer Credit Limit |
26 | Customer Join Date |
27 | Contact First Name |
28 | Contact Last Name |