attribute2dbField.put("bankCodeReg12DOC27","BANK_CODE_REG12");
attribute2dbField.put("currencyCodeReg03DOC27","CURRENCY_CODE_REG03");
Response res = org.jallinone.commons.server.QueryUtilExtension.insertTable(
conn,
new UserSessionParameters(username),
vo,
"DOC27_PAYMENTS",
attribute2dbField,
"Y",
"N",
null,
true
);
if (res.isError()) {
throw new Exception(res.getErrorMessage());
}
attribute2dbField.clear();
attribute2dbField.put("companyCodeSys01DOC28","COMPANY_CODE_SYS01");
attribute2dbField.put("progressiveDoc27DOC28","PROGRESSIVE_DOC27");
attribute2dbField.put("progressiveDoc19DOC28","PROGRESSIVE_DOC19");
attribute2dbField.put("paymentValueDOC28","PAYMENT_VALUE");
attribute2dbField.put("payedDOC28","PAYED");
pstmt2 = conn.prepareStatement(
"UPDATE DOC19_EXPIRATIONS SET "+
"PAYED=?,PAYED_VALUE=?,ALREADY_PAYED=?,REAL_PAYMENT_TYPE_CODE_REG11=?,REAL_ACCOUNT_CODE_ACC02=?,"+
"ROUNDING_ACCOUNT_CODE_ACC02=?,LAST_UPDATE_USER=?,LAST_UPDATE_DATE=? "+
"WHERE COMPANY_CODE_SYS01=? AND PROGRESSIVE=?"
);
PaymentDistributionVO dVO = null;
JournalHeaderVO jhVO = null;
String creditDebitAccountCode = null;
String accountCodeTypeACC06 = null;
BigDecimal paymentValue = null;
for(int i=0;i<payDistrs.size();i++) {
dVO = (PaymentDistributionVO)payDistrs.get(i);
dVO.setProgressiveDoc27DOC28(vo.getProgressiveDOC27());
res = org.jallinone.commons.server.QueryUtilExtension.insertTable(
conn,
new UserSessionParameters(username),
dVO,
"DOC28_PAYMENT_DISTRIBUTION",
attribute2dbField,
"Y",
"N",