ModularMerchant
Knowledge Base
Shopping Cart Software Online Manual
ospg_orders DB table
order_zone_fee_assoc DB Table ospg_order_event_assoc DB table
Location Home > Developer's Guide > Database Structure

ospg_orders DB table

this article last updated: June 11, 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 ospg_orders database table.

 

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

  • id
    Primary Key of the table.
    int(10) | unsigned | auto increment | primary key | indexed
  • product_value
    The total price of all products in the order.
    double(16,2) | indexed
  • gw_value
    The total of gift wrap fees.
    double(16,2) | indexed
  • order_total
    The total amount paid for the order.
    double(16,2) | indexed
  • coupon_value
    The dollar total of any coupon codes that were redeemed for the order.
    double(16,2) | indexed
  • cid
    A reference to the customer.id field associated with this order record.
    int(10) | unsigned | indexed
  • email
    The email address associated with this order record.
    varchar(255) | indexed
  • create_date
    The Unix timestamp of the date and time this order was created.
    int(10) | unsigned | indexed
  • auth_date
    The Unix timestamp of the date and time payment was authorized for this order.
    int(10) | unsigned | indexed
  • pay_date
    The Unix timestamp of the date and time payment was received for this order.
    int(10) | unsigned | indexed
  • processor
    A reference to the entity that placed the order: system (S), admin (A), or customer (C)
    char(1)
    | Values: S/C/A | indexed
  • sai
    The shipping address system ID number.
    int(10) | unsigned | indexed
  • ship_first_name
    The first name associated with the shipping address for this order.
    varchar(255)
    | indexed
  • ship_last_name
    The last name associated with the shipping address for this order.
    varchar(255)
    | indexed
  • ship_address_1
    The first line of the shipping address.
    varchar(255) | indexed
  • ship_address_2
    The second line of the shipping address.
    varchar(255)
    | indexed
  • ship_city
    The city of the shipping address.
    varchar(255)
    | indexed
  • ship_state
    The two-character ISO code for the state of the shipping address, followed by the two-character ISO code for that state's country.
    varchar(255) | Format: State-ISO_Country-ISO (Example: OR_US) | indexed
  • ship_zip
    The zip code of the shipping address.
    varchar(255) | indexed
  • ship_country
    The two-character ISO code for the country of the shipping address.
    varchar(255) | indexed
  • bill_first_name
    The first name associated with the billing address for this order.
    varchar(255)
    | indexed
  • bill_last_name
    The last name associated with the billing address for this order.  The first line of the billing address.
    varchar(255)
    | indexed
  • bill_address_1
    The first line of the billing address.
    varchar(255) | indexed
  • bill_address_2
    The second line of the billing address.
    varchar(255) | indexed
  • bill_city
    The city of the billing address.
    varchar(255) | indexed
  • bill_state
    The two-character ISO code for the state of the billing address, followed by the two-character ISO code for that state's country.
    varchar(255) | Format: State-ISO_Country-ISO (Example: OR_US) | indexed
  • bill_zip
    The zip code of the billing address.
    varchar(255) | indexed
  • bill_country
    The two-character ISO code for the country of the billing address.
    varchar(255) | indexed
  • phone_ac
    The area code of the customer's primary phone number.
    varchar(255) | indexed
  • phone
    The customer's primary phone number.
    varchar(255) | indexed
  • cmr_ip
    The IP address of the customer when this order was created.
    varchar(255) | indexed
  • pay_method
    The brand name of the cc or other payment method used for this order.
    varchar(255)
    | indexed
  • cc_name
    The name on the credit card used for payment.
    varchar(255) | encrypted
  • cc_num
    The credit card number used for payment.
    varchar(255)
    | encrypted
  • cc_mon
    The 2-digit month number of the expiration date of the credit card used for payment.
    varchar(255)
    | encrypted
  • cc_year
    The 4-digit month number of the expiration date of the credit card used for payment.
    varchar(255) | encrypted
  • bid
    A reference to the basket.id field associated with this order record.
    varchar(255) | indexed
  • gateway
    The name of the payment gateway used to process payment on this order.
    varchar(255) | indexed
  • digdel_password
    Auto-generated password needed to access the download area for this order.
    varbinary(255) | indexed
  • wish_list_id
    System ID number of the wish list in which the order is associated with.
    int(10) | unsigned | indexed
  • memo
    This field is used to store notes specific to the order that are visible to the customer.
    text


— Last Edited - 06/11/2010 4:16pm PDT
Rank and add a comment to this article
Only logged in users may leave comments and rank articles. Log in to have your say!
  Knowledge Base Home

  QuickCode™ Tag Glossary

  Modular Merchant.com Homepage

Not Logged in.
Either Log in or create a User Account.

Other articles in this category...

account_activity DB Table

admin DB Table

admin_attr DB Table

admin_attr_data DB Table

admin_attr_node DB Table

admin_password DB Table

aff_commission DB Ttable

aff_default_target_url DB Table

aff_payment DB Table

aff_tid DB Table

aff_traffic DB table

ban_list DB Table

basket DB Table

basket_field_data DB table

category DB Table

category_attr DB Table

category_attr_assoc DB table

category_attr_data DB Table

category_attr_node DB Table

checkout_field DB table

checkout_field_node

customer DB Table

customer_attr DB Table

customer_attr_assoc DB table

customer_attr_data DB Table

customer_attr_node DB Table

customer_field DB Table

customer_field_data DB Table

customer_field_node DB Table

customer_group DB Table

customer_group_assoc DB table

customer_group_rule DB Table

customer_group_rule_node DB table

customer_ip DB Table

customer_pay_method DB Table

customer_ship_addr DB Table

custom_page DB Table

custom_quickcode DB Table

dec_orders DB table

dec_order_event_assoc DB table

dec_order_field_data DB table

dec_order_gateway_assoc DB table

dec_order_item DB table

dec_order_item_field_data DB table

dec_order_pay_method DB table

dec_order_shipment DB table

dec_order_tax_assoc DB table

dec_order_zone_fee_assoc DB table

digdel_fileserver DB table

digdel_ip DB Table

digdel_object DB table

digdel_object_zone DB table

digdel_order_item DB Table

dropship DB Table

dropship_report_hour_assoc DB Table

dropship_ship_method_assoc DB Table

em_attachment DB Table

em_history DB Table

em_link DB table

em_queue DB table

em_queue DB table

em_series DB table

em_series_step DB table

em_template DB table

event_ignore DB table

event_info DB table

event_tr DB table

event_tr_slot DB table

gift_cert DB table

inventory_object DB table

iptocountry DB Table

note DB table

orders DB Table

order_event_assoc DB Table

order_field DB Table

order_field_data DB table

order_field_node DB Table

order_gateway_assoc DB table

order_item DB Table

order_item_field_data DB table

order_item_report DB Table

order_item_royalty_assoc DB table

order_item_status DB Table

order_item_tracking_assoc DB Table

order_pay_method DB table

order_shipment DB Table

order_tax_assoc DB Table

order_zone_fee_assoc DB Table

ospg_orders DB table

ospg_order_event_assoc DB table

ospg_order_field_data DB table

ospg_order_gateway_assoc DB table

ospg_order_item DB table

ospg_order_item_field_data DB table

ospg_order_item_royalty_assoc DB

ospg_order_pay_method DB table

ospg_order_shipment DB table

ospg_order_tax_assoc DB table

ospg_order_zone_fee_assoc DB table

product DB Table

product_add_ship_assoc DB Table

product_attr DB Table

product_attr_assoc DB table

product_attr_data DB Table

product_attr_node DB Table

product_category_assoc DB Table

product_com_val DB Table

product_digobj_assoc DB Table

product_field DB Table

product_field_assoc DB Table

product_field_data DB Table

product_field_node DB Table

product_fulfillment_assoc DB Table

product_group DB Table

product_group_assoc DB Table

product_image DB Table

product_instance DB Table

product_royalty DB Table

product_ship_method_assoc DB Table

product_status DB Table

product_stock_assoc DB Table

product_vendor_assoc DB Table

product_zone_fee_assoc DB Table

ptcs DB Table

ptcs_item DB table

ptcs_item_use DB table

review DB table

review_ceriteria DB table

review_rank DB table

review_vote DB table

ship_method DB Table

ship_method_zone DB Table

ship_status DB Table

stock_level DB Table

subscription DB Table

subscription_item DB Table

system_settings DB Table

sys_email_us_english DB Table

sys_message_us_english

tax DB Table

tax_zone DB Table

tracking_id DB Table

vendor DB Table

vendor_attr DB Table

vendor_attr_data DB Table

vendor_attr_node DB Table

zone_fee DB Table

zone_fee_zone DB Table