LT_M2_PROMOTION_LOG

Description:

This table is a mirror of  LT_M2_Promotion_UPDATE, and is used as part of the Asynchronous Promotion Processing workflow. After promotions from  LT_M2_Promotion_UPDATE are processed they are moved to this table for archiving for up to 3 months. Promotion rows older than 3 months are automatically deleted by LP_M2_UPDATE_PROMOTIONS_IN_BULK each time that it is run. 

Schema:

[sessionkey] [varchar](64) NULL,
[source_no] [int] NULL,
[opened_at] [datetime] NULL,
[email] [varchar](80) NULL,
[Campaign_id] [int] NULL,
[response] [int] NULL,
[action] [varchar](80) NULL,
[customer_no] [int] NULL

This table is updated by:

LP_M2_UPDATE_PROMOTIONS_IN_BULK

Still need help? Contact Us Contact Us