Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_SITEUSECUSTOMER_AR
Base de datos origen: ADW COEXITO
Descripción: Español: Catálogo de usos de sitio del cliente como facturación, envío y cobranza dentro del proceso comercial. English: Customer site use catalog for billing, shipping, and collection purposes within the commercial process.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | SITEUSECUSTOMER_AR_ID | NUMBER | NO | “DWADW”.”ISEQ$$_306883”.nextval | |
| 2 | SITEUSEID | NUMBER | NO | ||
| 3 | SITEUSECODE | VARCHAR2(50) | SI | ||
| 4 | LOCATIONID | NUMBER | NO | ||
| 5 | PARTYSITEID | NUMBER | NO | ||
| 6 | STATUS | VARCHAR2(50) | SI | ||
| 7 | AUDIT_ID | NUMBER | NO | ||
| 8 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ | |
| 9 | DIM_CUSTOMER_AR_ID | NUMBER | SI | ||
| 10 | DIM_LACSCUSTOMER_AR_ID | NUMBER | SI |
Restricciones
CHECK: DIM_SITEUSECUSTOMER_AR_AI_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00202840
- Estado: ENABLED
- Columnas: SITEUSECUSTOMER_AR_ID
- Condición:
"SITEUSECUSTOMER_AR_ID" IS NOT NULL
CHECK: SYS_C00202841
- Estado: ENABLED
- Columnas: SITEUSEID
- Condición:
"SITEUSEID" IS NOT NULL
CHECK: SYS_C00202842
- Estado: ENABLED
- Columnas: LOCATIONID
- Condición:
"LOCATIONID" IS NOT NULL
CHECK: SYS_C00202843
- Estado: ENABLED
- Columnas: PARTYSITEID
- Condición:
"PARTYSITEID" IS NOT NULL
CHECK: SYS_C00202844
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00202845
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: DIM_SITEUSECUSTOMER_AR_PK
- Estado: ENABLED
- Columnas: SITEUSECUSTOMER_AR_ID
FK: DIM_SITEUSECUSTOMER_AR_DIM_CUSTOMER_AR_FK
- Estado: ENABLED
- Columnas: DIM_CUSTOMER_AR_ID
- Referencia: DWADW.DIM_CUSTOMER_AR (constraint DIM_CUSTOMER_AR_PK)
FK: DIM_SITEUSECUSTOMER_AR_DIM_LACSCUSTOMER_AR_FK
- Estado: ENABLED
- Columnas: DIM_LACSCUSTOMER_AR_ID
- Referencia: DWADW.DIM_LACSCUSTOMER_AR (constraint DIM_LACSCUSTOMER_AR_PK)
UK: DIM_SITEUSECUSTOMER_AR_LOCATION_PARTY_SITE_UN
- Estado: ENABLED
- Columnas: LOCATIONID, PARTYSITEID, SITEUSEID
DDL
CREATE TABLE "DWADW"."DIM_SITEUSECUSTOMER_AR"
( "SITEUSECUSTOMER_AR_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"SITEUSEID" NUMBER NOT NULL ENABLE,
"SITEUSECODE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LOCATIONID" NUMBER NOT NULL ENABLE,
"PARTYSITEID" NUMBER NOT NULL ENABLE,
"STATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"AUDIT_ID" NUMBER NOT NULL ENABLE,
"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE,
"DIM_CUSTOMER_AR_ID" NUMBER,
"DIM_LACSCUSTOMER_AR_ID" NUMBER,
CONSTRAINT "DIM_SITEUSECUSTOMER_AR_AI_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "DIM_SITEUSECUSTOMER_AR_PK" PRIMARY KEY ("SITEUSECUSTOMER_AR_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_SITEUSECUSTOMER_AR_LOCATION_PARTY_SITE_UN" UNIQUE ("LOCATIONID", "PARTYSITEID", "SITEUSEID")
USING INDEX ENABLE,
CONSTRAINT "DIM_SITEUSECUSTOMER_AR_DIM_CUSTOMER_AR_FK" FOREIGN KEY ("DIM_CUSTOMER_AR_ID")
REFERENCES "DWADW"."DIM_CUSTOMER_AR" ("CUSTOMER_AR_ID") ENABLE,
CONSTRAINT "DIM_SITEUSECUSTOMER_AR_DIM_LACSCUSTOMER_AR_FK" FOREIGN KEY ("DIM_LACSCUSTOMER_AR_ID")
REFERENCES "DWADW"."DIM_LACSCUSTOMER_AR" ("LACSCUSTOMER_AR_ID") ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_SITEUSECUSTOMER_AR" IS 'Español: Catálogo de usos de sitio del cliente como facturación, envío y cobranza dentro del proceso comercial.
English: Customer site use catalog for billing, shipping, and collection purposes within the commercial process.';
CREATE UNIQUE INDEX "DWADW"."DIM_SITEUSECUSTOMER_AR_PK" ON "DWADW"."DIM_SITEUSECUSTOMER_AR" ("SITEUSECUSTOMER_AR_ID")
;
CREATE UNIQUE INDEX "DWADW"."DIM_SITEUSECUSTOMER_AR_LOCATION_PARTY_SITE_UN" ON "DWADW"."DIM_SITEUSECUSTOMER_AR" ("LOCATIONID", "PARTYSITEID", "SITEUSEID")
;