Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SALESREP_OM
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena información de los representantes de ventas. Contiene información del representante, recurso asociado, datos de contacto, estado, tipo de crédito de ventas y fechas de vigencia para la gestión y análisis de la fuerza comercial. English: Stores sales representative information. It contains representative details, associated resource, contact information, status, sales credit type, and effective dates for sales force management and analysis.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | EMAILADDRESS | VARCHAR2(320) | SI | ||
| 2 | ENDDATEACTIVE | DATE | SI | ||
| 3 | PARTYID | NUMBER(18,0) | SI | ||
| 4 | PARTYNAME | VARCHAR2(360) | SI | ||
| 5 | PARTYPEOLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 6 | PRIMARYPHONENUMBER | VARCHAR2(40) | SI | ||
| 7 | RESOURCEID | NUMBER | SI | ||
| 8 | RESOURCESALESREPID | NUMBER(18,0) | NO | ||
| 9 | RESOURCESALESREPPEOLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 10 | RESOURCESALESREPPEOSTATUS | VARCHAR2(30) | SI | ||
| 11 | SALESCREDITTYPEID | NUMBER | SI | ||
| 12 | SALESCREDITTYPENAME | VARCHAR2(240) | SI | ||
| 13 | SALESREPNUMBER | VARCHAR2(30) | SI | ||
| 14 | STARTDATEACTIVE | DATE | SI | ||
| 15 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00284985
- Estado: ENABLED
- Columnas: RESOURCESALESREPID
- Condición:
"RESOURCESALESREPID" IS NOT NULL
CHECK: SYS_C00284986
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_SALESREP_OM"
( "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,
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "STADW"."ST_SALESREP_OM" IS 'Español: Almacena información de los representantes de ventas. Contiene información del representante, recurso asociado, datos de contacto, estado, tipo de crédito de ventas y fechas de vigencia para la gestión y análisis de la fuerza comercial.
English: Stores sales representative information. It contains representative details, associated resource, contact information, status, sales credit type, and effective dates for sales force management and analysis.';
CREATE INDEX "STADW"."SALESREPRESOURCE_ID_IDX" ON "STADW"."ST_SALESREP_OM" ("RESOURCESALESREPID")
;