Inbound (Purchase) (Outbound mapping)

Inbound (Purchase)
Segment	Element	Attribute name	Attribute value	Default in Iptor WM1	DC1 mapping
					Note: Inbound orders can be created from: – Purchase orders SROSNDPOH, SROSNDPOA, SROSNDPOL, SROSNDPOT when SROSNDPOH.OHPTIC=’1′ – Customer return SROSNDSOH, SROSNDSOA, SROSNDSOL, SROSNDSOT when SROSNDSOH.OHOTIC=’2′
<inboundOrderHeader>		action	Purchase order: if srosndpoh.ohinta = “CLOSE” then “CHANGE” else srosndpoh.ohinta Customer return: if srosndsoh.ohinta = “CLOSE” then “CHANGE” else srosndsoh.ohinta		Note: Inbound order header can be created from: – Purchase orders SROSNDPOH when SROSNDPOH.OHPTIC=’1′ – Customer return SROSNDSOH when SROSNDSOH.OHOTIC=’2′
	<ownerCode>				srodic.dceown
	<inboundOrderSort>				if purchase order (srosndpoh) then “PO” if customer return (srosndsoh) then “CR”
	<inboundOrderNumber>				srosndpoh.ohorno or srosndsoh.ohorno
	<warehouseCode>
	<orderType>				srosndpoh.ohordt or srosndsoh.ohordt
	<businessPartnerCode>				srosndpoh.ohsuno or srosndsoh.ohcuno
	<addressNumber>				srosndpoh.ohsdan or srosndsoh.ohdano
	<transportCompanyCode>
	<orderDate>				srosndpoh.ohodat or srosdnsoh.ohodat
	<referenceOfOrigin>				srosndpoh.ohgdsm or srosndsoh.ohgdsm
	<referenceOfDestination>
	<referenceOfProject>
	<dueDt>				srosndpoh.ohdelt or srosndsoh.ohdelt
	<orderCat1>
	<orderCat2>
	<orderCat3>
	<orderCat4>
	<orderCat5>
	<orderCat6>
	<termsOfDeliveryCode>				srosndpoh.ohtodc or srosndsoh.ohtodc
	<mannerOfTransportCode>				srosndpoh.ohmotc or srosndsoh.ohmotc
	<termsOfPaymentCode>				srosndpoh.ohtopc or srosndsoh.ohtopc
	<currencyCode>				srosndpo.ohpcur or srosndsoh.ohpcur
	<creationUserCode>
	<responsibleUserCode>
	<inputLocationCode>
	<generateTask>				1 (true)
	<hostReference>
	<inboundOrderStatus>				Purchase order: if srosndpoh.ohords <=20 then 00 else if srosndpoh.ohords = 60 then 90 else 30 Customer return: if srosndsoh.ohords <=20 then 00 else if srosndsoh.ohords = 60 then 90 else 30

<inboundOrderDetail>		action	Purchase order: srosndpol.olinta Note: olinta=CLOSE shall not be processed Customer return: srosndsol.olinta Note: olinta=CLOSE shall not be processed		Note: Inbound order detail can be created from: – Purchase orders SROSNDPOL when SROORPHE.OHPTIC=’1′ where SROORPHE.OHORNO=SROSNDPOL.OLORNO – Customer return SROSNDSOL when SROORSHE.OHOTIC=’2′ where SROORSHE.OHORNO=SROSNDSOL.OLORNO
	<ownerCode>				srodic.dceown
	<inboundOrderSort>				if purchase order (srosndpol) then “PO” if customer return (srosndsol) then “CR”
	<inboundOrderNumber>				srosndpol.olorno or srosndsol.olorno
	<inboundOrderLineNumber>				srosndpol.olline or srosndsol.olline
	<inboundOrderStatus>				if srosndpol.olords <=20 then 00 else 30 / if srosndsol.olords <=20 then 00 else 30
	<businessPartnerCode>				sroorphe.ohsuno where sroorphe.ohorno=srosndpol.olorno or sroorshe.ohcuno where sroorshe.ohorno=srosndsol.olorno
	<addressNumber>				sroorphe.ohsdan where sroorphe.ohorno=srosndpol.olorno or sroorshe.ohdano where sroorshe.ohorno=srosndsol.olorno
	<referenceOfOrigin>				sroorphe.ohgdsm where sroorphe.ohorno=srosndpol.olorno or sroorshe.ohgdsm where sroorshe.ohorno=srosndsol.olorno
	<referenceOfDestination>
	<referenceOfProject>
	<transportCompanyCode>
	<warehouseCode>				srosndpol.olsrom or srosndsol.olsrom
	<stockProductOwner>				srodic.dceown
	<itemCode>				srosndpol.olprdc or srosndsol.olprdc
	<productCode2>
	<productCode3>
	<productCode4>
	<productCode5>
	<productCode6>				purchase order: if srosndpol.olsorn<>0 then srosndpol.olsorn + srosndpol.olslin (example 00000001143700010) customer return: if srosndsol.oltdc=’Y’ then srosndsol.olporn + srosndsol.olplin (example 00000001143700010)
	<productCode7>
	<productCode8>
	<handlingUnitCode>				srosndpol.olunit or srosndsol.olunit
	<itemDesc>				srosndpol.oldesc or srosndsol.oldesc
	<originalProductOwner>				srodic.dceown
	<originalItemCode>				srosndpol.olprdc or srosndsol.olprdc
	<originalProductCode2>
	<originalProductCode3>
	<originalProductCode4>
	<originalProductCode5>
	<originalProductCode6>				purchase order: if srosndpol.olsorn<>0 then srosndpol.olsorn + srosndpol.olslin (example 00000001143700010) customer return: if srosndsol.oltdc=’Y’ then srosndsol.olporn + srosndsol.olplin (example 00000001143700010)
	<originalProductCode7>
	<originalProductCode8>
	<backlogAllowed>				0 (false)
	<stockProductNature>				purchase order: if srosndpol.olbtcc=’Y’ or srosndpol.olsenc=’2′ then ‘G’ else ‘R’ customer return: if srosndsol.olbtcc=’Y’ or srosndsol.olsenc=’2′ then ‘G’ else ‘R’
	<orderedQty>				srosndpol.olqstu or srosndsol.oloqty
	<unitCode>				srosndpol.olstun or sroprg.pgstun where sroprg.pgprdc=srosndsol.olprdc
	<dueDt>				srosndpol.oldelt or srosndsol.oldelt
	<latestEndDt>
	<orderCat1>
	<orderCat2>
	<orderCat3>
	<orderCat4>
	<orderCat5>
	<orderCat6>
	<inboundUnitPrice>				srosndpol.olpurp or srosndsol.olsalp
	<lineAmount>				srosndpol.olamou or srosndsol.olamou
	<priceUnitCode>
	<inboundLimitOnExpiryInDays>
	<productExpiryTime>
	<receivingInstruction>
	<generateTask>				1 (true)
	<receptionInventoryStatusCode>
	<sampleRule>
	<sampleQty>
	<hostReference>
	<closeOrder>
	<lowerMarginPerc>
	<upperMarginPerc>
	<lowerMarginQty>
	<upperMarginQty>
	<lineInBackorder>				0 (false)
	<inboundLogisticGroupCode>
	<workloadClassCode>
	<workloadFactor>
	<ifProcessing>				0 (false)
	<generateStockProduct>				If the purchase order line is a BtB transit delivery: if srosndpol.olsorn<>0 then true(1) else false(0)
	<productCode2>
	<productCode3>
	<productCode4>
	<productCode5>
	<productCode6>				purchase order: if srosndpol.olsorn<>0 then srosndpol.olsorn + srosndpol.olslin (example 00000001143700010) customer return: if srosndsol.oltdc=’Y’ then srosndsol.olporn + srosndsol.olplin (example 00000001143700010)
	<productCode7>
	<productCode8>
	<expiryDt>
	<stockProductDesc>				srosndpol.oldesc or srosndsol.oldesc
	<productLocationGroupUpdateAction>
	<productLocationGroupCode>				wmopry.pyplgc where wmopry.pyprdc=srosndpol.olprdc / srosndsol.olprdc
	<productFamilyCode>
	<abcCodeUpdateAction>
	<abcCode>
	<eanCode>				sroean.pjeanp where sroean.pjprdc=srosndpol.olprdc / srosndsol.olprdc and sroean.pjunit=(sroprg.pgstun where sroprg.pgprdc=srosndpol.olprdc/srosndsol.olprdc) and sroean.pjoutb=”Y”
	<eanAddon>
	<stockProductNature>				if srosndpol.olsenc/srosndsol.olprdc<>”0″ (zero) or srosndpol.olbtcc/srosndsol.=”Y’ then “G” else “R”
	<pickingUnitCode>				srosndpol.olstun or sroprg.pgstun where sroprg.pgprdc=srosndsol.olprdc
	<dimensionUnitCode>
	<length>				sropru.pjleng where sropru.pjprdc=srosndpol.olprdc / srosndsol.olprdc and sropru.pjunit=srosndpol.olstun / srosndsol.olprdc
	<width>				sropru.pjwidt where sropru.pjprdc=srosndpol.olprdc / srosndsol.olprdc and sropru.pjunit=srosndpol.olstun / srosndsol.olprdc
	<height>				sropru.pjhigh where sropru.pjprdc=srosndpol.olprdc / srosndsol.olprdc and sropru.pjunit=srosndpol.olstun / srosndsol.olprdc
	<volume>				srosndpol.olnvol or srosndsol.olnvol
	<weight>				srosndpol.olnwgt or srosndsol.olnwgt
	<tareWeight>
	<standardUnitValue>				sroprg.pgstco where sroprg.pgprdc=srosndpol.olprdc / srosndsol.olprdc
	<inboundLimitOnExpiryInDays>
	<outboundLimitOnExpiryInDays>				sroprg.pglsdy where sroprg.pgprdc=srosndpol.olprdc / srosndsol.olprdc
	<putawayGroupCode>
	<pickingGroupCode>
	<replGroupCode>
	<productActive>				1 (true)
	<warehouseCode>				srosndpol.olsrom or srosndsol.olsrom
	<countingGroupCode>
	<replPoint>				wmopry.pyrppt where wmopry.pyprdc=srosndpol.olprdc / srosndsol.olprdc
	<minReplQty>				wmopry.pymirq where wmopry.pyprdc=srosndpol.olprdc / srosndsol.olprdc
	<maxReplQty>				wmopry.pymarq where wmopry.pyprdc=srosndpol.olprdc / srosndsol.olprdc
	<safetyStockQty>

<inboundOrderDetailText>		action	srosndpot.otinta srosndsot.otinta		Note: Inbound order detail text can be created from: – Purchase orders SROSNDPOT when SROORPHE.OHOTIC=’1′ where SROORPHE.OHORNO=SROSNDPOT.OTORNO and SROSNDPOT.OTLINE<>0 – Customer return SROSNDSOT when SROORSHE.OHPTIC=’2′ where SROORSHE.OHORNO=SROSNDSOT.OTORNO and SROSNDSOT.OTLINE<>0
	<ownerCode>				srodic.dceown
	<inboundOrderSort>				if purchase order (srosndpot) then “PO” if customer return (srosndsot) then “CR”
	<inboundOrderNumber>				srosndpot.otorno or srosndsot.otorno
	<inboundOrderLineNumber>				srosndpot.otline or srosndsot.otline
	<languageCode>				sroorphe.ohlang where sroorphe.ohorno=srosndpot.otorno or sroorshe.ohlang where sroorshe.ohorno=srosndsot.otorno
	<textNumber>				srosndpot.ottlno or srosndsot.ottlno
	<textType>				“T”
	<longText>				srosndpot.ottx70 or srosndsot.ottx70
	<document1PrintText>				srosndpot.ottpx1 or srosndsot.ottpx1
	<document2PrintText>				srosndpot.ottpx2 or srosndsot.ottpx2
	<document3PrintText>				srosndpot.ottpx3 or srosndsot.ottpx3
	<document4PrintText>				srosndpot.ottpx4 or srosndsot.ottpx4
	<document5PrintText>				srosndpot.ottpx5 or srosndsot.ottpx5
	<document6PrintText>				srosndpot.ottpx6 or srosndsot.ottpx6
	<document7PrintText>				srosndpot.ottpx7 or srosndsot.ottpx7
	<document8PrintText>				srosndpot.ottpx8 or srosndsot.ottpx8
	<document9PrintText>				srosndpot.ottpx9 or srosndsot.ottpx9

<inboundOrderHeaderText>		action	srosndpot.otinta srosndsot.otinta		Note: Inbound order header text can be created from: – Purchase orders SROSNDPOT when SROORPHE.OHOTIC=’1′ where SROORPHE.OHORNO=SROSNDPOT.OTORNO and SROSNDPOT.OTLINE=>0 – Customer return SROSNDSOT when SROORSHE.OHPTIC=’2′ where SROORSHE.OHORNO=SROSNDSOT.OTORNO and SROSNDSOT.OTLINE=>0
	<ownerCode>				srodic.dceown
	<inboundOrderSort>				if purchase order (srosndpot) then “PO” if customer return (srosndsot) then “CR”
	<inboundOrderNumber>				srosndpot.otorno or srosndsot.otorno
	<languageCode>				sroorphe.ohlang where sroorphe.ohorno=srosndpot.otorno or sroorshe.ohlang where sroorshe.ohorno=srosndsot.otorno
	<textNumber>				srosndpot.ottlno or srosndsot.ottlno
	<textType>				“T”
	<longText>				srosndpot.ottx70 or srosndsot.ottx70
	<document1PrintText>				srosndpot.ottpx1 or srosndsot.ottpx1
	<document2PrintText>				srosndpot.ottpx2 or srosndsot.ottpx2
	<document3PrintText>				srosndpot.ottpx3 or srosndsot.ottpx3
	<document4PrintText>				srosndpot.ottpx4 or srosndsot.ottpx4
	<document5PrintText>				srosndpot.ottpx5 or srosndsot.ottpx5
	<document6PrintText>				srosndpot.ottpx6 or srosndsot.ottpx6
	<document7PrintText>				srosndpot.ottpx7 or srosndsot.ottpx7
	<document8PrintText>				srosndpot.ottpx8 or srosndsot.ottpx8
	<document9PrintText>				srosndpot.ottpx9 or srosndsot.ottpx9
<address>					Note: Inbound order address can be created from: – Purchase orders SROSNDPOA when SROORPHE.OHPTIC=’1′ where SROORPHE.OHORNO=SROSNDPOA.OAORNO and SROSNDPOA.OAADTY=’D’ – Customer return SROSNDSOA when SROORSHE.OHOTIC=’2′ where SROORSHE.OHORNO=SROSNDSOA.OAORNO and SROSNDSOA.OAADTY=’D’
	<ownerCode>				srodic.dceown
	<businessPartnerCode>				sroorphe.ohsuno where sroorphe.ohorno=srosndpoa.oaorno or sroorshe.ohcuno where sroorshe.ohorno=srosndsoa.oaorno
	<businessPartnerName>				srosndpoa.oaname or srosndsoa.oaname
	<addressNumber>				sroorphe.ohsdan where sroorphe.ohorno=srosndsoa.oaorno or sroorshe.ohdano where sroorshe.ohorno=srosndsoa.oaorno
	<contactPerson>
	<addressLine1>				srosndpoa.oaadr1 or srosndsoa.oaadr1
	<addressLine2>				srosndpoa.oaadr2 or srosndsoa.oaadr2
	<addressLine3>				srosndpoa.oaadr3 or srosndsoa.oaadr3
	<addressLine4>				srosndpoa.oaadr4 or srosndsoa.oaadr4
	<postalCode>				srosndpoa.oapocd or srosndsoa.oapocd
	<countryCode>				srosndpoa.oacoun or srosndsoa.oacoun
	<languageCode>				sroorphe.ohlang where sroorphe.ohorno=srosndpoa.oaorno or sroorshe.ohlang where sroorshe.ohorno=srosndsoa.oaorno
	<telephoneNumber>
	<faxNumber>
	<emailAddress>
	<vatRegistrationNumber>
	<eanAddressCode>
	<consolAddressCode>
	<layoutTypeCode>
	<temporaryAddressFlag>				1(true)