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