|
id
|
int(11)
|
|
|
|
|
no_pr
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
calculation_id
|
int(11)
|
|
|
 Browse foreign values
|
|
item_code
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
item_name
|
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
|
hs_code
|
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
|
description_en
|
text
|
utf8mb4_unicode_ci
|
|
|
|
description_id
|
text
|
utf8mb4_unicode_ci
|
|
|
|
category_id
|
int(11)
|
|
|
|
|
quantity
|
int(11)
|
|
|
|
|
price_phase
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
unit_price_value
|
decimal(15,4)
|
|
|
|
|
unit_price_currency
|
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
|
weight
|
decimal(10,3)
|
|
|
|
|
customs_duty
|
decimal(5,2)
|
|
|
|
|
total_value_idr
|
decimal(15,2)
|
|
|
|
|
exw_charge
|
decimal(15,2)
|
|
|
|
|
ocean_freight
|
decimal(15,2)
|
|
|
|
|
clearance
|
decimal(15,2)
|
|
|
|
|
insurance
|
decimal(15,2)
|
|
|
|
|
handling
|
decimal(15,2)
|
|
|
|
|
lartas
|
decimal(12,5)
|
|
|
|
|
bm_normal
|
decimal(15,2)
|
|
|
|
|
bm_forme
|
decimal(15,2)
|
|
|
|
|
ppn_pph_normal
|
decimal(15,2)
|
|
|
|
|
additional_percentage
|
decimal(5,2)
|
|
|
|
|
landed_price_normal
|
decimal(15,2)
|
|
|
|
|
landed_price_normal_formula
|
decimal(12,5)
|
|
|
|
|
total_landed_price_normal
|
decimal(15,2)
|
|
|
|
|
ppn_pph_forme
|
decimal(15,2)
|
|
|
|
|
landed_price_forme
|
decimal(15,2)
|
|
|
|
|
landed_price_forme_formula
|
decimal(12,5)
|
|
|
|
|
total_landed_price_forme
|
decimal(15,2)
|
|
|
|
|
notes
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
created_at
|
timestamp
|
|
|
|
