Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

LACLS.LACLS_CO_MM_LINES

Base de datos origen: PDB1

Columnas

# Columna Tipo Nulo Default Comentario
1 LINE_ID NUMBER NO    
2 HEADER_ID NUMBER NO    
3 FORMAT_ID NUMBER NO    
4 CONCEPT_ID NUMBER NO    
5 LEDGER_ID NUMBER SI    
6 PERIOD_NAME VARCHAR2(15) NO    
7 PARTY_ID NUMBER NO    
8 CODE_COMBINATION_ID NUMBER SI    
9 ORIGIN VARCHAR2(10) SI    
10 SOURCE_ID NUMBER SI    
11 CODE_COMBINATION_ID_RELATED NUMBER SI    
12 ATTRIBUTE_CATEGORY VARCHAR2(150) SI    
13 REPORTED_FLAG VARCHAR2(1) SI ‘Y’  
14 LINE_TYPE_LOOKUP_CODE VARCHAR2(50) SI    
15 TAX_TYPE VARCHAR2(50) SI    
16 TAX_NAME VARCHAR2(50) SI    
17 ACCOUNT_NUMBER_RELATED VARCHAR2(40) SI    
18 CATEGORY VARCHAR2(40) SI    
19 ACCOUNT_NUMBER VARCHAR2(40) SI    
20 THIRD_PARTY_REPORT VARCHAR2(30) SI    
21 REPORTED_VALUE_1 NUMBER NO    
22 REPORTED_VALUE_2 NUMBER SI    
23 REPORTED_VALUE_3 NUMBER SI    
24 REPORTED_VALUE_4 NUMBER SI    
25 REPORTED_VALUE_5 NUMBER SI    
26 REPORTED_VALUE_6 NUMBER SI    
27 REPORTED_VALUE_7 NUMBER SI    
28 REPORTED_VALUE_8 NUMBER SI    
29 REPORTED_VALUE_9 NUMBER SI    
30 REPORTED_VALUE_10 NUMBER SI    
31 REPORTED_VALUE_11 NUMBER SI    
32 REPORTED_VALUE_12 NUMBER SI    
33 REPORTED_VALUE_13 NUMBER SI    
34 REPORTED_VALUE_14 NUMBER SI    
35 REPORTED_VALUE_15 NUMBER SI    
36 REPORTED_VALUE_16 NUMBER SI    
37 REPORTED_VALUE_17 NUMBER SI    
38 REPORTED_VALUE_18 NUMBER SI    
39 REPORTED_VALUE_19 NUMBER SI    
40 REPORTED_VALUE_20 NUMBER SI    
41 CREATION_DATE DATE SI    
42 CREATED_BY VARCHAR2(64) SI    
43 LAST_UPDATE_DATE DATE SI    
44 LAST_UPDATED_BY VARCHAR2(64) SI    
45 LAST_UPDATE_LOGIN VARCHAR2(32) SI    

Restricciones

CHECK: SYS_C0014606

CHECK: SYS_C0014607

CHECK: SYS_C0014608

CHECK: SYS_C0014609

CHECK: SYS_C0014610

CHECK: SYS_C0014611

CHECK: SYS_C0014612

DDL

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

← Volver a tablas de LACLS

🏠 Volver al menú principal