Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EDPORDER
This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
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
0 -- Background status initiated
1 -- Background status pending
2 -- Background finished successfully
3 -- Background finished with failureOPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use. FIELD1 INTEGER customizable FIELD2 VARCHAR(254) customizable FIELD3 VARCHAR(254) customizable
Indexes Index Name Indexed Column Names Index Type SQL100520030330010 EDPORDER_ID Primary Key I0000843 STORE_ID+ORDER_ID Non-Unique Index
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1096 EDPORDER_ID EDPPAYINST EDPORDER_ID Cascade F_1098 EDPORDER_ID EDPRELEASE EDPORDER_ID Cascade _vcc_freeselect_bottom_