# Timesheets - Catalog: `XAS` - Retrieve: true - Topic: `Message` - Base XPath: `/xas:Message` - XPath: `/xas:Wrknmr/xas:InkVrhVst/xas:Lntdvk/xas:Urnreg` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `Timesheets` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AANTURN` | `decimal` | | | | | `AUDIT_FILE_VERSION` | `string(240)` | | ☐ | | | `BDRTAR` | `decimal` | | | | | `COMPANY_ID` | `string(240)` | | ☐ | | | `COMPANY_NAME` | `string(1000)` | | ☐ | | | `COMPANY_POSTAL_CODE` | `string(240)` | | ☐ | | | `COMPANY_TAX_REG_IDENT` | `string(240)` | | ☐ | | | `FILE_CURRENCY_CODE` | `string(240)` | | ☐ | | | `FILE_DATE_CREATED` | `string(240)` | | ☐ | | | `FISCAL_YEAR_NUMBER` | `string(240)` | | ☑ | | | `INTERFACE_URL` | `string(4000)` | | ☑ | | | `LNTDVK_AANTSV` | `decimal` | Salary Period Social Security Days | | | | `LNTDVK_ENDDAT` | `datetime` | Salary Period End Date | | | | `LNTDVK_INGDAT` | `datetime` | Salary Period Start Date | | | | `LNTDVK_INKVRHVAR_BDRGRNDSLGAFDRCHTVRMWVA` | `decimal` | | | | | `LNTDVK_INKVRHVAR_BIJTELPERC` | `decimal` | Employee Variable Salary Ratio Surcharge Percentage | | | | `LNTDVK_INKVRHVAR_CATPRIJSAUTO` | `decimal` | Employee Variable Salary Ratio Catalogue Value Car | | | | `LNTDVK_INKVRHVAR_CDRDNGNBIJT` | `string(1)` | Employee Variable Salary Ratio Reason no Surcharge Car | | | | `LNTDVK_INKVRHVAR_DLTFCT` | `decimal` | Employee Variable Salary Ratio Part-Time Factor | | | | `LNTDVK_INKVRHVAR_GEBRAUTO` | `int64` | Employee Variable Salary Ratio Uses Car | | | | `LNTDVK_INKVRHVAR_IND30RGL` | `string(1)` | | | | | `LNTDVK_INKVRHVAR_INDDLNMLVNSLPJN` | `string(1)` | | | | | `LNTDVK_INKVRHVAR_INDGEMBEZ` | `string(1)` | | | | | `LNTDVK_INKVRHVAR_INDSTUDSCH` | `string(1)` | Employee Variable Salary Ratio Educational Debt | | | | `LNTDVK_INKVRHVAR_INDVAKBN` | `string(1)` | Employee Variable Salary Ratio Holiday Coupons | | | | `LNTDVK_INKVRHVAR_INDVRVR` | `string(1)` | Employee Variable Salary Ratio Transport due to Obliged Withholding | | | | `LNTDVK_INKVRHVAR_INDWIA` | `string(1)` | Employee Variable Salary Ratio WIA Insurance | | | | `LNTDVK_INKVRHVAR_INDWW` | `string(1)` | Employee Variable Salary Ratio WW Insurance | | | | `LNTDVK_INKVRHVAR_INDZVW` | `string(1)` | Employee Variable Salary Ratio ZVW Insurance | | | | `LNTDVK_INKVRHVAR_INDZW` | `string(1)` | Employee Variable Salary Ratio ZW Insurance | | | | `LNTDVK_INKVRHVAR_LBTAB` | `string(3)` | | | | | `LNTDVK_INKVRHVAR_LNHFKRTJN` | `string(1)` | | | | | `LNTDVK_INKVRHVAR_LNLBPH` | `decimal` | Employee Variable Salary Ratio Income LB/PH | | | | `LNTDVK_INKVRHVAR_LNSV` | `decimal` | Employee Variable Salary Ratio Sociale Security Income | | | | `LNTDVK_INKVRHVAR_PRAWF` | `decimal` | Employee Variable Salary Ratio Premium WW AWF Employer and Employee | | | | `LNTDVK_INKVRHVAR_PRUFO` | `decimal` | Employee Variable Salary Ratio Premium Ufo | | | | `LNTDVK_INKVRHVAR_PRWAOAOF` | `decimal` | Employee Variable Salary Ratio Base Premium WAO/IVE/WGA | | | | `LNTDVK_INKVRHVAR_PRWAOAOK` | `decimal` | Employee Variable Salary Ratio Uniform Premium WAO / Differentiated Premium WGA | | | | `LNTDVK_INKVRHVAR_PRWGF` | `decimal` | Employee Variable Salary Ratio Premium Industry Fund | | | | `LNTDVK_INKVRHVAR_SRTVAKBNCD` | `int64` | Employee Variable Salary Ratio Holiday Coupon Type Code | | | | `LNTDVK_INKVRHVAR_VRDLRGLTGPSTJN` | `string(1)` | | | | | `LNTDVK_INKVRHVAR_WRDPRGEBRAUT` | `decimal` | Employee Variable Salary Ratio Value Personal Use Car | | | | `LNTDVK_INKVRHVAR_WRKNBIJDRAUT` | `decimal` | Employee Variable Salary Ratio Employee Participation Car | | | | `LNTDVK_INKVRHVST_AANSLNRUWV` | `string(20)` | Employee Fixed Salary Ratio Connection Number UWV | | | | `LNTDVK_INKVRHVST_BRPOMS` | `string(35)` | Employee Fixed Salary Ratio Description | | | | `LNTDVK_INKVRHVST_CAOCD` | `int64` | Employee Fixed Salary Ratio CLA Code | | | | `LNTDVK_INKVRHVST_ENDDAT` | `datetime` | Employee Fixed Salary Ratio End Date | | | | `LNTDVK_INKVRHVST_INGDAT` | `datetime` | Employee Fixed Salary Ratio Start Date | | | | `LNTDVK_INKVRHVST_JRLNTBBZBEL` | `int64` | Employee Fixed Salary Ratio Annual Income for Special Income Table | | | | `LNTDVK_INKVRHVST_SRTINKCD` | `int64` | Employee Fixed Salary Ratio Income Type Code | | | | `LNTDVK_INKVRHVST_WRKNMR_GEBDAT` | `datetime` | Employee Date of Birth | | | | `LNTDVK_INKVRHVST_WRKNMR_GESL` | `string(1)` | Employee Gender | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATAUD` | `datetime` | Message General Creation Date Audit File | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATBR` | `datetime` | Message General Creation Date Message | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_BLJR` | `int64` | Message General Fiscal Year | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_BRCD` | `string(5)` | Message General Message Code | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_TOTLNLBPH` | `decimal` | Message General Total Salary LB/PH | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_BRALG_VNRBRCD` | `string(5)` | Message General Message Version Number | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_BDRVRLPGVRMSPONTW` | `decimal` | Employer Provisional Amount Remittance S&O | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_KLNTNRLSB` | `string(12)` | Employer Salary Administration Customer Number Payroll Service Office | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_LHNR` | `string(12)` | Employer Salary Administration Payroll Tax Number | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_NMAPPL` | `string(35)` | Employer Salary Administration Application Name | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VALCD` | `string(3)` | Employer Salary Administration Currency Code | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL` | `string(70)` | Employer Salary Administration Application Version | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_NM` | `string(35)` | Employer Name | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR` | `int64` | Street: The Netherlands House Number | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV` | `string(4)` | Street: The Netherlands House Number Addition | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_PC` | `string(6)` | Street: The Netherlands Postcode | | | | `LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_TWDLNM` | `string(35)` | Employer Second Part Name | | | | `LNTDVK_INKVRHVST_WRKNMR_NAT` | `string(4)` | Employee Nationality | | | | `LNTDVK_INKVRHVST_WRKNMR_PERSNR` | `string(35)` | Employee Number | | | | `LNTDVK_INKVRHVST_WRKNMR_SIGNNM` | `string(200)` | Employee Significant Part Last Name | | | | `LNTDVK_INKVRHVST_WRKNMR_SOFINR` | `int64` | Employee Social Security Number | | | | `LNTDVK_INKVRHVST_WRKNMR_VOORL` | `string(6)` | Employee Initials | | | | `LNTDVK_INKVRHVST_WRKNMR_VOORV` | `string(10)` | Employee Name Prefixes | | | | `LNTDVK_PRDNR` | `int64` | Salary Period Period Number | | | | `PRODUCT_ID` | `string(240)` | | ☐ | | | `PRODUCT_VERSION` | `string(240)` | | ☐ | | | `PROJID` | `string(35)` | | | | | `SRTURNCD` | `string(2)` | | | |