DWADW.DIM_ITEMREF_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de referencia y configuración de artículos. Contiene identificadores, organización, número de artículo y atributos de control de inventario, costos y operación, y permite relacionar y caracterizar los productos utilizados en los procesos operativos. English: Item reference and configuration catalog. It contains identifiers, organization, item number, and inventory, costing, and operational control attributes and supports linking and characterization of products used in operational processes.

Columnas

#	Columna	Tipo	Nulo	Default
1	ITEMREF_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378156”.nextval
2	DISTRIBUTIONRULEPEOACCOUNTINGOBJECTVERSIONNUMBER	NUMBER(9,0)	NO
3	DISTRIBUTIONRULEPEOACCOUNTINGRULEID	NUMBER(18,0)	NO
4	DISTRIBUTIONRULEPEOINVOICINGOBJECTVERSIONNUMBER	NUMBER(9,0)	NO
5	DISTRIBUTIONRULEPEOINVOICINGRULEID	NUMBER(18,0)	NO
6	FORCEPURCHASELEADTIMEFLAG	VARCHAR2(1)	SI
7	INVENTORYRULEPEORULEID	NUMBER(18,0)	NO
8	ITEMBASEPEOALLOWEDUNITSLOOKUPCODE	NUMBER(8,0)	SI
9	ITEMBASEPEOAPPROVALSTATUS	VARCHAR2(30)	SI
10	ITEMBASEPEOASSETCLASS	VARCHAR2(30)	SI
11	ITEMBASEPEOASSETTRACKEDFLAG	VARCHAR2(1)	SI
12	ITEMBASEPEOATPCOMPONENTSFLAG	VARCHAR2(1)	SI
13	ITEMBASEPEOATPFLAG	VARCHAR2(1)	SI
14	ITEMBASEPEOBOMITEMTYPE	NUMBER(8,0)	SI
15	ITEMBASEPEOBULKPICKEDFLAG	VARCHAR2(1)	SI
16	ITEMBASEPEOCOSTINGENABLEDFLAG	VARCHAR2(1)	SI
17	ITEMBASEPEOCURRENTPHASECODE	VARCHAR2(120)	SI
18	ITEMBASEPEOCUSTOMERORDERENABLEDFLAG	VARCHAR2(1)	SI
19	ITEMBASEPEOCUSTOMERORDERFLAG	VARCHAR2(1)	SI
20	ITEMBASEPEOCYCLECOUNTENABLEDFLAG	VARCHAR2(1)	SI
21	ITEMBASEPEODEFAULTINCLUDEINROLLUPFLAG	VARCHAR2(1)	SI
22	ITEMBASEPEODIMENSIONUOMCODE	VARCHAR2(3)	SI
23	ITEMBASEPEODUALUOMCONTROL	NUMBER(8,0)	SI
24	ITEMBASEPEOEFFECTIVITYCONTROL	NUMBER(8,0)	SI
25	ITEMBASEPEOENABLEDFLAG	VARCHAR2(1)	SI
26	ITEMBASEPEOENDASSEMBLYPEGGINGFLAG	VARCHAR2(1)	SI
27	ITEMBASEPEOEQUIPMENTTYPE	NUMBER(8,0)	SI
28	ITEMBASEPEOEXCLUDEFROMBUDGETFLAG	NUMBER(8,0)	SI
29	ITEMBASEPEOFULLLEADTIME	NUMBER(8,0)	SI
30	ITEMBASEPEOGRADECONTROLFLAG	VARCHAR2(1)	SI
31	ITEMBASEPEOHAZARDOUSMATERIALFLAG	VARCHAR2(1)	SI
32	ITEMBASEPEOINDIVISIBLEFLAG	VARCHAR2(1)	SI
33	ITEMBASEPEOINTERNALORDERENABLEDFLAG	VARCHAR2(1)	SI
34	ITEMBASEPEOINTERNALORDERFLAG	VARCHAR2(1)	SI
35	ITEMBASEPEOINVENTORYASSETFLAG	VARCHAR2(1)	SI
36	ITEMBASEPEOINVENTORYITEMFLAG	VARCHAR2(1)	SI
37	ITEMBASEPEOINVENTORYITEMID	NUMBER(18,0)	NO
38	ITEMBASEPEOINVENTORYITEMSTATUSCODE	VARCHAR2(10)	SI
39	ITEMBASEPEOINVENTORYORGANIZATIONID	NUMBER(18,0)	SI
40	ITEMBASEPEOINVENTORYPLANNINGCODE	NUMBER(8,0)	SI
41	ITEMBASEPEOINVOICEENABLEDFLAG	VARCHAR2(1)	SI
42	ITEMBASEPEOINVOICEABLEITEMFLAG	VARCHAR2(1)	SI
43	ITEMBASEPEOITEMCATALOGGROUPID	NUMBER(18,0)	SI
44	ITEMBASEPEOITEMNUMBER	VARCHAR2(300)	SI
45	ITEMBASEPEOITEMTYPE	VARCHAR2(30)	SI
46	ITEMBASEPEOJOBDEFINITIONNAME	VARCHAR2(100)	SI
47	ITEMBASEPEOJOBDEFINITIONPACKAGE	VARCHAR2(900)	SI
48	ITEMBASEPEOLASTUPDATEDATE	DATE	NO
49	ITEMBASEPEOLISTPRICEPERUNIT	NUMBER(8,0)	SI
50	ITEMBASEPEOLOCATIONCONTROLCODE	NUMBER(8,0)	SI
51	ITEMBASEPEOLOTCONTROLCODE	NUMBER(8,0)	SI
52	ITEMBASEPEOLOTSTATUSENABLED	VARCHAR2(1)	SI
53	ITEMBASEPEOLOTTRANSLATEENABLED	VARCHAR2(1)	SI
54	ITEMBASEPEOMARKETPRICE	NUMBER(8,0)	SI
55	ITEMBASEPEOMATCHAPPROVALLEVEL	NUMBER(8,0)	SI
56	ITEMBASEPEOORGANIZATIONID	NUMBER(18,0)	NO
57	ITEMORGANIZATIONPARAMETERPEOLASTUPDATEDATE	DATE	NO
58	ITEMTRANSLATIONPEOLASTUPDATEDATE	DATE	NO
59	ORGANIZATIONUNITPEOLASTUPDATEDATE	DATE	NO
60	ORGANIZATIONUNITTLPEOLASTUPDATEDATE	DATE	NO
61	ROW_ACTIVE	CHAR(1)	NO	‘A’
62	AUDIT_ID	NUMBER	NO

Restricciones

CHECK: DIM_ITEMREF_OM_CK

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

CHECK: SYS_C00304843

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

CHECK: SYS_C00304844

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

CHECK: SYS_C00304845

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

CHECK: SYS_C00304846

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

CHECK: SYS_C00304847

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

CHECK: SYS_C00304848

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

CHECK: SYS_C00304849

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

CHECK: SYS_C00304850

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

CHECK: SYS_C00304851

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

CHECK: SYS_C00304852

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

CHECK: SYS_C00304853

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

CHECK: SYS_C00304854

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

CHECK: SYS_C00304855

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

CHECK: SYS_C00304856

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

CHECK: SYS_C00304857

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

PK: ST_ITEMREF_OM_PK

Estado: ENABLED
Columnas: ITEMREF_OM_ID

UK: DIM_ITEMREF_OM_UN

Estado: ENABLED
Columnas: ITEMBASEPEOINVENTORYITEMID, ITEMBASEPEOORGANIZATIONID

DDL

CREATE TABLE "DWADW"."DIM_ITEMREF_OM" 
   (	"ITEMREF_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, 
	"DISTRIBUTIONRULEPEOACCOUNTINGOBJECTVERSIONNUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"DISTRIBUTIONRULEPEOACCOUNTINGRULEID" NUMBER(18,0) NOT NULL ENABLE, 
	"DISTRIBUTIONRULEPEOINVOICINGOBJECTVERSIONNUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"DISTRIBUTIONRULEPEOINVOICINGRULEID" NUMBER(18,0) NOT NULL ENABLE, 
	"FORCEPURCHASELEADTIMEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"INVENTORYRULEPEORULEID" NUMBER(18,0) NOT NULL ENABLE, 
	"ITEMBASEPEOALLOWEDUNITSLOOKUPCODE" NUMBER(8,0), 
	"ITEMBASEPEOAPPROVALSTATUS" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOASSETCLASS" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOASSETTRACKEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOATPCOMPONENTSFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOATPFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOBOMITEMTYPE" NUMBER(8,0), 
	"ITEMBASEPEOBULKPICKEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOCOSTINGENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOCURRENTPHASECODE" VARCHAR2(120) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOCUSTOMERORDERENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOCUSTOMERORDERFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOCYCLECOUNTENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEODEFAULTINCLUDEINROLLUPFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEODIMENSIONUOMCODE" VARCHAR2(3) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEODUALUOMCONTROL" NUMBER(8,0), 
	"ITEMBASEPEOEFFECTIVITYCONTROL" NUMBER(8,0), 
	"ITEMBASEPEOENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOENDASSEMBLYPEGGINGFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOEQUIPMENTTYPE" NUMBER(8,0), 
	"ITEMBASEPEOEXCLUDEFROMBUDGETFLAG" NUMBER(8,0), 
	"ITEMBASEPEOFULLLEADTIME" NUMBER(8,0), 
	"ITEMBASEPEOGRADECONTROLFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOHAZARDOUSMATERIALFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINDIVISIBLEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINTERNALORDERENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINTERNALORDERFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINVENTORYASSETFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINVENTORYITEMFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINVENTORYITEMID" NUMBER(18,0) NOT NULL ENABLE, 
	"ITEMBASEPEOINVENTORYITEMSTATUSCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINVENTORYORGANIZATIONID" NUMBER(18,0), 
	"ITEMBASEPEOINVENTORYPLANNINGCODE" NUMBER(8,0), 
	"ITEMBASEPEOINVOICEENABLEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOINVOICEABLEITEMFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOITEMCATALOGGROUPID" NUMBER(18,0), 
	"ITEMBASEPEOITEMNUMBER" VARCHAR2(300) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOITEMTYPE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOJOBDEFINITIONNAME" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOJOBDEFINITIONPACKAGE" VARCHAR2(900) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"ITEMBASEPEOLISTPRICEPERUNIT" NUMBER(8,0), 
	"ITEMBASEPEOLOCATIONCONTROLCODE" NUMBER(8,0), 
	"ITEMBASEPEOLOTCONTROLCODE" NUMBER(8,0), 
	"ITEMBASEPEOLOTSTATUSENABLED" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOLOTTRANSLATEENABLED" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ITEMBASEPEOMARKETPRICE" NUMBER(8,0), 
	"ITEMBASEPEOMATCHAPPROVALLEVEL" NUMBER(8,0), 
	"ITEMBASEPEOORGANIZATIONID" NUMBER(18,0) NOT NULL ENABLE, 
	"ITEMORGANIZATIONPARAMETERPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"ITEMTRANSLATIONPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"ORGANIZATIONUNITPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"ORGANIZATIONUNITTLPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "DIM_ITEMREF_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "ST_ITEMREF_OM_PK" PRIMARY KEY ("ITEMREF_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_ITEMREF_OM_UN" UNIQUE ("ITEMBASEPEOINVENTORYITEMID", "ITEMBASEPEOORGANIZATIONID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_ITEMREF_OM"  IS 'Español: Catálogo de referencia y configuración de artículos. Contiene identificadores, organización, número de artículo y atributos de control de inventario, costos y operación, y permite relacionar y caracterizar los productos utilizados en los procesos operativos.
English: Item reference and configuration catalog. It contains identifiers, organization, item number, and inventory, costing, and operational control attributes and supports linking and characterization of products used in operational processes.';

CREATE UNIQUE INDEX "DWADW"."ST_ITEMREF_OM_PK" ON "DWADW"."DIM_ITEMREF_OM" ("ITEMREF_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_ITEMREF_OM_UN" ON "DWADW"."DIM_ITEMREF_OM" ("ITEMBASEPEOINVENTORYITEMID", "ITEMBASEPEOORGANIZATIONID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal