Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_INVORGPARAMETERS_OM
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena información de las organizaciones de inventario, incluyendo código, unidad de negocio, entidad legal, organización maestra English: Stores inventory organization information, including organization code, business unit, legal entity, master organization
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ORGANIZATIONID | NUMBER(18,0) | NO | ||
| 2 | ORGANIZATIONCODE | VARCHAR2(18) | SI | ||
| 3 | BUSINESSUNITID | NUMBER(18,0) | SI | ||
| 4 | PROFITCENTERBUID | NUMBER(18,0) | SI | ||
| 5 | LEGALENTITYID | NUMBER(18,0) | SI | ||
| 6 | MASTERORGANIZATIONID | NUMBER(18,0) | SI | ||
| 7 | ITEMDEFINITIONORGID | NUMBER(18,0) | SI | ||
| 8 | SOURCEORGANIZATIONID | NUMBER(18,0) | SI | ||
| 9 | PARTYID | NUMBER(18,0) | SI | ||
| 10 | INVENTORYFLAG | VARCHAR2(1) | SI | ||
| 11 | MFGPLANTFLAG | VARCHAR2(1) | SI | ||
| 12 | CREATIONDATE | TIMESTAMP(6) | SI | ||
| 13 | LASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 14 | LASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 15 | OBJECTVERSIONNUMBER | NUMBER(9,0) | SI | ||
| 16 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00286293
- Estado: ENABLED
- Columnas: ORGANIZATIONID
- Condición:
"ORGANIZATIONID" IS NOT NULL
CHECK: SYS_C00286294
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_INVORGPARAMETERS_OM"
( "ORGANIZATIONID" NUMBER(18,0) NOT NULL ENABLE,
"ORGANIZATIONCODE" VARCHAR2(18) COLLATE "USING_NLS_COMP",
"BUSINESSUNITID" NUMBER(18,0),
"PROFITCENTERBUID" NUMBER(18,0),
"LEGALENTITYID" NUMBER(18,0),
"MASTERORGANIZATIONID" NUMBER(18,0),
"ITEMDEFINITIONORGID" NUMBER(18,0),
"SOURCEORGANIZATIONID" NUMBER(18,0),
"PARTYID" NUMBER(18,0),
"INVENTORYFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"MFGPLANTFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"CREATIONDATE" TIMESTAMP (6),
"LASTUPDATEDATE" TIMESTAMP (6),
"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"OBJECTVERSIONNUMBER" NUMBER(9,0),
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "STADW"."ST_INVORGPARAMETERS_OM" IS 'Español: Almacena información de las organizaciones de inventario, incluyendo código, unidad de negocio, entidad legal, organización maestra
English: Stores inventory organization information, including organization code, business unit, legal entity, master organization';
CREATE INDEX "STADW"."ST_INVORGPARAMETERS_ID_IDX" ON "STADW"."ST_INVORGPARAMETERS_OM" ("ORGANIZATIONID")
;