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)