NameDescriptionTypeAdditional information
UserFieldsID

integer

None.

ClientID

integer

None.

FieldName

string

String length: inclusive between 0 and 25

FieldLabel

string

String length: inclusive between 0 and 25

FieldType

string

String length: inclusive between 0 and 50

FieldList

string

None.

CalcType

integer

None.

GroupCodes

string

None.

UserGroup

string

String length: inclusive between 0 and 25

GroupPayTo

integer

None.

GroupRefreshDate

date

None.

GroupStartDate

date

None.

GroupEndDate

date

None.

PromptAdHoc

integer

None.

FormulaSql

string

None.

FormulaCall

string

String length: inclusive between 0 and 50

ModifiedOn

date

None.

ModifiedBy

string

String length: inclusive between 0 and 50

EnteredOn

date

None.

EnteredBy

string

String length: inclusive between 0 and 50

HasDependency

string

String length: inclusive between 0 and 1

ReverseSign

string

String length: inclusive between 0 and 1

EGDateType

string

String length: inclusive between 0 and 100

EGRouteTo

string

String length: inclusive between 0 and 100

EGVoucherType

string

String length: inclusive between 0 and 100

EGPayrollType

string

String length: inclusive between 0 and 100

EGERCCode

string

String length: inclusive between 0 and 100

EGCategory

string

String length: inclusive between 0 and 300

EGUserCategory

string

String length: inclusive between 0 and 300

EGExcludeCodes

string

String length: inclusive between 0 and 1000

EGCustomSQL

string

String length: inclusive between 0 and 1000

GroupPayrollType

string

String length: inclusive between 0 and 100

ID

integer

None.

EGDateType1

string

String length: inclusive between 0 and 30

EGDateType2

string

String length: inclusive between 0 and 30

EGDateType3

string

String length: inclusive between 0 and 30

EGDateType4

string

String length: inclusive between 0 and 30