| 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: |
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: |
||||
| <outboundOrderDetails> | |||||
| <outboundOrderHeaderTexts> | |||||
| <outboundOrderBusinessPartnerAddresses> | |||||
| <outboundOrderStockProducts> | |||||
| <outboundOrderDetail> | action | Sales order: srosndsol.olinta Note: olinta=*CLOSE shall not be processed Supplier return: |
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) | ||||
- Home
- /
- References
- /
- Technical References
- /
- WMS Integration
- /
- WMS mapping
- /
- Outbound mapping to Dynaman
- /
- Outbound (Sales) (Outbound mapping)