Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SITECUSTOMER_AR
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena la información de los sitios asociados a clientes, incluyendo la relación entre cliente, sitio y ubicación, datos de dirección, ciudad, provincia, estado, país, código postal, coordenadas geográficas, estado, vigencia y datos de auditoría. El sitio se identifica mediante PARTYSITEID y utiliza LASTUPDATEDATE como campo de actualización incremental. English: Stores customer site information, including the relationship between customer, site, and location, address, city, province, state, country, postal code, geographic coordinates, status, effective dates, and audit data. The site is identified by PARTYSITEID and uses LASTUPDATEDATE as the incremental update field.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | PARTYSITEID | NUMBER(18,0) | NO | ||
| 2 | PARTYID | NUMBER(18,0) | SI | ||
| 3 | LOCATIONID | NUMBER(18,0) | SI | ||
| 4 | PARTYSITENUMBER | VARCHAR2(30) | SI | ||
| 5 | PARTYSITENAME | VARCHAR2(240) | SI | ||
| 6 | PARTYSITETYPE | VARCHAR2(30) | SI | ||
| 7 | PARTYUSAGECODE | VARCHAR2(30) | SI | ||
| 8 | IDENTIFYINGADDRESSFLAG | VARCHAR2(1) | SI | ||
| 9 | STATUS | VARCHAR2(1) | SI | ||
| 10 | STARTDATEACTIVE | DATE | SI | ||
| 11 | ENDDATEACTIVE | DATE | SI | ||
| 12 | ORIGSYSTEMREFERENCE | VARCHAR2(240) | SI | ||
| 13 | RELATIONSHIPID | NUMBER(18,0) | SI | ||
| 14 | LOCATIONPEOLOCATIONID | NUMBER(18,0) | SI | ||
| 15 | LOCATIONPEOADDRESS1 | VARCHAR2(240) | SI | ||
| 16 | LOCATIONPEOCITY | VARCHAR2(60) | SI | ||
| 17 | LOCATIONPEOSTATE | VARCHAR2(60) | SI | ||
| 18 | LOCATIONPEOCOUNTRY | VARCHAR2(2) | SI | ||
| 19 | LOCATIONPEOSTATUSFLAG | VARCHAR2(1) | SI | ||
| 20 | LOCATIONPEOVALIDATEDFLAG | VARCHAR2(1) | SI | ||
| 21 | CREATIONDATE | TIMESTAMP(6) | SI | ||
| 22 | LASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 23 | IDMAESTROCARGUE | NUMBER | NO | ||
| 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 |
Restricciones
CHECK: SYS_C00295249
- Estado: ENABLED
- Columnas: PARTYSITEID
- Condición:
"PARTYSITEID" IS NOT NULL
CHECK: SYS_C00295250
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_SITECUSTOMER_AR"
( "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),
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE,
"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)
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "STADW"."ST_SITECUSTOMER_AR" IS 'Español: Almacena la información de los sitios asociados a clientes, incluyendo la relación entre cliente, sitio y ubicación, datos de dirección, ciudad, provincia, estado, país, código postal, coordenadas geográficas, estado, vigencia y datos de auditoría. El sitio se identifica mediante PARTYSITEID y utiliza LASTUPDATEDATE como campo de actualización incremental.
English: Stores customer site information, including the relationship between customer, site, and location, address, city, province, state, country, postal code, geographic coordinates, status, effective dates, and audit data. The site is identified by PARTYSITEID and uses LASTUPDATEDATE as the incremental update field.';
CREATE INDEX "STADW"."SITECUSTOMER_AR_IDX" ON "STADW"."ST_SITECUSTOMER_AR" ("PARTYSITEID")
;