this article last updated: March 10, 2010 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
This article outlines the database structure for the MMv4 order_tax_assoc database table.
- order_id
Reference to the order's SID number: orders.id.
int(10) | unsigned | indexed
- tax_id
Reference to the tax's SID number: tax.id.
int(10) | unsigned | indexed
- tax_value
Displays the amount of tax was applied to this order for this tax.id
double(16,2) | unsigned | indexed
- zone_type
Reference to the tax_zone.zone_type
char(1) | values: C, S, Z | indexed
|