itgendoc001X
xMsg javascript has not been loaded.
XAS 7.0 Data ModelCatalog: XAS
Label: Employers
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: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) |
Audit File Version |
☐ |
|
BDRVRLPGVRMSPONTW |
decimal |
Provisional Amount Remittance S&O |
|
|
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 |
☑ |
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
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 Application Name |
|
|
LNADM_VALCD |
string(3) |
Salary Administration Currency Code |
|
|
LNADM_VERAPPL |
string(70) |
Salary Administration Application Version |
|
|
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 Message Code |
|
|
MESSAGE_BRALG_TOTLNLBPH |
decimal |
Message General Total Salary LB/PH |
|
|
MESSAGE_BRALG_VNRBRCD |
string(5) |
Message General Message Version Number |
|
|
NM |
string(35) |
Name |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
STRADRNL_HUISNR |
int64 |
Dutch Street Address House Number |
|
|
STRADRNL_HUISTOEV |
string(4) |
Dutch Street Address House Number Addition |
|
|
STRADRNL_PC |
string(6) |
Dutch Street Address Postal Code |
|
|
TWDLNM |
string(35) |
Second Part Name |
|
|
12-12-2020 18:38 Version 20.1.301-BETA+3023
