6.1 – Map Transform

Adding Fields to the Dataset

Before we use the aggregate transform to create the shipping records, we need to add several fields to the dataset to prepare the orders so they can be imported into Sage.

Map > Field Mapping

  1. Re-open the Map transform and click on the Field Mapping tab.
  2. Create these new fields in the ‘Orders’ transaction:
  1. Field Name
    • Warehouse
  2. Field Type
    • Text
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • WAREHOUSE
  1. Field Name
    • UseInvoiceAddress
  2. Field Type
    • Boolean
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • False
  1. Field Name
    • Sage200OrderNumber
  2. Field Type
    • Text
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • <Empty>

  1. Press Refresh.

  2. Change the transaction type to ‘OrderDetails’.



  3. Create three fields the for Order Comment and Charges:
  1. Field Name
    • LineType
  2. Field Type
    • Integer
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • 0
  1. Field Name
    • StoredCharge
  2. Field Type
    • Decimal
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • <Empty>
  1. Field Name
    • StoredValue
  2. Field Type
    • Decimal
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • <Empty>
  1. Refresh, save & close.

  1. Save the integration.
Step 6.2: Aggregate Transform >