TimeSheetsWithNoTimeEntry
Retrieve time sheets with no time entries using the Time Sheet with No Time Entry Download connector.
Columns
| Name | Type | Description |
| Buyer Name | String | Fieldglass Buyer Name |
| Buyer Code | String | Fieldglass Buyer Code |
| Supplier Name | String | Fieldglass Supplier Name |
| Supplier Code | String | Fieldglass Supplier Code |
| Account Name | String | Name of the Account, such as geographical area covered. See Glossary |
| Account Code | String | The unique system identifier for the account. See Glossary |
| Remit To Address Code | String | Supplier's Remit To Address Code |
| Job Posting Owner | String | Fieldglass Job Posting Owner in 'First,Last' format. |
| Work Order ID | String | Fieldglass Work Order ID |
| Worker ID | String | Fieldglass Worker ID |
| Job Seeker ID | String | Fieldglass Job Seeker ID |
| Worker Last Name | String | Worker's Last Name |
| Worker First Name | String | Worker's First Name |
| Site Code | String | Fieldglass Site Code associated to the Worker. |
| Site Name | String | Fieldglass Site Name associated to Site Code above. |
| Business Unit Code | String | Fieldglass Business Unit Code associated to Worker. |
| Business Unit Name | String | Fieldglass Business Unit Name related to Business Unit Code above. |
| Final Approver First Name | String | First Name of the Time Sheet's Final Approver. Only appears if the Time Sheet has last approver ID populated. |
| Final Approver Last Name | String | Last Name of the Time Sheet's Final Approver. Only appears if the Time Sheet has last approver ID populated. |
| Final Approver Employee ID | String | Final Approver's Employee ID as stored on their SAP Fieldglass User Profile. |
| Final Approver Email | String | Final Approver's email address as stored on their SAP Fieldglass User Profile. |
| Time Sheet ID | String | Fieldglass Time Sheet ID |
| Time Sheet Status | String | Fieldglass Time Sheet Status |
| Time Sheet Start Date | Date | Start Date of Time Sheet |
| Time Sheet End Date | Date | End Date of Time Sheet |
| Time Sheet Submit Date/Time | Date | Date and Time when Time Sheet was Submitted by the Worker |
| Time Sheet Approved Date | Date | Date the Time Sheet was fully approved. Blank if Time Sheet is yet to be approved. |
| Time Entry Date | Date | Date for which time is being recorded. |
| Cost Center Code | String | Cost Center Code against which time is being recorded. |
| Cost Center Name | String | Cost Center Name related to the Cost Center Code above. |
| Task Code | String | Task Code against which time is being recorded. |
| Task Name | String | Task Name associated to the Task Code above. |
| General Ledger Account Code | String | General Ledger Account associated to the Task against which time is being recorded. Will be downloaded only when the company is GL enabled. This field is mutually exclusive with Segmented Object Detail. |
| Segmented Object Detail | String | Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-). Required if 'Enable Segmented Object Detail' configuration set. This field is mutually exclusive with GL Account fields. Note - More than one string can appear for a cost center. |
| Billable Per Diem | Decimal | Amount of any Billable Per Diem to be paid for the Time Entry Date |
| Billable Hours | Decimal | Number of Billable Hours recorded for the Time Entry Date |
| Non-billable Hours | Decimal | Number Non-Billable Hours recorded for the Time Entry Date |
| Total Hours | Decimal | Sum Total of Billable and Non-Billable Hours recorded for the Time Entry Date. |
| Billable Amount | Decimal | Total Amount to be billed for the Time Entry Date |
| Billable Amount after Discount | Decimal | Billable Amount of the time sheet date after applying the discount. |
| Currency | String | Currency in which Billable Amount is to be paid. |
| Rate Category / UOM | String | Rate Category and Unit of Measure for time recorded. |
| Bill Rate Buyer | Decimal | The Bill Rate that the Buyer will pay for each billable hour recorded. |
| Bill Rate Supplier | Decimal | The Bill Rate the Supplier will receive for each billable hour recorded. |
| Pay Rate | Decimal | The Worker's pay rate. |