TageTik: DATI_SALDI_LORDI-表结构

TAGETIK系统 一个表：DATI_SALDI_LORDI-表结构：

参考：https://zhuanlan.zhihu.com/p/611771293

CREATE TABLE TGK."DATI_SALDI_LORDI" ( 
OID_DATI_SALDI_LORDI VARCHAR2(36),
COD_SCENARIO VARCHAR2(15),
COD_PERIODO VARCHAR2(2),
COD_AZIENDA VARCHAR2(30),
COD_CONTO VARCHAR2(30),
COD_DEST1 VARCHAR2(30),
COD_DEST2 VARCHAR2(30),
COD_DEST3 VARCHAR2(30),
COD_DEST4 VARCHAR2(30),
COD_DEST5 VARCHAR2(30),
COD_CATEGORIA VARCHAR2(30),
IMPORTO NUMBER  DEFAULT 0  not null,
COD_VALUTA VARCHAR2(5),
IMPORTO_VALUTA_ORIGINARIA NUMBER  DEFAULT 0  not null,
COD_VALUTA_ORIGINARIA VARCHAR2(5),
PROVENIENZA VARCHAR2(80),
USERUPD VARCHAR2(255),
DATEUPD DATE,
NOTE VARCHAR2(1000) 
 ) ;
 
COMMENT ON TABLE TGK."DATI_SALDI_LORDI" IS '总余额数据表';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_SCENARIO IS '场景的代码。这是一个活跃的原始场景。关联：SCENARIO_PERIODO';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_PERIODO IS '期间代码。这是一个属于场景的期间。关联：SCENARIO_PERIODO（场景的期间表）'; 
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_AZIENDA IS '实体代码，即：公司代码，关联：AZIENDA';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_CONTO IS '科目代码，关联：CONTO';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_DEST1 IS '自定义尺寸1：自定义尺寸元素代码。关联：DEST1';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_DEST2 IS '自定义尺寸2：自定义尺寸元素代码。关联：DEST2';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_DEST3 IS '自定义尺寸3：自定义尺寸元素代码。关联：DEST3';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_DEST4 IS '自定义尺寸4：自定义尺寸元素代码。关联：DEST4';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_DEST5 IS '自定义尺寸5：自定义尺寸元素代码。关联：DEST5';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_CATEGORIA IS '类别代码，这是一个"数量"类别,关联：CATEGORIA（类别表）';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".IMPORTO IS '实体货币金额';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_VALUTA IS '实体货币代码，关联：VALUTA(货币表）';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".IMPORTO_VALUTA_ORIGINARIA IS '交易货币金额，其中IMPORTO即AMOUNT. ';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".COD_VALUTA_ORIGINARIA IS '交易货币代码，关联：VALUTA(货币表）';
COMMENT ON COLUMN TGK."DATI_SALDI_LORDI".NOTE IS '节点';

　　

DATI_SALDI_LORDI： 总余额表