More information

Importing Vendors

The following table defines the field references to be used in the Vendor Information section of the MasterAP.DEF file:

Table: tblAPVendor
Context Section: CONTEXT,VENDOR,HEADER,HVEND
Field ID	Req'd	Field Length	Default Value	Notes
VENDOR_ID	Y	User Defined		Vendor ID
VENDOR_STATUS	Y	1	A	A (Active), I (Inactive), or D (Discontinued)
VENDOR_NAME	Y	User Defined		Vendor Name
VENDOR_ CURRENCYTYPE	N	3		Active or Inactive Currency code. If no currency is being imported, remove this field from the DEF file.
VENDOR_ FORCECURTYPE	N	1	0	Always Pay in Vendor's Currency. 0 = No; 1 = Yes
VENDOR_USERID_GUID	N	See Notes for format.		The system user ID that is associated with the vendor ID. A blank GUID format: {00000000-0000-0000-0000-000000000000}
VENDOR_CLASS	N	User Defined		Optional Class Designation
VENDOR_TYPE	N	User Defined		Optional Type Designation
VENDOR_ADDRESS	Y*	80		Vendor Main Address. Use "^" to separate address lines. *Required if VENDOR_MISC1099 is Yes.
VENDOR_CITY	Y*	30		Main Address City. *Required if VENDOR_MISC1099 is Yes.
VENDOR_STATE	Y*	6		Main Address State or Province. Required if VENDOR_MISC1099 is Yes.
VENDOR_ZIP	Y*	10		Main Address Postal Code. Required if VENDOR_MISC1099 is Yes.
VENDOR_COUNTRY	N	35		Main Address Country
VENDOR_PHONE	N	25		Main Address Phone
VENDOR_FAX	N	25		Main Address Fax
VENDOR_FIRSTNAME	N	30		Main Address Contact First Name
VENDOR_MIDDLENAME	N	1		Main Address Contact Middle Initial
VENDOR_LASTNAME	N	30		Main Address Contact Last Name
VENDOR_TITLE	N	10		Main Address Contact Title
VENDOR_POSITION	N	30		Main Address Contact Job Position
VENDOR_EMAIL	N	50		Main Contact Email Address
VENDOR_ HOLDPAYMENTS	N	2	0	Hold payments? 0 = No; 1 = Yes
VENDOR_ PRINTSEPCHECK	N	2	0	Print separate checks for each invoice? 0 = No; 1 = Yes
VENDOR_ CHECKSTUBCOMMENT	N	30		Check Stub Comments
VENDOR_DISCOUNT1	N	50	00.0000	Enter 5% as 05 or 5.
VENDOR_ DAYSAVAILABLE1	N	Integer	0	Days Available for 1st Discount
VENDOR_DISCOUNT2	N	50	00.0000	Enter 5% as 05 or 5.
VENDOR_ DAYSAVAILABLE2	N	Integer	0	Days Available for 2nd Discount
VENDOR_NETDUEDAYS	N	Integer	30	Days until net amount due
VENDOR_GLCODE	N	User Defined		Default GL (Expense) Account
VENDOR_DISTCODE	N	User Defined		Default Distribution Code
VENDOR_MISC1099	N	1	0	Issue 1099 for this Vendor? 0 = No; 1 = Yes
VENDOR_FOREIGNIND	N	1	0	Foreign Address Indicator? 0 = No; 1 = Yes
VENDOR_PROPNAME	N*	30		Proprietor Name. *Required if VENDOR_TAXIDTYPE is S.
VENDOR_TAXIDTYPE	N	1	A	F = FEIN; S = SSN; X = Foreign; A = Applied For; or none. Required if VENDOR_MISC1099 is Yes.
VENDOR_TAXID	Y*	11		*Required if VENDOR_MISC1099 is Yes and VENDOR_TAXIDTYPE is S or F. Format: xxx-xx-xxxx for SSN xx-xxxxxxx for FEIN
VENDOR_ STATETAXWITHHELD	N	1		State Withholding Collected? 0 = No; 1 = Yes
VENDOR_1099STATE	N*	2		State Abbreviation. *Required if VENDOR_STATETAXWITHHELD is Yes.
VENDOR_STATETAXID	N*	11		State Tax ID. *Required if VENDOR_STATETAXWITHHELD is Yes. xxx-xx-xxxx for SSN
VENDOR_ 1099TYPEDEFAULT	N	4		Default Form Type
VENDOR_ MISC1099BOXNUM	N	8	N/A	Default Box Number. See Table 2.
VENDOR_ NAMECONTROL	N	4		Electronic Filing Name Control. If the currency is USD and the Issue 1099 for this Vendor check box is selected, this field is required.
VENDOR_NOTES	N			Notes
VENDOR_POSAMEAS	N	Integer	Main	None = 0, Main = 1, or Check = 3
VENDOR_POADDRESS	N	80		Purchase Order Address. Use "^" to separate address lines.
VENDOR_POCITY	N	30		Purchase Order Address City
VENDOR_POSTATE	N	6		Purchase Order Address State or Province
VENDOR_POZIP	N	10		Purchase Order Address Postal Code
VENDOR_POCOUNTRY	N	35		Purchase Order Address Country
VENDOR_POPHONE	N	25		Purchase Order Address Phone
VENDOR_POFAX	N	25		Purchase Order Address Fax
VENDOR_POFIRSTNAME	N	30		Purchase Order Address Contact First Name
VENDOR_POMIDDLENAME	N	1		Purchase Order Address Contact Middle Initial
VENDOR_POLASTNAME	N	30		Purchase Order Address Contact Last Name
VENDOR_POTITLE	N	10		Purchase Order Address Contact Title
VENDOR_POPOSITION	N	30		Purchase Order Address Contact Job Position
VENDOR_POEMAIL	N	50		Purchase Order Contact Email Address
VENDOR_ACCOUNT	N	30		Account Number assigned by vendor.
VENDOR_EPAYMENTS	N	2		Activate Electronic Payments? 0 = No; 1 = Yes
VENDOR_ROUTINGNUM	Y	9		Vendor's 9 digit Bank Routing Number. Required if VENDOR_ EPAYMENTS is Yes.
VENDOR_ACCOUNTNUM	Y	17		Vendor's Checking or Loan bank account number. Required if VENDOR_ EPAYMENTS is Yes.
VENDOR_ACCOUNTTYPE	Y	2	22	Electronic Payment Type: 22 for Checking and 52 for Loan. Required if VENDOR_ EPAYMENTS = Yes and if EFT for A/P is installed.
VENDOR_PRENOTE	Y	2		Send Prenote for this vendor? No or Yes. Case Sensitive. Required if VENDOR_ EPAYMENTS is Yes.
VENDOR_PERSONALACCT	N	1	0	0 = No; 1 = Yes
VENDOR_EFTEMAIL	Y	50		Vendor Email Address to send the payment notification. Required if VENDOR_ NOEMAIL is not selected.
VENDOR_NOEMAIL	N	2		Do not send payment notification email? 0 = No; 1 = Yes. Therefore if "1" is selected, no notification will be sent.Not available if VENDOR_ EPAYMENTS = No.