# EmployerSalaryRecognitionComponentTypes - Catalog: `XAS` - Retrieve: true - Topic: `Message` - Base XPath: `/xas:Message` - XPath: `/xas:Inhpl/xas:Lnadm/xas:Lncmp` The data in this table is partitioned per value of the COMPANY_NAME column. ## Table Columns The columns of the table `EmployerSalaryRecognitionComponentTypes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUDIT_FILE_VERSION` | `string(240)` | | ☐ | | | `BRUTONETTO` | `string(2)` | | | | | `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)` | | ☑ | | | `IDLNCMP` | `string(20)` | | | | | `INTERFACE_URL` | `string(4000)` | | ☑ | | | `LNADM_INHPL_BDRVRLPGVRMSPONTW` | `decimal` | Employer Provisional Amount Remittance S&O | | | | `LNADM_INHPL_MESSAGE_BRALG_AANDATAUD` | `datetime` | Message General Creation Date Audit File | | | | `LNADM_INHPL_MESSAGE_BRALG_AANDATBR` | `datetime` | Message General Creation Date Message | | | | `LNADM_INHPL_MESSAGE_BRALG_BLJR` | `int64` | Message General Fiscal Year | | | | `LNADM_INHPL_MESSAGE_BRALG_BRCD` | `string(5)` | Message General Message Code | | | | `LNADM_INHPL_MESSAGE_BRALG_TOTLNLBPH` | `decimal` | Message General Total Salary LB/PH | | | | `LNADM_INHPL_MESSAGE_BRALG_VNRBRCD` | `string(5)` | Message General Message Version Number | | | | `LNADM_INHPL_NM` | `string(35)` | Employer Name | | | | `LNADM_INHPL_STRADRNL_HUISNR` | `int64` | Street: The Netherlands House Number | | | | `LNADM_INHPL_STRADRNL_HUISTOEV` | `string(4)` | Street: The Netherlands House Number Addition | | | | `LNADM_INHPL_STRADRNL_PC` | `string(6)` | Street: The Netherlands Postcode | | | | `LNADM_INHPL_TWDLNM` | `string(35)` | Employer Second Part Name | | | | `LNADM_KLNTNRLSB` | `string(12)` | Employer Salary Administration Customer Number Payroll Service Office | | | | `LNADM_LHNR` | `string(12)` | Employer Salary Administration Payroll Tax Number | | | | `LNADM_NMAPPL` | `string(35)` | Employer Salary Administration Application Name | | | | `LNADM_VALCD` | `string(3)` | Employer Salary Administration Currency Code | | | | `LNADM_VERAPPL` | `string(70)` | Employer Salary Administration Application Version | | | | `LNCMPCD` | `string(2)` | | | | | `LNCMPTYPECD` | `string(2)` | | | | | `OMSLNCMP` | `string(35)` | | | | | `PRODUCT_ID` | `string(240)` | | ☐ | | | `PRODUCT_VERSION` | `string(240)` | | ☐ | | | `WZBLCD` | `string(1)` | | | |