|
id
|
int(11)
|
|
|
|
|
no_pr
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
calculation_name
|
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
|
user_session
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
shipping_term
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
additional_percentage
|
decimal(5,2)
|
|
|
|
|
total_shipping_normal
|
decimal(15,2)
|
|
|
|
|
total_shipping_forme
|
decimal(15,2)
|
|
|
|
|
total_customs_duty_normal
|
decimal(15,2)
|
|
|
|
|
total_customs_duty_forme
|
decimal(15,2)
|
|
|
|
|
total_ppn_normal
|
decimal(15,2)
|
|
|
|
|
total_ppn_forme
|
decimal(15,2)
|
|
|
|
|
total_pph_normal
|
decimal(15,2)
|
|
|
|
|
total_pph_forme
|
decimal(15,2)
|
|
|
|
|
total_landed_cost_normal
|
decimal(15,2)
|
|
|
|
|
total_landed_cost_forme
|
decimal(15,2)
|
|
|
|
|
total_landedcost_plus_normal
|
decimal(15,2)
|
|
|
|
|
total_landedcost_plus_forme
|
decimal(15,2)
|
|
|
|
|
total_savings
|
decimal(15,2)
|
|
|
|
|
savings_percentage
|
decimal(5,2)
|
|
|
|
|
ppn_rate
|
decimal(5,2)
|
|
|
|
|
pph_rate
|
decimal(5,2)
|
|
|
|
|
form_e_discount
|
decimal(5,2)
|
|
|
|
|
exw_charge_value
|
decimal(15,4)
|
|
|
|
|
exw_charge_currency
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
ocean_freight_value
|
decimal(15,4)
|
|
|
|
|
ocean_freight_currency
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
clearance_value
|
decimal(15,4)
|
|
|
|
|
clearance_currency
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
insurance_value
|
decimal(15,4)
|
|
|
|
|
insurance_currency
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
handling_value
|
decimal(15,4)
|
|
|
|
|
handling_currency
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
usd_to_idr
|
decimal(15,4)
|
|
|
|
|
cnh_to_idr
|
decimal(15,4)
|
|
|
|
|
eur_to_idr
|
decimal(15,4)
|
|
|
|
|
jpy_to_idr
|
decimal(15,4)
|
|
|
|
|
is_active
|
tinyint(1)
|
|
|
|
|
notes
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|
