Go To View:  RETURN TO BANNER ODS META DATA 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
VENDOR_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADDRESS_TYPE 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 Address type description. VARCHAR2(255)  

NA

NA

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

BUILDING Building Building code when there is a building in the vendor address. VARCHAR2(63)  

NA

NA

CAMPUS Campus Campus of the vendor. VARCHAR2(63)  

NA

NA

CAMPUS_DESC Campus Description Vendor campus description. VARCHAR2(255)  

NA

NA

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(4)  

NA

NA

CARRIER_VENDOR Carrier Vendor Determines whether the vendor is a domestic or foreign carrier. VARCHAR2(63)  

FTVVEND

FTVVEND_CARRIER_IND

CARRIER_VENDOR_DESC Carrier Vendor Description Carrier vendor description. VARCHAR2(255)  

FUNCTION

CASE WHEN FTVVEND_CARRIER_IND

CITY City Address city, town or municipality. VARCHAR2(63)  

NA

NA

CONTACT_NAME Contact Name Name or title of the primary contact for the vendor. VARCHAR2(255)  

FTVVEND

FTVVEND_CONTACT

CORRECTION_DIGIT Correction Digit Correction digit associated with the address for bar code mailing. NUMBER  

NA

NA

COUNTY County County for this address. VARCHAR2(63)  

NA

NA

COUNTY_DESC County Description County name for the address. VARCHAR2(255)  

STVCNTY

STVCNTY_DESC

CURRENCY Currency Vendor currency to default on invoicing. VARCHAR2(63)  

FTVVEND

FTVVEND_CURR_CODE

CURRENCY_DESC Currency Description Currency code description or title. VARCHAR2(255)  

GTVCURR

GTVCURR_TITLE

DELIVERY_POINT Delivery Point Delivery point associated with the address for barcode mailings. NUMBER  

NA

NA

DISCOUNT Discount Code representing the discount terms established with the vendor. VARCHAR2(63)  

FTVVEND

FTVVEND_DISC_CODE

DISCOUNT_DESC Discount Description Discount description. VARCHAR2(255)  

FTVDISC

FTVDISC_DESC

DISCOUNT_PERCENT Discount Percent Discount percent. NUMBER  

FTVDISC

FTVDISC_PCT

ENTITY_TYPE Entity Type Indicates whether this is person or entity record. VARCHAR2(1)  

SPRIDEN

SPRIDEN_ENTITY_IND

EPROCUREMENT_VENDOR_IND Eprocurement Vendor Indicator Determines whether the vendor exists in a procurement system at the institution or not. VARCHAR2(1)  

FTVVEND

FTVVEND_EPROC_IND

FEDERAL_ADDRESS_NUMBER Federal Address Number Sequence used to identify different addresses within the same address type. NUMBER  

FTVVEND

FTVVEND_1099_ADDR_SEQNO

FEDERAL_ADDRESS_TYPE 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

FEDERAL_CITY Federal City Address city, town or municipality. VARCHAR2(63)  

SPRADDR

SPRADDR_CITY

FEDERAL_COUNTY Federal County County for this address. VARCHAR2(63)  

SPRADDR

SPRADDR_COUNTY

FEDERAL_COUNTY_DESC Federal County Description   VARCHAR2(255)  

STVCNTY

STVCNTY_DESC

FEDERAL_NATION Federal Nation Nation/country code associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_NATN_CODE

FEDERAL_NATION_DESC Federal Nation Description   VARCHAR2(255)  

STVNATN

STVNATN_NATION

FEDERAL_POSTAL_CODE Federal Postal Code Address postal code. VARCHAR2(63)  

SPRADDR

SPRADDR_ZIP

FEDERAL_REPORTABLE_TAX_IND Federal Reportable Tax Indicator Indicates vendor as reportable for federal tax purposes. VARCHAR2(63)  

CALCULATION

DECODE(FTVVEND_1099_RPT_ID)

FEDERAL_REPORT_VENDOR_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 Federal Report Vendor Name Name of the Doing Business As vendor. VARCHAR2(255)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

FEDERAL_REPORT_VENDOR_UID 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 Federal State Province State or province associated with this address. VARCHAR2(63)  

SPRADDR

SPRADDR_STAT_CODE

FEDERAL_STATE_PROVINCE_DESC Federal State Province Description   VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

FEDERAL_STREET_LINE1 Federal Street Line 1 First line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE1

FEDERAL_STREET_LINE2 Federal Street Line 2 Second line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE2

FEDERAL_STREET_LINE3 Federal Street Line 3   VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE3

FEDERAL_STREET_LINE4 Federal Street Line 4   VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE4

FEDERAL_WITHHOLDING_PERCENT Federal Withholding Percent Backup withholding percentage used for federal income tax reporting purposes. NUMBER  

FTVVEND

FTVVEND_FED_WHOLD_PCT

FLOOR Floor Floor number specific to the shipping address. VARCHAR2(63)  

NA

NA

ID ID Entity's identification number used to access the records associated with the entity. VARCHAR2(63)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

INVOICE_GROUPING 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 Invoice Grouping Description Vendor invoice grouping description. VARCHAR2(255)  

FUNCTION

CASE WHEN FTVVEND_GROUPING_IND

MOST_RECENT_TAX_ID_NOTICE_YEAR Most Recent Tax ID Notice Year Year the most recent tax identification number notice was received. VARCHAR2(63)  

NA

NA

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NAME Name Name of the vendor. VARCHAR2(255)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

NATION Nation Nation/country code associated with the address. VARCHAR2(63)  

NA

NA

NATION_DESC Nation Description Address nation/country description. VARCHAR2(255)  

NA

NA

NUMBER_OF_TAX_ID_NOTICES Number Of Tax ID Notices Number of tax identification number notices the vendor has received. VARCHAR2(63)  

NA

NA

ORDER_FROM_ADDRESS_NUMBER Order From Address Number Sequence number of the order from address for the vendor. NUMBER  

FTVVEND

FTVVEND_ADDR_SEQNO

ORDER_FROM_ADDRESS_TYPE 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 Order From Address Type Description Vendor address type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ORDER_FROM_BUILDING Order From Building Building associated with the address. VARCHAR2(63)  

NA

NA

ORDER_FROM_CARRIER_ROUTE Order From Carrier Route Carrier route associated with the address for barcode mailings. VARCHAR2(4)  

SPRADDR

SPRADDR_CARRIER_ROUTE

ORDER_FROM_CITY Order From City City associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_CITY

ORDER_FROM_CORRECTION_DIGIT Order From Correction Digit Correction digit associated with the address for barcode mailings. NUMBER  

SPRADDR

SPRADDR_CORRECTION_DIGIT

ORDER_FROM_COUNTY Order From County County associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_CNTY_CODE

ORDER_FROM_COUNTY_DESC Order From County Description County associated with the county code. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ORDER_FROM_DELIVERY_POINT Order From Delivery Point Delivery point associated with the address for barcode mailings. NUMBER  

SPRADDR

SPRADDR_DELIVERY_POINT

ORDER_FROM_EMAIL_ADDRESS Order From Email Address Preferred email address of the person. VARCHAR2(255)  

GOREMAL

GOREMAL_EMAIL_ADDRESS

ORDER_FROM_EMAIL_TYPE 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 Order From Email Type Description Email type description. VARCHAR2(255)  

GTVEMAL

GTVEMAL_DESC

ORDER_FROM_FAX_NUMBER Order From Fax Number Fax number associated with the order from address. VARCHAR2(63)  

NA

NA

ORDER_FROM_FLOOR Order From Floor Floor associated with the order from address. VARCHAR2(63)  

NA

NA

ORDER_FROM_NATION Order From Nation Nation code associated with the order from address. VARCHAR2(63)  

SPRADDR

SPRADDR_NATN_CODE

ORDER_FROM_NATION_DESC Order From Nation Description Order from address nation/country description. VARCHAR2(255)  

STVNATN

STVNATN_NATION

ORDER_FROM_PHONE_COMBINED 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 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 Phone Type Description Order from telephone type description. VARCHAR2(255)  

STVTELE

STVTELE_DESC

ORDER_FROM_PHONE_UNLIST_IND Order From Phone Unlist Indicator Specifies if the phone number is to be unlisted. VARCHAR2(1)  

SPRTELE

SPRTELE_UNLIST_IND

ORDER_FROM_POSTAL_CODE Order From Postal Code Address postal code. VARCHAR2(63)  

SPRADDR

SPRADDR_ZIP

ORDER_FROM_STATE_PROVINCE 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 Order from state/province description. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

ORDER_FROM_STREET_LINE1 Order From Street Line 1 First line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE1

ORDER_FROM_STREET_LINE2 Order From Street Line 2 Second line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE2

ORDER_FROM_STREET_LINE3 Order From Street Line 3 Third line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE3

ORDER_FROM_STREET_LINE4 Order From Street Line 4 Fourth line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE4

ORDER_HOLD_REASON 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 Order Hold Reason Description Purchase order hold reason description. VARCHAR2(255)  

FTVHRSN

FTVHRSN_DESC

PAYMENT_HOLD_REASON 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 Payment hold reason description. VARCHAR2(255)  

FTVHRSN

FTVHRSN_DESC

PHONE_AREA Phone Area Phone area code for the vendor. VARCHAR2(63)  

FTVVEND

FTVVEND_PHONE_AREA

PHONE_COUNTRY_CODE Phone Country Code Phone region or country code designation. VARCHAR2(63)  

FTVVEND

FTVVEND_CTRY_CODE_PHONE

PHONE_EXT Phone Extension Phone extension for the vendor. VARCHAR2(63)  

FTVVEND

FTVVEND_PHONE_EXT

PHONE_NUMBER Phone Number Phone number for the vendor. VARCHAR2(63)  

FTVVEND

FTVVEND_PHONE_NUMBER

PHONE_NUMBER_COMBINED 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 Postal code associated with the vendor address. VARCHAR2(63)  

NA

NA

PROCESS_GROUP 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 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 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 Address Type Description 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 Remit To Building Building of the remit to vendor address. VARCHAR2(63)  

NA

NA

REMIT_TO_CARRIER_ROUTE Remit To Carrier Route Carrier route associated with the address for barcode mailings. VARCHAR2(4)  

SPRADDR

SPRADDR_CARRIER_ROUTE

REMIT_TO_CITY Remit To City City associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_CITY

REMIT_TO_CORRECTION_DIGIT Remit To Correction Digit Correction digit associated with the address for barcode mailings. NUMBER  

SPRADDR

SPRADDR_CORRECTION_DIGIT

REMIT_TO_COUNTY Remit To County County associated with the address. VARCHAR2(63)  

SPRADDR

SPRADDR_CNTY_CODE

REMIT_TO_COUNTY_DESC Remit To County Description County associated with the county code. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_DELIVERY_POINT Remit To Delivery Point Delivery point associated with the address for barcode mailings. NUMBER  

SPRADDR

SPRADDR_DELIVERY_POINT

REMIT_TO_EMAIL_ADDRESS Remit To Email Address Preferred email address of the person. VARCHAR2(255)  

GOREMAL

GOREMAL_EMAIL_ADDRESS

REMIT_TO_EMAIL_TYPE 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 Remit To Email Type Description Email address type description. VARCHAR2(255)  

GTVEMAL

GTVEMAL_DESC

REMIT_TO_FAX_NUMBER Remit To Fax Number Fax number associated with the remit to address. VARCHAR2(63)  

NA

NA

REMIT_TO_FLOOR Remit To Floor Floor associated with the remit to address. VARCHAR2(63)  

NA

NA

REMIT_TO_NATION Remit To Nation Nation code associated with the remit to address. VARCHAR2(63)  

SPRADDR

SPRADDR_NATN_CODE

REMIT_TO_NATION_DESC Remit To Nation Description Remit to nation's nation/country description. VARCHAR2(255)  

STVNATN

STVNATN_NATION

REMIT_TO_PHONE_NUMBER_COMBINED 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 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 Phone Type Description Remit to telephone type description. VARCHAR2(255)  

STVTELE

STVTELE_DESC

REMIT_TO_PHONE_UNLIST_IND Remit To Phone Unlist Indicator Specifies if the phone number is to be unlisted. VARCHAR2(1)  

SPRTELE

SPRTELE_UNLIST_IND

REMIT_TO_POSTAL_CODE Remit To Postal Code Address postal code. VARCHAR2(63)  

SPRADDR

SPRADDR_ZIP

REMIT_TO_STATE_PROVINCE Remit To State Province State/Province code of the address. VARCHAR2(63)  

SPRADDR

SPRADDR_STAT_CODE

REMIT_TO_STATE_PROVINCE_DESC Remit To State Province Description State/province name. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

REMIT_TO_STREET_LINE1 Remit To Street Line 1 First line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE1

REMIT_TO_STREET_LINE2 Remit To Street Line 2 Second line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE2

REMIT_TO_STREET_LINE3 Remit To Street Line 3 Third line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE3

REMIT_TO_STREET_LINE4 Remit To Street Line 4 Fourth line of the address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE4

REMIT_TO_VENDOR_ID 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 Remit To Vendor Name Name of the remit to vendor. VARCHAR2(255)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

REMIT_TO_VENDOR_UID 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 Province State or province associated with this address. VARCHAR2(63)  

NA

NA

STATE_PROVINCE_DESC State Province Description State/province name. VARCHAR2(255)  

NA

NA

STATE_WITHHOLDING_PERCENT State Withholding Percent Backup withholding percentage used for state income tax reporting purposes. NUMBER  

FTVVEND

FTVVEND_ST_WHOLD_PCT

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(255)  

NA

NA

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(255)  

NA

NA

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(255)  

NA

NA

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(255)  

NA

NA

TAX_ID 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 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 Tax income type description. VARCHAR2(255)  

FTVITYP

FTVITYP_DESC

TAX_INCOME_TYPE_KEY 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 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 Vendor Collects Tax Determines which compensating or use taxes should be collected. VARCHAR2(63)  

FTVVEND

FTVVEND_COLLECT_TAX

VENDOR_COLLECTS_TAX_DESC Vendor Collects Tax Description Collecting compensating or use tax description. VARCHAR2(255)  

FUNCTION

CASE WHEN FTVEVND_COLLECT_TAX

VENDOR_DATA_ORIGIN Vendor Data Origin Source system that created or updated the data. VARCHAR2(63)  

FTVVEND

FTVVEND_DATA_ORIGIN

VENDOR_RESIDENCY 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 Vendor residency description. VARCHAR2(255)  

FUNCTION

CASE WHEN FTVVEND_IN_ST_IND

VENDOR_START_DATE Vendor Start Date Vendor start date. DATE  

FTVVEND

FTVVEND_EFF_DATE

VENDOR_TERMINATION_DATE Vendor Termination Date Vendor termination date. DATE  

CALCULATION

NVL(FTVVEND_TERM_DATE,'31-DEC-2099')

VENDOR_TYPE_COUNT 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 Vendor UID System generated unique internal identification number used to access the vendor. NUMBER  

FTVVEND

FTVVEND_PIDM

VENDOR_USER_ID Vendor User ID Unique identification code of the user who entered or last updated the vendor. VARCHAR2(63)  

FTVVEND

FTVVEND_USER_ID



Ver: 9.0