Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.FACT_JOURNALLINEGL_GL

Base de datos origen: ADW COEXITO

Descripción: Español: Detalle de líneas de asientos contables del libro mayor que registra débitos, créditos, cuentas contables y origen de cada movimiento financiero. English: Detail of General Ledger journal entry lines that records debits, credits, accounting accounts, and the origin of each financial transaction.

Columnas

# Columna Tipo Nulo Default Comentario
1 JOURNALLINEGL_GL_ID NUMBER NO “DWADW”.”ISEQ$$_306908”.nextval  
2 CREATEDBYPERSONNAMEDISPLAYNAME VARCHAR2(2000) SI    
3 CREATEDBYPERSONNAMEEFFECTIVESTARTDATE DATE SI    
4 CREATEDBYPERSONNAMELASTUPDATEDATE DATE SI    
5 FUNPOSTACCTSEQVERSIONSHEADERNAME VARCHAR2(2000) SI    
6 JEHEADERID NUMBER NO    
7 JELINENUM NUMBER NO    
8 JOURNALLINEGLID VARCHAR2(20) SI    
9 JOURNALBATCHCOMPLETIONSTATUSCODE VARCHAR2(10) SI    
10 JOURNALBATCHPOSTINGSTATUSCODE VARCHAR2(10) SI    
11 JRNLBATCHCHARTOFACCOUNTSID NUMBER SI    
12 JRNLBATCHDESCRIPTION VARCHAR2(2000) SI    
13 JRNLBATCHJEBATCHID NUMBER SI    
14 JRNLBATCHNAME VARCHAR2(2000) SI    
15 JRNLHDRACCRUALREVPERIODNAME VARCHAR2(50) SI    
16 JRNLHDRCURRENCYCODE VARCHAR2(10) SI    
17 JRNLHDRCURRENCYCONVERSIONDATE DATE SI    
18 JRNLHDRCURRENCYCONVERSIONRATE NUMBER SI    
19 JRNLHDRDESCRIPTION VARCHAR2(2000) SI    
20 JRNLHDRJECATEGORY VARCHAR2(2000) SI    
21 JRNLHDRJESOURCE VARCHAR2(2000) SI    
22 JRNLHDRLEDGERID NUMBER SI    
23 JRNLLINEACCOUNTEDCR NUMBER SI    
24 JRNLLINEACCOUNTEDDR NUMBER SI    
25 JRNLLINECODECOMBINATIONID NUMBER SI    
26 JRNLLINECREATEDBY VARCHAR2(100) SI    
27 JRNLLINECREATIONDATE DATE SI    
28 JRNLLINECURRENCYCODE VARCHAR2(50) SI    
29 JRNLLINEDESCRIPTION VARCHAR2(2000) SI    
30 JRNLLINEEFFECTIVEDATE DATE SI    
31 JRNLLINEENTEREDCR NUMBER SI    
32 JRNLLINEENTEREDDR NUMBER SI    
33 JRNLLINEGLSLLINKID NUMBER SI    
34 LOCALDOCSEQUENCENAME VARCHAR2(200) SI    
35 AUDIT_ID NUMBER(18,0) NO    
36 ROW_ACTIVE CHAR(1) NO ‘A’  
37 DIM_CODECOMBINATION_GL_ID NUMBER SI    
38 DIM_JOURNALSOURCE_GL_ID NUMBER SI    

Restricciones

CHECK: FACT_JOURNALLINEGL_GL_AI_CK

CHECK: SYS_C00202892

CHECK: SYS_C00202893

CHECK: SYS_C00202894

CHECK: SYS_C00202895

CHECK: SYS_C00202896

PK: FACT_JOURNALLINEGL_GL_PK

FK: FACT_JOURNALLINEGL_GL_DIM_CODECOMBINATION_GL_FK

FK: FACT_JOURNALLINEGL_GL_DIM_JOURNALSOURCE_GL_FK

UK: FACT_JOURNALLINEGL_GL__UN

DDL

CREATE TABLE "DWADW"."FACT_JOURNALLINEGL_GL" 
   (	"JOURNALLINEGL_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, 
	"CREATEDBYPERSONNAMEDISPLAYNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"CREATEDBYPERSONNAMEEFFECTIVESTARTDATE" DATE, 
	"CREATEDBYPERSONNAMELASTUPDATEDATE" DATE, 
	"FUNPOSTACCTSEQVERSIONSHEADERNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JEHEADERID" NUMBER(*,0) NOT NULL ENABLE, 
	"JELINENUM" NUMBER(*,0) NOT NULL ENABLE, 
	"JOURNALLINEGLID" VARCHAR2(20) COLLATE "USING_NLS_COMP", 
	"JOURNALBATCHCOMPLETIONSTATUSCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"JOURNALBATCHPOSTINGSTATUSCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"JRNLBATCHCHARTOFACCOUNTSID" NUMBER, 
	"JRNLBATCHDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JRNLBATCHJEBATCHID" NUMBER, 
	"JRNLBATCHNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JRNLHDRACCRUALREVPERIODNAME" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"JRNLHDRCURRENCYCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"JRNLHDRCURRENCYCONVERSIONDATE" DATE, 
	"JRNLHDRCURRENCYCONVERSIONRATE" NUMBER, 
	"JRNLHDRDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JRNLHDRJECATEGORY" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JRNLHDRJESOURCE" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JRNLHDRLEDGERID" NUMBER, 
	"JRNLLINEACCOUNTEDCR" NUMBER, 
	"JRNLLINEACCOUNTEDDR" NUMBER, 
	"JRNLLINECODECOMBINATIONID" NUMBER, 
	"JRNLLINECREATEDBY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"JRNLLINECREATIONDATE" DATE, 
	"JRNLLINECURRENCYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"JRNLLINEDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"JRNLLINEEFFECTIVEDATE" DATE, 
	"JRNLLINEENTEREDCR" NUMBER, 
	"JRNLLINEENTEREDDR" NUMBER, 
	"JRNLLINEGLSLLINKID" NUMBER, 
	"LOCALDOCSEQUENCENAME" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"AUDIT_ID" NUMBER(18,0) NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_CODECOMBINATION_GL_ID" NUMBER, 
	"DIM_JOURNALSOURCE_GL_ID" NUMBER, 
	 CONSTRAINT "FACT_JOURNALLINEGL_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_JOURNALLINEGL_GL_PK" PRIMARY KEY ("JOURNALLINEGL_GL_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_JOURNALLINEGL_GL__UN" UNIQUE ("JEHEADERID", "JELINENUM")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_JOURNALLINEGL_GL_DIM_CODECOMBINATION_GL_FK" FOREIGN KEY ("DIM_CODECOMBINATION_GL_ID")
	  REFERENCES "DWADW"."DIM_CODECOMBINATION_GL" ("CODECOMBINATION_GL_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALLINEGL_GL_DIM_JOURNALSOURCE_GL_FK" FOREIGN KEY ("DIM_JOURNALSOURCE_GL_ID")
	  REFERENCES "DWADW"."DIM_JOURNALSOURCE_GL" ("JOURNALSOURCE_GL_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_JOURNALLINEGL_GL"  IS 'Español: Detalle de líneas de asientos contables del libro mayor que registra débitos, créditos, cuentas contables y origen de cada movimiento financiero.
English: Detail of General Ledger journal entry lines that records debits, credits, accounting accounts, and the origin of each financial transaction.';

CREATE UNIQUE INDEX "DWADW"."FACT_JOURNALLINEGL_GL_PK" ON "DWADW"."FACT_JOURNALLINEGL_GL" ("JOURNALLINEGL_GL_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_JOURNALLINEGL_GL__UN" ON "DWADW"."FACT_JOURNALLINEGL_GL" ("JEHEADERID", "JELINENUM") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal