Costpoint Help

Warning and Error Messages

When errors are encountered during the importing of vendor employees, messages may display.

VEND_EMPL

FieldDescription
Vendor ID

Error Message

Meaning/Related Information

Must exist in input file.

The Vendor ID is null.

Contains invalid character(s).

IF - Vendor ID is not null AND

  • Vendor ID contains invalid characters.

Not found in VEND table.
  • Vendor ID does not exist in VEND table.

Must have a parent record.

Already exists in another company.

IF - Vendor ID is not null AND

  • Vendor ID exists in VEND table for another Company ID.

Cannot have <vendor employee> if <vendor> is linked to an <employee>.

IF - Vendor ID is not null AND

  • Vendor ID exists in VEND table for current Company ID AND
  • Employee ID in VEND table is not null.

Existing Vendor linked to an Employee CANNOT have Vendor Employees.

</td></tr></tbody>
</table>

  • Vendor Employee ID

    Error Message

    Meaning/Related Information

    Must exist in input file.

    The Vendor Employee ID is null.

    Contains invalid character(s).

    IF - Vendor Employee ID is not null AND

    • Vendor Employee ID contains invalid characters.
    • Vendor Employee ID, Vendor ID

    Error Message

    Meaning/Related Information

    Already exists for another <vendor> in this company.

    IF - Vendor Employee ID is not null AND

    • Vendor Employee ID exists in VEND_EMPL table or input file for another Vendor ID in current Company ID.

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • (Vendor Employee ID + Vendor ID) is duplicated in input file for current Company ID.
    FieldDescription
    Last Name

    Error Message

    Meaning/Related Information

    Must exist in input file.

    IF - Last Name is null AND

    • Vendor Employee is new.
    First Name

    Error Message

    Meaning/Related Information

    Must exist in input file.

    IF - First Name is null AND

    • Vendor Employee is new.
    FieldDescription
    Vendor Employee Status

    Error Message

    Meaning/Related Information

    Must be A or I.

    IF - Vendor Employee Status is not null AND

    • Vendor Employee Status <> A or I.
    T&E Employee ID

    Error Message

    Meaning/Related Information

    Contains invalid character(s).

    IF - T&E Employee ID is not null AND

    • T&E Employee ID contains invalid characters.

    Already exists for another <vendor employee> in the VEND_EMPL input file.

    IF - T&E Employee ID is not null AND

    • T&E Employee ID exists in VEND_EMPL input file for another Vendor Employee ID.

    Already exists for another <vendor employee> in the VEND_EMPL table.

    IF - T&E Employee ID is not null AND

    • T&E Employee ID exists in VEND_EMPL table for another Vendor Employee ID.

    Already exists for another <employee> in the EMPL table.

    IF

    T&E Employee ID is not null AND

    T&E Employee ID exists (as Employee ID) in EMPL table.
    FieldDescription
    Vendor Employee Approver ID

    Error Message

    Meaning/Related Information

    Not found in EMPL table.

    IF - Vendor Employee Approver ID is not null AND

    • Vendor Employee Approver ID does not exist in EMPL table AND
    • Vendor Employee Requires Approval in AP_SETTINGS.
    Vendor Employee Approval Status Date

    Warning Message

    Meaning/Related Information

    Will be set to the system date.

    IF - Vendor Employee Approval Status Date is null AND

    • Vendor Employee Approver ID is not null AND
    • Vendor Employee Requires Approval in AP_SETTINGS
    FieldDescription
    Vendor Employee Approval Status

    Error Message

    Meaning/Related Information

    Must be A, P, or R.

    IF - Vendor Employee Approval Status is not null AND

    • Vendor Employee Approval Status <> A, P, or R.

    If null, there will be no error or warning but Costpoint will do the following:

     <ol type="a">
   <li>
     <p>Set it to A, if the <strong>Subcontractor Vendor Employee Approval - Requires Approval</strong> check box in Configure Accounts Payable Settings is not selected.</p>
   </li>
 </ol>
<ol type="a">
  <li>
    <p>Set it to P, if the <strong>Subcontractor Vendor Employee Approval - Requires Approval</strong> check box in Configure Accounts Payable Settings is selected.</p>
  </li>
</ol>
</td></tr></tbody>
</table>
    • US Citizen Flag

    Error Message

    Meaning/Related Information

    Must be Y or N.

    IF - US Citizen Flag is not null AND

    • US Citizen Flag <> Y or N.

    If null, there will be no error or warning but the system will set it to N (default).
    FieldDescription
    ITAR Status Code

    Error Message

    Meaning/Related Information

    Must be U, F, N, or NA.

    IF - ITAR Status Code is not null AND

    • ITAR Status Code <> U, F, N, or NA.

    If null, there will be no error or warning but the system will set it to N (default).

    </td></tr></tbody>
</table>
    • Termination Date

    Error Message

    Meaning/Related Information

    Bad CSV file. File: VEND_EMPL, Field: VEND_EMPL_TERM_DATE, Value: <Date>

    Termination Date is not a valid date.

    Termination Date is less than the workforce start date.

    IF - The vendor employee is assigned to a workforce AND

    • The Termination Date is earlier than the workforce start date.

    VE_LAB_INFO

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Effective Start Date
    Error MessageMeaning/Related Information
    Must exist in input file.Effective Start Date is null.
    Vendor Employee ID, Vendor ID

    Error Message

    Meaning/Related Information

    Not found in VEND_EMPL input file and VEND_EMPL table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
    Vendor Employee ID, Vendor ID, Effective Start Date

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Effective Start Date is not null AND
    • (Vendor Employee ID + Vendor ID + Effective Start Date) is duplicated in input file for current Company ID.
    Default GLC

    Error Message

    Meaning/Related Information

    Required if T&E <employee>ID is not blank.

    IF - Default GLC is null AND

    • T&E Employee ID in VEND_EMPL table or input file is not null

    Not found in GEN_LAB_CAT table.

    IF - Default GLC is not null AND

    • Default GLC does not exist in GEN_LAB_CAT table.
    FieldDescription
    Default PLC

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Default PLC is null AND

    • T&E Employee ID in VEND_EMPL table or input file is not null

    Not found in BILL_LAB_CAT table.

    IF - Default PLC is not null AND

    • Default PLC does not exist in BILL_LAB_CAT table.
    Default Pay Type

    Error Message

    Meaning/Related Information

    Not found in PAY_TYPE table.

    IF - Default Pay Type is not null AND

    • Default Pay Type does not exist in PAY_TYPE table.

    Table: VE_LAB_INFO, Column DFLT_PAY_TYPE, Value <default pay type> truncated to 15 characters.

    Default Pay Type exceeds 15 characters.
    FieldDescription
    Default Invoice Rate
    Error MessageMeaning/Related Information
    Must exist in input file.Default Invoice Rate is null.
    Default Invoice Rate

    Warning Message

    Meaning/Related Information

    Not greater than zero.

    IF - Default Invoice Rate is not null AND

    • Default Invoice Rate <= 0.
    Detail Job Title Code

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Detail Job Title Code is null AND

    • T&E Employee ID in VEND_EMPL table or input file is not null
    • HR license = ON.

    Not found in DETL_JOB_TITLES table.

    IF - Detail Job Title Code is not null AND

    • Detail Job Title Code does not exist in DETL_JOB_TITLES table AND
    • HR license = ON.
    Manager ID

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Manager ID is null AND

    • T&E Employee ID in VEND_EMPL table or input file is not null

    Not found in EMPL table.

    IF - Manager ID is not null AND

    • Manager ID does not exist in EMPL table.
    FieldDescription
    Labor Location

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Labor Location is null AND

    • T&E Employee ID in VEND_EMPL table or input file is not null

    Not found in LAB_LOCATION table.

    IF - Labor Location is not null AND

    • Labor Location does not exist in LAB_LOCATION table.
    Work Schedule

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Work Schedule is null AND

    • Default Work Schedule in VEND_SETTINGS table is null AND
    • T&E Employee ID in VEND_EMPL table or input file is not null

    Not found in WORK_SCH table.

    IF - Work Schedule is not null AND

    • Work Schedule does not exist in WORK_SCH table.
    FieldDescription
    Timesheet Schedule

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Timesheet Schedule is null AND

    • Default Timesheet Schedule in VEND_SETTINGS table is null AND
    • T&E Employee ID in VEND_EMPL table or input file is not null
    Timesheet Class

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Timesheet Class is null AND

    • Default Timesheet Class in VEND_SETTINGS table is null AND
    • T&E Employee ID in VEND_EMPL table or input file is not null

    Not found in EMPL_CLASS table.

    IF - Timesheet Class is not null AND

    • Timesheet Class does not exist in EMPL_CLASS table.
    FieldDescription
    Expense Class Code

    Error Message

    Meaning/Related Information

    Required if T&E <employee> ID is not blank.

    IF - Expense Class is null AND

    • Default Expense Class in VEND_SETTINGS table is null AND
    • T&E Employee ID in VEND_EMPL table or input file is not null
    State/Province

    Error Message

    Meaning/Related Information

    Not found in MAIL_STATE table.

    IF - State/Province is not null AND

    • State/Province does not exist in MAIL_STATE table.
    FieldDescription
    Postal Code

    Error Message

    Meaning/Related Information

    Not found in POSTAL_CD table.

    IF - Postal Code is not null AND

    • Postal Code does not exist in POSTAL_CD table.
    Country Code

    Error Message

    Meaning/Related Information

    Not found in COUNTRY table.

    IF - Country Code is not null AND

    • Country Code does not exist in COUNTRY table.

    VE_LAB_TRN_RT

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Effective Start Date
    Error MessageMeaning/Related Information
    Must exist in input file.Effective Start Date is null.
    Vendor Employee ID, Vendor ID, Effective Start Date

    Error Message

    Meaning/Related Information

    Not found in VE_LAB_INFO input file and VE_LAB_INFO table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Effective Start Date is not null AND
    • (Vendor Employee ID + Vendor ID + Effective Start Date) does not exist in VE_LAB_INFO input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID + Effective Start Date) does not exist in VE_LAB_INFO table for current Company ID.
    Transactional Currency Code

    Error Message

    Meaning/Related Information

    Must exist in input file.

    IF Transactional Currency Code is null.

    Not found in CURRENCY table.

    IF - Transactional Currency Code is not null AND

    • Transactional Currency Code does not exist in CURRENCY table.
    Vendor Employee ID, Vendor ID, Effective Start Date, Transactional Currency Code

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Effective Start Date is not null AND
    • Transactional Currency Code is not null AND
    • (Vendor Employee ID + Vendor ID + Effective Start Date + Transactional Currency Code) is duplicated in input file for current Company ID.
    FieldDescription
    Default Transactional Invoice Rate
    Error MessageMeaning/Related Information
    Must exist in input file.IF Default Transactional Invoice Rate is null.
    Default Transactional Invoice Rate

    Warning Message

    Meaning/Related Information

    Not greater than zero.

    IF - Default Transactional Invoice Rate is not null AND

    • Default Transactional Invoice Rate <= 0.

    SEC_CLR

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Vendor Employee ID, Vendor ID

    Error Message

    Meaning/Related Information

    Not found in VEND_EMPL input file and VEND_EMPL table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
    Security Clearance Code

    Error Message

    Meaning/Related Information

    Must exist in input file.

    Security Clearance Code is null.

    Not found in SEC_CLR_SETTINGS table.

    IF - Security Clearance Code is not null AND

    • Security Clearance Code does not exist in SEC_CLR_SETTINGS table.
    Vendor Employee ID, Vendor ID, Security Clearance Code

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Security Clearance Code is not null AND
    • (Vendor Employee ID + Vendor ID + Security Clearance Code) is duplicated in input file for current Company ID.
    FieldDescription
    Issuing Agency
    Error MessageMeaning/Related Information
    Must exist in input file.IF Issuing Agency is null.

    SUBC_SCISAP_CLR

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Security Clearance Code
    Error MessageMeaning/Related Information
    Must exist in input file.Security Clearance Code is null.
    Vendor Employee ID, Vendor ID, Security Clearance Code

    Error Message

    Meaning/Related Information

    Not found in SEC_CLR input file and SEC_CLR table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Security Clearance Code is not null AND
    • (Vendor Employee ID + Vendor ID + Security Clearance Code) does not exist in VEND_EMPL input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID + Security Clearance Code) does not exist in VEND_EMPL table for current Company ID.
    SCI/SAP Clearance Code

    Error Message

    Meaning/Related Information

    Must exist in input file.

    SCI/SAP Clearance Code is null.

    Not found in SCISAP_CLR table.

    IF - SCI/SAP Clearance Code is not null AND

    • SCI/SAP Clearance Code does not exist in SCISAP_CLR table.
    Vendor Employee ID, Vendor ID, Security Clearance Code, SCI/SAP Clearance Code

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Security Clearance Code is not null AND
    • SCI/SAP Clearance Code is not null AND
    • (Vendor Employee ID + Vendor ID + Security Clearance Code + SCI/SAP Clearance Code) is duplicated in input file for current Company ID.
    FieldDescription
    SCI Granting Agency
    Error MessageMeaning/Related Information
    Must exist in input file.IF SCI Granting Agency is null.

    SUBC_SKILLS

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Vendor Employee ID, Vendor ID

    Error Message

    Meaning/Related Information

    Not found in VEND_EMPL input file and VEND_EMPL table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
    Skill ID

    Error Message

    Meaning/Related Information

    Must exist in input file.

    Skill ID is null.

    Not found in SKILL table.

    IF - Skill ID is not null AND

    • Skill ID does not exist in SKILL table.
    Vendor Employee ID, Vendor ID, Skill ID

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Skill ID is not null AND
    • (Vendor Employee ID + Vendor ID + Skill ID) is duplicated in input file for current Company ID.
    • Skill Level Code

    Error Message

    Meaning/Related Information

    Not found in H_SKILL_LVL table.

    IF - Skill Level Code is not null AND

    • Skill Level Code does not exist in H_SKILL_LVL table.

    SUBC_TRAININGS

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Vendor Employee ID, Vendor ID

    Error Message

    Meaning/Related Information

    Not found in VEND_EMPL input file and VEND_EMPL table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
    Training ID

    Error Message

    Meaning/Related Information

    Must exist in input file.

    IF Training ID is null.

    Not found in TRAINING table.

    IF - Training ID is not null AND

    • Training ID does not exist in TRAINING table.
    Vendor Employee ID, Vendor ID, Training ID

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Skill ID is not null AND
    • (Vendor Employee ID + Vendor ID + Training ID) is duplicated in input file for current Company ID.
    FieldDescription
    Training Source

    Error Message

    Meaning/Related Information

    Not found in TRAINING_SRCE table.

    IF - Training Source is not null AND

    • Training Source does not exist in TRAINING_SRCE table.
    Internal/External Training

    Error Message

    Meaning/Related Information

    Must be I or E.

    IF - Internal/External Training is not null AND

    • Internal/External Training <> I or E.
    • CEU Credits Earned

    Error Message

    Meaning/Related Information

    Negative numbers are not allowed.

    IF - CEU Credits Earned is not null AND

    • CEU Credits Earned < 0.

    SUBC_PROPERTY

    FieldDescription
    Vendor ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor ID is null.
    Vendor Employee ID
    Error MessageMeaning/Related Information
    Must exist in input file.Vendor Employee ID is null.
    Vendor Employee ID, Vendor ID

    Error Message

    Meaning/Related Information

    Not found in VEND_EMPL input file and VEND_EMPL table.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND
    • (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
    Property ID

    Error Message

    Meaning/Related Information

    Must exist in input file.

    Property ID is null.

    Not found in H_COMPANY_PROP table.

    IF - Property ID is not null AND

    • Property ID does not exist in H_COMPANY_PROP table.
    Vendor Employee ID, Vendor ID, Property ID

    Error Message

    Meaning/Related Information

    Input file contains duplicate record.

    IF - Vendor Employee ID is not null AND

    • Vendor ID is not null AND
    • Property ID is not null AND
    • (Vendor Employee ID + Vendor ID + Property ID) is duplicated in input file for current Company ID.
    FieldDescription
    Property Quantity
    Error MessageMeaning/Related Information
    Must exist in input file.Property Quantity is null.
    Property Ownership

    Error Message

    Meaning/Related Information

    Must be O or U.

    IF - Property Ownership is not null AND

    • Property Ownership <> O or U.
    Asset ID, Asset Item Number

    Error Message

    Meaning/Related Information

    Not found in ASSET table.

    IF - Asset ID is not null AND

    • Asset Item Number is not null AND
    • (Asset ID + Asset Item Number) does not exist in ASSET table for current Company ID.
    Issue Date
    Error MessageMeaning/Related Information
    Must exist in input file.Issue Date is null.

    Parent Topic:

    Related Topics for the Import Vendor Employees Screen