Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.DW_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 LINE_DESCRIPTION VARCHAR2(2000) SI    
7 GROSS_UNIT_SELLING_PRICE NUMBER SI    
8 LINE_NUMBER NUMBER SI    
9 LINE_TYPE VARCHAR2(80) SI    
10 PRODUCT_TYPE VARCHAR2(80) SI    
11 QUANTITY_CREDITED NUMBER SI    
12 QUANTITY_INVOICED NUMBER SI    
13 QUANTITY_ORDERED NUMBER SI    
14 REVENUE_AMOUNT NUMBER SI    
15 TRX_NUMBER_DATE DATE SI    
16 SALES_ORDER VARCHAR2(30) SI    
17 SALES_ORDER_DATE DATE SI    
18 SALES_ORDER_LINE NUMBER SI    
19 UNIT_STANDARD_PRICE NUMBER SI    
20 UOM_CODE VARCHAR2(30) SI    
21 LINEINVENTORYITEMID NUMBER SI    
22 LINEWAREHOUSEID NUMBER SI    
23 CUSTTRXLINEGLDISTID NUMBER SI    
24 CODECOMBINATIONID NUMBER SI    
25 EXCHANGE_RATE NUMBER SI    
26 INVOICE_CURRENCY_CODE VARCHAR2(30) SI    
27 EXCHANGE_DATE DATE SI    
28 DISTRIBUTION_GL_DATE DATE SI    
29 DISTRIBUTION_ORIGINAL_GL_DATE DATE SI    
30 ACCOUNTED_AMOUNT NUMBER SI    

Restricciones

CHECK: SYS_C0024698

CHECK: SYS_C0024699

CHECK: SYS_C0024700

CHECK: SYS_C0024701

PK: SYS_C0024702

DDL

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

← Volver a tablas de DWADW

🏠 Volver al menú principal