E:\telus-agcg\SE-Development\fse_dev\z_cfmodMaster\POS\utilities\utl_applyDataRetentionRules_posOrderManagement_08262025.cfm using retentionDate of 01/01/2023

tbl_POS_Orders - 6 records purged

declare @ownerId int = 21 ;
        declare @ownerType varchar(3) = 'MFR' ;
        declare @retentionDate datetime = '2023-01-01' ;

        select ord.ownerid, ord.fsl_tablecode,ord.orderid, ord.orderdate, '' as orderlineItems
        from tbl_POS_Orders ord with(nolock)
        where abs ( ownerId ) = @ownerId 
        and ord.fsl_tableCode = @ownerType
        and ord.orderDate <= @retentionDate
        and ord.orderNum is NULL 
        order by ord.orderid