com.ibm.commerce.orderstatus.objects
Class OrderFulfillmentStatusBean

com.ibm.commerce.orderstatus.objects.OrderFulfillmentStatusBean
All Implemented Interfaces:
java.io.Serializable

public class OrderFulfillmentStatusBean
implements java.io.Serializable

This bean provides access to the ORDSTAT table.

The following is a description of this table:

This table contains information about the status of an order for an Order Status Update inbound message. Each row in the table contains information about a single order.

See Also:
Serialized Form

Constructor Summary
OrderFulfillmentStatusBean()
           
 
Method Summary
 java.sql.Timestamp getActualShipDateTime()
          This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP NULL.
 java.lang.String getComment()
          This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254) NULL.
 java.lang.String getCurrency()
          This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10) NULL.
 java.lang.Integer getField1()
          This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER NULL.
 java.math.BigDecimal getField2()
          This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 java.lang.String getField3()
          This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254) NULL.
 java.sql.Timestamp getInvoiceDateTime()
          This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP NULL.
 java.math.BigDecimal getInvoiceValue()
          This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20,5) NULL.
 java.sql.Timestamp getLastUpdateTime()
          This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP NULL.
 java.lang.String getMerchantOrderNumber()
          This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30) NULL.
 java.lang.Long getOrderId()
          This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT NULL.
 java.lang.String getOrderStatus()
          This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32) NULL.
 java.lang.Long getOrderStatusId()
          This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.
 java.sql.Timestamp getPlaceDateTime()
          This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP NULL.
 java.math.BigDecimal getPriceTotal()
          This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20,5) NULL.
 java.sql.Timestamp getRequestShipDateTime()
          This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getScheduleShipDateTime()
          This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP NULL.
 java.lang.String getSequenceNumber()
          This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64) NULL.
 java.lang.String getShipCondition()
          This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2) NULL.
 java.lang.String getShippingModeFlag()
          This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1) NULL.
 java.math.BigDecimal getShippingTaxTotal()
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getShippingTotal()
          This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20,5) NULL.
 java.math.BigDecimal getTaxTotal()
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20,5) NULL.
 java.lang.Integer getVersioning()
          This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER NULL.
 void setActualShipDateTime(java.sql.Timestamp aActualShipDateTime)
          This method provides access to the ORDSTAT.OSASTIME column of DB2 type TIMESTAMP NULL.
 void setComment(java.lang.String aComment)
          This method provides access to the ORDSTAT.OSCMNT column of DB2 type VARCHAR(254) NULL.
 void setCurrency(java.lang.String aCurrency)
          This method provides access to the ORDSTAT.OSCPCUR column of DB2 type CHAR(10) NULL.
 void setField1(java.lang.Integer aField1)
          This method provides access to the ORDSTAT.FIELD1 column of DB2 type INTEGER NULL.
 void setField2(java.math.BigDecimal aField2)
          This method provides access to the ORDSTAT.FIELD2 column of DB2 type DECIMAL(20,5) NULL.
 void setField3(java.lang.String aField3)
          This method provides access to the ORDSTAT.FIELD3 column of DB2 type VARCHAR(254) NULL.
 void setInvoiceDateTime(java.sql.Timestamp aInvoiceDateTime)
          This method provides access to the ORDSTAT.OSINVTIME column of DB2 type TIMESTAMP NULL.
 void setInvoiceValue(java.math.BigDecimal aInvoiceValue)
          This method provides access to the ORDSTAT.OSINVVAL column of DB2 type DECIMAL(20,5) NULL.
 void setLastUpdateTime(java.sql.Timestamp aLastUpdateTime)
          This method provides access to the ORDSTAT.OSUPDTIME column of DB2 type TIMESTAMP NULL.
 void setMerchantOrderNumber(java.lang.String aMerchantOrderNumber)
          This method provides access to the ORDSTAT.OSMORDER column of DB2 type CHAR(30) NULL.
 void setOrderId(java.lang.Long aOrderId)
          This method provides access to the ORDSTAT.ORDERS_ID column of DB2 type BIGINT NULL.
 void setOrderStatus(java.lang.String aOrderStatus)
          This method provides access to the ORDSTAT.OSSTATUS column of DB2 type CHAR(32) NULL.
 void setOrderStatusId(java.lang.Long aOrderStatusId)
          This method provides access to the ORDSTAT.ORDSTAT_ID column of DB2 type BIGINT NOT NULL.
 void setPlaceDateTime(java.sql.Timestamp aPlaceDateTime)
          This method provides access to the ORDSTAT.OSPLTIME column of DB2 type TIMESTAMP NULL.
 void setPriceTotal(java.math.BigDecimal aPriceTotal)
          This method provides access to the ORDSTAT.OSPRTOT column of DB2 type DECIMAL(20,5) NULL.
 void setRequestShipDateTime(java.sql.Timestamp aRequestShipDateTime)
          This method provides access to the ORDSTAT.OSRSTIME column of DB2 type TIMESTAMP NULL.
 void setScheduleShipDateTime(java.sql.Timestamp aScheduleShipDateTime)
          This method provides access to the ORDSTAT.OSSSTIME column of DB2 type TIMESTAMP NULL.
 void setSequenceNumber(java.lang.String aSequenceNumber)
          This method provides access to the ORDSTAT.OSSEQNUM column of DB2 type VARCHAR(64) NULL.
 void setShipCondition(java.lang.String aShipCondition)
          This method provides access to the ORDSTAT.OSSCOND column of DB2 type CHAR(2) NULL.
 void setShippingModeFlag(java.lang.String aShippingModeFlag)
          This method provides access to the ORDSTAT.OSSMFLAG column of DB2 type CHAR(1) NULL.
 void setShippingTaxTotal(java.math.BigDecimal aShippingTaxTotal)
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20,5) NULL.
 void setShippingTotal(java.math.BigDecimal aShippingTotal)
          This method provides access to the ORDSTAT.OSSHTOT column of DB2 type DECIMAL(20,5) NULL.
 void setTaxTotal(java.math.BigDecimal aTaxTotal)
          This method provides access to the ORDSTAT.OSSHTXTOT column of DB2 type DECIMAL(20,5) NULL.
 void setVersioning(java.lang.Integer aVersioning)
          This method provides access to the ORDSTAT.OSVERNBR column of DB2 type INTEGER NULL.
 

Constructor Detail

OrderFulfillmentStatusBean

public OrderFulfillmentStatusBean()
Method Detail

getActualShipDateTime

public java.sql.Timestamp getActualShipDateTime()

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

The following is a description of this column:

Actual shipping time stamp.

Returns:
java.sql.Timestamp

getComment

public java.lang.String getComment()

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

The following is a description of this column:

Comments for this order status.

Returns:
java.lang.String

getCurrency

public java.lang.String getCurrency()

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

The following is a description of this column:

Currency in which the price is expressed. This is a currency code as per ISO 4217 standards.

Returns:
java.lang.String

getField1

public java.lang.Integer getField1()

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

The following is a description of this column:

Customizable.

Returns:
java.lang.Integer

getField2

public java.math.BigDecimal getField2()

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

The following is a description of this column:

Customizable.

Returns:
java.math.BigDecimal

getField3

public java.lang.String getField3()

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

The following is a description of this column:

Customizable.

Returns:
java.lang.String

getInvoiceDateTime

public java.sql.Timestamp getInvoiceDateTime()

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

The following is a description of this column:

Invoice time stamp.

Returns:
java.sql.Timestamp

getInvoiceValue

public java.math.BigDecimal getInvoiceValue()

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

The following is a description of this column:

Net value of the invoice.

Returns:
java.math.BigDecimal

getLastUpdateTime

public java.sql.Timestamp getLastUpdateTime()

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

The following is a description of this column:

Last update time stamp for the order.

Returns:
java.sql.Timestamp

getMerchantOrderNumber

public java.lang.String getMerchantOrderNumber()

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

The following is a description of this column:

Order number generated by the back end system.

Returns:
java.lang.String

getOrderId

public java.lang.Long getOrderId()

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

The following is a description of this column:

WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS table.

Returns:
java.lang.Long

getOrderStatus

public java.lang.String getOrderStatus()

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

The following is a description of this column:

Status of the order.

Returns:
java.lang.String

getOrderStatusId

public java.lang.Long getOrderStatusId()

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

The following is a description of this column:

Order status reference number. This is the primary key for this table.

Returns:
java.lang.Long

getPlaceDateTime

public java.sql.Timestamp getPlaceDateTime()

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

The following is a description of this column:

Order placed time stamp.

Returns:
java.sql.Timestamp

getPriceTotal

public java.math.BigDecimal getPriceTotal()

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

The following is a description of this column:

Total product price for the order.

Returns:
java.math.BigDecimal

getRequestShipDateTime

public java.sql.Timestamp getRequestShipDateTime()

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

The following is a description of this column:

Requested shipping time stamp.

Returns:
java.sql.Timestamp

getScheduleShipDateTime

public java.sql.Timestamp getScheduleShipDateTime()

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

The following is a description of this column:

Scheduled shipping time stamp.

Returns:
java.sql.Timestamp

getSequenceNumber

public java.lang.String getSequenceNumber()

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

The following is a description of this column:

Order status sequence number for serialization.

Returns:
java.lang.String

getShipCondition

public java.lang.String getShipCondition()

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

The following is a description of this column:

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

Returns:
java.lang.String

getShippingModeFlag

public java.lang.String getShippingModeFlag()

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

The following is a description of this column:

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

Returns:
java.lang.String

getShippingTaxTotal

public java.math.BigDecimal getShippingTaxTotal()

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

The following is a description of this column:

Total tax on shipping charges for the order.

Returns:
java.math.BigDecimal

getShippingTotal

public java.math.BigDecimal getShippingTotal()

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

The following is a description of this column:

Total shipping charges for the order.

Returns:
java.math.BigDecimal

getTaxTotal

public java.math.BigDecimal getTaxTotal()

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

The following is a description of this column:

Total tax on shipping charges for the order.

Returns:
java.math.BigDecimal

getVersioning

public java.lang.Integer getVersioning()

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

The following is a description of this column:

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

Returns:
java.lang.Integer

setActualShipDateTime

public void setActualShipDateTime(java.sql.Timestamp aActualShipDateTime)

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

The following is a description of this column:

Actual shipping time stamp.

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

setComment

public void setComment(java.lang.String aComment)

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

The following is a description of this column:

Comments for this order status.

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

setCurrency

public void setCurrency(java.lang.String aCurrency)

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

The following is a description of this column:

Currency in which the price is expressed. This is a currency code as per ISO 4217 standards.

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

setField1

public void setField1(java.lang.Integer aField1)

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

The following is a description of this column:

Customizable.

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

setField2

public void setField2(java.math.BigDecimal aField2)

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

The following is a description of this column:

Customizable.

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

setField3

public void setField3(java.lang.String aField3)

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

The following is a description of this column:

Customizable.

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

setInvoiceDateTime

public void setInvoiceDateTime(java.sql.Timestamp aInvoiceDateTime)

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

The following is a description of this column:

Invoice time stamp.

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

setInvoiceValue

public void setInvoiceValue(java.math.BigDecimal aInvoiceValue)

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

The following is a description of this column:

Net value of the invoice.

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

setLastUpdateTime

public void setLastUpdateTime(java.sql.Timestamp aLastUpdateTime)

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

The following is a description of this column:

Last update time stamp for the order.

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

setMerchantOrderNumber

public void setMerchantOrderNumber(java.lang.String aMerchantOrderNumber)

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

The following is a description of this column:

Order number generated by the back end system.

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

setOrderId

public void setOrderId(java.lang.Long aOrderId)

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

The following is a description of this column:

WebSphere Commerce order reference number. Foreign key that references the ORDERS_ID column in the ORDERS table.

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

setOrderStatus

public void setOrderStatus(java.lang.String aOrderStatus)

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

The following is a description of this column:

Status of the order.

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

setOrderStatusId

public void setOrderStatusId(java.lang.Long aOrderStatusId)

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

The following is a description of this column:

Order status reference number. This is the primary key for this table.

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

setPlaceDateTime

public void setPlaceDateTime(java.sql.Timestamp aPlaceDateTime)

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

The following is a description of this column:

Order placed time stamp.

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

setPriceTotal

public void setPriceTotal(java.math.BigDecimal aPriceTotal)

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

The following is a description of this column:

Total product price for the order.

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

setRequestShipDateTime

public void setRequestShipDateTime(java.sql.Timestamp aRequestShipDateTime)

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

The following is a description of this column:

Requested shipping time stamp.

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

setScheduleShipDateTime

public void setScheduleShipDateTime(java.sql.Timestamp aScheduleShipDateTime)

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

The following is a description of this column:

Scheduled shipping time stamp.

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

setSequenceNumber

public void setSequenceNumber(java.lang.String aSequenceNumber)

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

The following is a description of this column:

Order status sequence number for serialization.

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

setShipCondition

public void setShipCondition(java.lang.String aShipCondition)

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

The following is a description of this column:

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

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

setShippingModeFlag

public void setShippingModeFlag(java.lang.String aShippingModeFlag)

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

The following is a description of this column:

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

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

setShippingTaxTotal

public void setShippingTaxTotal(java.math.BigDecimal aShippingTaxTotal)

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

The following is a description of this column:

Total tax on shipping charges for the order.

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

setShippingTotal

public void setShippingTotal(java.math.BigDecimal aShippingTotal)

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

The following is a description of this column:

Total shipping charges for the order.

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

setTaxTotal

public void setTaxTotal(java.math.BigDecimal aTaxTotal)

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

The following is a description of this column:

Total tax on shipping charges for the order.

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

setVersioning

public void setVersioning(java.lang.Integer aVersioning)

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

The following is a description of this column:

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

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