java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusAccessBean
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'.
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 |
public OrderFulfillmentStatusAccessBean()
public OrderFulfillmentStatusAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
Method Detail |
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 = ?))
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)
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)
public void setInitKey_orderStatusId(java.lang.Long newValue)
Set the primary key for this object
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
protected boolean instantiateEJBByPrimaryKey() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.naming.NamingException
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Update(flush) data to the EJBObject (persistent storage).
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Load data from the EJBObject.
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.
public void setLastUpdateTime(java.sql.Timestamp newValue)
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.
public void setTaxTotal(java.math.BigDecimal newValue)
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.
public void setInvoiceValue(java.math.BigDecimal newValue)
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
public void setVersioning(java.lang.Integer newValue)
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.
public void setComment(java.lang.String newValue)
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.
public void setPlaceDateTime(java.sql.Timestamp newValue)
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
public void setShipCondition(java.lang.String newValue)
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.
public void setSequenceNumber(java.lang.String newValue)
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.
public void setPriceTotal(java.math.BigDecimal newValue)
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.
public void setShippingTaxTotal(java.math.BigDecimal newValue)
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.
public void setCurrency(java.lang.String newValue)
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.
public void setField3(java.lang.String newValue)
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.
public void setField2(java.math.BigDecimal newValue)
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.
public void setField1(java.lang.Integer newValue)
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.
public void setActualShipDateTime(java.sql.Timestamp newValue)
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.
public void setOrderStatusId(java.lang.Long newValue)
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
public void setShippingModeFlag(java.lang.String newValue)
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.
public void setOrderId(java.lang.Long newValue)
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.
public void setOrderStatus(java.lang.String newValue)
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.
public void setShippingTotal(java.math.BigDecimal newValue)
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.
public void setInvoiceDateTime(java.sql.Timestamp newValue)
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.
public void setMerchantOrderNumber(java.lang.String newValue)
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.
public void setRequestShipDateTime(java.sql.Timestamp newValue)
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.
public void setScheduleShipDateTime(java.sql.Timestamp newValue)
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
public java.lang.String getOsCode() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setOsCode(java.lang.String newValue)
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
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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.