t
Tables (4)
export (수출 관리)
- id (Key) — int — Primary key — NOT NULL
- export_no (Field) — varchar(50)
- export_company_id (Field2) — int
- status (Field3) — varchar(50)
- gomi_manager_id (Field4) — int
- brand_manager_id (Field5) — int
- export_agent_id (Field12)
- export_importer_id (Field13)
- export_date (Field6)
- method_of_dispatch (Field7)
- type_of_shipment (Field8)
- vessel_aircraft (Field9)
- voyage_flight_no (Field10)
- port_of_departure (Field11)
- port_of_arrival (Field14)
- incoterms (Field15)
- methof_of_payment (Field16)
- bank_details (Field17)
- remark (Field18)
- country_of_original_of_goods (Field19)
- country_of_final_destination (Field20)
export_agency (수출대리인)
- export_agency_id (Field)
- company_id (Field2)
export_importer (수입자)
- export_importer_id (Field)
- company_id (Field2)
export_products (수출 상품)
- id (Key) — int — Primary key — NOT NULL
- export_id (Field) — varchar(50)
- product_id (Field20)
- export_price (Field2)
- expire_date (Field3)
- lot_no (Field4)
- uom (Field6)
- outer_box_count (Field7)
- in_box_count (Field9)
- weight (Field10)
- net_weight (Field14)
- gross_weight (Field15)
- shipping_mark_no (Field8)