Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
Base de datos origen: ADW COEXITO
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | DOCSEQCATDESCRIPTION | VARCHAR2(500) | SI | ||
| 2 | DOCSEQUENCENAME | VARCHAR2(50) | SI | ||
| 3 | INVDISTCOUNT | NUMBER | SI | ||
| 4 | INVDISTPOSTEDCOUNT | NUMBER | SI | ||
| 5 | INVOICEBATCHBATCHID | NUMBER | SI | ||
| 6 | INVOICEBATCHBATCHNAME | VARCHAR2(100) | SI | ||
| 7 | INVOICEHDRACCOUNTINGSTATUSCODE | VARCHAR2(50) | SI | ||
| 8 | INVOICEHDRVALIDATIONSTATUSCODE | VARCHAR2(50) | SI | ||
| 9 | INVOICEHEADERAPPROVALSTATUS | VARCHAR2(50) | SI | ||
| 10 | INVOICEHEADERCREATEDBY | VARCHAR2(100) | SI | ||
| 11 | INVOICEHEADERCREATIONDATE | DATE | SI | ||
| 12 | INVOICEHEADERDESCRIPTION | VARCHAR2(500) | SI | ||
| 13 | INVOICEHEADERDOCCATEGORYCODE | VARCHAR2(100) | SI | ||
| 14 | INVOICEHEADERDOCSEQUENCEVALUE | NUMBER | SI | ||
| 15 | INVOICEHEADEREXCLUSIVEPAYMENTFLAG | VARCHAR2(10) | SI | ||
| 16 | INVOICEHEADERGLDATE | DATE | SI | ||
| 17 | INVOICEHEADERINTERCOMPANYFLAG | VARCHAR2(10) | SI | ||
| 18 | INVOICEHEADERINVOICECURRENCYCODE | VARCHAR2(30) | SI | ||
| 19 | INVOICEHEADERINVOICEDATE | DATE | SI | ||
| 20 | INVOICEHEADERINVOICENUM | VARCHAR2(100) | SI | ||
| 21 | INVOICEHEADERINVOICETYPELOOKUPCODE | VARCHAR2(100) | SI | ||
| 22 | INVOICEHEADERLASTUPDATEDATE | DATE | SI | ||
| 23 | INVOICEHEADERLASTUPDATEDBY | VARCHAR2(100) | SI | ||
| 24 | INVOICEHEADERPAYGROUPLOOKUPCODE | VARCHAR2(50) | SI | ||
| 25 | INVOICEHEADERPAYMENTSTATUSFLAG | VARCHAR2(50) | SI | ||
| 26 | INVOICEHEADERROUTINGSTATUSLOOKUPCODE | VARCHAR2(50) | SI | ||
| 27 | INVOICEHEADERTAXATIONCOUNTRY | VARCHAR2(50) | SI | ||
| 28 | INVOICEHEADERTERMSDATE | DATE | SI | ||
| 29 | INVOICEID | NUMBER | NO | ||
| 30 | PARTYPARTYNAME | VARCHAR2(500) | SI | ||
| 31 | PERSONCREATEDBYDISPLAYNAME | VARCHAR2(500) | SI | ||
| 32 | INVOICEHEADERPARTYID | NUMBER | SI | ||
| 33 | INVOICEHEADERVENDORID | NUMBER | SI | ||
| 34 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
"INVOICEID" IS NOT NULL"IDMAESTROCARGUE" IS NOT NULL-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name