Transaction Database Tables

The Orders System stores runtime data in the transactions database. By default, the database is named sitename_transactions. To create new tables or add columns to the existing tables that store runtime data, update the OrderObjectMappings.xml file to indicate how to map runtime objects to the database tables. For more information about the OrderObjectMappings.xml file, see Mapping Purchase Orders to the Database.

The topics in this section describe each table in the transactions database.

In This Section

• CashCardPayments Table

• CreditCardPayments Table

• DiscountsApplied Table

• GiftCertificatePayments Table

• IdentityCounter Table

• LineItems Table

• OrderAddress Table

• OrderForms Table

• OrderTemplatesAndBaskets Table

• PromoCodeRecord Table

• PurchaseOrderPayments Table

• PurchaseOrders Table

• SearchResults Table

• Shipments Table

• ShippingDiscounts Table

• TransCategory Table

• TransDimension Table

See Also

Other Resources

Orders System Database Tables