Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_VENDOR

Description Source composite view contains information on all vendors.
Key & Frequency One row per vendor.

Target Column Business Definition Database Data Type Source Name Source Column
CAMPUS Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(0)

NA

NA

CAMPUS_DESC Vendor campus description. VARCHAR2(0)

NA

NA

CARRIER_VENDOR   VARCHAR2(1)    
CARRIER_VENDOR_DESC   VARCHAR2(16)    
CONTACT_NAME Name or title of the primary contact for the vendor. VARCHAR2(35)

FTVVEND

FTVVEND_CONTACT

COUNTRY_CODE   VARCHAR2(4)    
CURRENCY   VARCHAR2(4)    
CURRENCY_DESC   VARCHAR2(35)    
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DISCOUNT   VARCHAR2(2)    
DISCOUNT_DESC   VARCHAR2(35)    
DISCOUNT_PERCENT   NUMBER    
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

SPRIDEN

SPRIDEN_ENTITY_IND

EPROCUREMENT_VENDOR_IND   VARCHAR2(1)    
FEDERAL_ADDRESS_NUMBER   NUMBER    
FEDERAL_ADDRESS_TYPE   VARCHAR2(2)    
FEDERAL_REPORTABLE_TAX_IND Indicates vendor as reportable for federal tax purposes. VARCHAR2(1)

CALCULATION

DECODE(FTVVEND_1099_RPT_ID)

FEDERAL_REPORT_VENDOR_UID   NUMBER    
FEDERAL_WITHHOLDING_PERCENT   NUMBER    
INVOICE_GROUPING   VARCHAR2(1)    
INVOICE_GROUPING_DESC   VARCHAR2(23)    
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

MOST_RECENT_TAX_ID_NOTICE_YEAR Year the most recent tax identification number notice was received. VARCHAR2(0)

NA

NA

NUMBER_OF_TAX_ID_NOTICES Number of tax identification number notices the vendor has received. VARCHAR2(0)

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(2)

FTVVEND

FTVVEND_ATYP_CODE

ORDER_FROM_ADDRESS_TYPE_DESC Description for the address type of the vendor. VARCHAR2(30)

STVATYP

STVATYP_DESC

ORDER_HOLD_REASON   VARCHAR2(4)    
ORDER_HOLD_REASON_DESC   VARCHAR2(35)    
PAYMENT_HOLD_REASON   VARCHAR2(4)    
PAYMENT_HOLD_REASON_DESC   VARCHAR2(35)    
PHONE_AREA Phone area code for the vendor. VARCHAR2(6)

FTVVEND

FTVVEND_PHONE_AREA

PHONE_EXT Phone extension for the vendor. VARCHAR2(10)

FTVVEND

FTVVEND_PHONE_EXT

PHONE_NUMBER Phone number for the vendor. VARCHAR2(12)

FTVVEND

FTVVEND_PHONE_NUMBER

PHONE_NUMBER_COMBINED Extracted combined phone number for the vendor. VARCHAR2(28)

CALCULATION

FTVVEND_PHONE_AREA||FTVVEND_PHONE_NUMBER||FTVVEND_PHONE_EXT

REMIT_TO_ADDRESS_NUMBER Sequence number of the address type of the remit to vendor. NUMBER

FTVVEND

FTVVEND_VEND_CHECK_ADDR_SEQNO

REMIT_TO_ADDRESS_TYPE Identifies the type of address that the payment for the invoice is to be sent. VARCHAR2(4000)

FTVVEND

FTVVEND_VEND_CHECK_ATYP_CODE

REMIT_TO_ADDRESS_TYPE_DESC Description for the address type of the remit to vendor. VARCHAR2(30)

STVATYP

STVATYP_DESC

REMIT_TO_VENDOR_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

FTVVEND

FTVVEND_VEND_CHECK_PIDM

STATE_WITHHOLDING_PERCENT   NUMBER    
TAX_ID Vendor's tax identification number if payment is recorded and accumulated for income tax reporting. VARCHAR2(9)

FTVVEND

FTVVEND_1099_RPT_ID

TAX_INCOME_TYPE   VARCHAR2(2)    
TAX_INCOME_TYPE_DESC   VARCHAR2(35)    
TAX_INCOME_TYPE_KEY   NUMBER    
VENDOR_ACTIVITY_DATE   DATE    
VENDOR_COLLECTS_TAX   VARCHAR2(1)    
VENDOR_COLLECTS_TAX_DESC   VARCHAR2(23)    
VENDOR_DATA_ORIGIN   VARCHAR2(30)    
VENDOR_RESIDENCY   VARCHAR2(1)    
VENDOR_RESIDENCY_DESC   VARCHAR2(12)    
VENDOR_START_DATE   DATE    
VENDOR_TERMINATION_DATE   DATE    
VENDOR_TYPE Type of vendor that classifies the vendor by various demographic criteria. VARCHAR2(2)

FTVVENT

FTVVENT_VTYP_CODE

VENDOR_TYPE_DESC Description or title of the type of vendor. VARCHAR2(35)

FTVVTYP

FTVVTYP_DESC

VENDOR_UID System generated unique internal identification number used to access the vendor. NUMBER

FTVVEND

FTVVEND_PIDM

VENDOR_USER_ID   VARCHAR2(30)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: