Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	NA	NA	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BUILDING	Building code when there is a building in the vendor address.	VARCHAR2(63)	NA	NA	NO	NO
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	NA	NA	NO	NO
CAMPUS_DESC	Vendor campus description.	VARCHAR2(255)	NA	NA	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	NA	NA	NO	NO
CARRIER_VENDOR	Determines whether the vendor is a domestic or foreign carrier.	VARCHAR2(63)	FTVVEND	FTVVEND_CARRIER_IND	NO	NO
CARRIER_VENDOR_DESC	Carrier vendor description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVVEND_CARRIER_IND	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(63)	NA	NA	NO	NO
CONTACT_NAME	Name or title of the primary contact for the vendor.	VARCHAR2(255)	FTVVEND	FTVVEND_CONTACT	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	NA	NA	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	NA	NA	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC	NO	NO
CURRENCY	Vendor currency to default on invoicing.	VARCHAR2(63)	FTVVEND	FTVVEND_CURR_CODE	NO	NO
CURRENCY_DESC	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	NA	NA	NO	NO
DISCOUNT	Code representing the discount terms established with the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_DISC_CODE	NO	NO
DISCOUNT_DESC	Discount description.	VARCHAR2(255)	FTVDISC	FTVDISC_DESC	NO	NO
DISCOUNT_PERCENT	Discount percent.	NUMBER	FTVDISC	FTVDISC_PCT	NO	NO
ENTITY_TYPE	Indicates whether this is person or entity record.	VARCHAR2(1)	SPRIDEN	SPRIDEN_ENTITY_IND	NO	NO
EPROCUREMENT_VENDOR_IND	Determines whether the vendor exists in a procurement system at the institution or not.	VARCHAR2(1)	FTVVEND	FTVVEND_EPROC_IND	NO	NO
FEDERAL_ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	FTVVEND	FTVVEND_1099_ADDR_SEQNO	NO	NO
FEDERAL_ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	FTVVEND	FTVVEND_1099_ATYP_CODE	NO	NO
FEDERAL_CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
FEDERAL_COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_COUNTY	NO	NO
FEDERAL_COUNTY_DESC		VARCHAR2(255)	STVCNTY	STVCNTY_DESC	NO	NO
FEDERAL_NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
FEDERAL_NATION_DESC		VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
FEDERAL_POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
FEDERAL_REPORTABLE_TAX_IND	Indicates vendor as reportable for federal tax purposes.	VARCHAR2(63)	CALCULATION	DECODE(FTVVEND_1099_RPT_ID)	NO	NO
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	NO	NO
FEDERAL_REPORT_VENDOR_NAME	Name of the Doing Business As vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
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	NO	NO
FEDERAL_STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
FEDERAL_STATE_PROVINCE_DESC		VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
FEDERAL_STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
FEDERAL_STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
FEDERAL_STREET_LINE3		VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
FEDERAL_STREET_LINE4		VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
FEDERAL_WITHHOLDING_PERCENT	Backup withholding percentage used for federal income tax reporting purposes.	NUMBER	FTVVEND	FTVVEND_FED_WHOLD_PCT	NO	NO
FLOOR	Floor number specific to the shipping address.	VARCHAR2(63)	NA	NA	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
INVOICE_GROUPING	Determines whether the vendor invoices are grouped (M)any per check or (1) per check.	VARCHAR2(63)	FTVVEND	FTVVEND_GROUPING_IND	NO	NO
INVOICE_GROUPING_DESC	Vendor invoice grouping description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVVEND_GROUPING_IND	NO	NO
MOST_RECENT_TAX_ID_NOTICE_YEAR	Year the most recent tax identification number notice was received.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(63)	NA	NA	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(255)	NA	NA	NO	NO
NUMBER_OF_TAX_ID_NOTICES	Number of tax identification number notices the vendor has received.	VARCHAR2(63)	NA	NA	NO	NO
ORDER_FROM_ADDRESS_NUMBER	Sequence number of the order from address for the vendor.	NUMBER	FTVVEND	FTVVEND_ADDR_SEQNO	NO	NO
ORDER_FROM_ADDRESS_TYPE	Address type of the order from address for the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_ATYP_CODE	NO	NO
ORDER_FROM_ADDRESS_TYPE_DESC	Vendor address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ORDER_FROM_BUILDING	Building associated with the address.	VARCHAR2(63)	NA	NA	NO	NO
ORDER_FROM_CARRIER_ROUTE	Carrier route associated with the address for barcode mailings.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
ORDER_FROM_CITY	City associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
ORDER_FROM_CORRECTION_DIGIT	Correction digit associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
ORDER_FROM_COUNTY	County associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
ORDER_FROM_COUNTY_DESC	County associated with the county code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ORDER_FROM_DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
ORDER_FROM_EMAIL_ADDRESS	Preferred email address of the person.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
ORDER_FROM_EMAIL_TYPE	Type of email associated with the person's preferred email.	VARCHAR2(63)	GOREMAL	GOREMAL_EMAL_CODE	NO	NO
ORDER_FROM_EMAIL_TYPE_DESC	Email type description.	VARCHAR2(255)	GTVEMAL	GTVEMAL_DESC	NO	NO
ORDER_FROM_FAX_NUMBER	Fax number associated with the order from address.	VARCHAR2(63)	NA	NA	NO	NO
ORDER_FROM_FLOOR	Floor associated with the order from address.	VARCHAR2(63)	NA	NA	NO	NO
ORDER_FROM_NATION	Nation code associated with the order from address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
ORDER_FROM_NATION_DESC	Order from address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
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	NO	NO
ORDER_FROM_PHONE_TYPE	Order from type of telephone code such as home phone, emergency contact.	VARCHAR2(63)	SPRTELE	SPRTELE_TELE_CODE	NO	NO
ORDER_FROM_PHONE_TYPE_DESC	Order from telephone type description.	VARCHAR2(255)	STVTELE	STVTELE_DESC	NO	NO
ORDER_FROM_PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND	NO	NO
ORDER_FROM_POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
ORDER_FROM_STATE_PROVINCE	State/Province code of the address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
ORDER_FROM_STATE_PROVINCE_DESC	Order from state/province description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
ORDER_FROM_STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
ORDER_FROM_STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
ORDER_FROM_STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
ORDER_FROM_STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
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	NO	NO
ORDER_HOLD_REASON_DESC	Purchase order hold reason description.	VARCHAR2(255)	FTVHRSN	FTVHRSN_DESC	NO	NO
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	NO	NO
PAYMENT_HOLD_REASON_DESC	Payment hold reason description.	VARCHAR2(255)	FTVHRSN	FTVHRSN_DESC	NO	NO
PHONE_AREA	Phone area code for the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_PHONE_AREA	NO	NO
PHONE_COUNTRY_CODE	Phone region or country code designation.	VARCHAR2(63)	FTVVEND	FTVVEND_CTRY_CODE_PHONE	NO	NO
PHONE_EXT	Phone extension for the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_PHONE_EXT	NO	NO
PHONE_NUMBER	Phone number for the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_PHONE_NUMBER	NO	NO
PHONE_NUMBER_COMBINED	Extracted combined phone number for the vendor.	VARCHAR2(63)	CALCULATION	FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER||FTVVEND_PHONE_EXT	NO	NO
POSTAL_CODE	Postal code associated with the vendor address.	VARCHAR2(63)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REMIT_TO_ADDRESS_NUMBER	Sequence number of the remit to address type.	NUMBER	CALCULATION	CASE WHEN FTVVEND_CHECK_PIDM IS NULL	NO	NO
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	NO	NO
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)	NO	NO
REMIT_TO_BUILDING	Building of the remit to vendor address.	VARCHAR2(63)	NA	NA	NO	NO
REMIT_TO_CARRIER_ROUTE	Carrier route associated with the address for barcode mailings.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
REMIT_TO_CITY	City associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
REMIT_TO_CORRECTION_DIGIT	Correction digit associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
REMIT_TO_COUNTY	County associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
REMIT_TO_COUNTY_DESC	County associated with the county code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REMIT_TO_DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
REMIT_TO_EMAIL_ADDRESS	Preferred email address of the person.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS	NO	NO
REMIT_TO_EMAIL_TYPE	Type of email associated with the person's preferred email.	VARCHAR2(63)	GOREMAL	GOREMAL_EMAL_CODE	NO	NO
REMIT_TO_EMAIL_TYPE_DESC	Email address type description.	VARCHAR2(255)	GTVEMAL	GTVEMAL_DESC	NO	NO
REMIT_TO_FAX_NUMBER	Fax number associated with the remit to address.	VARCHAR2(63)	NA	NA	NO	NO
REMIT_TO_FLOOR	Floor associated with the remit to address.	VARCHAR2(63)	NA	NA	NO	NO
REMIT_TO_NATION	Nation code associated with the remit to address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
REMIT_TO_NATION_DESC	Remit to nation's nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
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	NO	NO
REMIT_TO_PHONE_TYPE	Remit to type of telephone code such as home phone, emergency contact.	VARCHAR2(63)	SPRTELE	SPRTELE_TELE_CODE	NO	NO
REMIT_TO_PHONE_TYPE_DESC	Remit to telephone type description.	VARCHAR2(255)	STVTELE	STVTELE_DESC	NO	NO
REMIT_TO_PHONE_UNLIST_IND	Specifies if the phone number is to be unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND	NO	NO
REMIT_TO_POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
REMIT_TO_STATE_PROVINCE	State/Province code of the address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
REMIT_TO_STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
REMIT_TO_STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
REMIT_TO_STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
REMIT_TO_STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
REMIT_TO_STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
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	NO	NO
REMIT_TO_VENDOR_NAME	Name of the remit to vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
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)	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	NA	NA	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	NA	NA	NO	NO
STATE_WITHHOLDING_PERCENT	Backup withholding percentage used for state income tax reporting purposes.	NUMBER	FTVVEND	FTVVEND_ST_WHOLD_PCT	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(255)	NA	NA	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(255)	NA	NA	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(255)	NA	NA	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	NA	NA	NO	NO
TAX_ID	Vendor's tax identification number if payment is recorded and accumulated for income tax reporting.	VARCHAR2(63)	FTVVEND	FTVVEND_1099_RPT_ID	NO	NO
TAX_INCOME_TYPE	User value representing income type for 1099 processing and reporting purposes.	VARCHAR2(63)	FTVITYP	FTVITYP_CODE	NO	NO
TAX_INCOME_TYPE_DESC	Tax income type description.	VARCHAR2(255)	FTVITYP	FTVITYP_DESC	NO	NO
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	NO	NO
VENDOR_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FTVVEND	FTVVEND_ACTIVITY_DATE	NO	NO
VENDOR_COLLECTS_TAX	Determines which compensating or use taxes should be collected.	VARCHAR2(63)	FTVVEND	FTVVEND_COLLECT_TAX	NO	NO
VENDOR_COLLECTS_TAX_DESC	Collecting compensating or use tax description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVEVND_COLLECT_TAX	NO	NO
VENDOR_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	FTVVEND	FTVVEND_DATA_ORIGIN	NO	NO
VENDOR_RESIDENCY	Determines whether the vendor is in the state, province or district.	VARCHAR2(63)	FTVVEND	FTVVEND_IN_ST_IND	NO	NO
VENDOR_RESIDENCY_DESC	Vendor residency description.	VARCHAR2(255)	FUNCTION	CASE WHEN FTVVEND_IN_ST_IND	NO	NO
VENDOR_START_DATE	Vendor start date.	DATE	FTVVEND	FTVVEND_EFF_DATE	NO	NO
VENDOR_TERMINATION_DATE	Vendor termination date.	DATE	CALCULATION	NVL(FTVVEND_TERM_DATE,'31-DEC-2099')	NO	NO
VENDOR_TYPE_COUNT	Count of the number of vendor types associated to the vendor.	NUMBER	FUNCTION	MFKFUNC.F_VENDOR_TYPE_COUNT(VENDOR.VENDOR_UID)	NO	NO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FTVVEND	FTVVEND_PIDM	NO	NO
VENDOR_USER_ID	Unique identification code of the user who entered or last updated the vendor.	VARCHAR2(63)	FTVVEND	FTVVEND_USER_ID	NO	NO

Ver: 9.2