Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SITECUSTOMER_AR_TMP_27301
Base de datos origen: ADW COEXITO
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_C00295315
- Estado: ENABLED
- Columnas: PARTYSITEID
- Condición:
"PARTYSITEID" IS NOT NULL
CHECK: SYS_C00295316
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_SITECUSTOMER_AR_TMP_27301"
( "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" ;