EDPORDER

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

Column Descriptions:

Name	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 HCL 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 failure
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1	INTEGER	Customizable.
FIELD2	VARCHAR (254)	Customizable.
FIELD3	VARCHAR (254)	Customizable.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	EDPORDER_ID	Primary Key
I0000843	STORE_ID+ORDER_ID	Non-Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1096	EDPORDER_ID	EDPPAYINST	EDPORDER_ID	Cascade
F_1098	EDPORDER_ID	EDPRELEASE	EDPORDER_ID	Cascade