Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.DW_AP_TRXHEADER

Base de datos origen: ADW COEXITO

Columnas

# Columna Tipo Nulo Default Comentario
1 DESCRIPTION VARCHAR2(500) SI    
2 SEQUENCE_NAME VARCHAR2(50) SI    
3 INV_DIST_COUNT NUMBER SI    
4 POSTED_COUNTED NUMBER SI    
5 BATCH_ID NUMBER SI    
6 BATCH_NAME VARCHAR2(100) SI    
7 ACCOUNTING_STATUS_CODE VARCHAR2(50) SI    
8 VALIDATION_STATUS_CODE VARCHAR2(50) SI    
9 APPROVAL_STATUS VARCHAR2(50) SI    
10 CREATED_BY VARCHAR2(100) SI    
11 CREATION_DATE DATE SI    
12 INVOICE_DESCRIPTION VARCHAR2(500) SI    
13 CATEGORY_CODE VARCHAR2(100) SI    
14 SEQUENCE_VALUE NUMBER SI    
15 EXCLUSIVE_PAYMENT_FLAG VARCHAR2(10) SI    
16 GL_DATE DATE SI    
17 INTERCOMPANY_FLAG VARCHAR2(10) SI    
18 CURRENCY_CODE VARCHAR2(30) SI    
19 INVOICE_DATE DATE SI    
20 INVOICE_NUM VARCHAR2(100) SI    
21 TYPE_LOOKUP_CODE VARCHAR2(100) SI    
22 LAST_UPDATE_DATE DATE SI    
23 LAST_UPDATE_BY VARCHAR2(100) SI    
24 PAY_GROUP_LOOKUP_CODE VARCHAR2(50) SI    
25 PAYMENT_STATUS_FLAG VARCHAR2(50) SI    
26 ROUTING_STATUS_LOOKUP VARCHAR2(50) SI    
27 TAXATION_COUNTRY VARCHAR2(50) SI    
28 TERMS_DATE DATE SI    
29 INVOICEID NUMBER NO    
30 PARTY_NAME VARCHAR2(500) SI    
31 CREATED_BY_NAME VARCHAR2(500) SI    
32 PARTYID NUMBER SI    
33 VENDORID NUMBER SI    
34 FISCAL_CODE VARCHAR2(100) SI    

Restricciones

CHECK: SYS_C0024783

PK: SYS_C0024784

DDL

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

← Volver a tablas de DWADW

🏠 Volver al menú principal