--ABS-7437
--------------------- UNIQUEITEMBUFFERINFO ---------------------
ALTER TABLE UNIQUEITEMBUFFERINFO MODIFY (LASTSCANSTATION VARCHAR2(12));

--------------------- PURGETABLE ---------------------
INSERT INTO PURGETABLE
  (PURGETABLE_ID,
   TABLENAME,
   DESCRIPTION,
   REMARK,
   WHERECLAUSE,
   DATEFIELDNAME,
   HINT,
   PLANTFIELDNAME,
   BUSINESSUNITFIELDNAME,
   COMMITSIZE,
   SYSTEMUSER_ID,
   TIMESTAMP)
        VALUES
          (SEQ_PURGETABLE.NEXTVAL,
           'Productionprocessscanaggr',
           'Production Process Scan (Aggregated)',
           NULL,
           NULL,
           'SCANDATE',
           NULL,
           NULL,
           'BUSINESSUNIT_ID',
           5000,
           1,
           SYSDATE);
   
INSERT INTO PURGETABLE
  (PURGETABLE_ID,
   TABLENAME,
   DESCRIPTION,
   REMARK,
   WHERECLAUSE,
   DATEFIELDNAME,
   HINT,
   PLANTFIELDNAME,
   BUSINESSUNITFIELDNAME,
   COMMITSIZE,
   SYSTEMUSER_ID,
   TIMESTAMP)
        VALUES
          (SEQ_PURGETABLE.NEXTVAL,
           'Prodprocessbuffersnapshot',
           'Production Process Buffer Snapshot',
           NULL,
           NULL,
           'SNAPSHOTLOCALDATE',
           NULL,
           'PLANT_ID',
           NULL,
           5000,
           1,
           SYSDATE);
COMMIT;
