XAS 7.0 Data Model
Employers |
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
Table Columns
The columns of the table Employers are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
|
☐ |
|
BDRVRLPGVRMSPONTW |
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) |
|
☑ |
|
INTERFACE_URL |
string(4000) |
|
☑ |
|
LNADM_KLNTNRLSB |
string(12) |
Salary Administration Customer Number Payroll Service Office |
|
|
LNADM_LHNR |
string(12) |
Salary Administration Payroll Tax Number |
|
|
LNADM_NMAPPL |
string(35) |
Salary Administration Anwendungsname |
|
|
LNADM_VALCD |
string(3) |
Salary Administration Währungscode |
|
|
LNADM_VERAPPL |
string(70) |
Salary Administration Anwendungsversion |
|
|
MESSAGE_BRALG_AANDATAUD |
datetime |
Message General Creation Date Audit File |
|
|
MESSAGE_BRALG_AANDATBR |
datetime |
Message General Creation Date Message |
|
|
MESSAGE_BRALG_BLJR |
int64 |
Message General Fiscal Year |
|
|
MESSAGE_BRALG_BRCD |
string(5) |
Message General Meldung-Code |
|
|
MESSAGE_BRALG_TOTLNLBPH |
decimal |
Message General Total Salary LB/PH |
|
|
MESSAGE_BRALG_VNRBRCD |
string(5) |
Message General Message Version Number |
|
|
NM |
string(35) |
|
|
|
PRODUCT_ID |
string(240) |
|
☐ |
|
PRODUCT_VERSION |
string(240) |
|
☐ |
|
STRADRNL_HUISNR |
int64 |
Dutch Street Address Hausnummer |
|
|
STRADRNL_HUISTOEV |
string(4) |
Dutch Street Address House Number Addition |
|
|
STRADRNL_PC |
string(6) |
Dutch Street Address Postleitzahl |
|
|
TWDLNM |
string(35) |
|
|
|
29-05-2022 00:56 Version 22.0.196-PROD+3400
