🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_TRXHEADER_PO

Base de datos origen: ADW COEXITO

Descripción: Español: Cabecera de órdenes de compra utilizada para gestionar montos, aprobaciones, estado documental y relación con proveedores. English: Purchase order header used to manage amounts, approvals, document status, and supplier relationships.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	TRXHEADER_PO_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306930”.nextval
2	HEADER_AMOUNT	NUMBER	SI
3	LEDGER_AMOUNT	NUMBER	SI
4	POHEADERID	NUMBER	NO
5	CHANGE_ORDER_STATUS	VARCHAR2(50)	SI
6	VERSION_LAST_UPDATE	DATE	SI
7	VERSION_SUBMITTED_DATE	DATE	SI
8	APPROVED_DATE	DATE	SI
9	APPROVED_FLAG	VARCHAR2(50)	SI
10	CONTROL_ENABLED_FLAG	VARCHAR2(50)	SI
11	MANAGER_TRANSPORT_FLAG	VARCHAR2(50)	SI
12	EMAIL_ADDRESS	VARCHAR2(100)	SI
13	CLOSE_DATE	DATE	SI
14	COMMENTS	VARCHAR2(2000)	SI
15	CREATION_DATE	DATE	SI
16	TAXATION_COUNTRY	VARCHAR2(50)	SI
17	CREATION_METHOD	VARCHAR2(100)	SI
18	DOCUMENT_STATUS	VARCHAR2(100)	SI
19	FUNDS_STATUS	VARCHAR2(100)	SI
20	LAST_UPDATE	DATE	SI
21	LAST_UPDATE_BY	VARCHAR2(100)	SI
22	NOT_E_TO_VENDOR	VARCHAR2(2000)	SI
23	VERSION_NUM	NUMBER	SI
24	SEGMENT1	VARCHAR2(200)	SI
25	SUPPLIER_METHOD	VARCHAR2(100)	SI
26	VENDOR_ID	NUMBER	SI
27	AUDIT_ID	NUMBER	NO
28	ROW_ACTIVE	CHAR(1)	NO	‘A’
29	DIM_SUPPLIER_AP_ID	NUMBER	SI

Restricciones

CHECK: FACT_TRXHEADER_PO_AI_CK

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

CHECK: SYS_C00202931

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

CHECK: SYS_C00202932

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

CHECK: SYS_C00202933

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

CHECK: SYS_C00202934

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

PK: FACT_TRXHEADER_PO_PK

• Estado: ENABLED
• Columnas: TRXHEADER_PO_ID

FK: FACT_TRXHEADER_PO_DIM_SUPPLIER_AP_FK

• Estado: ENABLED
• Columnas: DIM_SUPPLIER_AP_ID
• Referencia: DWADW.DIM_SUPPLIER_AP (constraint DIM_SUPPLIER_AP_PK)

UK: FACT_TRXHEADER_PO__UN

• Estado: ENABLED
• Columnas: POHEADERID

DDL

CREATE TABLE "DWADW"."FACT_TRXHEADER_PO" 
   (	"TRXHEADER_PO_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, 
	"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, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_SUPPLIER_AP_ID" NUMBER, 
	 CONSTRAINT "FACT_TRXHEADER_PO_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_TRXHEADER_PO_PK" PRIMARY KEY ("TRXHEADER_PO_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_TRXHEADER_PO__UN" UNIQUE ("POHEADERID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_TRXHEADER_PO_DIM_SUPPLIER_AP_FK" FOREIGN KEY ("DIM_SUPPLIER_AP_ID")
	  REFERENCES "DWADW"."DIM_SUPPLIER_AP" ("SUPPLIER_AP_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_TRXHEADER_PO"  IS 'Español: Cabecera de órdenes de compra utilizada para gestionar montos, aprobaciones, estado documental y relación con proveedores.
English: Purchase order header used to manage amounts, approvals, document status, and supplier relationships.';

CREATE INDEX "DWADW"."TRX_NUMBER_SEGMENT1_PO" ON "DWADW"."FACT_TRXHEADER_PO" ("SEGMENT1") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_TRXHEADER_PO_PK" ON "DWADW"."FACT_TRXHEADER_PO" ("TRXHEADER_PO_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_TRXHEADER_PO__UN" ON "DWADW"."FACT_TRXHEADER_PO" ("POHEADERID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal