com.ibm.commerce.orderstatus.objects
Class OrderFulfillmentStatusAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractAccessBean
        |
        +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
              |
              +--com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusAccessBean
All Implemented Interfaces:
OrderFulfillmentStatusAccessBeanData, java.io.Serializable

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

This bean provides access to the ORDSTAT table.

The following is a description of this table:

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

Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef
 
Constructor Summary
OrderFulfillmentStatusAccessBean()
          Default constructor.
OrderFulfillmentStatusAccessBean(javax.ejb.EJBObject object)
          Creates an access bean for the specified EJB
OrderFulfillmentStatusAccessBean(java.util.Hashtable ahsProperty)
          Maps to a corresponding ejbCreate method in the home interface of the EJB.
OrderFulfillmentStatusAccessBean(java.lang.Integer anVersion)
          Maps to a corresponding ejbCreate method in the home interface of the EJB.
 
Method Summary
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
 OrderFulfillmentStatusAccessBean findByMaxVersion(java.lang.Long lOrderId, java.lang.Long lOrderIdCopy)
          Retrieves the OrderFulfillmentStatusAccessBean that has the maximum version with the specified OrderId.
 OrderFulfillmentStatusAccessBean findByMerchantOrderNumber(java.lang.String sMerchantOrder)
          Retrieves the OrderFulfillmentStatusAccessBean with the specified Merchant Order Number.
 OrderFulfillmentStatusAccessBean findByOrderId(java.lang.Long lOrderId)
          Retrieves the OrderFulfillmentStatusAccessBean with the specified OrderId.
 java.sql.Timestamp getActualShipDateTime()
          This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP NULL.
 java.lang.String getComment()
          This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254) NULL.
 java.lang.String getCurrency()
          This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10) NULL.
 java.lang.Integer getField1()
          This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER NULL.
 java.math.BigDecimal getField2()
          This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getField3()
          This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254) NULL.
 java.sql.Timestamp getInvoiceDateTime()
          This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP NULL.
 java.math.BigDecimal getInvoiceValue()
          This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20,5) NULL.
 java.sql.Timestamp getLastUpdateTime()
          This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP NULL.
 java.lang.String getMerchantOrderNumber()
          This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30) NULL.
 java.lang.Long getOrderId()
          This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT NULL.
 java.lang.String getOrderStatus()
          This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32) NULL.
 java.lang.Long getOrderStatusId()
          This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.
 java.sql.Timestamp getPlaceDateTime()
          This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP NULL.
 java.math.BigDecimal getPriceTotal()
          This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20,5) NULL.
 java.sql.Timestamp getRequestShipDateTime()
          This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getScheduleShipDateTime()
          This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP NULL.
 java.lang.String getSequenceNumber()
          This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64) NULL.
 java.lang.String getShipCondition()
          This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2) NULL.
 java.lang.String getShippingModeFlag()
          This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1) NULL.
 java.math.BigDecimal getShippingTaxTotal()
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getShippingTotal()
          This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTaxTotal()
          This method provides access to the ORDSTAT.OSTXTOT column of DB2 type DECIMAL(20,5) NULL.
 java.lang.Integer getVersioning()
          This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER NULL.
 void propertySet(java.util.Hashtable ahsProperty)
          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 aActualShipDateTime)
          This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP NULL.
 void setComment(java.lang.String aComment)
          This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254) NULL.
 void setCurrency(java.lang.String aCurrency)
          This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10) NULL.
 void setField1(java.lang.Integer aField1)
          This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER NULL.
 void setField2(java.math.BigDecimal aField2)
          This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 void setField3(java.lang.String aField3)
          This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254) NULL.
 void setInitKey_orderStatusId(java.lang.Long aInitKey_orderStatusId)
          Set the primary key for this object
 void setInvoiceDateTime(java.sql.Timestamp aInvoiceDateTime)
          This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP NULL.
 void setInvoiceValue(java.math.BigDecimal aInvoiceValue)
          This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20,5) NULL.
 void setLastUpdateTime(java.sql.Timestamp aLastUpdateTime)
          This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP NULL.
 void setMerchantOrderNumber(java.lang.String aMerchantOrderNumber)
          This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30) NULL.
 void setOrderId(java.lang.Long aOrderId)
          This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT NULL.
 void setOrderStatus(java.lang.String aOrderStatus)
          This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32) NULL.
 void setOrderStatusId(java.lang.Long aOrderStatusId)
          This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.
 void setPlaceDateTime(java.sql.Timestamp aPlaceDateTime)
          This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP NULL.
 void setPriceTotal(java.math.BigDecimal aPriceTotal)
          This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20,5) NULL.
 void setRequestShipDateTime(java.sql.Timestamp aRequestShipDateTime)
          This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP NULL.
 void setScheduleShipDateTime(java.sql.Timestamp aScheduleShipDateTime)
          This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP NULL.
 void setSequenceNumber(java.lang.String aSequenceNumber)
          This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64) NULL.
 void setShipCondition(java.lang.String aShipCondition)
          This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2) NULL.
 void setShippingModeFlag(java.lang.String aShippingModeFlag)
          This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1) NULL.
 void setShippingTaxTotal(java.math.BigDecimal aShippingTaxTotal)
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20,5) NULL.
 void setShippingTotal(java.math.BigDecimal aShippingTotal)
          This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20,5) NULL.
 void setTaxTotal(java.math.BigDecimal aTaxTotal)
          This method provides access to the ORDSTAT.OSTXTOT column of DB2 type DECIMAL(20,5) NULL.
 void setVersioning(java.lang.Integer aVersioning)
          This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER NULL.
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
__getCache, __getCache, __getKey, __setCache, __setCache, __setKey, commitCopyHelper, createAccessBeans, createAccessBeans, instantiateEJBByPrimaryKey, refreshCopyHelper, setEJBRef
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
defaultJNDIName, defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, instantiateEJB, resetEJBRef, resetHomeCache, setInit_GlobalNameServiceTypeName, setInit_GlobalNameServiceURLName, setInit_JNDIName, setInit_NameServiceTypeName, setInit_NameServiceURLName
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OrderFulfillmentStatusAccessBean

public OrderFulfillmentStatusAccessBean()

Default constructor. Maps to findByPrimaryKey.


OrderFulfillmentStatusAccessBean

public OrderFulfillmentStatusAccessBean(javax.ejb.EJBObject object)
                                 throws java.rmi.RemoteException

Creates an access bean for the specified EJB

Parameters:
object - The EJB Object used for the access bean construction.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception

OrderFulfillmentStatusAccessBean

public OrderFulfillmentStatusAccessBean(java.util.Hashtable ahsProperty)
                                 throws javax.naming.NamingException,
                                        javax.ejb.CreateException,
                                        java.rmi.RemoteException,
                                        javax.ejb.FinderException

Maps to a corresponding ejbCreate method in the home interface of the EJB.

The property list provided will be used to call propertySet(java.util.Hashtable ahsProperty) and set data in the newly created row.

By default, the order status version number (i.e. OSVERNBR) will be set to 0 of DB2 type INTEGER NULL.

Parameters:
ahsProperty - java.util.Hashtable
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

OrderFulfillmentStatusAccessBean

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

Maps to a corresponding ejbCreate method in the home interface of the EJB. The parameter provided will be used to specify the version value of the newly created row in ORDSTAT table.

The value of anVersion will be used for the column ORDSTAT.OSVERNBR.

Parameters:
anVersion - java.lang.Integer
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
Method Detail

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).

Overrides:
commitCopyHelper in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findByMaxVersion

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

Retrieves the OrderFulfillmentStatusAccessBean 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 = ?))

Parameters:
lOrderId - java.lang.Long
lOrderIdCopy - java.lang.Long (the same value as 'lOrderId')
Returns:
com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusAccessBean
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findByMerchantOrderNumber

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

Retrieves the OrderFulfillmentStatusAccessBean 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

Parameters:
sMerchantOrder - java.lang.String
Returns:
com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusAccessBean
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findByOrderId

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

Retrieves the OrderFulfillmentStatusAccessBean 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

Parameters:
lOrderId - java.lang.Long
Returns:
com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusAccessBean
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

The following is a description of this column:

Customizable.

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

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) NULL.

The following is a description of this column:

Customizable.

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

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) NULL.

The following is a description of this column:

Customizable.

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

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

The following is a description of this column:

Order number generated by the back end system.

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

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

The following is a description of this column:

Code indicating if partial shipment of the order is accepted. Valid values are SC (ship complete order) and SP (ship partial order).

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

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) NULL.

The following is a description of this column:

Code indicating the level for the shipping address and shipping mode. Valid values are O (order level), I (item level).

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

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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) NULL.

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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 NULL.

The following is a description of this column:

Order status version number. A value of "0" (zero) indicates the most recent version of the order. The highest value indicates the second most recent version of the order.

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

propertySet

public void propertySet(java.util.Hashtable ahsProperty)
                 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

Parameters:
ahsProperty - java.util.Hashtable
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

refreshCopyHelper

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

Load data from the EJBObject.

Overrides:
refreshCopyHelper in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

setActualShipDateTime

public void setActualShipDateTime(java.sql.Timestamp aActualShipDateTime)

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

The following is a description of this column:

Actual shipping time stamp.

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

setComment

public void setComment(java.lang.String aComment)

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

The following is a description of this column:

Comments for this order status.

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

setCurrency

public void setCurrency(java.lang.String aCurrency)

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

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:
aCurrency - java.lang.String
Returns:
void

setField1

public void setField1(java.lang.Integer aField1)

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

The following is a description of this column:

Customizable.

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

setField2

public void setField2(java.math.BigDecimal aField2)

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

The following is a description of this column:

Customizable.

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

setField3

public void setField3(java.lang.String aField3)

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

The following is a description of this column:

Customizable.

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

setInitKey_orderStatusId

public void setInitKey_orderStatusId(java.lang.Long aInitKey_orderStatusId)

Set the primary key for this object

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

setInvoiceDateTime

public void setInvoiceDateTime(java.sql.Timestamp aInvoiceDateTime)

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

The following is a description of this column:

Invoice time stamp.

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

setInvoiceValue

public void setInvoiceValue(java.math.BigDecimal aInvoiceValue)

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

The following is a description of this column:

Net value of the invoice.

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

setLastUpdateTime

public void setLastUpdateTime(java.sql.Timestamp aLastUpdateTime)

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

The following is a description of this column:

Last update time stamp for the order.

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

setMerchantOrderNumber

public void setMerchantOrderNumber(java.lang.String aMerchantOrderNumber)

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

The following is a description of this column:

Order number generated by the back end system.

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

setOrderId

public void setOrderId(java.lang.Long aOrderId)

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

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:
aOrderId - java.lang.Long
Returns:
void

setOrderStatus

public void setOrderStatus(java.lang.String aOrderStatus)

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

The following is a description of this column:

Status of the order.

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

setOrderStatusId

public void setOrderStatusId(java.lang.Long aOrderStatusId)

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:
aOrderStatusId - java.lang.Long
Returns:
void

setPlaceDateTime

public void setPlaceDateTime(java.sql.Timestamp aPlaceDateTime)

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

The following is a description of this column:

Order placed time stamp.

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

setPriceTotal

public void setPriceTotal(java.math.BigDecimal aPriceTotal)

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

The following is a description of this column:

Total product price for the order.

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

setRequestShipDateTime

public void setRequestShipDateTime(java.sql.Timestamp aRequestShipDateTime)

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

The following is a description of this column:

Requested shipping time stamp.

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

setScheduleShipDateTime

public void setScheduleShipDateTime(java.sql.Timestamp aScheduleShipDateTime)

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

The following is a description of this column:

Scheduled shipping time stamp.

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

setSequenceNumber

public void setSequenceNumber(java.lang.String aSequenceNumber)

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

The following is a description of this column:

Order status sequence number for serialization.

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

setShipCondition

public void setShipCondition(java.lang.String aShipCondition)

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

The following is a description of this column:

Code indicating if partial shipment of the order is accepted. Valid values are SC (ship complete order) and SP (ship partial order).

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

setShippingModeFlag

public void setShippingModeFlag(java.lang.String aShippingModeFlag)

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

The following is a description of this column:

Code indicating the level for the shipping address and shipping mode. Valid values are O (order level), I (item level).

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

setShippingTaxTotal

public void setShippingTaxTotal(java.math.BigDecimal aShippingTaxTotal)

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

The following is a description of this column:

Total tax on shipping charges for the order.

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

setShippingTotal

public void setShippingTotal(java.math.BigDecimal aShippingTotal)

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

The following is a description of this column:

Total shipping charges for the order.

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

setTaxTotal

public void setTaxTotal(java.math.BigDecimal aTaxTotal)

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

The following is a description of this column:

Total tax for the order.

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

setVersioning

public void setVersioning(java.lang.Integer aVersioning)

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

The following is a description of this column:

Order status version number. A value of "0" (zero) indicates the most recent version of the order. The highest value indicates the second most recent version of the order.

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