Saltar al contenido

xpms.dim_record_subtype

TablaSeguridad a nivel de fila activa

The 124 kind-scoped record subtypes (Bible tab 25). The composite key lets a record carry a subtype only for its own kind.

Clave primaria: record_kind, record_subtype

Columnas de xpms.dim_record_subtype
ColumnaTipoAdmite nulosDescripción
record_kindxpms.canon_textNoKind the subtype belongs to.Hace referencia a xpms.dim_record_kind.record_kind
record_subtypexpms.canon_textNoSubtype label.
ordinalintegerNoPosition of the subtype in its Bible tab; the canonical display order where the code is not numeric.
unspsc_segmentxpms.canon_textSíUNSPSC segment and its title, where canon gives one.