Each row of this table contains subtotals of amounts for all the OrderItems of an Order with the same shipping address.
Column Descriptions
| Column Name
| Column 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
| Reserved for IBM internal use.
|