Property starting with A |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ABPEndDate
|
Einddatum deelnemerschap
|
Einddatum deelnemerschap
|
Date
|
|
ABPEndDate
|
|
|
|
|
ABPParticipationType
|
Aard deelnemerschap
|
Aard deelnemerschap
|
String
|
|
ABPParticipationType
|
|
|
|
|
ABPPartTimeFactor
|
Deeltijdfactor andere betrekking/verlof
|
Deeltijdfactor andere betrekking/verlof
|
Number
|
|
ABPPartTimeFactor
|
|
|
|
|
ABPPercentageParticipation
|
Percentage waarde deelnemerschap
|
Percentage waarde deelnemerschap
|
Number
|
|
ABPPercentageParticipation
|
|
|
|
|
ABPSequenceNumber
|
Volgnummer deelnemer
|
Volgnummer deelnemer
|
Number
|
|
ABPSequenceNumber
|
|
|
|
|
ABPStartDate
|
Begindatum deelnemerschap
|
Begindatum deelnemerschap
|
Date
|
|
ABPStartDate
|
|
|
|
|
ABPValueParticipation
|
Waarde deelnemerschap
|
Waarde deelnemerschap
|
String
|
|
ABPValueParticipation
|
|
|
|
|
ABUEndDate
|
Einddatum wekentelling
|
Einddatum wekentelling
|
Date
|
|
ABUEndDate
|
|
|
|
|
ABUNumberofWeeksNotWorked
|
Aantal weken niet gewerkt
|
Aantal weken niet gewerkt
|
Number
|
|
ABUNumberofWeeksNotWorked
|
|
|
|
|
ABUStartDate
|
Begindatum wekentelling
|
Begindatum wekentelling
|
Date
|
|
ABUStartDate
|
|
|
|
|
AdditionalElderlyRebate
|
Aanvullende ouderenkorting
|
Aanvullende ouderenkorting
|
Boolean
|
|
AdditionalElderlyRebate
|
|
|
|
|
AmountB
|
CAO uren
|
CAO uren
|
String
|
|
AmountB
|
|
|
|
|
AmountBenefitPayment
|
Bedrag uitkering
|
Bedrag uitkering
|
String
|
|
AmountBenefitPayment
|
|
|
|
|
AmountExtraTaxAmount
|
Bedrag extra loonheffing
|
Bedrag extra loonheffing
|
Number
|
|
AmountExtraTaxAmount
|
|
|
|
|
AmountSpecialSituation1
|
Bedrag 1
|
Bedrag 1
|
Number
|
|
AmountSpecialSituation1
|
|
|
|
|
AmountSpecialSituation2
|
Bedrag 2
|
Bedrag 2
|
Number
|
|
AmountSpecialSituation2
|
|
|
|
|
AmountSpecialSituation3
|
Bedrag 3
|
Bedrag 3
|
Number
|
|
AmountSpecialSituation3
|
|
|
|
|
AmountWAOPayment
|
Pensioengevend loon
|
Pensioengevend loon
|
String
|
|
AmountWAOPayment
|
|
|
|
|
AnnualWageSpecialTax
|
Jaarloon voor bijzonder tarief
|
Jaarloon voor bijzonder tarief
|
Number
|
|
AnnualWageSpecialTax
|
|
|
|
|
AverageHoursPerWeek
|
Gemiddeld aantal uren per week
|
Gemiddeld aantal uren per week
|
Number
|
|
AverageHoursPerWeek
|
|
|
|
|
Property starting with B |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
BasicValueRelanVNPS
|
Loonsom RELAN/VNPS
|
Loonsom RELAN/VNPS
|
Number
|
|
BasicValueRelanVNPS
|
|
|
|
|
BeneficialRegulation
|
Voordeelregel
|
Voordeelregel
|
Boolean
|
|
BeneficialRegulation
|
|
|
|
|
BirthDate
|
|
|
Date
|
|
BirthDate
|
|
|
|
|
BPFInsured
|
Code BPF horeca en bakkers
|
Code BPF horeca en bakkers
|
String
|
|
BPFInsured
|
|
|
|
|
BTERDays
|
BTER dagen
|
BTER dagen
|
Number
|
|
BTERDays
|
|
|
|
|
BTERDaysDeviated
|
Afw. BTER grondslag PF
|
Afw. BTER grondslag PF
|
Number
|
|
BTERDaysDeviated
|
|
|
|
|
BTERHourlyWage
|
BTER uurloon
|
BTER uurloon
|
Number
|
|
BTERHourlyWage
|
|
|
|
|
Property starting with C |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
CalcDaysWeek
|
SV dagen per week
|
SV dagen per week
|
Number
|
|
CalcDaysWeek
|
|
|
|
|
CalcHoursWeek
|
SV uren per week
|
SV uren per week
|
Number
|
|
CalcHoursWeek
|
|
|
|
|
CalcPtf
|
Deeltijdfactor
|
Deeltijdfactor
|
Number
|
|
CalcPtf
|
|
|
|
|
CalcPtfMethod
|
Berekening deeltijdfactor
|
Berekening deeltijdfactor
|
String
|
|
CalcPtfMethod
|
|
|
|
|
CalcSvdaysMethod
|
Berekening SV dagen/uren
|
Berekening SV dagen/uren
|
String
|
|
CalcSvdaysMethod
|
|
|
|
|
CAOCode
|
CAO code
|
CAO code
|
String
|
|
CAOCode
|
|
|
|
|
CheckPeriod
|
Peilperiode
|
Peilperiode
|
Number
|
|
CheckPeriod
|
|
|
|
|
CheckYear
|
Peiljaar
|
Peiljaar
|
Number
|
|
CheckYear
|
|
|
|
|
CodeCAO
|
Code CAO
|
Code CAO
|
Number
|
|
CodeCAO
|
|
|
|
|
CodeContract
|
Code contract
|
Code contract
|
String
|
|
CodeContract
|
|
|
|
|
CodeExceptions
|
Code premie vrijstellingen
|
Code premie vrijstellingen
|
String
|
|
CodeExceptions
|
|
|
|
|
CodeExtraTaxPayment
|
Extra loonheffing
|
Extra loonheffing
|
String
|
|
CodeExtraTaxPayment
|
|
|
|
|
CodeFranchise
|
Vakantiebonnen
|
Vakantiebonnen
|
String
|
|
CodeFranchise
|
|
|
|
|
CodeIncomeReduction
|
Code inkomstenvermindering
|
Code inkomstenvermindering
|
String
|
|
CodeIncomeReduction
|
|
|
|
|
CodePhaseFZ
|
Code fase indeling F&Z
|
Code fase indeling F&Z
|
String
|
|
CodePhaseFZ
|
|
|
|
|
CodeReasonNoIncreaseValue
|
Code reden geen bijtelling auto
|
Code reden geen bijtelling auto
|
String
|
|
CodeReasonNoIncreaseValue
|
|
|
|
|
CodeSpecialSituation1
|
Code speciale aanduiding 1
|
Code speciale aanduiding 1
|
String
|
|
CodeSpecialSituation1
|
|
|
|
|
CodeSpecialSituation2
|
Code speciale aanduiding 2
|
Code speciale aanduiding 2
|
String
|
|
CodeSpecialSituation2
|
|
|
|
|
CodeSpecialSituation3
|
Code speciale aanduiding 3
|
Code speciale aanduiding 3
|
String
|
|
CodeSpecialSituation3
|
|
|
|
|
CodeSpecialSituationSV
|
Code speciale aanduiding SV
|
Code speciale aanduiding SV
|
String
|
|
CodeSpecialSituationSV
|
|
|
|
|
CodeTaxDeduction
|
Overige verminderingen
|
Overige verminderingen
|
String
|
|
CodeTaxDeduction
|
|
|
|
|
CodeTaxDeductionLowWages
|
Vermindering lage lonen
|
Vermindering lage lonen
|
String
|
|
CodeTaxDeductionLowWages
|
|
|
|
|
CodeTaxRebate
|
Loonheffingskorting
|
Loonheffingskorting
|
String
|
|
CodeTaxRebate
|
|
|
|
|
CodeTypeofIncome
|
Code soort inkomen
|
Code soort inkomen
|
String
|
|
CodeTypeofIncome
|
|
|
|
|
CodeVUTHoreca
|
Code VUT horeca
|
Code VUT horeca
|
String
|
|
CodeVUTHoreca
|
|
|
|
|
CodeZVW
|
Code verzekeringssituatie ZVW
|
Code verzekeringssituatie ZVW
|
String
|
|
CodeZVW
|
|
|
|
|
CompanyCar
|
Auto van de zaak
|
Auto van de zaak
|
String
|
|
CompanyCar
|
|
|
|
|
CompanyCode
|
|
|
String
|
|
CompanyCode
|
|
|
|
|
ComponentGroup
|
Component group
|
Component group
|
String
|
|
ComponentGroup
|
|
|
|
|
ComponentGroupDescription
|
|
|
String
|
|
ComponentGroupDescription
|
|
|
|
|
ContractEndDate
|
Contract end date
|
Contract end date
|
Date
|
|
ContractEndDate
|
|
|
|
|
CorrectionType
|
Type correctie Loonaangifte
|
Type correctie Loonaangifte
|
String
|
|
CorrectionType
|
|
|
|
|
CorrectionWorkrelationship
|
Type correctie OLP
|
Type correctie OLP
|
String
|
|
CorrectionWorkrelationship
|
|
|
|
|
CostCenter
|
|
|
String
|
|
CostCenter
|
|
|
|
|
CostRegulationArtist
|
Kostenbeschikking artiest
|
Kostenbeschikking artiest
|
Number
|
|
CostRegulationArtist
|
|
|
|
|
CountryCode
|
Country
|
Country
|
String
|
|
CountryCode
|
|
|
|
|
CreatedDate
|
|
|
Date
|
|
CreatedDate
|
|
|
|
|
CreatedOn
|
Verwerkt op
|
Verwerkt op
|
Date
|
|
CreatedOn
|
|
|
|
|
CreateMSV
|
Melding sociale verzekering maken
|
Melding sociale verzekering maken
|
Boolean
|
|
CreateMSV
|
|
|
|
|
Creator
|
|
|
Number
|
|
Creator
|
|
|
|
|
CreatorName
|
|
|
String
|
|
CreatorName
|
|
|
|
|
CreditorNumber
|
|
|
String
|
|
CreditorNumber
|
|
|
|
|
CVZCountryFactor
|
Woonlandfactor CVZ
|
Woonlandfactor CVZ
|
Number
|
|
CVZCountryFactor
|
|
|
|
|
Property starting with D |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
DatePersonnelDeclaration
|
Datum ingang
|
Datum ingang
|
Date
|
|
DatePersonnelDeclaration
|
|
|
|
|
DaysBenefitPayment
|
Dagen aanvulling
|
Dagen aanvulling
|
String
|
|
DaysBenefitPayment
|
|
|
|
|
DaysPerPeriod
|
Dagen per periode
|
Dagen per periode
|
Number
|
|
DaysPerPeriod
|
|
|
|
|
DaysScholarship
|
Aantal dagen leerplichtig
|
Aantal dagen leerplichtig
|
String
|
|
DaysScholarship
|
|
|
|
|
DeclarationLastAction
|
Laatste actie
|
Laatste actie
|
String
|
|
DeclarationLastAction
|
|
|
|
|
DeclarationPeriod
|
Declaration Period
|
Declaration Period
|
Number
|
|
DeclarationPeriod
|
|
|
|
|
DeclarationType
|
DeclarationType
|
DeclarationType
|
String
|
|
DeclarationType
|
|
|
|
|
DispensationRiskFund
|
Dispensatie Risicofonds
|
Dispensatie Risicofonds
|
Boolean
|
|
DispensationRiskFund
|
|
|
|
|
Property starting with E |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
EmploymentNumber
|
Nummer Inkomstenverhouding
|
Nummer Inkomstenverhouding
|
String
|
|
EmploymentNumber
|
|
|
|
|
EmploymentStart
|
Employment date
|
Employment date
|
Date
|
|
EmploymentStart
|
|
|
|
|
EndDate
|
|
|
Date
|
|
EndDate
|
|
|
|
|
ExceptionRule
|
Uitzondering
|
Uitzondering
|
String
|
|
ExceptionRule
|
|
|
|
|
ExceptionWorkrelationship
|
Uitzonderingssituatie
|
Uitzonderingssituatie
|
String
|
|
ExceptionWorkrelationship
|
|
|
|
|
Property starting with F |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
FixedAmountTaxDeduction
|
Vermindering onderwijs vast bedrag
|
Vermindering onderwijs vast bedrag
|
Number
|
|
FixedAmountTaxDeduction
|
|
|
|
|
FixedWorkingHours
|
Regelmatig arbeidspatroon
|
Regelmatig arbeidspatroon
|
Boolean
|
|
FixedWorkingHours
|
|
|
|
|
Property starting with G |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
GovernmentPersonnel
|
Overheidspersoneel
|
Overheidspersoneel
|
Boolean
|
|
GovernmentPersonnel
|
|
|
|
|
GrossAnnualWage
|
Bruto jaarloon
|
Bruto jaarloon
|
Number
|
|
GrossAnnualWage
|
|
|
|
|
Property starting with H |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
HoursTaxReduction
|
Uren per week vermindering
|
Uren per week vermindering
|
Number
|
|
HoursTaxReduction
|
|
|
|
|
HoursWorkedThisYear
|
Gewerkte uren dit jaar
|
Gewerkte uren dit jaar
|
String
|
|
HoursWorkedThisYear
|
|
|
|
|
Property starting with I |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ID
|
|
|
Number
|
|
ID
|
|
|
|
|
IndicationEmployment
|
Aanduiding inkomstenverhouding
|
Aanduiding inkomstenverhouding
|
String
|
|
IndicationEmployment
|
|
|
|
|
IVDeviatingDate
|
Afwijkende datum
|
Afwijkende datum
|
Boolean
|
|
IVDeviatingDate
|
|
|
|
|
IVEndDate
|
End date
|
End date
|
Date
|
|
IVEndDate
|
|
|
|
|
IVStartDate
|
Start date
|
Start date
|
Date
|
|
IVStartDate
|
|
|
|
|
Property starting with L |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
LifeCourseRebate
|
Levensloopverlofkorting
|
Levensloopverlofkorting
|
Number
|
|
LifeCourseRebate
|
|
|
|
|
LineType
|
Soort regel
|
Soort regel
|
String
|
|
LineType
|
|
|
|
|
Property starting with M |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ModifiedDate
|
|
|
Date
|
|
ModifiedDate
|
|
|
|
|
Modifier
|
|
|
Number
|
|
Modifier
|
|
|
|
|
ModifierName
|
|
|
String
|
|
ModifierName
|
|
|
|
|
Property starting with N |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
NameComposition
|
Samenstelling naam
|
Samenstelling naam
|
String
|
|
NameComposition
|
|
|
|
|
NatureOfWorkrelationship
|
Anders, aard arbeidsovereenkomst
|
Anders, aard arbeidsovereenkomst
|
String
|
|
NatureOfWorkrelationship
|
|
|
|
|
Property starting with P |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ParticipantBPS
|
Deelnemer BPS
|
Deelnemer BPS
|
Boolean
|
|
ParticipantBPS
|
|
|
|
|
ParticipantOBF
|
Deelnemer OBF
|
Deelnemer OBF
|
Boolean
|
|
ParticipantOBF
|
|
|
|
|
ParticipantSteinkuhlerfund
|
Deelnemer Steinkuhlerfonds
|
Deelnemer Steinkuhlerfonds
|
Boolean
|
|
ParticipantSteinkuhlerfund
|
|
|
|
|
ParticipantVNPS
|
Deelnemer VNPS
|
Deelnemer VNPS
|
Boolean
|
|
ParticipantVNPS
|
|
|
|
|
PaymentPeriod
|
Betalingsperiode
|
Betalingsperiode
|
String
|
|
PaymentPeriod
|
|
|
|
|
PayrollYear
|
Year
|
Year
|
String
|
|
PayrollYear
|
|
|
|
|
PercentageCompensationRegulation
|
Percentage vergoedingsregeling
|
Percentage vergoedingsregeling
|
Number
|
|
PercentageCompensationRegulation
|
|
|
|
|
PercentageEmploymentDisabled
|
Percentage arbeidsongeschiktheid
|
Percentage arbeidsongeschiktheid
|
String
|
|
PercentageEmploymentDisabled
|
|
|
|
|
Period
|
Period
|
Period
|
Number
|
|
Period
|
|
|
|
|
PremiumGroup
|
Premiegroep
|
Premiegroep
|
String
|
|
PremiumGroup
|
|
|
|
|
Property starting with R |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ReasonEndofService
|
Einde dienstverband
|
Einde dienstverband
|
String
|
|
ReasonEndofService
|
|
|
|
|
ReducibleTaxCalculation
|
Herleidingsregel
|
Herleidingsregel
|
String
|
|
ReducibleTaxCalculation
|
|
|
|
|
ReductionWAPremium
|
Reductie premie wachtgeld
|
Reductie premie wachtgeld
|
String
|
|
ReductionWAPremium
|
|
|
|
|
RegularEmployment
|
Op basis van arbeidsovereenkomst
|
Op basis van arbeidsovereenkomst
|
Boolean
|
|
RegularEmployment
|
|
|
|
|
ResourceCostCenter
|
Cost center
|
Cost center
|
String
|
|
ResourceCostCenter
|
|
|
|
|
ResourceID
|
Resource
|
Resource
|
Number
|
|
ResourceID
|
|
|
|
|
ResourceName
|
ResourceName
|
ResourceName
|
String
|
|
ResourceName
|
|
|
|
|
RiskTaker
|
Eigen risicodrager
|
Eigen risicodrager
|
String
|
|
RiskTaker
|
|
|
|
|
Property starting with S |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Sector
|
Sector
|
Sector
|
String
|
|
Sector
|
|
|
|
|
Sliptextline1
|
Sliptekst regel 1
|
Sliptekst regel 1
|
String
|
|
Sliptextline1
|
|
|
|
|
Sliptextline2
|
Sliptekst regel 2
|
Sliptekst regel 2
|
String
|
|
Sliptextline2
|
|
|
|
|
Sliptextline3
|
Sliptekst regel 3
|
Sliptekst regel 3
|
String
|
|
Sliptextline3
|
|
|
|
|
SocialSecurityNumber
|
|
|
String
|
|
SocialSecurityNumber
|
|
|
|
|
SortDeclaration
|
Aard melding
|
Aard melding
|
String
|
|
SortDeclaration
|
|
|
|
|
SpecialTaxPercentage
|
Loonheffing bijzonder tarief
|
Loonheffing bijzonder tarief
|
Number
|
|
SpecialTaxPercentage
|
|
|
|
|
StartDate
|
|
|
Date
|
|
StartDate
|
|
|
|
|
StartDateTaxrebate
|
Datum ingang
|
Datum ingang
|
Date
|
|
StartDateTaxrebate
|
|
|
|
|
Subsector
|
CAO
|
CAO
|
String
|
|
Subsector
|
|
|
|
|
Property starting with T |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
TableColor
|
Tabelkleur
|
Tabelkleur
|
String
|
|
TableColor
|
|
|
|
|
TakenDaysTSF
|
Tijdspaarfonds dagen opgenomen
|
Tijdspaarfonds dagen opgenomen
|
Number
|
|
TakenDaysTSF
|
|
|
|
|
TaxPayment
|
Loonheffing
|
Loonheffing
|
Boolean
|
|
TaxPayment
|
|
|
|
|
Property starting with U |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
UseDailyTaxTable
|
Dagtabel toepassen
|
Dagtabel toepassen
|
String
|
|
UseDailyTaxTable
|
|
|
|
|
UTAStaff
|
UTA personeel
|
UTA personeel
|
Boolean
|
|
UTAStaff
|
|
|
|
|
Property starting with W |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
WAO
|
WAO
|
WAO
|
String
|
|
WAO
|
|
|
|
|
WorkDisabledRebate
|
Code Arbeidsgehandicaptenkorting
|
Code Arbeidsgehandicaptenkorting
|
String
|
|
WorkDisabledRebate
|
|
|
|
|
WW
|
WW
|
WW
|
String
|
|
WW
|
|
|
|
|
Property starting with Y |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
YoungDisabledRebate
|
Jonggehandicapten korting
|
Jonggehandicapten korting
|
Boolean
|
|
YoungDisabledRebate
|
|
|
|
|
Property starting with Z |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ZFW
|
ZVW
|
ZVW
|
String
|
|
ZFW
|
|
|
|
|
ZW
|
ZW
|
ZW
|
String
|
|
ZW
|
|
|
|
|
Property starting with A |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ABPEndDate
|
ABPEindDatum
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPParticipationType
|
ABPAardDeelnemerschap
|
String
|
|
1
|
0
|
W
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ABPPartTimeFactor
|
ABPDeeltijdfactor
|
Number
|
|
8
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPPercentageParticipation
|
ABPPercentageDeelnemerschap
|
Number
|
|
8
|
3
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPSequenceNumber
|
ABPVolgnummer
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPStartDate
|
ABPStartDatum
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPValueParticipation
|
ABPWaardeDeelnemerschap
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ABUEndDate
|
ABUEindDatum
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABUNumberofWeeksNotWorked
|
ABUWekenNietGewerkt
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABUStartDate
|
ABUStartDatum
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AdditionalElderlyRebate
|
AanvullendeOuderenkorting
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
AmountB
|
BedragB
|
String
|
|
4
|
0
|
0000
|
|
|
|
|
|
|
|
|
|
|
|
AmountBenefitPayment
|
BedragUitkering
|
String
|
|
5
|
0
|
00000
|
|
|
|
|
|
|
|
|
|
|
|
AmountExtraTaxAmount
|
BedragExtraLoonheffing
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
AmountSpecialSituation1
|
BedragSpecialeAanduiding1
|
Number
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AmountSpecialSituation2
|
BedragSpecialeAanduiding2
|
Number
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AmountSpecialSituation3
|
BedragSpecialeAanduiding3
|
Number
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AmountWAOPayment
|
BedragWAOUitkering
|
String
|
|
5
|
0
|
00000
|
|
|
|
|
|
|
|
|
|
|
|
AnnualWageSpecialTax
|
JaarloonBijzonderTarief
|
Number
|
|
11
|
2
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
AverageHoursPerWeek
|
UrenPerWeekGemiddeld
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with B |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
BasicValueRelanVNPS
|
LoonsomRelanVNPS
|
Number
|
|
8
|
2
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
BeneficialRegulation
|
Voordeelregel
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
BirthDate
|
BirthDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BPFInsured
|
CodeBPFHorecaEnBakkers
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
BTERDays
|
DagenBTER
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BTERDaysDeviated
|
DagenBTERAfwijkend
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
BTERHourlyWage
|
BTERUurloon
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with C |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
CalcDaysWeek
|
CalcDaysWeek
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CalcHoursWeek
|
CalcHoursWeek
|
Number
|
|
6
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CalcPtf
|
CalcPtf
|
Number
|
|
8
|
6
|
|
|
|
|
|
|
|
|
|
|
|
|
CalcPtfMethod
|
CalcPtfMethod
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CalcSvdaysMethod
|
CalcSvdaysMethod
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CAOCode
|
CAOCode
|
String
|
|
4
|
0
|
0000
|
|
|
|
|
|
|
|
|
|
|
|
CheckPeriod
|
PeilPeriode
|
Number
|
|
3
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
CheckYear
|
Peiljaar
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeCAO
|
CodeCAO
|
Number
|
|
4
|
0
|
9999
|
|
|
|
|
|
|
|
|
|
|
|
CodeContract
|
CodeContract
|
String
|
|
1
|
0
|
O
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeExceptions
|
CodePremieVrijstellingen
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeExtraTaxPayment
|
CodeExtraLoonheffing
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeFranchise
|
CodeFranchise
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeIncomeReduction
|
CodeInkomstenVermindering
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodePhaseFZ
|
CodeFaseFZ
|
String
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeReasonNoIncreaseValue
|
CodeRedenGeenBijtelling
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeSpecialSituation1
|
CodeSpecialeAanduiding1
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
CodeSpecialSituation2
|
CodeSpecialeAanduiding2
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
CodeSpecialSituation3
|
CodeSpecialeAanduiding3
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
CodeSpecialSituationSV
|
CodeSpecialeAanduidingSV
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
CodeTaxDeduction
|
CodeVermindering
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeTaxDeductionLowWages
|
CodeVerminderingLageLonenDB
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
|
CodeTaxRebate
|
CodeLoonheffingskorting
|
String
|
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeTypeofIncome
|
CodeSoortInkomen
|
String
|
|
2
|
0
|
15
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CodeVUTHoreca
|
CodeVUTHoreca
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
CodeZVW
|
CodeZVW
|
String
|
|
1
|
0
|
C
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CompanyCar
|
AutoVanDeZaak
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CompanyCode
|
CompanyCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ComponentGroup
|
ComponentGroup
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ComponentGroupDescription
|
ComponentGroupDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractEndDate
|
ContractEndDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CorrectionType
|
TypeCorrectie
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CorrectionWorkrelationship
|
CorrectieArbeidsverhouding
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CostCenter
|
CostCenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostRegulationArtist
|
KostenbeschikkingArtiest
|
Number
|
|
8
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryCode
|
CountryCode
|
String
|
|
3
|
0
|
NL
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
Created
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
CreatedOn
|
AangemaaktOp
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreateMSV
|
MeldingSocialeVerzekeringMaken
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
Creator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
CreatorName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorNumber
|
CreditorNumber
|
String
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CVZCountryFactor
|
CVZwoonlandfactor
|
Number
|
|
6
|
4
|
|
0
|
9.9999
|
|
|
|
|
|
|
|
|
|
Property starting with D |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
DatePersonnelDeclaration
|
DatumWijzigingMelding
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DaysBenefitPayment
|
DagenAanvulling
|
String
|
|
3
|
0
|
000
|
|
|
|
|
|
|
|
|
|
|
|
DaysPerPeriod
|
DagenPerPeriode
|
Number
|
|
6
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
DaysScholarship
|
DagenLeerplichtig
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
DeclarationLastAction
|
DeclarationLastAction
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
DeclarationPeriod
|
DeclarationPeriod
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DeclarationType
|
DeclarationType
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DispensationRiskFund
|
DispensatieRisicofonds
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with E |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
EmploymentNumber
|
NummerInkomstenverhouding
|
String
|
|
4
|
0
|
1
|
1
|
9999
|
0123456789
|
|
|
|
|
|
|
|
|
EmploymentStart
|
EmploymentStart
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EndDate
|
EndDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ExceptionRule
|
Uitzondering
|
String
|
|
1
|
0
|
G
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ExceptionWorkrelationship
|
Uitzonderingssituatie
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with F |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
FixedAmountTaxDeduction
|
CodeVerminderingVastBedrag
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
FixedWorkingHours
|
RegelmatigArbeidspatroon
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with G |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
GovernmentPersonnel
|
Overheidspersoneel
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
GrossAnnualWage
|
BrutoJaarloon
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with H |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
HoursTaxReduction
|
UrenVermindering
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
HoursWorkedThisYear
|
UrenDitJaarGewerkt
|
String
|
|
4
|
0
|
0000
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with I |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ID
|
ID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IndicationEmployment
|
AanduidingInkomstenverhouding
|
String
|
|
4
|
0
|
|
1
|
9999
|
0123456789
|
|
|
|
|
|
|
|
|
IVDeviatingDate
|
IVDeviatingDate
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
IVEndDate
|
IVEndDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IVStartDate
|
IVStartDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with L |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
LifeCourseRebate
|
LevensloopVerlofKorting
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
LineType
|
SoortRegel
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with M |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ModifiedDate
|
Modified
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
Modifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
ModifierName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with N |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
NameComposition
|
SamenstellingNaam
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
NatureOfWorkrelationship
|
AardArbeidsovereenkomst
|
String
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with P |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ParticipantBPS
|
DeelnemerBPS
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ParticipantOBF
|
DeelnemerOBF
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ParticipantSteinkuhlerfund
|
DeelnemerSteinkuhlerfonds
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ParticipantVNPS
|
DeelnemerVNPS
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
PaymentPeriod
|
PaymentPeriod
|
String
|
|
1
|
0
|
M
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PayrollYear
|
PayrollYear
|
String
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PercentageCompensationRegulation
|
PercentageVergoedingsregeling
|
Number
|
|
8
|
3
|
|
|
|
|
|
|
|
|
|
|
|
|
PercentageEmploymentDisabled
|
PercentageArbeidsongeschiktheid
|
String
|
|
3
|
0
|
000
|
|
|
|
|
|
|
|
|
|
|
|
Period
|
Period
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PremiumGroup
|
Premiegroep
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with R |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ReasonEndofService
|
EindeDienstverband
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ReducibleTaxCalculation
|
Herleidingsregel
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ReductionWAPremium
|
ReductiePremieWachtgeld
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
RegularEmployment
|
OpBasisVanArbeidsovereenkomst
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
ResourceCostCenter
|
ResourceCostCenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceID
|
ResourceID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceName
|
ResourceName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
RiskTaker
|
Eigenrisicodrager
|
String
|
|
1
|
0
|
2
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with S |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Sector
|
Sector
|
String
|
|
2
|
0
|
select isnull(stringvalue, '00') from settings where settinggroup='salaris' and settingname='sbi_code'
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Sliptextline1
|
SliptekstRegel1
|
String
|
|
70
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sliptextline2
|
SliptekstRegel2
|
String
|
|
70
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sliptextline3
|
SliptekstRegel3
|
String
|
|
70
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SocialSecurityNumber
|
SocialSecurityNumber
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SortDeclaration
|
AardMelding
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
SpecialTaxPercentage
|
LoonheffingBijzonderTarief
|
Number
|
|
8
|
2
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
StartDate
|
StartDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
StartDateTaxrebate
|
DatumIngangLoonheffingskorting
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Subsector
|
Subsector
|
String
|
|
4
|
0
|
select isnull(stringvalue, '0000') from settings where settinggroup='salaris' and settingname='trj_aansl_nr'
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with T |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
TableColor
|
TabelKleur
|
String
|
|
1
|
0
|
W
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
TakenDaysTSF
|
TSFDagenOpgenomen
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
TaxPayment
|
Loonheffing
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with U |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
UseDailyTaxTable
|
DagtabelToepassen
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UTAStaff
|
UTAPersoneel
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with W |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
WAO
|
WAO
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
WorkDisabledRebate
|
Arbeidsgehandicaptenkorting
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
WW
|
WW
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Property starting with Y |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
YoungDisabledRebate
|
JonggehandicaptenKorting
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with Z |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ZFW
|
ZFW
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ZW
|
ZW
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|