🏠 Menú principal

← Volver a tablas

---

STADW.ST_HEADER

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ID	NUMBER	NO	“STADW”.”ISEQ$$_188076”.nextval
2	IDMAESTROCARGUE	NUMBER(18,0)	NO
3	CANCELEDFLAG	VARCHAR2(1)	SI
4	CHANGEVERSIONNUMBER	NUMBER(18,0)	SI
5	CREATEDBY	VARCHAR2(64)	NO
6	CREATIONDATE	DATE	NO
7	CUSTOMERPONUMBER	VARCHAR2(50)	SI
8	HEADERCANCELREASONCODE	VARCHAR2(30)	SI
9	HEADERID	NUMBER(18,0)	NO
10	HEADERORDEREDDATETIMESTAMP	DATE	SI
11	HEADERREQUESTSHIPDATE	DATE	SI
12	HEADERSUBMITTEDBY	VARCHAR2(64)	SI
13	HEADERSUBMITTEDDATE	DATE	SI
14	LASTUPDATEDATE	DATE	NO
15	LASTUPDATEDBY	VARCHAR2(64)	NO
16	ONHOLD	VARCHAR2(1)	SI
17	OPENFLAG	VARCHAR2(1)	SI
18	ORDERNUMBER	VARCHAR2(50)	NO
19	ORDERTYPECODE	VARCHAR2(30)	SI
20	ORDEREDDATE	DATE	SI
21	SOLDTOPARTYID	NUMBER(18,0)	SI
22	SOURCEDOCUMENTTYPECODE	VARCHAR2(50)	SI
23	SOURCEORDERNUMBER	VARCHAR2(50)	SI
24	SOURCEORDERSYSTEM	VARCHAR2(50)	SI
25	SUBMITTEDFLAG	VARCHAR2(1)	SI

Restricciones

CHECK: SYS_C0034894

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

CHECK: SYS_C0034895

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

CHECK: SYS_C0034896

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

CHECK: SYS_C0034897

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

CHECK: SYS_C0034898

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

CHECK: SYS_C0034899

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

CHECK: SYS_C0034900

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

CHECK: SYS_C0034901

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

PK: SYS_C0034902

• Estado: ENABLED
• Columnas: ID

DDL

CREATE TABLE "STADW"."ST_HEADER" 
   (	"ID" NUMBER(*,0) GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE, 
	"CANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"CHANGEVERSIONNUMBER" NUMBER(18,0), 
	"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CREATIONDATE" DATE NOT NULL ENABLE, 
	"CUSTOMERPONUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"HEADERCANCELREASONCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"HEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"HEADERORDEREDDATETIMESTAMP" DATE, 
	"HEADERREQUESTSHIPDATE" DATE, 
	"HEADERSUBMITTEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"HEADERSUBMITTEDDATE" DATE, 
	"LASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ONHOLD" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"OPENFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDERTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"ORDEREDDATE" DATE, 
	"SOLDTOPARTYID" NUMBER(18,0), 
	"SOURCEDOCUMENTTYPECODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SOURCEORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SOURCEORDERSYSTEM" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUBMITTEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	 PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0034902" ON "STADW"."ST_HEADER" ("ID") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal