Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.FACT_JOURNALELINE_GL_20260610_COPIA
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | JOURNALELINE_GL_ID | NUMBER | NO | ||
| 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 | ||
| 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: SYS_C00234518
- Estado: ENABLED
- Columnas: JOURNALELINE_GL_ID
- Condición:
"JOURNALELINE_GL_ID" IS NOT NULL
CHECK: SYS_C00234519
- Estado: ENABLED
- Columnas: AEHEADERID
- Condición:
"AEHEADERID" IS NOT NULL
CHECK: SYS_C00234520
- Estado: ENABLED
- Columnas: AELINENUM
- Condición:
"AELINENUM" IS NOT NULL
CHECK: SYS_C00234521
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00234522
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
DDL
CREATE TABLE "DWADW"."FACT_JOURNALELINE_GL_20260610_COPIA"
( "JOURNALELINE_GL_ID" NUMBER 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" 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
) DEFAULT COLLATION "USING_NLS_COMP" ;