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

Ver: 8.1