Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.FACT_HEADEREXTRACT_OM
Base de datos origen: ADW COEXITO
Descripción: Español: Tabla de hechos de cabeceras de órdenes. Contiene identificación de la orden, cliente, estado, versión, moneda, organizaciones, fechas y condiciones de envío, y permite analizar la evolución y características generales de las órdenes. English: Order header fact table. It contains order identification, customer, status, version, currency, organizations, dates, and shipping conditions and supports analysis of order evolution and general characteristics.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | HEADEREXTRACT_OM_ID | NUMBER | NO | “DWADW”.”ISEQ$$_378187”.nextval | |
| 2 | HEADERID | NUMBER(18,0) | NO | ||
| 3 | HEADERCANCELEDFLAG | VARCHAR2(1) | SI | ||
| 4 | HEADERCONVERSIONDATE | DATE | SI | ||
| 5 | HEADERCONVERSIONRATE | NUMBER | SI | ||
| 6 | HEADERCONVERSIONTYPECODE | VARCHAR2(30) | SI | ||
| 7 | HEADERCREATEDBY | VARCHAR2(64) | SI | ||
| 8 | HEADERCREATIONDATE | TIMESTAMP(6) | SI | ||
| 9 | HEADERCUSTOMERPONUMBER | VARCHAR2(50) | SI | ||
| 10 | HEADERISEDITABLE | VARCHAR2(1) | SI | ||
| 11 | HEADERLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 12 | HEADERLASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 13 | HEADERLASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 14 | HEADERLEGALENTITYID | NUMBER(18,0) | SI | ||
| 15 | HEADEROBJECTVERSIONNUMBER | NUMBER(9,0) | SI | ||
| 16 | HEADERONHOLD | VARCHAR2(1) | SI | ||
| 17 | HEADEROPENFLAG | VARCHAR2(1) | SI | ||
| 18 | HEADERORDERNUMBER | VARCHAR2(50) | SI | ||
| 19 | HEADERORDERTYPECODE | VARCHAR2(30) | SI | ||
| 20 | HEADERORDEREDDATE | TIMESTAMP(6) | SI | ||
| 21 | HEADERORGID | NUMBER(18,0) | SI | ||
| 22 | HEADERORIGSYSDOCUMENTREF | VARCHAR2(50) | SI | ||
| 23 | HEADEROWNERID | NUMBER(18,0) | SI | ||
| 24 | HEADERPARTIALSHIPALLOWEDFLAG | VARCHAR2(1) | SI | ||
| 25 | HEADERSOLDTOCONTACTID | NUMBER(18,0) | SI | ||
| 26 | HEADERSOLDTOCUSTOMERID | NUMBER(18,0) | SI | ||
| 27 | HEADERSOURCEDOCUMENTTYPECODE | VARCHAR2(50) | SI | ||
| 28 | HEADERSOURCEORDERID | VARCHAR2(50) | SI | ||
| 29 | HEADERSOURCEORDERNUMBER | VARCHAR2(50) | SI | ||
| 30 | HEADERSOURCEORDERSYSTEM | VARCHAR2(50) | SI | ||
| 31 | HEADERSOURCEORGID | NUMBER(18,0) | SI | ||
| 32 | HEADERSTATUSCODE | VARCHAR2(30) | SI | ||
| 33 | HEADERTRANSACTIONALCURRENCYCODE | VARCHAR2(15) | SI | ||
| 34 | HEADERSOLDTOPARTYID | NUMBER(18,0) | SI | ||
| 35 | HEADERSOLDTOPARTYCONTACTID | NUMBER(18,0) | SI | ||
| 36 | HEADERSUBMITTEDFLAG | VARCHAR2(1) | SI | ||
| 37 | HEADERAGREEMENTHEADERID | NUMBER(18,0) | SI | ||
| 38 | HEADERAGREEMENTVERSIONNUMBER | NUMBER(18,0) | SI | ||
| 39 | HEADERPAYMENTTERMID | NUMBER(18,0) | SI | ||
| 40 | HEADERSUBMITTEDDATE | TIMESTAMP(6) | SI | ||
| 41 | HEADERSUBMITTEDBY | VARCHAR2(64) | SI | ||
| 42 | HEADERSALESPERSONID | NUMBER(18,0) | SI | ||
| 43 | HEADERSALESCHANNELCODE | VARCHAR2(30) | SI | ||
| 44 | HEADERPAYMENTTERMIDDERIVED | NUMBER(18,0) | SI | ||
| 45 | HEADERCANCELREASONCODE | VARCHAR2(30) | SI | ||
| 46 | HEADERREQUESTCANCELDATE | TIMESTAMP(6) | SI | ||
| 47 | HEADERTRANSACTIONALCURRENCYCODEDERIVED | VARCHAR2(15) | SI | ||
| 48 | HEADERCONVERSIONTYPECODEDERIVED | VARCHAR2(30) | SI | ||
| 49 | HEADERCOMMENTS | VARCHAR2(2000) | SI | ||
| 50 | HEADERPRICEDON | TIMESTAMP(6) | SI | ||
| 51 | HEADERPRICINGSEGMENTCODE | VARCHAR2(30) | SI | ||
| 52 | HEADERPRICINGSEGMENTEXPLANATION | VARCHAR2(1000) | SI | ||
| 53 | HEADERPRICINGSTRATEGYEXPLANATION | VARCHAR2(1000) | SI | ||
| 54 | HEADERSEGMENTEXPLANATIONMSGNAME | VARCHAR2(30) | SI | ||
| 55 | HEADERSTRATEGYEXPLANATIONMSGNAME | VARCHAR2(30) | SI | ||
| 56 | HEADERPRICINGSTRATEGYID | NUMBER(18,0) | SI | ||
| 57 | HEADERFREEZEPRICEFLAG | VARCHAR2(1) | SI | ||
| 58 | HEADERFREEZESHIPPINGCHARGEFLAG | VARCHAR2(1) | SI | ||
| 59 | HEADERSOLDTOPARTYCONTACTPOINTID | NUMBER(18,0) | SI | ||
| 60 | HEADERFREEZETAXFLAG | VARCHAR2(1) | SI | ||
| 61 | HEADERPRECREDITCHECKEDFLAG | VARCHAR2(1) | SI | ||
| 62 | HEADERSOURCEREVISIONNUMBER | NUMBER(18,0) | SI | ||
| 63 | HEADERALLOWCURRENCYOVERRIDEFLAG | VARCHAR2(1) | SI | ||
| 64 | HEADERAPPLIEDCURRENCYCODE | VARCHAR2(15) | SI | ||
| 65 | HEADERSHIPSETFLAG | VARCHAR2(1) | SI | ||
| 66 | HEADERFULFILLORGID | NUMBER(18,0) | SI | ||
| 67 | HEADERSUPPLIERID | NUMBER(18,0) | SI | ||
| 68 | HEADERSUPPLIERSITEID | NUMBER(18,0) | SI | ||
| 69 | HEADERDEMANDCLASSCODE | VARCHAR2(30) | SI | ||
| 70 | HEADERSUBSTITUTEALLOWEDFLAG | VARCHAR2(1) | SI | ||
| 71 | HEADERFREIGHTTERMSCODE | VARCHAR2(30) | SI | ||
| 72 | HEADERFOBPOINTCODE | VARCHAR2(30) | SI | ||
| 73 | HEADERPACKINGINSTRUCTIONS | VARCHAR2(1000) | SI | ||
| 74 | HEADERSHIPPINGINSTRUCTIONS | VARCHAR2(1000) | SI | ||
| 75 | HEADERSHIPMENTPRIORITYCODE | VARCHAR2(30) | SI | ||
| 76 | HEADERREQUESTSHIPDATE | DATE | SI | ||
| 77 | HEADERLATESTACCEPTABLESHIPDATE | DATE | SI | ||
| 78 | HEADEREARLIESTACCEPTABLESHIPDATE | DATE | SI | ||
| 79 | HEADERCARRIERID | NUMBER(18,0) | SI | ||
| 80 | HEADERSHIPMODEOFTRANSPORT | VARCHAR2(30) | SI | ||
| 81 | HEADERSHIPCLASSOFSERVICE | VARCHAR2(30) | SI | ||
| 82 | HEADERREQUESTARRIVALDATE | DATE | SI | ||
| 83 | HEADERLATESTACCEPTARRIVALDATE | DATE | SI | ||
| 84 | HEADEREARLIESTACCEPTARRIVALDATE | DATE | SI | ||
| 85 | HEADERREVISIONSOURCEORDERSYSTEM | VARCHAR2(30) | SI | ||
| 86 | HEADERAPPROVALSEQUENCENUMBER | NUMBER(18,0) | SI | ||
| 87 | HEADERTRADECOMPLIANCERESULTCODE | VARCHAR2(30) | SI | ||
| 88 | HEADERCREATEDINRELEASE | VARCHAR2(15) | SI | ||
| 89 | HEADERCHANGEVERSIONNUMBER | NUMBER(18,0) | SI | ||
| 90 | HEADERINTERNALCOMMENTS | VARCHAR2(4000) | SI | ||
| 91 | HEADERREFERENCEHEADERID | NUMBER(18,0) | SI | ||
| 92 | HEADERMODIFIEDFLAG | VARCHAR2(1) | SI | ||
| 93 | HEADERBATCHID | NUMBER(18,0) | SI | ||
| 94 | HEADERCREATIONMODE | VARCHAR2(30) | SI | ||
| 95 | HEADERMDOFLAG | VARCHAR2(1) | SI | ||
| 96 | HEADERSUBINVENTORY | VARCHAR2(10) | SI | ||
| 97 | HEADERPRICINGDATE | TIMESTAMP(6) | SI | ||
| 98 | HEADERORDERREPRESENTATIVEUSERNAME | VARCHAR2(100) | SI | ||
| 99 | HEADERORDERREPRESENTATIVE | VARCHAR2(255) | SI | ||
| 100 | HEADERBILLINGSETFLAG | VARCHAR2(1) | SI | ||
| 101 | AUDIT_ID | NUMBER | NO | ||
| 102 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ | |
| 103 | DIM_CUSTOMER_AR_ID | NUMBER | SI |
Restricciones
CHECK: FACT_HEADEREXTRACT_OM_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00304945
- Estado: ENABLED
- Columnas: HEADEREXTRACT_OM_ID
- Condición:
"HEADEREXTRACT_OM_ID" IS NOT NULL
CHECK: SYS_C00304946
- Estado: ENABLED
- Columnas: HEADERID
- Condición:
"HEADERID" IS NOT NULL
CHECK: SYS_C00304947
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00304948
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: FACT_HEADEREXTRACT_OM_PK
- Estado: ENABLED
- Columnas: HEADEREXTRACT_OM_ID
FK: FACT_HEADEREXTRACT_OM_DIM_CUSTOMER_AR_FK
- Estado: ENABLED
- Columnas: DIM_CUSTOMER_AR_ID
- Referencia: DWADW.DIM_CUSTOMER_AR (constraint DIM_CUSTOMER_AR_PK)
UK: FACT_HEADEREXTRACT_OM_UN
- Estado: ENABLED
- Columnas: HEADERID
DDL
CREATE TABLE "DWADW"."FACT_HEADEREXTRACT_OM"
( "HEADEREXTRACT_OM_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"HEADERID" NUMBER(18,0) NOT NULL ENABLE,
"HEADERCANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERCONVERSIONDATE" DATE,
"HEADERCONVERSIONRATE" NUMBER,
"HEADERCONVERSIONTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"HEADERCREATIONDATE" TIMESTAMP (6),
"HEADERCUSTOMERPONUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADERISEDITABLE" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERLASTUPDATEDATE" TIMESTAMP (6),
"HEADERLASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP",
"HEADERLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"HEADERLEGALENTITYID" NUMBER(18,0),
"HEADEROBJECTVERSIONNUMBER" NUMBER(9,0),
"HEADERONHOLD" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADEROPENFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADERORDERTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERORDEREDDATE" TIMESTAMP (6),
"HEADERORGID" NUMBER(18,0),
"HEADERORIGSYSDOCUMENTREF" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADEROWNERID" NUMBER(18,0),
"HEADERPARTIALSHIPALLOWEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERSOLDTOCONTACTID" NUMBER(18,0),
"HEADERSOLDTOCUSTOMERID" NUMBER(18,0),
"HEADERSOURCEDOCUMENTTYPECODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADERSOURCEORDERID" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADERSOURCEORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADERSOURCEORDERSYSTEM" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"HEADERSOURCEORGID" NUMBER(18,0),
"HEADERSTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERTRANSACTIONALCURRENCYCODE" VARCHAR2(15) COLLATE "USING_NLS_COMP",
"HEADERSOLDTOPARTYID" NUMBER(18,0),
"HEADERSOLDTOPARTYCONTACTID" NUMBER(18,0),
"HEADERSUBMITTEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERAGREEMENTHEADERID" NUMBER(18,0),
"HEADERAGREEMENTVERSIONNUMBER" NUMBER(18,0),
"HEADERPAYMENTTERMID" NUMBER(18,0),
"HEADERSUBMITTEDDATE" TIMESTAMP (6),
"HEADERSUBMITTEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"HEADERSALESPERSONID" NUMBER(18,0),
"HEADERSALESCHANNELCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERPAYMENTTERMIDDERIVED" NUMBER(18,0),
"HEADERCANCELREASONCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERREQUESTCANCELDATE" TIMESTAMP (6),
"HEADERTRANSACTIONALCURRENCYCODEDERIVED" VARCHAR2(15) COLLATE "USING_NLS_COMP",
"HEADERCONVERSIONTYPECODEDERIVED" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERCOMMENTS" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"HEADERPRICEDON" TIMESTAMP (6),
"HEADERPRICINGSEGMENTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERPRICINGSEGMENTEXPLANATION" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"HEADERPRICINGSTRATEGYEXPLANATION" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"HEADERSEGMENTEXPLANATIONMSGNAME" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERSTRATEGYEXPLANATIONMSGNAME" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERPRICINGSTRATEGYID" NUMBER(18,0),
"HEADERFREEZEPRICEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERFREEZESHIPPINGCHARGEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERSOLDTOPARTYCONTACTPOINTID" NUMBER(18,0),
"HEADERFREEZETAXFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERPRECREDITCHECKEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERSOURCEREVISIONNUMBER" NUMBER(18,0),
"HEADERALLOWCURRENCYOVERRIDEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERAPPLIEDCURRENCYCODE" VARCHAR2(15) COLLATE "USING_NLS_COMP",
"HEADERSHIPSETFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERFULFILLORGID" NUMBER(18,0),
"HEADERSUPPLIERID" NUMBER(18,0),
"HEADERSUPPLIERSITEID" NUMBER(18,0),
"HEADERDEMANDCLASSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERSUBSTITUTEALLOWEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERFREIGHTTERMSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERFOBPOINTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERPACKINGINSTRUCTIONS" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"HEADERSHIPPINGINSTRUCTIONS" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"HEADERSHIPMENTPRIORITYCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERREQUESTSHIPDATE" DATE,
"HEADERLATESTACCEPTABLESHIPDATE" DATE,
"HEADEREARLIESTACCEPTABLESHIPDATE" DATE,
"HEADERCARRIERID" NUMBER(18,0),
"HEADERSHIPMODEOFTRANSPORT" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERSHIPCLASSOFSERVICE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERREQUESTARRIVALDATE" DATE,
"HEADERLATESTACCEPTARRIVALDATE" DATE,
"HEADEREARLIESTACCEPTARRIVALDATE" DATE,
"HEADERREVISIONSOURCEORDERSYSTEM" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERAPPROVALSEQUENCENUMBER" NUMBER(18,0),
"HEADERTRADECOMPLIANCERESULTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERCREATEDINRELEASE" VARCHAR2(15) COLLATE "USING_NLS_COMP",
"HEADERCHANGEVERSIONNUMBER" NUMBER(18,0),
"HEADERINTERNALCOMMENTS" VARCHAR2(4000) COLLATE "USING_NLS_COMP",
"HEADERREFERENCEHEADERID" NUMBER(18,0),
"HEADERMODIFIEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERBATCHID" NUMBER(18,0),
"HEADERCREATIONMODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"HEADERMDOFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"HEADERSUBINVENTORY" VARCHAR2(10) COLLATE "USING_NLS_COMP",
"HEADERPRICINGDATE" TIMESTAMP (6),
"HEADERORDERREPRESENTATIVEUSERNAME" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"HEADERORDERREPRESENTATIVE" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"HEADERBILLINGSETFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"AUDIT_ID" NUMBER NOT NULL ENABLE,
"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE,
"DIM_CUSTOMER_AR_ID" NUMBER,
CONSTRAINT "FACT_HEADEREXTRACT_OM_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "FACT_HEADEREXTRACT_OM_PK" PRIMARY KEY ("HEADEREXTRACT_OM_ID")
USING INDEX ENABLE,
CONSTRAINT "FACT_HEADEREXTRACT_OM_UN" UNIQUE ("HEADERID")
USING INDEX ENABLE,
CONSTRAINT "FACT_HEADEREXTRACT_OM_DIM_CUSTOMER_AR_FK" FOREIGN KEY ("DIM_CUSTOMER_AR_ID")
REFERENCES "DWADW"."DIM_CUSTOMER_AR" ("CUSTOMER_AR_ID") ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."FACT_HEADEREXTRACT_OM" IS 'Español: Tabla de hechos de cabeceras de órdenes. Contiene identificación de la orden, cliente, estado, versión, moneda, organizaciones, fechas y condiciones de envío, y permite analizar la evolución y características generales de las órdenes.
English: Order header fact table. It contains order identification, customer, status, version, currency, organizations, dates, and shipping conditions and supports analysis of order evolution and general characteristics.';
CREATE INDEX "DWADW"."HDR_TRACKING_OM_IDX" ON "DWADW"."FACT_HEADEREXTRACT_OM" ("HEADERORDERNUMBER", "HEADEROBJECTVERSIONNUMBER")
;
CREATE UNIQUE INDEX "DWADW"."FACT_HEADEREXTRACT_OM_PK" ON "DWADW"."FACT_HEADEREXTRACT_OM" ("HEADEREXTRACT_OM_ID")
;
CREATE UNIQUE INDEX "DWADW"."FACT_HEADEREXTRACT_OM_UN" ON "DWADW"."FACT_HEADEREXTRACT_OM" ("HEADERID")
;