xpms.v_sheet_document_asset_library

Vista

The Playbook Document & Asset Library sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_document_asset_library
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
record_id	xpms.canon_text	Sí	RECORD ID (column A), field.
document_name	xpms.canon_text	Sí	DOCUMENT NAME (column B), field.
document_type	xpms.canon_text	Sí	DOCUMENT TYPE (column C), field.
reference_id	xpms.canon_text	Sí	REFERENCE ID (column D), field.
organization	xpms.canon_text	Sí	ORGANIZATION (column E), field.
project	xpms.canon_text	Sí	PROJECT (column F), field.
department	xpms.canon_text	Sí	DEPARTMENT (column G), field.
category	xpms.canon_text	Sí	CATEGORY (column H), field.
sub_category	xpms.canon_text	Sí	SUB CATEGORY (column I), field.
file_format	xpms.canon_text	Sí	FILE FORMAT (column J), field.
file_size	xpms.canon_text	Sí	FILE SIZE (column K), field.
storage_url	xpms.canon_text	Sí	STORAGE URL (column L), field.
version	xpms.canon_text	Sí	VERSION (column M), field.
issue_date	date	Sí	ISSUE DATE (column N), field.
expiration_date	date	Sí	EXPIRATION DATE (column O), field.
status	xpms.canon_text	Sí	STATUS (column P), field.
flag	boolean	Sí	FLAG (column Q), field.
notes	xpms.canon_text	Sí	NOTES (column R), field.
created_by	xpms.canon_text	Sí	CREATED BY (column S), field.
created_at	timestamp without time zone	Sí	CREATED AT (column T), field.
updated_at	timestamp without time zone	Sí	UPDATED AT (column U), field.