Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_JOURNALELINE_GL
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | AEHEADERID | NUMBER | NO | ||
| 2 | AELINENUM | NUMBER | 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 | ||
| 46 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 47 | XLALINESLASTUPDATEDATE | DATE | SI |
Restricciones
CHECK: SYS_C00191150
- Estado: ENABLED
- Columnas: AEHEADERID
- Condición:
"AEHEADERID" IS NOT NULL
CHECK: SYS_C00191151
- Estado: ENABLED
- Columnas: AELINENUM
- Condición:
"AELINENUM" IS NOT NULL
CHECK: SYS_C00191152
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_JOURNALELINE_GL"
( "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,
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE,
"XLALINESLASTUPDATEDATE" DATE
) DEFAULT COLLATION "USING_NLS_COMP" ;