Deal Itemloc Item

This contains the unique deal ID number.

This contains the Deal component ID number, uniquely sequenced within each deal.

Sequence number that uniquely identifies each item/location line within the deal component.

Indicates what level of the merchandise hierarchy the record is at.

ID of the division included in or excluded from the deal component.

ID of the group included in or excluded from the deal component.

ID of the department included in or excluded from the deal component.

ID of the class included in or excluded from the deal component.

ID of the subclass included in or excluded from the deal component.

This contains the item associated to the deal.

Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.

Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table.

Diff_group or diff_id that differentiates the current item from its item_parent.

Diff_group or diff_id that differentiates the current item from its item_parent

Diff_group or diff_id that differentiates the current item from its item_parent.

Diff_group or diff_id that differentiates the current item from its item_parent.

Indicates what level of the organizational hierarchy the record is at. Valid values include 1 for chain, 2 for area, 3 for region, 4 for district and 5 for location. These level types will be held on the codes table under a code type of DIOL.

ID of the chain included in or excluded from the deal component.

ID of the area included in or excluded from the deal component.

ID of the region included in or excluded from the deal component

ID of the district included in or excluded from the deal component.

This contains the location associated to the deal.

This contains the Origin country of the item that the deal component should apply to.

This contains the location type of the location associated to the deal.

Indicates if the deal component item/location line is included in the deal component or excluded from it. Valid values are Y for yes or N for no.

Date/time stamp of when the record was created. This date/time can be used for auditing purposes. This value should only be populated on insert - it should never be updated. This field is required by the database

Holds the Oracle user-id of the user who most recently updated this record. This date/time can be used for auditing purposes. This field is required by the database.

Holds the date time stamp of the most recent update by the last_update_id. This date/time can be used for auditing purposes. This field is required by the database.

Active_ind is an indicator that tells whether a deal is active or not. Active deals are defined as deals where the close date is less than the business date. Updated by prepost.pc weekly.

This column holds the User id of the user who created the record.