org.compiere.udf
Class Account

java.lang.Object
  COM.ibm.db2.app.UDF
      org.compiere.udf.Account

public class Account
extends COM.ibm.db2.app.UDF

SQLJ Account related Functions

Version:

$Id: Account.java,v 1.3 2006/07/30 00:59:07 jjanke Exp $

Author:

Jorg Janke

Field Summary

Fields inherited from class COM.ibm.db2.app.UDF

SQLUDF_FIRST_CALL, SQLUDF_NORMAL_CALL, SQLUDF_TF_CLOSE, SQLUDF_TF_FETCH, SQLUDF_TF_FINAL, SQLUDF_TF_FIRST, SQLUDF_TF_OPEN

Constructor Summary

Account()

Method Summary

static double

balance(int p_Account_ID, BigDecimal p_AmtDr, BigDecimal p_AmtCr) Get Balance based on Account Sign and Type.

Methods inherited from class COM.ibm.db2.app.UDF

close, getCallType, getConnection, getDBapplid, getDBauthid, getDBcodepg, getDBcolname, getDBinfo, getDBname, getDBplatform, getDBprocid, getDBtbname, getDBtbschema, getDBver_rel, getFunctionName, getScratchpad, getSpecificName, isNull, needToSet, set, set, set, set, set, set, set, set, set, set, set, setCodepage, setScratchpad, setSQLmessage, setSQLstate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Account

public Account()

Method Detail

balance

public static double balance(int p_Account_ID,
                             BigDecimal p_AmtDr,
                             BigDecimal p_AmtCr)
                      throws SQLException

Get Balance based on Account Sign and Type. Acct_Balance - acctBalance If an account is specified and found - If the account sign is Natural it sets it based on Account Type

Parameters:

p_Account_ID - account

p_AmtDr - debit

p_AmtCr - credit

Returns:

cr or dr balance

Throws:

SQLException