Skip to content

xpms.production_template_metadata

TableRow level security on

Cover Page cells: the template's metadata, at their source row and column. A formula cell keeps its evaluated value beside its formula.

Primary key: template_code, source_row, column_ordinal

Columns of xpms.production_template_metadata
ColumnTypeNullableDescription
template_codexpms.canon_codeNoTemplate.References xpms.production_template.template_code
source_rowintegerNoCover Page row.
column_ordinalintegerNoCover Page column, 1 for A.
value_textxpms.canon_textYesValue in lossless text form; NULL for a formula that evaluates to nothing.
value_kindxpms.canon_codeNoKind of the value: string, number, boolean, date, datetime, time or empty.
formulaxpms.canon_textYesFormula source, for a formula cell.