Oracle ATG Web Commerce uses the following tables to store information about order markers:
dcs_order_marker
This table holds information about markers assigned to orders when an order reaches a business process stage.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the marker. |
| varchar (40) | not null | The ID of the order for that has an order marker. |
| varchar (100) | not null | The name of the business process associated with the marker. |
| varchar (100) | null | The name of the business process stage associated with the marker. |
| varchar (100) | null | This column is not currently in use. |
| timestamp | null | The date the business process stage is reached and the order marker is assigned to the order. |
| integer | not null | The order marker repository version number. This information is managed and used internally by the repository. |
| integer | null | This column is not currently in use. |
dcs_gwp_order_markers
This table holds information about markers assigned to gift with purchase promotion orders.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the marker. |
| varchar(100) | not null | The type of gift, which can be |
| varchar(1024) | not null | String identifying the gift, usually the repository id of the gift type. |
| number | not null | Flag to indicate whether free gifts should be auto removed if the promotion no longer qualifies. This is configured by the merchandiser when the promotion is created. |
| integer | not null | The total quantity of SKU for this gift selection. It is the quantity from the PMDL multiplied by the number of times the offer applied (if it applied more than once due to a ‘for next’ or multiple grants). |
| integer | not null | The quantity of free SKU for this gift selection that has already been targeted and made free by the calculator in the order. |
| integer | not null | The quantity of free SKU for this gift selection that has already been auto added to the order. |
| integer | null | The quantity of free SKU for this gift selection that has already been selected by the Shopper and added to the order. |
| integer | null | The amount of free quantity that has since been manually removed by a shopper. Keeping track of removed quantities prevents them from being automatically re-added in future pricing operations. The assumption is that the customer does not want the free item. |
| varchar(40) | not null | Identifier of the order that contains the gift item. |
| varchar(100) | not null | Key identifying the type of the marker. |
| varchar(100) | null | Value of the marker. |
| varchar(100) | not null | Data for the marker. |
| int | null | The marker type. |
| int | not null | Quantity of gift with purchase items where an attempt was made to automatically add the item, but the attempt failed. |
dcspp_gwp_itemmarkers
This table holds information about markers assigned to gift with purchase promotion commerce items.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the marker. |
| integer | not null | The quantity of the free gift that this commerce item is making free and was targeted by pricing. |
| integer | not null | The quantity of the free gift that this commerce item is making free and was auto added by pricing. |
| integer | null | The quantity of the free gift that this commerce item is making free and was selected by the shopper. |
| varchar(40) | not null | |
| varchar(100) | not null | Key identifying the type of the marker. |
| varchar(100) | varchar(100) | Value of the marker. |
| varchar(100) | varchar(100) | Data for the marker. |
| int | not null |