xpms.v_sheet_advance_requests
Vista
The Playbook Advance Requests 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. |
| record_id | text | Sí | RECORD ID (column A), field. |
| organization | text | Sí | ORGANIZATION (column B), field. |
| project_id | text | Sí | PROJECT ID (column C), field. |
| department | text | Sí | DEPARTMENT (column D), field. |
| category | text | Sí | CATEGORY (column E), field. |
| sub_category | text | Sí | SUB CATEGORY (column F), field. |
| vendor_id | text | Sí | VENDOR ID (column G), field. |
| item | text | Sí | ITEM (column H), field. |
| description | text | Sí | DESCRIPTION (column I), field. |
| urid | text | Sí | URID (column J), field. |
| quantity | text | Sí | QUANTITY (column K), field. |
| unit_basis | text | Sí | UNIT BASIS (column L), field. |
| estimate_rate | text | Sí | ESTIMATE RATE (column M), field. |
| total_estimate | text | Sí | TOTAL ESTIMATE (column N), field. |
| location_id | text | Sí | LOCATION ID (column O), field. |
| needed_by_date | text | Sí | NEEDED BY DATE (column P), field. |
| requested_by | text | Sí | REQUESTED BY (column Q), field. |
| approver_role | text | Sí | APPROVER ROLE (column R), field. |
| approval_date | text | Sí | APPROVAL DATE (column S), field. |
| po_number | text | Sí | PO NUMBER (column T), field. |
| status | text | Sí | STATUS (column U), field. |
| flag | text | Sí | FLAG (column V), field. |
| notes | text | Sí | NOTES (column W), field. |
| created_by | text | Sí | CREATED BY (column X), field. |
| created_at | text | Sí | CREATED AT (column Y), field. |
| updated_at | text | Sí | UPDATED AT (column Z), field. |