ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData ODBC Driver for SAP Fieldglass ビュー
| Name | Description |
| ActiveWorkers | Retrieve all active workers using the Active Worker Download connector. |
| ActiveWorkersSingleLine | Retrieve all active workers using the Active Worker Single Line Download connector. |
| ActiveWorkOrderProfileWorkers | Retrieve all active work orders including profile workers using the Active Work Order Profile Worker Download connector. |
| ActiveWorkOrders | Retrieve all active work orders using the Active Work Order Download connector. |
| Approvals | Query this table for approvals in SAPFieldglass. |
| ApprovedExpenseSheets | Retrieve approved expense sheets using the Approved Expense Sheet Download connector. |
| ApprovedTimeSheets | Retrieve all approved time sheets using the Approved Time Sheet Download connector. |
| Assignments | Retrieve all active assignments using the Assignment Download connector. |
| AuditTrails | Query this table for audit trails in SAPFieldglass. |
| BusinessUnits | Retrieve business units using the Business Unit Download connector. |
| CATSTimeSheets | Retrieve all time sheets entered in SAP CATS (Cross-Application Time Sheet) that are now in Draft, Rejected, and/or Pending Approval status within a provided parameter using the CATS Time Sheet Download connector. |
| CostCenters | Retrieve cost centers using the Cost Center Download connector. |
| DistributionLists | Retrieve distribution lists using the Distribution List Download connector. |
| DraftRejectedTimeSheets | Retrieve all time sheets in draft/rejected approval status using the Draft Rejected Time Sheet Download connector. |
| DraftTimeSheets | Retrieve all time sheets in Draft status using the Draft Time Sheet Download connector. |
| Locations | Retrieve locations using the Location Download connector. |
| RateCategories | Retrieve rate categories using the Rate Category Download connector. |
| RateCodes | Retrieve rate codes using the Rate Code Download connector. |
| RateComponentGroups | Retrieve rate component groups using the Rate Component Group Download connector. |
| RateComponents | Retrieve rate components using the Rate Component Download connector. |
| RateGrids | Retrieve rate grid codes using the Rate Grid Download connector. |
| RateGroups | Retrieve rate groups using the Rate Group Download connector. |
| RateSchedules | Retrieve rate schedules using the Rate Schedule Download connector. |
| RejectReasons | Query this table for reject reasons in SAPFieldglass. |
| RequisitionLineItems | Retrieve all high-level requisition information using the Requisition Line Item Detail Download connector. This connector differs from the Requisition Detail Download in that it adds SOW characteristic details. Each payment characteristic is added as a separate line and its corresponding details is sourced from the SOW. |
| Requisitions | Retrieve all high-level requisition information using the Requisition Detail Download connector. |
| Resources | Retrieve resources using the Resource Download connector. |
| SecurityWorkers | Retrieve all data on workers with Security IDs using the Worker Security Download connector. |
| SecurityWorkersSingleLine | Retrieve all data on workers with Security IDs using the Worker Security Single Line Download connector. |
| SecurityWorkersWithTransactionType | Retrieve worker records based on transaction type filtering logic using the Worker Security with Transaction Type Download connector. |
| SecurityWorkersWithTransactionTypeSingleLine | Retrieve worker records based on transaction type filtering logic using the Worker Security with Transaction Type Single Line Download connector. |
| ServiceEntrySheets | Retrieve service entry sheets using the Service Entry Sheet Download connector. |
| ServiceReceipts | Retrieve service receipts that are in Pending Approval, Approval Paused, Rejected and/or Approved status using the Service Receipt Download connector. |
| Sites | Retrieve site codes using the Site Download connector. |
| SOWBids | Retrieve SOW and SOW bid information using the SOW with Bid Download connector. |
| SOWCharacteristics | Retrieve SOW characteristic information using the Approved Characteristic Download connector. |
| SOWs | Retrieve Statement of Work (SOW) information using the SOW Download connector. |
| SOWWorkerRoles | Retrieve worker roles in all statuses using the SOW Worker Role Download connector. |
| Suppliers | Retrieve supplier configuration information using the Supplier Download connector. |
| TimeJournals | Retrieve time journals that are in Submitted, Consolidated, and/or Errored status depending on a provided parameter using the Time Journal Download connector. |
| TimeSheetBuyerDeductions | Retrieve time sheet deductions for buyers using the Deduction Buyer Download connector. |
| TimeSheets | Retrieve contingent worker time sheets that are in Draft (with time entries), Rejected, and/or Pending Approval status, depending on a provided parameter using the Time Sheet Download connector. |
| TimeSheetSupplierDeductions | Retrieve time sheet deductions for suppliers using the Deduction Supplier Download connector. |
| TimeSheetsWithNoTimeEntry | Retrieve time sheets with no time entries using the Time Sheet with No Time Entry Download connector. |
| TITOTimeSheets | Retrieve worker time in/time out (TITO) details based off a parameter entered during run time using the TITO Time Sheet Status Parameter Download connector. |
| Users | Retrieve all active users for the logged in user's company using the User Download connector. |
| WorkersFromWorkOrder | Retrieve multiple workers using the Worker from Work Order Download connector. |