| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | bigint(20) unsigned | NO | PRI | auto_increment | |
| provider | varchar(32) | NO | MUL | ||
| external_invoice_id | varchar(128) | NO | |||
| direction | enum('INBOUND','OUTBOUND') | NO | INBOUND | ||
| erp_status | varchar(32) | NO | |||
| last_raw_status | varchar(64) | YES | |||
| last_pay_status | varchar(64) | NO | |||
| invoice_number | varchar(128) | YES | |||
| supplier_vat | varchar(32) | YES | |||
| supplier_name | varchar(255) | YES | |||
| buyer_vat | varchar(32) | YES | |||
| buyer_name | varchar(255) | YES | |||
| issue_date | date | YES | |||
| due_date | date | YES | |||
| total_ht | decimal(15,2) | YES | |||
| total_tva | decimal(15,2) | YES | |||
| total_ttc | decimal(15,2) | YES | |||
| currency | char(3) | YES | |||
| created_at | datetime | NO | current_timestamp() | ||
| updated_at | datetime | NO | current_timestamp() | on update current_timestamp() | |
| en16931_json | longtext | YES | |||
| compliance_status | varchar(100) | YES | OK | ||
| facturx_profile | varchar(16) | YES | |||
| source_format | varchar(16) | NO | |||
| workflow_status | varchar(32) | YES | |||
| validation_status | varchar(8) | YES | |||
| validation_errors | int(11) | YES | 0 | ||
| validation_warnings | int(11) | YES | 0 |