🏠 Menú principal

← Volver a tablas

---

DWADW.DW_PO_TRXHEADER

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	HEADER_AMOUNT	NUMBER	SI
2	LEDGER_AMOUNT	NUMBER	SI
3	POHEADERID	NUMBER	NO
4	CHANGE_ORDER_STATUS	VARCHAR2(50)	SI
5	VERSION_LAST_UPDATE	DATE	SI
6	VERSION_SUBMITTED_DATE	DATE	SI
7	APPROVED_DATE	DATE	SI
8	APPROVED_FLAG	VARCHAR2(50)	SI
9	CONTROL_ENABLED_FLAG	VARCHAR2(50)	SI
10	MANAGER_TRANSPORT_FLAG	VARCHAR2(50)	SI
11	EMAIL_ADDRESS	VARCHAR2(100)	SI
12	CLOSE_DATE	DATE	SI
13	COMMENTS	VARCHAR2(2000)	SI
14	CREATION_DATE	DATE	SI
15	TAXATION_COUNTRY	VARCHAR2(50)	SI
16	CREATION_METHOD	VARCHAR2(100)	SI
17	DOCUMENT_STATUS	VARCHAR2(100)	SI
18	FUNDS_STATUS	VARCHAR2(100)	SI
19	LAST_UPDATE	DATE	SI
20	LAST_UPDATE_BY	VARCHAR2(100)	SI
21	NOT_E_TO_VENDOR	VARCHAR2(2000)	SI
22	VERSION_NUM	NUMBER	SI
23	SEGMENT1	VARCHAR2(200)	SI
24	SUPPLIER_METHOD	VARCHAR2(100)	SI
25	VENDOR_ID	NUMBER	SI
26	PARTY_NAME	VARCHAR2(1000)	SI
27	FISCAL_CODE	VARCHAR2(100)	SI
28	PARTY_ID	NUMBER	SI

Restricciones

CHECK: SYS_C0024779

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

PK: SYS_C0024780

• Estado: ENABLED
• Columnas: POHEADERID

DDL

CREATE TABLE "DWADW"."DW_PO_TRXHEADER" 
   (	"HEADER_AMOUNT" NUMBER, 
	"LEDGER_AMOUNT" NUMBER, 
	"POHEADERID" NUMBER(*,0) NOT NULL ENABLE, 
	"CHANGE_ORDER_STATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"VERSION_LAST_UPDATE" DATE, 
	"VERSION_SUBMITTED_DATE" DATE, 
	"APPROVED_DATE" DATE, 
	"APPROVED_FLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CONTROL_ENABLED_FLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"MANAGER_TRANSPORT_FLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"EMAIL_ADDRESS" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CLOSE_DATE" DATE, 
	"COMMENTS" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"CREATION_DATE" DATE, 
	"TAXATION_COUNTRY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CREATION_METHOD" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"DOCUMENT_STATUS" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"FUNDS_STATUS" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"LAST_UPDATE" DATE, 
	"LAST_UPDATE_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"NOT_E_TO_VENDOR" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"VERSION_NUM" NUMBER, 
	"SEGMENT1" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"SUPPLIER_METHOD" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"VENDOR_ID" NUMBER, 
	"PARTY_NAME" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"FISCAL_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER, 
	 PRIMARY KEY ("POHEADERID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT DELETE ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT INSERT ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT SELECT ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT UPDATE ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT ALTER ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT READ ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT DEBUG ON "DWADW"."DW_PO_TRXHEADER" TO "MANAGE_DW_ST";
  GRANT ALTER ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT DELETE ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT INSERT ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT UPDATE ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT READ ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT DEBUG ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_PO_TRXHEADER" TO "POWER_BI";
  GRANT INDEX ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT REFERENCES ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT ON COMMIT REFRESH ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT QUERY REWRITE ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";
  GRANT FLASHBACK ON "DWADW"."DW_PO_TRXHEADER" TO "BICC";

CREATE UNIQUE INDEX "DWADW"."SYS_C0024780" ON "DWADW"."DW_PO_TRXHEADER" ("POHEADERID") 
  ;
  CREATE INDEX "DWADW"."TRX_NUMBER_PO" ON "DWADW"."DW_PO_TRXHEADER" ("SEGMENT1") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal