ID

varchar

40

No

Identifier; primary key.

NPRODUCT_ID

varchar

40

No

Natural key of product.

NAME

varchar

254

No

Product name in the default language.

NAME_EN

varchar

254

Yes

Product name in English.

DESCRIPTION

varchar

254

Yes

Product description in the default language.

DESCRIPTION_EN

varchar

254

Yes

Product description in English.

PARENT_CAT_ID

int

Yes

ID of the product’s parent category, if applicable. Foreign key to ARF_CATEGORY.ID column.

BRAND

varchar

254

Yes

The name of the brand associated with the product. This name is used when no locale is specified for a report.

BRAND_EN

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.

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