🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_JOURNALENTRYDIST_GLBORRRA

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla puente entre contabilidad auxiliar y libro mayor que relaciona líneas contables del subledger con asientos contables de General Ledger. English: Bridge table between subledger accounting and General Ledger that links subledger accounting lines with General Ledger journal entries.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	JOURNALENTRYDIST_GL_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306904”.nextval
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	‘A’
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: FACT_JOURNALENTRYDIST_GL_AI_CK

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: row_active IN ('A','I')

CHECK: SYS_C00202882

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

CHECK: SYS_C00202883

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

CHECK: SYS_C00202884

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

CHECK: SYS_C00202885

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

CHECK: SYS_C00202886

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

PK: FACT_JOURNALENTRYDIST_GL_PK

• Estado: ENABLED
• Columnas: JOURNALENTRYDIST_GL_ID

FK: FACT_JOURNALENTRYDIST_GL_FACT_JOURNALELINE_GL_FK

• Estado: ENABLED
• Columnas: FACT_JOURNALELINE_GL_ID
• Referencia: DWADW.FACT_JOURNALELINE_GL (constraint FACT_JOURNALELINE_GL_PK)

FK: FACT_JOURNALENTRYDIST_GL_FACT_JOURNALLINEGL_GL_FK

• Estado: ENABLED
• Columnas: FACT_JOURNALLINEGL_GL_ID
• Referencia: DWADW.FACT_JOURNALLINEGL_GL (constraint FACT_JOURNALLINEGL_GL_PK)

UK: FACT_JEDIST_UN

• Estado: ENABLED
• Columnas: DLINKAPPLICATIONID, DLINKREFAEHEADERID, DLINKTEMPLINENUM, DLINKAEHEADERID, GLIMPREFJEHEADERID, GLIMPREFJELINENUM

DDL

CREATE TABLE "DWADW"."FACT_JOURNALENTRYDIST_GLBORRRA" 
   (	"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, 
	"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" DEFAULT 'A' 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, 
	 CONSTRAINT "FACT_JOURNALENTRYDIST_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_JOURNALENTRYDIST_GL_PK" PRIMARY KEY ("JOURNALENTRYDIST_GL_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_JEDIST_UN" UNIQUE ("DLINKAPPLICATIONID", "DLINKREFAEHEADERID", "DLINKTEMPLINENUM", "DLINKAEHEADERID", "GLIMPREFJEHEADERID", "GLIMPREFJELINENUM")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_JOURNALENTRYDIST_GL_FACT_JOURNALELINE_GL_FK" FOREIGN KEY ("FACT_JOURNALELINE_GL_ID")
	  REFERENCES "DWADW"."FACT_JOURNALELINE_GL" ("JOURNALELINE_GL_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALENTRYDIST_GL_FACT_JOURNALLINEGL_GL_FK" FOREIGN KEY ("FACT_JOURNALLINEGL_GL_ID")
	  REFERENCES "DWADW"."FACT_JOURNALLINEGL_GL" ("JOURNALLINEGL_GL_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_JOURNALENTRYDIST_GLBORRRA"  IS 'Español: Tabla puente entre contabilidad auxiliar y libro mayor que relaciona líneas contables del subledger con asientos contables de General Ledger.
English: Bridge table between subledger accounting and General Ledger that links subledger accounting lines with General Ledger journal entries.';

CREATE UNIQUE INDEX "DWADW"."FACT_JEDIST_UN" ON "DWADW"."FACT_JOURNALENTRYDIST_GLBORRRA" ("DLINKAPPLICATIONID", "DLINKREFAEHEADERID", "DLINKTEMPLINENUM", "DLINKAEHEADERID", "GLIMPREFJEHEADERID", "GLIMPREFJELINENUM") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_JOURNALENTRYDIST_GL_PK" ON "DWADW"."FACT_JOURNALENTRYDIST_GLBORRRA" ("JOURNALENTRYDIST_GL_ID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal