Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

STADW.ST_JOURNALLINE_GL_HIST

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 CREATEDBYPERSONNAMEDISPLAYNAME VARCHAR2(2000) SI    
2 CREATEDBYPERSONNAMEEFFECTIVESTARTDATE DATE SI    
3 CREATEDBYPERSONNAMELASTUPDATEDATE DATE SI    
4 FUNPOSTACCTSEQVERSIONSHEADERNAME VARCHAR2(2000) SI    
5 JEHEADERID NUMBER NO    
6 JELINENUM NUMBER NO    
7 JOURNALLINEGLID VARCHAR2(20) SI    
8 JOURNALBATCHCOMPLETIONSTATUSCODE VARCHAR2(10) SI    
9 JOURNALBATCHPOSTINGSTATUSCODE VARCHAR2(10) SI    
10 JRNLBATCHCHARTOFACCOUNTSID NUMBER SI    
11 JRNLBATCHDESCRIPTION VARCHAR2(2000) SI    
12 JRNLBATCHJEBATCHID NUMBER SI    
13 JRNLBATCHNAME VARCHAR2(2000) SI    
14 JRNLHDRACCRUALREVPERIODNAME VARCHAR2(50) SI    
15 JRNLHDRCURRENCYCODE VARCHAR2(10) SI    
16 JRNLHDRCURRENCYCONVERSIONDATE DATE SI    
17 JRNLHDRCURRENCYCONVERSIONRATE NUMBER SI    
18 JRNLHDRDESCRIPTION VARCHAR2(2000) SI    
19 JRNLHDRJECATEGORY VARCHAR2(2000) SI    
20 JRNLHDRJESOURCE VARCHAR2(2000) SI    
21 JRNLHDRLEDGERID NUMBER SI    
22 JRNLLINEACCOUNTEDCR NUMBER SI    
23 JRNLLINEACCOUNTEDDR NUMBER SI    
24 JRNLLINECODECOMBINATIONID NUMBER SI    
25 JRNLLINECREATEDBY VARCHAR2(100) SI    
26 JRNLLINECREATIONDATE DATE SI    
27 JRNLLINECURRENCYCODE VARCHAR2(50) SI    
28 JRNLLINEDESCRIPTION VARCHAR2(2000) SI    
29 JRNLLINEEFFECTIVEDATE DATE SI    
30 JRNLLINEENTEREDCR NUMBER SI    
31 JRNLLINEENTEREDDR NUMBER SI    
32 JRNLLINEGLSLLINKID NUMBER SI    
33 LOCALDOCSEQUENCENAME VARCHAR2(200) SI    
34 IDMAESTROCARGUE NUMBER(18,0) NO    

Restricciones

CHECK: SYS_C00190192

CHECK: SYS_C00190193

CHECK: SYS_C00190194

DDL

-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name

← Volver a tablas de STADW

🏠 Volver al menú principal