1.SELECT T1.[TransId], T0.[Debit], T0.[Credit], T0.[ShortName], T0.[BPLId] FROM JDT1 T0 INNER JOIN OJDT T1 ON T0.[TransId] = T1.[TransId] WHERE T1.[TransId] =317966
2.UPDATE JDT1 SET BPLD=3 WHERE TRANSID=317966

2.UPDATE JDT1 SET BPLD=3 WHERE TRANSID=317966