Go To View:  RETURN TO COMPOSITE VIEW 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.

Target Column Business Definition Database Data Type Source Name Source Column
CAMPUS Campus of the vendor. VARCHAR2(0)

NA

NA

CAMPUS_DESC Vendor campus description. VARCHAR2(0)

NA

NA

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

FTVVEND

FTVVEND_CONTACT

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

FEDERAL_REPORTABLE_TAX_IND Indicates vendor as reportable for federal tax purposes. VARCHAR2(1)

CALCULATION

DECODE(FTVVEND_1099_RPT_ID)

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

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

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

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

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

FTVVEND

FTVVEND_VEND_CHECK_PIDM

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

FTVVEND

FTVVEND_1099_RPT_ID

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

FTVVEND

FTVVEND_PIDM

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

NA

NA



Ver: 8.0