wp_ipenta_expenses
StaticStores ipenta expenses data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT | YES |
| description | VARCHAR(200) | NO |
| category | VARCHAR(100) | YES |
| amount | DECIMAL(12,2) | YES |
| tax_amount | DECIMAL(12,2) | YES |
| supplier | VARCHAR(200) | YES |
| reference | VARCHAR(100) | YES |
| date_expense | DATE | YES |
| receipt_url | VARCHAR(500) | YES |
| notes | TEXT | YES |
| date_created | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_ipenta_expenses ( id INT AUTO_INCREMENT PRIMARY KEY, description VARCHAR(200) NOT NULL, category VARCHAR(100), amount DECIMAL(12,2) DEFAULT 0, tax_amount DECIMAL(12,2) DEFAULT 0, supplier VARCHAR(200), reference VARCHAR(100), date_expense DATE, receipt_url VARCHAR(500), notes TEXT, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c");
Safe to delete?
If you have uninstalled SilverStream Invoicing, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_ipenta_expenses`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from SilverStream Invoicing