====== ProcessWeaver Integration ======

===== Overview =====

With the ProcessWeaver integration shipping labels can be obtained in Produmex WMS without having to use the two systems separately. 

The required product version is Produmex WMS 2021.03 or higher.

With the integration the ProcessWeaverHookScript is triggered after the SalesDeliveryCreatedHookScript in the following flows:
  * Ad Hoc Picking Flow
  * Bulk Shipping Flow
  * Mobile Packing Flow
  * Packing Flow
  * Shipping Flow
  * Picking Flow
  * Multi-Picking Flow
  * Zone Picking Flow
  * Box Pick and Pack Flow
  * Zone Box Picking Flow


===== Installation steps =====

====1. Edit workflow====

To install the ProcessWeaver integration the ProcessWeaverHookScript workflow must be edited by overwriting the existing content with the content of the received ProcessWeaverHookScript.

**Background**: Produmex WMS installs the script as a standard hook script. Hook scripts are called, or executed, from various points in Produmex WMS, but as delivered hook scripts do nothing and have no processing impact.  Hook scripts are designed to be modified by programmer-level technicians. To install the ProcessWeaver Integration the content of the standard ProcessWeaverHookScript is replaced with the content of a file that contains much of the actual ProcessWeaver integration logic. 

**Steps**: \\

1. Locate the file WorkflowScript_ProcessWeaverHookScript_Release.cs.

Base WMS installation folder > WorkflowScripts > WorkflowScript_ProcessWeaverHookScript

2. Open the file WorkflowScript_ProcessWeaverHookScript_Release.cs in a text editor e.g. Notepad.  

3. Select all text using Control-A or similar sequence supported by the text editor.

4. Copy the selected text using Control-C or similar sequence supported by the text editor.

5. Close the Notepad (or similar) window.

6. Go to Organizational Structure > Workflows tab and find the ProcessWeaverHookScript workflow.

{{:implementation:wms:workflows_processweaverhookscript.png|ProcessWeaverHookScript workflow}}

7. Click the ''Edit Script'' button.  The Workflow Script Editor window appears.

8. Select all text in the editor window.  Use the scrollbars to ensure that all text is selected.

9. Paste the text that was copied in the earlier step.

10. Insert the ProcessWeaver URL into the line:

<code sql> public const string PROCESSWEAVER_URL = “” </code>

Use the URL provided by ProcessWeaver [[http://74.205.51.116/ShippingAPI/Api/Ship|http://74.205.51.116/ShippingAPI/Api/Ship]]

11. Click the ''Validate'' button. The system displays the message //The script compiled successfully//. 

12. Click ''OK'' to save the script and close the Organizational Structure window.

Note: If a different message is displayed, click the ''Cancel'' button, and repeat the above mentioned steps to make sure that all the text indicated is selected.

====2. Execute SQL files====

The following two SQL files must be executed in your SAP Business One database where Produmex WMS is installed. 
  * PMX_PROCESSWEAVER_DATA.sql
  * PMX_PROCESSWEAVER_INTERNATIONAL_DATA.sql

**Steps:**

1. Obtain the .sql files from your Boyum support / service team member. 

2. Import the files into SQL Server Studio or Hana Studio.

3. Edit each of the imported view definitions in either SQL Server Studio or Hana Studio. For each of the view make the following changes:

{{:implementation:wms:functional:views2.png |Views and changes}}

4. Adjust the ship to address logic in both views to reflect the way customer addresses are managed in your system. E.g. some installations use SAP BO’s Address2 and Address3 as the address fields, other use different address fields.

5. Review the use of weight and dimension units of measure. ProcessWeaver allows only LBS and KGS for weight and IN and CM for linear dimensions. Update the views to output these units and recalculate the related values if Produmex WMS captures these values in other units.

===== Customization =====

The ProcessWeaverHookScript and the views can be customized. 

**Example of request:**

<code sql>
<?xml version="1.0" encoding="UTF-8"?>
<ShipRequest>
    <APIKey>TLo0bs73ebiBTFYUoySRFOuMPeUlOMQVgnmHSb5M/yw=</APIKey>
    <ENV>TEST</ENV>
    <LabelFormat>PNG</LabelFormat>
    <TotalWeight>10.00</TotalWeight>
    <ID_ReasonForExport>SALES</ID_ReasonForExport>
    <ID_TermsOfSales>DDP</ID_TermsOfSales>
    <CarrierDetails>
        <AccountNumber>510159020</AccountNumber>
        <Carrier>FEDEX</Carrier>
        <CustomerTransactionId/>
        <MeterNumber>1244649</MeterNumber>
        <Password>bzHVcz48ErlM8N4Lni8TxFk8H</Password>
        <ServiceType>INTERNATIONAL_ECONOMY</ServiceType>
        <ShipDate>2020-10-28</ShipDate>
        <UserID>R7iEGJlHgfWPDGjK</UserID>
        <PrinterID/>
    </CarrierDetails>
    <ShipFrom>
        <City>New York</City>
        <CompanyName>WMS trunk</CompanyName>
        <Contact/>
        <CountryCode>US</CountryCode>
        <Email>info@oec.com</Email>
        <Phone>(610) 768-7465</Phone>
        <PostalCode>10001</PostalCode>
        <StreetLine1>1901 Maynesboro Drive</StreetLine1>
        <StreetLine2/>
        <StreetLine3>Suite 200</StreetLine3>
        <StateOrProvinceCode>NY</StateOrProvinceCode>
    </ShipFrom>
    <ShipTo>
        <City>Ruiselede</City>
        <CompanyName>Norm Thompson</CompanyName>
        <Contact/>
        <CountryCode>BE</CountryCode>
        <Email/>
        <Phone>123456789</Phone>
        <PostalCode>8755</PostalCode>
        <StreetLine1>Kruiskerkestraat 15</StreetLine1>
        <StreetLine2/>
        <StreetLine3/>
        <StateOrProvinceCode/>
    </ShipTo>
    <PackageCount>3</PackageCount>
    <Packagedetails>
        <Packagedetails>
            <CODAmount/>
            <CODCurrencyCode/>
            <CUSTOMERREFERENCE>123456789000009077</CUSTOMERREFERENCE>
            <DimensionUnit>CM</DimensionUnit>
            <INVOICENUMBER/>
            <InsuranceAmount/>
            <InsuranceCurrencyCode/>
            <Length>0.00</Length>
            <Width>0.00</Width>
            <Height>0.00</Height>
            <PONUMBER/>
            <WeightUnits>Kg</WeightUnits>
            <WeightValue>10.00</WeightValue>
        </Packagedetails>
        <Packagedetails>
            <CODAmount/>
            <CODCurrencyCode/>
            <CUSTOMERREFERENCE>123456789000009930</CUSTOMERREFERENCE>
            <DimensionUnit>CM</DimensionUnit>
            <INVOICENUMBER/>
            <InsuranceAmount/>
            <InsuranceCurrencyCode/>
            <Length>0.00</Length>
            <Width>0.00</Width>
            <Height>0.00</Height>
            <PONUMBER/>
            <WeightUnits>Kg</WeightUnits>
            <WeightValue>10.00</WeightValue>
        </Packagedetails>
        <Packagedetails>
            <CODAmount/>
            <CODCurrencyCode/>
            <CUSTOMERREFERENCE>123456789000020072</CUSTOMERREFERENCE>
            <DimensionUnit>CM</DimensionUnit>
            <INVOICENUMBER/>
            <InsuranceAmount/>
            <InsuranceCurrencyCode/>
            <Length>0.00</Length>
            <Width>0.00</Width>
            <Height>0.00</Height>
            <PONUMBER/>
            <WeightUnits>Kg</WeightUnits>
            <WeightValue>10.00</WeightValue>
        </Packagedetails>
    </Packagedetails>
    <Paymentinformation>
        <PayerAccountNumber>510159020</PayerAccountNumber>
        <PayerCountryCode>BE</PayerCountryCode>
        <PaymentType>SENDER</PaymentType>
    </Paymentinformation>
    <InternationalDetail>
        <ID_ReasonForExport>SALES</ID_ReasonForExport>
        <ID_TermsOfSales>DDP</ID_TermsOfSales>
        <Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>1.00</NumberOfPieces>
                <Quantity>1.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>EUROPALLET</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>2.00</NumberOfPieces>
                <Quantity>2.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00001</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>3.00</NumberOfPieces>
                <Quantity>3.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00002</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>1.00</NumberOfPieces>
                <Quantity>1.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>EUROPALLET</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>2.00</NumberOfPieces>
                <Quantity>2.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00001</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>3.00</NumberOfPieces>
                <Quantity>3.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00002</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>1.00</NumberOfPieces>
                <Quantity>1.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>EUROPALLET</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>2.00</NumberOfPieces>
                <Quantity>2.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00001</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>3.00</NumberOfPieces>
                <Quantity>3.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00002</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
        </Commodities>
        <DutiesPayment>
            <ResponsiblePartyPaymentType>RECIPIENT</ResponsiblePartyPaymentType>
            <ResponsiblePartyAccountNumber>123456789</ResponsiblePartyAccountNumber>
        </DutiesPayment>
    </InternationalDetail>
</ShipRequest>
</code>

**Link between views and the request:**

VIEW_NAME (standard = "PMX_PROCESSWEAVER_DATA")

VIEW_NAME_INT (standard = "PMX_PROCESSWEAVER_INTERNATIONAL_DATA")

<code sql>
<?xml version="1.0" encoding="UTF-8"?>
<ShipRequest>
    <APIKey>TLo0bs73ebiBTFYUoySRFOuMPeUlOMQVgnmHSb5M/yw=</APIKey>
    <ENV>TEST</ENV>
    <LabelFormat>PNG</LabelFormat>
    <TotalWeight>10.00</TotalWeight>
    <ID_ReasonForExport>SALES</ID_ReasonForExport>
    <ID_TermsOfSales>DDP</ID_TermsOfSales>
    <CarrierDetails>
        <AccountNumber>510159020</AccountNumber>
        <Carrier>FEDEX</Carrier>
        <CustomerTransactionId/>
        <MeterNumber>1244649</MeterNumber>
        <Password>bzHVcz48ErlM8N4Lni8TxFk8H</Password>
        <ServiceType>INTERNATIONAL_ECONOMY</ServiceType>
        <ShipDate>2020-10-28</ShipDate>
        <UserID>R7iEGJlHgfWPDGjK</UserID>
        <PrinterID/>
    </CarrierDetails>
    <ShipFrom>
        <City>New York</City>
        <CompanyName>WMS trunk</CompanyName>
        <Contact/>
        <CountryCode>US</CountryCode>
        <Email>info@oec.com</Email>
        <Phone>(610) 768-7465</Phone>
        <PostalCode>10001</PostalCode>
        <StreetLine1>1901 Maynesboro Drive</StreetLine1>
        <StreetLine2/>
        <StreetLine3>Suite 200</StreetLine3>
        <StateOrProvinceCode>NY</StateOrProvinceCode>
    </ShipFrom>
    <ShipTo>
        <City>Ruiselede</City>
        <CompanyName>Norm Thompson</CompanyName>
        <Contact/>
        <CountryCode>BE</CountryCode>
        <Email/>
        <Phone>123456789</Phone>
        <PostalCode>8755</PostalCode>
        <StreetLine1>Kruiskerkestraat 15</StreetLine1>
        <StreetLine2/>
        <StreetLine3/>
        <StateOrProvinceCode/>
    </ShipTo>
    <PackageCount>3</PackageCount>
    <Packagedetails>
        <Packagedetails>
            <CODAmount/>
            <CODCurrencyCode/>
            <CUSTOMERREFERENCE>123456789000009077</CUSTOMERREFERENCE>
            <DimensionUnit>CM</DimensionUnit>
            <INVOICENUMBER/>
            <InsuranceAmount/>
            <InsuranceCurrencyCode/>
            <Length>0.00</Length>
            <Width>0.00</Width>
            <Height>0.00</Height>
            <PONUMBER/>
            <WeightUnits>Kg</WeightUnits>
            <WeightValue>10.00</WeightValue>
        </Packagedetails>
        <Packagedetails>
            <CODAmount/>
            <CODCurrencyCode/>
            <CUSTOMERREFERENCE>123456789000009930</CUSTOMERREFERENCE>
            <DimensionUnit>CM</DimensionUnit>
            <INVOICENUMBER/>
            <InsuranceAmount/>
            <InsuranceCurrencyCode/>
            <Length>0.00</Length>
            <Width>0.00</Width>
            <Height>0.00</Height>
            <PONUMBER/>
            <WeightUnits>Kg</WeightUnits>
            <WeightValue>10.00</WeightValue>
        </Packagedetails>
        <Packagedetails>
            <CODAmount/>
            <CODCurrencyCode/>
            <CUSTOMERREFERENCE>123456789000020072</CUSTOMERREFERENCE>
            <DimensionUnit>CM</DimensionUnit>
            <INVOICENUMBER/>
            <InsuranceAmount/>
            <InsuranceCurrencyCode/>
            <Length>0.00</Length>
            <Width>0.00</Width>
            <Height>0.00</Height>
            <PONUMBER/>
            <WeightUnits>Kg</WeightUnits>
            <WeightValue>10.00</WeightValue>
        </Packagedetails>
    </Packagedetails>
    <Paymentinformation>
        <PayerAccountNumber>510159020</PayerAccountNumber>
        <PayerCountryCode>BE</PayerCountryCode>
        <PaymentType>SENDER</PaymentType>
    </Paymentinformation>
    <InternationalDetail>
        <ID_ReasonForExport>SALES</ID_ReasonForExport>
        <ID_TermsOfSales>DDP</ID_TermsOfSales>
        <Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>1.00</NumberOfPieces>
                <Quantity>1.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>EUROPALLET</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>2.00</NumberOfPieces>
                <Quantity>2.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00001</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>3.00</NumberOfPieces>
                <Quantity>3.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00002</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>1.00</NumberOfPieces>
                <Quantity>1.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>EUROPALLET</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>2.00</NumberOfPieces>
                <Quantity>2.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00001</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>3.00</NumberOfPieces>
                <Quantity>3.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00002</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>1.00</NumberOfPieces>
                <Quantity>1.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>EUROPALLET</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>2.00</NumberOfPieces>
                <Quantity>2.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00001</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
            <Commodities>
                <Description>SALES</Description>
                <NumberOfPieces>3.00</NumberOfPieces>
                <Quantity>3.00</Quantity>
                <QuantityUnits>Manual</QuantityUnits>
                <CountryOfManufacture>US</CountryOfManufacture>
                <UnitPrice>0.00</UnitPrice>
                <HarmonizeCode>9999999999</HarmonizeCode>
                <PartNumber>00002</PartNumber>
                <Weight>1.00</Weight>
                <WeightUnits>Kg</WeightUnits>
            </Commodities>
        </Commodities>
        <DutiesPayment>
            <ResponsiblePartyPaymentType>RECIPIENT</ResponsiblePartyPaymentType>
            <ResponsiblePartyAccountNumber>123456789</ResponsiblePartyAccountNumber>
        </DutiesPayment>
    </InternationalDetail>
</ShipRequest>
</code>

**Link between the script and the view:**

<code sql>
url to processweaver api
public const string PROCESSWEAVER_URL = "http://74.205.51.116/ShippingAPI/Api/Ship";

Link to the view name 
public const string VIEW_NAME = "PMX_PROCESSWEAVER_DATA"; -> view name
public const string VIEW_NAME_INT = "PMX_PROCESSWEAVER_INTERNATIONAL_DATA"; view name of international 

prefix of the columnames
public const string VIEW_PREFIX_CARRIER_DETAILS = "CD_";
public const string VIEW_PREFIX_PACKAGE_DETAILS = "PD_";
public const string VIEW_PREFIX_SHIP_FROM = "SF_";
public const string VIEW_PREFIX_SHIP_TO = "ST_";
public const string VIEW_PREFIX_PAYMENT_INFORMATION = "PI_";
public const string VIEW_PREFIX_COMMODITIES = "COM_";
public const string VIEW_PREFIX_INTERNATIONAL_DETAIL = "ID_";
public const string VIEW_PREFIX_DUTIESPAYMENT = "DP_";


supported tagnames
public const string PROCESSWEAVER_XMLNODE_DOCENTRY = "DocEntry";
public const string PROCESSWEAVER_XMLNODE_SHIPREQUEST = "ShipRequest";
public const string PROCESSWEAVER_XMLNODE_CARRIER_DETAILS = "CarrierDetails";
public const string PROCESSWEAVER_XMLNODE_SHIPFROM = "ShipFrom";
public const string PROCESSWEAVER_XMLNODE_SHIPTO = "ShipTo";
public const string PROCESSWEAVER_XMLNODE_PACKAGE_DETAILS = "Packagedetails";
public const string PROCESSWEAVER_XMLNODE_PACKAGECOUNT = "PackageCount";
public const string PROCESSWEAVER_XMLNODE_PAYMENTINFORMATION = "Paymentinformation";
public const string PROCESSWEAVER_XMLNODE_INTERNATIONALDETAIL = "InternationalDetail";
public const string PROCESSWEAVER_XMLNODE_COMMODITIES = "Commodities";
public const string PROCESSWEAVER_XMLNODE_DUTIESPAYMENT = "DutiesPayment";

columnnames that has to be converted to certain format
public const string PROCESSWEAVER_CONVERT_TO_DECIMAL = "PD_Length,PD_WeightValue,PD_Height,PD_Width,TotalWeight,COM_Weight,COM_UnitPrice,COM_NumberOfPieces,COM_Quantity"; -> 
public const string PROCESSWEAVER_CONVERT_TO_DATE = "CD_ShipDate";

format
public const string PROCESSWEAVER_DATE_FORMAT = "yyyy-MM-dd";
public const string PROCESSWEAVER_DECIMAL_FORMAT = "0.00";
</code>

**Changing the layout of the request** 

Example: Adding tag “test” to shipFrom taggroup

  * Add columname SF_test to view PMX_PROCESSWEAVER_DATA
  * SF_ > prefix of ship from tag (see definition part in the script)
  * test > tag name

<code sql>
<ShipFrom>
        <City>New York</City>
        <CompanyName>WMS trunk</CompanyName>
        <Contact/>
        <CountryCode>US</CountryCode>
        <Email>info@oec.com</Email>
        <Phone>(610) 768-7465</Phone>
        <PostalCode>10001</PostalCode>
        <StreetLine1>1901 Maynesboro Drive</StreetLine1>
        <StreetLine2/>
        <StreetLine3>Suite 200</StreetLine3>
        <StateOrProvinceCode>NY</StateOrProvinceCode>
        <test></test>
    </ShipFrom>
</code>