This table stores SKU information from your product repository. There is one row per SKU.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | varchar | 40 | No | Identifier; primary key. |
NSKU_ID | varchar | 40 | No | Natural key of SKU. |
NAME | varchar | 254 | No | SKU name in the default language. |
NAME_EN | varchar | 254 | Yes | SKU name in English. |
DESCRIPTION | varchar | 254 | Yes | SKU description in the default language. |
DESCRIPTION_EN | varchar | 254 | Yes | SKU description in English. |
PARENT_PROD_ID | int | Yes | ID of the SKU’s parent product. Foreign key to ARF_PRODUCT.ID column. | |
WHOLESALE_PRICE | double | Yes | Wholesale price of the item represented by the SKU. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. | |
LIST_PRICE | double | Yes | List price of the item represented by the SKU. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. | |
SALE_PRICE | double | Yes | Sale price of the item represented by the SKU. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. | |
ON_SALE | numeric or tinyint | 1 (for numeric) | Yes | Indicates whether or not the item is currently on sale. 0 = No 1 = Yes |
RECORD_LAST_UPDATE | timestamp | Yes | Date the record was last updated. | |
RECORD_START_DATE | timestamp | Yes | Date when the information in this warehouse record became effective | |
RECORD_END_DATE | timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
MOST_RECENT | one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
DELETED | one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |