🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_JOURNALENTRYDIST_GL_20260610_COPIA

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C00234507

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

CHECK: SYS_C00234508

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

CHECK: SYS_C00234509

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

CHECK: SYS_C00234510

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

CHECK: SYS_C00234511

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

DDL

CREATE TABLE "DWADW"."FACT_JOURNALENTRYDIST_GL_20260610_COPIA" 
   (	"JOURNALENTRYDIST_GL_ID" NUMBER NOT NULL ENABLE, 
	"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
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal