getOrderPriceUE
Las correlaciones de GetOrderPriceUE permiten que los pedidos creados en Sterling Order Management o Sterling Call Center recuperen precios unitarios, descuentos de promoción, regalos gratuitos e información de descuento de promoción de envío de HCL Commerce.
correlaciones de solicitud getOrderPrice
Estas son las correlaciones de solicitud getOrderPrice:
Sterling Order ManagementVía de acceso de API | HCL Commerce vía de acceso |
---|---|
ORDER | |
codificación en XSLT de transformación (ProcessOrder/Calculate) | Process/ActionCriteria/ActionExpression@actionCode |
Order/@OrderReference | Order/ OrderIdentifier/ExternalOrderID |
Order/@OrderNo | Order/OrderIdentifier/UniqueID |
Order/@BuyerUserID | Order/BuyerIdentifier/ExternalIdentifier/Identifier |
Order/@Currency | Order/OrderAmount/TotalProductPrice/@Currency |
Order/@CustomerId | |
Order/@OrganizationCode | Order/StoreIdentifier/UniqueID Utilice el archivo de correlación de atributos común, ValueMaps. XML, para implementar esta correlación. |
Order/@EnterpriseCode | |
<PaymentMethod CheckReference="" CreditCardName="" CreditCardType="" CustomerAccountNo="" DisplayCustomerAccountNo="" DisplayPaymentReference1="" DisplaySvcNo="" PaymentReference1="" PaymentReference2="" PaymentReference3="" PaymentType="">, obtenga la modalidad de pago según la CreditCardName y el tipo de pago para obtener PaymentMethodName | Order/OrderPaymentInfo/PaymentInstructionType/PaymentMethod/PaymentMethodName Use el archivo general de correlación de atributos, ValueMaps.xml, para implementar esta correlación. Si la correlación no existe, la solicitud getOrderPrice se utiliza directamente. |
Order/@DocumentType | |
Order/@PricingDate | Order/CalculationInfo/PricingDate |
Order/@RunCatalogOnlyRules | Estos elementos/atributos no se utilizan en getOrderPrice. |
Order/@SuggestManualRuleAdjustments | |
Order/@SuppressRuleExecution | |
Order/@SuppressShipping | |
Order/SelectionCriteria/PersonInfo/@AddressLine1 | Los cargos de envío no están soportados en la versión actual; se ha cancelado la correlación de direcciones. |
Order/SelectionCriteria/PersonInfo/@AddressLine2 | |
Order/SelectionCriteria/PersonInfo/@AddressLine3 | |
Order/SelectionCriteria/PersonInfo/@AddressLine4 | |
Order/SelectionCriteria/PersonInfo/@AddressLine5 | |
Order/SelectionCriteria/PersonInfo/@AddressLine6 | |
Order/SelectionCriteria/PersonInfo/@AlternateEmailID | |
Order/SelectionCriteria/PersonInfo/@Beeper | |
Order/SelectionCriteria/PersonInfo/@City | |
Order/SelectionCriteria/PersonInfo/@Company | |
Order/SelectionCriteria/PersonInfo/@Country | |
Order/SelectionCriteria/PersonInfo/@LastName | |
Order/SelectionCriteria/PersonInfo/@MiddleName | |
Order/SelectionCriteria/PersonInfo/@PersonID | |
Order/SelectionCriteria/PersonInfo/@PreferredShippingAddress | |
Order/SelectionCriteria/PersonInfo/@State | |
Order/SelectionCriteria/PersonInfo/@TaxGeoCode | |
Order/SelectionCriteria/PersonInfo/@ZipCode | |
Pasa usageIds/if para Sterling Order Management, solo se da soporte al ajuste de descuento y de envío en la versión actual. Los cargos de envío están fuera del ámbito. | Order/CalculationInfo/Usage= -1,-7 |
Correlación de códigos de hardware en el archivo de transformación, puesto que el precio se actualizará siempre por omisión = AlwaysUpdate | Order/CalculationInfo/PriceUpdateFlag (NeverUpdate, AlwaysUpdate, UpdateIfExpired) |
Order/ManualRuleAdjustments/ManualRuleAdjustment/@Adjustment | ManualRuleAdjustment no está soportado en la versión actual. |
Order/ManualRuleAdjustments/ManualRuleAdjustment/@PricingRuleKey | |
Order/ManualRuleAdjustments/ManualRuleAdjustment/@PricingRuleName | |
Order/ManualAdjustments/ManualAdjustment/@Adjustment | Order/CalculationInfo/ExtraAdjustment/AdjustmentApplyAmount |
Order/ ManualAdjustments/ ManualAdjustment/@AdjustmentID | Order/CalculationInfo/ExtraAdjustments/CalculationCodeIdentifier/UniqueID |
Solo se da soporte a la sustitución fija en el release actual; codificar esta correlación en el archivo de transformación. | Pedido/CalculationInfo/extraadjusts/AdjustmentApplyPolicy (1) sustitución fija |
codificación falsa | Order/CalculationInfo/ExtraAdjustment/IsOverrideExistingAdjustment |
Order/Shipping/@CarrierServiceCode | Order/OrderShippingInfo/ShippingMode Use el archivo general de correlación de atributos, ValueMaps.xml, para implementar esta correlación |
Order/Shipping/Carrier | Order/OrderShippingInfo/Carrier |
Order/Shipping/@MinimizeNumberOfShipments | (no se utiliza) |
Order/Shipping/@ShippingCharge | Order/OrderShippingInfo/TotalShippingCharge |
ORDER LINE/ORDER ITEM | |
Order/OrderLines/OrderLine/Shipping/@CarrierServiceCode | Order/OrderItem/OrderItemShippingInfo/ShippingMode |
Order/OrderLines/OrderLine/Shipping/Carrier | Order/OrderItem/OrderItemShippingInfo/Carrier |
Order/OrderLines/OrderLine/Shipping/@ShippingCharge | Order/OrderItem/OrderItemShippingInfo/TotalShippingCharge |
Order/OrderLines/OrderLine/@DeliveryMethod(shipment, pickup, delivery) | |
Order/OrderLines/OrderLine/@EligibleForShippingDiscount | |
Order/OrderLines/OrderLine/@IsLinePriceForInformationOnly | |
Order/OrderLines/OrderLine/@IsPriceLocked | Order/OrderItem/OrderItemAmount/@priceOverride |
La transformación se realiza en el archivo de transformación de WebSphere Enterprise Service Bus; Redacte ItemIds en el componente de OrderItem utilizando ParentLineId. | Order/OrderItem/OrderItemComponent |
ItemID(partnumber) | Order/OrderItem/CatalogEntryIdentifier/UniqueID |
Order/OrderLines/OrderLine/@ItemID | Order/OrderItem/CatalogEntryIdentifier/ExternalIdentifier/partnumber |
Order/OrderLines/OrderLine/@LineID | Order/OrderItem/OrderItemIdentifier/ExternalOrderItemID |
Order/OrderLines/OrderLine/@Quantity | Order/OrderItem/Quantity |
Order/OrderLines/OrderLine/@UnitOfMeasure | Order/OrderItem/Quantity/@UOM Use el archivo general de correlación de atributos, ValueMaps.xml, para implementar esta correlación |
<Awards><Award AwardAmount="" AwardApplied="" AwardId="" AwardKey="" AwardType="" ChargeCategory="" ChargeName="" DenialReason="" Description="" IsPromotionOnOrder="" IsPromotionOnOrderLine="" PosReasonCode="" PromotionId="" PromotionKey=""/></Awards>: AwardType=' FreeGift ' para identificar esta prima es un regalo gratuito y utilizar AwardAmount para calcular la cantidad gratuita del regalo | Order/OrderItem/OrderItemAmount/@freegift |
Order/OrderLines/OrderLine/@UnitPrice | Order/OrderItem/OrderItemAmount/UnitPrice |
Order/OrderLines/OrderLine/ManualRuleAdjustments/ManualRuleAdjustment/@Adjustment | Esto se implementa mediante el componente precio/promoción de WebSphere® Commerce. |
Order/OrderLines/OrderLine/ManualRuleAdjustments/ManualRuleAdjustment/ @PricingRuleKey | |
Order/OrderLines/OrderLine/ManualRuleAdjustments/ManualRuleAdjustment/@PricingRuleName | |
Order/OrderLines/OrderLine/ManualAdjustments/ManualAdjustment/@AdjustmentID | Order/CalculationInfo/ExtraAdjustments/CalculationCodeIdentifier/UniqueID (1) -10: Descuento de pedido de CSR (2)-11: Descuento de artículo de pedido de CSR (3)-12: Ajuste de envío CSR |
Order/OrderLines/OrderLine/ManualAdjustments/ManualAdjustment/@AdjustmentPerLine | Order/CalculationInfo/ExtraAdjustments/AdjustmentApplyAmount (AdjustmentPerUnit * Quantity + AdjustmentPerLine) |
Order/OrderLines/OrderLine/ManualAdjustments/ManualAdjustment/@AdjustmentPerUnit | |
Codificado en la correlación WESB; solo se utiliza el tipo de sustitución fija para Sterling Order Management. | Pedido/CalculationInfo/extraadjusts/AdjustmentApplyPolicy (1) ajuste fijo (2) ajuste por porcentaje (3) sustitución fija Nota: En el release actual solo se da soporte a la sustitución fija. |
Se realiza en xslt. | Order/CalculationInfo/ExtraAdjustments/OrderItemIdentifier/UniqueID Order/CalculationInfo/ExtraAdjustments/OrderItemIdentifier/ExternalOrderItemID |
Codificado en correlación WESB; es falso | Order/CalculationInfo/IsOverrideExistingAdjustments |
Order/Coupons/Coupon/@CouponID | Order/PromotionCode/Code |
correlaciones de respuesta de getOrderPriceUE
HCL Commerce Vía de acceso | Sterling Order Management Vía de acceso de la API |
---|---|
ORDER | |
Order/OrderAmount/TotalProductPrice/@Currency | Order/@Currency |
Order/OrderIdentifier/UniqueID | Order/@OrderReference |
Order/OrderIdentifier/externalOrderID | |
Order/BuyerIdentifier/ExternalIdentifier/Identifier | Order/@BuyerUserId |
Order/@EnterpriseCode | |
Order/OrderAmount/TotalProductPrice | Order/@LinePriceTotal |
Order/OrderAmount/TotalAdjustment | Order/@OrderAdjustment |
Order/OrderAmount/GrandTotal | Order/@OrderTotal |
Order/StoreIdentifier/UniqueID (ValueMaps.xml) | Order/@OrganizationCode |
Utilice el mismo PricingDate que la entrada de solicitud. | Order/@PricingDate |
(sin utilizar) | Order/@RunCategoryOnlyRules |
totalproductPrice + descuento de pedido/artículo (no incluir ajuste de envío) | Order/@Subtotal |
(sin utilizar) | Order/@SuggestManualRuleAdjustment |
(sin utilizar) | Order/@SuppressExecution |
(sin utilizar) | Order/@SuppressShipping |
(sin utilizar) | Order/@ManualRuleAdjustments |
(sin utilizar) | Order/@ApplicableManualRules |
(sin utilizar) | Order/@ApplicableManualRuleSummary |
CarrierServiceCode="" DistributeAdjustment="" EndDateActive="" IgnoreRuleOnManualAdjustment="" IgnoreRuleOnPriceLock="" IsCouponRule="" IsItemAttributeValueRule="" IsItemRule="" IsManualAdjustment="" IsManualRule="" ItemOperatorCode="" MinimizeNumberOfShipments="" OrganizationCode="" PricingRuleKey="" PricingRuleName="" PricingStatus="" RuleCategory="" RuleType="" StartDateActive="" | |
Order/PromotionCode/Code | Order/Coupon/@CouponID |
Order/PromotionCode/Reason/ReasonCode | Order/Coupon/@CouponStatusMsgCode |
Order/PromotionCode/Reason/Valid | Order/Coupon/@Valid |
Order/PricingDate | Order/@PricingDate |
(No hay ningún archivo correspondiente en HCL Commerce.) | Order/Coupon/StatusAttribute/@Name |
(No hay ningún archivo correspondiente en HCL Commerce.) | Order/Coupon/StatusAttribute/@Value |
ORDER ITEM/ORDER LINE | |
XXX, componente de precio de WC | Order/OrderLines/OrderLine/@AbsoluteAdjustment |
Order/OrderLines/OrderLine/@DeliveryMethod | |
(sin utilizar) | Order/OrderLines/OrderLine/@EligibleForShippingDiscount |
(sin utilizar) | Order/OrderLines/OrderLine/@ExtendedPrice |
(sin utilizar) | Order/OrderLines/OrderLine/@isLinePriceForInformationOnly |
Utilice los mismos valores que la entrada de solicitud. | Order/OrderLines/OrderLine/@isPriceLocked |
Order/OrderItem/CatentryIdentifier/ExtendedIdentifier/PartNumber | Order/OrderLines/OrderLine/@ItemID |
Order/OrderItem/OrderItemAmount/ajuste (suma de displayLevel = orderItem) | Order/OrderLines/OrderLine/@LineAdjustment |
Order/OrderItem/OrderItemIdentifier/UniqueID | Order/OrderLines/OrderLine/@LineId |
Order/OrderItem/OrderItemAmount/OrderItemPrice | Order/OrderLines/OrderLine/@LinePrice |
Order/OrderItem/OrderItemAmount/(OrderItemPrice + totaladjustment + shipping charge Nota: Los impuestos sobre el envío y los impuestos sobre la venta no están disponibles en este release en getOrderPriceUE. |
Order/OrderLines/OrderLine/@LineTotal |
No se utiliza en el pedido de HCL Commerce; se utiliza el precio unitario. | Order/OrderLines/OrderLine/@ListPrice |
Order/OrderItem/OrderItemAmount/ajuste (suma de displaylevel = order) | Order/OrderLines/OrderLine/@OrderAdjustment |
(sin utilizar) | Order/OrderLines/OrderLine/@PercentAdjustment |
Order/OrderItem/Quantity | Order/OrderLines/OrderLine/@Quantity |
Ajuste de ShippingCharge + recargo Nota: El recargo de envío no está soportado en HCL Commerce; es un cargo de envío normal. |
Order/OrderLines/OrderLine/@ShippingAdjustment |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (suma de usage =-7 y amount < 0, usage =-7 es ajuste de envío) | Order/OrderLines/OrderLine/@ShippingChargeAdjustment |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (suma de usage =-7 y amount > 0, usage =-7 es ajuste de envío) | Order/OrderLines/OrderLine/@ShippingSurcharge |
Order/OrderItem/Quantity/UOM | Order/OrderLines/OrderLine/@UnitofMeasure |
Order/OrderItem/OrderItemAmount/UnitPrice | Order/OrderLines/OrderLine/@UnitPrice |
(sin utilizar) | Order/OrderLines/OrderLine/@ManualRuleAdjustments |
(sin utilizar) | Order/OrderLines/OrderLine/@ApplicablesManualRules |
ORDER ITEM/ORDER LINE - Ajustes de línea | |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (usageId -1 discount, displaylevel = orderitem) | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/@AdjustmentApplied |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (usageId -1 discount, displaylevel = orderitem) | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/@AdjustmentAvailable |
Order/OrderItem/OrderItemAmount/Adjustment/Code (usage=-1 discount, displaylevel = orderitem) | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/@AdjustmentID |
Order/OrderItem/OrderItemAmount/Adjustment/Amount SUM (usageId -1 discount, displaylevel = orderitem) | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/@AdjustmentPerLine |
Order/OrderItem/OrderItemAmount/Adjustment/Amount SUM/Quantity (usageId -1 discount, displaylevel = orderitem) | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/@AdjustmentPerUnit |
(sin utilizar) | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/@CarrierServiceCode |
Order/OrderItem/OrderItemAmount/Adjustment/Amount/Currency | Order/OrderLines/OrderLine/LineAdjustments/@Adjustment/Currency |
Order/OrderItem/OrderItemAmount/Adjustment/Description | Order/OrderLines/OrderLine/LineAdjustment/@Adjustment/Description |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/LineAdjustment/Adjustment/@PricingRuleName |
valor predeterminado = true, en WC, siempre se distribuyen los ajustes | Order/OrderLines/OrderLine/LineAdjustment/Adjustment/@DistributeAdjustment |
Si este artículo es un regalo gratuito, marcaremos este RuleCategory de ajuste en FreeGift | Order/OrderLines/OrderLine/LineAdjustment/@Adjustment/RuleCategory |
(sin utilizar) | CarrierServiceCode="" EndDateActive="" IgnoreRuleOnManualAdjustment="" IgnoreRuleOnPriceLock="" IsCouponRule="" IsItemAttributeValueRule="" IsItemRule="" IsManualAdjustment="" IsManualRule="" ItemOperatorCode="" MinimizeNumberOfShipments="" OrganizationCode="" PricingRuleKey="" PricingRuleName="" PricingStatus="" RuleCategory="" RuleType="" StartDateActive="" |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/LineAdjustments/Adjustment/AdjustmentAction/@ChargeName |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/ LineAdjustments/Adjustment/Coupon/@CouponID (si este ajuste es necesario para el cupón) |
ORDER ITEM/ORDER LINE - Ajustes de envío | |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (usageId -7 shipping adjustment, displaylevel = orderitem) | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@AdjustmentApplied |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (usageId -7 shipping adjustment, displaylevel = orderitem) | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@AdjustmentAvailable |
Order/OrderItem/OrderItemAmount/Adjustment/Code (usage=-7 shipping adjustment, displaylevel = orderitem) | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@AdjustmentID |
Order/OrderItem/OrderItemAmount/Adjustment/Amount SUM of the amount (usageId -7shipping adjustment, displaylevel = orderitem) | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@AdjustmentPerLine |
Order/OrderItem/OrderItemAmount/Adjustment/Amount SUM of the amount/ Quantity (usageId -7 shipping adjustment, displaylevel = orderitem) | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@AdjustmentPerUnit |
(sin utilizar) | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@CarrierServiceCode |
Order/OrderItem/OrderItemAmount/Adjustment/Amount/Currency | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@Currency |
Order/OrderItem/OrderItemAmount/Adjustment/Description | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@Description |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@PricingRuleName |
valor predeterminado = true; en HCL Commerce, los ajustes siempre se distribuyen. | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/@DistributeAdjustment |
(sin utilizar) | CarrierServiceCode="" EndDateActive="" IgnoreRuleOnManualAdjustment="" IgnoreRuleOnPriceLock="" IsCouponRule="" IsItemAttributeValueRule="" IsItemRule="" IsManualAdjustment="" IsManualRule="" ItemOperatorCode="" MinimizeNumberOfShipments="" OrganizationCode="" PricingRuleKey="" PricingRuleName="" PricingStatus="" RuleCategory="" RuleType="" StartDateActive="" |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/ShippingAdjustments/Adjustment/AdjustmentAction/@ChargeName |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/Shipping/Adjustments/Adjustment/Coupon/@CouponID (si este ajuste es necesario para el cupón) |
ORDER ITEM/ORDER LINE - Ajustes de pedido | |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (usageId -1, displaylevel = order) | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@AdjustmentApplied |
Order/OrderItem/OrderItemAmount/Adjustment/Amount (usageId -1, displaylevel = order) | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@AdjustmentAvailable |
Order/OrderItem/OrderItemAmount/Adjustment/Code (usage=-1, displaylevel = order) | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@AdjustmentID |
Order/OrderItem/OrderItemAmount/Adjustment/Amount SUM (usageId -1, displaylevel = order) | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@AdjustmentPerLine |
Order/OrderItem/OrderItemAmount/Adjustment/Amount SUM/Quantity (usageId -1, displaylevel = order) | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@AdjustmentPerUnit |
(sin utilizar) | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@CarrierServiceCode |
Order/OrderItem/OrderItemAmount/Adjustment/Amount/Currency | Order/OrderLines/OrderLine/OrderAdjustments/@Adjustment/Currency |
Order/OrderItem/OrderItemAmount/Adjustment/Description | Order/OrderLines/OrderLine/OrderAdjustments/@Adjustment/Description |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@PricingRuleName |
valor predeterminado = true; en WebSphere® Commerce, los ajustes siempre se distribuyen | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@DistributeAdjustment |
Si este artículo es un regalo gratuito, el RuleCategory de este ajuste se marca como FreeGift. | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/@RuleCategory |
(sin utilizar) | CarrierServiceCode="" EndDateActive="" IgnoreRuleOnManualAdjustment="" IgnoreRuleOnPriceLock="" IsCouponRule="" IsItemAttributeValueRule="" IsItemRule="" IsManualAdjustment="" IsManualRule="" ItemOperatorCode="" MinimizeNumberOfShipments="" OrganizationCode="" PricingRuleKey="" PricingRuleName="" PricingStatus="" RuleCategory="" RuleType="" StartDateActive="" |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/AdjustmentAction/@ChargeName |
Order/OrderItem/OrderItemAmount/Adjustment/CalculationCodeIdentifier | Order/OrderLines/OrderLine/OrderAdjustments/Adjustment/Coupon/@CouponID (si este ajuste es necesario para el cupón) |
SHIPPING | |
Order/OrderAmount/TotalShippingCharge + shipping adjustment | Order/Shipping/@AdjustedShippingTotal |
Order/OrderShippingInfo/ShippingMode | Order/Shipping/@CarrierServiceCode |
(sin utilizar) | Order/Shipping/@MinimizeNumberOfShipments |
shippingchargeadjustment+shipping surcharge | Order/Shipping/@ShippingAdjustment |
Order/OrderAmount/TotalShippingCharge | Order/Shipping/@ShippingCharge |
Order/OrderAmount/Adjustment/Amount sum of usageId =-7 and value<0 | Order/Shipping/@ShippingChargeAdjustment |
Order/OrderAmount/Adjustment/Amount sum of usageId =-7 and value>0 | Order/Shipping/@ShippingSurcharge |