Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Manage Vendors to Manage Subcontracts Mapping

This section includes information that flows down from the Manage Vendors application into the Manage Subcontracts screen when you use the Refresh from AP button in Manage Subcontracts, or when you add or replace the subcontractor/vendor ID in a subcontract record. Also included here is the mapping of database tables and columns/fields where information is retrieved and copied into.

Table Column Description Nulls Type Table Column Description Nulls Type Notes
Manage Vendors Manage Subcontracts
VEND S_CL_SM_BUS_CD Small Business Code N VARCHAR(1) SUBCNTR_MASTER S_CL_SM_BUS_CD Business Classification Size Y VARCHAR(1) L = Large; S = Small; N = Non-Profit; F = Foreign/Other
VEND CL_WOM_OWN_FL Women Owned Business Flag (Y/N) N VARCHAR(1) SUBCNTR_MASTER CL_WOM_OWN_FL Woman-Owned N VARCHAR(1)
VEND CL_DISADV_FL Disadvantaged Business Flag (Y/N) N VARCHAR(1) SUBCNTR_MASTER CL_DISADV_FL Disadvantaged (Include Minority Owned) N VARCHAR(1)
VEND CL_LAB_SRPL_FL Vendor Classification Labor Surplus Flag (Y/N) N VARCHAR(1) SUBCNTR_MASTER CL_LAB_SRPL_FL HUB Zone N VARCHAR(1)
VEND CL_HIST_BL_CLG_FL Historical Black College Business Flag (Y/N) N VARCHAR(1) SUBCNTR_MASTER CL_HIST_BL_CLG_FL Historical Black Colleges and Universities/Minority Institutions N VARCHAR(1)
VEND CL_VET_FL Vendor Classification Veteran Flag (Y/N) Y VARCHAR(1) SUBCNTR_MASTER CL_VET_FL Veteran-Owned N VARCHAR(1)
VEND CL_SD_VET_FL Vendor Classification Disabled Veteran Flag (Y/N) Y VARCHAR(1) SUBCNTR_MASTER CL_SD_VET_FL Service-Disabled Veteran-Owned N VARCHAR(1)
VEND CL_ANC_IT_FL Alaskan Native Corporations and Indian Tribes Y VARCHAR(1) SUBCNTR_MASTER CL_ANC_IT_FL Alaskan Native Corporation (ANC) and Indian Tribes N VARCHAR(1)
VEND CL_8A_FL 8(a) Certified N VARCHAR(1) SUBCNTR_MASTER CL_8A_FL 8(a) Certified N VARCHAR(1)
VEND CL_ABIL_ONE_FL AbilityOne Non-Profit Agency N VARCHAR(1) SUBCNTR_MASTER CL_ABIL_ONE_FL AbilityOne Non-Profit Agency N VARCHAR(1)
VEND CL_LGBTQ_FL LGBTQ+ Owned N VARCHAR(1) SUBCNTR_MASTER CL_LGBTQ_FL LGBTQ+ Owned N VARCHAR(1)
VEND_NAICS OPP_NAICS_CD NAICS Code N VARCHAR(15) SUBCNTR_MASTER OPP_NAICS1_CD NAICS (primary) Y VARCHAR(1) Where PRIME_NAIC = Y
VEND_NAICS EFFECTIVE_DT NAICS Effective Date Y smalldatetime SUBCNTR_MASTER NAICS_EFFECTIAVE_DT_1 NAICS Effective Date (primary) Y SMALLDATETIME
VEND CMMC_LEVEL Cybersecurity Maturity Model Certification Level Y VARCHAR(10) SUBCNTR_MASTER CMMC_LEVEL CMMC Level Y VARCHAR(10) New Subcontract Field (None, 1, 2, 3, 4, 5)