| invc_id | int(11) | NO | | PRI | auto_increment | |
| invc_cus_id | int(11) | NO | | MUL | | |
| invc_cli_id | int(11) | NO | | MUL | | |
| invc_name | varchar(120) | NO | | | | |
| invc_foreground_color | varchar(7) | NO | #000000 | | | |
| invc_background_color | varchar(7) | NO | #ffffff | | | |
| invc_disabled | char(1) | NO | 0 | | | |
| invc_administered | char(1) | NO | 0 | | | |
| invc_default | char(1) | NO | 0 | | | If set to 1, then the inventory select popup will default to this type. |
| invc_type | int(11) | NO | 0 | | | If this is a system type then it will be greater than 0. |
| invc_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| invc_created | timestamp | YES | CURRENT_TIMESTAMP | | | |