xMsg javascript has not been loaded.
Catalog: XAS
Label: Employee Credentials
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:Wrknmr/xas:Legbew
The columns of the table EmployeeCredentials are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
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 |
☐ |
|
DATAFG |
datetime |
Date Issued |
|
|
DATGTM |
datetime |
Date Valid till |
|
|
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 |
☑ |
|
NRLEGB |
string(30) |
Credential Number |
|
|
PLTSAFG |
string(24) |
Place Issued |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
SRTLEGBCD |
int64 |
Credential Type |
|
|
WRKNMR_GEBDAT |
datetime |
Employee Date of Birth |
|
|
WRKNMR_GESL |
string(1) |
Employee Gender |
|
|
WRKNMR_MESSAGE_BRALG_AANDATAUD |
datetime |
Message General Creation Date Audit File |
|
|
WRKNMR_MESSAGE_BRALG_AANDATBR |
datetime |
Message General Creation Date Message |
|
|
WRKNMR_MESSAGE_BRALG_BLJR |
int64 |
Message General Fiscal Year |
|
|
WRKNMR_MESSAGE_BRALG_BRCD |
string(5) |
Message General Message Code |
|
|
WRKNMR_MESSAGE_BRALG_TOTLNLBPH |
decimal |
Message General Total Salary LB/PH |
|
|
WRKNMR_MESSAGE_BRALG_VNRBRCD |
string(5) |
Message General Message Version Number |
|
|
WRKNMR_MESSAGE_INHPL_BDRVRLPGVRMSPONTW |
decimal |
Employer Provisional Amount Remittance S&O |
|
|
WRKNMR_MESSAGE_INHPL_LNADM_KLNTNRLSB |
string(12) |
Employer Salary Administration Customer Number Payroll Service Office |
|
|
WRKNMR_MESSAGE_INHPL_LNADM_LHNR |
string(12) |
Employer Salary Administration Payroll Tax Number |
|
|
WRKNMR_MESSAGE_INHPL_LNADM_NMAPPL |
string(35) |
Employer Salary Administration Application Name |
|
|
WRKNMR_MESSAGE_INHPL_LNADM_VALCD |
string(3) |
Employer Salary Administration Currency Code |
|
|
WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL |
string(70) |
Employer Salary Administration Application Version |
|
|
WRKNMR_MESSAGE_INHPL_NM |
string(35) |
Employer Name |
|
|
WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR |
int64 |
Street Address the Netherlands House Number |
|
|
WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV |
string(4) |
Street Address the Netherlands House Number Addition |
|
|
WRKNMR_MESSAGE_INHPL_STRADRNL_PC |
string(6) |
Street Address the Netherlands Postal Code |
|
|
WRKNMR_MESSAGE_INHPL_TWDLNM |
string(35) |
Employer Second Part Name |
|
|
WRKNMR_NAT |
string(4) |
Employee Nationality |
|
|
WRKNMR_PERSNR |
string(35) |
Employee Employee Number |
|
|
WRKNMR_SIGNNM |
string(200) |
Employee Significant Part Last Name |
|
|
WRKNMR_SOFINR |
int64 |
Employee Social Security Number |
|
|
WRKNMR_VOORL |
string(6) |
Employee Initials |
|
|
WRKNMR_VOORV |
string(10) |
Employee Prefixes |
|
|
12-12-2020 18:38 Version 20.1.301-BETA+3023