xpms.v_sheet_procurement_catalog
Vista
The Playbook Procurement Catalog sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| source_row | integer | Sí | Row number in the source sheet. |
| item_id | text | Sí | ITEM ID (column A), field. |
| urid | text | Sí | URID (column B), field. |
| item_name | text | Sí | ITEM NAME (column C), field. |
| resource_kind | text | Sí | RESOURCE KIND (column D), field. |
| schema_family_xyz | text | Sí | SCHEMA FAMILY (XYZ) (column E), field. |
| default_gl_account | text | Sí | DEFAULT GL ACCOUNT (column F), field. |
| default_gl_name | text | Sí | DEFAULT GL NAME (column G), field. |
| default_cost_center | text | Sí | DEFAULT COST CENTER (column H), field. |
| unit_of_measure | text | Sí | UNIT OF MEASURE (column I), field. |
| grade_1_basic_low | text | Sí | GRADE 1 BASIC ($ LOW) (column J), field. |
| grade_2_standard_cost | text | Sí | GRADE 2 STANDARD ($ COST) (column K), field. |
| grade_3_premium_high | text | Sí | GRADE 3 PREMIUM ($ HIGH) (column L), field. |
| description | text | Sí | DESCRIPTION (column M), field. |
| specifications | text | Sí | SPECIFICATIONS (column N), field. |
| lead_time_hrs | text | Sí | LEAD TIME (HRS) (column O), field. |
| tier | text | Sí | TIER (column P), field. |
| default_phase | text | Sí | DEFAULT PHASE (column Q), field. |
| external_ref | text | Sí | EXTERNAL REF (column R), field. |