DWADW.FACT_ORDERRELEASELINES_OTM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de líneas de order release para análisis detallado de productos y valores. | English: Fact table of order release lines for detailed product and value analysis.

Columnas

#	Columna	Tipo	Nulo	Default
1	ORDERRELEASELINES_OTM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_220889”.nextval
2	ORDER_RELEASE_LINE_GID	VARCHAR2(404)	NO
3	ORDER_RELEASE_LINE_XID	VARCHAR2(200)	NO
4	ORDER_RELEASE_GID	VARCHAR2(404)	NO
5	WEIGHT	NUMBER	SI
6	WEIGHT_UOM_CODE	VARCHAR2(256)	SI
7	WEIGHT_BASE	NUMBER	SI
8	VOLUME	NUMBER	SI
9	VOLUME_UOM_CODE	VARCHAR2(256)	SI
10	VOLUME_BASE	NUMBER	SI
11	DECLARED_VALUE	NUMBER	NO
12	DECLARED_VALUE_BASE	NUMBER	NO
13	DECLARED_VALUE_CURRENCY_GID	VARCHAR2(404)	NO
14	INITIAL_ITEM_GID	VARCHAR2(404)	SI
15	ITEM_PACKAGE_COUNT	NUMBER	NO
16	PACKAGED_ITEM_GID	VARCHAR2(404)	NO
17	FREE_ALONG_SIDE	NUMBER	NO
18	FREE_ALONG_SIDE_BASE	NUMBER	NO
19	FREE_ALONG_SIDE_CURRENCY_GID	VARCHAR2(404)	NO
20	HAZ_NET_EXPLOSV_CONTENT_WEIGHT	NUMBER	NO
21	HAZ_NET_EXPL_CNTNT_WT_UOM_CODE	VARCHAR2(256)	NO
22	HAZ_NET_EXPL_CONTENT_WT_BASE	NUMBER	NO
23	HAZ_IS_LIMITED_QUANTITY	VARCHAR2(4)	NO
24	HAZ_IS_REPORTABLE_QUANTITY	VARCHAR2(4)	NO
25	HAZ_IS_TOXIC_INHALATION	VARCHAR2(4)	SI
26	HAZ_IS_PASSENGER_AIRCRAFT_FORB	VARCHAR2(4)	SI
27	HAZ_IS_COMMERCIAL_AIRCRAFT_FOR	VARCHAR2(4)	SI
28	HAZ_IS_OIL_CONTAINED	VARCHAR2(4)	NO
29	IS_DRAWBACK	VARCHAR2(4)	NO
30	BILLED_QUANTITY	NUMBER	NO
31	PRICE_PER_UNIT	NUMBER	NO
32	PRICE_PER_UNIT_BASE	NUMBER	NO
33	PRICE_PER_UNIT_CURRENCY_GID	VARCHAR2(404)	SI
34	TOTAL_BILLED_AMT	NUMBER	NO
35	TOTAL_BILLED_AMT_BASE	NUMBER	NO
36	TOTAL_BILLED_AMT_CURRENCY_GID	VARCHAR2(404)	NO
37	HAZ_IS_NOS	VARCHAR2(4)	SI
38	HAZ_IS_MARINE_POLLUTANT	VARCHAR2(4)	SI
39	HAZ_ALL_PACKED	VARCHAR2(4)	SI
40	HAZ_IS_OVERPACK	VARCHAR2(4)	SI
41	HAZ_PACKING_COUNT	NUMBER	NO
42	IS_SPLIT_ALLOWED	VARCHAR2(4)	NO
43	DOMAIN_NAME	VARCHAR2(200)	NO
44	RN	NUMBER	SI
45	FACT_PACKAGEDITEM_OTM_ID	NUMBER	SI
46	FACT_ORDERRELEASE_OTM_ID	NUMBER	SI
47	INSERT_USER	VARCHAR2(512)	NO
48	INSERT_DATE	DATE	NO
49	UPDATE_USER	VARCHAR2(512)	SI
50	UPDATE_DATE	DATE	SI
51	AUDIT_ID	NUMBER	NO
52	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: FACT_ORDERRELEASELINES_OTM_ROW_ACTIVE_CK

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

CHECK: SYS_C0045050

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

CHECK: SYS_C0045051

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

CHECK: SYS_C0045052

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

CHECK: SYS_C0045053

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

CHECK: SYS_C0045054

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

CHECK: SYS_C0045055

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

CHECK: SYS_C0045056

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

CHECK: SYS_C0045057

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

CHECK: SYS_C0045058

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

CHECK: SYS_C0045059

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

CHECK: SYS_C0045060

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

CHECK: SYS_C0045061

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

CHECK: SYS_C0045062

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

CHECK: SYS_C0045063

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

CHECK: SYS_C0045064

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

CHECK: SYS_C0045065

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

CHECK: SYS_C0045066

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

CHECK: SYS_C0045067

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

CHECK: SYS_C0045068

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

CHECK: SYS_C0045069

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

CHECK: SYS_C0045070

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

CHECK: SYS_C0045071

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

CHECK: SYS_C0045072

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

CHECK: SYS_C0045073

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

CHECK: SYS_C0045074

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

CHECK: SYS_C0045075

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

CHECK: SYS_C0045076

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

CHECK: SYS_C0045077

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

CHECK: SYS_C0045080

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

CHECK: SYS_C0045081

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

CHECK: SYS_C0085817

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

CHECK: SYS_C0085892

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

PK: FACT_ORDERRELEASELINES_OTM_PK

Estado: ENABLED
Columnas: ORDERRELEASELINES_OTM_ID

FK: FACT_ORDERRELEASELINES_OTM_FACT_ORDERRELEASE_OTM_FK

Estado: ENABLED
Columnas: FACT_ORDERRELEASE_OTM_ID
Referencia: DWADW.FACT_ORDERRELEASE_OTM (constraint FACT_ORDERRELEASE_OTM_PK)

FK: FACT_ORLINES_PITEM_OTM_FK

Estado: ENABLED
Columnas: FACT_PACKAGEDITEM_OTM_ID
Referencia: DWADW.FACT_PACKAGEDITEM_OTM (constraint DIM_PACKAGEDITEM_OTM_PK)

UK: FACT_ORDERRELEASELINES_OTM_UN

Estado: ENABLED
Columnas: ORDER_RELEASE_LINE_GID

DDL

CREATE TABLE "DWADW"."FACT_ORDERRELEASELINES_OTM" 
   (	"ORDERRELEASELINES_OTM_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, 
	"ORDER_RELEASE_LINE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDER_RELEASE_LINE_XID" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDER_RELEASE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"WEIGHT" NUMBER, 
	"WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"WEIGHT_BASE" NUMBER, 
	"VOLUME" NUMBER, 
	"VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"VOLUME_BASE" NUMBER, 
	"DECLARED_VALUE" NUMBER NOT NULL ENABLE, 
	"DECLARED_VALUE_BASE" NUMBER NOT NULL ENABLE, 
	"DECLARED_VALUE_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INITIAL_ITEM_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"ITEM_PACKAGE_COUNT" NUMBER NOT NULL ENABLE, 
	"PACKAGED_ITEM_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FREE_ALONG_SIDE" NUMBER NOT NULL ENABLE, 
	"FREE_ALONG_SIDE_BASE" NUMBER NOT NULL ENABLE, 
	"FREE_ALONG_SIDE_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HAZ_NET_EXPLOSV_CONTENT_WEIGHT" NUMBER NOT NULL ENABLE, 
	"HAZ_NET_EXPL_CNTNT_WT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HAZ_NET_EXPL_CONTENT_WT_BASE" NUMBER NOT NULL ENABLE, 
	"HAZ_IS_LIMITED_QUANTITY" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HAZ_IS_REPORTABLE_QUANTITY" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HAZ_IS_TOXIC_INHALATION" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_IS_PASSENGER_AIRCRAFT_FORB" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_IS_COMMERCIAL_AIRCRAFT_FOR" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_IS_OIL_CONTAINED" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_DRAWBACK" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"BILLED_QUANTITY" NUMBER NOT NULL ENABLE, 
	"PRICE_PER_UNIT" NUMBER NOT NULL ENABLE, 
	"PRICE_PER_UNIT_BASE" NUMBER NOT NULL ENABLE, 
	"PRICE_PER_UNIT_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"TOTAL_BILLED_AMT" NUMBER NOT NULL ENABLE, 
	"TOTAL_BILLED_AMT_BASE" NUMBER NOT NULL ENABLE, 
	"TOTAL_BILLED_AMT_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HAZ_IS_NOS" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_IS_MARINE_POLLUTANT" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_ALL_PACKED" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_IS_OVERPACK" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"HAZ_PACKING_COUNT" NUMBER NOT NULL ENABLE, 
	"IS_SPLIT_ALLOWED" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DOMAIN_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"RN" NUMBER, 
	"FACT_PACKAGEDITEM_OTM_ID" NUMBER, 
	"FACT_ORDERRELEASE_OTM_ID" NUMBER, 
	"INSERT_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSERT_DATE" DATE NOT NULL ENABLE, 
	"UPDATE_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP", 
	"UPDATE_DATE" DATE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASELINES_OTM_PK" PRIMARY KEY ("ORDERRELEASELINES_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASELINES_OTM_UN" UNIQUE ("ORDER_RELEASE_LINE_GID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASELINES_OTM_ROW_ACTIVE_CK" CHECK (ROW_ACTIVE IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASELINES_OTM_FACT_ORDERRELEASE_OTM_FK" FOREIGN KEY ("FACT_ORDERRELEASE_OTM_ID")
	  REFERENCES "DWADW"."FACT_ORDERRELEASE_OTM" ("ORDERRELEASE_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_ORLINES_PITEM_OTM_FK" FOREIGN KEY ("FACT_PACKAGEDITEM_OTM_ID")
	  REFERENCES "DWADW"."FACT_PACKAGEDITEM_OTM" ("PACKAGEDITEM_OTM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_ORDERRELEASELINES_OTM"  IS 'Español: Tabla de hechos de líneas de order release para análisis detallado de productos y valores. | English: Fact table of order release lines for detailed product and value analysis.';

CREATE UNIQUE INDEX "DWADW"."FACT_ORDERRELEASELINES_OTM_PK" ON "DWADW"."FACT_ORDERRELEASELINES_OTM" ("ORDERRELEASELINES_OTM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_ORDERRELEASELINES_OTM_UN" ON "DWADW"."FACT_ORDERRELEASELINES_OTM" ("ORDER_RELEASE_LINE_GID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal