Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_ORGANIZATIONCUSTOMER_AR
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena la información de organizaciones asociadas a clientes, incluyendo identificación del cliente, perfil de organización, ubicación, sitio, dirección, información de contacto, vigencia y datos de auditoría. El perfil de organización se identifica mediante ORGANIZATIONPROFILEID y utiliza ORGANIZATIONPROFILEPEOLASTUPDATEDATE como campo de actualización incremental. English: Stores organization information associated with customers, including customer identification, organization profile, location, site, address, contact information, effective dates, and audit data. The organization profile is identified by ORGANIZATIONPROFILEID and uses ORGANIZATIONPROFILEPEOLASTUPDATEDATE as the incremental update field.
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_C00295251
- Estado: ENABLED
- Columnas: ORGANIZATIONPROFILEID
- Condición:
"ORGANIZATIONPROFILEID" IS NOT NULL
CHECK: SYS_C00295252
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_ORGANIZATIONCUSTOMER_AR"
( "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" ;
COMMENT ON TABLE "STADW"."ST_ORGANIZATIONCUSTOMER_AR" IS 'Español: Almacena la información de organizaciones asociadas a clientes, incluyendo identificación del cliente, perfil de organización, ubicación, sitio, dirección, información de contacto, vigencia y datos de auditoría. El perfil de organización se identifica mediante ORGANIZATIONPROFILEID y utiliza ORGANIZATIONPROFILEPEOLASTUPDATEDATE como campo de actualización incremental.
English: Stores organization information associated with customers, including customer identification, organization profile, location, site, address, contact information, effective dates, and audit data. The organization profile is identified by ORGANIZATIONPROFILEID and uses ORGANIZATIONPROFILEPEOLASTUPDATEDATE as the incremental update field.';
CREATE INDEX "STADW"."ORGANIZATIONCUSTOMER_AR_IDX" ON "STADW"."ST_ORGANIZATIONCUSTOMER_AR" ("ORGANIZATIONPROFILEID")
;