ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.			NA	NA
ADDRESS_TYPE_DESC	Address type description.			NA	NA
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
BUILDING	Building code when there is a building in the vendor address.			NA	NA
CAMPUS	Campus of the vendor.			NA	NA
CAMPUS_DESC	Vendor campus description.			NA	NA
CARRIER_ROUTE	Address carrier route.			NA	NA
CITY	Address city, town or municipality.			NA	NA
CONTACT_NAME	Name or title of the primary contact for the vendor.			FTVVEND	FTVVEND_CONTACT
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.			NA	NA
COUNTY	County for this address.			NA	NA
COUNTY_DESC	County name for the address.			STVCNTY	STVCNTY_DESC
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.			NA	NA
ENTITY_TYPE	Indicates whether this is person or entity record.			SPRIDEN	SPRIDEN_ENTITY_IND
FEDERAL_REPORTABLE_TAX_IND	Indicates vendor as reportable for federal tax purposes.			CALCULATION	DECODE(FTVVEND_1099_RPT_ID)
FLOOR	Floor number specific to the shipping address.			NA	NA
ID	Entity's identification number used to access the records associated with the entity.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
MOST_RECENT_TAX_ID_NOTICE_YEAR	Year the most recent tax identification number notice was received.			NA	NA
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the vendor.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
NATION	Nation/country code associated with the address.			NA	NA
NATION_DESC	Address nation/country description.			NA	NA
NUMBER_OF_TAX_ID_NOTICES	Number of tax identification number notices the vendor has received.			NA	NA
ORDER_FROM_ADDRESS_TYPE	Address type of the order from address for the vendor.			FTVVEND	FTVVEND_ATYP_CODE
ORDER_FROM_ADDRESS_TYPE_DESC	Vendor address type description.			FUNCTION	GOKODSF.F_GET_DESC
ORDER_FROM_BUILDING	Building associated with the address.			NA	NA
ORDER_FROM_CARRIER_ROUTE	Carrier route associated with the address for barcode mailings.			SPRADDR	SPRADDR_CARRIER_ROUTE
ORDER_FROM_CITY	City associated with the address.			SPRADDR	SPRADDR_CITY
ORDER_FROM_CORRECTION_DIGIT	Correction digit associated with the address for barcode mailings.			SPRADDR	SPRADDR_CORRECTION_DIGIT
ORDER_FROM_COUNTY	County associated with the address.			SPRADDR	SPRADDR_CNTY_CODE
ORDER_FROM_COUNTY_DESC	County associated with the county code.			FUNCTION	GOKODSF.F_GET_DESC
ORDER_FROM_DELIVERY_POINT	Delivery point associated with the address for barcode mailings.			SPRADDR	SPRADDR_DELIVERY_POINT
ORDER_FROM_EMAIL_ADDRESS	Preferred email address of the person.			GOREMAL	GOREMAL_EMAIL_ADDRESS
ORDER_FROM_EMAIL_TYPE	Type of email associated with the person's preferred email.			GOREMAL	GOREMAL_EMAL_CODE
ORDER_FROM_EMAIL_TYPE_DESC	Email type description.			GTVEMAL	GTVEMAL_DESC
ORDER_FROM_FAX_NUMBER	Fax number associated with the order from address.			NA	NA
ORDER_FROM_FLOOR	Floor associated with the order from address.			NA	NA
ORDER_FROM_NATION	Nation code associated with the order from address.			SPRADDR	SPRADDR_NATN_CODE
ORDER_FROM_NATION_DESC	Order from address nation/country description.			STVNATN	STVNATN_NATION
ORDER_FROM_PHONE_COMBINED	Extracted order from combined phone number for the vendor.			CALCULATION	SPRTELE_INTL_ACCESS || SPRTELE_PHONE_AREA || SPRTELE_PHONE_NUMBER || SPRTELE_PHONE_EXT
ORDER_FROM_PHONE_TYPE	Order from type of telephone code such as home phone, emergency contact.			SPRTELE	SPRTELE_TELE_CODE
ORDER_FROM_PHONE_TYPE_DESC	Order from telephone type description.			STVTELE	STVTELE_DESC
ORDER_FROM_PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.			SPRTELE	SPRTELE_UNLIST_IND
ORDER_FROM_POSTAL_CODE	Address postal code.			SPRADDR	SPRADDR_ZIP
ORDER_FROM_STATE_PROVINCE	State/Province code of the address.			SPRADDR	SPRADDR_STAT_CODE
ORDER_FROM_STATE_PROVINCE_DESC	Order from state/province description.			STVSTAT	STVSTAT_DESC
ORDER_FROM_STREET_LINE1	First line of the address.			SPRADDR	SPRADDR_STREET_LINE1
ORDER_FROM_STREET_LINE2	Second line of the address.			SPRADDR	SPRADDR_STREET_LINE2
ORDER_FROM_STREET_LINE3	Third line of the address.			SPRADDR	SPRADDR_STREET_LINE3
ORDER_FROM_STREET_LINE4	Fourth line of the address.			SPRADDR	SPRADDR_STREET_LINE4
PHONE_AREA	Phone area code for the vendor.			FTVVEND	FTVVEND_PHONE_AREA
PHONE_EXT	Phone extension for the vendor.			FTVVEND	FTVVEND_PHONE_EXT
PHONE_NUMBER	Phone number for the vendor.			FTVVEND	FTVVEND_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Extracted combined phone number for the vendor.			CALCULATION	FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER||FTVVEND_PHONE_EXT
POSTAL_CODE	Postal code associated with the vendor address.			NA	NA
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
REMIT_TO_ADDRESS_TYPE	Identifies the type of address that the payment for the invoice is to be sent.			FTVVEND	FTVVEND_VEND_CHECK_ATYP_CODE
REMIT_TO_ADDRESS_TYPE_DESC	Remit to vendor's address type description.			FUNCTION	GOKODSF.F_GET_DESC
REMIT_TO_BUILDING	Building of the remit to vendor address.			NA	NA
REMIT_TO_CARRIER_ROUTE	Carrier route associated with the address for barcode mailings.			SPRADDR	SPRADDR_CARRIER_ROUTE
REMIT_TO_CITY	City associated with the address.			SPRADDR	SPRADDR_CITY
REMIT_TO_CORRECTION_DIGIT	Correction digit associated with the address for barcode mailings.			SPRADDR	SPRADDR_CORRECTION_DIGIT
REMIT_TO_COUNTY	County associated with the address.			SPRADDR	SPRADDR_CNTY_CODE
REMIT_TO_COUNTY_DESC	County associated with the county code.			FUNCTION	GOKODSF.F_GET_DESC
REMIT_TO_DELIVERY_POINT	Delivery point associated with the address for barcode mailings.			SPRADDR	SPRADDR_DELIVERY_POINT
REMIT_TO_EMAIL_ADDRESS	Preferred email address of the person.			GOREMAL	GOREMAL_EMAIL_ADDRESS
REMIT_TO_EMAIL_TYPE	Type of email associated with the person's preferred email.			GOREMAL	GOREMAL_EMAL_CODE
REMIT_TO_EMAIL_TYPE_DESC	Email address type description.			GTVEMAL	GTVEMAL_DESC
REMIT_TO_FAX_NUMBER	Fax number associated with the remit to address.			NA	NA
REMIT_TO_FLOOR	Floor associated with the remit to address.			NA	NA
REMIT_TO_NATION	Nation code associated with the remit to address.			SPRADDR	SPRADDR_NATN_CODE
REMIT_TO_NATION_DESC	Remit to nation's nation/country description.			STVNATN	STVNATN_NATION
REMIT_TO_PHONE_NUMBER_COMBINED	Extracted remit to combined phone number for the vendor.			CALCULATION	SPRTELE_INTL_ACCESS || SPRTELE_PHONE_AREA || SPRTELE_PHONE_NUMBER || SPRTELE_PHONE_EXT
REMIT_TO_PHONE_TYPE	Remit to type of telephone code such as home phone, emergency contact.			SPRTELE	SPRTELE_TELE_CODE
REMIT_TO_PHONE_TYPE_DESC	Remit to telephone type description.			STVTELE	STVTELE_DESC
REMIT_TO_PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.			SPRTELE	SPRTELE_UNLIST_IND
REMIT_TO_POSTAL_CODE	Address postal code.			SPRADDR	SPRADDR_ZIP
REMIT_TO_STATE_PROVINCE	State/Province code of the address.			SPRADDR	SPRADDR_STAT_CODE
REMIT_TO_STATE_PROVINCE_DESC	State/province name.			STVSTAT	STVSTAT_DESC
REMIT_TO_STREET_LINE1	First line of the address.			SPRADDR	SPRADDR_STREET_LINE1
REMIT_TO_STREET_LINE2	Second line of the address.			SPRADDR	SPRADDR_STREET_LINE2
REMIT_TO_STREET_LINE3	Third line of the address.			SPRADDR	SPRADDR_STREET_LINE3
REMIT_TO_STREET_LINE4	Fourth line of the address.			SPRADDR	SPRADDR_STREET_LINE4
STATE_PROVINCE	State or province associated with this address.			NA	NA
STATE_PROVINCE_DESC	State/province name.			NA	NA
STREET_LINE1	First line of the address.			NA	NA
STREET_LINE2	Second line of the address.			NA	NA
STREET_LINE3	Third line of the address.			NA	NA
STREET_LINE4	Fourth line of the address.			NA	NA
TAX_ID	Vendor's tax identification number if payment is recorded and accumulated for income tax reporting.			FTVVEND	FTVVEND_1099_RPT_ID
VENDOR_TYPE_COUNT	Count of the number of vendor types associated to the vendor.			FUNCTION	MFKFUNC.F_VENDOR_TYPE_COUNT(VENDOR.VENDOR_UID)
VENDOR_UID	System generated unique internal identification number used to access the vendor.			FTVVEND	FTVVEND_PIDM

Ver: 8.3