PRODUCTS - ProductPrices
Cette requête retourne la liste des prix spécifiques d'un article.
Champs obligatoires
La requête doit retourner obligatoirement les champs suivants :
- ProductKey String, le code unique de l'article dans l'ERP (exemple: ART0001)
- PriceGroupKey String, le code du groupe de tarifs dans l'ERP (exemple: TARIF1)
- CustomerKey String le code unique du client l'ERP (exemple: C0001)
- ShopKey String le code unique de la boutique (exemple: 1)
- Price Numeric le prix HT de l'article (exemple: 45.78)
- FromQuantity Numeric la quantité à partir de laquelle le prix s'applique (exemple: 4)
- ReductionAmout Numeric le montant de la remise HT (exemple: 7.50)
- ReductionPercent Numeric le montant de la remise en pourcentage (exemple: 5)
- From Date la date de début du prix spécifique (exemple: 2020-09-27)
- To Date la date de fin du prix spécifique (exemple: 2020-10-05)
Argument obligatoire
- {0} spécifie le code unique de l'article (exemple: ART0001)
Exemple de requête
SELECT
ProductKey as 'ProductKey' /* Type: String */,
PriceGroupKey as 'PriceGroupKey' /* Type: String */,
CustomerKey as 'CustomerKey' /* Type: String */,
ShopKey as 'ShopKey' /* Type: String */,
Price as 'Price' /* Type: Numeric */,
FromQuantity as 'FromQuantity' /* Type: Numeric */,
ReductionAmount as 'ReductionAmount' /* Type: Numeric */,
ReductionPercent as 'ReductionPercent' /* Type: Numeric */,
From as 'From' /* Type: Date */,
To as 'To' /* Type: Date */
FROM TABLE
WHERE
ProductKey = '{0}' /* Type: String, Format: */
ProductKey as 'ProductKey' /* Type: String */,
PriceGroupKey as 'PriceGroupKey' /* Type: String */,
CustomerKey as 'CustomerKey' /* Type: String */,
ShopKey as 'ShopKey' /* Type: String */,
Price as 'Price' /* Type: Numeric */,
FromQuantity as 'FromQuantity' /* Type: Numeric */,
ReductionAmount as 'ReductionAmount' /* Type: Numeric */,
ReductionPercent as 'ReductionPercent' /* Type: Numeric */,
From as 'From' /* Type: Date */,
To as 'To' /* Type: Date */
FROM TABLE
WHERE
ProductKey = '{0}' /* Type: String, Format: */