# Data Types

> Data types supported by the Supply Chain & Retail Solutions Data Ingestion API when specifying field schemas for resources.

The Data Ingestion API supports the following data types when specifying the schema of the data being sent. For a full breakdown of the required request payload and which data types apply to each field, see:

* [Markdown & Promotions, modules in Merchandising](markdown-promotions-data-model.md)
* [Quote Pricing, a module in Commercial Pricing](quote-pricing-data-model.md)
* [Inventory Management](inventory-management-data-model.md)

| Data Type | Description | Extra Requirements |
|---|---|---|
| `string` | Text/string values (Limit for Redshift: `65535`; for Snowflake same as the warehouse default) | None |
| `integer` | Whole number values | None |
| `boolean` | True/false values | None |
| `float` | Floating-point numbers | None — `precision` and `scale` are **not** accepted for `float` and will be rejected at schema save |
| `numeric` | Precise decimal numbers | Requires `precision` (1–38) and `scale` (0–37) |
| `json` | Arbitrary JSON values — stored as Snowflake `VARIANT` / Redshift `SUPER` | None |
| `date` | Date values (no time component) | Requires a `timestampFormat` validation with `format: "YYYY-MM-DD"` |
| `timestamp` | Date + time values | Requires a `timestampFormat` validation with `format: "YYYY-MM-DD HH:MI:SS"` or `format: "YYYY-MM-DD HH:MI:SS ±hh:mm"` |

## Data Type Categories

| Category | Types | Additional Required Fields |
|---|---|---|
| Basic Types | `string`, `integer`, `boolean`, `float`, `json` | None beyond standard validations |
| Numeric Types | `numeric` | `precision` (number), `scale` (number) |
| Date/Time Types | `date`, `timestamp` | `timestampFormat` validation with `format` field |