Insertion of prepay reversal entry which not created by system.
SELECT Count(*)FROM PS_VCHR_ACCTG_LINE
WHERE BUSINESS_UNIT = 22
AND VOUCHER_ID = '00036349'
AND POSTING_PROCESS = 'PPAY'
(0 ROWS SELECTED)
INSERT INTO PS_VCHR_ACCTG_LINE
VALUES(22,'00036349',0,'ACCRUAL','PPAY',99998,1,1,'APA',0,'CORPORATE',' ',21000,' ',' ',' ', 175613,'INR','CRRNT',1,44.916, 3909.81,0,0,' ','Accounts Payable', 175613, -3909.81,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ','01-OCT-2011',0,0,22000,' ','',0,'N','N',671436,'N',' ',' ',' ',0,0,' ',' ',0,0,0,' ',0,0,' ',' ',' ',' ',' ',' ','I','USD',' ',' ',' ',' ',' ','I','I',' ',' ',0,0,0,'ACTUALS',' ',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ',0,'',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0,0,0,' ',' ',' ' ,' ',' ',0,'N',' ',' ',' ',' ','01-OCT-2011','I','N','V','V','C','01-OCT-2011',' ',' ','01-OCT-2011',0,0,0,' ',0,'Y','APVD','AP',' ','N',0,0,0,0,0,0,' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0)
INSERT INTO PS_VCHR_ACCTG_LINE
VALUES(22,'00036349',0,'ACCRUAL','PPAY',99998,1,1,'DST',0,'CORPORATE',' ',12350,' ',' ',' ',-177388,'INR','CRRNT',1,44.916,-3949.33,0,0,' ','Expense Distribution',-177387,-3949.31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ','01-OCT-2011',0,0,22000,' ','',0,'N','N',671436,'N','N',' ','N',0,0,' ',' ',0,0,0,'N',0,0,' ',' ',' ',' ',' ',' ','I','USD','N',' ',' ',' ',' ','I','I',' ',' ',0,0,0,'ACTUALS',' ',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ',0,'01-OCT-2011',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',0,0,0,' ',' ',22000,22000,' ',0,'E',' ','',' ',' ','01-OCT-2011','I','N','V','V','C','01-OCT-2011',' ',' ','01-OCT-2011',0,0,0,' ',0, 'N','APVD','AP',' ','N',0,0,0,0,0,0,' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0)
INSERT INTO PS_VCHR_ACCTG_LINE
VALUES(22,'00036349',0,'ACCRUAL','PPAY',99998,1,1,'WTH',0,'CORPORATE',' ',23420,' ',' ',' ',1774, 'INR','CRRNT',1,44.916, 39.50, 0,0,' ','Withholding Liability',177387, 3949.31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ','07-Oct-2011',0,0,22000,' ','',0,'N','N',671436,'N',' ',' ',' ',0,0,' ',' ',0,0,0,' ',0,0,' ',' ',' ',' ',' ',' ','I','USD',' ',' ',' ',' ',' ','I','I',' ',' ',0,0,0,'ACTUALS',' ',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ',0,'07-Oct-2011',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0,0,0,' ',' ',' ',' ',' ',0,'N',' ',,' ',' ','07-Oct-2011','I','N','V','V','C','07-Oct-2011',' ',' ','07-Oct-2011',0,0,0,' ',0,'N','APVD','AP',' ','N',0,0,0,0,0,0,' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0)
INSERT INTO PS_VCHR_ACCTG_LINE
VALUES(22,'00036349',0,'ACCRUAL','PPAY',99998,1,1,'APA',0 ,'LOCAL',' ',21000,' ',' ',' ', 175613,'INR','CRRNT',1,1,175613,0,0,' ','Accounts Payable', -175613,-175613,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ','01-OCT-2011',0,0,22000,' ','',0,'N','N',671436 'N',' ',' ',' ',0,0,' ',' ',0,0,0,' ',0,0,' ',' ',' ',' ',' ',' ','I','INR',' ',' ',' ',' ',' ','I','I',' ',' ',0,0,0,'ACTUALS',' ',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ',0,'01-OCT-2011',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0,0,0,' ',' ',' ',' ',' ',0,'N',' ',' ',' ',' ','01-OCT-2011','I','Y','V','V','C','01-OCT-2011',' ',' ','01-OCT-2011',0,0,0,' ',0,'Y','APVD','AP',' ','N',0,0,0,0,0,0,' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0)
INSERT INTO PS_VCHR_ACCTG_LINE
VALUES(22,'00036349',0,'ACCRUAL','PPAY',99998,1,1,'DST',0 ,'LOCAL',' ',12350,' ',' ',' ',-177387,'INR','CRRNT',1,1,-177387,0,0,' ','Expense Distribution', -177387,-177387,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ','01-OCT-2011',0,0,22000,' ','',0,'N','N',671436,'N','N',' ','N',0,0,' ',' ',0,0,0,'N',0,0,' ',' ',' ',' ',' ',' ','I','INR','N',' ',' ',' ',' ','I','I',' ',' ',0,0,0,'ACTUALS',' ',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ' ,0,'',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',0,0,0,' ',' ',22000,22000,' ',0,'E',' ',' ',' ',' ','01-OCT-2011','I','Y','V','V','C','01-OCT-2011',' ',' ','01-OCT-2011',0,0,0,' ',0,'N','APVD','AP',' ','N',0,0,0,0,0,0,' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0)
INSERT INTO PS_VCHR_ACCTG_LINE
VALUES(22,'00036349',0,'ACCRUAL','PPAY',99998,1,1,'WTH',51,'LOCAL',' ',23420,' ',' ',' ', 1774,'INR','CRRNT',1,1, 1774,0,0,' ','Withholding Liability',-177387,-177387,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ','07-Oct-2011',0,0,'22000',' ',,0,'N','N',671436,'N',' ',' ',' ',0,0,' ',' ',0,0,0,' ',0,0,' ',' ',' ',' ',' ',' ','I','INR',' ',' ',' ',' ',' ','I','I',' ',' ',0,0,0,'ACTUALS',' ',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ',0,'07-Oct-2011',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0,0,0,' ',' ',' ',' ',' ',0,'N',' ',,' ',' ','07-Oct-2011','I','Y','V','V','C','07-Oct-2011',' ',' ','07-Oct-2011',0,0,0,' ',0,'N','APVD','AP',' ','N',0,0,0,0,0,0,' ',' ',' ',' ',' ',' ',' ',' ',' ','N',0)
