Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

STADW.ST_ARLINES_AR_HIST

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    
31 IDMAESTROCARGUE NUMBER(18,0) NO    
32 TRANSACTIONLINELASTUPDATEDATE DATE SI    

Restricciones

CHECK: SYS_C00191080

CHECK: SYS_C00191081

CHECK: SYS_C00191082

CHECK: SYS_C00191083

CHECK: SYS_C00191084

DDL

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

← Volver a tablas de STADW

🏠 Volver al menú principal