|
id
|
int(10) unsigned
|
|
|
|
|
invoice_no
|
varchar(40)
|
|
|
|
|
quote_id
|
int(10) unsigned
|
|
|
|
|
customer_name
|
varchar(150)
|
|
|
|
|
vin
|
varchar(40)
|
|
|
|
|
payment_method
|
varchar(80)
|
|
|
|
|
subtotal
|
decimal(12,2)
|
|
|
0.00
|
|
discount
|
decimal(12,2)
|
|
|
0.00
|
|
payment_fees
|
decimal(12,2)
|
|
|
0.00
|
|
shipping_cost
|
decimal(12,2)
|
|
|
0.00
|
|
other_costs
|
decimal(12,2)
|
|
|
0.00
|
|
cogs
|
decimal(12,2)
|
|
|
0.00
|
|
total
|
decimal(12,2)
|
|
|
0.00
|
|
net_profit
|
decimal(12,2)
|
|
|
0.00
|
|
status
|
enum
|
-- |
|
completed
|
|
user_id
|
int(10) unsigned
|
|
|
|
|
sold_at
|
datetime
|
|
|
2026-11-15 22:40:55.000000
|
|
created_at
|
datetime
|
|
|
2026-11-15 22:40:55.000000
|
|
customer_phone
|
varchar(50)
|
|
|
|
|
notes
|
text
|
|
|
|
|
external_order_no
|
varchar(60)
|
|
|
|
|
payment_method_key
|
varchar(60)
|
|
|
|
|
shipping_revenue
|
decimal(12,2)
|
|
|
0.00
|
|
payment_fee_base
|
decimal(12,2)
|
|
|
0.00
|
|
payment_fee_vat
|
decimal(12,2)
|
|
|
0.00
|
|
wallet_deductions
|
decimal(12,2)
|
|
|
0.00
|
|
payout_net
|
decimal(12,2)
|
|
|
0.00
|
|
updated_at
|
datetime
|
|
|
|
|
salla_order_id
|
bigint(20) unsigned
|
|
|
|
|
salla_reference_id
|
bigint(20) unsigned
|
|
|
|
|
source
|
enum
|
-- |
|
local
|
|
raw_data
|
longtext
|
|
|
|
|
salla_synced_at
|
datetime
|
|
|
|