| Name | Description | Type | Additional information |
|---|---|---|---|
| CustomerID | string |
None. |
|
| FullName | string |
None. |
|
| string |
None. |
||
| Gender | string |
None. |
|
| PostalCode | string |
None. |
|
| Region | string |
None. |
|
| CustomerTypeID | integer |
None. |
|
| TariffID | integer |
None. |
|
| IsNewsletterSuscriber | boolean |
None. |
|
| OrdersAmount | decimal number |
None. |
|
| OrderAmountAverage | decimal number |
None. |
|
| OrderAmountMin | decimal number |
None. |
|
| OrderAmountMax | decimal number |
None. |
|
| OrdersCount | integer |
None. |
|
| OrderItemsQty |
total de productes q ha comprat en el periode. Decimal because Qty of a product can be decimal! |
decimal number |
None. |
| DaysSinceLastOrder |
when there is no Order, it is also 0 |
integer |
None. |
