Please enable JavaScript to view this site.

Navigation: » No topics above this level «

EmployeeDutchAddresses: Employee Dutch Addresses

Name: EmployeeDutchAddresses

Catalog: XAS

Label: Employee Dutch Addresses

Table Columns

Name

Data Type

Label

Required

Documentation

AUDIT_FILE_VERSION

string(60)

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(60)

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

 

HUISNR

int64

House Number

 

 

HUISTOEV

string(4)

House Number Addition

 

 

INGDAT

datetime

Start Date

 

 

INTERFACE_URL

string(4000)

Interface URL

{res:itgen_interface_url_def}

LOCOMS

string(35)

Location Description

 

 

PC

string(6)

Postal Code

 

 

PRODUCT_ID

string(240)

Product ID

 

PRODUCT_VERSION

string(240)

Product Version

 

STRAAT

string(24)

Street

 

 

WNPL

string(24)

City

 

 

WRKNMR_GEBDAT

datetime

Employee Date of Birth

 

 

WRKNMR_GESL

string(1)

Employee Gender

 

 

WRKNMR_MESSAGE_BRALG_AANDATAUD

datetime

Message General Creation Date Audit File

 

 

WRKNMR_MESSAGE_BRALG_AANDATBR

datetime

Message General Creation Date Message

 

 

WRKNMR_MESSAGE_BRALG_BLJR

int64

Message General Fiscal Year

 

 

WRKNMR_MESSAGE_BRALG_BRCD

string(5)

Message General Message Code

 

 

WRKNMR_MESSAGE_BRALG_TOTLNLBPH

decimal

Message General Total Salary LB/PH

 

 

WRKNMR_MESSAGE_BRALG_VNRBRCD

string(5)

Message General Message Version Number

 

 

WRKNMR_MESSAGE_INHPL_BDRVRLPGVRMSPONTW

decimal

Employer Provisional Amount Remittance S&O

 

 

WRKNMR_MESSAGE_INHPL_LNADM_KLNTNRLSB

string(12)

Employer Salary Administration Customer Number Payroll Service Office

 

 

WRKNMR_MESSAGE_INHPL_LNADM_LHNR

string(12)

Employer Salary Administration Payroll Tax Number

 

 

WRKNMR_MESSAGE_INHPL_LNADM_NMAPPL

string(35)

Employer Salary Administration Application Name

 

 

WRKNMR_MESSAGE_INHPL_LNADM_VALCD

string(3)

Employer Salary Administration Currency Code

 

 

WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL

string(70)

Employer Salary Administration Application Version

 

 

WRKNMR_MESSAGE_INHPL_NM

string(35)

Employer Name

 

 

WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR

int64

Street Address the Netherlands House Number

 

 

WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV

string(4)

Street Address the Netherlands House Number Addition

 

 

WRKNMR_MESSAGE_INHPL_STRADRNL_PC

string(6)

Street Address the Netherlands Postal Code

 

 

WRKNMR_MESSAGE_INHPL_TWDLNM

string(35)

Employer Second Part Name

 

 

WRKNMR_NAT

string(4)

Employee Nationality

 

 

WRKNMR_PERSNR

string(35)

Employee Employee Number

 

 

WRKNMR_SIGNNM

string(200)

Employee Significant Part Last Name

 

 

WRKNMR_SOFINR

int64

Employee Social Security Number

 

 

WRKNMR_VOORL

string(6)

Employee Initials

 

 

WRKNMR_VOORV

string(10)

Employee Prefixes

 

 

 

Generated 11-01-2019 19:48 on version 17.30.0-PROD+1821.