EDPORDER

This table stores the information of the value object container Credit for credit-related transactions in the payments subsystem.

Column Descriptions:

NameTypeDescription
EDPORDER_IDBIGINT NOT NULLThis is the EDPOrder identifier. This is the primary key of the table and it is generated by WebSphere Commerce Key manager.
ORDER_IDBIGINTThe order identifier in the Orders subsystem.
STORE_IDINTEGERstore identifier
INITIALAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of goods available in stock during the Order Capture
TOTALAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000total amount of the order
CURRENCYCHAR (3) NOT NULLcurrency 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.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
BLOCKEDINTEGER NOT NULL DEFAULT 0indicates if the order is blocked or not; once blocked, the order needs to be unblocked to be useable again
BGJOBSTATUSINTEGER NOT NULL DEFAULT 0Indicates 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 failure
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EDPORDER_IDPrimary Key
I0000843STORE_ID+ORDER_IDNon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1096EDPORDER_IDEDPPAYINSTEDPORDER_IDCascade
F_1098EDPORDER_IDEDPRELEASEEDPORDER_IDCascade