ODBC Driver for SAP Fieldglass

Build 23.0.8839

RateSchedules

Retrieve rate schedules using the Rate Schedule Download connector.

Columns

Name Type Description
Rate Schedule Code String Code identifying the rate schedule.
Rate Schedule Name String Name of rate schedule.
Service Type String Indicates service type for rate schedule.
Rate Section Name String Indicates the section of the rate schedule. The rate section name 'Base Section' must always be included. Other rate sections names can also be added by the buyer after 'Base Section'.
Include Rate on String The base rate must appear on the work order details; however, you can determine if any other rates need to appear (in additional sections).
Coefficient Code String Indicates overtime/coefficient code for rate schedule in case of coefficient type rate.
Coefficient Name String Indicates overtime/coefficient name for rate schedule in case of coefficient type rate.
Rate Code String Indicates Rate code for rate schedule.
Rate Name String Indicates rate name for rate schedule.
Associated Shift Schedules String Indicates shift schedules associated to rate code
Time Sheet Rule String Indicates rate rule or custom script associated to rate code.
Frequency String The Frequency determines when a time sheet entry can be made either by the worker or via the rate rule. If Daily is selected, the worker (or rate rule) will be able to make an entry on every day. If Weekly is selected, the worker (or rate rule) will be able to make an entry on the last day of the time sheet. If Monthly is selected, the worker (or rate rule) will be able to make an entry on the last day of the month.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839