-- ABS-26917

------------------------------------------ROUTETRANSACTIONCATEGORY-------------------------------------------------------------------------------------
UPDATE ROUTETRANSACTIONCATEGORY
SET SHOWTAB_YN='Y'
WHERE ROUTETRANSACTIONCATEGORY_ID=9;
COMMIT;

------------------------------------------ROUTETRANSACTIONTYPE-----------------------------------------------------------------------------------------

INSERT INTO ROUTETRANSACTIONTYPE(ROUTETRANSACTIONTYPE_ID,FACTORYDESCRIPTION,ALLOWMANUALAPPROVAL_YN,APPROVEMANUALLY_YN, ROUTETRANSACTIONCATEGORY_ID, SYSTEMUSER_ID,TIMESTAMP) VALUES (703, 'Loss Charge Invoice Line Adjustment','N','N', 1, GETMINSYSTEMUSER(),SYSDATE);
COMMIT;

INSERT INTO ROUTETRANSACTIONTYPE(ROUTETRANSACTIONTYPE_ID,FACTORYDESCRIPTION,ALLOWMANUALAPPROVAL_YN,APPROVEMANUALLY_YN, ROUTETRANSACTIONCATEGORY_ID, SYSTEMUSER_ID,TIMESTAMP) VALUES (704, 'Returned Item Invoice Line Adjustment','N','N', 1, GETMINSYSTEMUSER(),SYSDATE);
COMMIT;

INSERT INTO ROUTETRANSACTIONTYPE(ROUTETRANSACTIONTYPE_ID,FACTORYDESCRIPTION,ALLOWMANUALAPPROVAL_YN,APPROVEMANUALLY_YN, ROUTETRANSACTIONCATEGORY_ID, SYSTEMUSER_ID,TIMESTAMP) VALUES (804, 'Scan Returned Item','N','N', 9, GETMINSYSTEMUSER(),SYSDATE);
COMMIT;