Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

STADW.ST_CASHRECEIPT_GL_HIST

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 CASHRECEIPTID NUMBER NO    
2 CUSTACCTACCOUNTNAME VARCHAR2(500) SI    
3 CUSTACCTACCOUNTNUMBER VARCHAR2(500) SI    
4 CUSTACCTPARTYID NUMBER SI    
5 PARTYPARTYNAME VARCHAR2(500) SI    
6 PARTYPARTYNUMBER VARCHAR2(500) SI    
7 PAYMENTSCHEDULEAMOUNTAPPLIED NUMBER SI    
8 PAYMENTSCHEDULEAMOUNTDUEORIGINAL NUMBER SI    
9 PAYMENTSCHEDULEDUEDATE DATE SI    
10 PAYMENTSCHEDULELASTUPDATEDATE DATE SI    
11 RECEIPTACCOUNTEDAMOUNT NUMBER SI    
12 RECEIPTACTUALVALUEDATE DATE SI    
13 RECEIPTAMOUNT NUMBER SI    
14 RECEIPTBATCHBATCHID NUMBER SI    
15 RECEIPTBATCHNAME VARCHAR2(50) SI    
16 RECEIPTCOMMENTS VARCHAR2(2500) SI    
17 RECEIPTCONFIRMEDFLAG VARCHAR2(10) SI    
18 RECEIPTCREATEDBY VARCHAR2(100) SI    
19 RECEIPTCREATIONDATE DATE SI    
20 RECEIPTDEPOSITDATE DATE SI    
21 RECEIPTLASTUPDATEDATE DATE SI    
22 RECEIPTRECEIPTDATE DATE SI    
23 RECEIPTRECEIPTNUMBER VARCHAR2(100) SI    
24 IDMAESTROCARGUE NUMBER(18,0) NO    

Restricciones

CHECK: SYS_C00191173

CHECK: SYS_C00191174

DDL

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

← Volver a tablas de STADW

🏠 Volver al menú principal