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.
XAS 7.0 Data Model