🏠 Menú principal

← Volver a tablas

---

STADW.ST_SUPPLIER

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ORGANIZATIONEFFECTIVESTARTDATE	DATE	SI
2	PARTYPARTYNAME	VARCHAR2(2000)	SI
3	PARTYPARTYNUMBER	VARCHAR2(2000)	SI
4	PARTYTAXPROFILEGENERICCOUNTRYCODE	VARCHAR2(50)	SI
5	PARTYTAXPROFILEGENERICTAXCLASSIFICATIONCODE	VARCHAR2(50)	SI
6	SUPPINVDISTAMOUNT	NUMBER	SI
7	SUPPLIERBUSINESSRELATIONSHIP	VARCHAR2(50)	SI
8	SUPPLIERCREATEDBY	VARCHAR2(100)	SI
9	SUPPLIERCREATIONDATE	DATE	SI
10	SUPPLIERCREATIONDATEONLY	DATE	SI
11	SUPPLIERCREATIONSOURCE	VARCHAR2(100)	SI
12	SUPPLIERFEDERALREPORTABLEFLAG	VARCHAR2(2)	SI
13	SUPPLIERHIERARCHYINVDISTHIERARCHYAMOUNT	NUMBER	SI
14	SUPPLIERHIERARCHYINVDISTVENDORID	NUMBER	SI
15	SUPPLIERLASTUPDATEDATE	DATE	SI
16	SUPPLIERLASTUPDATEDBY	VARCHAR2(50)	SI
17	SUPPLIERORGANIZATIONTYPELOOKUPCODE	VARCHAR2(50)	SI
18	SUPPLIERPARTYID	NUMBER	SI
19	SUPPLIERSEGMENT1	VARCHAR2(50)	SI
20	SUPPLIERTAXPAYERCOUNTRY	VARCHAR2(10)	SI
21	SUPPLIERVENDORTYPELOOKUPCODE	VARCHAR2(50)	SI
22	VENDORID	NUMBER	NO
23	SUPPLIERTAXPAYERID	VARCHAR2(100)	SI
24	PARTYTAXPROFILEGENERICREPREGISTRATIONNUMBER	VARCHAR2(100)	SI

Restricciones

CHECK: SYS_C0024769

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

PK: SYS_C0024770

• Estado: ENABLED
• Columnas: VENDORID

DDL

CREATE TABLE "STADW"."ST_SUPPLIER" 
   (	"ORGANIZATIONEFFECTIVESTARTDATE" DATE, 
	"PARTYPARTYNAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PARTYPARTYNUMBER" VARCHAR2(2000) COLLATE "USING_NLS_COMP", 
	"PARTYTAXPROFILEGENERICCOUNTRYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"PARTYTAXPROFILEGENERICTAXCLASSIFICATIONCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPINVDISTAMOUNT" NUMBER(*,0), 
	"SUPPLIERBUSINESSRELATIONSHIP" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPLIERCREATEDBY" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"SUPPLIERCREATIONDATE" DATE, 
	"SUPPLIERCREATIONDATEONLY" DATE, 
	"SUPPLIERCREATIONSOURCE" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"SUPPLIERFEDERALREPORTABLEFLAG" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"SUPPLIERHIERARCHYINVDISTHIERARCHYAMOUNT" NUMBER(*,0), 
	"SUPPLIERHIERARCHYINVDISTVENDORID" NUMBER(*,0), 
	"SUPPLIERLASTUPDATEDATE" DATE, 
	"SUPPLIERLASTUPDATEDBY" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPLIERORGANIZATIONTYPELOOKUPCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPLIERPARTYID" NUMBER(*,0), 
	"SUPPLIERSEGMENT1" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUPPLIERTAXPAYERCOUNTRY" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"SUPPLIERVENDORTYPELOOKUPCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"VENDORID" NUMBER(*,0) NOT NULL ENABLE, 
	"SUPPLIERTAXPAYERID" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	"PARTYTAXPROFILEGENERICREPREGISTRATIONNUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP", 
	 PRIMARY KEY ("VENDORID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0024770" ON "STADW"."ST_SUPPLIER" ("VENDORID") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal