SUBORDERS

Each row of this table contains subtotals of amounts for all the OrderItems of an Order with the same shipping address.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLThe Order.
SUBORDER_IDBIGINT NOT NULLGenerated unique key.
ADDRESS_IDBIGINTThe shipping address.
COUNTRYCHAR (30)Customizable.
TOTALPRODUCTDECIMAL (20,5) DEFAULT 0The total of ORDERITEMS.TOTALPRODUCT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALTAXDECIMAL (20,5) DEFAULT 0The total of ORDERITEMS.TAXAMOUNT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALSHIPPINGDECIMAL (20,5) DEFAULT 0The total of ORDERITEMS.SHIPCHARGE for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
TOTALTAXSHIPPINGDECIMAL (20,5) DEFAULT 0The total of ORDERITEMS.SHIPTAXAMOUNT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
CURRENCYCHAR (10)The currency for monetary amounts in the SubOrder. This is a currency code as per ISO 4217 standards.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
TOTALADJUSTMENTDECIMAL (20,5) DEFAULT 0The total of ORDERITEMS.TOTALADJUSTMENT for all the OrderItems with the same shipping address as the SubOrder, in the Currency specified by CURRENCY.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SUBORDER_IDPrimary Key
I0000242TOTALPRODUCTNon-Unique Index
I0000243ORDERS_IDNon-Unique Index
I0000801ADDRESS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_812ADDRESS_IDADDRESSADDRESS_IDCascade
F_813ORDERS_IDORDERSORDERS_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_811SUBORDER_IDSUBORDADJSUBORDER_IDCascade
F_814SUBORDER_IDSUBORDTAXSUBORDER_IDCascade