🏠 Menú principal

← Volver a tablas

---

STADW.ST_ITEMREF_HIST

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	IDMAESTROCARGUE	NUMBER(18,0)	NO
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

Restricciones

CHECK: SYS_C0036421

• Estado: ENABLED
• Columnas: IDMAESTROCARGUE
• Condición: "IDMAESTROCARGUE" IS NOT NULL

CHECK: SYS_C0036422

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

CHECK: SYS_C0036423

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

CHECK: SYS_C0036424

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

CHECK: SYS_C0036425

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

CHECK: SYS_C0036426

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

CHECK: SYS_C0036427

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

CHECK: SYS_C0036428

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

CHECK: SYS_C0036429

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

CHECK: SYS_C0036430

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

CHECK: SYS_C0036431

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

CHECK: SYS_C0036432

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

CHECK: SYS_C0036433

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

DDL

CREATE TABLE "STADW"."ST_ITEMREF_HIST" 
   (	"IDMAESTROCARGUE" NUMBER(18,0) 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
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT ALTER ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT DELETE ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT INDEX ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT INSERT ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT SELECT ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT READ ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_ITEMREF_HIST" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_ITEMREF_HIST" TO "BICC";

---

← Volver a tablas de STADW

🏠 Volver al menú principal