DWADW.DIM_SALESREP_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de vendedores y representantes comerciales. Contiene identificadores, código y nombre del vendedor, información de contacto, estado y vigencia, y permite asociar las ventas y órdenes con el responsable comercial. English: Sales representative catalog. It contains identifiers, salesperson code and name, contact information, status, and effective dates and supports associating sales and orders with the responsible sales representative.

Columnas

#	Columna	Tipo	Nulo	Default
1	SALESREP_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378164”.nextval
2	EMAILADDRESS	VARCHAR2(320)	SI
3	ENDDATEACTIVE	DATE	SI
4	PARTYID	NUMBER(18,0)	SI
5	PARTYNAME	VARCHAR2(360)	SI
6	PARTYPEOLASTUPDATEDATE	TIMESTAMP(6)	SI
7	PRIMARYPHONENUMBER	VARCHAR2(40)	SI
8	RESOURCEID	NUMBER	SI
9	RESOURCESALESREPID	NUMBER(18,0)	NO
10	RESOURCESALESREPPEOLASTUPDATEDATE	TIMESTAMP(6)	SI
11	RESOURCESALESREPPEOSTATUS	VARCHAR2(30)	SI
12	SALESCREDITTYPEID	NUMBER	SI
13	SALESCREDITTYPENAME	VARCHAR2(240)	SI
14	SALESREPNUMBER	VARCHAR2(30)	SI
15	STARTDATEACTIVE	DATE	SI
16	ROW_ACTIVE	CHAR(1)	NO	‘A’
17	AUDIT_ID	NUMBER	NO

Restricciones

CHECK: DIM_SALESREP_OM_CK

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

CHECK: SYS_C00304868

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

CHECK: SYS_C00304869

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

CHECK: SYS_C00304870

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

CHECK: SYS_C00304871

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

PK: DIM_SALESREP_OM_PK

Estado: ENABLED
Columnas: SALESREP_OM_ID

UK: DIM_SALESREP_OM__UN

Estado: ENABLED
Columnas: RESOURCESALESREPID

DDL

CREATE TABLE "DWADW"."DIM_SALESREP_OM" 
   (	"SALESREP_OM_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, 
	"EMAILADDRESS" VARCHAR2(320) COLLATE "USING_NLS_COMP", 
	"ENDDATEACTIVE" DATE, 
	"PARTYID" NUMBER(18,0), 
	"PARTYNAME" VARCHAR2(360) COLLATE "USING_NLS_COMP", 
	"PARTYPEOLASTUPDATEDATE" TIMESTAMP (6), 
	"PRIMARYPHONENUMBER" VARCHAR2(40) COLLATE "USING_NLS_COMP", 
	"RESOURCEID" NUMBER, 
	"RESOURCESALESREPID" NUMBER(18,0) NOT NULL ENABLE, 
	"RESOURCESALESREPPEOLASTUPDATEDATE" TIMESTAMP (6), 
	"RESOURCESALESREPPEOSTATUS" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"SALESCREDITTYPEID" NUMBER, 
	"SALESCREDITTYPENAME" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"SALESREPNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"STARTDATEACTIVE" DATE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "DIM_SALESREP_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_SALESREP_OM_PK" PRIMARY KEY ("SALESREP_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_SALESREP_OM__UN" UNIQUE ("RESOURCESALESREPID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_SALESREP_OM"  IS 'Español: Catálogo de vendedores y representantes comerciales. Contiene identificadores, código y nombre del vendedor, información de contacto, estado y vigencia, y permite asociar las ventas y órdenes con el responsable comercial.
English: Sales representative catalog. It contains identifiers, salesperson code and name, contact information, status, and effective dates and supports associating sales and orders with the responsible sales representative.';

CREATE UNIQUE INDEX "DWADW"."DIM_SALESREP_OM_PK" ON "DWADW"."DIM_SALESREP_OM" ("SALESREP_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_SALESREP_OM__UN" ON "DWADW"."DIM_SALESREP_OM" ("RESOURCESALESREPID") 
  ;
  CREATE INDEX "DWADW"."IDX_SALESREP_TRACKING_OM" ON "DWADW"."DIM_SALESREP_OM" ("RESOURCEID", "RESOURCESALESREPPEOLASTUPDATEDATE") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal