| id |
int(10)
|
|
|
|
| invoice_no |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| quote_id |
int(10)
|
|
|
|
| customer_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| vin |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| subtotal |
decimal(12,2)
|
|
|
|
| discount |
decimal(12,2)
|
|
|
|
| payment_fees |
decimal(12,2)
|
|
|
|
| shipping_cost |
decimal(12,2)
|
|
|
|
| other_costs |
decimal(12,2)
|
|
|
|
| cogs |
decimal(12,2)
|
|
|
|
| total |
decimal(12,2)
|
|
|
|
| net_profit |
decimal(12,2)
|
|
|
|
| status |
enum('completed', 'pending', 'cancelled', 'refunded')
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(10)
|
|
|
|
| sold_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| customer_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| external_order_no |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| payment_method_key |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| shipping_revenue |
decimal(12,2)
|
|
|
|
| payment_fee_base |
decimal(12,2)
|
|
|
|
| payment_fee_vat |
decimal(12,2)
|
|
|
|
| wallet_deductions |
decimal(12,2)
|
|
|
|
| payout_net |
decimal(12,2)
|
|
|
|
| updated_at |
datetime
|
|
|
|
| salla_order_id |
bigint(20)
|
|
|
|
| salla_reference_id |
bigint(20)
|
|
|
|
| source |
enum('local', 'salla')
|
utf8mb4_unicode_ci
|
|
|
| raw_data |
longtext
|
utf8mb4_bin
|
|
|
| salla_synced_at |
datetime
|
|
|
|
