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