Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

STADW.ST_ARLINES

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 TRXLINEID NUMBER NO    
2 LINECUSTOMERTRXID NUMBER NO    
3 SOLDTOCUSTACCOUNTID NUMBER NO    
4 SOLDTOCUSTACCTPARTYID NUMBER NO    
5 SOLDTOPARTYSITEPARTYSITEID NUMBER SI    
6 DESCRIPTION VARCHAR2(2000) SI    
7 GROSSUNITSELLINGPRICE NUMBER SI    
8 LINENUMBER NUMBER SI    
9 LINETYPE VARCHAR2(80) SI    
10 LINEPRODUCTTYPE VARCHAR2(80) SI    
11 QUANTITYCREDITED NUMBER SI    
12 QUANTITYINVOICED NUMBER SI    
13 QUANTITYORDERED NUMBER SI    
14 REVENUEAMOUNT NUMBER SI    
15 TRANSACTIONHEADERTRXDATE DATE SI    
16 SALESORDER VARCHAR2(30) SI    
17 SALESORDERDATE DATE SI    
18 SALESORDERLINE NUMBER SI    
19 UNITSTANDARDPRICE NUMBER SI    
20 LINEUOMCODE VARCHAR2(30) SI    
21 LINEINVENTORYITEMID NUMBER SI    
22 LINEWAREHOUSEID NUMBER SI    
23 CUSTTRXLINEGLDISTID NUMBER SI    
24 CODECOMBINATIONID NUMBER SI    
25 LINEEXCHANGERATE NUMBER SI    
26 LINEINVOICECURRENCYCODE VARCHAR2(30) SI    
27 LINEEXCHANGEDATE DATE SI    
28 LINEDISTRIBUTIONGLDATE DATE SI    
29 LINEDISTRIBUTIONORIGINALGLDATE DATE SI    
30 TRANSACTIONLINEDISTRIBUTIONACCTDAMOUNT NUMBER SI    

Restricciones

CHECK: SYS_C0024658

CHECK: SYS_C0024659

CHECK: SYS_C0024660

CHECK: SYS_C0024661

PK: SYS_C0024662

DDL

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

← Volver a tablas de STADW

🏠 Volver al menú principal