Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_ORGANIZATIONCUSTOMER_AR_TMP_34971
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ORGANIZATIONPROFILEID | NUMBER(18,0) | NO | ||
| 2 | PARTYID | NUMBER(18,0) | SI | ||
| 3 | PARTYPEOPARTYID | NUMBER(18,0) | SI | ||
| 4 | PARTYNUMBER | VARCHAR2(30) | SI | ||
| 5 | PARTYNAME | VARCHAR2(360) | SI | ||
| 6 | PARTYUNIQUENAME | VARCHAR2(900) | SI | ||
| 7 | PARTYTYPE | VARCHAR2(30) | SI | ||
| 8 | ORGANIZATIONNAME | VARCHAR2(360) | SI | ||
| 9 | STATUS | VARCHAR2(1) | SI | ||
| 10 | JGZZFISCALCODE | VARCHAR2(20) | SI | ||
| 11 | ORIGSYSTEMREFERENCE | VARCHAR2(240) | SI | ||
| 12 | IDENADDRLOCATIONID | NUMBER(18,0) | SI | ||
| 13 | IDENADDRPARTYSITEID | NUMBER(18,0) | SI | ||
| 14 | ADDRESS1 | VARCHAR2(240) | SI | ||
| 15 | CITY | VARCHAR2(60) | SI | ||
| 16 | STATE | VARCHAR2(60) | SI | ||
| 17 | COUNTRY | VARCHAR2(2) | SI | ||
| 18 | EMAILADDRESS | VARCHAR2(320) | SI | ||
| 19 | PRIMARYPHONECOUNTRYCODE | VARCHAR2(10) | SI | ||
| 20 | PRIMARYPHONENUMBER | VARCHAR2(40) | SI | ||
| 21 | EFFECTIVESTARTDATE | DATE | SI | ||
| 22 | EFFECTIVEENDDATE | DATE | SI | ||
| 23 | EFFECTIVELATESTCHANGE | VARCHAR2(1) | SI | ||
| 24 | EFFECTIVESEQUENCE | NUMBER(4,0) | SI | ||
| 25 | PARTYPEOCREATIONDATE | TIMESTAMP(6) | SI | ||
| 26 | PARTYPEOLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 27 | ORGANIZATIONPROFILEPEOCREATIONDATE | TIMESTAMP(6) | SI | ||
| 28 | ORGANIZATIONPROFILEPEOLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 29 | IDMAESTROCARGUE | NUMBER | NO | ||
| 30 | PARTYPEOCREATEDBY | VARCHAR2(64) | SI | ||
| 31 | PARTYPEOLASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 32 | ORGANIZATIONPROFILEPEOCREATEDBY | VARCHAR2(64) | SI | ||
| 33 | ORGANIZATIONPROFILEPEOLASTUPDATEDBY | VARCHAR2(64) | SI |
Restricciones
CHECK: SYS_C00333495
- Estado: ENABLED
- Columnas: ORGANIZATIONPROFILEID
- Condición:
"ORGANIZATIONPROFILEID" IS NOT NULL
CHECK: SYS_C00333496
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_ORGANIZATIONCUSTOMER_AR_TMP_34971"
( "ORGANIZATIONPROFILEID" NUMBER(18,0) NOT NULL ENABLE,
"PARTYID" NUMBER(18,0),
"PARTYPEOPARTYID" NUMBER(18,0),
"PARTYNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"PARTYNAME" VARCHAR2(360) COLLATE "USING_NLS_COMP",
"PARTYUNIQUENAME" VARCHAR2(900) COLLATE "USING_NLS_COMP",
"PARTYTYPE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"ORGANIZATIONNAME" VARCHAR2(360) COLLATE "USING_NLS_COMP",
"STATUS" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"JGZZFISCALCODE" VARCHAR2(20) COLLATE "USING_NLS_COMP",
"ORIGSYSTEMREFERENCE" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"IDENADDRLOCATIONID" NUMBER(18,0),
"IDENADDRPARTYSITEID" NUMBER(18,0),
"ADDRESS1" VARCHAR2(240) COLLATE "USING_NLS_COMP",
"CITY" VARCHAR2(60) COLLATE "USING_NLS_COMP",
"STATE" VARCHAR2(60) COLLATE "USING_NLS_COMP",
"COUNTRY" VARCHAR2(2) COLLATE "USING_NLS_COMP",
"EMAILADDRESS" VARCHAR2(320) COLLATE "USING_NLS_COMP",
"PRIMARYPHONECOUNTRYCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP",
"PRIMARYPHONENUMBER" VARCHAR2(40) COLLATE "USING_NLS_COMP",
"EFFECTIVESTARTDATE" DATE,
"EFFECTIVEENDDATE" DATE,
"EFFECTIVELATESTCHANGE" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"EFFECTIVESEQUENCE" NUMBER(4,0),
"PARTYPEOCREATIONDATE" TIMESTAMP (6),
"PARTYPEOLASTUPDATEDATE" TIMESTAMP (6),
"ORGANIZATIONPROFILEPEOCREATIONDATE" TIMESTAMP (6),
"ORGANIZATIONPROFILEPEOLASTUPDATEDATE" TIMESTAMP (6),
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE,
"PARTYPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"PARTYPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"ORGANIZATIONPROFILEPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"ORGANIZATIONPROFILEPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;