GetServiceInfo()

Field

Type

Length

Description

iId

Integer

4

Primary Key - Unique Identifier.

iLocationId

Integer

4

Not used.

cCode

String

10

Identifying code for the service.

iClassId

Integer

4

Service Class Id.  Foreign Key to service class.

cDescript

String

40

Description of service.

cShopType

String

1

Shop cost type.

$ = Fixed dollar amount

% = Percentage off

cLaborType

String

1

Labor cost type.

$ = Fixed dollar amount

% = Percentage off

nNewClient

Decimal

8

New client deduction.

cNcType

String

1

New client deduction type.

$ = Fixed dollar amount

% = Percentage off

cCommType

String

1

Commission type.

$ = Fixed dollar amount

% = Percentage off

lOverride

Boolean

1

Indicates whether the service has a commission override.

nCOverride

Decimal

8

Commission override (dollar amount or percentage).

nEmpPrice

Decimal

8

Employee service price.

nLevel1

Decimal

8

Service price for level 1.

nLevel2

Decimal

8

Service price for level 2.

nLevel3

Decimal

8

Service price for level 3.

nLevel4

Decimal

8

Service price for level 4.

nLevel5

Decimal

8

Service price for level 5.

nLevel6

Decimal

8

Service price for level 6.

nLevel7

Decimal

8

Service price for level 7.

nLevel8

Decimal

8

Service price for level 8.

nLevel9

Decimal

8

Service price for level 9.

iFormulaId

Integer

4

Formula Id.  Foreign Key to Formulas iId.

nNextTime

Decimal

2,0

Indicates how often clients should receive the service.

nStartLen

Decimal

6,4

Service start length.

nGapLen

Decimal

6,4

Service gap length.

nFinishLen

Decimal

6,4

Service finish length.

mNotes

String

Service notes.

dLastSale

DateTime

8

Sale start date.

dCreated

DateTime

8

Date the service was created.

lSubLabor

Boolean

1

Indicates whether has a labor cost.

lOnSale

Boolean

1

Indicates whether the service is on sale.

nSalePerc

Boolean

1

Percentage off discount for the service when on sale.

dSaleStart

DateTime

8

Sale start date.

dSaleEnd

DateTime

8

Sale end date.

lIgnoreDis

Boolean

1

Indicates whether client receive discounts on the service.

mCatalog

String

Catalog description for service.

dDateDel

DateTime

8

Date service was deleted.

lNonTaxable

Boolean

1

Indicates whether the service is non-taxable.

lMale

Boolean

1

Indicates whether the service is for male clients only.

lFemale

Boolean

1

Indicates whether the service is for female clients only.

nPkgPrice

Decimal

8

Package price for service.

lInactive

Boolean

1

Indicates whether the service is Inactive.

lShowNotes

Boolean

1

Indicates whether the service’s notes display on the Appointment Editor and Register.

nPreBookDisc

Decimal

8

Discount amount if service was pre-booked.

nOnlineDisc

Decimal

8

Discount amount if service was booked online.

cPreType

String

1

Pre-book discount type.

$ = Fixed dollar amount

% = Percentage off

cOnLineType

String

1

Online discount type.

$ = Fixed dollar amount

% = Percentage off

lBookOnline

Boolean

1

Indicates whether clients can book the service using Online Booking.

lClass

Boolean

1

Indicates whether the service is a class.

nClassQty

Decimal

2,0

Used with Class Booking module.  Specifies the maximum number of students in a class.

iGId

Integer

4

Not used.

cEmpTip

String

1

Employee service charge type. 

$ = Fixed dollar amount

% = Percentage off

nEmpTip

Decimal

8

Employee service charge amount.

cHouseTip

String

1

House service charge type.

$ = Fixed dollar amount

% = Percentage off

nHouseTip

Decimal

8

House service charge amount.

lForceGender

Boolean

1

Indicates whether clients need to specify a gender preference for their service provider.

lUseEquip

Boolean

1

Indicates that the service uses equipment.

lAllowPoints

Boolean

1

Indicates whether points apply to the service.

tChanged

DateTime

8

Date last changed.

cSubClassName

String

40

Subclass name.