Please enable JavaScript to view this site.

Navigation: » No topics above this level «

EmployerSalaryRecognitionComponentTypes

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:Inhpl/xas:Lnadm/xas:Lncmp

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

Arbeitgeber 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 Meldung-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)

Arbeitgeber Name

 

 

LNADM_INHPL_STRADRNL_HUISNR

int64

Straße: Die Niederlande Hausnummer

 

 

LNADM_INHPL_STRADRNL_HUISTOEV

string(4)

Straße: Die Niederlande House Number Addition

 

 

LNADM_INHPL_STRADRNL_PC

string(6)

Straße: Die Niederlande Postleitzahl

 

 

LNADM_INHPL_TWDLNM

string(35)

Arbeitgeber 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 Anwendungsname

 

 

LNADM_VALCD

string(3)

Employer Salary Administration Währungscode

 

 

LNADM_VERAPPL

string(70)

Employer Salary Administration Anwendungsversion

 

 

LNCMPCD

string(2)

 

 

 

LNCMPTYPECD

string(2)

 

 

 

OMSLNCMP

string(35)

 

 

 

PRODUCT_ID

string(240)

 

 

PRODUCT_VERSION

string(240)

 

 

WZBLCD

string(1)

 

 

 

 

29-05-2022 00:56 Version 22.0.196-PROD+3400