🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_JOURNALELINE_GL

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de contabilidad auxiliar que registra líneas contables XLA antes de su transferencia a General Ledger, permitiendo rastrear el origen de transacciones AP, AR y cobros. English: Subledger accounting table that stores XLA accounting lines before transfer to General Ledger, enabling traceability of AP, AR, and receipt transactions.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	JOURNALELINE_GL_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306900”.nextval
2	AEHEADERID	NUMBER	NO
3	AELINENUM	NUMBER	NO
4	DOCSEQCATEGNAME	VARCHAR2(2000)	SI
5	DOCSEQNAME	VARCHAR2(2000)	SI
6	PERSONCREATEDBYDISPLAYNAME	VARCHAR2(2000)	SI
7	TRANSACTIONENTITYENTITYCODE	VARCHAR2(2000)	SI
8	TRANSACTIONENTITYENTITYID	NUMBER	SI
9	TRANSACTIONENTITYTRANSACTIONNUMBER	VARCHAR2(200)	SI
10	XLAAPPLNVLHDRJESOURCENAME	VARCHAR2(2000)	SI
11	XLAAPPLNVLLINESJESOURCENAME	VARCHAR2(2000)	SI
12	XLAAPPLNVLTRXENTITYJESOURCENAME	VARCHAR2(2000)	SI
13	XLAHDRACCOUNTINGENTRYTYPECODE	VARCHAR2(2000)	SI
14	XLAHDRBALANCETYPECODE	VARCHAR2(2000)	SI
15	XLAHDRCOMPLETEDDATE	DATE	SI
16	XLAHDRCREATEDBY	VARCHAR2(2000)	SI
17	XLAHDRCREATIONDATE	DATE	SI
18	XLAHDRDESCRIPTION	VARCHAR2(2000)	SI
19	XLAHDRDOCSEQUENCEVALUE	NUMBER	SI
20	XLAHDREVENTID	NUMBER	SI
21	XLAHDREVENTTYPECODE	VARCHAR2(2000)	SI
22	XLAHDRGLTRANSFERDATE	DATE	SI
23	XLAHDRJECATEGORYNAME	VARCHAR2(2000)	SI
24	XLAHDRLEDGERID	NUMBER	SI
25	XLAHDRMULTIPERIODFLAG	VARCHAR2(2000)	SI
26	XLAHDRPERIODNAME	VARCHAR2(2000)	SI
27	XLAHDRREFERENCEDATE	DATE	SI
28	XLALINESACCOUNTEDCR	NUMBER	SI
29	XLALINESACCOUNTEDDR	NUMBER	SI
30	XLALINESACCOUNTINGDATE	DATE	SI
31	XLALINESAPPLICATIONID	NUMBER	SI
32	XLALINESCODECOMBINATIONID	NUMBER	SI
33	XLALINESCURRENCYCODE	VARCHAR2(2000)	SI
34	XLALINESDESCRIPTION	VARCHAR2(2000)	SI
35	XLALINESDISPLAYEDLINENUMBER	NUMBER	SI
36	XLALINESENTEREDCR	NUMBER	SI
37	XLALINESENTEREDDR	NUMBER	SI
38	XLALINESGLSLLINKID	NUMBER	SI
39	JOURNALELINEID	VARCHAR2(2000)	SI
40	EVNTTYPEXLAHDRVLEVENTCLASSCODE	VARCHAR2(500)	SI
41	CUSTACCTPARTYID	NUMBER	SI
42	APINVOICEID	NUMBER	SI
43	APCHECKID	NUMBER	SI
44	CASHRECEIPTID	NUMBER	SI
45	ARCUSTOMERTRXID	NUMBER	SI
46	CMRACCOUNTINGEVENTID	NUMBER	SI
47	AUDIT_ID	NUMBER	NO
48	ROW_ACTIVE	CHAR(1)	NO	‘A’
49	FACT_CASHRECEIPT_GL_ID	NUMBER	SI
50	FACT_RECEIPTACCOUNTING_GL_ID	NUMBER	SI
51	FACT_TRXHEADER_AP_ID	NUMBER	SI
52	FACT_PAYMENT_AP_ID	NUMBER	SI
53	FACT_TRXHEADER_PO_ID	NUMBER	SI
54	DIM_CODECOMBINATION_GL_ID	NUMBER	SI

Restricciones

CHECK: FACT_JOURNALELINE_GL_AI_CK

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

CHECK: SYS_C00202873

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

CHECK: SYS_C00202874

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

CHECK: SYS_C00202875

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

CHECK: SYS_C00202876

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

CHECK: SYS_C00202877

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

PK: FACT_JOURNALELINE_GL_PK

• Estado: ENABLED
• Columnas: JOURNALELINE_GL_ID

FK: FACT_JOURNALELINE_GL_DIM_CODECOMBINATION_GL_FK

• Estado: ENABLED
• Columnas: DIM_CODECOMBINATION_GL_ID
• Referencia: DWADW.DIM_CODECOMBINATION_GL (constraint DIM_CODECOMBINATION_GL_PK)

FK: FACT_JOURNALELINE_GL_FACT_CASHRECEIPT_GL_FK

• Estado: ENABLED
• Columnas: FACT_CASHRECEIPT_GL_ID
• Referencia: DWADW.FACT_CASHRECEIPT_GL (constraint FACT_CASHRECEIPT_GL_PK)

FK: FACT_JOURNALELINE_GL_FACT_PAYMENT_AP_FK

• Estado: ENABLED
• Columnas: FACT_PAYMENT_AP_ID
• Referencia: DWADW.FACT_PAYMENT_AP (constraint FACT_PAYMENT_AP_PK)

FK: FACT_JOURNALELINE_GL_FACT_RECEIPTACCOUNTING_GL_FK

• Estado: ENABLED
• Columnas: FACT_RECEIPTACCOUNTING_GL_ID
• Referencia: DWADW.FACT_RECEIPTACCOUNTING_GL (constraint FACT_RECEIPTACCOUNTING_GL_PK)

FK: FACT_JOURNALELINE_GL_FACT_TRXHEADER_AP_FK

• Estado: ENABLED
• Columnas: FACT_TRXHEADER_AP_ID
• Referencia: DWADW.FACT_TRXHEADER_AP (constraint FACT_TRXHEADER_AP_PK)

FK: FACT_JOURNALELINE_GL_FACT_TRXHEADER_PO_FK

• Estado: ENABLED
• Columnas: FACT_TRXHEADER_PO_ID
• Referencia: DWADW.FACT_TRXHEADER_PO (constraint FACT_TRXHEADER_PO_PK)

UK: FACT_JOURNALELINE_GL_AEHEADER_AELINENUM_XLAHDREVENTID_UN

• Estado: ENABLED
• Columnas: AEHEADERID, AELINENUM, XLAHDREVENTID

DDL

CREATE TABLE "DWADW"."FACT_JOURNALELINE_GL" 
   (	"JOURNALELINE_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(*,0) NOT NULL ENABLE, 
	"AELINENUM" NUMBER(*,0) NOT NULL ENABLE, 
	"DOCSEQCATEGNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"DOCSEQNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PERSONCREATEDBYDISPLAYNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONENTITYENTITYCODE" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"TRANSACTIONENTITYENTITYID" NUMBER, 
	"TRANSACTIONENTITYTRANSACTIONNUMBER" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"XLAAPPLNVLHDRJESOURCENAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAAPPLNVLLINESJESOURCENAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAAPPLNVLTRXENTITYJESOURCENAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRACCOUNTINGENTRYTYPECODE" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRBALANCETYPECODE" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRCOMPLETEDDATE" DATE, 
	"XLAHDRCREATEDBY" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRCREATIONDATE" DATE, 
	"XLAHDRDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRDOCSEQUENCEVALUE" NUMBER, 
	"XLAHDREVENTID" NUMBER, 
	"XLAHDREVENTTYPECODE" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRGLTRANSFERDATE" DATE, 
	"XLAHDRJECATEGORYNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRLEDGERID" NUMBER, 
	"XLAHDRMULTIPERIODFLAG" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRPERIODNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLAHDRREFERENCEDATE" DATE, 
	"XLALINESACCOUNTEDCR" NUMBER, 
	"XLALINESACCOUNTEDDR" NUMBER, 
	"XLALINESACCOUNTINGDATE" DATE, 
	"XLALINESAPPLICATIONID" NUMBER, 
	"XLALINESCODECOMBINATIONID" NUMBER, 
	"XLALINESCURRENCYCODE" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLALINESDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"XLALINESDISPLAYEDLINENUMBER" NUMBER, 
	"XLALINESENTEREDCR" NUMBER, 
	"XLALINESENTEREDDR" NUMBER, 
	"XLALINESGLSLLINKID" NUMBER, 
	"JOURNALELINEID" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"EVNTTYPEXLAHDRVLEVENTCLASSCODE" VARCHAR2(500) COLLATE "USING_NLS_COMP", 
	"CUSTACCTPARTYID" NUMBER, 
	"APINVOICEID" NUMBER, 
	"APCHECKID" NUMBER, 
	"CASHRECEIPTID" NUMBER, 
	"ARCUSTOMERTRXID" NUMBER, 
	"CMRACCOUNTINGEVENTID" NUMBER, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"FACT_CASHRECEIPT_GL_ID" NUMBER, 
	"FACT_RECEIPTACCOUNTING_GL_ID" NUMBER, 
	"FACT_TRXHEADER_AP_ID" NUMBER, 
	"FACT_PAYMENT_AP_ID" NUMBER, 
	"FACT_TRXHEADER_PO_ID" NUMBER, 
	"DIM_CODECOMBINATION_GL_ID" NUMBER, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_PK" PRIMARY KEY ("JOURNALELINE_GL_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_AEHEADER_AELINENUM_XLAHDREVENTID_UN" UNIQUE ("AEHEADERID", "AELINENUM", "XLAHDREVENTID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_DIM_CODECOMBINATION_GL_FK" FOREIGN KEY ("DIM_CODECOMBINATION_GL_ID")
	  REFERENCES "DWADW"."DIM_CODECOMBINATION_GL" ("CODECOMBINATION_GL_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_FACT_CASHRECEIPT_GL_FK" FOREIGN KEY ("FACT_CASHRECEIPT_GL_ID")
	  REFERENCES "DWADW"."FACT_CASHRECEIPT_GL" ("CASHRECEIPT_GL_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_FACT_PAYMENT_AP_FK" FOREIGN KEY ("FACT_PAYMENT_AP_ID")
	  REFERENCES "DWADW"."FACT_PAYMENT_AP" ("PAYMENT_AP_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_FACT_RECEIPTACCOUNTING_GL_FK" FOREIGN KEY ("FACT_RECEIPTACCOUNTING_GL_ID")
	  REFERENCES "DWADW"."FACT_RECEIPTACCOUNTING_GL" ("RECEIPTACCOUNTING_GL_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_FACT_TRXHEADER_AP_FK" FOREIGN KEY ("FACT_TRXHEADER_AP_ID")
	  REFERENCES "DWADW"."FACT_TRXHEADER_AP" ("TRXHEADER_AP_ID") ENABLE, 
	 CONSTRAINT "FACT_JOURNALELINE_GL_FACT_TRXHEADER_PO_FK" FOREIGN KEY ("FACT_TRXHEADER_PO_ID")
	  REFERENCES "DWADW"."FACT_TRXHEADER_PO" ("TRXHEADER_PO_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_JOURNALELINE_GL"  IS 'Español: Tabla de contabilidad auxiliar que registra líneas contables XLA antes de su transferencia a General Ledger, permitiendo rastrear el origen de transacciones AP, AR y cobros.
English: Subledger accounting table that stores XLA accounting lines before transfer to General Ledger, enabling traceability of AP, AR, and receipt transactions.';

CREATE INDEX "DWADW"."JE_LINE_AE_IDX" ON "DWADW"."FACT_JOURNALELINE_GL" ("AEHEADERID", "AELINENUM") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_JOURNALELINE_GL_AEHEADER_AELINENUM_XLAHDREVENTID_UN" ON "DWADW"."FACT_JOURNALELINE_GL" ("AEHEADERID", "AELINENUM", "XLAHDREVENTID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_JOURNALELINE_GL_PK" ON "DWADW"."FACT_JOURNALELINE_GL" ("JOURNALELINE_GL_ID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal