It’s possible to write many types of sql expressions, example:1.“retwho_assort_node_char_api.get_value('PS1',':assortment_id',':assortment_node_id')|| retwho_assort_node_char_api.get_value('PS2',':assortment_id',':assortment_node_id')|| retwho_assort_node_char_api.get_value('PS3',':assortment_id',':assortment_node_id')|| retwho_assort_node_char_api.get_value('PS4',':assortment_id',':assortment_node_id')“2.“to_char(to_date(Retwho_Util_Api.Get_Week_Date('*', retwho_assort_node_char_api.get_value('WEEK_IN_STORE', ':assortment_id',':assortment_node_id'), 2, replace(retwho_assort_node_char_api.get_value('LIFE_CYCLE', ':assortment_id',':assortment_node_id'),',','.')*7, 0), 'YYYY-MM-DD'),'IYYYIW')“3“SELECT min(retwho_assortment_node_api.get_value(':assortment_id',':assortment_node_id', 'LIST_PRICE_SUPPLIER', vendor_no, ''))INTO :result_FROM retwho_assortment_supplierWHERE assortment_id = ':assortment_id'AND assortment_node_id = ':assortment_node_id'AND rownum = 1“4“SELECT DECODE(retwho_assort
The extension components “IFS for Retail” does not have any integration messages for shipment
The box tab on shipment will show boxes on the customer order line(s) connected to the shipment.Parts/Items on customer order lines get connections to box if the box was added to the customer order.So if the customer order line(s) then are connected to the shipment the box information can be shown on the tab.
For the retail industries there is a base line component WMSINT that contain 6 messages to make the integration work between IFS and a WMS work smoothly. The principle of the integration is this: The messages are these: Part Catalog The message contains item information needed by the warehouse in order to know the characteristics of the item like volume, weight etc. Inbound delivery The items coming into the warehouse expressed in IFS Applications as a purchase order or a RMA. Outbound delivery The items leaving the warehouse expressed in IFS Applications as a customer order, supplier return or a supplier material order. Inbound Delivery confirmation When the goods have arrived the WMS signals this and the item is received into IFS Applications. outbound delivery confirmation When the WMS starts the delivery process it usually sends a zero quantity delivered or a status “Started” to IFS Application and then it is known to the IFS user that the delivery has started. When the
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
