Products
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| products/products_yyyy_MM_dd.csv | :white_check_mark: | :no_entry: | Daily |
| Attribute | Required? | Value | Description |
|---|---|---|---|
| PRODUCT_ID | Yes | NUMBER | Unique id of product |
| PRODUCT_GROUP_ID | NUMBER | Foreign key for Product Groups | |
| SORT_INDEX | Yes | NUMBER | Sets the sort index of the product |
| PRODUCT_PERIOD_ID | NUMBER | Foreign key for Product Periods | |
| PRICE | NUMBER | ||
| ENABLED | 0 or 1 | ||
| MINIMUM_PERIODS | Yes | NUMBER | |
| DESCRIPTION | VARCHAR2(1000 BYTE) | ||
| STARTDATE | DATE | ||
| ENDDATE | DATE | ||
| PACKAGE | VARCHAR2(1000 BYTE) | ||
| CURRENCY | VARCHAR2(25 BYTE) | ||
| PRODUCT_STATUS | VARCHAR2(20 BYTE) | ||
| ADMIN_COMMENT | VARCHAR2(1000 BYTE) |