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)