Add Labor Billing Rates
Use this service to add or update labor billing rates.
Connection Information
URL = https://<SPECTRUM-SERVER>:8482/TimeMaterial/AddLaborTM
Authentication: Basic Authentication, Enhanced Authentication
Supported methods: POST
Supported formats: JSON
Sample JSON Body
{
"timeMaterialLabors": [{
"Company_Code": "2nd",
"Billing_Code": "VS1",
"Description": "",
"Markup_Type":"N",
"Reg_Bill_1":"1",
"Reg_Bill_2":"10",
"Reg_Bill_3":"100",
"Reg_Bill_4":"1000",
"Reg_Bill_5":"100000",
"OT_Bill_1":"20",
"OT_Bill_2":"20",
"OT_Bill_3":"20",
"OT_Bill_4":"20",
"OT_Bill_5":"20",
"DT_Bill_1":"30",
"DT_Bill_2":"30",
"DT_Bill_3":"30",
"DT_Bill_4":"30",
"DT_Bill_5":"30",
"Markup_1":"5",
"Markup_2":"10",
"Markup_3":"25",
"Markup_4":"29",
"Markup_5":"35"
}]
}
Underlying File Maintenance
Field Descriptions
| Excel | Element Name | Description | Req | Type | Max | Format | Validation |
|---|---|---|---|---|---|---|---|
| Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen | ||
| GUID | Unique reference number created by programming | Text | 36 | ** See GUID definition | |||
| B | Company_Code | Company Code | YES | Text | 3 | Key | Valid Company in Spectrum |
| C | Billing_Code | Billing Code | YES | Text | 10 | Key | |
| D | Description | Bill Code Description | Text | 25 | |||
| E | Markup_Type | Markup Type | Text | 1 | 'N'one, 'P'ercentage or 'R'ate per hour | ||
| F | Reg_Bill_1 | Regular Billing Rate 1 | Numeric | 8.3 | |||
| G | Reg_Bill_2 | Regular Billing Rate 2 | Numeric | 8.3 | |||
| H | Reg_Bill_3 | Regular Billing Rate 3 | Numeric | 8.3 | |||
| I | Reg_Bill_4 | Regular Billing Rate 4 | Numeric | 8.3 | |||
| J | Reg_Bill_5 | Regular Billing Rate 5 | Numeric | 8.3 | |||
| K | OT_Bill_1 | Overtime Billing Rate 1 | Numeric | 8.3 | |||
| L | OT_Bill_2 | Overtime Billing Rate 2 | Numeric | 8.3 | |||
| M | OT_Bill_3 | Overtime Billing Rate 3 | Numeric | 8.3 | |||
| N | OT_Bill_4 | Overtime Billing Rate 4 | Numeric | 8.3 | |||
| O | OT_Bill_5 | Overtime Billing Rate 5 | Numeric | 8.3 | |||
| P | DT_Bill_1 | Double Time Billing Rate 1 | Numeric | 8.3 | |||
| Q | DT_Bill_2 | Double Time Billing Rate 2 | Numeric | 8.3 | |||
| R | DT_Bill_3 | Double Time Billing Rate 3 | Numeric | 8.3 | |||
| S | DT_Bill_4 | Double Time Billing Rate 4 | Numeric | 8.3 | |||
| T | DT_Bill_5 | Double Time Billing Rate 5 | Numeric | 8.3 | |||
| U | Markup_1 | Markup 1 | Numeric | 5.2 | 3.2/5.2 | Percentage is 3.2, Rate/Hr is 5.2 | |
| V | Markup_2 | Markup 2 | Numeric | 5.2 | 3.2/5.2 | Percentage is 3.2, Rate/Hr is 5.2 | |
| W | Markup_3 | Markup 3 | Numeric | 5.2 | 3.2/5.2 | Percentage is 3.2, Rate/Hr is 5.2 | |
| X | Markup_4 | Markup 4 | Numeric | 5.2 | 3.2/5.2 | Percentage is 3.2, Rate/Hr is 5.2 | |
| Y | Markup_5 | Markup 5 | Numeric | 5.2 | 3.2/5.2 | Percentage is 3.2, Rate/Hr is 5.2 |
