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
Descripción: Español: Almacena la información de cabecera de las transacciones comerciales. Contiene la identificación de la transacción, unidad de negocio, cliente, número y fecha del documento, clase y estado de la transacción, moneda, condiciones y fecha de vencimiento, referencias comerciales, datos de facturación y envío, dirección de entrega y campos de auditoría. English: Stores commercial transaction header information. It contains the transaction identifier, business unit, customer, document number and date, transaction class and status, currency, payment terms and due date, commercial references, billing and shipping information, delivery address, and audit fields.
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" ;
COMMENT ON TABLE "STADW"."ST_TRANSACTIONHEADER_OM" IS 'Español: Almacena la información de cabecera de las transacciones comerciales. Contiene la identificación de la transacción, unidad de negocio, cliente, número y fecha del documento, clase y estado de la transacción, moneda, condiciones y fecha de vencimiento, referencias comerciales, datos de facturación y envío, dirección de entrega y campos de auditoría.
English: Stores commercial transaction header information. It contains the transaction identifier, business unit, customer, document number and date, transaction class and status, currency, payment terms and due date, commercial references, billing and shipping information, delivery address, and audit fields.';
CREATE INDEX "STADW"."ST_TRANSACTIONHEADER_OM_IDX" ON "STADW"."ST_TRANSACTIONHEADER_OM" ("CUSTOMERTRXID")
;