MMv4 KB
 
ospg_order_tax_assoc DB table
  Last Edited - 05/24/2010 1:28pm PDT
  Category Path - Developer's Guide > Database Structure
 
This article outlines the database structure for the MMv4 ospg_order_tax_assoc database table.

Note: This database table is used to store information about orders that are sent to an Off Site Payment Gateway.

  • 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

 

Powered by ModularKB