• Vendor ID is not null AND
• Vendor ID contains invalid characters.

• Vendor ID is not null AND
• Vendor ID does not exist in VEND table.

Must have a parent record.

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

• 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.

• Vendor Employee ID is not null AND
• Vendor Employee ID contains invalid characters.

• 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.

• 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.

• Last Name is null AND
• Vendor Employee is new.

• First Name is null AND
• Vendor Employee is new.

• Vendor Employee Status is not null AND
• Vendor Employee Status <> A or I.

• T&E Employee ID is not null AND
• T&E Employee ID contains invalid characters.

• T&E Employee ID is not null AND
• T&E Employee ID exists in VEND_EMPL input file for another Vendor Employee ID.

• T&E Employee ID is not null AND
• T&E Employee ID exists in VEND_EMPL table for another Vendor Employee ID.

T&E Employee ID is not null AND

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

• 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 is null AND
• Vendor Employee Approver ID is not null AND
• Vendor Employee Requires Approval in AP_SETTINGS

• 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:

1. Set it to A, if the Subcontractor Vendor Employee Approval - Requires Approval check box in Configure Accounts Payable Settings is not selected.
2. Set it to P, if the Subcontractor Vendor Employee Approval - Requires Approval check box in Configure Accounts Payable Settings is selected.

• 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).

• 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).

• 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 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 is null AND
• T&E Employee ID in VEND_EMPL table or input file is not null

• Default GLC is not null AND
• Default GLC does not exist in GEN_LAB_CAT table.

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

• Default PLC is not null AND
• Default PLC does not exist in BILL_LAB_CAT table.

• Default Pay Type is not null AND
• Default Pay Type does not exist in PAY_TYPE table.

• Default Invoice Rate is not null AND
• Default Invoice Rate <= 0.

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

• 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 is null AND
• T&E Employee ID in VEND_EMPL table or input file is not null

• Manager ID is not null AND
• Manager ID does not exist in EMPL table.

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

• Labor Location is not null AND
• Labor Location does not exist in LAB_LOCATION table.

• 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

• Work Schedule is not null AND
• Work Schedule does not exist in WORK_SCH table.

• 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 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

• Timesheet Class is not null AND
• Timesheet Class does not exist in EMPL_CLASS table.

• 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 is not null AND
• State/Province does not exist in MAIL_STATE table.

• Postal Code is not null AND
• Postal Code does not exist in POSTAL_CD table.

• Country Code is not null AND
• Country Code does not exist in COUNTRY table.

• 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 is not null AND
• Transactional Currency Code does not exist in CURRENCY table.

• 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.

• Default Transactional Invoice Rate is not null AND
• Default Transactional Invoice Rate <= 0.

• 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 is not null AND
• Security Clearance Code does not exist in SEC_CLR_SETTINGS table.

• 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.

• 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 is not null AND
• SCI/SAP Clearance Code does not exist in SCISAP_CLR table.

• 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.

• 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 is not null AND
• Skill ID does not exist in SKILL table.

• 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 is not null AND
• Skill Level Code does not exist in H_SKILL_LVL table.

• 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 is not null AND
• Training ID does not exist in TRAINING table.

• 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.

• Training Source is not null AND
• Training Source does not exist in TRAINING_SRCE table.

• Internal/External Training is not null AND
• Internal/External Training <> I or E.

• CEU Credits Earned is not null AND
• CEU Credits Earned < 0.

• 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 is not null AND
• Property ID does not exist in H_COMPANY_PROP table.

• 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.

• Property Ownership is not null AND
• Property Ownership <> O or U.

• 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.