Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.DW_CASHRECEIPT

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 RECEIPTID NUMBER NO    
2 ACCOUNT_NAME VARCHAR2(500) SI    
3 ACCOUNT_NUMBER VARCHAR2(500) SI    
4 PARTY_ID NUMBER SI    
5 PARTY_NAME VARCHAR2(500) SI    
6 PARTY_NUMBER VARCHAR2(500) SI    
7 SCHEDULE_AMOUNT_APPLIED NUMBER SI    
8 SCHEDULE_AMOUNT_ORIGINAL NUMBER SI    
9 SCHDULE_DUE_DATE DATE SI    
10 SCHEDULE_LAST_UPDATE DATE SI    
11 REC_ACCOUNTED_AMOUNT NUMBER SI    
12 REC_VALUE_DATE DATE SI    
13 RECEIPT_AMOUNT NUMBER SI    
14 REC_BATCH_ID NUMBER SI    
15 REC_BATCH_NAME VARCHAR2(50) SI    
16 REC_COMMENTS VARCHAR2(2500) SI    
17 REC_CONFIRMED_FLAG VARCHAR2(10) SI    
18 REC_CREATED_BY VARCHAR2(100) SI    
19 REC_CREATION_DATE DATE SI    
20 REC_DEPOSIT_DATE DATE SI    
21 REC_LAST_UPDATE DATE SI    
22 RECEIPT_DATE DATE SI    
23 RECEIPT_NUMBER VARCHAR2(100) SI    
24 FISCAL_CODE VARCHAR2(100) SI    

Restricciones

CHECK: SYS_C0024878

PK: SYS_C0024879

DDL

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

← Volver a tablas de DWADW

🏠 Volver al menú principal