Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

STADW.ST_ARTRXHEADER

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 CUSTOMERTRXID NUMBER NO    
2 TRANSACTIONHEADERTRXNUMBER NUMBER SI    
3 DOCSEQHDRNAME VARCHAR2(500) SI    
4 TRANSACTIONBATCHSOURCENAME VARCHAR2(200) SI    
5 TRANSACTIONHEADERTRXCLASS VARCHAR2(10) SI    
6 CUSTACCTACCOUNTNUMBER VARCHAR2(500) SI    
7 TRANSACTIONHEADERCOMMENTS VARCHAR2(1000) SI    
8 TRANSACTIONHEADERCOMPLETEFLAG VARCHAR2(10) SI    
9 TRANSACTIONHEADERCTREFERENCE VARCHAR2(200) SI    
10 TRANSACTIONHEADERCUSTTRXTYPESEQID NUMBER SI    
11 TRANSACTIONHEADERSTATUSTRX VARCHAR2(10) SI    
12 TRANSACTIONHEADERTERMDUEDATE DATE SI    
13 TRANSACTIONHEADERTRXDATE DATE SI    
14 TRANSACTIONHEADERTERMID NUMBER SI    
15 TRANSACTIONHEADEREXCHANGEDATE DATE SI    
16 TRANSACTIONHEADERINTERFACEHEADERCONTEXT VARCHAR2(100) SI    
17 TRANSACTIONHEADERINVOICECURRENCYCODE VARCHAR2(10) SI    
18 TRANSACTIONHEADERPRINTINGPENDING VARCHAR2(10) SI    
19 TRANSACTIONHEADERREASONCODE VARCHAR2(10) SI    
20 CUSTACCTCUSTACCOUNTID NUMBER SI    
21 CUSTACCTPARTYID NUMBER SI    
22 SHIPTOADDRLOCATIONLOCATIONID NUMBER SI    
23 SHIPTOPARTYSITEPARTYSITEID NUMBER SI    
24 TRANSACTIONHEADERSHIPTOCONTACTID NUMBER SI    
25 TRANSACTIONHEADERBILLTOCONTACTID NUMBER SI    
26 TRANSACTIONHEADERBILLTOSITEUSEID NUMBER SI    
27 TRANSACTIONHEADERPRIMARYRESOURCESALESREPID NUMBER SI    

Restricciones

CHECK: SYS_C0024721

PK: ST_ARTRXHEADER_PK

DDL

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

← Volver a tablas de STADW

🏠 Volver al menú principal