xMsg javascript has not been loaded.
Catalog: XAS
Label: Basis Salary Thresholds
The data in this table is partitioned per value of the COMPANY_NAME column.
This is a read-only table. The XAS 7.0 API may not support changing the data or the Invantive SQL driver for XAS 7.0 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the XAS 7.0 API.
Topic: Message
Base XPath: /xas:Message
XPath: /xas:Wrknmr/xas:InkVrhVst/xas:Lntdvk/xas:GrPrln
The columns of the table BasisSalaryThresholds are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
BDR |
decimal |
Amount |
|
|
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 |
☑ |
|
IDGRPRLN |
string(1) |
Identification Base Premium Income |
|
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
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 Job 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 Address the Netherlands House Number |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV |
string(4) |
Street Address the Netherlands House Number Addition |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_PC |
string(6) |
Street Address the Netherlands Postal Code |
|
|
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 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 Prefixes |
|
|
LNTDVK_PRDNR |
int64 |
Salary Period Period Number |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
12-12-2020 18:38 Version 20.1.301-BETA+3023