Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.FACT_SSHIPMENTUNITLINE_OTM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de líneas de unidades de embarque con métricas físicas y relación a order releases. | English: Shipment unit line fact table with physical metrics linked to order releases.

Columnas

# Columna Tipo Nulo Default Comentario
1 SSHIPMENTUNITLINE_OTM_ID NUMBER NO “DWADW”.”ISEQ$$_220929”.nextval  
2 S_SHIP_UNIT_GID VARCHAR2(404) NO    
3 S_SHIP_UNIT_LINE_NO NUMBER NO    
4 WEIGHT NUMBER SI    
5 WEIGHT_UOM_CODE VARCHAR2(256) SI    
6 WEIGHT_BASE NUMBER SI    
7 VOLUME NUMBER SI    
8 VOLUME_UOM_CODE VARCHAR2(256) SI    
9 VOLUME_BASE NUMBER SI    
10 OR_LINE_GID VARCHAR2(404) SI    
11 ORDER_RELEASE_GID VARCHAR2(404) SI    
12 PACKAGING_UNIT_COUNT NUMBER SI    
13 ITEM_PACKAGE_COUNT NUMBER SI    
14 DECLARED_VALUE NUMBER SI    
15 DECLARED_VALUE_BASE NUMBER SI    
16 DECLARED_VALUE_CURRENCY_GID VARCHAR2(404) SI    
17 PACKAGED_ITEM_GID VARCHAR2(404) NO    
18 RECEIVED_ITEM_PACKAGE_COUNT NUMBER SI    
19 SHIP_UNIT_GID VARCHAR2(404) SI    
20 SHIP_UNIT_LINE_NO NUMBER SI    
21 COUNT_PER_SHIP_UNIT NUMBER SI    
22 DOMAIN_NAME VARCHAR2(200) NO    
23 RN NUMBER SI    
24 FACT_ORDERRELEASELINES_OTM_ID NUMBER SI    
25 DIM_PACKAGEDITEM_OTM_ID NUMBER NO    
26 INSERT_USER VARCHAR2(512) NO    
27 INSERT_DATE DATE NO    
28 UPDATE_USER VARCHAR2(512) SI    
29 UPDATE_DATE DATE SI    
30 DIM_SHIPUNIT_OTM_ID NUMBER SI    
31 FACT_ORDERRELEASE_OTM_ID NUMBER SI    
32 AUDIT_ID NUMBER NO    
33 ROW_ACTIVE CHAR(1) NO ‘A’  

Restricciones

CHECK: FACT_SSHIPMENTUNITLINE_OTM_ROW_ACTIVE_CK

CHECK: SYS_C0045237

CHECK: SYS_C0045238

CHECK: SYS_C0045239

CHECK: SYS_C0045240

CHECK: SYS_C0045241

CHECK: SYS_C0045243

CHECK: SYS_C0045244

CHECK: SYS_C0045245

CHECK: SYS_C0085823

CHECK: SYS_C0085904

PK: FACT_SSHIPMENTUNITLINE_OTM_PK

FK: FACT_SSHIPMENTUNITLINE_OTM_DIM_SHIPUNIT_OTM_FK

FK: FACT_SSHIPMENTUNITLINE_OTM_FACT_ORDERRELEASELINES_OTM_FK

FK: FACT_SSHIPMENTUNITLINE_OTM_FACT_ORDERRELEASE_OTM_FK

FK: FACT_SSHIPUL_PI_OTM_FK

UK: FACT_SSHIPMENTUNITLINE_OTM_UN

DDL

CREATE TABLE "DWADW"."FACT_SSHIPMENTUNITLINE_OTM" 
   (	"SSHIPMENTUNITLINE_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, 
	"S_SHIP_UNIT_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"S_SHIP_UNIT_LINE_NO" NUMBER 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, 
	"OR_LINE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"ORDER_RELEASE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"PACKAGING_UNIT_COUNT" NUMBER, 
	"ITEM_PACKAGE_COUNT" NUMBER, 
	"DECLARED_VALUE" NUMBER, 
	"DECLARED_VALUE_BASE" NUMBER, 
	"DECLARED_VALUE_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"PACKAGED_ITEM_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"RECEIVED_ITEM_PACKAGE_COUNT" NUMBER, 
	"SHIP_UNIT_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_LINE_NO" NUMBER, 
	"COUNT_PER_SHIP_UNIT" NUMBER, 
	"DOMAIN_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"RN" NUMBER, 
	"FACT_ORDERRELEASELINES_OTM_ID" NUMBER, 
	"DIM_PACKAGEDITEM_OTM_ID" NUMBER NOT NULL ENABLE, 
	"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, 
	"DIM_SHIPUNIT_OTM_ID" NUMBER, 
	"FACT_ORDERRELEASE_OTM_ID" NUMBER, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "FACT_SSHIPMENTUNITLINE_OTM_PK" PRIMARY KEY ("SSHIPMENTUNITLINE_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_SSHIPMENTUNITLINE_OTM_UN" UNIQUE ("S_SHIP_UNIT_GID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_SSHIPMENTUNITLINE_OTM_ROW_ACTIVE_CK" CHECK (ROW_ACTIVE IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_SSHIPMENTUNITLINE_OTM_DIM_SHIPUNIT_OTM_FK" FOREIGN KEY ("DIM_SHIPUNIT_OTM_ID")
	  REFERENCES "DWADW"."DIM_SHIPUNIT_OTM" ("SHIPUNIT_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_SSHIPMENTUNITLINE_OTM_FACT_ORDERRELEASE_OTM_FK" FOREIGN KEY ("FACT_ORDERRELEASE_OTM_ID")
	  REFERENCES "DWADW"."FACT_ORDERRELEASE_OTM" ("ORDERRELEASE_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_SSHIPMENTUNITLINE_OTM_FACT_ORDERRELEASELINES_OTM_FK" FOREIGN KEY ("FACT_ORDERRELEASELINES_OTM_ID")
	  REFERENCES "DWADW"."FACT_ORDERRELEASELINES_OTM" ("ORDERRELEASELINES_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_SSHIPUL_PI_OTM_FK" FOREIGN KEY ("DIM_PACKAGEDITEM_OTM_ID")
	  REFERENCES "DWADW"."FACT_PACKAGEDITEM_OTM" ("PACKAGEDITEM_OTM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_SSHIPMENTUNITLINE_OTM"  IS 'Español: Tabla de hechos de líneas de unidades de embarque con métricas físicas y relación a order releases. | English: Shipment unit line fact table with physical metrics linked to order releases.';

CREATE UNIQUE INDEX "DWADW"."FACT_SSHIPMENTUNITLINE_OTM_PK" ON "DWADW"."FACT_SSHIPMENTUNITLINE_OTM" ("SSHIPMENTUNITLINE_OTM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_SSHIPMENTUNITLINE_OTM_UN" ON "DWADW"."FACT_SSHIPMENTUNITLINE_OTM" ("S_SHIP_UNIT_GID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal