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 |