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 |