EITS Simple Logo

Financial Information Systems

a division of Enterprise Information Technology Services

Mrs. Sharon Burch, Interim Director
(706) 542-5305

Query Table - QUERY.AP_VENDOR

Column Name Definition
VENDOR_NUMBER Accounts Payable ("Pay To") Vendor Identification Number
VENDOR_ADDRESS Code used to identify a particular "pay to" address for the vendor
VENDOR_NAME Date on which the Accounting Period begins - approximately the beginning of the month
  Format:  MM/DD/YYYY
BEGIN_DATE Date on which the Vendor/Address became active
  Format:  MM/DD/YYYY
END_DATE Date on which the Vendor/Address became inactive - not used
  Format:  MM/DD/YYYY
VENDOR_STATUS Code used to indicate whether the vendor is "active" or "inactive"
VENDOR_STATUS_DESC Description of the vendor status
ADDRESS_LINE1 First line of address
ADDRESS_LINE2 Second line of address
ADDRESS_LINE3 Third line of address
ADDRESS_LINE4 Fourth line of address
ADDRESS_LINE5 Fifth line of address
ZIP_CODE Postal Zip Code (5 char)
ZIP_PLUS4_EXT Postal Zip Code Extension (4 char)


Access Services            Enterprise Information Technology Services            The University of Georgia