DWADW.DIM_SITECUSTOMER_AR

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de sitios y ubicaciones asociados a clientes. Contiene identificadores del cliente y sitio, dirección, ciudad, provincia, país, estado y vigencia, y permite identificar los lugares utilizados para entrega, facturación y análisis geográfico. English: Catalog of customer sites and locations. It contains customer and site identifiers, address, city, state, country, status, and effective dates and supports identification of locations used for delivery, billing, and geographic analysis.

Columnas

#	Columna	Tipo	Nulo	Default
1	SITECUSTOMER_AR_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378168”.nextval
2	PARTYSITEID	NUMBER(18,0)	NO
3	PARTYID	NUMBER(18,0)	SI
4	LOCATIONID	NUMBER(18,0)	SI
5	PARTYSITENUMBER	VARCHAR2(30)	SI
6	PARTYSITENAME	VARCHAR2(240)	SI
7	PARTYSITETYPE	VARCHAR2(30)	SI
8	PARTYUSAGECODE	VARCHAR2(30)	SI
9	IDENTIFYINGADDRESSFLAG	VARCHAR2(1)	SI
10	STATUS	VARCHAR2(1)	SI
11	STARTDATEACTIVE	DATE	SI
12	ENDDATEACTIVE	DATE	SI
13	ORIGSYSTEMREFERENCE	VARCHAR2(240)	SI
14	RELATIONSHIPID	NUMBER(18,0)	SI
15	LOCATIONPEOLOCATIONID	NUMBER(18,0)	SI
16	LOCATIONPEOADDRESS1	VARCHAR2(240)	SI
17	LOCATIONPEOCITY	VARCHAR2(60)	SI
18	LOCATIONPEOSTATE	VARCHAR2(60)	SI
19	LOCATIONPEOCOUNTRY	VARCHAR2(2)	SI
20	LOCATIONPEOSTATUSFLAG	VARCHAR2(1)	SI
21	LOCATIONPEOVALIDATEDFLAG	VARCHAR2(1)	SI
22	CREATIONDATE	TIMESTAMP(6)	SI
23	LASTUPDATEDATE	TIMESTAMP(6)	SI
24	PARTYPEOPARTYID	NUMBER(18,0)	SI
25	SITETYPES	VARCHAR2(400)	SI
26	CREATEDBY	VARCHAR2(64)	SI
27	LASTUPDATEDBY	VARCHAR2(64)	SI
28	LOCATIONPEOCREATIONDATE	TIMESTAMP(6)	SI
29	LOCATIONPEOLASTUPDATEDATE	TIMESTAMP(6)	SI
30	AUDIT_ID	NUMBER	NO
31	ROW_ACTIVE	CHAR(1)	NO	‘A’
32	DIM_CUSTOMER_AR_ID	NUMBER	SI
33	DIM_LACSCUSTOMER_AR_ID	NUMBER	SI

Restricciones

CHECK: DIM_SITECUSTOMER_AR_CK

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

CHECK: SYS_C00304875

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

CHECK: SYS_C00304876

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

CHECK: SYS_C00304877

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

CHECK: SYS_C00304878

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

PK: DIM_SITECUSTOMER_AR_PK

Estado: ENABLED
Columnas: SITECUSTOMER_AR_ID

FK: DIM_SITECUSTOMER_AR_DIM_CUSTOMER_AR_FK

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

FK: DIM_SITECUSTOMER_AR_DIM_LACSCUSTOMER_AR_FK

Estado: ENABLED
Columnas: DIM_LACSCUSTOMER_AR_ID
Referencia: DWADW.DIM_LACSCUSTOMER_AR (constraint DIM_LACSCUSTOMER_AR_PK)

UK: DIM_SITECUSTOMER_AR__UN

Estado: ENABLED
Columnas: PARTYSITEID

DDL

CREATE TABLE "DWADW"."DIM_SITECUSTOMER_AR" 
   (	"SITECUSTOMER_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, 
	"PARTYSITEID" NUMBER(18,0) NOT NULL ENABLE, 
	"PARTYID" NUMBER(18,0), 
	"LOCATIONID" NUMBER(18,0), 
	"PARTYSITENUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PARTYSITENAME" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"PARTYSITETYPE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"PARTYUSAGECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"IDENTIFYINGADDRESSFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"STATUS" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"STARTDATEACTIVE" DATE, 
	"ENDDATEACTIVE" DATE, 
	"ORIGSYSTEMREFERENCE" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"RELATIONSHIPID" NUMBER(18,0), 
	"LOCATIONPEOLOCATIONID" NUMBER(18,0), 
	"LOCATIONPEOADDRESS1" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"LOCATIONPEOCITY" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"LOCATIONPEOSTATE" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"LOCATIONPEOCOUNTRY" VARCHAR2(2) COLLATE "USING_NLS_COMP", 
	"LOCATIONPEOSTATUSFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"LOCATIONPEOVALIDATEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" TIMESTAMP (6), 
	"LASTUPDATEDATE" TIMESTAMP (6), 
	"PARTYPEOPARTYID" NUMBER(18,0), 
	"SITETYPES" VARCHAR2(400) COLLATE "USING_NLS_COMP", 
	"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"LOCATIONPEOCREATIONDATE" TIMESTAMP (6), 
	"LOCATIONPEOLASTUPDATEDATE" TIMESTAMP (6), 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_CUSTOMER_AR_ID" NUMBER, 
	"DIM_LACSCUSTOMER_AR_ID" NUMBER, 
	 CONSTRAINT "DIM_SITECUSTOMER_AR_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_SITECUSTOMER_AR_PK" PRIMARY KEY ("SITECUSTOMER_AR_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_SITECUSTOMER_AR__UN" UNIQUE ("PARTYSITEID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_SITECUSTOMER_AR_DIM_CUSTOMER_AR_FK" FOREIGN KEY ("DIM_CUSTOMER_AR_ID")
	  REFERENCES "DWADW"."DIM_CUSTOMER_AR" ("CUSTOMER_AR_ID") ENABLE, 
	 CONSTRAINT "DIM_SITECUSTOMER_AR_DIM_LACSCUSTOMER_AR_FK" FOREIGN KEY ("DIM_LACSCUSTOMER_AR_ID")
	  REFERENCES "DWADW"."DIM_LACSCUSTOMER_AR" ("LACSCUSTOMER_AR_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_SITECUSTOMER_AR"  IS 'Español: Catálogo de sitios y ubicaciones asociados a clientes. Contiene identificadores del cliente y sitio, dirección, ciudad, provincia, país, estado y vigencia, y permite identificar los lugares utilizados para entrega, facturación y análisis geográfico.
English: Catalog of customer sites and locations. It contains customer and site identifiers, address, city, state, country, status, and effective dates and supports identification of locations used for delivery, billing, and geographic analysis.';

CREATE UNIQUE INDEX "DWADW"."DIM_SITECUSTOMER_AR_PK" ON "DWADW"."DIM_SITECUSTOMER_AR" ("SITECUSTOMER_AR_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_SITECUSTOMER_AR__UN" ON "DWADW"."DIM_SITECUSTOMER_AR" ("PARTYSITEID") 
  ;
  CREATE INDEX "DWADW"."IDX_SITECUST_TRACKING_OM" ON "DWADW"."DIM_SITECUSTOMER_AR" ("PARTYID", "LOCATIONID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal