MAS Integration

Within the MAS intergation settings

---

Web.Config Settings

   <add key="PortalOrdersListMAS" value="PortalOrdersListMAS"/>
   <add key="MASIntegration" value="True" />
   <add key="OrdersListLinkField" value="SalesOrderNo" />
   <add key="OrdersListIdfield" value="SalesOrderNo" />
   <add key="OrdersListSummaryPage" value="ordersummary.aspx" />
   <add key="ar_customer" value="MAS_TST.dbo.ar_customer" />
   <add key="so_salesorderhistoryheader" value="MAS_TST.dbo.so_salesorderhistoryheader" />
   <add key="so_salesOrderHistoryDetail" value="MAS_TST.dbo.so_salesOrderHistoryDetail" />
   <add key="PortalOrdersScreenMAS" value="PortalOrdersScreenMAS" />
   <add key="so_salesOrderHistoryDetail_fieldlist" value="ItemCode as OrIt_LineItemID, SequenceNo as OrIt_linenumber,ItemCodeDesc as OrIt_description, as OrIt_uomid,QuantityShipped as OrIt_quantity,UnitCost  as OrIt_listprice,UnitCost as OrIt_quotedprice,LineDiscountPercent as OrIt_discount,(UnitCost * QuantityShipped) as OrIt_quotedpricetotal" />
   <add key="so_salesOrderHistoryDetail_orderby" value="LineKey" />
   <add key="so_salesOrderHistoryDetail_total" value="sum(LastUnitPrice * QuantityShipped) as OrIt_quotedpricetotal" />
   <add key="so_salesOrderHistoryDetail_filter" value=" " />
   <add key="so_salesOrderHistoryDetail_endtotals" value="salesorderno as Orde_OrderQuoteID,sum(UnitCost * QuantityShipped) as Orde_nettamt,  as Orde_DiscountType,  as Orde_DiscountPC, as Orde_discountamt,  as orde_grossamt" />
   <add key="so_salesOrderHistoryDetail_groupby" value="group by SalesOrderNo"/>