Svc Comp Price Hist

Uniquely identifies a process in SVC_PROCESS_TRACKER.

Uniquely identifies a chunk. The value will always be 1.

The rows sequence. Should be unique within a Process-ID.

Describes type of action i.e. NEW, MOD or DEL.

Status of current row. Could be N - New, P-Processed, E-Error.

This field identifies the unique alphanumeric value for the transaction level item that was competitively shopped.

This field contains the reference item (e.g. UPC, PLU, etc.) for the item that was competitively shopped.

Contains the number to uniquely identify a competitors store.

The date that the items price was recorded at the competitors store.

The retail price at the competitors store.

Contains the price type which was recorded. Valid values are: R = regular P = promotional C = clearance

Contains the total quantity for multi unit pricing (e.g. 2 for, 3 for)

Contains the total price for multi unit pricing (e.g. 2 for $10)

Contains the effective start date of the competitors promotional price.

Contains the effective end date of the competitors promotional price.

This field identifies the offer type of the competitors regular (e.g. pre-priced) or promotional retail (e.g. bonus card). Valid values are stored on the codes table with a code type of OFTP.

User who created the record. Oracle Retail target column CREATE_ID on SVC_COMP_PRICE_HIST.

Date time when record was inserted.

User who last updated the record.

Date time when record was last updated.