org.compiere.udf
Class Payment

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

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

SQLJ Payment related Functions

Version:

$Id: Payment.java,v 1.2 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

Payment()

Method Summary

static double	allocated(int p_C_Payment_ID, int p_C_Currency_ID) Get allocated Payment amount
static double	available(int p_C_Payment_ID) Get available Payment amount in payment currency

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

Payment

public Payment()

Method Detail

allocated

public static double allocated(int p_C_Payment_ID,
                               int p_C_Currency_ID)
                        throws SQLException

Get allocated Payment amount. - paymentAllocated

Parameters:

p_C_Payment_ID - payment

p_C_Currency_ID - currency

Returns:

allocated amount

Throws:

SQLException

available

public static double available(int p_C_Payment_ID)
                        throws SQLException

Get available Payment amount in payment currency

Parameters:

p_C_Payment_ID - payment

Returns:

available amt

Throws:

SQLException