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
CARRIER_VENDOR	Determines whether the vendor is a domestic or foreign carrier.	VARCHAR2(63)	FTVVEND	FTVVEND_CARRIER_IND
CARRIER_VENDOR_DESC	Carrier vendor description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVVEND_CARRIER_IND
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
CURRENCY	Vendor currency to default on invoicing.	VARCHAR2(63)	FTVVEND	FTVVEND_CURR_CODE
CURRENCY_DESC	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	NA	NA
DISCOUNT	Code representing the discount terms established with the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_DISC_CODE
DISCOUNT_DESC	Discount description.	VARCHAR2(255)	FTVDISC	FTVDISC_DESC
DISCOUNT_PERCENT	Discount percent.	NUMBER	FTVDISC	FTVDISC_PCT
ENTITY_TYPE	Indicates whether this is person or entity record.	VARCHAR2(1)	SPRIDEN	SPRIDEN_ENTITY_IND
EPROCUREMENT_VENDOR_IND	Determines whether the vendor exists in a procurement system at the institution or not.	VARCHAR2(1)	FTVVEND	FTVVEND_EPROC_IND
FEDERAL_ADDRESS_NUMBER		NUMBER	FTVVEND	FTVVEND_1099_ADDR_SEQNO
FEDERAL_ADDRESS_TYPE		VARCHAR2(63)	FTVVEND	FTVVEND_1099_ATYP_CODE
FEDERAL_CITY		VARCHAR2(63)	SPRADDR	SPRADDR_CITY
FEDERAL_COUNTY		VARCHAR2(63)	SPRADDR	SPRADDR_COUNTY
FEDERAL_COUNTY_DESC		VARCHAR2(255)	STVCNTY	STVCNTY_DESC
FEDERAL_NATION		VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
FEDERAL_NATION_DESC		VARCHAR2(255)	STVNATN	STVNATN_NATION
FEDERAL_POSTAL_CODE		VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
FEDERAL_REPORTABLE_TAX_IND	Indicates vendor as reportable for federal tax purposes.	VARCHAR2(63)	CALCULATION	DECODE(FTVVEND_1099_RPT_ID)
FEDERAL_REPORT_VENDOR_ID	Identification number assigned to a Doing Business As vendor that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
FEDERAL_REPORT_VENDOR_NAME	Name of the Doing Business As vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
FEDERAL_REPORT_VENDOR_UID	System generated, unique, internal identification number assigned to this person or organization entity providing a cross reference from Doing Business As vendor to the vendor_uid for federal reporting like US 1099.	NUMBER	FTVVEND	FTVVEND_PIDM_OWNER
FEDERAL_STATE_PROVINCE		VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
FEDERAL_STATE_PROVINCE_DESC		VARCHAR2(255)	STVSTAT	STVSTAT_DESC
FEDERAL_STREET_LINE1		VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
FEDERAL_STREET_LINE2		VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
FEDERAL_STREET_LINE3		VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
FEDERAL_STREET_LINE4		VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
FEDERAL_WITHHOLDING_PERCENT	Backup withholding percentage used for federal income tax reporting purposes.	NUMBER	FTVVEND	FTVVEND_FED_WHOLD_PCT
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
INVOICE_GROUPING	Determines whether the vendor invoices are grouped (M)any per check or (1) per check.	VARCHAR2(63)	FTVVEND	FTVVEND_GROUPING_IND
INVOICE_GROUPING_DESC	Vendor invoice grouping description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVVEND_GROUPING_IND
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_NUMBER	Sequence number of the order from address for the vendor.	NUMBER	FTVVEND	FTVVEND_ADDR_SEQNO
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(255)	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)	SPRADDR	SPRADDR_STREET_LINE4
ORDER_HOLD_REASON	Reason to hold creation of new purchase orders for the vendor except by an authorized user.	VARCHAR2(63)	FTVVEND	FTVVEND_PO_HOLD_RSN_CODE
ORDER_HOLD_REASON_DESC	Purchase order hold reason description.	VARCHAR2(255)	FTVHRSN	FTVHRSN_DESC
PAYMENT_HOLD_REASON	Reason to hold payment against the vendor's invoices unless overridden by an authorized user.	VARCHAR2(63)	FTVVEND	FTVVEND_PMT_HOLD_RSN_CODE
PAYMENT_HOLD_REASON_DESC	Payment hold reason description.	VARCHAR2(255)	FTVHRSN	FTVHRSN_DESC
PHONE_AREA	Phone area code for the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_PHONE_AREA
PHONE_COUNTRY_CODE	Phone region or country code designation.	VARCHAR2(63)	FTVVEND	FTVVEND_CTRY_CODE_PHONE
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_NUMBER	Sequence number of the remit to address type.	NUMBER	CALCULATION	CASE WHEN FTVVEND_CHECK_PIDM IS NULL
REMIT_TO_ADDRESS_TYPE	Identifies the type of address that the payment for the invoice is to be sent.	VARCHAR2(63)	CALCULATION	CASE WHEN FTVVEND_CHECK_PIDM IS NULL
REMIT_TO_ADDRESS_TYPE_DESC	Remit to vendor's address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC(CASE WHEN FTVVEND_VEND_CHECK_PIDM IS NULL)
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(255)	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)	SPRADDR	SPRADDR_STREET_LINE4
REMIT_TO_VENDOR_ID	Identification number assigned to the remit to vendor that is used externally for all communication and correspondence with the person or organization.	VARCHAR2(63)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
REMIT_TO_VENDOR_NAME	Name of the remit to vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
REMIT_TO_VENDOR_UID	System generated, unique, internal identification number assigned to this person or organization entity to remit the invoices to instead of the procurement vendor.	NUMBER	CALCULATION	NVL(FTVVEND_VEND_CHECK_PIDM,FTVVEND_PIDM)
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	NA	NA
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	NA	NA
STATE_WITHHOLDING_PERCENT	Backup withholding percentage used for state income tax reporting purposes.	NUMBER	FTVVEND	FTVVEND_ST_WHOLD_PCT
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
TAX_INCOME_TYPE	User value representing income type for 1099 processing and reporting purposes.	VARCHAR2(63)	FTVITYP	FTVITYP_CODE
TAX_INCOME_TYPE_DESC	Tax income type description.	VARCHAR2(255)	FTVITYP	FTVITYP_DESC
TAX_INCOME_TYPE_KEY	Unique, internal, system generated value representing the user selected income type for 1099 processing and reporting purposes.	NUMBER	FTVVEND	FTVVEND_ITYP_SEQ_CODE
VENDOR_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FTVVEND	FTVVEND_ACTIVITY_DATE
VENDOR_COLLECTS_TAX	Determines which compensating or use taxes should be collected.	VARCHAR2(63)	FTVVEND	FTVVEND_COLLECT_TAX
VENDOR_COLLECTS_TAX_DESC	Collecting compensating or use tax description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVEVND_COLLECT_TAX
VENDOR_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	FTVVEND	FTVVEND_DATA_ORIGIN
VENDOR_RESIDENCY	Determines whether the vendor is in the state, province or district.	VARCHAR2(63)	FTVVEND	FTVVEND_IN_ST_IND
VENDOR_RESIDENCY_DESC	Vendor residency description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVVEND_IN_ST_IND
VENDOR_START_DATE	Vendor start date.	DATE	FTVVEND	FTVVEND_EFF_DATE
VENDOR_TERMINATION_DATE	Vendor termination date.	DATE	CALCULATION	NVL(FTVVEND_TERM_DATE,'31-DEC-2099')
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
VENDOR_USER_ID	Unique identification code of the user who entered or last updated the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_USER_ID

Ver: 8.4.1