Change Equipment Charges
Use this service to import Equipment Charges change information.
Method: UpdateEquip_Charges
Assumptions and Dependencies
The Equipment module must be set up.
The Equipment code must exist in the defined Company code.
The Equipment Items - Charges Information Web Service updates existing Equipment's information for the defined fields only.
Any field that is left blank will not be updated in Spectrum. The service does not delete values that exist in Spectrum; it only changes the data with the defined data in the field name.
Field Descriptions
Use the table below for reference when using this service. The Authorization_ID and GUID elements are not shown on the Spectrum Excel Office Add-in templates for data entry points.
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 | Valid Company in Spectrum | |
C |
Equipment_Code | Equipment Code | YES | Text | 10 | Valid Equipment Code in Spectrum | |
D |
Insurance_Cost_Per_Year | Insurance Cost/Yr. | Numeric | 10 | Enter decimals but no $ or commas. | ||
E |
License_Per_Year | License Cost/Yr. | Numeric | 10 | Enter decimals but no $ or commas. | ||
F |
Depreciation_Cost | Depreciation Cost/Yr. | Numeric | 10 | Enter decimals but no $ or commas. | ||
G |
Depreciation_Method | Depreciation Method | Text | 1 | (Y)ear, (M)eter, or (H)ours | ||
H |
Rate_Per_Hour | Job Rate/Full Charge/Hourly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
I |
Rate_Per_Day | Job Rate/Full Charge/Daily | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
J |
Rate_Per_Week | Job Rate//Full Charge/Weekly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
K |
Rate_Per_Month | Job Rate/Full Charge/Monthly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
L |
Job_Operating_Rate_Hour | Job Rate/ Operating//Hourly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
M |
Job_Operating_Rate_Day | Job Rate/ Operating/Daily | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
N |
Job_Operating_Rate_Week | Job Rate/ Operating/Weekly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
O |
Job_Operating_Rate_Month | Job Rate/ Operating/Monthly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
P |
Stand_By_Rate_Hour | Job Stand By Rate/Hourly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
Q |
Stand_By_Rate_Day | Job Stand By Rate/Daily | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
R |
Stand_By_Rate_Week | Job Stand By Rate/Weekly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
S |
Stand_By_Rate_Month | Job Stand By Rate/Monthly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
T |
Hourly_Rental_Rate | Rental Rate/Full Charge/Hourly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
U |
Daily_Rental_Rate | Rental Rate/Full Charge/Daily | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
V |
Weekly_Rental_Rate | Rental Rate/Full Charge/Weekly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
W |
Monthly_Rental_Rate | Rental Rate/Full Charge/Monthly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
X |
Rent_Operating_Rate_Hour | Rental Rate/ Operating/Hourly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
Y |
Rent_Operating_Rate_Day | Rental Rate/ Operating/Daily | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
Z |
Rent_Operating_Rate_Week | Rental Rate/ Operating/Weekly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
AA |
Rent_Operating_Rate_Month | Rental Rate/ Operating/Monthly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
AB |
Rental_Stand_By_Hour | Rental Rate/ Stand By/Hourly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
AC |
Rental_Stand_By_Day | Rental Rate/ Stand By/Daily | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
AD |
Rental_Stand_By_Week | Rental Rate/ Stand By/Weekly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. | ||
AE |
Rental_Stand_By_Month | Rental Rate/ Stand By/Monthly | Numeric | 8 | Enter decimals but no $ or commas. Positive number only. |