NOT EXISTS (SELECT a.C_OrderLine_ID FROM WM_DeliveryScheduleLine b WHERE b.C_OrderLine_ID=a.C_OrderLine_ID)
!|Login|
|User |GardenAdmin|
|Password |GardenAdmin|
|AD_ClIEnT_id|@Ref=AD_Client[Value='GardenWorld'].AD_Client_ID|
|AD_Role_id |@Ref=AD_Role[Name='GardenWorld Admin'].AD_Role_ID |
|AD_Org_ID|@Ref=AD_Org[Name='HQ'].AD_Org_ID |
|M_Warehouse_id |@Ref=M_Warehouse[Name='HQ Warehouse'].M_Warehouse_ID |
|*Login* | |
!|Read Record|
|*Table* |WM_Gate|
|WM_Gate_ID|@Ref=WM_Gate[Name='Gate 1'].WM_Gate_ID|
|*Read*||
!|ReadInfoWindow|
|*InfoWindow*|Orders to Delivery Schedule|
|*WHERE*|b.IsSOTrx='N'|
!|RunProcess|
|*ProcessValue*|CreateDeliverySchedule|
|WM_Gate_ID|@WM_Gate.WM_Gate_ID@|
|*Run*||
!|Read Record|
|*Table* |WM_DeliverySchedule|
|WM_Gate_ID|@Ref=WM_Gate[Name='Gate 1'].WM_Gate_ID|
|*Read*||
|WM_DeliverySchedule_ID||
!|Read Record|
|*Table* |WM_HandlingUnit|
|WM_HandlingUnit_ID|@Ref=WM_HandlingUnit[Name='HU01'].WM_HandlingUnit_ID|
|*Read*||
|WM_HandlingUnit_ID||
!|ReadInfoWindow|
|*InfoWindow*|Delivery Schedule to Putaway/Picking|
|*WHERE*|b.IsSOTrx='N'|
!|RunProcess|
|*ProcessValue*|CreatePutawayList|
|WM_HandlingUnit_ID|@WM_HandlingUnit.WM_HandlingUnit_ID@|
|IsSameLine|Y|
|*Run*||
!|Set DocAction|
|*Table*|WM_DeliverySchedule|
|WM_DeliverySchedule_ID|@WM_DeliverySchedule.WM_DeliverySchedule_ID@|
|docAction |CO |
|*Save* | |
!|Read Record|
|*Table* |WM_HandlingUnit|
|WM_HandlingUnit_ID|@Ref=WM_HandlingUnit[Name='HU01'].WM_HandlingUnit_ID|
|*Read*||
!|ReadInfoWindow|
|*InfoWindow*|Putaway/Picking Info-Window|
|*WHERE*|b.IsSOTrx='N'|
!|RunProcess|
|*ProcessValue*|AssignHandlingUnit|
|WM_HandlingUnit_ID|@WM_HandlingUnit.WM_HandlingUnit_ID@|
|IsSameDistribution|N|
|*Run*||
!|Read Record|
|*Table* |WM_Gate|
|WM_Gate_ID|@Ref=WM_Gate[Name='Gate 2'].WM_Gate_ID|
|*Read*||
|WM_Gate_ID||
!|Read Record|
|*Table* |WM_HandlingUnit|
|WM_HandlingUnit_ID|@Ref=WM_HandlingUnit[Name='HU01'].WM_HandlingUnit_ID|
|*Read*||
|WM_HandlingUnit_ID||
!|ReadInfoWindow|
|*InfoWindow*|Orders to Delivery Schedule|
|*WHERE*|b.IsSOTrx='Y'|
!|RunProcess|
|*ProcessValue*|CreateDeliverySchedule|
|WM_Gate_ID|@WM_Gate.WM_Gate_ID@|
|*Run*||
!|Read Record|
|*Table* |WM_DeliverySchedule|
|WM_Gate_ID|@Ref=WM_Gate[Name='Gate 2'].WM_Gate_ID|
|*Read*||
|WM_DeliverySchedule_ID||
!|Read Record|
|*Table* |WM_InOut|
|WM_Gate_ID|@Ref=WM_Gate[Name='Gate 1'].WM_Gate_ID|
|*Read*||
|WM_InOut_ID||
!|Set DocAction|
|*Table*|WM_InOut|
|WM_InOut_ID|@WM_InOut.WM_InOut_ID@|
|docAction |CO |
|*Save* | |
!|Read Record|
|*Table* |WM_Gate|
|WM_Gate_ID|@Ref=WM_Gate[Name='Gate 2'].WM_Gate_ID|
|*Read*||
|WM_Gate_ID||
!|Read Record|
|*Table* |WM_HandlingUnit|
|WM_HandlingUnit_ID|@Ref=WM_HandlingUnit[Name='HU01'].WM_HandlingUnit_ID|
|*Read*||
|WM_HandlingUnit_ID||
!|ReadInfoWindow|
|*InfoWindow*|Delivery Schedule to Putaway/Picking|
|*WHERE*|b.IsSOTrx='Y'|
!|RunProcess|
|*ProcessValue*|CreatePutawayList|
|WM_HandlingUnit_ID|@WM_HandlingUnit.WM_HandlingUnit_ID@|
|IsSameDistribution|Y|
|IsSameLine|N|
|*Run*||
!|Set DocAction|
|*Table*|WM_DeliverySchedule|
|WM_DeliverySchedule_ID|@WM_DeliverySchedule.WM_DeliverySchedule_ID@|
|docAction |CO |
|*Save* | |
!|ReadInfoWindow|
|*InfoWindow*|Putaway/Picking Info-Window|
|*WHERE*|b.IsSOTrx='Y'|
!|RunProcess|
|*ProcessValue*|AssignHandlingUnit|
|WM_HandlingUnit_ID|@WM_HandlingUnit.WM_HandlingUnit_ID@|
|IsSameDistribution|N|
|*Run*||
PUCRHASING STORAGE LINE
!|Read Record|
|*Table* |WM_EmptyStorageLine|
|M_Product_ID|@Ref=M_Product[Name='Azalea Bush'].M_Product_ID|
|isSOTrx|'N'|
|*Read*||
|DateStart||
|DateEnd||
|QtyMovement||
|WM_HandlingUnit_ID||
LOCATOR STORAGE
!|Read Record|
|*Table* |WM_EmptyStorage|
|WM_EmptyStorage_ID|@WM_EmptyStorageLine.WM_EmptyStorage_ID@|
|*Read*||
|M_Locator_ID||
|AvailableCapacity||
|Percentage||
|IsFull||
LOCATOR INFO
!|Read Record|
|*Table* |M_Locator|
|M_Locator_ID|@WM_EmptyStorage.M_Locator_ID@|
|*Read*||
|Value||
STORAGE LINK
!|Read Record|
|*Table* |WM_ESLine|
|WM_EmptyStorageLine_ID|@WM_EmptyStorageLine.WM_EmptyStorageLine_ID@|
|*Read*||
|Value||
|Processed||
WM INOUT LINE
!|Read Record|
|*Table* |WM_InOutLine|
|M_Product_ID|@Ref=M_Product[Name='Azalea Bush'].M_Product_ID|
|WM_HandlingUnit_ID|@WM_EmptyStorageLine.WM_HandlingUnit_ID@|
|*Read*||
|M_InOutLine_ID||
MATERIAL RECEIPT LINE
!|Read Record|
|*Table*|M_InOutLine|
|M_InOutLine_ID|@WM_InOutLine.M_InOutLine_ID@|
|M_Product_ID|@Ref=M_Product[Name='Azalea Bush'].M_Product_ID|
|*Read*||
|M_InOut_ID||
|C_UOM_ID||
MATERIAL RECEIPT
!|Read Record|
|*Table*|M_InOut|
|M_InOut_ID|@M_InOutLine.M_InOut_ID@|
|*Read*||
|Updated||
|AD_Org_ID||
|C_Order_ID||
|IsSOTrx||
SALES STORAGE LINE
!|Read Record|
|*Table* |WM_EmptyStorageLine|
|M_Product_ID|@Ref=M_Product[Name='Azalea Bush'].M_Product_ID|
|isSOTrx|'Y'|
|WM_EmptyStorage_ID|@WM_EmptyStorage.WM_EmptyStorage_ID@|
|*Read*||
|DateStart||
|DateEnd||
|QtyMovement||
|WM_HandlingUnit_ID||
!|Read Record|
|*Table* |WM_EmptyStorageLine|
|M_Product_ID|@Ref=M_Product[Name='Plum Tree'].M_Product_ID|
|QtyMovement|2|
|isSOTrx|'Y'|
|*Read*||
|DateStart||
|DateEnd||
|WM_HandlingUnit_ID||
PURCHASE STORAGE LINE
!|Read Record|
|*Table* |WM_EmptyStorageLine|
|M_Product_ID|@Ref=M_Product[Name='Weeder'].M_Product_ID|
|isSOTrx|'N'|
|*Read*||
|DateStart||
|DateEnd||
|QtyMovement||
|WM_HandlingUnit_ID||
!|Roll Back|
|*Commit*|True|
Users browsing this forum: No registered users and 1 guest