Outbound (Sales) (Outbound mapping)

Outbound (Sales)
Segment Element Attribute name Attribute value Default in Iptor WM1 DC1 mapping
          Note: Outbound orders can be created from:
– Sales orders  SROSNDSOH, SROSNDSOA, SROSNDSOL, SROSNDSOT when SROSNDSOH.OHOTIC=’1′
– Supplier return SROSNDPOH, SROSNDPOA, SROSNDPOL, SROSNDPOT when  SROSNDPOH.OHPTIC=’2′
<outboundOrderHeader>   action Sales order:
if srosndsoh.ohinta = “*CLOSE” then “*CHANGE” else srosndsoh.ohinta

Supplier return:
if srosndpoh.ohinta = “*CLOSE” then “*CHANGE” else srosndpoh.ohinta

  Note: Outbound order header can be created from:
– Sales orders  SROSNDSOH when SROSNDSOH.OHOTIC=’1′
– Supplier return SROSNDPOH when SROSNDPOH.OHPTIC=’2′
  <ownerCode>       srodic.dceown
  <outboundOrderSort>       if sales order (srosndsoh) then “SO”
if supplier return (srosndpoh) then “SR”
  <outboundOrderNumber>       srosndsoh.ohorno or srosndpoh.ohorno
  <warehouseCode>        
  <orderType>       srosndsoh.ohordt or srosndpoh.ohordt
  <businessPartnerCode>       srosndsoh.ohcuno or srosndpoh.ohsuno
  <addressNumber>       srosndsoh.ohdano or srosndpoh.ohsdan
  <invoiceBusinessPartnerCode>       srosndsoh.ohdeno or srosndpoh.ohsuno
  <transportCompanyCode>        
  <orderReference>       srosndsoh.ohoref or srosndpoh.ohoref
  <referenceOfOrigin>       srosndsoh.ohgdsm or srosndpoh.ohgdsm
  <referenceOfDestination>        
  <referenceOfProject>        
  <orderDate>       srosndsoh.ohodat or srosdnpoh.ohodat
  <waveTemplateCode>        
  <picklistTemplateCode>        
  <outboundTemplateCode>        
  <replenTemplateCode>        
  <routeCode>       srosndsoh.ohrout
  <orderPicking>        
  <dispatchCode>       sales order (srosndsoh): if srosndsoh.ohcmpd=’Y’ then 1 else 3
suppier return (srosndpoh): set value=2
  <dueDt>       srosndsoh.ohdelt or srosdnpoh.ohdelt
  <requestedDt>       srosndsoh.ohdelt or srosdnpoh.ohdelt
  <orderCat1>        
  <orderCat2>        
  <orderCat3>        
  <orderCat4>        
  <orderCat5>        
  <orderCat6>        
  <dockRelationCode>        
  <termsOfDeliveryCode>       srosndsoh.ohtodc or srosndpoh.ohtodc
  <mannerOfTransportCode>       srosndsoh.ohmotc or srosndpoh.ohmotc
  <termsOfPaymentCode>       srosndsoh.ohtopc or srosndpoh.ohtopc
  <currencyCode>       srosndsoh.ohpcur or srosndpoh.ohpcur
  <cashOnDelivery>        
  <hostReference>        
  <creationUserCode>        
  <responsibleUserCode>        
  <outboundOrderStatus>       Sales order:
if srosndsoh.ohords <=20 then 00 else if srosndsoh.ohords=60 then 90 else 30

Supplier return:
if srosndpoh.ohords <=20 then 00 else if srosndpoh.ohords=60 then 90 else 30

  <outboundOrderDetails>        
  <outboundOrderHeaderTexts>        
  <outboundOrderBusinessPartnerAddresses>        
  <outboundOrderStockProducts>        
           
<outboundOrderDetail>   action Sales order:
srosndsol.olinta
Note: olinta=*CLOSE shall not be processed

Supplier return:
srosndpol.olinta
Note: olinta=*CLOSE shall not be processed

  Note: Outbound order detail can be created from:
– Sales orders SROSNDSOL when SROORSHE.OHOTIC=’1′ where SROORSHE.OHORNO=SROSNDSOL.OLORNO
– Supplier return SROSNDPOL when SROORPHE.OHPTIC=’2′ where SROORPHE.OHORNO=SROSNDPOL.OLORNO
  <ownerCode>       srodic.dceown
  <outboundOrderSort>       if sales order (srosndsol) then “SO”
if supplier return (srosndpol) then “SR”
  <outboundOrderNumber>       srosndsol.olorno or srosndpol.olorno
  <outboundOrderLineNumber>       srosndsol.olline or srosndpol.olline
  <outboundOrderStatus>       sales order: if srosndsol.olords <=20 then 00 else 30
supplier return: if srosndpol.olords<=20 then 00 else 30
  <businessPartnerCode>       sroorshe.ohcuno where sroorshe.ohorno=srosndsol.olorno or
sroorphe.ohsuno where sroorphe.ohorno=srosndpol.olorno
  <addressNumber>       sroorshe.ohdano where sroorshe.ohorno=srosndsol.olorno or
sroorphe.ohsdan where sroorphe.ohorno=srosndpol.olorno
  <orderReference>       sroorshe.ohgdsm where sroorshe.ohorno=srosndsol.olorno or
sroorphe.ohgdsm where sroorphe.ohorno=srosndpol.olorno
  <referenceOfOrigin>        
  <referenceOfDestination>        
  <referenceOfProject>        
  <warehouseCode>       srosndsol.olsrom or srosndpol.olsrom
  <stockProductOwner>       srodic.dceown
  <itemCode>       srosndsol.olprdc or srosndpol.olprdc
  <productCode2>        
  <productCode3>        
  <productCode4>        
  <productCode5>        
  <productCode6>       sales order: if srosndsol.oltdcd=’Y’ then srosndsol.olorno + srosndsol.olline (example 00000001143700010)
supplier return: if srosndpol.olsorn<>0 then srosndpol.olsorn + srosndpol.olslin (example 00000001143700010)
  <productCode7>        
  <productCode8>        
  <handlingUnitCode>       srosndsol.olunit or srosndpol.olunit
  <itemDesc>       srosndsol.oldesc or srosndpol.oldesc
  <stockProductNature>       sales order: if srosndsol.oltbtcc=’Y’ or srosndsol.olsenc=’2′ then ‘G’ else ‘R’
supplier return: if srosndpol.olbtcc=’Y’ or srosndpol.olsenc=’2′ then ‘G’ else ‘R’
  <originalProductOwner>       srodic.dceown
  <originalItemCode>       srosndsol.olprdc or srosndpol.olprdc
  <originalProductCode2>        
  <originalProductCode3>        
  <originalProductCode4>        
  <originalProductCode5>        
  <originalProductCode6>       sales order: if srosndsol.oltdc=’Y’ then srosndsol.olorno + srosndsol.olline (example 00000001143700010)
supplier return:   if srosndpol.olsorn<>0 then srosndpol.olsorn + srosndpol.olslin (example 00000001143700010)
  <originalProductCode7>        
  <originalProductCode8>        
  <backlogAllowed>       0 (false)
  <backlogOnHost>       sales order: if srosndsol.olbalc=’Y then 1 else 0
supplier return: set value 0
  <orderPicking>        
  <orderedQty>       srosndsol.oloqty or srosndpol.olqstu
  <requestedQty>        
  <backorderQty>        
  <unitCode>       sales order: sroprg.pgstun where sroprg.pgprdc=srosndsol.olprdc
supplier return: sndpol.olstun
  <roundingQualifier>        
  <dueDateType>        
  <dueDt>       srosndsol.oldelt or srosndpol.oldelt
  <latestEndDt>       srosndpol.oldelt or srosndsol.oldelt
  <requestedDt>       sales order: srosndpol.olrddt
supplier return: sroorppl.olrddt where sroorppl.olorno=srosndpol.olorno and
sroorppl.olline=srosndpol.olline
  <transportCompanyCode>        
  <termsOfDeliveryCode>        
  <mannerOfTransportCode>        
  <packageTypeCode>       sales order: wmopry.pupatc where wmopry.pyprdc=srosndsol.olprdc
supplier return: wmopry.pupatc where wmopry.pyprdc=srosndpol.olprdc
  <routeCode>        
  <sequenceInRoute>        
  <reservationPriority>        
  <priorityIncrement>        
  <pickSequence>        
  <sequentialNumber>        
  <capacityParameter1>        
  <capacityParameter2>        
  <capacityParameter3>        
  <orderCat1>        
  <orderCat2>        
  <orderCat3>        
  <orderCat4>        
  <orderCat5>        
  <orderCat6>        
  <outboundUnitPrice>       srosndsol.olsalp or srosndpol.olpurp
  <lineAmount>       srosndsol.olamou or srosndpol.olamou
  <priceUnitCode>       srosndsol.olprcu
  <outboundLimitOnExpiryInDays>        
  <productExpiryTime>        
  <pickingInstruction>        
  <packingInstruction>        
  <shippingInstruction>        
  <reservationInventoryStatusCode>        
  <dockRelationCode>        
  <waveTemplateCode>        
  <picklistTemplateCode>        
  <outboundTemplateCode>        
  <replenTemplateCode>        
  <pickingGroupCode>        
  <hostReference>        
  <lineInBackorder>       sales order: if srosndsol.olorli<>0 then 1 else 0
supplier return: if srosndpol.olorli<>0 then 1 else 0
  <originalLineNumber>       srosndsol.olorli or srosndpol.olorli
  <referenceLineNumber>        
  <outboundLogisticGroupCode>        
  <workloadClassCode>        
  <workloadFactor>        
  <ifProcessing>       1 (true)
  <generateStockProduct>       if the line is a BtB transit delivery:
if srosndsol.oltdcd=’Y’ then true(1) else false(0)
if srosndpol.olsorn<>0 then true(1) else false(0)
  <productCode2>        
  <productCode3>        
  <productCode4>        
  <productCode5>        
  <productCode6>       sales order: if srosndsol.oltdc=’Y’ then srosndsol.olorno + srosndsol.olline (example 00000001143700010)
supplier return: if
srosndpol.olsorn<>0 then srosndpol.olsorn + srosndpol.olslin (example 00000001143700010)
  <productCode7>        
  <productCode8>        
  <expiryDt>        
  <stockProductDesc>       srosndsol.oldesc or srosndpol.oldesc
  <productLocationGroupUpdateAction>        
  <productLocationGroupCode>       wmopry.pyplgc where wmopry.pyprdc=srosndsol.olprdc / srosndpol.olprdc
  <productFamilyCode>        
  <abcCodeUpdateAction>        
  <abcCode>        
  <eanCode>       sroean.pjeanp where  sroean.pjprdc=srosndsol.olprdc / srosndpol.olprdc and sroean.pjunit=(sroprg.pgstun where
sroprg.pgprdc=srosndsol.olprdc/srosndpol.olprdc) and sroean.pjoutb=”Y”
  <eanAddon>        
  <stockProductNature>       if srosndsol.olsenc/srosndpol.olprdc<>”0″ (zero) or srosndsol.olbtcc/srosndpol.=”Y’ then “G” else “R”
  <pickingUnitCode>       sroprg.pgstun where sroprg.pgprdc=srosndsol.olprdc or
srosndpol.olstun
  <dimensionUnitCode>        
  <length>       sropru.pjleng where sropru.pjprdc=srosndsol.olprdc/srosndpol.olprdc and sropru.pjunit=srosndsol.olstun/srosndpol.olstun
  <width>       sropru.pjwidt where sropru.pjprdc=srosndsol.olprdc/srosndpol.olprdc and sropru.pjunit=srosndsol.olstun/srosndpol.olstun
  <height>       sropru.pjhigh where sropru.pjprdc=srosndsol.olprdc/srosndpol.olprdc and sropru.pjunit=srosndsol.olstun/srosndpol.olstun
  <volume>       srosndsol.olnvol or srosndpol.olnvol
  <weight>       srosndsol.olnwgt or srosndpol.olnwgt
  <tareWeight>        
  <standardUnitValue>       sroprg.pgstco where sroprg.pgprdc=srosndsol.olprdc/srosndpol.olprdc
  <inboundLimitOnExpiryInDays>        
  <outboundLimitOnExpiryInDays>       sroprg.pglsdy where sroprg.pgprdc=srosndsol.olprdc/srosndpol.olprdc
  <putawayGroupCode>        
  <pickingGroupCode>        
  <replGroupCode>        
  <productActive>       1 (true)
  <warehouseCode>       srosndsol.olsrom or srosndpol.olsrom
  <countingGroupCode>        
  <replPoint>       wmopry.pyrppt where wmopry.pyprdc=srosndsol.olprdc/srosndpol.olprdc
  <minReplQty>       wmopry.pymirq where wmopry.pyprdc=srosndsol.olprdc/srosndpol.olprdc
  <maxReplQty>       wmopry.pymarq where wmopry.pyprdc=srosndsol.olprdc/srosndpol.olprdc
  <safetyStockQty>        
           
<outboundOrderDetailText>   action srosndsot.otinta srosndpot.otinta   Note: Outbound order detail text can be created from:
– Sales orders  SROSNDSOT when SROORSHE.OHOTIC=’1′ where SROORSHE.OHORNO=SROSNDSOT.OTORNO and SROSNDSOT.OTLINE<>0
– Supplier return SROSNDPOT when SROORPHE.OHPTIC=’2′ where SROORPHE.OHORNO=SROSNDPOT.OTORNO and SROSNDPOT.OTLINE<>0
ownerCode <ownerCode>       srodic.dceown
outboundOrderSort <outboundOrderSort>       if sales order (srosndsol) then “SO”
if supplier return (srosndpol) then “SR”
outboundOrderNumber <outboundOrderNumber>       srosndsot.olorno or srosndpot.olorno
outboundOrderLineNumber <outboundOrderLineNumber>       srosndsot.olline
or srosndpot.olline
languageCode <languageCode>       sroorshe.ohlang where sroorshe.ohorno=srosndsot.otorno or
sroorphe.ohlang where sroorpe.ohorno=srosndpot.otorno
textNumber <textNumber>       srosndsot.ottlno or srosndpot.ottlno
textType <textType>       “T”
longText <longText>       srosndsot.ottx70 or srosndpot.ottx70
document1PrintText <document1PrintText>       srosndsot.ottpx1 or srosndpot.ottpx1
document2PrintText <document2PrintText>       srosndsot.ottpx2 or srosndpot.ottpx2
document3PrintText <document3PrintText>       srosndsot.ottpx3 or srosndpot.ottpx3
document4PrintText <document4PrintText>       srosndsot.ottpx4 or srosndpot.ottpx4
document5PrintText <document5PrintText>       srosndsot.ottpx5 or srosndpot.ottpx5
document6PrintText <document6PrintText>       srosndsot.ottpx6 or srosndpot.ottpx6
document7PrintText <document7PrintText>       srosndsot.ottpx7 or srosndpot.ottpx7
document8PrintText <document8PrintText>       srosndsot.ottpx8 or srosndpot.ottpx8
document9PrintText <document9PrintText>       srosndsot.ottpx9 or srosndpot.ottpx9
           
<outboundOrderHeaderText>   action srosndsot.otinta srosndpot.otinta   Note: Outbound order header text can be created from:
– Sales orders  SROSNDSOT when SROORSHE.OHOTIC=’1′ where SROORSHE.OHORNO=SROSNDSOT.OTORNO and SROSNDSOT.OTLINE=0
– Supplier return SROSNDPOT when SROORPHE.OHPTIC=’2′ where SROORPHE.OHORNO=SROSNDPOT.OTORNO and SROSNDPOT.OTLINE=0
  <ownerCode>       srodic.dceown
  <outboundOrderSort>       if sales order (srosndsol) then “SO”
if supplier return (srosndpol) then “SR”
  <outboundOrderNumber>       srosndsotolorno or srosndpot.olorno
  <languageCode>       sroorshe.ohlang where sroorshe.ohorno=srosndsot.otorno or
sroorphe.ohlang where sroorpe.ohorno=srosndpot.otorno
  <textNumber>       srosndsot.ottlno or srosndpot.ottlno
  <textType>       “T”
  <longText>       srosndsot.ottx70 or srosndpot.ottx70
  <document1PrintText>       srosndsot.ottpx1 or srosndpot.ottpx1
  <document2PrintText>       srosndsot.ottpx2 or srosndpot.ottpx2
  <document3PrintText>       srosndsot.ottpx3 or srosndpot.ottpx3
  <document4PrintText>       srosndsot.ottpx4 or srosndpot.ottpx4
  <document5PrintText>       srosndsot.ottpx5 or srosndpot.ottpx5
  <document6PrintText>       srosndsot.ottpx6 or srosndpot.ottpx6
  <document7PrintText>       srosndsot.ottpx7 or srosndpot.ottpx7
  <document8PrintText>       srosndsot.ottpx8 or srosndpot.ottpx8
  <document9PrintText>       srosndsot.ottpx9 or srosndpot.ottpx9
           
<address>         sales order: if srosndsoa.oaadty=’D’
supplier return; if srosndpoa.oaadty=’D’
  <ownerCode>       srodic.dceown
  <businessPartnerCode>       sroorshe.ohcuno where sroorshe.ohorno=srosndsoa.oaorno or
sroorphe.ohsuno where sroorphe.ohorno=srosndpoa.oaorno
  <businessPartnerName>       srosndsoa.oaname or srosndpoa.oaname
  <addressNumber>       sroorshe.ohdano where sroorshe.ohorno=srosndsoa.oaorno or
sroorphe.ohsdan where sroorphe.ohorno=srosndsoa.oaorno
  <contactPerson>        
  <addressLine1>       srosndsoa.oaadr1 or srosndpoa.oaadr1
  <addressLine2>       srosndsoa.oaadr2 or srosndpoa.oaadr2
  <addressLine3>       srosndsoa.oaadr3 or srosndpoa.oaadr3
  <addressLine4>       srosndsoa.oaadr4 or srosndpoa.oaadr4
  <postalCode>       srosndsoa.oapocd or srosndpoa.oapocd
  <countryCode>       srosndsoa.oacoun or srosndpoa.oacoun
  <languageCode>       sroorshe.ohlang where sroorshe.ohorno=srosndsot.otorno or
sroorphe.ohlang where sroorpe.ohorno=srosndpot.otorno
  <telephoneNumber>        
  <faxNumber>        
  <emailAddress>        
  <vatRegistrationNumber>        
  <eanAddressCode>        
  <consolAddressCode>        
  <layoutTypeCode>        
  <temporaryAddressFlag>       1 (true)