Validating Data Example

For this example you need to map the customer product code from the Product/Service ID to the customer product code field (CUSTPROCODE) on the application side of the map. To ensure that the data that is mapped from the Product/Service ID element really is your partner’s customer product code, you need to establish and use a code table with the Product Service ID Qualifier.

Use this procedure to validate the data in the Product/Service ID field against a code list table.

  1. Load the code list table from the standard for the Product/Service ID Qualifier element.
    Note: The standards provide code list tables only for elements that use them. For example, in the TD4 segment, the TD401 (Special Handling Code) and TD403 (Hazardous Material Class Code) have code tables provided by the standard.
  2. Define a code list table for the Product/Service ID Qualifier element that only contains the code value "BP" (Buyer’s Part Number).
  3. Double-click the element for which you need to validate data against a code table (Product/Service ID Qualifier).

    The system displays the Element Properties dialog box.

  4. Select the Standard Rule tab.
  5. From the standard rule list, select Use Code.
  6. From the code list, select the code list table that the data in this field is validated against (0235).
  7. If you need to specify that, for compliance reasons, the element must contain one of the codes from the specified table (nothing else is valid for that field), select the compliance error check box.
  8. Click OK to add this standard rule to the field.