iWay Integration Solution for EDI X12 User's Guide > Tutorial: Mapping an IDOC to an Invoice Document (810) > Mapping the ITEM Detail

Mapping the ITEM Detail

This section describes how to map the ITEM detail.

Baseline Invoice Item Data (IT1)

  1. In the Output Tag Properties dialog box for the SG5 segment, set the context and looping.
  2. Map the Integer of the IDoc line number value to the IT102 element.
    @INT(INVOIC02/IDOC/E1EDP01/MENGE)
  3. If the length of the Unit of Measure is greater than 0, map to the IT103 element, otherwise, map the constant EA.
    @IF(@LEN(INVOIC02/IDOC/E1EDP01/MENEE) > '0',' INVOIC02/IDOC/E1EDP01/MENEE','EA')
  4. Trim leading spaces from the unit price and map it to the IT104 element.
    @LTRIM(INVOIC02/IDOC/E1EDP01/VPREI)
  5. Add an output group node to the IT1 segment and rename it to OUTPUT_GROUP_NODE.
  6. Use the Move Up option to position the new output group node under the IT104 element.
  7. In the Output Tag Properties dialog box for the OUTPUT_GROUP_NODE, set the following properties:
  8. Add an output group node to the IT1 segment and rename it to OUTPUT_PARENT_TAG.
  9. Use the Move Up option to position the new output group node under the IT105 element.
  10. In the Output Tag Properties dialog box for the OUTPUT_PARENT_TAG, set the following properties:
  11. Add an output group node to the IT1 segment and rename it to OUTPUT_GROUP_NODE.
  12. Use the Move Up option to position the new output group node under the IT106 element.
  13. In the Output Tag Properties dialog box for the OUTPUT_GROUP_NODE, set the following properties:
  14. Add an output group node to the IT1 segment and rename it to OUTPUT_PARENT_TAG.
  15. Use the Move Up option to position the new output group node under the IT107 element.
  16. In the Output Tag Properties dialog box for the OUTPUT_PARENT_TAG, set the following properties:

    Your iWay Integration Tool interface should resemble the following image:

  17. Map the Qualifier to the IT106 element.
    @IF(INVOIC02/IDOC/E1EDP01/E1EDP19/QUALF == '001',' IN','')
  18. Map the value to the IT107 element.
    @IF(INVOIC02/IDOC/E1EDP01/E1EDP19/QUALF == '001',' INVOIC02/IDOC/E1EDP01/E1EDP19/IDTNR ','')
  19. Map the qualifier constant to the IT108 element.
    @IF(INVOIC02/IDOC/E1EDP01/E1EDP19/QUALF == '003',' IN','')
  20. Map the IDoc value to the IT109 element.
    @IF(INVOIC02/IDOC/E1EDP01/E1EDP19/QUALF == '003',' INVOIC02/IDOC/E1EDP01/E1EDP19/IDTNR ','')

    Your iIT interface should resemble the following image:

Product Item Description Segment (PID)

  1. In the Output Tag Properties dialog box for the SG6 segment, set the looping.
  2. In the Output Tag Properties dialog box for the PID segment, set the following properties:
  3. Add an output group node to the PID segment and rename it to OUTPUT_PARENT_TAG.
  4. In the Output Tag Properties dialog box for the output group node, set the following properties:
  5. Map a constant F to the PID01 element.
  6. Map the following to the PID05 segment:
    @IF(INVOIC02/IDOC/E1EDP01/E1EDP19/QUALF == '002',INVOIC02/IDOC/E1EDP01/E1EDP19/KTEXT,'')

    Your iIT interface should resemble the following: