com.ibm.commerce.order.objects
Class OrderAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractAccessBean
        |
        +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
              |
              +--com.ibm.commerce.order.objects.OrderAccessBean
All Implemented Interfaces:
OrderAccessBeanData, java.io.Serializable

public class OrderAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements OrderAccessBeanData

This bean provides access to the ORDERS table.

The following is a description of this table:

Each row in this table represents an Order in a Store.

See Also:
Serialized Form

Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef
 
Constructor Summary
OrderAccessBean()
          Default constructor.
OrderAccessBean(javax.ejb.EJBObject object)
          Creates an access bean for the specified EJB
OrderAccessBean(java.lang.Long anMemberId, java.lang.Integer anStoreEntityId, java.lang.Double afSequence, java.math.BigDecimal afTotalTax, java.sql.Timestamp atsLastUpdate)
          Maps to a corresponding ejbCreate method in the home interface of the EJB
OrderAccessBean(java.lang.Long anMemberId, java.lang.Integer anStoreEntityId, java.lang.Double afSequence, java.sql.Timestamp atsLastUpdate)
          Maps to a corresponding ejbCreate method in the home interface of the EJB
OrderAccessBean(java.lang.Long anMemberId, java.lang.Integer anStoreEntityId, java.sql.Timestamp atsLastUpdate)
          Maps to a corresponding ejbCreate method in the home interface of the EJB
 
Method Summary
 void clearOrderItemsCache()
          IBM internal use only.
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
 java.util.Enumeration findByMemberForUpdate(java.lang.Long anMemberId)
          Retrieves all the orders for given customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.MEMBER_ID = ? for update
 OrderAccessBean findByOrderForUpdate(java.lang.Long anOrderId)
          Retrieves OrderAccessBean representing the order with specified order identifier.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID = ? for update
 java.util.Enumeration findByStatus(java.lang.String astrStatus)
          Retrieves all the orders with specified status.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?)
 java.util.Enumeration findByStatusAndMember(java.lang.String astrStatus, java.lang.Long anMemberId)
          Retrieves all the orders for specified status and member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) ORDER BY T1.ORDERS_ID
 java.util.Enumeration findByStatusMemberAndStore(java.lang.String astrStatus, java.lang.Long anMemberId, java.lang.Integer anStoreEntityId)
          Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID
 java.util.Enumeration findByStatusMemberAndStoreForUpdate(java.lang.String astrStatus, java.lang.Long anMemberId, java.lang.Integer anStoreEntityId)
          Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID for update
 java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer aDByStoreIdMemberIdAndStatus, java.lang.Long aDByStoreIdMemberIdAndStatus, java.lang.String aDByStoreIdMemberIdAndStatus, java.lang.String aDByStoreIdMemberIdAndStatus, boolean aDByStoreIdMemberIdAndStatus)
          IBM internal use only.
 java.util.Enumeration findCurrentPendingOrders()
          Retrieves all the current pending orders.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE
 java.util.Enumeration findCurrentPendingOrdersByMember(java.lang.Long anMemberId)
          Retrieves all the current pending orders for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE
 java.util.Enumeration findCurrentPendingOrdersByMemberAndStore(java.lang.Long anMemberId, java.lang.Integer anStoreEntityId)
          Retrieves all the current pending orders for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND (T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER WHERE MEMBER_ID = ?)) AND (STOREENT_ID = ?) ORDER BY T1.LASTUPDATE
 java.util.Enumeration findOrderTemplatesByMember(java.lang.Long anMemberId)
          Retrieves all the order templates for specified member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)
 java.util.Enumeration findOrderTemplatesByMemberAndUsage(java.lang.Long anMemberId, java.lang.Integer anUsage)
          Retrieves all the order templates for specified member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)
 java.util.Enumeration findOrderTemplatesByStoreAndMember(java.lang.Integer anStoreEntityId, java.lang.Long anMemberId)
          Retrieves all the order templates for specified store and member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)
 java.util.Enumeration findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer anStoreEntityId, java.lang.Long anMemberId, java.lang.Integer anUsage)
          Retrieves all the order templates for specified store, member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)
 java.util.Enumeration findPendingOrders(java.lang.Long anMemberId, java.lang.Long anStoreEntityId)
          Retrieves all the pending orders for given customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) AND (T1.STATUS = 'P')
 java.util.Enumeration findPrivateRequisitionListByMember(java.lang.Long anMemberId)
          Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE
 java.util.Enumeration findPrivateRequisitionListByMemberAndStore(java.lang.Long anMemberId, java.lang.Integer anStoreId)
          Retrieves all the private requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)
 java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long anMemberId)
          Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE
 java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long anMemberId)
          Retrieves all the shareable requisition lists that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?))
 java.util.Enumeration findShareableRequisitionListByMemberAndStore(java.lang.Long anMemberId, java.lang.Integer anStoreId)
          Retrieves all the shareable requisition lists for given store that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) AND (T1.STOREENT_ID = ?)
 java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long anMemberId)
          Retrieves all the shareable requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?)
 java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long anMemberId, java.lang.Integer anStoreId)
          Retrieves all the shareable requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)
 java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer aDTemplatedOrdersByStoreIdMemberIdAndUsage, java.lang.Long aDTemplatedOrdersByStoreIdMemberIdAndUsage, java.lang.Integer aDTemplatedOrdersByStoreIdMemberIdAndUsage, java.lang.String aDTemplatedOrdersByStoreIdMemberIdAndUsage, boolean aDTemplatedOrdersByStoreIdMemberIdAndUsage)
          IBM internal use only.
 java.util.Enumeration findWithPushDownQuery(java.lang.String astrWithPushDownQuery)
          Retrieves orders identified by the specified WHERE clause.
 boolean fulfills(java.lang.Long anMemberId, java.lang.String astrRelationship)
          Determines if a given member fulfills a given relationship with the order resource.
 java.sql.Timestamp getActualShipDate()
          Retrieves the latest time any of the order items in the order have been shipped.
The SQL query used to fetch the requested data from the ORDERITEMS table is:
SELECT MAX(T1.TIMESHIPPED) FROM ORDERITEMS T1 WHERE T1.ORDERS_ID=?";
 java.lang.String getAddressId()
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.
 java.lang.Long getAddressIdInEJBType()
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.
 java.lang.String getCurrency()
          This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10) NULL.
 java.lang.String getDescription()
          This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254) NULL.
 java.sql.Timestamp getEstimatedOrPromisedShipDate()
          Retreives the latest time any of the order items in the order are expected or promised (for placed orders) to be shipped.
 java.sql.Timestamp getEstimatedShipDate()
          Retreives the latest time any of the order items in the order are expected to be shipped.
 java.lang.String getField1()
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER NULL.
 java.lang.Integer getField1InEJBType()
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER NULL.
 java.lang.String getField2()
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getField2InEJBType()
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getField3()
          This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254) NULL.
 java.lang.Object getGroupingAttributeValue(java.lang.String astrAttributeName, GroupingContext aGroupContext)
          Returns the value of a resource attribute - based on the attribute name and context.
 java.lang.String getLastUpdate()
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getLastUpdateInEJBType()
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 java.lang.String getLock()
          This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1) NULL.
 java.lang.String getMemberId()
          This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
 java.lang.Long getMemberIdInEJBType()
          This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
 java.lang.String getMerchantOrderId()
          This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30) NULL.
 java.lang.String getOrderChannelTypeId()
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.
 java.lang.Long getOrderChannelTypeIdInEJBType()
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.
 java.lang.String getOrderId()
          This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.
 java.lang.Long getOrderIdInEJBType()
          This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.
 OrderItemAccessBean[] getOrderItems()
          Returns an array of OrderItemAccessBean objects representing order items in this order.
 OrderItemAccessBean[] getOrderItemsForUpdate()
          Returns an array of OrderItemAccessBean objects representing order items in this order.
 OrderItemAccessBean[] getOrderItemsSortedByOrderItemId()
          Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
 java.lang.String getOrganizationId()
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.
 java.lang.Long getOrganizationIdInEJBType()
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.
 java.lang.Long getOwner()
          Returns the member id of the owner; used by access control.
 java.lang.String getPlaceOrderTime()
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getPlaceOrderTimeInEJBType()
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getPromisedShipDate()
          Retreives the latest time that any of the order items in the order are promised to be shipped.
 java.lang.String getProviderOrderNumber()
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.
 java.lang.Integer getProviderOrderNumberInEJBType()
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.
 java.lang.String getSequence()
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.
 java.lang.Double getSequenceInEJBType()
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.
 java.lang.String getShipAsComplete()
          This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL.
 java.lang.String getStatus()
          This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1) NULL.
 java.lang.String getStoreEntityId()
          This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
 java.lang.Integer getStoreEntityIdInEJBType()
          This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
 SubOrderAccessBean[] getSubOrders()
          Returns an array of SubOrderAccessBean objects representing suborders for this order.
 java.lang.String getTotalAdjustment()
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTotalAdjustmentByDisplayLevel(java.lang.Integer aTotalAdjustmentByDisplayLevel)
          IBM internal use only.
 java.math.BigDecimal getTotalAdjustmentInEJBType()
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getTotalProductPrice()
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTotalProductPriceInEJBType()
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getTotalShippingCharge()
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTotalShippingChargeInEJBType()
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getTotalShippingTax()
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTotalShippingTaxInEJBType()
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getTotalTax()
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTotalTaxInEJBType()
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20,5) NULL.
 void refreshCopyHelper()
          Load data from the EJBObject.
 void setAddressId(java.lang.Long aAddressId)
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.
 void setAddressId(java.lang.String aAddressId)
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.
 void setCurrency(java.lang.String aCurrency)
          This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10) NULL.
 void setDescription(java.lang.String aDescription)
          This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254) NULL.
 void setField1(java.lang.Integer aField1)
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER NULL.
 void setField1(java.lang.String aField1)
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER NULL.
 void setField2(java.math.BigDecimal aField2)
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 void setField2(java.lang.String aField2)
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 void setField3(java.lang.String aField3)
          This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254) NULL.
 void setInitKey_orderId(java.lang.String aInitKey_orderId)
          Set the primary key for this object
 void setLastUpdate(java.lang.String aLastUpdate)
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 void setLastUpdate(java.sql.Timestamp aLastUpdate)
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 void setLock(java.lang.String aLock)
          This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1) NULL.
 void setMemberId(java.lang.Long aMemberId)
          This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
 void setMemberId(java.lang.String aMemberId)
          This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
 void setMerchantOrderId(java.lang.String aMerchantOrderId)
          This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30) NULL.
 void setOrderChannelTypeId(java.lang.Long aOrderChannelTypeId)
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.
 void setOrderChannelTypeId(java.lang.String aOrderChannelTypeId)
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.
 void setOrganizationId(java.lang.Long aOrganizationId)
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.
 void setOrganizationId(java.lang.String aOrganizationId)
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.
 void setPlaceOrderTime(java.lang.String aPlaceOrderTime)
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.
 void setPlaceOrderTime(java.sql.Timestamp aPlaceOrderTime)
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.
 void setProviderOrderNumber(java.lang.Integer aProviderOrderNumber)
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.
 void setProviderOrderNumber(java.lang.String aProviderOrderNumber)
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.
 void setSequence(java.lang.Double aSequence)
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.
 void setSequence(java.lang.String aSequence)
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.
 void setShipAsComplete(java.lang.String aShipAsComplete)
          This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL.
 void setStatus(java.lang.String aStatus)
          This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1) NULL.
 void setStoreEntityId(java.lang.Integer aStoreEntityId)
          This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
 void setStoreEntityId(java.lang.String aStoreEntityId)
          This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
 void setTotalAdjustment(java.math.BigDecimal aTotalAdjustment)
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20,5) NULL.
 void setTotalAdjustment(java.lang.String aTotalAdjustment)
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20,5) NULL.
 void setTotalProductPrice(java.math.BigDecimal aTotalProductPrice)
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20,5) NULL.
 void setTotalProductPrice(java.lang.String aTotalProductPrice)
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20,5) NULL.
 void setTotalShippingCharge(java.math.BigDecimal aTotalShippingCharge)
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 void setTotalShippingCharge(java.lang.String aTotalShippingCharge)
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 void setTotalShippingTax(java.math.BigDecimal aTotalShippingTax)
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 void setTotalShippingTax(java.lang.String aTotalShippingTax)
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20,5) NULL.
 void setTotalTax(java.math.BigDecimal aTotalTax)
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20,5) NULL.
 void setTotalTax(java.lang.String aTotalTax)
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20,5) 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

OrderAccessBean

public OrderAccessBean()

Default constructor. Maps to findByPrimaryKey.


OrderAccessBean

public OrderAccessBean(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

OrderAccessBean

public OrderAccessBean(java.lang.Long anMemberId,
                       java.lang.Integer anStoreEntityId,
                       java.lang.Double afSequence,
                       java.math.BigDecimal afTotalTax,
                       java.sql.Timestamp atsLastUpdate)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException

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

Parameters:
anMemberId - java.lang.Long The customer of the order
anStoreEntityId - java.lang.Integer The store entity the order is part of
afSequence - java.lang.Double Maybe used by a user interface to control the sequence of orders in a list
afTotalTax - java.math.BigDecimal The sum of order items' tax amount for the order items in the order
atsLastUpdate - java.sql.Timestamp The time the order was most recently updated
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception

OrderAccessBean

public OrderAccessBean(java.lang.Long anMemberId,
                       java.lang.Integer anStoreEntityId,
                       java.lang.Double afSequence,
                       java.sql.Timestamp atsLastUpdate)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException

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

Parameters:
anMemberId - java.lang.Long The customer of the order
anStoreEntityId - java.lang.Integer The store entity the order is part of
afSequence - java.lang.Double Maybe used by a user interface to control the sequence of orders in a list
atsLastUpdate - java.sql.Timestamp The time the order was most recently updated
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception

OrderAccessBean

public OrderAccessBean(java.lang.Long anMemberId,
                       java.lang.Integer anStoreEntityId,
                       java.sql.Timestamp atsLastUpdate)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException

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

Parameters:
anMemberId - java.lang.Long The customer of the order
anStoreEntityId - java.lang.Integer The store entity the order is part of
atsLastUpdate - java.sql.Timestamp The time the order was most recently updated
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
Method Detail

clearOrderItemsCache

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

IBM internal use only.

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

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

findByMemberForUpdate

public java.util.Enumeration findByMemberForUpdate(java.lang.Long anMemberId)
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

Retrieves all the orders for given customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.MEMBER_ID = ? for update

Parameters:
anMemberId - java.lang.Long The customer of the orders
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findByOrderForUpdate

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

Retrieves OrderAccessBean representing the order with specified order identifier.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID = ? for update

Parameters:
anOrderId - java.lang.Long Order identifier
Returns:
com.ibm.commerce.order.objects.OrderAccessBean The OrderAccessBean representing the row that matches the search criteria.
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

findByStatus

public java.util.Enumeration findByStatus(java.lang.String astrStatus)
                                   throws java.rmi.RemoteException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

Retrieves all the orders with specified status.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?)

Parameters:
astrStatus - java.lang.String Order status
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findByStatusAndMember

public java.util.Enumeration findByStatusAndMember(java.lang.String astrStatus,
                                                   java.lang.Long anMemberId)
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

Retrieves all the orders for specified status and member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) ORDER BY T1.ORDERS_ID

Parameters:
astrStatus - java.lang.String Order status
anMemberId - java.lang.Long The customer of the order
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findByStatusMemberAndStore

public java.util.Enumeration findByStatusMemberAndStore(java.lang.String astrStatus,
                                                        java.lang.Long anMemberId,
                                                        java.lang.Integer anStoreEntityId)
                                                 throws java.rmi.RemoteException,
                                                        javax.ejb.FinderException,
                                                        javax.naming.NamingException

Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID

Parameters:
astrStatus - java.lang.String Order status
anMemberId - java.lang.Long The customer of the order
anStoreEntityId - java.lang.Integer The store entity the order is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findByStatusMemberAndStoreForUpdate

public java.util.Enumeration findByStatusMemberAndStoreForUpdate(java.lang.String astrStatus,
                                                                 java.lang.Long anMemberId,
                                                                 java.lang.Integer anStoreEntityId)
                                                          throws java.rmi.RemoteException,
                                                                 javax.ejb.FinderException,
                                                                 javax.naming.NamingException

Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID for update

Parameters:
astrStatus - java.lang.String Order status
anMemberId - java.lang.Long The customer of the order
anStoreEntityId - java.lang.Integer The store entity the order is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findByStoreIdMemberIdAndStatus

public java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer aDByStoreIdMemberIdAndStatus,
                                                            java.lang.Long aDByStoreIdMemberIdAndStatus,
                                                            java.lang.String aDByStoreIdMemberIdAndStatus,
                                                            java.lang.String aDByStoreIdMemberIdAndStatus,
                                                            boolean aDByStoreIdMemberIdAndStatus)
                                                     throws javax.ejb.FinderException,
                                                            java.rmi.RemoteException,
                                                            javax.naming.NamingException

IBM internal use only.

Parameters:
aDByStoreIdMemberIdAndStatus - java.lang.Integer
aDByStoreIdMemberIdAndStatus - java.lang.Long
aDByStoreIdMemberIdAndStatus - java.lang.String
aDByStoreIdMemberIdAndStatus - java.lang.String
aDByStoreIdMemberIdAndStatus - boolean
Returns:
java.util.Enumeration
Throws:
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findCurrentPendingOrders

public java.util.Enumeration findCurrentPendingOrders()
                                               throws java.rmi.RemoteException,
                                                      javax.ejb.FinderException,
                                                      javax.naming.NamingException

Retrieves all the current pending orders.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE

Returns:
An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findCurrentPendingOrdersByMember

public java.util.Enumeration findCurrentPendingOrdersByMember(java.lang.Long anMemberId)
                                                       throws java.rmi.RemoteException,
                                                              javax.ejb.FinderException,
                                                              javax.naming.NamingException

Retrieves all the current pending orders for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE

Parameters:
anMemberId - java.lang.Long The customer of the order
Returns:
An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findCurrentPendingOrdersByMemberAndStore

public java.util.Enumeration findCurrentPendingOrdersByMemberAndStore(java.lang.Long anMemberId,
                                                                      java.lang.Integer anStoreEntityId)
                                                               throws java.rmi.RemoteException,
                                                                      javax.ejb.FinderException,
                                                                      javax.naming.NamingException

Retrieves all the current pending orders for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND (T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER WHERE MEMBER_ID = ?)) AND (STOREENT_ID = ?) ORDER BY T1.LASTUPDATE

Parameters:
anMemberId - java.lang.Long The customer of the order
anStoreEntityId - java.lang.Integer The store entity the order is part of
Returns:
An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findOrderTemplatesByMember

public java.util.Enumeration findOrderTemplatesByMember(java.lang.Long anMemberId)
                                                 throws java.rmi.RemoteException,
                                                        javax.ejb.FinderException,
                                                        javax.naming.NamingException

Retrieves all the order templates for specified member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)

Parameters:
anMemberId - java.lang.Long The customer of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findOrderTemplatesByMemberAndUsage

public java.util.Enumeration findOrderTemplatesByMemberAndUsage(java.lang.Long anMemberId,
                                                                java.lang.Integer anUsage)
                                                         throws java.rmi.RemoteException,
                                                                javax.ejb.FinderException,
                                                                javax.naming.NamingException

Retrieves all the order templates for specified member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)

Parameters:
anMemberId - java.lang.Long The customer of the order templates
anUsage - java.lang.Integer The intended usage of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findOrderTemplatesByStoreAndMember

public java.util.Enumeration findOrderTemplatesByStoreAndMember(java.lang.Integer anStoreEntityId,
                                                                java.lang.Long anMemberId)
                                                         throws java.rmi.RemoteException,
                                                                javax.ejb.FinderException,
                                                                javax.naming.NamingException

Retrieves all the order templates for specified store and member.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)

Parameters:
anStoreEntityId - java.lang.Integer The store entity the order templates are part of
anMemberId - java.lang.Long The customer of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findOrderTemplatesByStoreMemberAndUsage

public java.util.Enumeration findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer anStoreEntityId,
                                                                     java.lang.Long anMemberId,
                                                                     java.lang.Integer anUsage)
                                                              throws java.rmi.RemoteException,
                                                                     javax.ejb.FinderException,
                                                                     javax.naming.NamingException

Retrieves all the order templates for specified store, member and usage.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)

Parameters:
anStoreEntityId - java.lang.Integer The store entity the order templates are part of
anMemberId - java.lang.Long The customer of the order templates
anUsage - java.lang.Integer The intended usage of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findPendingOrders

public java.util.Enumeration findPendingOrders(java.lang.Long anMemberId,
                                               java.lang.Long anStoreEntityId)
                                        throws java.rmi.RemoteException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

Retrieves all the pending orders for given customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) AND (T1.STATUS = 'P')

Parameters:
anMemberId - java.lang.Long The customer of the orders
anStoreEntityId - java.lang.Long The store entity the orders are part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findPrivateRequisitionListByMember

public java.util.Enumeration findPrivateRequisitionListByMember(java.lang.Long anMemberId)
                                                         throws java.rmi.RemoteException,
                                                                javax.ejb.FinderException,
                                                                javax.naming.NamingException

Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE

Parameters:
anMemberId - java.lang.Long The customer of the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findPrivateRequisitionListByMemberAndStore

public java.util.Enumeration findPrivateRequisitionListByMemberAndStore(java.lang.Long anMemberId,
                                                                        java.lang.Integer anStoreId)
                                                                 throws java.rmi.RemoteException,
                                                                        javax.ejb.FinderException,
                                                                        javax.naming.NamingException

Retrieves all the private requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)

Parameters:
anMemberId - java.lang.Long The customer of the requisition list
anStoreId - java.lang.Integer The store entity the requisition list is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findPrivateRequisitionListByMemberOrderByLastUpdate

public java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long anMemberId)
                                                                          throws java.rmi.RemoteException,
                                                                                 javax.ejb.FinderException,
                                                                                 javax.naming.NamingException

Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE

Parameters:
anMemberId - java.lang.Long The customer of the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects ordered by creation date representing rows that match the search criteria.
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

findShareableRequisitionListByMember

public java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long anMemberId)
                                                           throws java.rmi.RemoteException,
                                                                  javax.ejb.FinderException,
                                                                  javax.naming.NamingException

Retrieves all the shareable requisition lists that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?))

Parameters:
anMemberId - java.lang.Long The customer to access the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findShareableRequisitionListByMemberAndStore

public java.util.Enumeration findShareableRequisitionListByMemberAndStore(java.lang.Long anMemberId,
                                                                          java.lang.Integer anStoreId)
                                                                   throws java.rmi.RemoteException,
                                                                          javax.ejb.FinderException,
                                                                          javax.naming.NamingException

Retrieves all the shareable requisition lists for given store that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) AND (T1.STOREENT_ID = ?)

Parameters:
anMemberId - java.lang.Long The customer to access the requisition list
anStoreId - java.lang.Integer The store entity the requisition list is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findShareableRequisitionListOwnedByMember

public java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long anMemberId)
                                                                throws java.rmi.RemoteException,
                                                                       javax.ejb.FinderException,
                                                                       javax.naming.NamingException

Retrieves all the shareable requisition lists for specified customer.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?)

Parameters:
anMemberId - java.lang.Long The customer of the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findShareableRequisitionListOwnedByMemberAndStore

public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long anMemberId,
                                                                               java.lang.Integer anStoreId)
                                                                        throws java.rmi.RemoteException,
                                                                               javax.ejb.FinderException,
                                                                               javax.naming.NamingException

Retrieves all the shareable requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)

Parameters:
anMemberId - java.lang.Long The customer of the requisition list
anStoreId - java.lang.Integer The store entity the requisition list is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
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

findTemplatedOrdersByStoreIdMemberIdAndUsage

public java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer aDTemplatedOrdersByStoreIdMemberIdAndUsage,
                                                                          java.lang.Long aDTemplatedOrdersByStoreIdMemberIdAndUsage,
                                                                          java.lang.Integer aDTemplatedOrdersByStoreIdMemberIdAndUsage,
                                                                          java.lang.String aDTemplatedOrdersByStoreIdMemberIdAndUsage,
                                                                          boolean aDTemplatedOrdersByStoreIdMemberIdAndUsage)
                                                                   throws javax.ejb.FinderException,
                                                                          java.rmi.RemoteException,
                                                                          javax.naming.NamingException

IBM internal use only.

Parameters:
aDTemplatedOrdersByStoreIdMemberIdAndUsage - java.lang.Integer
aDTemplatedOrdersByStoreIdMemberIdAndUsage - java.lang.Long
aDTemplatedOrdersByStoreIdMemberIdAndUsage - java.lang.Integer
aDTemplatedOrdersByStoreIdMemberIdAndUsage - java.lang.String
aDTemplatedOrdersByStoreIdMemberIdAndUsage - boolean
Returns:
java.util.Enumeration
Throws:
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findWithPushDownQuery

public java.util.Enumeration findWithPushDownQuery(java.lang.String astrWithPushDownQuery)
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

Retrieves orders identified by the specified WHERE clause.

Parameters:
astrWithPushDownQuery - java.lang.String The WHERE clause string.
Returns:
java.util.Enumeration
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

fulfills

public boolean fulfills(java.lang.Long anMemberId,
                        java.lang.String astrRelationship)
                 throws java.rmi.RemoteException,
                        java.lang.Exception,
                        javax.ejb.FinderException,
                        javax.naming.NamingException
Determines if a given member fulfills a given relationship with the order resource.
Parameters:
anMemberId - java.lang.Long Member id of the member
astrRelationship - java.lang.String The relationship the member has with respect to the resource
Returns:
true if the member fulfills the relationship with the resource
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
java.lang.Exception - The java.lang.Exception exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getActualShipDate

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

Retrieves the latest time any of the order items in the order have been shipped.
The SQL query used to fetch the requested data from the ORDERITEMS table is:
SELECT MAX(T1.TIMESHIPPED) FROM ORDERITEMS T1 WHERE T1.ORDERS_ID=?";

Returns:
java.sql.Timestamp Time when the last order item in the order has been shipped
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getAddressId

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

This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The billing address, if known.

Specified by:
getAddressId in interface OrderAccessBeanData
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

getAddressIdInEJBType

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

This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The billing address, if known.

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

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 ORDERS.CURRENCY column of DB2 type CHAR(10) NULL.

The following is a description of this column:

The Currency for monetary amounts associated with this Order. This is a currency code as per ISO 4217 standards.

Specified by:
getCurrency in interface OrderAccessBeanData
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

getDescription

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

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

The following is a description of this column:

A mnemonic description of the Order, entered by the customer, suitable for display to the customer.

Specified by:
getDescription in interface OrderAccessBeanData
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

getEstimatedOrPromisedShipDate

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

Retreives the latest time any of the order items in the order are expected or promised (for placed orders) to be shipped.

Returns:
java.sql.Timestamp Expected or promised ship time
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getEstimatedShipDate

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

Retreives the latest time any of the order items in the order are expected to be shipped.

Returns:
java.sql.Timestamp Expected ship time
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getField1

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

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

The following is a description of this column:

Customizable.

Specified by:
getField1 in interface OrderAccessBeanData
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

getField1InEJBType

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

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

The following is a description of this column:

Customizable.

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.lang.String getField2()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException

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

The following is a description of this column:

Customizable.

Specified by:
getField2 in interface OrderAccessBeanData
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

getField2InEJBType

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

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

The following is a description of this column:

Customizable.

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 ORDERS.FIELD3 column of DB2 type VARCHAR(254) NULL.

The following is a description of this column:

Customizable.

Specified by:
getField3 in interface OrderAccessBeanData
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

getGroupingAttributeValue

public java.lang.Object getGroupingAttributeValue(java.lang.String astrAttributeName,
                                                  GroupingContext aGroupContext)
                                           throws java.lang.Exception,
                                                  java.rmi.RemoteException,
                                                  javax.ejb.FinderException,
                                                  javax.naming.NamingException

Returns the value of a resource attribute - based on the attribute name and context. Used by access control to determine if a resource falls within a resource group.

Parameters:
astrAttributeName - java.lang.String
aGroupContext - com.ibm.commerce.grouping.GroupingContext
Returns:
java.lang.Object
Throws:
java.lang.Exception - The java.lang.Exception exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getLastUpdate

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

This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was most recently updated.

Specified by:
getLastUpdate in interface OrderAccessBeanData
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

getLastUpdateInEJBType

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

This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was most recently updated.

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

getLock

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

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

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getLock in interface OrderAccessBeanData
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

getMemberId

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

This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The customer of the Order.

Specified by:
getMemberId in interface OrderAccessBeanData
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

getMemberIdInEJBType

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

This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The customer of the Order.

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

getMerchantOrderId

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

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

The following is a description of this column:

A merchant assigned order reference number, if any.

Specified by:
getMerchantOrderId in interface OrderAccessBeanData
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

getOrderChannelTypeId

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

This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getOrderChannelTypeId in interface OrderAccessBeanData
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

getOrderChannelTypeIdInEJBType

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

This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

Reserved for IBM internal use.

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

getOrderId

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

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

The following is a description of this column:

Generated unique key.

Specified by:
getOrderId in interface OrderAccessBeanData
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

getOrderIdInEJBType

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

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

The following is a description of this column:

Generated unique key.

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

getOrderItems

public OrderItemAccessBean[] getOrderItems()
                                    throws javax.naming.NamingException,
                                           java.rmi.RemoteException,
                                           javax.ejb.FinderException

Returns an array of OrderItemAccessBean objects representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.ADDRESS_ID, T1.ORDERITEMS_ID

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getOrderItemsForUpdate

public OrderItemAccessBean[] getOrderItemsForUpdate()
                                             throws javax.naming.NamingException,
                                                    java.rmi.RemoteException,
                                                    javax.ejb.FinderException

Returns an array of OrderItemAccessBean objects representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE T1.ORDERS_ID = ? for update

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getOrderItemsSortedByOrderItemId

public OrderItemAccessBean[] getOrderItemsSortedByOrderItemId()
                                                       throws javax.naming.NamingException,
                                                              java.rmi.RemoteException,
                                                              javax.ejb.FinderException

Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.ORDERITEMS_ID

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getOrganizationId

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

This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The immediate parent organization ID of the creator.

Specified by:
getOrganizationId in interface OrderAccessBeanData
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

getOrganizationIdInEJBType

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

This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The immediate parent organization ID of the creator.

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

getOwner

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

Returns the member id of the owner; used by access control.

Returns:
java.lang.Long
Throws:
java.lang.Exception - The java.lang.Exception exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getPlaceOrderTime

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

This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was processed by the OrderProcess command.

Specified by:
getPlaceOrderTime in interface OrderAccessBeanData
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

getPlaceOrderTimeInEJBType

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

This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was processed by the OrderProcess command.

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

getPromisedShipDate

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

Retreives the latest time that any of the order items in the order are promised to be shipped.

Returns:
java.sql.Timestamp Expected or promised ship time
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getProviderOrderNumber

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

This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getProviderOrderNumber in interface OrderAccessBeanData
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

getProviderOrderNumberInEJBType

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

This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.

The following is a description of this column:

Reserved for IBM internal use.

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

getSequence

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

This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

May be used by a user interface to control the sequence of Orders in a list.

Specified by:
getSequence in interface OrderAccessBeanData
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

getSequenceInEJBType

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

This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

May be used by a user interface to control the sequence of Orders in a list.

Returns:
java.lang.Double
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

getShipAsComplete

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

This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getShipAsComplete in interface OrderAccessBeanData
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

getStatus

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

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

The following is a description of this column:

The order status. Refer to ORDERS table: details for more information.

Specified by:
getStatus in interface OrderAccessBeanData
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

getStoreEntityId

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

This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The StoreEntity the Order is part of. This is normally a Store unless STATUS is Q, in which case it is normally a StoreGroup.

Specified by:
getStoreEntityId in interface OrderAccessBeanData
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

getStoreEntityIdInEJBType

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

This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The StoreEntity the Order is part of. This is normally a Store unless STATUS is Q, in which case it is normally a StoreGroup.

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

getSubOrders

public SubOrderAccessBean[] getSubOrders()
                                  throws javax.naming.NamingException,
                                         java.rmi.RemoteException,
                                         javax.ejb.FinderException

Returns an array of SubOrderAccessBean objects representing suborders for this order.

Returns:
com.ibm.commerce.order.objects.SubOrderAccessBean[]
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getTotalAdjustment

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

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALADJUSTMENT for the OrderItems in the Order.

Specified by:
getTotalAdjustment in interface OrderAccessBeanData
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

getTotalAdjustmentByDisplayLevel

public java.math.BigDecimal getTotalAdjustmentByDisplayLevel(java.lang.Integer aTotalAdjustmentByDisplayLevel)
                                                      throws javax.naming.NamingException,
                                                             javax.ejb.CreateException,
                                                             java.sql.SQLException,
                                                             java.rmi.RemoteException,
                                                             javax.ejb.FinderException

IBM internal use only.

Parameters:
aTotalAdjustmentByDisplayLevel - java.lang.Integer
Returns:
java.math.BigDecimal
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getTotalAdjustmentInEJBType

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

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALADJUSTMENT for the OrderItems in the Order.

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

getTotalProductPrice

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

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.

Specified by:
getTotalProductPrice in interface OrderAccessBeanData
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

getTotalProductPriceInEJBType

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

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.

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

getTotalShippingCharge

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

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order.

Specified by:
getTotalShippingCharge in interface OrderAccessBeanData
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

getTotalShippingChargeInEJBType

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

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order.

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

getTotalShippingTax

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

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.

Specified by:
getTotalShippingTax in interface OrderAccessBeanData
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

getTotalShippingTaxInEJBType

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

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.

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

getTotalTax

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

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

The following is a description of this column:

The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.

Specified by:
getTotalTax in interface OrderAccessBeanData
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

getTotalTaxInEJBType

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

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

The following is a description of this column:

The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.

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

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

setAddressId

public void setAddressId(java.lang.Long aAddressId)

This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The billing address, if known.

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

setAddressId

public void setAddressId(java.lang.String aAddressId)

This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The billing address, if known.

Specified by:
setAddressId in interface OrderAccessBeanData
Parameters:
aAddressId - java.lang.String
Returns:
void

setCurrency

public void setCurrency(java.lang.String aCurrency)

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

The following is a description of this column:

The Currency for monetary amounts associated with this Order. This is a currency code as per ISO 4217 standards.

Specified by:
setCurrency in interface OrderAccessBeanData
Parameters:
aCurrency - java.lang.String
Returns:
void

setDescription

public void setDescription(java.lang.String aDescription)

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

The following is a description of this column:

A mnemonic description of the Order, entered by the customer, suitable for display to the customer.

Specified by:
setDescription in interface OrderAccessBeanData
Parameters:
aDescription - java.lang.String
Returns:
void

setField1

public void setField1(java.lang.Integer aField1)

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

The following is a description of this column:

Customizable.

Parameters:
aField1 - java.lang.Integer
Returns:
void

setField1

public void setField1(java.lang.String aField1)

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

The following is a description of this column:

Customizable.

Specified by:
setField1 in interface OrderAccessBeanData
Parameters:
aField1 - java.lang.String
Returns:
void

setField2

public void setField2(java.math.BigDecimal aField2)

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

The following is a description of this column:

Customizable.

Parameters:
aField2 - java.math.BigDecimal
Returns:
void

setField2

public void setField2(java.lang.String aField2)

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

The following is a description of this column:

Customizable.

Specified by:
setField2 in interface OrderAccessBeanData
Parameters:
aField2 - java.lang.String
Returns:
void

setField3

public void setField3(java.lang.String aField3)

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

The following is a description of this column:

Customizable.

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

setInitKey_orderId

public void setInitKey_orderId(java.lang.String aInitKey_orderId)

Set the primary key for this object

Parameters:
aInitKey_orderId - java.lang.String
Returns:
void

setLastUpdate

public void setLastUpdate(java.lang.String aLastUpdate)

This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was most recently updated.

Specified by:
setLastUpdate in interface OrderAccessBeanData
Parameters:
aLastUpdate - java.lang.String
Returns:
void

setLastUpdate

public void setLastUpdate(java.sql.Timestamp aLastUpdate)

This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was most recently updated.

Parameters:
aLastUpdate - java.sql.Timestamp
Returns:
void

setLock

public void setLock(java.lang.String aLock)

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

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setLock in interface OrderAccessBeanData
Parameters:
aLock - java.lang.String
Returns:
void

setMemberId

public void setMemberId(java.lang.Long aMemberId)

This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The customer of the Order.

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

setMemberId

public void setMemberId(java.lang.String aMemberId)

This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The customer of the Order.

Specified by:
setMemberId in interface OrderAccessBeanData
Parameters:
aMemberId - java.lang.String
Returns:
void

setMerchantOrderId

public void setMerchantOrderId(java.lang.String aMerchantOrderId)

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

The following is a description of this column:

A merchant assigned order reference number, if any.

Specified by:
setMerchantOrderId in interface OrderAccessBeanData
Parameters:
aMerchantOrderId - java.lang.String
Returns:
void

setOrderChannelTypeId

public void setOrderChannelTypeId(java.lang.Long aOrderChannelTypeId)

This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

Reserved for IBM internal use.

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

setOrderChannelTypeId

public void setOrderChannelTypeId(java.lang.String aOrderChannelTypeId)

This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setOrderChannelTypeId in interface OrderAccessBeanData
Parameters:
aOrderChannelTypeId - java.lang.String
Returns:
void

setOrganizationId

public void setOrganizationId(java.lang.Long aOrganizationId)

This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The immediate parent organization ID of the creator.

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

setOrganizationId

public void setOrganizationId(java.lang.String aOrganizationId)

This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT NULL.

The following is a description of this column:

The immediate parent organization ID of the creator.

Specified by:
setOrganizationId in interface OrderAccessBeanData
Parameters:
aOrganizationId - java.lang.String
Returns:
void

setPlaceOrderTime

public void setPlaceOrderTime(java.lang.String aPlaceOrderTime)

This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was processed by the OrderProcess command.

Specified by:
setPlaceOrderTime in interface OrderAccessBeanData
Parameters:
aPlaceOrderTime - java.lang.String
Returns:
void

setPlaceOrderTime

public void setPlaceOrderTime(java.sql.Timestamp aPlaceOrderTime)

This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The time this Order was processed by the OrderProcess command.

Parameters:
aPlaceOrderTime - java.sql.Timestamp
Returns:
void

setProviderOrderNumber

public void setProviderOrderNumber(java.lang.Integer aProviderOrderNumber)

This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.

The following is a description of this column:

Reserved for IBM internal use.

Parameters:
aProviderOrderNumber - java.lang.Integer
Returns:
void

setProviderOrderNumber

public void setProviderOrderNumber(java.lang.String aProviderOrderNumber)

This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setProviderOrderNumber in interface OrderAccessBeanData
Parameters:
aProviderOrderNumber - java.lang.String
Returns:
void

setSequence

public void setSequence(java.lang.Double aSequence)

This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

May be used by a user interface to control the sequence of Orders in a list.

Parameters:
aSequence - java.lang.Double
Returns:
void

setSequence

public void setSequence(java.lang.String aSequence)

This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

May be used by a user interface to control the sequence of Orders in a list.

Specified by:
setSequence in interface OrderAccessBeanData
Parameters:
aSequence - java.lang.String
Returns:
void

setShipAsComplete

public void setShipAsComplete(java.lang.String aShipAsComplete)

This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setShipAsComplete in interface OrderAccessBeanData
Parameters:
aShipAsComplete - java.lang.String
Returns:
void

setStatus

public void setStatus(java.lang.String aStatus)

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

The following is a description of this column:

The order status. Refer to ORDERS table: details for more information.

Specified by:
setStatus in interface OrderAccessBeanData
Parameters:
aStatus - java.lang.String
Returns:
void

setStoreEntityId

public void setStoreEntityId(java.lang.Integer aStoreEntityId)

This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The StoreEntity the Order is part of. This is normally a Store unless STATUS is Q, in which case it is normally a StoreGroup.

Parameters:
aStoreEntityId - java.lang.Integer
Returns:
void

setStoreEntityId

public void setStoreEntityId(java.lang.String aStoreEntityId)

This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The StoreEntity the Order is part of. This is normally a Store unless STATUS is Q, in which case it is normally a StoreGroup.

Specified by:
setStoreEntityId in interface OrderAccessBeanData
Parameters:
aStoreEntityId - java.lang.String
Returns:
void

setTotalAdjustment

public void setTotalAdjustment(java.math.BigDecimal aTotalAdjustment)

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALADJUSTMENT for the OrderItems in the Order.

Parameters:
aTotalAdjustment - java.math.BigDecimal
Returns:
void

setTotalAdjustment

public void setTotalAdjustment(java.lang.String aTotalAdjustment)

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALADJUSTMENT for the OrderItems in the Order.

Specified by:
setTotalAdjustment in interface OrderAccessBeanData
Parameters:
aTotalAdjustment - java.lang.String
Returns:
void

setTotalProductPrice

public void setTotalProductPrice(java.math.BigDecimal aTotalProductPrice)

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.

Parameters:
aTotalProductPrice - java.math.BigDecimal
Returns:
void

setTotalProductPrice

public void setTotalProductPrice(java.lang.String aTotalProductPrice)

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

The following is a description of this column:

The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.

Specified by:
setTotalProductPrice in interface OrderAccessBeanData
Parameters:
aTotalProductPrice - java.lang.String
Returns:
void

setTotalShippingCharge

public void setTotalShippingCharge(java.math.BigDecimal aTotalShippingCharge)

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order.

Parameters:
aTotalShippingCharge - java.math.BigDecimal
Returns:
void

setTotalShippingCharge

public void setTotalShippingCharge(java.lang.String aTotalShippingCharge)

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order.

Specified by:
setTotalShippingCharge in interface OrderAccessBeanData
Parameters:
aTotalShippingCharge - java.lang.String
Returns:
void

setTotalShippingTax

public void setTotalShippingTax(java.math.BigDecimal aTotalShippingTax)

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.

Parameters:
aTotalShippingTax - java.math.BigDecimal
Returns:
void

setTotalShippingTax

public void setTotalShippingTax(java.lang.String aTotalShippingTax)

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

The following is a description of this column:

The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.

Specified by:
setTotalShippingTax in interface OrderAccessBeanData
Parameters:
aTotalShippingTax - java.lang.String
Returns:
void

setTotalTax

public void setTotalTax(java.math.BigDecimal aTotalTax)

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

The following is a description of this column:

The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.

Parameters:
aTotalTax - java.math.BigDecimal
Returns:
void

setTotalTax

public void setTotalTax(java.lang.String aTotalTax)

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

The following is a description of this column:

The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.

Specified by:
setTotalTax in interface OrderAccessBeanData
Parameters:
aTotalTax - java.lang.String
Returns:
void