Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

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 Administrative-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 associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. 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 Sequence used to identify different addresses within the same address type. NUMBER

FTVVEND

FTVVEND_1099_ADDR_SEQNO

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 Address city, town or municipality. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

FEDERAL_COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_COUNTY

FEDERAL_COUNTY_DESC   VARCHAR2(255)

STVCNTY

STVCNTY_DESC

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

SPRADDR

SPRADDR_NATN_CODE

FEDERAL_NATION_DESC   VARCHAR2(255)

STVNATN

STVNATN_NATION

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

SPRADDR

SPRADDR_STAT_CODE

FEDERAL_STATE_PROVINCE_DESC   VARCHAR2(255)

STVSTAT

STVSTAT_DESC

FEDERAL_STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

FEDERAL_STREET_LINE2 Second line of the address. 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 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

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: 9.1