| Target Column |
Business Name |
Business Definition |
Database Data Type |
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
|
Administrative-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 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
|
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
|
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
|
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
|