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. This access bean corresponds to the database table 'ORDSTAT'.

See Also:
Serialized Form

Constructor Summary
OrderFulfillmentStatusAccessBean()
Zero argument constructor used to initialize the access bean.
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 orderId1, java.lang.Long orderId2)
Retrieves the OrderFulfillmentStatus that has the maximum version with the specified OrderId.
OrderFulfillmentStatusAccessBean findByMerchantOrderNumber(java.lang.String merchantOrderNumber)
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 orderId)
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 arg1)
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 accesses a non-CMP field
void setComment(java.lang.String newValue)
This method accesses a non-CMP field
void setCurrency(java.lang.String newValue)
This method accesses a non-CMP field
void setField1(java.lang.Integer newValue)
This method accesses a non-CMP field
void setField2(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setField3(java.lang.String newValue)
This method accesses a non-CMP field
void setInitKey_orderStatusId(java.lang.Long newValue)
Set the primary key for this object
void setInvoiceDateTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setInvoiceValue(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setLastUpdateTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setMerchantOrderNumber(java.lang.String newValue)
This method accesses a non-CMP field
void setOrderId(java.lang.Long newValue)
This method accesses a non-CMP field
void setOrderStatus(java.lang.String newValue)
This method accesses a non-CMP field
void setOrderStatusId(java.lang.Long newValue)
This method accesses a non-CMP field
void setOsCode(java.lang.String newValue)
This method accesses a non-CMP field
void setPlaceDateTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setPriceTotal(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setRequestShipDateTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setScheduleShipDateTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setSequenceNumber(java.lang.String newValue)
This method accesses a non-CMP field
void setShipCondition(java.lang.String newValue)
This method accesses a non-CMP field
void setShippingModeFlag(java.lang.String newValue)
This method accesses a non-CMP field
void setShippingTaxTotal(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setShippingTotal(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setTaxTotal(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setVersioning(java.lang.Integer newValue)
This method accesses a non-CMP field
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OrderFulfillmentStatusAccessBean

public OrderFulfillmentStatusAccessBean()
Zero argument constructor used to initialize the access bean. This constructor corresponds to the following home interface method: public abstract com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatus com.ibm.commerce.orderstatus.objimpl.OrderFulfillmentStatusHomeBase.findByPrimaryKey(com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusKey) throws java.rmi.RemoteException,javax.ejb.FinderException The home interface method properties need to be set by calling the following setter methods before calling any business methods: setInitKey_orderStatusId( java.lang.Long )

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 orderId1,
                                                         java.lang.Long orderId2)
                                                  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 = ?))

Parameters:
orderId1 - The order identifier.
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 merchantOrderNumber)
                                                           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)

Parameters:
merchantOrderNumber - The merchant order number (order number generated by the backend system).
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 orderId)
                                               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)

Parameters:
orderId - The order identifier.
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 accesses a non-CMP field
Specified by:
setLastUpdateTime in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setTaxTotal in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setInvoiceValue in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setVersioning in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setComment in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setPlaceDateTime in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setShipCondition in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setSequenceNumber in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setPriceTotal in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setShippingTaxTotal in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setCurrency in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setField3 in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setField2 in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setField1 in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setActualShipDateTime in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setOrderStatusId in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setShippingModeFlag in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setOrderId in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setOrderStatus in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setShippingTotal in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setInvoiceDateTime in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setMerchantOrderNumber in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setRequestShipDateTime in interface OrderFulfillmentStatusAccessBeanData

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 accesses a non-CMP field
Specified by:
setScheduleShipDateTime in interface OrderFulfillmentStatusAccessBeanData

propertySet

public void propertySet(java.util.Hashtable arg1)
                 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:
arg1 - The list of properties stored in a Hashtable.
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
Throws:
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

Feedback