Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

STADW.ST_TRXHEADER_AP_HIST

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 DOCSEQCATDESCRIPTION VARCHAR2(500) SI    
2 DOCSEQUENCENAME VARCHAR2(50) SI    
3 INVDISTCOUNT NUMBER SI    
4 INVDISTPOSTEDCOUNT NUMBER SI    
5 INVOICEBATCHBATCHID NUMBER SI    
6 INVOICEBATCHBATCHNAME VARCHAR2(100) SI    
7 INVOICEHDRACCOUNTINGSTATUSCODE VARCHAR2(50) SI    
8 INVOICEHDRVALIDATIONSTATUSCODE VARCHAR2(50) SI    
9 INVOICEHEADERAPPROVALSTATUS VARCHAR2(50) SI    
10 INVOICEHEADERCREATEDBY VARCHAR2(100) SI    
11 INVOICEHEADERCREATIONDATE DATE SI    
12 INVOICEHEADERDESCRIPTION VARCHAR2(500) SI    
13 INVOICEHEADERDOCCATEGORYCODE VARCHAR2(100) SI    
14 INVOICEHEADERDOCSEQUENCEVALUE NUMBER SI    
15 INVOICEHEADEREXCLUSIVEPAYMENTFLAG VARCHAR2(10) SI    
16 INVOICEHEADERGLDATE DATE SI    
17 INVOICEHEADERINTERCOMPANYFLAG VARCHAR2(10) SI    
18 INVOICEHEADERINVOICECURRENCYCODE VARCHAR2(30) SI    
19 INVOICEHEADERINVOICEDATE DATE SI    
20 INVOICEHEADERINVOICENUM VARCHAR2(100) SI    
21 INVOICEHEADERINVOICETYPELOOKUPCODE VARCHAR2(100) SI    
22 INVOICEHEADERLASTUPDATEDATE DATE SI    
23 INVOICEHEADERLASTUPDATEDBY VARCHAR2(100) SI    
24 INVOICEHEADERPAYGROUPLOOKUPCODE VARCHAR2(50) SI    
25 INVOICEHEADERPAYMENTSTATUSFLAG VARCHAR2(50) SI    
26 INVOICEHEADERROUTINGSTATUSLOOKUPCODE VARCHAR2(50) SI    
27 INVOICEHEADERTAXATIONCOUNTRY VARCHAR2(50) SI    
28 INVOICEHEADERTERMSDATE DATE SI    
29 INVOICEID NUMBER NO    
30 PARTYPARTYNAME VARCHAR2(500) SI    
31 PERSONCREATEDBYDISPLAYNAME VARCHAR2(500) SI    
32 INVOICEHEADERPARTYID NUMBER SI    
33 INVOICEHEADERVENDORID NUMBER SI    
34 IDMAESTROCARGUE NUMBER(18,0) NO    

Restricciones

CHECK: SYS_C00191161

CHECK: SYS_C00191162

DDL

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

← Volver a tablas de STADW

🏠 Volver al menú principal