Each row of this table contains subtotals of
amounts for all the OrderItems of an Order with the same shipping
address.
Column Descriptions:
Name | Type | Description |
ORDERS_ID | BIGINT NOT NULL | The Order. |
SUBORDER_ID | BIGINT NOT NULL | Generated unique key. |
ADDRESS_ID | BIGINT | The shipping address. |
COUNTRY | CHAR (30) | Customizable. |
TOTALPRODUCT | DECIMAL (20,5) DEFAULT 0 | The total of ORDERITEMS.TOTALPRODUCT for all the
OrderItems with the same shipping address as the SubOrder, in the
Currency specified by CURRENCY. |
TOTALTAX | DECIMAL (20,5) DEFAULT 0 | The total of ORDERITEMS.TAXAMOUNT for all the
OrderItems with the same shipping address as the SubOrder, in the
Currency specified by CURRENCY. |
TOTALSHIPPING | DECIMAL (20,5) DEFAULT 0 | The total of ORDERITEMS.SHIPCHARGE for all the
OrderItems with the same shipping address as the SubOrder, in the
Currency specified by CURRENCY. |
TOTALTAXSHIPPING | DECIMAL (20,5) DEFAULT 0 | The total of ORDERITEMS.SHIPTAXAMOUNT for all the
OrderItems with the same shipping address as the SubOrder, in the
Currency specified by CURRENCY. |
CURRENCY | CHAR (10) | The currency for monetary amounts in the
SubOrder. This is a currency code as per ISO 4217 standards. |
FIELD1 | INTEGER | Customizable. |
FIELD2 | DECIMAL (20,5) | Customizable. |
FIELD3 | VARCHAR (254) | Customizable. |
TOTALADJUSTMENT | DECIMAL (20,5) DEFAULT 0 | The total of ORDERITEMS.TOTALADJUSTMENT for all
the OrderItems with the same shipping address as the SubOrder, in
the Currency specified by CURRENCY. |
OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | SUBORDER_ID | Primary Key |
I0000242 | TOTALPRODUCT | Non-Unique Index |
I0000243 | ORDERS_ID | Non-Unique Index |
I0000801 | ADDRESS_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_812 | ADDRESS_ID | ADDRESS | ADDRESS_ID | Cascade |
F_813 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_811 | SUBORDER_ID | SUBORDADJ | SUBORDER_ID | Cascade |
F_814 | SUBORDER_ID | SUBORDTAX | SUBORDER_ID | Cascade |