das

Tables (30)

Common_Material_Release

  • Material_issue_code — VARCHAR2(50)
  • Quantity_of_material_release — NUMBER
  • Material_release_date — DATE
  • Material_release_type — VARCHAR2(50)
  • Material_code — VARCHAR2(50)
  • Detailed_information — VARCHAR2(200)

EQM

  • EQM_Code — VARCHAR2(30)
  • Line_Code — VARCHAR2(30)
  • process_code — VARCHAR2(30)
  • process_name — VARCHAR2(30)
  • EQM_FG — VARCHAR2(30)
  • EQM_Name — VARCHAR2(30)
  • EQM_Date — DATE
  • EQM_Use — VARCHAR2(10)
  • EQM_CycleDays — NUMBER
  • MinimumTemperature — NUMBER
  • MaximumTemperature — NUMBER

EQM_CHECK

  • Check_code — VARCHAR2(30)
  • EQM_Code — VARCHAR2(30)
  • EQM_Name — VARCHAR2(30)
  • Inspection_date — DATE
  • Action — VARCHAR2(10)
  • Details_of_action — VARCHAR2(1000)
  • Verdict — VARCHAR2(10)
  • Inspector — VARCHAR2(30)

EQM_IMAGE

  • EQM_Code — VARCHAR2(30)
  • Process_code — VARCHAR2(30)
  • EQM_IMAGE — VARCHAR2(100)

EQM_LINE

  • Line_code — VARCHAR2(30)
  • line_name — VARCHAR2(30)
  • Line_rep — VARCHAR2(30)
  • UPH_production — NUMBER
  • EQM_Use — VARCHAR(10)

ISSUE

  • IssueID — VARCHAR2(30)
  • IssueDate — DATE
  • CustomerName — VARCHAR2(50)
  • ProductName — VARCHAR2(50)
  • Quantity — NUMBER
  • PricePerUnit — NUMBER
  • TotalPRICE — NUMBER

Material_Inventory

  • Material_code — VARCHAR2(50)
  • Material_Available_Quantity — NUMBER
  • Material_stock_quantity — NUMBER

Material_Inventory_History

  • Closing_year_month — VARCHAR2(20)
  • Material_code — VARCHAR2(20)
  • Material_warehoused_quantity — NUMBER
  • Quantity_of_material_released — NUMBER
  • Beginning_inventory — NUMBER

Material_Release_Details

  • Material_issue_code — VARCHAR2(50)
  • Material_LOT_stock_code — VARCHAR2(50)
  • Material_code — VARCHAR2(50)
  • Quantity_of_material_release — NUMBER

ORDER_SHEET

  • SalesID — VARCHAR2(30)
  • SalesDate — DATE
  • CustomerName — VARCHAR2(50)
  • ProductName — VARCHAR2(50)
  • Quantity — NUMBER
  • PricePerUnit — NUMBER
  • TotalPrice — NUMBER
  • DELIVERY_DATE — DATE
  • ShippingAddress — VARCHAR2(100)

PRODUCTION_PLANNING

  • PROD_PLAN_CODE — VARCHAR2(50)
  • DELIVERY_DATE — DATE
  • CURRENT_STATE — VARCHAR2(10)
  • PRODUCTION_PLAN_DATE — DATE
  • SalesID — VARCHAR2(50)

PROD_INSTR_DETAIL

  • PROD_ORDER_DATE — DATE
  • PROD_PLAN_CODE — VARCHAR2(50)
  • PROD_QUANTITY — NUMBER
  • WORK_START_DATE — DATE
  • LINE_CODE — VARCHAR2(50)
  • LINE_MANAGER — VARCHAR2(50)
  • PROD_ORDER_QUANTITY — NUMBER
  • FINISHED_PRODUCT_CODE — VARCHAR2(50)
  • BOM_CODE — VARCHAR2(6)

PROD_ORDER

  • PROD_ORDER_DATE — DATE
  • PROD_PLAN_CODE — VARCHAR2(20)
  • TASK_PRIORITY — NUMBER
  • CURRENT_STATE — VARCHAR2(10)

PROD_PLAN_DETAIL

  • TASK_PRIORITY — NUMBER
  • PROD_PLAN_CODE — VARCHAR2(50)
  • FINISHED_PRODUCT_CODE — VARCHAR(50)
  • ORDER_QUANTITY — NUMBER
  • PROD_ORDER_QUANTITY — NUMBER
  • PROD_START_DATE — DATE
  • PROD_END_DATE — DATE
  • LINE_CODE — VARCHAR2(50)

RECEIPT

  • ReceiptID — VARCHAR2(30)
  • ReceiptDate — DATE
  • Vendor — VARCHAR2(50)
  • ProductName — VARCHAR2(50)
  • Quantity — NUMBER
  • Price — NUMBER
  • TotalPRICE — NUMBER

STOCK

  • STOCKID — VARCHAR2(50)
  • ProductName — VARCHAR2(50)
  • Quantity — NUMBER
  • CostPerUnit — NUMBER

bill_of_materials

  • bom_code — VARCHAR2(6)
  • sequence_number — NUMBER
  • finished_product_code — VARCHAR2(6)
  • material_code — VARCHAR2(6)
  • unit — VARCHAR2(30)
  • consumption — NUMBER
  • process_code — VARCHAR2(6)
  • remarks — VARCHAR2(1000)
  • EQM_Use — VARCHAR2(2)

material_lot_management

  • material_lot_code — VARCHAR2(50)
  • material_code — VARCHAR2(50)
  • material_lot_registration_quantity — NUMBER
  • remaining_quantity_of_material_lot — NUMBER
  • material_receipt_code — VARCHAR2(50)
  • material_inspection_code — VARCHAR2(50)
  • material_ordering_code — VARCHAR2(50)
  • expiration_date — DATE

material_management

  • material_code — VARCHAR2(6)
  • account_code — VARCHAR2(6)
  • material_name — VARCHAR2(50)
  • material_standard — VARCHAR2(50)
  • material_unit — VARCHAR2(30)
  • material_type — VARCHAR2(50)
  • safety_stock — NUMBER
  • EQM_Use — VARCHAR2(2)

material_order

  • order_number — VARCHAR2(50)
  • order_request_date — DATE
  • account_code — VARCHAR2(50)

material_order_details

  • order_number — VARCHAR2(50)
  • material_code — VARCHAR2(50)
  • receipt_date — NUMBER
  • order_quantity — NUMBER
  • request_delivery_date — DATE

material_warehousing

  • order_number — VARCHAR2(50)
  • material_code — VARCHAR2(20)
  • receipt_date — DATE
  • order_quantity — NUMBER
  • receipt_type — VARCHAR2(50)

material_warehousing_inspection

  • inspection_number — NUMBER
  • inspection_date — DATE
  • checker — VARCHAR2(30)
  • stocking_date — DATE

material_warehousing_inspection_defect

  • material_code — VARCHAR2(6)
  • inspection_number — NUMBER
  • defective_quantity — NUMBER

material_warehousing_inspection_details

  • material_code — VARCHAR2(6)PRIMARY
  • inspection_number — NUMBER
  • order_number — NUMBER
  • inspected_quantity — NUMBER
  • defective_quantity — NUMBER
  • defect_number — VARCHAR2(50)
  • defect_content — VARCHAR2(50)

process_control

  • process_code — VARCHAR2(50)
  • process_name — VARCHAR2(50)
  • process_classification — VARCHAR2(50)
  • process_details — VARCHAR2(2000)

process_defect_details

  • process_code — VARCHAR2(50)
  • prod_order_date — DATE
  • PROD_PLAN_CODE — VARCHAR2(50)
  • defect_quantity — NUMBER
  • defective_name — VARCHAR2(50)

product_inspection_defect_management

  • finished_product_lot_number — NUMBER
  • FINISHED_PRODUCT_CODE — VARCHAR2(6)
  • finished_product_name — VARCHAR2(30)
  • defect_type — VARCHAR2(50)
  • defect_details — VARCHAR2(100)
  • inspection_person — VARCHAR2(30)
  • inspection_date — DATE

product_inspection_management

  • finished_product_lot_number — NUMBER
  • FINISHED_PRODUCT_CODE — VARCHAR2(6)
  • finished_product_name — VARCHAR2(50)
  • order_code — VARCHAR2(50)
  • test_result — VARCHAR2(50)
  • inspection_person — VARCHAR2(50)
  • inspection_date — DATE

progress_management

  • process_code — VARCHAR2(50)
  • prod_order_date — DATE
  • PROD_PLAN_CODE — VARCHAR2(50)
  • start_time — DATE
  • work_end_time — DATE
  • process_manager — VARCHAR2(30)
  • PROD_ORDER_QUANTITY — NUMBER
  • defect_quantity — NUMBER
  • production_number — NUMBER
  • Line_Code — VARCHAR2(50)
  • task_priority — NUMBER