SalaryRecognitionComponents

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)

☑

IBANRKNR

string(34)

IDLNCMP

string(20)

INTERFACE_URL

string(4000)

☑

LNOVERPRDNR

int64

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)

☐

RKNR

int64