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