🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_JOURNALENTRYDISTRI_GL

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	JOURNALENTRYDISTRI_GL_ID	NUMBER	NO	“DWADW”.”ISEQ$$_335466”.nextval

Restricciones

CHECK: SYS_C00239686

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

CHECK: SYS_C00239687

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

CHECK: SYS_C00239688

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

CHECK: SYS_C00239689

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

CHECK: SYS_C00239690

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

PK: PK_FACT_JOURNALENTRYDISTRI_GL

• Estado: ENABLED
• Columnas: JOURNALENTRYDISTRI_GL_ID

UK: FACT_JOURNALENTRYDISTRI_GL_UN

• Estado: ENABLED
• Columnas: AEHEADERID, AELINENUM

DDL

CREATE TABLE "DWADW"."FACT_JOURNALENTRYDISTRI_GL" 
   (	"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, 
	"JOURNALENTRYDISTRI_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, 
	 CONSTRAINT "PK_FACT_JOURNALENTRYDISTRI_GL" PRIMARY KEY ("JOURNALENTRYDISTRI_GL_ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" 
  PARALLEL 8 ;
  CREATE INDEX "DWADW"."DISTRI_AE_IDX_" ON "DWADW"."FACT_JOURNALENTRYDISTRI_GL" ("AEHEADERID", "AELINENUM") 
  ;
ALTER TABLE "DWADW"."FACT_JOURNALENTRYDISTRI_GL" ADD CONSTRAINT "FACT_JOURNALENTRYDISTRI_GL_UN" UNIQUE ("AEHEADERID", "AELINENUM")
  USING INDEX "DWADW"."DISTRI_AE_IDX_"  ENABLE;

CREATE INDEX "DWADW"."DISTRI_AE_IDX_" ON "DWADW"."FACT_JOURNALENTRYDISTRI_GL" ("AEHEADERID", "AELINENUM") 
  ;
  CREATE UNIQUE INDEX "DWADW"."PK_FACT_JOURNALENTRYDISTRI_GL" ON "DWADW"."FACT_JOURNALENTRYDISTRI_GL" ("JOURNALENTRYDISTRI_GL_ID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal