XAS 7.0 Data Model

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

☐

FILE_CURRENCY_CODE

string(240)

File Currency Code

☐

FILE_DATE_CREATED

string(240)

File Creation Date

☐

FISCAL_YEAR_NUMBER

string(240)

Fiscal Year Number

☑

GEBDAT

datetime

Date of Birth

GESL

string(1)

Gender

INTERFACE_URL

string(4000)

Interface URL

☑

MESSAGE_BRALG_AANDATAUD

datetime

Message General Creation Date Audit File

MESSAGE_BRALG_AANDATBR

datetime

Message General Creation Date Message

MESSAGE_BRALG_BLJR

int64

Message General Fiscal Year

MESSAGE_BRALG_BRCD

string(5)

Message General Message Code

MESSAGE_BRALG_TOTLNLBPH

decimal

Message General Total Salary LB/PH

MESSAGE_BRALG_VNRBRCD

string(5)

Message General Message Version Number

MESSAGE_INHPL_BDRVRLPGVRMSPONTW

decimal

Employer Provisional Amount Remittance S&O

MESSAGE_INHPL_LNADM_KLNTNRLSB

string(12)

Employer Salary Administration Customer Number Payroll Service Office

MESSAGE_INHPL_LNADM_LHNR

string(12)

Employer Salary Administration Payroll Tax Number

MESSAGE_INHPL_LNADM_NMAPPL

string(35)

Employer Salary Administration Application Name

MESSAGE_INHPL_LNADM_VALCD

string(3)

Employer Salary Administration Currency Code

MESSAGE_INHPL_LNADM_VERAPPL

string(70)

Employer Salary Administration Application Version

MESSAGE_INHPL_NM

string(35)

Employer Name

MESSAGE_INHPL_STRADRNL_HUISNR

int64

Street Address the Netherlands House Number

MESSAGE_INHPL_STRADRNL_HUISTOEV

string(4)

Street Address the Netherlands House Number Addition

MESSAGE_INHPL_STRADRNL_PC

string(6)

Street Address the Netherlands Postal Code

MESSAGE_INHPL_TWDLNM

string(35)

Employer Second Part Name

NAT

string(4)

Nationality

PERSNR

string(35)

Employee Number

PRODUCT_ID

string(240)

Product ID

☐

PRODUCT_VERSION

string(240)

Product Version

☐

SIGNNM

string(200)

Significant Part Last Name

SOFINR

int64

Social Security Number

VOORL

string(6)

Initials

VOORV

string(10)

Prefixes