pixiReport_NewCustomersStats

Deprecated

New Customers report Multi Currency: Return database currency code in field dbCurrency depend on if Multi Currency is Enabled then we:

  • calculate and return data in database currency else
  • calculate and return data in order / original currency (with value NULL for currency code).

Since pixi version: LOU Official (6.3.0.4452) Additional notes:


Request

POST https://apigateway.descartes.com/tms/pixi/pixiReport_NewCustomersStats

Request body

Name Type Required Description
Shop string false

Shop ID

Type: varchar(3)

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)

Year integer false

Year as a date range for report

Type: int

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)

Country string false

Country code

Type: varchar(3)

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)


Response

1. Result set

Name Type Description
Average number

Average

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month01 number

Month01

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month02 number

Month02

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month03 number

Month03

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month04 number

Month04

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month05 number

Month05

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month06 number

Month06

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month07 number

Month07

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month08 number

Month08

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month09 number

Month09

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month10 number

Month10

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month11 number

Month11

Type: numeric

Available from: 25.06 (25.6.0.58802)

Month12 number

Month12

Type: numeric

Available from: 25.06 (25.6.0.58802)

ParShop string

ParShop

Type: varchar

Available from: 25.06 (25.6.0.58802)

ParYear integer

ParYear

Type: int

Available from: 25.06 (25.6.0.58802)

LineLabel string

LineLabel

Type: varchar

Available from: 25.06 (25.6.0.58802)

LineNumber integer

LineNumber

Type: int

Available from: 25.06 (25.6.0.58802)

ParCountry string

ParCountry

Type: varchar

Available from: 25.06 (25.6.0.58802)

dbCurrency string

dbCurrency

Type: varchar

Available from: 25.06 (25.6.0.58802)

GroupNumber integer

GroupNumber

Type: int

Available from: 25.06 (25.6.0.58802)