Business Rules
• Either Vendor Name or Vendor Last Name and Vendor First Name fields must be filled.
• If Vendor Name field is entered, Vendor First Name and Vendor Last Name fields must be blank.
• If Vendor First Name and Vendor Last Name fields have been entered, the Vendor Name field must be blank.
• Tax number must be 9-digits and cannot be all zeros.
• The first three digits of an SSN cannot be '000' or '666.
• The middle two digits of an SSN cannot be '00.
• The last four digits of an SSN cannot be '0000.
• The first two digits of a FEIN cannot be '00.
• The vendor's Tax Number must be unique unless it is a division of a parent vendor.
• Vendors of type 'Purchase Order' must have an address of the type 'Purchase Order.
• Vendors of type 'Disbursement Voucher' must have an address of the type 'Remit.
• A vendor must have one and only one address marked as a default address.
• If a country for an address is 'United States' then state and zip code are required.
• Phone and fax numbers must be formatted as ###-###-####.
• If the Category Allowed Indicator for a specific ownership type is 'N' (No) then vendor category must be left blank.
• If the SSN Allowed Indicator for this ownership type is 'N' (No) then the tax number type must not be SSN.
• If the FEIN Allowed Indicator for this ownership type is 'N' (No) then the tax number type must not be FEIN.
• Contract begin date must be earlier than contract end date.
• The Conflict of Interest tab is available only for ‘parent’ vendor records.
• Conflict of Interest is required if vendor type is ‘Purchase Order’.
• Conflict of Interest tab can have only one field populated, either ‘Employee of Conflict’ or ‘Other’.
• If Conflict of Interest data is entered, the ‘Origin Date’ is required.
• If Conflict of Interest data is entered, the ‘COI Last Signature Date’ is required.
• COI Last Signature Date cannot occur before the ‘Origin Date’.
• COI Last Signature Date cannot be future dated.
• The Criminal Background Check tab is available for both ‘parent’ and ‘child’ vendor records.
• Criminal Background Check Required is required if vendor type matches the value set in the Criminal_Background_Check_Required_Vendor_Types parameter.
• CBC Last Signature Date is required if CBC Required field is set to ‘Yes’.
• CBC Last Signature Date must be today or past date; cannot be future dated.
• The Supplier Diversity tab is available only for ‘parent’ vendor records.
• Supplier Diversity Certification field is required if the Supplier Diversity value is set to a non-null value.
• Supplier Diversity Start Date is required if the Certification value is set to a non-null value.
• Supplier Diversity Start Date must be today or past date; cannot be future dated.
• Do not allow for duplicate Supplier Diversity records unless Start Dates do not overlap.
• Supplier Diversity End Date is required if Certification field is set to ‘Certified’.
• Supplier Diversity End Date allows for previous or future date.
• The Sustainability tab is available for both ‘parent’ and ‘child’ vendor records.
Routing