Action Sequence Action Type Parameters Action Description Sequence Event Name Handler Description 10 Set Values SETVARVALUES(vShipmentId = METHODPARM(1)) 101 IdoPostInvoke ue_FiresonShipConfirmation 20 Finish "CONDITION(METHOD() <> ""ShipConfirmationSp"" OR V(vShipmentId) = V(LastProcessedShipment))" 101 IdoPostInvoke ue_FiresonShipConfirmation 30 Load Collection "IDO(""SLShipmentSeqs"") PROPERTIES(""ShipmentId, ShipmentLine, ue_CoItemitemProductCode"") DISTINCT(FALSE) FILTER(SUBSTITUTE(""ShipmentId={0} AND (ue_CoItemitemProductCode IN ('01','02','03','04'))"", V(vShipmentId))) SET(R(ShipmentSeqs) = RESULT)" 101 IdoPostInvoke ue_FiresonShipConfirmation 40 Set Values SETVARVALUES(vldx = 1) 101 IdoPostInvoke ue_FiresonShipConfirmation 50 Set Values SETVARVALUES(vTotalRows = ROWS(ShipmentSeqs)) 101 IdoPostInvoke ue_FiresonShipConfirmation 60 Branch CONDITION(V(vldx) > V(vTotalRows))DEST(170) 101 IdoPostInvoke ue_FiresonShipConfirmation 70 Load IDO Row "IDO(""SLShipmentLines"")PROPERTIES(""RefNum, RefLineSuf, RefRelease, ShipmentLine"")FILTER(SUBSTITUTE(""ShipmentId = {0}"", V(vShipmentId))) ROW(V(vldx))SET(RV(vCoNum) = ""RefNum"", RV(vCoLine) = ""RefLineSuf"", RV(vCoRelease) = ""RefRelease"", RV(vShipmentLine) = ""ShipmentLine"")" 101 IdoPostInvoke ue_FiresonShipConfirmation 80 Load IDO Row "IDO(""SLShipmentSeqSerials"")PROPERTIES(""SerNum"")FILTER(SUBSTITUTE(""ShipmentId = {0} AND ShipmentLine = {1}"", V(vShipmentId), V(vShipmentLine)))SET(RV(vSerNum) = ""SerNum"")" 101 IdoPostInvoke ue_FiresonShipConfirmation 90 Branch "CONDITION(V(vSerNum) = """" OR V(vSerNum) = ""NULL"") DEST(150)" 101 IdoPostInvoke ue_FiresonShipConfirmation 100 Load IDO Row "IDO(""SLShipments"")PROPERTIES(""CustName, CustNum, CustSeq, ShipDate, CadName"")FILTER(SUBSTITUTE(""ShipmentId = {0}"", V(vShipmentId)))SET(RV(vShipToName) = ""CustName"", RV(vCadName) = ""CadName"", RV(vCustNum) = ""CustNum"", RV(vCustSeq) = ""CustSeq"", RV(vShipDate) = ""ShipDate"")" 101 IdoPostInvoke ue_FiresonShipConfirmation 110 Load IDO Row "IDO(""SLShipmentSeqs"")PROPERTIES(""CoNum, CoItem, ItemDescription"")FILTER(SUBSTITUTE(""ShipmentId = {0} AND ShipmentLine = {1}"", V(vShipmentId), V(vShipmentLine)))SET(RV(vCustOrdNum) = ""CoNum"", RV(vCoItem) = ""CoItem"", RV(vCoItmDescription) = ""ItemDescription"")" 101 IdoPostInvoke ue_FiresonShipConfirmation 120 Load IDO Row "IDO(""SLCos"")PROPERTIES(""CoNum, BillToName"")FILTER(SUBSTITUTE(""CoNum = '{0}'"", V(vCoNum)))SET(RV(vBillToName) = ""BillToName"")" 101 IdoPostInvoke ue_FiresonShipConfirmation 130 Load IDO Row "IDO(""SLCoitems"")PROPERTIES(""CoNum, CoLine, CoRelease, RefNum, RefLineSuf"")FILTER(SUBSTITUTE(""CoNum='{0}' AND CoLine='{1}' AND CoRelease='{2}'"", V(vCoNum), V(vCoLine), V(vCoRelease)))SET(RV(vJobNum) = ""RefNum"", RV(vSuffix) = ""RefLineSuf"")" 101 IdoPostInvoke ue_FiresonShipConfirmation 140 Send Email "TO(""xxx@xxxx.com"")SUBJECT(SUBSTITUTE(""ShipmentId {0} has been Shipped."", V(vShipmentId)))HTMLFORMAT(FALSE)BODY(SUBSTITUTE("" ShipmentId:{0} CustNum:{1} CustName:{2} ShipTo:{3} ShipToName:{4} CoNum:{5} CoLine:{6} CoRelease:{7} CoItem:{8} CoItemDescription:{9} SerNum:{10} Job:{11} Suffix:{12} ShipDate:{13}"", V(vShipmentId), V(vCustNum), V(vBillToName), V(vCustSeq), V(vShipToName), V(vCoNum), V(vCoLine), V(vCoRelease), V(vCoItem), V(vCoItmDescription), V(vSerNum), V(vJobNum), V(vSuffix), SUBSTRING(V(vShipDate), 1, 10)))" 101 IdoPostInvoke ue_FiresonShipConfirmation 150 Set Values "SETVARVALUES(vldx = 1 + V(vldx), vSerNum = """")" 101 IdoPostInvoke ue_FiresonShipConfirmation 160 Branch CONDITION(V(vldx) <= V(vTotalRows)) DEST(70) 101 IdoPostInvoke ue_FiresonShipConfirmation 170 Set Values SETVARVALUES(LastProcessedShipment = V(vShipmentId)) 101 IdoPostInvoke ue_FiresonShipConfirmation 180 Finish "RESULT(""Shipment Processed"")" 101 IdoPostInvoke ue_FiresonShipConfirmation