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
|
|
|
|
|
|
|
|
|
|
|
W,0,Werknemer | A,0,Voormalig werknemer met ontslaguitkering | B,0,Voormalig werknemer met functioneel leeftijdsontslag | C,0,Voormalig werknemer met VUT of FPU uitkering | D,0,Voormalig werknemer met suppletie | E,0,Verlof wegens politieke functie | F,0,Verlof wegens functie bij EG NAVO e.d. | G,0,Verlof wegens militaire functie | H,0,Verlof wegens functie op de Nederlandse Antillen | I,0,Verlof wegens functie ombudsman | J,0,Verlof alle andere situaties |
|
ABPPartTimeFactor
|
ABPDeeltijdfactor
|
Number
|
|
8
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPPercentageParticipation
|
ABPPercentageDeelnemerschap
|
Number
|
|
8
|
3
|
100
|
|
|
|
|
|
|
|
|
|
|
|
ABPSequenceNumber
|
ABPVolgnummer
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPStartDate
|
ABPStartDatum
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ABPValueParticipation
|
ABPWaardeDeelnemerschap
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,100: de diensttijd telt volledig mee | 1,0,050: de diensttijd telt voor de helft mee | 2,0,000: de diensttijd telt niet mee |
|
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
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CalcPtf
|
CalcPtf
|
Number
|
|
8
|
6
|
|
|
|
|
|
|
|
|
|
|
|
|
CalcPtfMethod
|
CalcPtfMethod
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
A,0,Automatisch | V,0,Vaste waarde gebruiken |
|
CalcSvdaysMethod
|
CalcSvdaysMethod
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
A,0,Automatisch | V,0,Vaste waarden gebruiken |
|
CAOCode
|
CAOCode
|
String
|
|
4
|
0
|
0000
|
|
|
|
|
|
|
|
|
|
|
|
CheckPeriod
|
PeilPeriode
|
Number
|
|
3
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
CheckYear
|
Peiljaar
|
String
|
|
75
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CodeCAO
|
CodeCAO
|
Number
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CodeContract
|
CodeContract
|
String
|
|
1
|
0
|
O
|
|
|
|
|
|
|
|
|
|
|
O,0,Onbepaald | B,0,Bepaald | C,0,Contractgegevens |
|
CodeExceptions
|
CodePremieVrijstellingen
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 2,0,2 Gemoedsbezwaard | 4,0,4 Marginale arbeid | 5,0,5 Arbeidsgehandicapt | 7,0,Combinatie van 2 en 5 | 9,0,Combinatie van 4 en 5 |
|
CodeExtraTaxPayment
|
CodeExtraLoonheffing
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,0,Niet van toepassing | P,0,Percentage | B,0,Bedrag |
|
CodeFranchise
|
CodeFranchise
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Geen franchise | 1,0,Minder dan 10 dagen | 2,0,Vanaf 10 t/m 19 dagen | 3,0,Vanaf 20 dagen |
|
CodeIncomeReduction
|
CodeInkomstenVermindering
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,0,Niet van toepassing | B,0,Bevalling of zwangerschap | O,0,Onbetaald verlof | Z,0,Ziekte |
|
CodePhaseFZ
|
CodeFaseFZ
|
String
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,Fase 1 | 2,0,Fase 2 | 3,0,Fase 3 | 4,0,Fase 4 | 5,0,Wettelijk regime | 6,0,Ketensysteem | 17,0,Fase A | 18,0,Fase B | 19,0,Fase C | 38,0,Fase A (zonder beding met loonuitsluiting) | 40,0,Fase A (zonder beding) | 41,0,Fase 1 (zonder beding) | 42,0,Fase 2 (zonder beding) | 99,0,Contractgegevens |
|
CodeReasonNoIncreaseValue
|
CodeRedenGeenBijtelling
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,Afspraak via werkgever met belastingdienst | 2,0,Werknemer heeft beschikking belastingdienst | 4,0,Bestelauto zonder privé gebruik | 3,0,Ander bewijs |
|
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
|
|
|
|
|
|
|
|
|
|
|
N,0,Geen vermindering | L,0,Langdurig werklozen | O,0,Onderwijs | S,0,Onderwijs (Start kwalificatie) | P,0,Onderwijs en Onderwijs (Start kwalificatie) | B,0,Onderwijs en Langdurig werklozen | C,0,Onderwijs (Start kwalificatie) en Langdurig werklozen |
|
CodeTaxDeductionLowWages
|
CodeVerminderingLageLonenDB
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
|
CodeTaxRebate
|
CodeLoonheffingskorting
|
String
|
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
0,0,Geen loonheffingskorting | 1,0,Wel loonheffingskorting |
|
CodeTypeofIncome
|
CodeSoortInkomen
|
String
|
|
2
|
0
|
15
|
|
|
|
|
|
|
|
|
|
|
11,0,11 Loon/salaris ambtenaren | 12,0,12 Loon gepremieerde gesubsidieerde en gebudgetteerde instellingen | 13,0,13 Directeuren NV/BV verzekerd | 14,0,14 Loon/salaris overige werknemers niet verzekerd voor WAO | 15,0,15 Overige lonen en salarissen | 17,0,17 Directeuren NV/BV niet verzekerd | 18,0,18 Wachtgeld uitgekeerd door overheidsinstellingen | 21,0,21 Pensioen/lijfrente etc. | 22,0,22 Uitkeringen AOW | 23,0,23 Oorlogs- en verzetspensioenen | 24,0,24 Uitkeringen ANW | 31,0,31 ZW en vrijwillige verzekering ZW | 32,0,32 Uitkeringen WAO en AAW | 33,0,33 Uitkeringen nWW | 34,0,34 Uitkeringen IOAW | 35,0,35 Vervolguitkeringen nWW | 36,0,36 Uitkeringen WAZ | 37,0,37 Uitkeringen Wajong | 38,0,38 Samenloop WAZ/WAO met Wajong gelijktijdig of volgtijdelijk | 42,0,42 Uitkeringen bijstandsbesluit zelfstandigen | 43,0,43 Overige uitkeringen in het kader van de ABW | 44,0,44 Uitkeringen Wet Inkomensvoorziening Kunstenaars (WIK) | 45,0,45 Uitkeringen IOAZ | 50,0,50 Uitkeringen overige sociale verzekeringswetten |
|
CodeVUTHoreca
|
CodeVUTHoreca
|
String
|
|
2
|
0
|
00
|
|
|
|
|
|
|
|
|
|
|
|
CodeZVW
|
CodeZVW
|
String
|
|
1
|
0
|
C
|
|
|
|
|
|
|
|
|
|
|
A,0,Niet verzekeringsplichtig | B,0,Niet verzekeringsplichtig (militair) | C,0,Verzekeringsplichtig (normaal tarief) | D,0,Verzekeringsplichtig (zeelieden) | E,0,Verzekeringsplichtig (verlaagd tarief) | F,0,Verzekeringsplichtig (meerdere tarieven) |
|
CompanyCar
|
AutoVanDeZaak
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,Correctie | 2,0,Intrekking |
|
CorrectionWorkrelationship
|
CorrectieArbeidsverhouding
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 2,0,Vervangende regel (inclusief levensloop) | 3,0,Vervangende regel (exclusief levensloop) |
|
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.0000
|
9.9999
|
0123456789
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
0,0,0 Dagen | 1,0,1 Dag | 2,0,2 Dagen |
|
DeclarationLastAction
|
DeclarationLastAction
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,Correctie | 2,0,Intrekking | 3,0,Initieel |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
EndateTaxDeduction
|
CodeVerminderingEinddatum
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EndDate
|
EndDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EndDateCompensationRegulation
|
EinddatumVergoedingsregeling
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ExceptionRule
|
Uitzondering
|
String
|
|
1
|
0
|
G
|
|
|
|
|
|
|
|
|
|
|
G,0,Geen uitzondering | R,0,Vergoedingsregeling bruto bedragen exclusief vergoeding | S,0,Vergoedingsregeling bruto bedragen inclusief vergoeding | H,0,Binnenlandse artiest/sporter | P,0,Binnenlandse artiest/sporter (kostenbeschikking/kleine artiest/sporter) | B,0,Buitenlandse artiest/sporter | V,0,Buitenlandse sporter (verlaagd tarief) | C,0,Buitenlandse artiestengezelschappen en sportploegen | T,0,Thuiswerker | L,0,Studenten/scholieren regeling |
|
ExceptionWorkrelationship
|
Uitzonderingssituatie
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,0,Niet van toepassing | F,0,Familie van eigenaar | V,0,Vorige eigenaar | O,0,Oproepkracht zonder verplichting | P,0,Oproepkracht met verplichting | D,0,Directeur of grootaandeelhouder |
|
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
|
|
|
|
|
|
|
|
|
|
|
N,0,Normaal | V,0,Vervangt ambtshalve | M,0,Maximering BTER | R,0,Roostervrije dagen | A,0,Nabetaling | Z,0,Ziektewet vakantiefondsverlaging |
|
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
|
|
|
|
|
|
|
|
|
|
|
0,0,Achternaam + meisjesnaam | 1,0,Achternaam | 2,0,Meisjesnaam | 3,0,Meisjesnaam + achternaam |
|
NatureOfWorkrelationship
|
AardArbeidsovereenkomst
|
String
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
00,0,Niet van toepassing | 23,0,Publiekrechtelijke aanstelling | 01,0,Aanneming van werk | 02,0,Vertegenwoordiger | 03,0,WSW-er | 04,0,Stagiair | 05,0,Vrijwilliger of reservist politie/brandweer | 06,0,Thuiswerker | 07,0,Uitzendkracht | 08,0,Musicus of artiest | 09,0,Persoonlijke arbeid | 10,0,Deelvisser | 11,0,Topsporter | 12,0,Gemoedsbezwaarde | 13,0,Bestuurder coöp. | 14,0,PMA Scholier/student | 15,0,PMA Huisvrouw (m/v) | 16,0,PMA Uitkeringsgerechtigde | 17,0,Iemand die onbetaald verlof heeft | 18,0,GLW Scholier/student | 19,0,GLW Huisvrouw (m/v) | 20,0,GLW Asielzoeker | 21,0,GLW Overige categorieën | 22,0,VUT | 24,0,Ontslaguitkering | 25,0,Werkt als zelfstandige | 26,0,Ambtenaar |
|
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
|
|
|
|
|
|
|
|
|
|
|
M,0,Maandelijks | W,0,Wekelijks | D,0,Dagelijks | Q,0,Per kwartaal | A,0,Halfjaarlijks | Y,0,Jaarlijks | V,0,Elke 4 weken |
|
PayrollYear
|
PayrollYear
|
String
|
|
4
|
0
|
select stringvalue from settings where settingname='lnjr_std'
|
|
|
|
|
|
|
|
|
|
|
|
PercentageCompensationRegulation
|
PercentageVergoedingsregeling
|
Number
|
|
8
|
3
|
|
|
|
|
|
|
|
|
|
|
|
|
PercentageEmploymentDisabled
|
PercentageArbeidsongeschiktheid
|
String
|
|
3
|
0
|
000
|
|
|
|
|
|
|
|
|
|
|
|
Period
|
Period
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PremiumGroup
|
Premiegroep
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
G,0,Geen | A,0,Premiegroep A | B,0,Premiegroep B |
|
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
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,WerkeloosheidsWet (WW) | 2,0,Vervroegde UitTreding (VUT) | 3,0,Wet op de ArbeidsOngeschiktheid (WAO) | 5,0,Flexwerker: geen werk aangeboden | 6,0,Flexwerker: werk aangeboden | 7,0,Flexwerker: lopend arbeidscontract | 8,0,Flexwerker: opdracht ingetrokken | 9,0,Flexwerker: ontslag genomen | 4,0,Overige |
|
ReducibleTaxCalculation
|
Herleidingsregel
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,0,Niet van toepassing | A,0,A<65 Uitsluitend premieplichtig (grensarbeider) | B,0,B<65 Uitsluitend belastingplichtig | C,0,C<65 Belasting- en premieplichtig AOW/ANW | D,0,D<65 Belasting- en premieplichtig AWBZ | E,0,E<65 Niet belasting- en premieplichtig AOW/ANW | F,0,F<65 Niet belasting- en premieplichtig AWBZ | G,0,G>=65 Uitsluitend premieplichtig (grensarbeider) | H,0,H>=65 Uitsluitend belastingplichtig | I,0,I>=65 Belasting- en premieplichtig ANW | J,0,J>=65 Belasting- en premieplichtig AWBZ | K,0,K>=65 Niet belasting- en premieplichtig ANW | L,0,L>=65 Niet belasting- en premieplichtig AWBZ |
|
ReductionWAPremium
|
ReductiePremieWachtgeld
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,Vast dienstverband | 2,0,Los dienstverband |
|
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
|
|
|
|
|
|
|
|
|
|
|
1,0,Normale regeling | 2,0,Niet van toepassing | 3,0,Bijzondere regeling |
|
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'
|
|
|
|
|
|
|
|
|
|
|
00,0,00 Niet van toepassing |
|
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
|
|
|
|
|
|
|
|
|
|
|
A,0,A Indiensttreding | B,0,A Wijziging arbeidsverhouding | C,0,A Correctie eerdere melding | D,0,A Geen van bovenstaande | E,0,B Uitdiensttreding | H,0,B Wijziging uitdiensttreding | F,0,B Overlijden | G,0,B Geen van bovenstaande |
|
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'
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
TakenDaysTSF
|
TSFDagenOpgenomen
|
Number
|
|
5
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
TaxPayment
|
Loonheffing
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
TravelDaysPerYear
|
TravelDaysPerYear
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TravelDistance
|
TravelDistance
|
Number
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
A,0,Automatisch | J,0,Ja | N,0,Nee | B,0,Bij in/uitdiensttreding |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
WorkDisabledRebate
|
Arbeidsgehandicaptenkorting
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,0,Niet van toepassing | 1,0,In dienst genomen jonggehandicapte | 2,0,Herplaatste jonggehandicapte | 3,0,In dienst genomen arbeidsgehandicapte | 4,0,Herplaatste arbeidsgehandicapte |
|
WW
|
WW
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
J,0,Ja | N,0,Nee | G,0,Geen franchise |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
ZW
|
ZW
|
String
|
|
1
|
0
|
J
|
|
|
|
|
|
|
|
|
|
|
|