BasisSalaryThresholds |
Catalog: XAS
The data in this table is partitioned per value of the COMPANY_NAME column.
Retrieve: true
Topic: Message
Base XPath: /xas:Message
XPath: /xas:Wrknmr/xas:InkVrhVst/xas:Lntdvk/xas:GrPrln
Table Columns
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) |
|
☐ |
|
BDR |
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) |
|
☑ |
|
IDGRPRLN |
string(1) |
|
|
|
INTERFACE_URL |
string(4000) |
|
☑ |
|
LNTDVK_AANTSV |
decimal |
Salary Period Social Security Days |
|
|
LNTDVK_ENDDAT |
datetime |
Salary Period Enddatum |
|
|
LNTDVK_INGDAT |
datetime |
Salary Period Anfangsdatum |
|
|
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 Teilzeitfaktor |
|
|
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 Auftragsbeschreibung |
|
|
LNTDVK_INKVRHVST_CAOCD |
int64 |
Employee Fixed Salary Ratio CLA Code |
|
|
LNTDVK_INKVRHVST_ENDDAT |
datetime |
Employee Fixed Salary Ratio Enddatum |
|
|
LNTDVK_INKVRHVST_INGDAT |
datetime |
Employee Fixed Salary Ratio Anfangsdatum |
|
|
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 |
Mitarbeiter Geburtsdatum |
|
|
LNTDVK_INKVRHVST_WRKNMR_GESL |
string(1) |
Mitarbeiter Geschlecht |
|
|
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 Meldung-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 |
Arbeitgeber 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 Anwendungsname |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VALCD |
string(3) |
Employer Salary Administration Währungscode |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL |
string(70) |
Employer Salary Administration Anwendungsversion |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_NM |
string(35) |
Arbeitgeber Name |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR |
int64 |
Straße: Die Niederlande Hausnummer |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV |
string(4) |
Straße: Die Niederlande House Number Addition |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_PC |
string(6) |
Straße: Die Niederlande Postleitzahl |
|
|
LNTDVK_INKVRHVST_WRKNMR_MESSAGE_INHPL_TWDLNM |
string(35) |
Arbeitgeber Second Part Name |
|
|
LNTDVK_INKVRHVST_WRKNMR_NAT |
string(4) |
Mitarbeiter Staatsangehörigkeit |
|
|
LNTDVK_INKVRHVST_WRKNMR_PERSNR |
string(35) |
Mitarbeiter Mitarbeiter-Nummer |
|
|
LNTDVK_INKVRHVST_WRKNMR_SIGNNM |
string(200) |
Mitarbeiter Significant Part Last Name |
|
|
LNTDVK_INKVRHVST_WRKNMR_SOFINR |
int64 |
Mitarbeiter Sozialversicherungsnummer |
|
|
LNTDVK_INKVRHVST_WRKNMR_VOORL |
string(6) |
Mitarbeiter Initialen |
|
|
LNTDVK_INKVRHVST_WRKNMR_VOORV |
string(10) |
Mitarbeiter Präfixe |
|
|
LNTDVK_PRDNR |
int64 |
Salary Period Period Number |
|
|
PRODUCT_ID |
string(240) |
|
☐ |
|
PRODUCT_VERSION |
string(240) |
|
☐ |
|
29-05-2022 00:56 Version 22.0.196-PROD+3400