Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.DW_SUPPLIER

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 START_DATE DATE SI    
2 PARTY_NAME VARCHAR2(2000) SI    
3 PARTY_NUMBER VARCHAR2(2000) SI    
4 COUNTRY_CODE VARCHAR2(50) SI    
5 CLASSIFICATION_CODE VARCHAR2(50) SI    
6 INV_DIST_AMOUNT NUMBER SI    
7 RELATION_SHIP VARCHAR2(50) SI    
8 CREATED_BY VARCHAR2(100) SI    
9 CREATION_DATE DATE SI    
10 CREATION_DATE_ONLY DATE SI    
11 CREATION_SOURCE VARCHAR2(100) SI    
12 REPORTABLE_FLAG VARCHAR2(2) SI    
13 INV_DIST_HIERARCHY_AMOUNT NUMBER SI    
14 DIST_VENDOR_ID NUMBER SI    
15 LAST_UPDATE DATE SI    
16 LAST_UPDATE_BY VARCHAR2(50) SI    
17 ORG_LOOKUP_CODE VARCHAR2(50) SI    
18 PARTY_ID NUMBER SI    
19 SUPPLIER_SEGMENT1 VARCHAR2(50) SI    
20 SUPPLIER_PAYER_COUNTRY VARCHAR2(10) SI    
21 SUPPLIER_LOOKUP_CODE VARCHAR2(50) SI    
22 VENDORID NUMBER NO    
23 FISCAL_CODE VARCHAR2(100) SI    
24 TAXPAYER_ID VARCHAR2(100) SI    

Restricciones

CHECK: SYS_C0024771

PK: SYS_C0024772

DDL

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

← Volver a tablas de DWADW

🏠 Volver al menú principal