org.compiere.sqlj
Class Invoice

java.lang.Object
  org.compiere.sqlj.Invoice

public class Invoice
extends Object

SQLJ Invoice related Functions

Version:

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

Author:

Jorg Janke

Constructor Summary

Invoice()

Method Summary

static BigDecimal	allocatedAmt(int C_Invoice_ID, int C_Currency_ID, int C_ConversionType_ID, BigDecimal MultiplierAP) Get Allocated Amt (not directly used)
static BigDecimal	allocatedAmtToDate(int C_Invoice_ID, int C_Currency_ID, int C_ConversionType_ID, BigDecimal MultiplierAP, Timestamp DateAcct) Get Allocated Amt (not directly used)
static BigDecimal	discount(int p_C_Invoice_ID, Timestamp p_PayDate, int p_C_InvoicePaySchedule_ID) Get Invoice discount.
static BigDecimal	open(int p_C_Invoice_ID, int p_C_InvoicePaySchedule_ID) Open Invoice Amount
static BigDecimal	openToDate(int p_C_Invoice_ID, int p_C_InvoicePaySchedule_ID, Timestamp DateAcct) Open Invoice Amount
static BigDecimal	paid(int p_C_Invoice_ID, int p_C_Currency_ID, int p_MultiplierAP) Get Invoice paid(allocated) amount
static BigDecimal	paidToDate(int p_C_Invoice_ID, int p_C_Currency_ID, int p_MultiplierAP, Timestamp DateAcct) Get Invoice paid(allocated) amount

Methods inherited from class java.lang.Object

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

Constructor Detail

Invoice

public Invoice()

Method Detail

open

public static BigDecimal open(int p_C_Invoice_ID,
                              int p_C_InvoicePaySchedule_ID)
                       throws SQLException

Open Invoice Amount. - incoiceOpen

Parameters:

p_C_Invoice_ID - invoice

p_C_InvoicePaySchedule_ID - payment schedule

Returns:

open amount

Throws:

SQLException

openToDate

public static BigDecimal openToDate(int p_C_Invoice_ID,
                                    int p_C_InvoicePaySchedule_ID,
                                    Timestamp DateAcct)
                             throws SQLException

Open Invoice Amount. - incoiceOpen

Parameters:

p_C_Invoice_ID - invoice

p_C_InvoicePaySchedule_ID - payment schedule

DateAcct - Date Account

Returns:

open amount

Throws:

SQLException

paidToDate

public static BigDecimal paidToDate(int p_C_Invoice_ID,
                                    int p_C_Currency_ID,
                                    int p_MultiplierAP,
                                    Timestamp DateAcct)
                             throws SQLException

Get Invoice paid(allocated) amount. - invoicePaid

Parameters:

p_C_Invoice_ID - invoice

p_C_Currency_ID - currency

p_MultiplierAP - multiplier

DateAcct - Date Account

Returns:

paid amount

Throws:

SQLException

paid

public static BigDecimal paid(int p_C_Invoice_ID,
                              int p_C_Currency_ID,
                              int p_MultiplierAP)
                       throws SQLException

Get Invoice paid(allocated) amount. - invoicePaid

Parameters:

p_C_Invoice_ID - invoice

p_C_Currency_ID - currency

p_MultiplierAP - multiplier

Returns:

paid amount

Throws:

SQLException

allocatedAmt

public static BigDecimal allocatedAmt(int C_Invoice_ID,
                                      int C_Currency_ID,
                                      int C_ConversionType_ID,
                                      BigDecimal MultiplierAP)
                               throws SQLException

Get Allocated Amt (not directly used)

Parameters:

C_Invoice_ID - invoice

C_Currency_ID - currency

C_ConversionType_ID - conversion type

MultiplierAP - multiplier

Returns:

allocated amount

Throws:

SQLException

allocatedAmtToDate

public static BigDecimal allocatedAmtToDate(int C_Invoice_ID,
                                            int C_Currency_ID,
                                            int C_ConversionType_ID,
                                            BigDecimal MultiplierAP,
                                            Timestamp DateAcct)
                                     throws SQLException

Get Allocated Amt (not directly used)

Parameters:

C_Invoice_ID - invoice

C_Currency_ID - currency

C_ConversionType_ID - conversion type

MultiplierAP - multiplier

DateAcct - Date Account

Returns:

allocated amount

Throws:

SQLException

discount

public static BigDecimal discount(int p_C_Invoice_ID,
                                  Timestamp p_PayDate,
                                  int p_C_InvoicePaySchedule_ID)
                           throws SQLException

Get Invoice discount. C_Invoice_Discount - invoiceDiscount

Parameters:

p_C_Invoice_ID - invoice

p_PayDate - pay date

p_C_InvoicePaySchedule_ID - pay schedule

Returns:

discount amount or null

Throws:

SQLException