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