com.ibm.commerce.order.objects
Class OrderAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
        |
        +--com.ibm.commerce.order.objects.OrderAccessBean
All Implemented Interfaces:
OrderAccessBeanData
Direct Known Subclasses:
OrderFlowEntityBean

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

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

See Also:
Serialized Form

Constructor Summary
OrderAccessBean()
          constructor
OrderAccessBean(javax.ejb.EJBObject o)
          constructor
OrderAccessBean(java.lang.Long arg0, java.lang.Integer arg1, java.lang.Double arg2, java.math.BigDecimal arg3, java.sql.Timestamp arg4)
          constructor
OrderAccessBean(java.lang.Long arg0, java.lang.Integer arg1, java.lang.Double arg2, java.sql.Timestamp arg3)
          constructor
OrderAccessBean(java.lang.Long arg0, java.lang.Integer arg1, java.sql.Timestamp arg2)
          constructor
 
Method Summary
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
protected  java.lang.String defaultJNDIName()
           
 java.util.Enumeration findByMemberForUpdate(java.lang.Long arg0)           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 arg0)           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 findByOrderIds(java.lang.Long[] anOrderIds)
          Returns order items by orderIds
 java.util.Enumeration findByStatus(java.lang.String arg0)           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 arg0, java.lang.Long arg1)           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 findByStatusAndMemberScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Gets all the orders for the user that are in the state specified.
 java.util.Enumeration findByStatusAndMemberScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Gets all the orders for the user that are in the state specified.
 java.util.Enumeration findByStatusesMemberStoresRelTypeStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.lang.String aRelType, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
          Returns orders by statuses,member id, store ids and relation type Scoped by start and end date
 java.util.Enumeration findByStatusesMemberStoresStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
          Returns orders by statuses,member id, relation type,and store ids Scoped by start and end date
 java.util.Enumeration findByStatusMemberAndRelType(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType)
          Returns order items by orderIds
 java.util.Enumeration findByStatusMemberAndRelTypeScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Returns orders by status,member id, and relation type
 java.util.Enumeration findByStatusMemberAndRelTypeScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Returns orders by status,member id, and relation type
 java.util.Enumeration findByStatusMemberAndStore(java.lang.String arg0, java.lang.Long arg1, java.lang.Integer arg2)           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 arg0, java.lang.Long arg1, java.lang.Integer arg2)           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 findByStatusMemberAndStoreHostedAtChannel(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId)
          Gets all the orders for the user under those merchant hosted at channel merchant that are in the state specified.
 java.util.Enumeration findByStatusMemberAndStoreScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Gets all the orders for the user and merchant that are in the state specified.
 java.util.Enumeration findByStatusMemberAndStoreScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Gets all the orders for the user and merchant that are in the state specified.
 java.util.Enumeration findByStatusMemberRelTypeAndStore(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId)
          Returns orders by status,member id, and relation type
 java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Returns orders by status,member id, relation type,and store id
 java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
          Returns orders by status,member id, relation type,and store id
 java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer arg0, java.lang.Long arg1, java.lang.String arg2, java.lang.String arg3, boolean arg4)
          IBM internal use only.
 java.util.Enumeration findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType(java.lang.Integer[] aDistributorStoreIds, java.lang.Long aOrdersId, java.lang.String aRelType)
          Returns parent order by ordersId
 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 arg0)           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 arg0, java.lang.Integer arg1)           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 findFullyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
          Returns orders(shopcarts) that are in the state "processed" by channelStoreId and shopperid
 java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
          Returns Fully Transferred Orders
 java.util.Enumeration findNotTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
          Returns orders(shopcarts) that are in the state "partly transferred" by channelStoreId and shopperid
 java.util.Enumeration findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
          Returns Not Transferred Orders
 java.util.Enumeration findOrderTemplatesByMember(java.lang.Long arg0)           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 arg0, java.lang.Integer arg1)           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 arg0, java.lang.Long arg1)           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 arg0, java.lang.Long arg1, java.lang.Integer arg2)           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 = ?)
  OrderAccessBean findParentOrderByOrdersId(java.lang.Long aOrdersId)
          Returns orders(shopcarts) that are in the state "not transferred" by channelStoreId and shopperid
 java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
          Returns orders(shopcarts) that are in the state "fully transferred" by channelStoreId and shopperid
 java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
          Returns Partly Transferred Orders
 java.util.Enumeration findPendingOrders(java.lang.Long arg0, java.lang.Long arg1)           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 arg0)           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 arg0, java.lang.Integer arg1)           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 findPrivateRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId)
           
 java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long arg0)           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 findProcessedOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
          Returns orders by status,member id, relation type,and store id
 java.util.Enumeration findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
          Returns Processed Transferred Orders
 java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long arg0)           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 arg0, java.lang.Integer arg1)           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 findShareableRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId)
           
 java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long arg0)           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 arg0, java.lang.Integer arg1)           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 findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId)
          findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel
 java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer arg0, java.lang.Long arg1, java.lang.Integer arg2, java.lang.String arg3, boolean arg4)
          IBM internal use only.
 java.util.Enumeration findWithPushDownQuery(java.lang.String arg0)
          Retrieves orders identified by the specified WHERE clause.
 boolean fulfills(java.lang.Long arg0, java.lang.String arg1)
           
 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.
 java.lang.Long getAddressIdInEJBType()
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
 java.lang.String getComment()
          getComment
 java.lang.String getCurrency()
          This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10).
 java.lang.String getDescription()
          This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254).
 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.
 java.lang.Integer getField1InEJBType()
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
 java.lang.String getField2()
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
 java.math.BigDecimal getField2InEJBType()
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
 java.lang.String getField3()
          This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254).
 java.lang.Object getGroupingAttributeValue(java.lang.String arg0, com.ibm.commerce.grouping.GroupingContext arg1)
          This method accesses a non-CMP field
 java.lang.String getLastUpdate()
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
 java.sql.Timestamp getLastUpdateInEJBType()
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
 java.lang.String getLock()
          This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1).
 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).
 java.lang.String getNotificationId()
          getNotificationId
 java.lang.Long getNotificationIdInEJBType()
          getNotificationIdInEJBType
 java.lang.String getOrderChannelTypeId()
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
 java.lang.Long getOrderChannelTypeIdInEJBType()
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
 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[] getOrderItemsByFulfillmentStatus(java.lang.String strFulfillmentStatus)
           
  OrderItemAccessBean[] getOrderItemsByFulfillmentStatusForUpdate(java.lang.String strFulfillmentStatus)
           
  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.
 java.lang.Long getOrganizationIdInEJBType()
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
 java.lang.Long getOwner()
          This method accesses a non-CMP field
 java.lang.String getPlaceOrderTime()
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
 java.sql.Timestamp getPlaceOrderTimeInEJBType()
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
 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.
 java.lang.Integer getProviderOrderNumberInEJBType()
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
 java.lang.String getSequence()
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
 java.lang.Double getSequenceInEJBType()
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
 java.lang.String getShipAsComplete()
          This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL DEFAULT 'Y'.
 java.lang.String getStatus()
          This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1).
 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) DEFAULT 0.
 java.math.BigDecimal getTotalAdjustmentByDisplayLevel(java.lang.Integer arg0)
          IBM internal use only.
 java.math.BigDecimal getTotalAdjustmentInEJBType()
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.lang.String getTotalProductPrice()
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.math.BigDecimal getTotalProductPriceInEJBType()
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.lang.String getTotalShippingCharge()
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.math.BigDecimal getTotalShippingChargeInEJBType()
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.lang.String getTotalShippingTax()
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.math.BigDecimal getTotalShippingTaxInEJBType()
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.lang.String getTotalTax()
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
 java.math.BigDecimal getTotalTaxInEJBType()
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
protected  void instantiateEJB()
           
protected  boolean instantiateEJBByPrimaryKey()
           
 void refreshCopyHelper()
          Load data from the EJBObject.
 void setAddressId(java.lang.Long newValue)
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
 void setAddressId(java.lang.String newValue)
          This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
 void setComment(java.lang.String newValue)
          This method accesses a non-CMP field
 void setCurrency(java.lang.String newValue)
          This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10).
 void setDescription(java.lang.String newValue)
          This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254).
 void setField1(java.lang.Integer newValue)
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
 void setField1(java.lang.String newValue)
          This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
 void setField2(java.math.BigDecimal newValue)
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
 void setField2(java.lang.String newValue)
          This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
 void setField3(java.lang.String newValue)
          This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254).
 void setInitKey_orderId(java.lang.String newValue)
          Set the primary key for this object
 void setLastUpdate(java.lang.String newValue)
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
 void setLastUpdate(java.sql.Timestamp newValue)
          This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
 void setLastUpdateWithoutCheck(java.sql.Timestamp newValue)
          The time this Order was most recently updated without checking whether the previous update time.
 void setLock(java.lang.String newValue)
          This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1).
 void setMemberId(java.lang.Long newValue)
          This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
 void setMemberId(java.lang.String newValue)
          This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
 void setMerchantOrderId(java.lang.String newValue)
          This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30).
 void setNotificationId(java.lang.Long newValue)
          This method accesses a non-CMP field
 void setNotificationId(java.lang.String newValue)
          This method accesses a non-CMP field
 void setOrderChannelTypeId(java.lang.Long newValue)
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
 void setOrderChannelTypeId(java.lang.String newValue)
          This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
 void setOrganizationId(java.lang.Long newValue)
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
 void setOrganizationId(java.lang.String newValue)
          This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
 void setPlaceOrderTime(java.lang.String newValue)
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
 void setPlaceOrderTime(java.sql.Timestamp newValue)
          This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
 void setProviderOrderNumber(java.lang.Integer newValue)
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
 void setProviderOrderNumber(java.lang.String newValue)
          This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
 void setSequence(java.lang.Double newValue)
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
 void setSequence(java.lang.String newValue)
          This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
 void setShipAsComplete(java.lang.String newValue)
          This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL DEFAULT 'Y'.
 void setStatus(java.lang.String newValue)
          This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1).
 void setStoreEntityId(java.lang.Integer newValue)
          This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
 void setStoreEntityId(java.lang.String newValue)
          This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
 void setTotalAdjustment(java.math.BigDecimal newValue)
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalAdjustment(java.lang.String newValue)
          This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalProductPrice(java.math.BigDecimal newValue)
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalProductPrice(java.lang.String newValue)
          This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalShippingCharge(java.math.BigDecimal newValue)
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalShippingCharge(java.lang.String newValue)
          This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalShippingTax(java.math.BigDecimal newValue)
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalShippingTax(java.lang.String newValue)
          This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalTax(java.math.BigDecimal newValue)
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
 void setTotalTax(java.lang.String newValue)
          This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OrderAccessBean

public OrderAccessBean()
constructor

OrderAccessBean

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

OrderAccessBean

public OrderAccessBean(java.lang.Long arg0,
                       java.lang.Integer arg1,
                       java.lang.Double arg2,
                       java.math.BigDecimal arg3,
                       java.sql.Timestamp arg4)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException
constructor
Parameters:
arg0 - java.lang.Long
arg1 - java.lang.Integer
arg2 - java.lang.Double
arg3 - java.math.BigDecimal
arg4 - java.sql.Timestamp
Throws:
javax.naming.NamingException
javax.ejb.CreateException
javax.ejb.FinderException
java.rmi.RemoteException

OrderAccessBean

public OrderAccessBean(java.lang.Long arg0,
                       java.lang.Integer arg1,
                       java.lang.Double arg2,
                       java.sql.Timestamp arg3)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException
constructor
Parameters:
arg0 - java.lang.Long
arg1 - java.lang.Integer
arg2 - java.lang.Double
arg3 - java.sql.Timestamp
Throws:
javax.naming.NamingException
javax.ejb.CreateException
javax.ejb.FinderException
java.rmi.RemoteException

OrderAccessBean

public OrderAccessBean(java.lang.Long arg0,
                       java.lang.Integer arg1,
                       java.sql.Timestamp arg2)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException
constructor
Parameters:
arg0 - java.lang.Long
arg1 - java.lang.Integer
arg2 - java.sql.Timestamp
Throws:
javax.naming.NamingException
javax.ejb.CreateException
javax.ejb.FinderException
java.rmi.RemoteException
Method Detail

findByOrderForUpdate

public OrderAccessBean findByOrderForUpdate(java.lang.Long arg0)
                                     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

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

findByMemberForUpdate

public java.util.Enumeration findByMemberForUpdate(java.lang.Long arg0)
                                            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

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

findByStatus

public java.util.Enumeration findByStatus(java.lang.String arg0)
                                   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 = ?)

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

findByStatusAndMember

public java.util.Enumeration findByStatusAndMember(java.lang.String arg0,
                                                   java.lang.Long arg1)
                                            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

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

findByStatusMemberAndStore

public java.util.Enumeration findByStatusMemberAndStore(java.lang.String arg0,
                                                        java.lang.Long arg1,
                                                        java.lang.Integer arg2)
                                                 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

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

findByStatusMemberAndStoreForUpdate

public java.util.Enumeration findByStatusMemberAndStoreForUpdate(java.lang.String arg0,
                                                                 java.lang.Long arg1,
                                                                 java.lang.Integer arg2)
                                                          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

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

findByStoreIdMemberIdAndStatus

public java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer arg0,
                                                            java.lang.Long arg1,
                                                            java.lang.String arg2,
                                                            java.lang.String arg3,
                                                            boolean arg4)
                                                     throws javax.ejb.FinderException,
                                                            java.rmi.RemoteException,
                                                            javax.naming.NamingException

IBM internal use only.

Returns:
java.util.Enumeration
Throws:
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException

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

findCurrentPendingOrdersByMember

public java.util.Enumeration findCurrentPendingOrdersByMember(java.lang.Long arg0)
                                                       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

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

findCurrentPendingOrdersByMemberAndStore

public java.util.Enumeration findCurrentPendingOrdersByMemberAndStore(java.lang.Long arg0,
                                                                      java.lang.Integer arg1)
                                                               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

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

findOrderTemplatesByMember

public java.util.Enumeration findOrderTemplatesByMember(java.lang.Long arg0)
                                                 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 = ?)

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

findOrderTemplatesByMemberAndUsage

public java.util.Enumeration findOrderTemplatesByMemberAndUsage(java.lang.Long arg0,
                                                                java.lang.Integer arg1)
                                                         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 = ?)

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

findOrderTemplatesByStoreAndMember

public java.util.Enumeration findOrderTemplatesByStoreAndMember(java.lang.Integer arg0,
                                                                java.lang.Long arg1)
                                                         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 = ?)

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

findOrderTemplatesByStoreMemberAndUsage

public java.util.Enumeration findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer arg0,
                                                                     java.lang.Long arg1,
                                                                     java.lang.Integer arg2)
                                                              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 = ?)

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

findPendingOrders

public java.util.Enumeration findPendingOrders(java.lang.Long arg0,
                                               java.lang.Long arg1)
                                        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')

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

findPrivateRequisitionListByMember

public java.util.Enumeration findPrivateRequisitionListByMember(java.lang.Long arg0)
                                                         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

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

findPrivateRequisitionListByMemberAndStore

public java.util.Enumeration findPrivateRequisitionListByMemberAndStore(java.lang.Long arg0,
                                                                        java.lang.Integer arg1)
                                                                 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 = ?)

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

findPrivateRequisitionListByMemberOrderByLastUpdate

public java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long arg0)
                                                                          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

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

findShareableRequisitionListByMember

public java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long arg0)
                                                           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 = ?))

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

findShareableRequisitionListByMemberAndStore

public java.util.Enumeration findShareableRequisitionListByMemberAndStore(java.lang.Long arg0,
                                                                          java.lang.Integer arg1)
                                                                   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 = ?)

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

findShareableRequisitionListOwnedByMember

public java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long arg0)
                                                                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 = ?)

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

findShareableRequisitionListOwnedByMemberAndStore

public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long arg0,
                                                                               java.lang.Integer arg1)
                                                                        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 = ?)

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

findTemplatedOrdersByStoreIdMemberIdAndUsage

public java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer arg0,
                                                                          java.lang.Long arg1,
                                                                          java.lang.Integer arg2,
                                                                          java.lang.String arg3,
                                                                          boolean arg4)
                                                                   throws javax.ejb.FinderException,
                                                                          java.rmi.RemoteException,
                                                                          javax.naming.NamingException

IBM internal use only.

Returns:
java.util.Enumeration
Throws:
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException

findWithPushDownQuery

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

Retrieves orders identified by the specified WHERE clause.

Returns:
java.util.Enumeration
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

setInitKey_orderId

public void setInitKey_orderId(java.lang.String newValue)

Set the primary key for this object

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

defaultJNDIName

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

instantiateEJB

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

instantiateEJBByPrimaryKey

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

commitCopyHelper

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

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

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

refreshCopyHelper

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

Load data from the EJBObject.

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

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setDescription

public void setDescription(java.lang.String newValue)

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

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

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.

The following is a description of this column:

The time this Order was most recently updated.

Specified by:
getLastUpdate in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

The following is a description of this column:

The time this Order was most recently updated.

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

setLastUpdate

public void setLastUpdate(java.lang.String newValue)

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

The following is a description of this column:

The time this Order was most recently updated.

Specified by:
setLastUpdate in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setLastUpdate

public void setLastUpdate(java.sql.Timestamp newValue)

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

The following is a description of this column:

The time this Order was most recently updated.

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

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.

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setPlaceOrderTime

public void setPlaceOrderTime(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setPlaceOrderTime

public void setPlaceOrderTime(java.sql.Timestamp newValue)

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

The following is a description of this column:

The time this Order was processed by the OrderProcess command.

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

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

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalShippingTax

public void setTotalShippingTax(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setTotalShippingTax

public void setTotalShippingTax(java.math.BigDecimal newValue)

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

The following is a description of this column:

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

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

getCurrency

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

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setCurrency

public void setCurrency(java.lang.String newValue)

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

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

getField3

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

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

The following is a description of this column:

Customizable.

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

setField3

public void setField3(java.lang.String newValue)

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

The following is a description of this column:

Customizable.

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

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

The following is a description of this column:

Customizable.

Specified by:
getField2 in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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

The following is a description of this column:

Customizable.

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

setField2

public void setField2(java.lang.String newValue)

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

The following is a description of this column:

Customizable.

Specified by:
setField2 in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setField2

public void setField2(java.math.BigDecimal newValue)

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

The following is a description of this column:

Customizable.

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

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.

The following is a description of this column:

Customizable.

Specified by:
getField1 in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

The following is a description of this column:

Customizable.

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

setField1

public void setField1(java.lang.String newValue)

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

The following is a description of this column:

Customizable.

Specified by:
setField1 in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setField1

public void setField1(java.lang.Integer newValue)

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

The following is a description of this column:

Customizable.

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

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 DEFAULT 'Y'.

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setShipAsComplete

public void setShipAsComplete(java.lang.String newValue)

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

The following is a description of this column:

Reserved for IBM internal use.

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

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

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalShippingCharge

public void setTotalShippingCharge(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setTotalShippingCharge

public void setTotalShippingCharge(java.math.BigDecimal newValue)

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

The following is a description of this column:

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

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

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.

The following is a description of this column:

The immediate parent organization ID of the creator.

Specified by:
getOrganizationId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

The following is a description of this column:

The immediate parent organization ID of the creator.

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

setOrganizationId

public void setOrganizationId(java.lang.String newValue)

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

The following is a description of this column:

The immediate parent organization ID of the creator.

Specified by:
setOrganizationId in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setOrganizationId

public void setOrganizationId(java.lang.Long newValue)

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

The following is a description of this column:

The immediate parent organization ID of the creator.

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

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

The following is a description of this column:

The status of the Order.

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

setStatus

public void setStatus(java.lang.String newValue)

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

The following is a description of this column:

The status of the Order.

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

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.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getProviderOrderNumber in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

The following is a description of this column:

Reserved for IBM internal use.

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

setProviderOrderNumber

public void setProviderOrderNumber(java.lang.String newValue)

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

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setProviderOrderNumber in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setProviderOrderNumber

public void setProviderOrderNumber(java.lang.Integer newValue)

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

The following is a description of this column:

Reserved for IBM internal use.

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

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setLock

public void setLock(java.lang.String newValue)

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

The following is a description of this column:

Reserved for IBM internal use.

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

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setStoreEntityId

public void setStoreEntityId(java.lang.String newValue)

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:
newValue - String
Returns:
void

setStoreEntityId

public void setStoreEntityId(java.lang.Integer newValue)

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:
newValue - java.lang.Integer
Returns:
void

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setMemberId

public void setMemberId(java.lang.String newValue)

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:
newValue - String
Returns:
void

setMemberId

public void setMemberId(java.lang.Long newValue)

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

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

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalProductPrice

public void setTotalProductPrice(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setTotalProductPrice

public void setTotalProductPrice(java.math.BigDecimal newValue)

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

The following is a description of this column:

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

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

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

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalTax

public void setTotalTax(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setTotalTax

public void setTotalTax(java.math.BigDecimal newValue)

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

The following is a description of this column:

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

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

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setMerchantOrderId

public void setMerchantOrderId(java.lang.String newValue)

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

The following is a description of this column:

A merchant assigned order reference number, if any.

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

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 DEFAULT 0.

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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 DEFAULT 0.

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setSequence

public void setSequence(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setSequence

public void setSequence(java.lang.Double newValue)

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

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

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.

The following is a description of this column:

The billing address, if known.

Specified by:
getAddressId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

The following is a description of this column:

The billing address, if known.

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

setAddressId

public void setAddressId(java.lang.String newValue)

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

The following is a description of this column:

The billing address, if known.

Specified by:
setAddressId in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setAddressId

public void setAddressId(java.lang.Long newValue)

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

The following is a description of this column:

The billing address, if known.

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

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.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getOrderChannelTypeId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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.

The following is a description of this column:

Reserved for IBM internal use.

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

setOrderChannelTypeId

public void setOrderChannelTypeId(java.lang.String newValue)

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

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setOrderChannelTypeId in interface OrderAccessBeanData
Parameters:
newValue - String
Returns:
void

setOrderChannelTypeId

public void setOrderChannelTypeId(java.lang.Long newValue)

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

The following is a description of this column:

Reserved for IBM internal use.

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

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

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:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

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

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
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalAdjustment

public void setTotalAdjustment(java.lang.String newValue)

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

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:
newValue - String
Returns:
void

setTotalAdjustment

public void setTotalAdjustment(java.math.BigDecimal newValue)

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

The following is a description of this column:

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

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

fulfills

public boolean fulfills(java.lang.Long arg0,
                        java.lang.String arg1)
                 throws java.rmi.RemoteException,
                        java.lang.Exception,
                        javax.ejb.FinderException,
                        javax.naming.NamingException
Parameters:
arg0 - java.lang.Long
arg1 - java.lang.String
Returns:
boolean
Throws:
java.rmi.RemoteException
java.lang.Exception
javax.ejb.FinderException
javax.naming.NamingException

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

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

getOwner

public java.lang.Long getOwner()
                        throws java.lang.Exception,
                               java.rmi.RemoteException,
                               javax.ejb.FinderException,
                               javax.naming.NamingException
This method accesses a non-CMP field
java.lang.Exception
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

getGroupingAttributeValue

public java.lang.Object getGroupingAttributeValue(java.lang.String arg0,
                                                  com.ibm.commerce.grouping.GroupingContext arg1)
                                           throws java.lang.Exception,
                                                  java.rmi.RemoteException,
                                                  javax.ejb.FinderException,
                                                  javax.naming.NamingException
This method accesses a non-CMP field
java.lang.Exception
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

getTotalAdjustmentByDisplayLevel

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

IBM internal use only.

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

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

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

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

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

getComment

public java.lang.String getComment()
                            throws java.rmi.RemoteException,
                                   javax.ejb.CreateException,
                                   javax.ejb.FinderException,
                                   javax.naming.NamingException
getComment
Specified by:
getComment in interface OrderAccessBeanData
Returns:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setComment

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

findParentOrderByOrdersId

public OrderAccessBean findParentOrderByOrdersId(java.lang.Long aOrdersId)
                                          throws javax.naming.NamingException,
                                                 javax.ejb.FinderException,
                                                 java.rmi.RemoteException
Returns orders(shopcarts) that are in the state "not transferred" by channelStoreId and shopperid
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

getOrderItemsByFulfillmentStatus

public OrderItemAccessBean[] getOrderItemsByFulfillmentStatus(java.lang.String strFulfillmentStatus)
                                                       throws javax.naming.NamingException,
                                                              javax.ejb.FinderException,
                                                              java.rmi.RemoteException
Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean []
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

getOrderItemsByFulfillmentStatusForUpdate

public OrderItemAccessBean[] getOrderItemsByFulfillmentStatusForUpdate(java.lang.String strFulfillmentStatus)
                                                                throws javax.naming.NamingException,
                                                                       javax.ejb.FinderException,
                                                                       java.rmi.RemoteException
Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean []
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findNotTransferredOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findNotTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                                  java.lang.Long aShopperId)
                                                                           throws javax.naming.NamingException,
                                                                                  javax.ejb.FinderException,
                                                                                  java.rmi.RemoteException
Returns orders(shopcarts) that are in the state "partly transferred" by channelStoreId and shopperid
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findProcessedOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findProcessedOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                             java.lang.Long aShopperId)
                                                                      throws javax.naming.NamingException,
                                                                             javax.ejb.FinderException,
                                                                             java.rmi.RemoteException
Returns orders by status,member id, relation type,and store id
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findFullyTransferredOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                                    java.lang.Long aShopperId)
                                                                             throws javax.naming.NamingException,
                                                                                    javax.ejb.FinderException,
                                                                                    java.rmi.RemoteException
Returns orders(shopcarts) that are in the state "processed" by channelStoreId and shopperid
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findPartlyTransferredOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                                     java.lang.Long aShopperId)
                                                                              throws javax.naming.NamingException,
                                                                                     javax.ejb.FinderException,
                                                                                     java.rmi.RemoteException
Returns orders(shopcarts) that are in the state "fully transferred" by channelStoreId and shopperid
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberRelTypeAndStore

public java.util.Enumeration findByStatusMemberRelTypeAndStore(java.lang.String istrOrderStatus,
                                                               java.lang.Long inUserId,
                                                               java.lang.String istrRelType,
                                                               java.lang.Integer inStoreId)
                                                        throws javax.naming.NamingException,
                                                               javax.ejb.FinderException,
                                                               java.rmi.RemoteException
Returns orders by status,member id, and relation type
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndRelType

public java.util.Enumeration findByStatusMemberAndRelType(java.lang.String istrOrderStatus,
                                                          java.lang.Long inUserId,
                                                          java.lang.String istrRelType)
                                                   throws javax.naming.NamingException,
                                                          javax.ejb.FinderException,
                                                          java.rmi.RemoteException
Returns order items by orderIds
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByOrderIds

public java.util.Enumeration findByOrderIds(java.lang.Long[] anOrderIds)
                                     throws javax.naming.NamingException,
                                            javax.ejb.FinderException,
                                            java.rmi.RemoteException
Returns order items by orderIds
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType

public java.util.Enumeration findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType(java.lang.Integer[] aDistributorStoreIds,
                                                                                      java.lang.Long aOrdersId,
                                                                                      java.lang.String aRelType)
                                                                               throws javax.naming.NamingException,
                                                                                      javax.ejb.FinderException,
                                                                                      java.rmi.RemoteException
Returns parent order by ordersId
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndRelTypeScopedByTimePlaced

public java.util.Enumeration findByStatusMemberAndRelTypeScopedByTimePlaced(java.lang.String istrOrderStatus,
                                                                            java.lang.Long inUserId,
                                                                            java.lang.String istrRelType,
                                                                            java.sql.Timestamp argStartDate,
                                                                            java.sql.Timestamp argEndDate)
                                                                     throws javax.naming.NamingException,
                                                                            javax.ejb.FinderException,
                                                                            java.rmi.RemoteException
Returns orders by status,member id, and relation type
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndStoreScopedByLastUpdate

public java.util.Enumeration findByStatusMemberAndStoreScopedByLastUpdate(java.lang.String argStatus,
                                                                          java.lang.Long argMemberId,
                                                                          java.lang.Integer argStoreId,
                                                                          java.sql.Timestamp argStartDate,
                                                                          java.sql.Timestamp argEndDate)
                                                                   throws javax.naming.NamingException,
                                                                          javax.ejb.FinderException,
                                                                          java.rmi.RemoteException
Gets all the orders for the user and merchant that are in the state specified.
Parameters:
argStatus - java.lang.String The state of the order to query.
argStartDate - java.sql.Timestamp start date
argEndDate - java.sql.Timestamp end date
Returns:
java.util.Enumeration An enumeration of orders sorted by ascending reference number.
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findByStatusMemberRelTypeAndStoreScopedByLastUpdate

public java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByLastUpdate(java.lang.String istrOrderStatus,
                                                                                 java.lang.Long inUserId,
                                                                                 java.lang.String istrRelType,
                                                                                 java.lang.Integer inStoreId,
                                                                                 java.sql.Timestamp argStartDate,
                                                                                 java.sql.Timestamp argEndDate)
                                                                          throws javax.naming.NamingException,
                                                                                 javax.ejb.FinderException,
                                                                                 java.rmi.RemoteException
Returns orders by status,member id, relation type,and store id
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndRelTypeScopedByLastUpdate

public java.util.Enumeration findByStatusMemberAndRelTypeScopedByLastUpdate(java.lang.String istrOrderStatus,
                                                                            java.lang.Long inUserId,
                                                                            java.lang.String istrRelType,
                                                                            java.sql.Timestamp argStartDate,
                                                                            java.sql.Timestamp argEndDate)
                                                                     throws javax.naming.NamingException,
                                                                            javax.ejb.FinderException,
                                                                            java.rmi.RemoteException
Returns orders by status,member id, and relation type
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusAndMemberScopedByLastUpdate

public java.util.Enumeration findByStatusAndMemberScopedByLastUpdate(java.lang.String argStatus,
                                                                     java.lang.Long argMemberId,
                                                                     java.sql.Timestamp argStartDate,
                                                                     java.sql.Timestamp argEndDate)
                                                              throws javax.naming.NamingException,
                                                                     javax.ejb.FinderException,
                                                                     java.rmi.RemoteException
Gets all the orders for the user that are in the state specified.
Parameters:
argStatus - java.lang.String The state of the order to query.
argStartDate - java.sql.Timestamp start date
argEndDate - java.sql.Timestamp end date
Returns:
java.util.Enumeration An enumeration of orders sorted by ascending reference number.
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findByStatusMemberAndStoreScopedByTimePlaced

public java.util.Enumeration findByStatusMemberAndStoreScopedByTimePlaced(java.lang.String argStatus,
                                                                          java.lang.Long argMemberId,
                                                                          java.lang.Integer argStoreId,
                                                                          java.sql.Timestamp argStartDate,
                                                                          java.sql.Timestamp argEndDate)
                                                                   throws javax.naming.NamingException,
                                                                          javax.ejb.FinderException,
                                                                          java.rmi.RemoteException
Gets all the orders for the user and merchant that are in the state specified.
Parameters:
argStatus - java.lang.String The state of the order to query.
argStartDate - java.sql.Timestamp start date
argEndDate - java.sql.Timestamp end date
Returns:
java.util.Enumeration An enumeration of orders sorted by ascending reference number.
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findByStatusMemberRelTypeAndStoreScopedByTimePlaced

public java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByTimePlaced(java.lang.String istrOrderStatus,
                                                                                 java.lang.Long inUserId,
                                                                                 java.lang.String istrRelType,
                                                                                 java.lang.Integer inStoreId,
                                                                                 java.sql.Timestamp argStartDate,
                                                                                 java.sql.Timestamp argEndDate)
                                                                          throws javax.naming.NamingException,
                                                                                 javax.ejb.FinderException,
                                                                                 java.rmi.RemoteException
Returns orders by status,member id, relation type,and store id
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusAndMemberScopedByTimePlaced

public java.util.Enumeration findByStatusAndMemberScopedByTimePlaced(java.lang.String argStatus,
                                                                     java.lang.Long argMemberId,
                                                                     java.sql.Timestamp argStartDate,
                                                                     java.sql.Timestamp argEndDate)
                                                              throws javax.naming.NamingException,
                                                                     javax.ejb.FinderException,
                                                                     java.rmi.RemoteException
Gets all the orders for the user that are in the state specified.
Parameters:
argStatus - java.lang.String The state of the order to query.
argStartDate - java.sql.Timestamp start date
argEndDate - java.sql.Timestamp end date
Returns:
java.util.Enumeration An enumeration of orders sorted by ascending reference number.
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findByStatusesMemberStoresRelTypeStartEndDateAndDateField

public java.util.Enumeration findByStatusesMemberStoresRelTypeStartEndDateAndDateField(java.lang.String[] aStatusList,
                                                                                       java.lang.Long aMemberId,
                                                                                       java.lang.Integer[] aStoreIdList,
                                                                                       java.lang.String aRelType,
                                                                                       java.sql.Timestamp startDate,
                                                                                       java.sql.Timestamp endDate,
                                                                                       java.lang.String dateField)
                                                                                throws javax.naming.NamingException,
                                                                                       javax.ejb.FinderException,
                                                                                       java.rmi.RemoteException
Returns orders by statuses,member id, store ids and relation type Scoped by start and end date
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusesMemberStoresStartEndDateAndDateField

public java.util.Enumeration findByStatusesMemberStoresStartEndDateAndDateField(java.lang.String[] aStatusList,
                                                                                java.lang.Long aMemberId,
                                                                                java.lang.Integer[] aStoreIdList,
                                                                                java.sql.Timestamp startDate,
                                                                                java.sql.Timestamp endDate,
                                                                                java.lang.String dateField)
                                                                         throws javax.naming.NamingException,
                                                                                javax.ejb.FinderException,
                                                                                java.rmi.RemoteException
Returns orders by statuses,member id, relation type,and store ids Scoped by start and end date
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                          java.lang.Long memberId,
                                                                                                          java.sql.Timestamp startDate,
                                                                                                          java.sql.Timestamp endDate,
                                                                                                          java.lang.String dateField)
                                                                                                   throws javax.naming.NamingException,
                                                                                                          javax.ejb.FinderException,
                                                                                                          java.rmi.RemoteException
Returns Partly Transferred Orders
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                         java.lang.Long memberId,
                                                                                                         java.sql.Timestamp startDate,
                                                                                                         java.sql.Timestamp endDate,
                                                                                                         java.lang.String dateField)
                                                                                                  throws javax.naming.NamingException,
                                                                                                         javax.ejb.FinderException,
                                                                                                         java.rmi.RemoteException
Returns Fully Transferred Orders
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                       java.lang.Long memberId,
                                                                                                       java.sql.Timestamp startDate,
                                                                                                       java.sql.Timestamp endDate,
                                                                                                       java.lang.String dateField)
                                                                                                throws javax.naming.NamingException,
                                                                                                       javax.ejb.FinderException,
                                                                                                       java.rmi.RemoteException
Returns Not Transferred Orders
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                  java.lang.Long memberId,
                                                                                                  java.sql.Timestamp startDate,
                                                                                                  java.sql.Timestamp endDate,
                                                                                                  java.lang.String dateField)
                                                                                           throws javax.naming.NamingException,
                                                                                                  javax.ejb.FinderException,
                                                                                                  java.rmi.RemoteException
Returns Processed Transferred Orders
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel

public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel(java.lang.Long memberId,
                                                                                              java.lang.Integer channelStoreId)
                                                                                       throws javax.naming.NamingException,
                                                                                              javax.ejb.FinderException,
                                                                                              java.rmi.RemoteException
findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel
Returns:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findShareableRequisitionListByMemberAndStoreHostedAtChannel

public java.util.Enumeration findShareableRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId,
                                                                                         java.lang.Integer channelStoreId)
                                                                                  throws javax.naming.NamingException,
                                                                                         javax.ejb.FinderException,
                                                                                         java.rmi.RemoteException
Parameters:
memberId - java.lang.Long member ID
channelStoreId - java.lang.Integer Channel Store Id
Returns:
java.util.Enumeration An enumeration of orders
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findPrivateRequisitionListByMemberAndStoreHostedAtChannel

public java.util.Enumeration findPrivateRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId,
                                                                                       java.lang.Integer channelStoreId)
                                                                                throws javax.naming.NamingException,
                                                                                       javax.ejb.FinderException,
                                                                                       java.rmi.RemoteException
Parameters:
memberId - java.lang.Long member ID
channelStoreId - java.lang.Integer Channel Store Id
Returns:
java.util.Enumeration An enumeration of orders
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findByStatusMemberAndStoreHostedAtChannel

public java.util.Enumeration findByStatusMemberAndStoreHostedAtChannel(java.lang.String argStatus,
                                                                       java.lang.Long argMemberId,
                                                                       java.lang.Integer argStoreId)
                                                                throws javax.naming.NamingException,
                                                                       javax.ejb.FinderException,
                                                                       java.rmi.RemoteException
Gets all the orders for the user under those merchant hosted at channel merchant that are in the state specified.
Parameters:
argStatus - java.lang.String The state of the order to query.
Returns:
java.util.Enumeration An enumeration of orders sorted by ascending reference number.
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

getNotificationId

public java.lang.String getNotificationId()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException
getNotificationId
Specified by:
getNotificationId in interface OrderAccessBeanData
Returns:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setNotificationId

public void setNotificationId(java.lang.Long newValue)
This method accesses a non-CMP field

getNotificationIdInEJBType

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

setNotificationId

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

setLastUpdateWithoutCheck

public void setLastUpdateWithoutCheck(java.sql.Timestamp newValue)
The time this Order was most recently updated without checking whether the previous update time.
Specified by:
setLastUpdateWithoutCheck in interface OrderAccessBeanData