This table stores product information from your product repository. There is one row per product.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| varchar | 40 | No | Identifier; primary key. |
| varchar | 40 | No | Natural key of product. |
| varchar | 254 | No | Product name in the default language. |
| varchar | 254 | Yes | Product name in English. |
| varchar | 254 | Yes | Product description in the default language. |
| varchar | 254 | Yes | Product description in English. |
| int | Yes | ID of the product’s parent category, if applicable. Foreign key to | |
| varchar | 254 | Yes | The name of the brand associated with the product. This name is used when no locale is specified for a report. |
| varchar | 254 | Yes | The name of the brand associated with the product. This description is used when an English language locale is specified for a report. |
| timestamp | Yes | Date the record was last updated. | |
| timestamp | Yes | Date when the information in this warehouse record became effective | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
| one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
| one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |