Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DW_JOURNALELINE_TEMP
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | AEHEADERID | NUMBER(38,0) | NO | ||
| 2 | AELINENUM | NUMBER(38,0) | NO | ||
| 3 | DOCSEQCATEGNAME | VARCHAR2(2000) | SI | ||
| 4 | DOCSEQNAME | VARCHAR2(2000) | SI | ||
| 5 | PERSONCREATEDBYDISPLAYNAME | VARCHAR2(2000) | SI | ||
| 6 | TRANSACTIONENTITYENTITYCODE | VARCHAR2(2000) | SI | ||
| 7 | TRANSACTIONENTITYENTITYID | NUMBER | SI | ||
| 8 | TRANSACTIONENTITYTRANSACTIONNUMBER | VARCHAR2(200) | SI | ||
| 9 | XLAAPPLNVLHDRJESOURCENAME | VARCHAR2(2000) | SI | ||
| 10 | XLAAPPLNVLLINESJESOURCENAME | VARCHAR2(2000) | SI | ||
| 11 | XLAAPPLNVLTRXENTITYJESOURCENAME | VARCHAR2(2000) | SI | ||
| 12 | XLAHDRACCOUNTINGENTRYTYPECODE | VARCHAR2(2000) | SI | ||
| 13 | XLAHDRBALANCETYPECODE | VARCHAR2(2000) | SI | ||
| 14 | XLAHDRCOMPLETEDDATE | DATE | SI | ||
| 15 | XLAHDRCREATEDBY | VARCHAR2(2000) | SI | ||
| 16 | XLAHDRCREATIONDATE | DATE | SI | ||
| 17 | XLAHDRDESCRIPTION | VARCHAR2(2000) | SI | ||
| 18 | XLAHDRDOCSEQUENCEVALUE | NUMBER | SI | ||
| 19 | XLAHDREVENTID | NUMBER | SI | ||
| 20 | XLAHDREVENTTYPECODE | VARCHAR2(2000) | SI | ||
| 21 | XLAHDRGLTRANSFERDATE | DATE | SI | ||
| 22 | XLAHDRJECATEGORYNAME | VARCHAR2(2000) | SI | ||
| 23 | XLAHDRLEDGERID | NUMBER | SI | ||
| 24 | XLAHDRMULTIPERIODFLAG | VARCHAR2(2000) | SI | ||
| 25 | XLAHDRPERIODNAME | VARCHAR2(2000) | SI | ||
| 26 | XLAHDRREFERENCEDATE | DATE | SI | ||
| 27 | XLALINESACCOUNTEDCR | NUMBER | SI | ||
| 28 | XLALINESACCOUNTEDDR | NUMBER | SI | ||
| 29 | XLALINESACCOUNTINGDATE | DATE | SI | ||
| 30 | XLALINESAPPLICATIONID | NUMBER | SI | ||
| 31 | XLALINESCODECOMBINATIONID | NUMBER | SI | ||
| 32 | XLALINESCURRENCYCODE | VARCHAR2(2000) | SI | ||
| 33 | XLALINESDESCRIPTION | VARCHAR2(2000) | SI | ||
| 34 | XLALINESDISPLAYEDLINENUMBER | NUMBER | SI | ||
| 35 | XLALINESENTEREDCR | NUMBER | SI | ||
| 36 | XLALINESENTEREDDR | NUMBER | SI | ||
| 37 | XLALINESGLSLLINKID | NUMBER | SI | ||
| 38 | JOURNALELINEID | VARCHAR2(2000) | SI | ||
| 39 | EVNTTYPEXLAHDRVLEVENTCLASSCODE | VARCHAR2(500) | SI | ||
| 40 | CUSTACCTPARTYID | NUMBER | SI | ||
| 41 | APINVOICEID | NUMBER | SI | ||
| 42 | APCHECKID | NUMBER | SI | ||
| 43 | CASHRECEIPTID | NUMBER | SI | ||
| 44 | ARCUSTOMERTRXID | NUMBER | SI | ||
| 45 | CMRACCOUNTINGEVENTID | NUMBER | SI |
Restricciones
PK: PK_JL_TEMP
- Estado: ENABLED
- Columnas: AEHEADERID, AELINENUM
DDL
CREATE TABLE "DWADW"."DW_JOURNALELINE_TEMP"
( "AEHEADERID" NUMBER(38,0),
"AELINENUM" NUMBER(38,0),
"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
) DEFAULT COLLATION "USING_NLS_COMP" ;
CREATE INDEX "DWADW"."INDEX_JL_TEMP" ON "DWADW"."DW_JOURNALELINE_TEMP" ("AEHEADERID", "AELINENUM")
;
ALTER TABLE "DWADW"."DW_JOURNALELINE_TEMP" ADD CONSTRAINT "PK_JL_TEMP" PRIMARY KEY ("AEHEADERID", "AELINENUM")
USING INDEX "DWADW"."INDEX_JL_TEMP" ENABLE;
GRANT ALTER ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT DELETE ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT INDEX ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT INSERT ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT SELECT ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT UPDATE ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT REFERENCES ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT READ ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT ON COMMIT REFRESH ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT QUERY REWRITE ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT DEBUG ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
GRANT FLASHBACK ON "DWADW"."DW_JOURNALELINE_TEMP" TO "BICC";
CREATE INDEX "DWADW"."INDEX_DW_journalELine_temp_XLAHDRPERIODNAME" ON "DWADW"."DW_JOURNALELINE_TEMP" ("XLAHDRPERIODNAME")
;
CREATE INDEX "DWADW"."INDEX_JL_TEMP" ON "DWADW"."DW_JOURNALELINE_TEMP" ("AEHEADERID", "AELINENUM")
;