Returns salary, hourly wage, and commission information for the specified employee(s).
GetEmployeeSalaryCommInfo(XmlIds AS String)
XML String
XmlIds = XML String containing the Employee Ids of the records to return. You must format this string using the XML IdList Structure Definition.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iLocationId |
Integer |
4 |
Not used |
|
iEmpId |
Integer |
4 |
Employee Id. Foreign Key to Employee iId. |
|
nSalary |
Decimal |
8 |
Salary. |
|
nHourlyWage |
Decimal |
8 |
Hourly wage. |
|
nTicketDeduct |
Decimal |
8 |
Dollar amount to charge per ticket. |
|
nApplysDeduct |
Decimal |
1 |
Indicates when service deductions are applied. 1 = Service deductions are applied BEFORE commissions are calculated 2 = Service deductions are applied AFTER commissions are calculated |
|
nServDeduct |
Decimal |
1 |
Indicates whether service deductions are applied. 0 = Service deductions are NOT applied 1 = Service deductions are applied |
|
nLaborDeduct |
Decimal |
1 |
Indicates whether labor deductions are applied. 0 = Labor deductions are NOT applied 1 = Labor deductions are applied |
|
nClientDeduct |
Decimal |
1 |
Indicates whether new client deductions are applied. 0 = New client deductions are NOT applied 1 = New client deductions are applied |
|
nSCommType |
Decimal |
1 |
Indicates service commission type. 0 = No commission type specified 1 = Straight commission 2 = Sliding scale commission |
|
nSCommCat |
Decimal |
1 |
Indicates how service commissions are calculated. 1 = Commission Only 2 = Salary/Wage AND Commission 3 = Salary/Wage OR Commission |
|
nSFrom1 |
Decimal |
8 |
Service Commission FROM value for service commission range #1. |
|
nSFrom2 |
Decimal |
8 |
Service Commission FROM value for service commission range #2. |
|
nSFrom3 |
Decimal |
8 |
Service Commission FROM value for service commission range #3. |
|
nSFrom4 |
Decimal |
8 |
Service Commission FROM value for service commission range #4. |
|
nSFrom5 |
Decimal |
8 |
Service Commission FROM value for service commission range #5. |
|
nSFrom6 |
Decimal |
8 |
Service Commission FROM value for service commission range #6. |
|
nSFrom7 |
Decimal |
8 |
Service Commission FROM value for service commission range #7. |
|
nSFrom8 |
Decimal |
8 |
Service Commission FROM value for service commission range #8. |
|
nSTo1 |
Decimal |
8 |
Service Commission TO value for service commission range #1. |
|
nSTo2 |
Decimal |
8 |
Service Commission TO value for service commission range #2. |
|
nSTo3 |
Decimal |
8 |
Service Commission TO value for service commission range #3. |
|
nSTo4 |
Decimal |
8 |
Service Commission TO value for service commission range #4. |
|
nSTo5 |
Decimal |
8 |
Service Commission TO value for service commission range #5. |
|
nSTo6 |
Decimal |
8 |
Service Commission TO value for service commission range #6. |
|
nSTo7 |
Decimal |
8 |
Service Commission TO value for service commission range #7. |
|
nSTo8 |
Decimal |
8 |
Service Commission TO value for service commission range #8. |
|
nSPercent1 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #1. |
|
nSPercent2 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #2. |
|
nSPercent3 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #3. |
|
nSPercent4 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #4. |
|
nSPercent5 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #5. |
|
nSPercent6 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #6. |
|
nSPercent7 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #7. |
|
nSPercent8 |
Decimal |
6,2 |
Service Commission percentage value for service commission range #8. |
|
nRMinService |
Decimal |
8 |
Minimum amount in service sales required to receive commission. |
|
NRCommType |
Decimal |
1 |
Indicates retail commission type. 0 = No commission type specified 1 = Straight commission 2 = Sliding scale commission |
|
NRFrequency |
Decimal |
1 |
Payment frequency for retail commissions. 1 = Weekly 2 = Every Two Weeks 3 = Monthly 4 = Every Two Months 5 = Quarterly 6 = Yearly |
|
nRFrom1 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #1. |
|
nRFrom2 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #2. |
|
nRFrom3 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #3. |
|
nRFrom4 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #4. |
|
nRFrom5 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #5. |
|
nRFrom6 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #6. |
|
nRFrom7 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #7. |
|
nRFrom8 |
Decimal |
8 |
Retail Commission FROM value for Retail commission range #8. |
|
nRTo1 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #1. |
|
nRTo2 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #2. |
|
nRTo3 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #3. |
|
nRTo4 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #4. |
|
nRTo5 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #5. |
|
nRTo6 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #6. |
|
nRTo7 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #7. |
|
nRTo8 |
Decimal |
8 |
Retail Commission TO value for Retail commission range #8. |
|
nPercent1 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #1. |
|
nPercent2 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #2. |
|
nPercent3 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #3. |
|
nPercent4 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #4. |
|
nPercent5 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #5. |
|
nPercent6 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #6. |
|
nPercent7 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #7. |
|
nPercent8 |
Decimal |
6,2 |
Retail Commission percentage value for Retail commission range #8. |
|
NPFrom1 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #1. |
|
NPFrom2 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #2. |
|
NPFrom3 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #3. |
|
NPFrom4 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #4. |
|
NPFrom5 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #5. |
|
NPFrom6 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #6. |
|
NPFrom7 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #7. |
|
NPFrom8 |
Decimal |
6,2 |
% Retail to Service commission FROM value for Retail to Service commission range #8. |
|
NPTo1 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #1. |
|
NPTo2 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #2. |
|
NPTo3 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #3. |
|
NPTo4 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #4. |
|
NPTo5 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #5. |
|
NPTo6 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #6. |
|
NPTo7 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #7. |
|
NPTo8 |
Decimal |
6,2 |
% Retail to Service commission TO value for Retail to Service commission range #8. |
|
NPPercent1 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #1. |
|
NPPercent2 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #2. |
|
NPPercent3 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #3. |
|
NPPercent4 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #4. |
|
NPPercent5 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #5. |
|
NPPercent6 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #6. |
|
NPPercent7 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #7. |
|
NPPercent8 |
Decimal |
6,2 |
% Retail to Service commission percentage value for Retail to Service commission range #8. |
|
nDeduction |
Decimal |
8 |
User-defined deduction for the pay period. |
|
cDeductDesc |
String |
25 |
Description of the user-defined deduction. |
|
nBooth |
Decimal |
8 |
Allows for a charge/booth fee for independent contractors. |
|
nFrequency |
Decimal |
1 |
Frequency of the charge/booth fee to the independent contractor. 1 = Weekly 2 = Every Two Weeks 3 = Monthly 4 = Every Two Months 5 = Quarterly 6 = Yearly |
|
nNumHours |
Decimal |
3 |
Number of hours that commissions are based on. |
|
iGId |
Integer |
4 |
Not used. |
|
nOtMult |
Decimal |
8 |
Overtime multiplier. |
|
nOtHours |
Decimal |
8 |
Number of hours after which the employee receives overtime pay. |