🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_JOURNALENTRYDIST_GL5

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	AEHEADERID	NUMBER	NO
2	AELINENUM	NUMBER	NO
3	JEHEADERID	NUMBER	SI
4	JELINENUM	NUMBER	SI
5	AUDIT_ID	NUMBER	NO
6	ROW_ACTIVE	CHAR(1)	NO
7	FACT_JOURNALLINEGL_GL_ID	NUMBER	SI
8	FACT_JOURNALELINE_GL_ID	NUMBER	SI
9	DLINKAPPLICATIONID	NUMBER	SI
10	DLINKREFAEHEADERID	NUMBER	SI
11	DLINKTEMPLINENUM	NUMBER	SI
12	DLINKAEHEADERID	NUMBER	SI
13	GLIMPREFJEHEADERID	NUMBER	SI
14	GLIMPREFJELINENUM	NUMBER	SI
15	JOURNALENTRYDIST_GL_ID	NUMBER	NO	“DWADW”.”ISEQ$$_335360”.nextval

Restricciones

CHECK: SYS_C00239397

• Estado: ENABLED
• Columnas: AEHEADERID
• Condición: "AEHEADERID" IS NOT NULL

CHECK: SYS_C00239398

• Estado: ENABLED
• Columnas: AELINENUM
• Condición: "AELINENUM" IS NOT NULL

CHECK: SYS_C00239399

• Estado: ENABLED
• Columnas: AUDIT_ID
• Condición: "AUDIT_ID" IS NOT NULL

CHECK: SYS_C00239400

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: "ROW_ACTIVE" IS NOT NULL

CHECK: SYS_C00239436

• Estado: ENABLED
• Columnas: JOURNALENTRYDIST_GL_ID
• Condición: "JOURNALENTRYDIST_GL_ID" IS NOT NULL

DDL

CREATE TABLE "DWADW"."FACT_JOURNALENTRYDIST_GL5" 
   (	"AEHEADERID" NUMBER NOT NULL ENABLE, 
	"AELINENUM" NUMBER NOT NULL ENABLE, 
	"JEHEADERID" NUMBER, 
	"JELINENUM" NUMBER, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FACT_JOURNALLINEGL_GL_ID" NUMBER, 
	"FACT_JOURNALELINE_GL_ID" NUMBER, 
	"DLINKAPPLICATIONID" NUMBER, 
	"DLINKREFAEHEADERID" NUMBER, 
	"DLINKTEMPLINENUM" NUMBER, 
	"DLINKAEHEADERID" NUMBER, 
	"GLIMPREFJEHEADERID" NUMBER, 
	"GLIMPREFJELINENUM" NUMBER, 
	"JOURNALENTRYDIST_GL_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal