com.ibm.commerce.orderstatus.objects
Class OrderFulfillmentStatusAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
        |
        +--com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusAccessBean
All Implemented Interfaces:
OrderFulfillmentStatusAccessBeanData
Direct Known Subclasses:
OrderStatusDataBean

public class OrderFulfillmentStatusAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements OrderFulfillmentStatusAccessBeanData

This table contains information about the status of an order for an Order Status Update inbound message. Each row in the table contains information about a single order.

See Also:
Serialized Form

Constructor Summary
OrderFulfillmentStatusAccessBean()
          constructor
OrderFulfillmentStatusAccessBean(javax.ejb.EJBObject o)
          constructor
 
Method Summary
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
protected  java.lang.String defaultJNDIName()
           
  OrderFulfillmentStatusAccessBean findByMaxVersion(java.lang.Long arg0, java.lang.Long arg1)
          Retrieves the OrderFulfillmentStatus that has the maximum version with the specified OrderId.
  OrderFulfillmentStatusAccessBean findByMerchantOrderNumber(java.lang.String arg0)
          Retrieves the OrderFulfillmentStatus with the specified Merchant Order Number.
  OrderFulfillmentStatusAccessBean findByMerchantOrderNumberForUpdate(java.lang.String asMerchantOrderNumber)
          Retrieves the OrderFulfillmentStatus with the specified Merchant Order Number.
  OrderFulfillmentStatusAccessBean findByOrderId(java.lang.Long arg0)
          Retrieves the OrderFulfillmentStatus with the specified OrderId.
  OrderFulfillmentStatusAccessBean findByOrderIdForUpdate(java.lang.Long anOrderId)
          Retrieves the OrderFulfillmentStatus with the specified OrderId.
 java.sql.Timestamp getActualShipDateTime()
          This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP.
 java.lang.String getComment()
          This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254).
 java.lang.String getCurrency()
          This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10).
 java.lang.Integer getField1()
          This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER.
 java.math.BigDecimal getField2()
          This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20 5).
 java.lang.String getField3()
          This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254).
 java.sql.Timestamp getInvoiceDateTime()
          This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP.
 java.math.BigDecimal getInvoiceValue()
          This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20 5).
 java.sql.Timestamp getLastUpdateTime()
          This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP.
 java.lang.String getMerchantOrderNumber()
          This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30).
 java.lang.Long getOrderId()
          This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT.
 java.lang.String getOrderStatus()
          This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32).
 java.lang.Long getOrderStatusId()
          This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.
 java.lang.String getOsCode()
          This method accesses a non-CMP field
 java.sql.Timestamp getPlaceDateTime()
          This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP.
 java.math.BigDecimal getPriceTotal()
          This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20 5).
 java.sql.Timestamp getRequestShipDateTime()
          This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP.
 java.sql.Timestamp getScheduleShipDateTime()
          This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP.
 java.lang.String getSequenceNumber()
          This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64).
 java.lang.String getShipCondition()
          This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2).
 java.lang.String getShippingModeFlag()
          This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1).
 java.math.BigDecimal getShippingTaxTotal()
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20 5).
 java.math.BigDecimal getShippingTotal()
          This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20 5).
 java.math.BigDecimal getTaxTotal()
          This method provides access to the ORDSTAT.OSTXTOT column of DB2 type DECIMAL(20 5).
 java.lang.Integer getVersioning()
          This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER.
protected  void instantiateEJB()
           
protected  boolean instantiateEJBByPrimaryKey()
           
 void propertySet(java.util.Hashtable arg0)
          The property list will be used to set the data in the row being created or referred to.
 void refreshCopyHelper()
          Load data from the EJBObject.
 void setActualShipDateTime(java.sql.Timestamp newValue)
          This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP.
 void setComment(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254).
 void setCurrency(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10).
 void setField1(java.lang.Integer newValue)
          This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER.
 void setField2(java.math.BigDecimal newValue)
          This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20 5).
 void setField3(java.lang.String newValue)
          This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254).
 void setInitKey_orderStatusId(java.lang.Long newValue)
          Set the primary key for this object
 void setInvoiceDateTime(java.sql.Timestamp newValue)
          This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP.
 void setInvoiceValue(java.math.BigDecimal newValue)
          This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20 5).
 void setLastUpdateTime(java.sql.Timestamp newValue)
          This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP.
 void setMerchantOrderNumber(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30).
 void setOrderId(java.lang.Long newValue)
          This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT.
 void setOrderStatus(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32).
 void setOrderStatusId(java.lang.Long newValue)
          This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.
 void setOsCode(java.lang.String newValue)
          This method accesses a non-CMP field
 void setPlaceDateTime(java.sql.Timestamp newValue)
          This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP.
 void setPriceTotal(java.math.BigDecimal newValue)
          This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20 5).
 void setRequestShipDateTime(java.sql.Timestamp newValue)
          This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP.
 void setScheduleShipDateTime(java.sql.Timestamp newValue)
          This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP.
 void setSequenceNumber(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64).
 void setShipCondition(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2).
 void setShippingModeFlag(java.lang.String newValue)
          This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1).
 void setShippingTaxTotal(java.math.BigDecimal newValue)
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20 5).
 void setShippingTotal(java.math.BigDecimal newValue)
          This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20 5).
 void setTaxTotal(java.math.BigDecimal newValue)
          This method provides access to the ORDSTAT.OSTXTOT column of DB2 type DECIMAL(20 5).
 void setVersioning(java.lang.Integer newValue)
          This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OrderFulfillmentStatusAccessBean

public OrderFulfillmentStatusAccessBean()
constructor

OrderFulfillmentStatusAccessBean

public OrderFulfillmentStatusAccessBean(javax.ejb.EJBObject o)
                                 throws java.rmi.RemoteException
constructor
Parameters:
o - javax.ejb.EJBObject
Throws:
java.rmi.RemoteException
Method Detail

findByMaxVersion

public OrderFulfillmentStatusAccessBean findByMaxVersion(java.lang.Long arg0,
                                                         java.lang.Long arg1)
                                                  throws java.rmi.RemoteException,
                                                         javax.ejb.FinderException,
                                                         javax.naming.NamingException

Retrieves the OrderFulfillmentStatus that has the maximum version with the specified OrderId.

The SQL query used to fetch the requested row from the ORDSTAT table is:

SELECT * FROM ORDSTAT T1 WHERE (T1.ORDERS_ID = ?) AND (T1.OSVERNBR = (SELECT MAX(OSVERNBR) FROM ORDSTAT WHERE ORDERS_ID = ?))

Returns:
The order fulfillment status object found.
Throws:
java.rmi.RemoteException - Raised whenever a communication related problems occured
javax.ejb.FinderEception - Raised whenever a request object is not found
javax.ejb.FinderException
javax.naming.NamingException

findByMerchantOrderNumber

public OrderFulfillmentStatusAccessBean findByMerchantOrderNumber(java.lang.String arg0)
                                                           throws java.rmi.RemoteException,
                                                                  javax.ejb.FinderException,
                                                                  javax.naming.NamingException

Retrieves the OrderFulfillmentStatus with the specified Merchant Order Number.

The SQL query used to fetch the requested row from the ORDSTAT table is:

SELECT * FROM ORDSTAT T1 WHERE(T1.OSMORDER = ?) AND (T1.OSVERNBR = 0)

Returns:
The order fulfillment status object found.
Throws:
java.rmi.RemoteException - Raised whenever a communication related problems occured
javax.ejb.FinderEception - Raised whenever a request object is not found
javax.ejb.FinderException
javax.naming.NamingException

findByOrderId

public OrderFulfillmentStatusAccessBean findByOrderId(java.lang.Long arg0)
                                               throws java.rmi.RemoteException,
                                                      javax.ejb.FinderException,
                                                      javax.naming.NamingException

Retrieves the OrderFulfillmentStatus with the specified OrderId.

The SQL query used to fetch the requested row from the ORDSTAT table is:

SELECT * FROM ORDSTAT T1 WHERE (T1.ORDERS_ID = ?) AND (T1.OSVERNBR = 0)

Returns:
The order fulfillment status object found.
Throws:
java.rmi.RemoteException - Raised whenever a communication related problems occured
javax.ejb.FinderEception - Raised whenever a request object is not found
javax.ejb.FinderException
javax.naming.NamingException

setInitKey_orderStatusId

public void setInitKey_orderStatusId(java.lang.Long newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.Long
Returns:
void

defaultJNDIName

protected java.lang.String defaultJNDIName()
Returns:
String

instantiateEJB

protected void instantiateEJB()
                       throws java.rmi.RemoteException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException
Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

instantiateEJBByPrimaryKey

protected boolean instantiateEJBByPrimaryKey()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.naming.NamingException
Returns:
boolean
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.naming.NamingException

commitCopyHelper

public void commitCopyHelper()
                      throws java.rmi.RemoteException,
                             javax.ejb.CreateException,
                             javax.ejb.FinderException,
                             javax.naming.NamingException

Update(flush) data to the EJBObject (persistent storage).

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

refreshCopyHelper

public void refreshCopyHelper()
                       throws java.rmi.RemoteException,
                              javax.ejb.CreateException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException

Load data from the EJBObject.

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getLastUpdateTime

public java.sql.Timestamp getLastUpdateTime()
                                     throws java.rmi.RemoteException,
                                            javax.ejb.CreateException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Last update time stamp for the order.

Specified by:
getLastUpdateTime in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setLastUpdateTime

public void setLastUpdateTime(java.sql.Timestamp newValue)

This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Last update time stamp for the order.

Specified by:
setLastUpdateTime in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.sql.Timestamp
Returns:
void

getTaxTotal

public java.math.BigDecimal getTaxTotal()
                                 throws java.rmi.RemoteException,
                                        javax.ejb.CreateException,
                                        javax.ejb.FinderException,
                                        javax.naming.NamingException

This method provides access to the ORDSTAT.OSTXTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total tax for the order.

Specified by:
getTaxTotal in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTaxTotal

public void setTaxTotal(java.math.BigDecimal newValue)

This method provides access to the ORDSTAT.OSTXTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total tax for the order.

Specified by:
setTaxTotal in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.math.BigDecimal
Returns:
void

getInvoiceValue

public java.math.BigDecimal getInvoiceValue()
                                     throws java.rmi.RemoteException,
                                            javax.ejb.CreateException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Net value of the invoice.

Specified by:
getInvoiceValue in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setInvoiceValue

public void setInvoiceValue(java.math.BigDecimal newValue)

This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Net value of the invoice.

Specified by:
setInvoiceValue in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.math.BigDecimal
Returns:
void

getVersioning

public java.lang.Integer getVersioning()
                                throws java.rmi.RemoteException,
                                       javax.ejb.CreateException,
                                       javax.ejb.FinderException,
                                       javax.naming.NamingException

This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER.

The following is a description of this column:

Order status version number. A value of &quo

Specified by:
getVersioning in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setVersioning

public void setVersioning(java.lang.Integer newValue)

This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER.

The following is a description of this column:

Order status version number. A value of &quo

Specified by:
setVersioning in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.Integer
Returns:
void

getComment

public java.lang.String getComment()
                            throws java.rmi.RemoteException,
                                   javax.ejb.CreateException,
                                   javax.ejb.FinderException,
                                   javax.naming.NamingException

This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254).

The following is a description of this column:

Comments for this order status.

Specified by:
getComment in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setComment

public void setComment(java.lang.String newValue)

This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254).

The following is a description of this column:

Comments for this order status.

Specified by:
setComment in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getPlaceDateTime

public java.sql.Timestamp getPlaceDateTime()
                                    throws java.rmi.RemoteException,
                                           javax.ejb.CreateException,
                                           javax.ejb.FinderException,
                                           javax.naming.NamingException

This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Order placed time stamp.

Specified by:
getPlaceDateTime in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setPlaceDateTime

public void setPlaceDateTime(java.sql.Timestamp newValue)

This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Order placed time stamp.

Specified by:
setPlaceDateTime in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.sql.Timestamp
Returns:
void

getShipCondition

public java.lang.String getShipCondition()
                                  throws java.rmi.RemoteException,
                                         javax.ejb.CreateException,
                                         javax.ejb.FinderException,
                                         javax.naming.NamingException

This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2).

The following is a description of this column:

Code indicating if partial shipment of the order is accepted. Valid values:&l

Specified by:
getShipCondition in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setShipCondition

public void setShipCondition(java.lang.String newValue)

This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2).

The following is a description of this column:

Code indicating if partial shipment of the order is accepted. Valid values:&l

Specified by:
setShipCondition in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getSequenceNumber

public java.lang.String getSequenceNumber()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64).

The following is a description of this column:

Order status sequence number for serialization.

Specified by:
getSequenceNumber in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setSequenceNumber

public void setSequenceNumber(java.lang.String newValue)

This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64).

The following is a description of this column:

Order status sequence number for serialization.

Specified by:
setSequenceNumber in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getPriceTotal

public java.math.BigDecimal getPriceTotal()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total product price for the order.

Specified by:
getPriceTotal in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setPriceTotal

public void setPriceTotal(java.math.BigDecimal newValue)

This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total product price for the order.

Specified by:
setPriceTotal in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.math.BigDecimal
Returns:
void

getShippingTaxTotal

public java.math.BigDecimal getShippingTaxTotal()
                                         throws java.rmi.RemoteException,
                                                javax.ejb.CreateException,
                                                javax.ejb.FinderException,
                                                javax.naming.NamingException

This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total tax on shipping charges for the order.

Specified by:
getShippingTaxTotal in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setShippingTaxTotal

public void setShippingTaxTotal(java.math.BigDecimal newValue)

This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total tax on shipping charges for the order.

Specified by:
setShippingTaxTotal in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.math.BigDecimal
Returns:
void

getCurrency

public java.lang.String getCurrency()
                             throws java.rmi.RemoteException,
                                    javax.ejb.CreateException,
                                    javax.ejb.FinderException,
                                    javax.naming.NamingException

This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10).

The following is a description of this column:

Currency in which the price is expressed. This is a currency code as per ISO 4217 standards.

Specified by:
getCurrency in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setCurrency

public void setCurrency(java.lang.String newValue)

This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10).

The following is a description of this column:

Currency in which the price is expressed. This is a currency code as per ISO 4217 standards.

Specified by:
setCurrency in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getField3

public java.lang.String getField3()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException

This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254).

The following is a description of this column:

Customizable.

Specified by:
getField3 in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setField3

public void setField3(java.lang.String newValue)

This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254).

The following is a description of this column:

Customizable.

Specified by:
setField3 in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getField2

public java.math.BigDecimal getField2()
                               throws java.rmi.RemoteException,
                                      javax.ejb.CreateException,
                                      javax.ejb.FinderException,
                                      javax.naming.NamingException

This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Customizable.

Specified by:
getField2 in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setField2

public void setField2(java.math.BigDecimal newValue)

This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Customizable.

Specified by:
setField2 in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.math.BigDecimal
Returns:
void

getField1

public java.lang.Integer getField1()
                            throws java.rmi.RemoteException,
                                   javax.ejb.CreateException,
                                   javax.ejb.FinderException,
                                   javax.naming.NamingException

This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER.

The following is a description of this column:

Customizable.

Specified by:
getField1 in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setField1

public void setField1(java.lang.Integer newValue)

This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER.

The following is a description of this column:

Customizable.

Specified by:
setField1 in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.Integer
Returns:
void

getActualShipDateTime

public java.sql.Timestamp getActualShipDateTime()
                                         throws java.rmi.RemoteException,
                                                javax.ejb.CreateException,
                                                javax.ejb.FinderException,
                                                javax.naming.NamingException

This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Actual shipping time stamp.

Specified by:
getActualShipDateTime in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setActualShipDateTime

public void setActualShipDateTime(java.sql.Timestamp newValue)

This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Actual shipping time stamp.

Specified by:
setActualShipDateTime in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.sql.Timestamp
Returns:
void

getOrderStatusId

public java.lang.Long getOrderStatusId()
                                throws java.rmi.RemoteException,
                                       javax.ejb.CreateException,
                                       javax.ejb.FinderException,
                                       javax.naming.NamingException

This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

Order status reference number. This is the primary key for this table.

Specified by:
getOrderStatusId in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setOrderStatusId

public void setOrderStatusId(java.lang.Long newValue)

This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

Order status reference number. This is the primary key for this table.

Specified by:
setOrderStatusId in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.Long
Returns:
void

getShippingModeFlag

public java.lang.String getShippingModeFlag()
                                     throws java.rmi.RemoteException,
                                            javax.ejb.CreateException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1).

The following is a description of this column:

Code indicating the level for the shipping address and shipping mode. Valid values:&l

Specified by:
getShippingModeFlag in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setShippingModeFlag

public void setShippingModeFlag(java.lang.String newValue)

This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1).

The following is a description of this column:

Code indicating the level for the shipping address and shipping mode. Valid values:&l

Specified by:
setShippingModeFlag in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getOrderId

public java.lang.Long getOrderId()
                          throws java.rmi.RemoteException,
                                 javax.ejb.CreateException,
                                 javax.ejb.FinderException,
                                 javax.naming.NamingException

This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT.

The following is a description of this column:

WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS table.

Specified by:
getOrderId in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setOrderId

public void setOrderId(java.lang.Long newValue)

This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT.

The following is a description of this column:

WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS table.

Specified by:
setOrderId in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.Long
Returns:
void

getOrderStatus

public java.lang.String getOrderStatus()
                                throws java.rmi.RemoteException,
                                       javax.ejb.CreateException,
                                       javax.ejb.FinderException,
                                       javax.naming.NamingException

This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32).

The following is a description of this column:

Status of the order.

Specified by:
getOrderStatus in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setOrderStatus

public void setOrderStatus(java.lang.String newValue)

This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32).

The following is a description of this column:

Status of the order.

Specified by:
setOrderStatus in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getShippingTotal

public java.math.BigDecimal getShippingTotal()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.ejb.FinderException,
                                             javax.naming.NamingException

This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total shipping charges for the order.

Specified by:
getShippingTotal in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setShippingTotal

public void setShippingTotal(java.math.BigDecimal newValue)

This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Total shipping charges for the order.

Specified by:
setShippingTotal in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.math.BigDecimal
Returns:
void

getInvoiceDateTime

public java.sql.Timestamp getInvoiceDateTime()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.ejb.FinderException,
                                             javax.naming.NamingException

This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Invoice time stamp.

Specified by:
getInvoiceDateTime in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setInvoiceDateTime

public void setInvoiceDateTime(java.sql.Timestamp newValue)

This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Invoice time stamp.

Specified by:
setInvoiceDateTime in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.sql.Timestamp
Returns:
void

getMerchantOrderNumber

public java.lang.String getMerchantOrderNumber()
                                        throws java.rmi.RemoteException,
                                               javax.ejb.CreateException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30).

The following is a description of this column:

Order number generated by the backend system.

Specified by:
getMerchantOrderNumber in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setMerchantOrderNumber

public void setMerchantOrderNumber(java.lang.String newValue)

This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30).

The following is a description of this column:

Order number generated by the backend system.

Specified by:
setMerchantOrderNumber in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.lang.String
Returns:
void

getRequestShipDateTime

public java.sql.Timestamp getRequestShipDateTime()
                                          throws java.rmi.RemoteException,
                                                 javax.ejb.CreateException,
                                                 javax.ejb.FinderException,
                                                 javax.naming.NamingException

This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Requested shipping time stamp.

Specified by:
getRequestShipDateTime in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setRequestShipDateTime

public void setRequestShipDateTime(java.sql.Timestamp newValue)

This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Requested shipping time stamp.

Specified by:
setRequestShipDateTime in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.sql.Timestamp
Returns:
void

getScheduleShipDateTime

public java.sql.Timestamp getScheduleShipDateTime()
                                           throws java.rmi.RemoteException,
                                                  javax.ejb.CreateException,
                                                  javax.ejb.FinderException,
                                                  javax.naming.NamingException

This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Scheduled shipping time stamp.

Specified by:
getScheduleShipDateTime in interface OrderFulfillmentStatusAccessBeanData
Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setScheduleShipDateTime

public void setScheduleShipDateTime(java.sql.Timestamp newValue)

This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP.

The following is a description of this column:

Scheduled shipping time stamp.

Specified by:
setScheduleShipDateTime in interface OrderFulfillmentStatusAccessBeanData
Parameters:
newValue - java.sql.Timestamp
Returns:
void

propertySet

public void propertySet(java.util.Hashtable arg0)
                 throws java.rmi.RemoteException,
                        javax.ejb.FinderException,
                        javax.naming.NamingException

The property list will be used to set the data in the row being created or referred to.

The list entries may include: Long orderId; //ORDERS_ID String merchantOrderNumber; //OSMORDER String partNumber; //PARTNUMBER String currency; //OSCPCUR BigDecimal priceTotal; //OSPRTOT BigDecimal taxTotal; //OSTXTOT BigDecimal shippingTotal; //OSSHTOT BigDecimal shippingTaxTotal; //OSSHTXTOT String orderStatus; //OSSTATUS Timestamp placeDateTime; //OSPLTIME Timestamp requestShipDateTime; //OSRSTIME Timestamp scheduleShipDateTime; //OSSSTIME Timestamp actualShipDateTime; //OSASTIME Timestamp invoiceDateTime; //OSINVTIME BigDecimal invoiceValue; //OSINVVAL String shipCondtion; //OSSCOND String shippingModeFlag; //OSSMFLAG Timestamp lastUpdateTime; //OSUPDTIME String sequenceNumber; //OSSEQNUM String comment; //OSCMNT int field1; //FIELD1 BigDecimal field2; //FIELD2 String field3; //FIELD3

Throws:
java.rmi.RemoteException - Raised whenever a communication related problems occured
javax.ejb.FinderException
javax.naming.NamingException

getOsCode

public java.lang.String getOsCode()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException
This method accesses a non-CMP field
Specified by:
getOsCode in interface OrderFulfillmentStatusAccessBeanData
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setOsCode

public void setOsCode(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setOsCode in interface OrderFulfillmentStatusAccessBeanData

findByMerchantOrderNumberForUpdate

public OrderFulfillmentStatusAccessBean findByMerchantOrderNumberForUpdate(java.lang.String asMerchantOrderNumber)
                                                                    throws javax.naming.NamingException,
                                                                           javax.ejb.FinderException,
                                                                           java.rmi.RemoteException

Retrieves the OrderFulfillmentStatus with the specified Merchant Order Number.

The SQL query used to fetch the requested row from the ORDSTAT table is:

SELECT * FROM ORDSTAT T1 WHERE(T1.OSMORDER = ?) AND (T1.OSVERNBR = 0) FOR UPDATE

Returns:
The order fulfillment status object found.
Throws:
java.rmi.RemoteException - Raised whenever a communication related problems occured
javax.ejb.FinderEception - Raised whenever a request object is not found
javax.naming.NamingException
javax.ejb.FinderException

findByOrderIdForUpdate

public OrderFulfillmentStatusAccessBean findByOrderIdForUpdate(java.lang.Long anOrderId)
                                                        throws javax.naming.NamingException,
                                                               javax.ejb.FinderException,
                                                               java.rmi.RemoteException

Retrieves the OrderFulfillmentStatus with the specified OrderId.

The SQL query used to fetch the requested row from the ORDSTAT table is:

SELECT * FROM ORDSTAT T1 WHERE (T1.ORDERS_ID = ?) AND (T1.OSVERNBR = 0) FOR UPDATE

Returns:
The order fulfillment status object found.
Throws:
java.rmi.RemoteException - Raised whenever a communication related problems occured
javax.ejb.FinderEception - Raised whenever a request object is not found
javax.naming.NamingException
javax.ejb.FinderException