🏠 Menú principal

← Volver a tablas

---

DWADW.DW_SUPPLIER

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	START_DATE	DATE	SI
2	PARTY_NAME	VARCHAR2(2000)	SI
3	PARTY_NUMBER	VARCHAR2(2000)	SI
4	COUNTRY_CODE	VARCHAR2(50)	SI
5	CLASSIFICATION_CODE	VARCHAR2(50)	SI
6	INV_DIST_AMOUNT	NUMBER	SI
7	RELATION_SHIP	VARCHAR2(50)	SI
8	CREATED_BY	VARCHAR2(100)	SI
9	CREATION_DATE	DATE	SI
10	CREATION_DATE_ONLY	DATE	SI
11	CREATION_SOURCE	VARCHAR2(100)	SI
12	REPORTABLE_FLAG	VARCHAR2(2)	SI
13	INV_DIST_HIERARCHY_AMOUNT	NUMBER	SI
14	DIST_VENDOR_ID	NUMBER	SI
15	LAST_UPDATE	DATE	SI
16	LAST_UPDATE_BY	VARCHAR2(50)	SI
17	ORG_LOOKUP_CODE	VARCHAR2(50)	SI
18	PARTY_ID	NUMBER	SI
19	SUPPLIER_SEGMENT1	VARCHAR2(50)	SI
20	SUPPLIER_PAYER_COUNTRY	VARCHAR2(10)	SI
21	SUPPLIER_LOOKUP_CODE	VARCHAR2(50)	SI
22	VENDORID	NUMBER	NO
23	FISCAL_CODE	VARCHAR2(100)	SI
24	TAXPAYER_ID	VARCHAR2(100)	SI

Restricciones

CHECK: SYS_C0024771

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

PK: SYS_C0024772

• Estado: ENABLED
• Columnas: VENDORID

DDL

CREATE TABLE "DWADW"."DW_SUPPLIER" 
   (	"START_DATE" DATE, 
	"PARTY_NAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PARTY_NUMBER" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"COUNTRY_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CLASSIFICATION_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"INV_DIST_AMOUNT" NUMBER(*,0), 
	"RELATION_SHIP" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CREATED_BY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"CREATION_DATE" DATE, 
	"CREATION_DATE_ONLY" DATE, 
	"CREATION_SOURCE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"REPORTABLE_FLAG" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"INV_DIST_HIERARCHY_AMOUNT" NUMBER(*,0), 
	"DIST_VENDOR_ID" NUMBER(*,0), 
	"LAST_UPDATE" DATE, 
	"LAST_UPDATE_BY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"ORG_LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER(*,0), 
	"SUPPLIER_SEGMENT1" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPLIER_PAYER_COUNTRY" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"SUPPLIER_LOOKUP_CODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"VENDORID" NUMBER(*,0) NOT NULL ENABLE, 
	"FISCAL_CODE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"TAXPAYER_ID" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	 PRIMARY KEY ("VENDORID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "DWADW"."SYS_C0024772" ON "DWADW"."DW_SUPPLIER" ("VENDORID") 
  ;
  CREATE INDEX "DWADW"."INDEX_PARTY_NAME" ON "DWADW"."DW_SUPPLIER" ("PARTY_NAME") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal