Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: VENDOR

Description Contains vendor maintenance information including ID, name, contact name, federal tax indicator, federal tax ID number, order/remittance addresses and phone numbers.
Key & Frequency One row per vendor.
Recommended Search Columns ADDRESS_TYPE
PHONE_TYPE
VENDOR_UID

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.0