| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
CAMPUS
|
|
Campus of the vendor.
|
VARCHAR2(0)
|
|
NA
|
NA
|
|
CAMPUS_DESC
|
|
Vendor campus description.
|
VARCHAR2(0)
|
|
NA
|
NA
|
|
CARRIER_VENDOR
|
Carrier Vendor
|
|
VARCHAR2(1)
|
|
|
|
|
CARRIER_VENDOR_DESC
|
Carrier Vendor Description
|
|
VARCHAR2(16)
|
|
|
|
|
CONTACT_NAME
|
|
Name or title of the primary contact for the vendor.
|
VARCHAR2(35)
|
|
FTVVEND
|
FTVVEND_CONTACT
|
|
COUNTRY_CODE
|
Country Code
|
|
VARCHAR2(4)
|
|
|
|
|
CURRENCY
|
Currency
|
|
VARCHAR2(4)
|
|
|
|
|
CURRENCY_DESC
|
Currency Description
|
|
VARCHAR2(35)
|
|
|
|
|
CURRENT_DATE
|
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
|
NA
|
SYSDATE
|
|
DISCOUNT
|
Discount
|
|
VARCHAR2(2)
|
|
|
|
|
DISCOUNT_DESC
|
Discount Description
|
|
VARCHAR2(35)
|
|
|
|
|
DISCOUNT_PERCENT
|
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
|
Eprocurement Vendor Indicator
|
|
VARCHAR2(1)
|
|
|
|
|
FEDERAL_ADDRESS_NUMBER
|
Federal Address Number
|
|
NUMBER
|
|
|
|
|
FEDERAL_ADDRESS_TYPE
|
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
|
Federal Report Vendor UID
|
|
NUMBER
|
|
|
|
|
FEDERAL_WITHHOLDING_PERCENT
|
Federal Withholding Percent
|
|
NUMBER
|
|
|
|
|
INVOICE_GROUPING
|
Invoice Grouping
|
|
VARCHAR2(1)
|
|
|
|
|
INVOICE_GROUPING_DESC
|
Invoice Grouping Description
|
|
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(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
|
|
ORDER_HOLD_REASON
|
Order Hold Reason
|
|
VARCHAR2(4)
|
|
|
|
|
ORDER_HOLD_REASON_DESC
|
Order Hold Reason Description
|
|
VARCHAR2(35)
|
|
|
|
|
PAYMENT_HOLD_REASON
|
Payment Hold Reason
|
|
VARCHAR2(4)
|
|
|
|
|
PAYMENT_HOLD_REASON_DESC
|
Payment Hold Reason Description
|
|
VARCHAR2(35)
|
|
|
|
|
PHONE_AREA
|
Phone Area
|
Phone area code for the vendor.
|
VARCHAR2(6)
|
|
FTVVEND
|
FTVVEND_PHONE_AREA
|
|
PHONE_EXT
|
Phone Extension
|
Phone extension for the vendor.
|
VARCHAR2(10)
|
|
FTVVEND
|
FTVVEND_PHONE_EXT
|
|
PHONE_NUMBER
|
Phone Number
|
Phone number for the vendor.
|
VARCHAR2(12)
|
|
FTVVEND
|
FTVVEND_PHONE_NUMBER
|
|
PHONE_NUMBER_COMBINED
|
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(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(8)
|
|
FTVVEND
|
FTVVEND_VEND_CHECK_PIDM
|
|
STATE_WITHHOLDING_PERCENT
|
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
|
Tax Income Type
|
|
VARCHAR2(2)
|
|
|
|
|
TAX_INCOME_TYPE_DESC
|
Tax Income Type Description
|
|
VARCHAR2(35)
|
|
|
|
|
TAX_INCOME_TYPE_KEY
|
Tax Income Type KEY
|
|
NUMBER
|
|
|
|
|
VENDOR_ACTIVITY_DATE
|
Vendor Activity Date
|
|
DATE
|
|
|
|
|
VENDOR_COLLECTS_TAX
|
Vendor Collects Tax
|
|
VARCHAR2(1)
|
|
|
|
|
VENDOR_COLLECTS_TAX_DESC
|
Vendor Collects Tax Description
|
|
VARCHAR2(23)
|
|
|
|
|
VENDOR_DATA_ORIGIN
|
Vendor Data Origin
|
|
VARCHAR2(30)
|
|
|
|
|
VENDOR_RESIDENCY
|
Vendor Residency
|
|
VARCHAR2(1)
|
|
|
|
|
VENDOR_RESIDENCY_DESC
|
Vendor Residency Description
|
|
VARCHAR2(12)
|
|
|
|
|
VENDOR_START_DATE
|
Vendor Start Date
|
|
DATE
|
|
|
|
|
VENDOR_TERMINATION_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(8)
|
|
FTVVEND
|
FTVVEND_PIDM
|
|
VENDOR_USER_ID
|
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
|