DWADW.FACT_LINEEXTRACT_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de líneas de órdenes. Contiene artículos, cantidades, precios, estados, organizaciones, fechas y referencias de cada línea, y permite analizar el detalle comercial y operativo de las órdenes. English: Order line fact table. It contains items, quantities, prices, statuses, organizations, dates, and references for each line and supports detailed commercial and operational analysis of orders.

Columnas

#	Columna	Tipo	Nulo	Default
1	LINEEXTRACT_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378191”.nextval
2	LINEID	NUMBER(18,0)	NO
3	LINEACTUALSHIPDATE	DATE	SI
4	LINECANCELEDFLAG	VARCHAR2(1)	SI
5	LINECANCELEDQTY	NUMBER	SI
6	LINECATEGORYCODE	VARCHAR2(30)	SI
7	LINECOMPSEQPATH	VARCHAR2(4000)	SI
8	LINECREATEDBY	VARCHAR2(64)	SI
9	LINECREATIONDATE	TIMESTAMP(6)	SI
10	LINEDELTATYPE	NUMBER(18,0)	SI
11	LINEEXTENDEDAMOUNT	NUMBER	SI
12	LINEFULFILLEDQTY	NUMBER	SI
13	LINEFULFILLMENTDATE	DATE	SI
14	LINEHEADERID	NUMBER(18,0)	SI
15	LINEINVENTORYITEMID	NUMBER(18,0)	SI
16	LINEINVENTORYORGANIZATIONID	NUMBER(18,0)	SI
17	LINEITEMTYPECODE	VARCHAR2(30)	SI
18	LINELASTUPDATEDATE	TIMESTAMP(6)	SI
19	LINELASTUPDATELOGIN	VARCHAR2(32)	SI
20	LINELASTUPDATEDBY	VARCHAR2(64)	SI
21	LINELINENUMBER	NUMBER(9,0)	SI
22	LINELINETYPECODE	VARCHAR2(30)	SI
23	LINEOBJECTVERSIONNUMBER	NUMBER(9,0)	SI
24	LINEONHOLD	VARCHAR2(1)	SI
25	LINEOPENFLAG	VARCHAR2(1)	SI
26	LINEORDEREDQTY	NUMBER	SI
27	LINEORGID	NUMBER(18,0)	SI
28	LINEORDEREDUOM	VARCHAR2(3)	SI
29	LINEORIGSYSDOCUMENTLINEREF	VARCHAR2(50)	SI
30	LINEORIGSYSDOCUMENTREF	VARCHAR2(50)	SI
31	LINEOWNERID	NUMBER(18,0)	SI
32	LINEPARENTLINEID	NUMBER(18,0)	SI
33	LINEREFERENCELINEID	NUMBER(18,0)	SI
34	LINERMADELIVEREDQTY	NUMBER	SI
35	LINEROOTPARENTLINEID	NUMBER(18,0)	SI
36	LINESCHEDULESHIPDATE	DATE	SI
37	LINESHIPPEDQTY	NUMBER	SI
38	LINESOURCELINEID	VARCHAR2(50)	SI
39	LINESOURCELINENUMBER	VARCHAR2(50)	SI
40	LINESOURCEORDERID	VARCHAR2(50)	SI
41	LINESOURCEORDERNUMBER	VARCHAR2(50)	SI
42	LINESOURCEORDERSYSTEM	VARCHAR2(30)	SI
43	LINESOURCEORGID	NUMBER(18,0)	SI
44	LINESOURCESCHEDULEID	VARCHAR2(50)	SI
45	LINESOURCESCHEDULENUMBER	VARCHAR2(50)	SI
46	LINESTATUSCODE	VARCHAR2(30)	SI
47	LINETRANSFORMFROMLINEID	NUMBER(18,0)	SI
48	LINEUNITLISTPRICE	NUMBER	SI
49	LINEUNITSELLINGPRICE	NUMBER	SI
50	LINEDISPLAYLINENUMBER	VARCHAR2(100)	SI
51	AUDIT_ID	NUMBER	NO
52	ROW_ACTIVE	CHAR(1)	NO	‘A’
53	FACT_HEADEREXTRACT_OM_ID	NUMBER	SI
54	DIM_HEADER_OM_ID	NUMBER	SI
55	DIM_ITEMS_OM_ID	NUMBER	SI

Restricciones

CHECK: FACT_LINEEXTRACT_OM_CK

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: row_active IN ('A','I')

CHECK: SYS_C00304952

Estado: ENABLED
Columnas: LINEEXTRACT_OM_ID
Condición: "LINEEXTRACT_OM_ID" IS NOT NULL

CHECK: SYS_C00304953

Estado: ENABLED
Columnas: LINEID
Condición: "LINEID" IS NOT NULL

CHECK: SYS_C00304954

Estado: ENABLED
Columnas: AUDIT_ID
Condición: "AUDIT_ID" IS NOT NULL

CHECK: SYS_C00304955

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: "ROW_ACTIVE" IS NOT NULL

PK: FACT_LINEEXTRACT_OM_PK

Estado: ENABLED
Columnas: LINEEXTRACT_OM_ID

FK: FACT_LINEEXTRACT_OM_DIM_HEADER_OM_FK

Estado: ENABLED
Columnas: DIM_HEADER_OM_ID
Referencia: DWADW.DIM_HEADER_OM (constraint DIM_HEADER_OM_PK)

FK: FACT_LINEEXTRACT_OM_DIM_ITEMS_OM_FK

Estado: ENABLED
Columnas: DIM_ITEMS_OM_ID
Referencia: DWADW.DIM_ITEMS_OM (constraint DIM_ITEMS_PIM_PK)

FK: FACT_LINEEXTRACT_OM_FACT_HEADEREXTRACT_OM_FK

Estado: ENABLED
Columnas: FACT_HEADEREXTRACT_OM_ID
Referencia: DWADW.FACT_HEADEREXTRACT_OM (constraint FACT_HEADEREXTRACT_OM_PK)

UK: FACT_LINEEXTRACT_OM__UN

Estado: ENABLED
Columnas: LINEID

DDL

CREATE TABLE "DWADW"."FACT_LINEEXTRACT_OM" 
   (	"LINEEXTRACT_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, 
	"LINEID" NUMBER(18,0) NOT NULL ENABLE, 
	"LINEACTUALSHIPDATE" DATE, 
	"LINECANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"LINECANCELEDQTY" NUMBER, 
	"LINECATEGORYCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINECOMPSEQPATH" VARCHAR2(4000) COLLATE "USING_NLS_COMP", 
	"LINECREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"LINECREATIONDATE" TIMESTAMP (6), 
	"LINEDELTATYPE" NUMBER(18,0), 
	"LINEEXTENDEDAMOUNT" NUMBER, 
	"LINEFULFILLEDQTY" NUMBER, 
	"LINEFULFILLMENTDATE" DATE, 
	"LINEHEADERID" NUMBER(18,0), 
	"LINEINVENTORYITEMID" NUMBER(18,0), 
	"LINEINVENTORYORGANIZATIONID" NUMBER(18,0), 
	"LINEITEMTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINELASTUPDATEDATE" TIMESTAMP (6), 
	"LINELASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP", 
	"LINELASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"LINELINENUMBER" NUMBER(9,0), 
	"LINELINETYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINEOBJECTVERSIONNUMBER" NUMBER(9,0), 
	"LINEONHOLD" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"LINEOPENFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"LINEORDEREDQTY" NUMBER, 
	"LINEORGID" NUMBER(18,0), 
	"LINEORDEREDUOM" VARCHAR2(3) COLLATE "USING_NLS_COMP", 
	"LINEORIGSYSDOCUMENTLINEREF" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINEORIGSYSDOCUMENTREF" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINEOWNERID" NUMBER(18,0), 
	"LINEPARENTLINEID" NUMBER(18,0), 
	"LINEREFERENCELINEID" NUMBER(18,0), 
	"LINERMADELIVEREDQTY" NUMBER, 
	"LINEROOTPARENTLINEID" NUMBER(18,0), 
	"LINESCHEDULESHIPDATE" DATE, 
	"LINESHIPPEDQTY" NUMBER, 
	"LINESOURCELINEID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCELINENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCEORDERID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCEORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCEORDERSYSTEM" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINESOURCEORGID" NUMBER(18,0), 
	"LINESOURCESCHEDULEID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCESCHEDULENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINETRANSFORMFROMLINEID" NUMBER(18,0), 
	"LINEUNITLISTPRICE" NUMBER, 
	"LINEUNITSELLINGPRICE" NUMBER, 
	"LINEDISPLAYLINENUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"FACT_HEADEREXTRACT_OM_ID" NUMBER, 
	"DIM_HEADER_OM_ID" NUMBER, 
	"DIM_ITEMS_OM_ID" NUMBER, 
	 CONSTRAINT "FACT_LINEEXTRACT_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_LINEEXTRACT_OM_PK" PRIMARY KEY ("LINEEXTRACT_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_LINEEXTRACT_OM__UN" UNIQUE ("LINEID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_LINEEXTRACT_OM_DIM_HEADER_OM_FK" FOREIGN KEY ("DIM_HEADER_OM_ID")
	  REFERENCES "DWADW"."DIM_HEADER_OM" ("HEADER_OM_ID") ENABLE, 
	 CONSTRAINT "FACT_LINEEXTRACT_OM_FACT_HEADEREXTRACT_OM_FK" FOREIGN KEY ("FACT_HEADEREXTRACT_OM_ID")
	  REFERENCES "DWADW"."FACT_HEADEREXTRACT_OM" ("HEADEREXTRACT_OM_ID") ENABLE, 
	 CONSTRAINT "FACT_LINEEXTRACT_OM_DIM_ITEMS_OM_FK" FOREIGN KEY ("DIM_ITEMS_OM_ID")
	  REFERENCES "DWADW"."DIM_ITEMS_OM" ("ITEMS_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_LINEEXTRACT_OM"  IS 'Español: Tabla de hechos de líneas de órdenes. Contiene artículos, cantidades, precios, estados, organizaciones, fechas y referencias de cada línea, y permite analizar el detalle comercial y operativo de las órdenes.
English: Order line fact table. It contains items, quantities, prices, statuses, organizations, dates, and references for each line and supports detailed commercial and operational analysis of orders.';

CREATE INDEX "DWADW"."IDX_LINE_TRACKING_OM" ON "DWADW"."FACT_LINEEXTRACT_OM" ("LINEHEADERID", "LINEID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_LINEEXTRACT_OM_PK" ON "DWADW"."FACT_LINEEXTRACT_OM" ("LINEEXTRACT_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_LINEEXTRACT_OM__UN" ON "DWADW"."FACT_LINEEXTRACT_OM" ("LINEID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal