Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_TRANSACTIONHEADER_OM
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CUSTOMERTRXID | NUMBER(18,0) | NO | ||
| 2 | BUSINESSUNITNAME | VARCHAR2(240) | SI | ||
| 3 | TRANSACTIONBATCHSOURCENAME | VARCHAR2(50) | SI | ||
| 4 | CUSTACCTCUSTACCOUNTID | NUMBER(18,0) | SI | ||
| 5 | CUSTACCTACCOUNTNUMBER | VARCHAR2(30) | SI | ||
| 6 | TRANSACTIONHEADERTRXNUMBER | VARCHAR2(20) | SI | ||
| 7 | TRANSACTIONHEADERTRXDATE | DATE | SI | ||
| 8 | TRANSACTIONHEADERDOCSEQUENCEVALUE | NUMBER(18,0) | SI | ||
| 9 | TRANSACTIONHEADERTRXCLASS | VARCHAR2(20) | SI | ||
| 10 | TRXCLASSLOOKUPCODE | VARCHAR2(30) | SI | ||
| 11 | TRXCLASSMEANING | VARCHAR2(80) | SI | ||
| 12 | TRANSACTIONHEADERCUSTTRXTYPESEQID | NUMBER(18,0) | SI | ||
| 13 | TRANSACTIONHEADERCOMPLETEFLAG | VARCHAR2(1) | SI | ||
| 14 | TRANSACTIONHEADERSTATUSTRX | VARCHAR2(30) | SI | ||
| 15 | TRANSACTIONHEADERINVOICECURRENCYCODE | VARCHAR2(15) | SI | ||
| 16 | TRANSACTIONHEADERTERMID | NUMBER(18,0) | SI | ||
| 17 | TRANSACTIONHEADERTERMDUEDATE | DATE | SI | ||
| 18 | TRANSACTIONHEADERCUSTOMERREFERENCE | VARCHAR2(30) | SI | ||
| 19 | TRANSACTIONHEADERPURCHASEORDER | VARCHAR2(50) | SI | ||
| 20 | TRANSACTIONHEADERBILLTOSITEUSEID | NUMBER(18,0) | SI | ||
| 21 | SHIPTOPARTYSITEPARTYSITEID | NUMBER(18,0) | SI | ||
| 22 | SHIPTOADDRLOCATIONLOCATIONID | NUMBER(18,0) | SI | ||
| 23 | SHIPTOADDRLOCATIONADDRESS1 | VARCHAR2(240) | SI | ||
| 24 | SHIPTOADDRLOCATIONCITY | VARCHAR2(60) | SI | ||
| 25 | SHIPTOADDRLOCATIONSTATE | VARCHAR2(60) | SI | ||
| 26 | SHIPTOADDRLOCATIONCOUNTRY | VARCHAR2(2) | SI | ||
| 27 | SHIPTOADDRLOCATIONPOSTALCODE | VARCHAR2(60) | SI | ||
| 28 | TRANSACTIONHEADERCREATEDBY | VARCHAR2(64) | SI | ||
| 29 | TRANSACTIONHEADERCREATIONDATE | TIMESTAMP(6) | SI | ||
| 30 | TRANSACTIONHEADERLASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 31 | TRANSACTIONHEADERLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 32 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
Restricciones
CHECK: SYS_C00273355
- Estado: ENABLED
- Columnas: CUSTOMERTRXID
- Condición:
"CUSTOMERTRXID" IS NOT NULL
CHECK: SYS_C00273356
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_TRANSACTIONHEADER_OM"
( "CUSTOMERTRXID" NUMBER(18,0) NOT NULL ENABLE,
"BUSINESSUNITNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"TRANSACTIONBATCHSOURCENAME" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"CUSTACCTCUSTACCOUNTID" NUMBER(18,0),
"CUSTACCTACCOUNTNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERTRXNUMBER" VARCHAR2(20) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERTRXDATE" DATE,
"TRANSACTIONHEADERDOCSEQUENCEVALUE" NUMBER(18,0),
"TRANSACTIONHEADERTRXCLASS" VARCHAR2(20) COLLATE "USING_NLS_COMP",
"TRXCLASSLOOKUPCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"TRXCLASSMEANING" VARCHAR2(80) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERCUSTTRXTYPESEQID" NUMBER(18,0),
"TRANSACTIONHEADERCOMPLETEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERSTATUSTRX" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERINVOICECURRENCYCODE" VARCHAR2(15) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERTERMID" NUMBER(18,0),
"TRANSACTIONHEADERTERMDUEDATE" DATE,
"TRANSACTIONHEADERCUSTOMERREFERENCE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERPURCHASEORDER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERBILLTOSITEUSEID" NUMBER(18,0),
"SHIPTOPARTYSITEPARTYSITEID" NUMBER(18,0),
"SHIPTOADDRLOCATIONLOCATIONID" NUMBER(18,0),
"SHIPTOADDRLOCATIONADDRESS1" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"SHIPTOADDRLOCATIONCITY" VARCHAR2(60) COLLATE "USING_NLS_COMP",
"SHIPTOADDRLOCATIONSTATE" VARCHAR2(60) COLLATE "USING_NLS_COMP",
"SHIPTOADDRLOCATIONCOUNTRY" VARCHAR2(2) COLLATE "USING_NLS_COMP",
"SHIPTOADDRLOCATIONPOSTALCODE" VARCHAR2(60) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERCREATIONDATE" TIMESTAMP (6),
"TRANSACTIONHEADERLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"TRANSACTIONHEADERLASTUPDATEDATE" TIMESTAMP (6),
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;