表单安装 安装后可存放1000万+条数据
表字段预览 除系统字段外，okayapi_box_invoice数据库表 共有 40 个表字段
Displaying 1-40 of 40 results.
| 字段名称 | 字段类型 | 字段默认值 | 是否允许为空 | 字段描述 | 索引 | 字段数据示例 |
|---|---|---|---|---|---|---|
| client_id | bigint(20) | 是 | Normal Index | |||
| serie | varchar(50) | 是 | ||||
| nr | varchar(255) | 是 | ||||
| hash | varchar(255) | 是 | To access via public link | Unique Index | ||
| currency | varchar(25) | 是 | ||||
| currency_rate | decimal(13,6) | 是 | ||||
| credit | double(18,2) | 是 | ||||
| base_income | double(18,2) | 是 | Income in default currency | |||
| base_refund | double(18,2) | 是 | Refund in default currency | |||
| refund | double(18,2) | 是 | ||||
| notes | text | 是 | ||||
| text_1 | text | 是 | ||||
| text_2 | text | 是 | ||||
| status | varchar(50) | unpaid | 是 | paid, unpaid | unpaid | |
| seller_company | varchar(255) | 是 | ||||
| seller_company_vat | varchar(255) | 是 | ||||
| seller_company_number | varchar(255) | 是 | ||||
| seller_address | varchar(255) | 是 | ||||
| seller_phone | varchar(255) | 是 | ||||
| seller_email | varchar(255) | 是 | ||||
| buyer_first_name | varchar(255) | 是 | ||||
| buyer_last_name | varchar(255) | 是 | ||||
| buyer_company | varchar(255) | 是 | ||||
| buyer_company_vat | varchar(255) | 是 | ||||
| buyer_company_number | varchar(255) | 是 | ||||
| buyer_address | varchar(255) | 是 | ||||
| buyer_city | varchar(255) | 是 | ||||
| buyer_state | varchar(255) | 是 | ||||
| buyer_country | varchar(255) | 是 | ||||
| buyer_zip | varchar(255) | 是 | ||||
| buyer_phone | varchar(255) | 是 | ||||
| buyer_phone_cc | varchar(255) | 是 | ||||
| buyer_email | varchar(255) | 是 | ||||
| gateway_id | int(11) | 是 | ||||
| approved | tinyint(1) | 0 | 是 | 0 | ||
| taxname | varchar(255) | 是 | ||||
| taxrate | varchar(35) | 是 | ||||
| due_at | datetime | 是 | ||||
| reminded_at | datetime | 是 | ||||
| paid_at | datetime | 是 |
