The root object of the payments portion of an order container. An EDPOrder can be seen as a portion of the complete order container. The orders subsystem part is the one that handles order items, taxes, etc. The EDPOrder is the portion that handles the payments part only.
Column Descriptions
| Column Name
| Column Type
| Description |
| EDPORDER_ID
| BIGINT NOT NULL
| This is the EDPOrder identifier. This is the primary key of the table and it is generated by WebSphere Commerce Key manager.
|
| ORDER_ID
| BIGINT
| The order identifier in the Orders subsystem.
|
| STORE_ID
| INTEGER
| store identifier
|
| INITIALAMOUNT
| DECIMAL (20,5) NOT NULL DEFAULT 0.00000
| amount of goods available in stock during the Order Capture
|
| TOTALAMOUNT
| DECIMAL (20,5) NOT NULL DEFAULT 0.00000
| total amount of the order
|
| CURRENCY
| CHAR(3) NOT NULL
| currency used when the order was placed; the assumption is that an order is able to handle only one single currency, otherwise the currency should be in the Payment Instruction instead.
|
| MARKFORDELETE
| INTEGER NOT NULL DEFAULT 0
| The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
|
| BLOCKED
| INTEGER NOT NULL DEFAULT 0
| indicates if the order is blocked or not; once blocked, the order needs to be unblocked to be useable again
|
| BGJOBSTATUS
| INTEGER NOT NULL DEFAULT 0
| indicates the status of the task working on a payment action, in background
|
| OPTCOUNTER
| SMALLINT NOT NULL DEFAULT 0
| Reserved for IBM internal use.
|
| FIELD1
| INTEGER
| customizable
|
| FIELD2
| VARCHAR(254)
| customizable
|
| FIELD3
| VARCHAR(254)
| customizable
|