XAS 7.0 Data Model

AANTSV

decimal

Social Security Days

AUDIT_FILE_VERSION

string(240)

Audit File Version

☐

COMPANY_ID

string(240)

Company ID

☐

COMPANY_NAME

string(1000)

Company Name

☐

COMPANY_POSTAL_CODE

string(240)

Company Postal Code

☐

COMPANY_TAX_REG_IDENT

string(240)

Wage Tax Registration Number

☐

ENDDAT

datetime

End Date

FILE_CURRENCY_CODE

string(240)

File Currency Code

☐

FILE_DATE_CREATED

string(240)

File Creation Date

☐

FISCAL_YEAR_NUMBER

string(240)

Fiscal Year Number

☑

INGDAT

datetime

Start Date

INKVRHVAR_BDRGRNDSLGAFDRCHTVRMWVA

decimal

INKVRHVAR_BIJTELPERC

decimal

Income Ratio Variable Surcharge Percentage

INKVRHVAR_CATPRIJSAUTO

decimal

Income Ratio Variable Catalogue Value Car

INKVRHVAR_CDRDNGNBIJT

string(1)

Income Ratio Variable Reason no Surcharge Car

INKVRHVAR_DLTFCT

decimal

Income Ratio Variable Part-time Factor

INKVRHVAR_GEBRAUTO

int64

Income Ratio Variable Uses Car

INKVRHVAR_IND30RGL

string(1)

INKVRHVAR_INDDLNMLVNSLPJN

string(1)

INKVRHVAR_INDGEMBEZ

string(1)

INKVRHVAR_INDSTUDSCH

string(1)

Income Ratio Variable Educational Debt

INKVRHVAR_INDVAKBN

string(1)

Income Ratio Variable Holiday Coupons

INKVRHVAR_INDVRVR

string(1)

Income Ratio Variable Transport due to Obliged Withholding

INKVRHVAR_INDWIA

string(1)

Income Ratio Variable WIA Insurance

INKVRHVAR_INDWW

string(1)

Income Ratio Variable WW Insurance

INKVRHVAR_INDZVW

string(1)

Income Ratio Variable ZVW Insurance

INKVRHVAR_INDZW

string(1)

Income Ratio Variable ZW Insurance

INKVRHVAR_LBTAB

string(3)

INKVRHVAR_LNHFKRTJN

string(1)

INKVRHVAR_LNLBPH

decimal

Income Ratio Variable Income LB/PH

INKVRHVAR_LNSV

decimal

Income Ratio Variable Sociale Security Income

INKVRHVAR_PRAWF

decimal

Income Ratio Variable Premium WW AWF Employer and Employee

INKVRHVAR_PRUFO

decimal

Income Ratio Variable Premium Ufo

INKVRHVAR_PRWAOAOF

decimal

Income Ratio Variable Base Premium WAO/IVE/WGA

INKVRHVAR_PRWAOAOK

decimal

Income Ratio Variable Uniform Premium WAO / Differentiated Premium WGA

INKVRHVAR_PRWGF

decimal

Income Ratio Variable Premium Industry Fund

INKVRHVAR_SRTVAKBNCD

int64

Income Ratio Variable Holiday Coupon Type Code

INKVRHVAR_VRDLRGLTGPSTJN

string(1)

INKVRHVAR_WRDPRGEBRAUT

decimal

Income Ratio Variable Value Personal Use Car

INKVRHVAR_WRKNBIJDRAUT

decimal

Income Ratio Variable Employee Participation Car

INKVRHVST_AANSLNRUWV

string(20)

Employee Fixed Salary Ratio Connection Number UWV

INKVRHVST_BRPOMS

string(35)

Employee Fixed Salary Ratio Job Description

INKVRHVST_CAOCD

int64

Employee Fixed Salary Ratio CLA Code

INKVRHVST_ENDDAT

datetime

Employee Fixed Salary Ratio End Date

INKVRHVST_INGDAT

datetime

Employee Fixed Salary Ratio Start Date

INKVRHVST_JRLNTBBZBEL

int64

Employee Fixed Salary Ratio Annual Income for Special Income Table

INKVRHVST_SRTINKCD

int64

Employee Fixed Salary Ratio Income Type Code

INKVRHVST_WRKNMR_GEBDAT

datetime

Employee Date of Birth

INKVRHVST_WRKNMR_GESL

string(1)

Employee Gender

INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATAUD

datetime

Message General Creation Date Audit File

INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATBR

datetime

Message General Creation Date Message

INKVRHVST_WRKNMR_MESSAGE_BRALG_BLJR

int64

Message General Fiscal Year

INKVRHVST_WRKNMR_MESSAGE_BRALG_BRCD

string(5)

Message General Message Code

INKVRHVST_WRKNMR_MESSAGE_BRALG_TOTLNLBPH

decimal

Message General Total Salary LB/PH

INKVRHVST_WRKNMR_MESSAGE_BRALG_VNRBRCD

string(5)

Message General Message Version Number

INKVRHVST_WRKNMR_MESSAGE_INHPL_BDRVRLPGVRMSPONTW

decimal

Employer Provisional Amount Remittance S&O

INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_KLNTNRLSB

string(12)

Employer Salary Administration Customer Number Payroll Service Office

INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_LHNR

string(12)

Employer Salary Administration Payroll Tax Number

INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_NMAPPL

string(35)

Employer Salary Administration Application Name

INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VALCD

string(3)

Employer Salary Administration Currency Code

INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL

string(70)

Employer Salary Administration Application Version

INKVRHVST_WRKNMR_MESSAGE_INHPL_NM

string(35)

Employer Name

INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR

int64

Street Address the Netherlands House Number

INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV

string(4)

Street Address the Netherlands House Number Addition

INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_PC

string(6)

Street Address the Netherlands Postal Code

INKVRHVST_WRKNMR_MESSAGE_INHPL_TWDLNM

string(35)

Employer Second Part Name

INKVRHVST_WRKNMR_NAT

string(4)

Employee Nationality

INKVRHVST_WRKNMR_PERSNR

string(35)

Employee Employee Number

INKVRHVST_WRKNMR_SIGNNM

string(200)

Employee Significant Part Last Name

INKVRHVST_WRKNMR_SOFINR

int64

Employee Social Security Number

INKVRHVST_WRKNMR_VOORL

string(6)

Employee Initials

INKVRHVST_WRKNMR_VOORV

string(10)

Employee Prefixes

INTERFACE_URL

string(4000)

Interface URL

☑

PRDNR

int64

Period Number

PRODUCT_ID

string(240)

Product ID

☐

PRODUCT_VERSION

string(240)

Product Version

☐