ggms_interface

Tables (6)

t_activedata

  • activedata_id (PK) — INTEGER — Primary key — NOT NULL
  • plant (Field) — VARCHAR(2)
  • process (Field10) — VARCHAR(10)
  • 배출활동코드 (Field2) — VARCHAR(4)
  • 배출시설코드 (Field4) — VARCHAR(4)
  • 배출시설일련번호 (Field6) — VARCHAR(10)
  • 연료타입 (Field5) — VARCHAR(10)
  • 단위 (Field9) — VARCHAR(4)
  • formula (Field7) — VARCHAR(500)
  • value (Field3) — FLOAT

t_activedata_master (t_activedata_calculation)

  • master_code (PK) — INTEGER — Primary key — NOT NULL
  • plant (Field) — VARCHAR(2)
  • interface_sys (Field10) — VARCHAR(10)
  • matnr (Field2) — VARCHAR(4)
  • bwart (Field4) — INTEGER
  • kostl (Field5) — INTEGER
  • kostl_j (Field9) — VARCHAR(50)
  • tagname (Field6) — VARCHAR(10)
  • tagtype (Field7) — FLOAT

t_inteface_dataparc (t_interface_dataparc)

  • interface_id (PK) — INTEGER — Primary key — NOT NULL
  • plant (Field) — VARCHAR(2)
  • tagtype (Field11) — VARCHAR(10)
  • tagname (Field2) — VARCHAR(100)
  • timestamp (Field3) — TIMESTAMP
  • value (Field12) — FLOAT
  • lValue (Field4) — FLOAT
  • sValue (Field5) — INTEGER
  • quality (Field6) — INTEGER
  • squality (Field7) — VARCHAR(100)
  • historianQuality (Field8) — INTEGER
  • sHistorianQuality (Field9) — VARCHAR(100)
  • eai_datetime (Field10) — TIMESTAMP

t_interface_sap

  • interface_id (PK) — INTEGER — Primary key — NOT NULL
  • plant (Field) — VARCHAR(2)
  • matnr (Field2) — VARCHAR(20)
  • budat (Field3) — TIMESTAMP
  • bwart (Field4) — INTEGER
  • kostl (Field5) — INTEGER
  • kostl_j (Field9) — VARCHAR(50)
  • erfme (Field6) — VARCHAR(10)
  • menge (Field7) — FLOAT
  • aufnr (Field13) — VARCHAR(20)
  • kunnr (Field14) — VARCHAR(20)
  • grund (Field15) — INTEGER
  • sgtxt (Field16) — VARCHAR(50)
  • eai_user (Field10) — VARCHAR(20
  • eai_datetime (Field11) — VARCHAR(20)
  • eai_uuid (Field12) — VARCHAR(20)

t_xxx_dataparc

  • interface_id (PK,FK) — INTEGER — Foreign key → t_inteface_dataparc.interface_id — NOT NULL
  • plant (Field) — VARCHAR(2)
  • tagtype (Field11) — VARCHAR(10)
  • tagname (Field2) — VARCHAR(100)
  • timestamp (Field3) — TIMESTAMP
  • value (Field4) — FLOAT

t_xxx_sap

  • interface_id (PK,FK) — INTEGER — Foreign key → t_interface_sap.interface_id — NOT NULL
  • plant (Field) — VARCHAR(2)
  • sgtxt (Field10) — VARCHAR(50)
  • matnr (Field2) — VARCHAR(20)
  • budat (Field3) — TIMESTAMP
  • bwart (Field4) — INTEGER
  • kostl (Field5) — INTEGER
  • kostl_j (Field9) — VARCHAR(50)
  • erfme (Field6) — VARCHAR(10)
  • menge (Field7) — FLOAT