DWADW.DIM_ORGANIZATIONCUSTOMER_AR

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de organizaciones asociadas a clientes. Contiene identificación, información fiscal, dirección, contacto, vigencia y datos del perfil de organización, y permite complementar el análisis y segmentación de clientes empresariales. English: Catalog of organizations associated with customers. It contains identification, tax information, address, contact, effective dates, and organization profile data and supports analysis and segmentation of business customers.

Columnas

#	Columna	Tipo	Nulo	Default
1	ORGANIZATIONCUSTOMER_AR_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378160”.nextval
2	ORGANIZATIONPROFILEID	NUMBER(18,0)	NO
3	PARTYID	NUMBER(18,0)	SI
4	PARTYPEOPARTYID	NUMBER(18,0)	SI
5	PARTYNUMBER	VARCHAR2(30)	SI
6	PARTYNAME	VARCHAR2(360)	SI
7	PARTYUNIQUENAME	VARCHAR2(900)	SI
8	PARTYTYPE	VARCHAR2(30)	SI
9	ORGANIZATIONNAME	VARCHAR2(360)	SI
10	STATUS	VARCHAR2(1)	SI
11	JGZZFISCALCODE	VARCHAR2(20)	SI
12	ORIGSYSTEMREFERENCE	VARCHAR2(240)	SI
13	IDENADDRLOCATIONID	NUMBER(18,0)	SI
14	IDENADDRPARTYSITEID	NUMBER(18,0)	SI
15	ADDRESS1	VARCHAR2(240)	SI
16	CITY	VARCHAR2(60)	SI
17	STATE	VARCHAR2(60)	SI
18	COUNTRY	VARCHAR2(2)	SI
19	EMAILADDRESS	VARCHAR2(320)	SI
20	PRIMARYPHONECOUNTRYCODE	VARCHAR2(10)	SI
21	PRIMARYPHONENUMBER	VARCHAR2(40)	SI
22	EFFECTIVESTARTDATE	DATE	SI
23	EFFECTIVEENDDATE	DATE	SI
24	EFFECTIVELATESTCHANGE	VARCHAR2(1)	SI
25	EFFECTIVESEQUENCE	NUMBER(4,0)	SI
26	PARTYPEOCREATIONDATE	TIMESTAMP(6)	SI
27	PARTYPEOLASTUPDATEDATE	TIMESTAMP(6)	SI
28	ORGANIZATIONPROFILEPEOCREATIONDATE	TIMESTAMP(6)	SI
29	ORGANIZATIONPROFILEPEOLASTUPDATEDATE	TIMESTAMP(6)	SI
30	PARTYPEOCREATEDBY	VARCHAR2(64)	SI
31	PARTYPEOLASTUPDATEDBY	VARCHAR2(64)	SI
32	ORGANIZATIONPROFILEPEOCREATEDBY	VARCHAR2(64)	SI
33	ORGANIZATIONPROFILEPEOLASTUPDATEDBY	VARCHAR2(64)	SI
34	AUDIT_ID	NUMBER	NO
35	ROW_ACTIVE	CHAR(1)	NO	‘A’
36	DIM_CUSTOMER_AR_ID	NUMBER	SI

Restricciones

CHECK: DIM_ORGANIZATIONCUSTOMER_AR_CK

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

CHECK: SYS_C00304861

Estado: ENABLED
Columnas: ORGANIZATIONCUSTOMER_AR_ID
Condición: "ORGANIZATIONCUSTOMER_AR_ID" IS NOT NULL

CHECK: SYS_C00304862

Estado: ENABLED
Columnas: ORGANIZATIONPROFILEID
Condición: "ORGANIZATIONPROFILEID" IS NOT NULL

CHECK: SYS_C00304863

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

CHECK: SYS_C00304864

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

PK: DIM_ORGANIZATIONCUSTOMER_AR_PK

Estado: ENABLED
Columnas: ORGANIZATIONCUSTOMER_AR_ID

FK: DIM_ORGANIZATIONCUSTOMER_AR_DIM_CUSTOMER_AR_FK

Estado: ENABLED
Columnas: DIM_CUSTOMER_AR_ID
Referencia: DWADW.DIM_CUSTOMER_AR (constraint DIM_CUSTOMER_AR_PK)

UK: DIM_ORGANIZATIONCUSTOMER_AR__UN

Estado: ENABLED
Columnas: ORGANIZATIONPROFILEID

DDL

CREATE TABLE "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR" 
   (	"ORGANIZATIONCUSTOMER_AR_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, 
	"ORGANIZATIONPROFILEID" NUMBER(18,0) NOT NULL ENABLE, 
	"PARTYID" NUMBER(18,0), 
	"PARTYPEOPARTYID" NUMBER(18,0), 
	"PARTYNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PARTYNAME" VARCHAR2(360) COLLATE "USING_NLS_COMP", 
	"PARTYUNIQUENAME" VARCHAR2(900) COLLATE "USING_NLS_COMP", 
	"PARTYTYPE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"ORGANIZATIONNAME" VARCHAR2(360) COLLATE "USING_NLS_COMP", 
	"STATUS" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"JGZZFISCALCODE" VARCHAR2(20) COLLATE "USING_NLS_COMP", 
	"ORIGSYSTEMREFERENCE" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"IDENADDRLOCATIONID" NUMBER(18,0), 
	"IDENADDRPARTYSITEID" NUMBER(18,0), 
	"ADDRESS1" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"CITY" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"STATE" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"COUNTRY" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"EMAILADDRESS" VARCHAR2(320) COLLATE "USING_NLS_COMP", 
	"PRIMARYPHONECOUNTRYCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"PRIMARYPHONENUMBER" VARCHAR2(40) COLLATE "USING_NLS_COMP", 
	"EFFECTIVESTARTDATE" DATE, 
	"EFFECTIVEENDDATE" DATE, 
	"EFFECTIVELATESTCHANGE" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"EFFECTIVESEQUENCE" NUMBER(4,0), 
	"PARTYPEOCREATIONDATE" TIMESTAMP (6), 
	"PARTYPEOLASTUPDATEDATE" TIMESTAMP (6), 
	"ORGANIZATIONPROFILEPEOCREATIONDATE" TIMESTAMP (6), 
	"ORGANIZATIONPROFILEPEOLASTUPDATEDATE" TIMESTAMP (6), 
	"PARTYPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"PARTYPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"ORGANIZATIONPROFILEPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"ORGANIZATIONPROFILEPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_CUSTOMER_AR_ID" NUMBER, 
	 CONSTRAINT "DIM_ORGANIZATIONCUSTOMER_AR_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_ORGANIZATIONCUSTOMER_AR_PK" PRIMARY KEY ("ORGANIZATIONCUSTOMER_AR_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_ORGANIZATIONCUSTOMER_AR__UN" UNIQUE ("ORGANIZATIONPROFILEID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_ORGANIZATIONCUSTOMER_AR_DIM_CUSTOMER_AR_FK" FOREIGN KEY ("DIM_CUSTOMER_AR_ID")
	  REFERENCES "DWADW"."DIM_CUSTOMER_AR" ("CUSTOMER_AR_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR"  IS 'Español: Catálogo de organizaciones asociadas a clientes. Contiene identificación, información fiscal, dirección, contacto, vigencia y datos del perfil de organización, y permite complementar el análisis y segmentación de clientes empresariales.
English: Catalog of organizations associated with customers. It contains identification, tax information, address, contact, effective dates, and organization profile data and supports analysis and segmentation of business customers.';

CREATE UNIQUE INDEX "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR_PK" ON "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR" ("ORGANIZATIONCUSTOMER_AR_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR__UN" ON "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR" ("ORGANIZATIONPROFILEID") 
  ;
  CREATE INDEX "DWADW"."IDX_ORGCUST_TRACKING_OM" ON "DWADW"."DIM_ORGANIZATIONCUSTOMER_AR" ("PARTYID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal