wp_fin_costs
StaticStores fin costs data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| coid | varchar(8) | NO |
| siteid | tinyint(4) | NO |
| vid | int(11) | NO |
| poid | int(11) | NO |
| type | enum('cost', 'expense', 'acquisition') | NO |
| cat | varchar(32) | NO |
| paidwith | varchar(32) | NO |
| items | varchar(512) | NO |
| amount | float(11,2) | NO |
| tr | float(11,2) | NO |
| name | varchar(128) | NO |
| notes | varchar(512) | NO |
| datepaid | int(11) | NO |
| timecr | int(11) | NO |
| attfile | varchar(512) | YES |
| siteid | tinyint(4) | NO |
| vid | int(11) | NO |
| pid | int(11) | NO |
| is_sold | enum('0', '1') | NO |
| cost | float(11,2) | NO |
| soldprice | float(11,2) | NO |
| timecr | int(11) | NO |
| timesold | int(11) | NO |
| data | text | NO |
| siteid | tinyint(4) | NO |
| tfrom | varchar(32) | NO |
| tto | varchar(32) | NO |
| amount | float(11,2) | NO |
| notes | varchar(256) | NO |
| datetransfer | int(11) | NO |
| timecr | int(11) | NO |
| siteid | tinyint(4) | NO |
| payid | varchar(64) | NO |
| amount | float(11,2) | NO |
| notes | varchar(256) | NO |
| datepaid | int(11) | NO |
| timecr | int(11) | NO |
| siteid | tinyint | NO |
| vname | varchar(64) | NO |
| 🔑timecr | int | NO |
| vid | int | NO |
| siteid | tinyint | NO |
| title | varchar(64) | NO |
| status | enum('paid','unpaid','partial') | NO |
| stype | varchar(16) | NO |
| scat | varchar(16) | NO |
| amount | float(11,2) | NO |
| timecr | int | NO |
| timedue | int | NO |
| attfile | varchar(512) | NO |
| notes | varchar(512) | NO |
CREATE TABLE Statement
CREATE TABLE `fin_costs` ( `coid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `vid` int(11) NOT NULL DEFAULT '0', `poid` int(11) NOT NULL DEFAULT '0', `type` enum('cost', 'expense', 'acquisition') NOT NULL, `cat` varchar(32) NOT NULL, `paidwith` varchar(32) NOT NULL, `items` varchar(512) NOT NULL DEFAULT '.', `amount` float(11,2) NOT NULL, `tr` float(11,2) NOT NULL DEFAULT '0.00', `name` varchar(128) NOT NULL, `notes` varchar(512) NOT NULL DEFAULT '', `datepaid` int(11) NOT NULL, `timecr` int(11) NOT NULL, `attfile` varchar(512) DEFAULT NULL, UNIQUE KEY coid (coid) ) $charset_collate;"; $sql .= "CREATE TABLE `fin_inventory` ( `iid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `vid` int(11) NOT NULL DEFAULT '0', `pid` int(11) NOT NULL, `is_sold` enum('0', '1') NOT NULL DEFAULT '0', `cost` float(11,2) NOT NULL, `soldprice` float(11,2) NOT NULL, `timecr` int(11) NOT NULL, `timesold` int(11) NOT NULL, `data` text NOT NULL, UNIQUE KEY iid (iid) ) $charset_collate;"; $sql .= "CREATE TABLE `fin_transfers` ( `trid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `tfrom` varchar(32) NOT NULL, `tto` varchar(32) NOT NULL, `amount` float(11,2) NOT NULL, `notes` varchar(256) NOT NULL, `datetransfer` int(11) NOT NULL, `timecr` int(11) NOT NULL, UNIQUE KEY trid (trid) ) $charset_collate;"; $sql .= "CREATE TABLE `fin_taxpaid` ( `tid` varchar(8) NOT NULL, `siteid` tinyint(4) NOT NULL DEFAULT '0', `payid` varchar(64) NOT NULL, `amount` float(11,2) NOT NULL, `notes` varchar(256) NOT NULL, `datepaid` int(11) NOT NULL, `timecr` int(11) NOT NULL, UNIQUE KEY tid (tid) ) $charset_collate;"; $sql .= "CREATE TABLE `fin_vendors` ( `vid` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `siteid` tinyint NOT NULL DEFAULT '0', `vname` varchar(64) NOT NULL, `timecr` int NOT NULL ) $charset_collate;"; $sql .= "CREATE TABLE `fin_purchase_orders` ( `poid` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `vid` int NOT NULL, `siteid` tinyint NOT NULL DEFAULT '0', `title` varchar(64) NOT NULL, `status` enum('paid','unpaid','partial') NOT NULL DEFAULT 'unpaid', `stype` varchar(16) NOT NULL, `scat` varchar(16) NOT NULL, `amount` float(11,2) NOT NULL, `timecr` int NOT NULL, `timedue` int NOT NULL, `attfile` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `notes` varchar(512) NOT NULL ) $charset_collate;"; if ( ! function_exists('dbDelta') ) { require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );Safe to delete?
If you have uninstalled Finpose – Accounting for WooCommerce, 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_fin_costs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.