🏠 Menú principal

← Volver a tablas

---

STADW.ST_PO_TRXHEADER

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	POHEADERAMOUNT	NUMBER	SI
2	POHEADERLEDGERAMOUNT	NUMBER	SI
3	POHEADERID	NUMBER	NO
4	PURCHASEORDERVERSIONCHANGEORDERSTATUS	VARCHAR2(50)	SI
5	PURCHASEORDERVERSIONLASTUPDATEDATE	DATE	SI
6	PURCHASEORDERVERSIONSUBMITTEDDATE	DATE	SI
7	PURCHASINGDOCUMENTHEADERAPPROVEDDATE	DATE	SI
8	PURCHASINGDOCUMENTHEADERAPPROVEDFLAG	VARCHAR2(50)	SI
9	PURCHASINGDOCUMENTHEADERBUDGETCONTROLENABLEDFLAG	VARCHAR2(50)	SI
10	PURCHASINGDOCUMENTHEADERBUYERMANAGEDTRANSPORTFLAG	VARCHAR2(50)	SI
11	PURCHASINGDOCUMENTHEADERCCEMAILADDRESS	VARCHAR2(100)	SI
12	PURCHASINGDOCUMENTHEADERCLOSEDDATE	DATE	SI
13	PURCHASINGDOCUMENTHEADERCOMMENTS	VARCHAR2(2000)	SI
14	PURCHASINGDOCUMENTHEADERCREATIONDATE	DATE	SI
15	PURCHASINGDOCUMENTHEADERDEFAULTTAXATIONCOUNTRY	VARCHAR2(50)	SI
16	PURCHASINGDOCUMENTHEADERDOCUMENTCREATIONMETHOD	VARCHAR2(100)	SI
17	PURCHASINGDOCUMENTHEADERDOCUMENTSTATUS	VARCHAR2(100)	SI
18	PURCHASINGDOCUMENTHEADERFUNDSSTATUS	VARCHAR2(100)	SI
19	PURCHASINGDOCUMENTHEADERLASTUPDATEDATE	DATE	SI
20	PURCHASINGDOCUMENTHEADERLASTUPDATEDBY	VARCHAR2(100)	SI
21	PURCHASINGDOCUMENTHEADERNOTETOVENDOR	VARCHAR2(2000)	SI
22	PURCHASINGDOCUMENTHEADERREVISIONNUM	NUMBER	SI
23	PURCHASINGDOCUMENTHEADERSEGMENT1	VARCHAR2(200)	SI
24	PURCHASINGDOCUMENTHEADERSUPPLIERNOTIFMETHOD	VARCHAR2(100)	SI
25	PURCHASINGDOCUMENTHEADERVENDORID	NUMBER	SI

Restricciones

CHECK: SYS_C0024777

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

PK: SYS_C0024778

• Estado: ENABLED
• Columnas: POHEADERID

DDL

CREATE TABLE "STADW"."ST_PO_TRXHEADER" 
   (	"POHEADERAMOUNT" NUMBER, 
	"POHEADERLEDGERAMOUNT" NUMBER, 
	"POHEADERID" NUMBER(*,0) NOT NULL ENABLE, 
	"PURCHASEORDERVERSIONCHANGEORDERSTATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PURCHASEORDERVERSIONLASTUPDATEDATE" DATE, 
	"PURCHASEORDERVERSIONSUBMITTEDDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERAPPROVEDDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERAPPROVEDFLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERBUDGETCONTROLENABLEDFLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERBUYERMANAGEDTRANSPORTFLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERCCEMAILADDRESS" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERCLOSEDDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERCOMMENTS" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERCREATIONDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERDEFAULTTAXATIONCOUNTRY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERDOCUMENTCREATIONMETHOD" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERDOCUMENTSTATUS" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERFUNDSSTATUS" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERLASTUPDATEDATE" DATE, 
	"PURCHASINGDOCUMENTHEADERLASTUPDATEDBY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERNOTETOVENDOR" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERREVISIONNUM" NUMBER, 
	"PURCHASINGDOCUMENTHEADERSEGMENT1" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERSUPPLIERNOTIFMETHOD" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PURCHASINGDOCUMENTHEADERVENDORID" NUMBER, 
	 PRIMARY KEY ("POHEADERID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0024778" ON "STADW"."ST_PO_TRXHEADER" ("POHEADERID") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal