Export Vendor Information
Previous  Top  Next

tkflex0012
This program exports the information contained in the vendor file for other applications to use.

By using the "Sort By" options the order of the transactions can be controlled.

By using the "Export File Type" options the type of file created by the export is selected.

By using the "Restrictions" section the report can be limited to transactions that meet fall into the specified parameters. Leaving each field blank will allow the report to print all of the transactions. Restrict the report by entering a starting and/or an ending value.

Preview?Indicate whether or not to display the report to the screen before printing.  
 
PrintPrint the report. A progress bar will display below the print button as the report is being prepared to print.  

The information exported is as follows:

Field Name
Data Type
Size
Description
V_CODE
Alphanumeric
10
Vendor's Code
V_NAME
Alphanumeric
45
Vendor's name.
V_ADDRESS1
Alphanumeric
30
Vendor's first address line.
V_ADDRESS2
Alphanumeric
30
Vendor's last address line.
V_CITY
Alphanumeric
25
Vendor's city.
V_STATE
Alphanumeric
2
Vendor's state.
V_ZIPCODE
Alphanumeric
10
Vendor's zip code.
V_COUNTRY
Alphanumeric
25
Vendor's country.
V_VENDACCT
Alphanumeric
20
Account number with Vendor.
V_BILLTO
Alphanumeric
10
Bill to vendor code.
V-PRT1099
Alphanumeric
1
Y/N - Print 1099's
V_TEMPORARY
Alphanumeric
1
Y/N - Temporary Vendor
V_PRIVACY
Alphanumeric
1
Y/N - Keep information private.
V_EMAIL
Alphanumeric
40
Vendor's Email address.
V_URL
Alphanumeric
40
Vendor's URL/Website.
V_FEDID
Alphanumeric
15
Vendor's Federal Tax ID.
V_STATEID
Alphanumeric
15
Vendor's State Tax ID.
V_CREATED
Date (YYYYMMDD)
8
Date Vendor record was created.
V_UPDATED
Date (YYYYMMDD)
8
Date Vendor record was last updated.
V_PURCH
Date (YYYYMMDD)
8
Date of last purchase.
V_PAYMENT
Date (YYYYMMDD)
8
Date of last payment.
V_TERMS
Integer (###)
3
Terms Indicator.
V_DISCOUNT
Numeric (####.##)
7
Default Discount
V_GLACCT
Alphanumeric
10
A/P G/L account code.
V_COSTCENT
Alphanumeric
5
Default cost center.