Union Fringes
Use this service to add union fringes information.
Connection Information
URL = https://<SPECTRUM-SERVER>:8482/payroll/unionfringe
Authentication: Basic Authentication, Enhanced Authentication
Supported methods: POST
Supported formats: JSON
Sample JSON Body
{
"unionFringes": [
{
"Company_Code": "ABC",
"Union_Code": "DF001",
"Fringe_Code": "F1",
"Record_Type": "R",
"Base_Type": "A",
"Formula_Code": "",
"Fringe_Rate": 2.34,
"Formula_Variable_1": 0,
"Formula_Variable_2": 0,
"Formula_Variable_3": 0,
"Fringe_Payable_GL_Acct": "0255",
"Status": "A",
"Effective_Date": ""
}
]
}
Underlying File Maintenance
Field Descriptions
Use the table below for reference when using this service.
Excel |
Element Name | Description | Req | Type | Max | Format | Validation |
---|---|---|---|---|---|---|---|
B |
Company_Code | YES | Text | 3 | Valid Company in Spectrum | ||
C |
Union_Code | YES | Text | 10 | Union | Union File Maintenance | |
D |
Fringe_Code | YES | Text | 20 | |||
E |
Record_Type | When updating this indicates whether the change is to rate or status, when adding a new deduction this field is ignored | YES (if updating) | Text | 1 | R = Rate change S = Status change | |
F |
Base_Type | Base Type | YES | Text | 1 | P = % of Gross B = % of Base R = Regular O = Overtime D = Double time A = All hours U = User-defined | |
G |
Formula_Code | Formula Code | Text | 5 | If Method = (U)ser-defined, this field is requiried, otherwise not available | Valid Formula Code (PR_FORMULA_MC) | |
H |
Fringe_Rate | Fringe Rate | Numeric | 7 | If NOT using Formula_Code Format = 3.4 | ||
I |
Formula_Variable_1 | Formula Variable 1 (V1) Rate | Numeric | 7 | If using Formula_Code Format = 4.4 | ||
J |
Formula_Variable_2 | Formula Variable 2 (V2) Rate | Numeric | 7 | If using Formula_Code Format = 4.4 | ||
K |
Formula_Variable_3 | Formula Variable 3 (V3) Rate | Numeric | 7 | If using Formula_Code Format = 4.4 | ||
L |
Fringe_Payable_GL_Acct | Fringe Payable GL Account | YES | Numeric | 12 | Code must have an Active status | G/L Master File Maintenance |
M |
Status | Status | Text | 1 | (A)ctive or (Inactive). Defaults to Active if blank | ||
N |
Effective_Date | Effective Date | Date | 10 | Enter MM/DD/CCYY | Defaults to current payroll data |