SalaryPeriods: Salary Periods |
Name: SalaryPeriods
Catalog: XAS
Label: Salary Periods
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AANTSV |
decimal |
Social Security Days |
|
|
AUDIT_FILE_VERSION |
string(60) |
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(60) |
Wage Tax Registration Number |
☑ |
|
ENDDAT |
datetime |
End Date |
|
|
FILE_CURRENCY_CODE |
string(240) |
File Currency Code |
☑ |
|
FILE_DATE_CREATED |
string(240) |
File Creation Date |
☑ |
|
FISCAL_YEAR_NUMBER |
string(240) |
Fiscal Year Number |
☑ |
|
INGDAT |
datetime |
Start Date |
|
|
INKVRHVAR_BDRGRNDSLGAFDRCHTVRMWVA |
decimal |
Income Ratio Variable itgen_xas_bdr_grndslg_afdrchtvrm_wva |
|
|
INKVRHVAR_BIJTELPERC |
decimal |
Income Ratio Variable Surcharge Percentage |
|
|
INKVRHVAR_CATPRIJSAUTO |
decimal |
Income Ratio Variable Catalogue Value Car |
|
|
INKVRHVAR_CDRDNGNBIJT |
string(1) |
Income Ratio Variable Reason no Surcharge Car |
|
|
INKVRHVAR_DLTFCT |
decimal |
Income Ratio Variable Part-time Factor |
|
|
INKVRHVAR_GEBRAUTO |
int64 |
Income Ratio Variable Uses Car |
|
|
INKVRHVAR_IND30RGL |
string(1) |
Income Ratio Variable itgen_xas_ind30_rgl |
|
|
INKVRHVAR_INDDLNMLVNSLPJN |
string(1) |
Income Ratio Variable itgen_xas_ind_dlnm_lvnslp_jn |
|
|
INKVRHVAR_INDGEMBEZ |
string(1) |
Income Ratio Variable itgen_xas_ind_gembez |
|
|
INKVRHVAR_INDSTUDSCH |
string(1) |
Income Ratio Variable Educational Debt |
|
|
INKVRHVAR_INDVAKBN |
string(1) |
Income Ratio Variable Holiday Coupons |
|
|
INKVRHVAR_INDVRVR |
string(1) |
Income Ratio Variable Transport due to Obliged Withholding |
|
|
INKVRHVAR_INDWIA |
string(1) |
Income Ratio Variable WIA Insurance |
|
|
INKVRHVAR_INDWW |
string(1) |
Income Ratio Variable WW Insurance |
|
|
INKVRHVAR_INDZVW |
string(1) |
Income Ratio Variable ZVW Insurance |
|
|
INKVRHVAR_INDZW |
string(1) |
Income Ratio Variable ZW Insurance |
|
|
INKVRHVAR_LBTAB |
string(3) |
Income Ratio Variable itgen_xas_lb_tab |
|
|
INKVRHVAR_LNHFKRTJN |
string(1) |
Income Ratio Variable itgen_xas_lnhfkrt_jn |
|
|
INKVRHVAR_LNLBPH |
decimal |
Income Ratio Variable Income LB/PH |
|
|
INKVRHVAR_LNSV |
decimal |
Income Ratio Variable Sociale Security Income |
|
|
INKVRHVAR_PRAWF |
decimal |
Income Ratio Variable Premium WW AWF Employer and Employee |
|
|
INKVRHVAR_PRUFO |
decimal |
Income Ratio Variable Premium Ufo |
|
|
INKVRHVAR_PRWAOAOF |
decimal |
Income Ratio Variable Base Premium WAO/IVE/WGA |
|
|
INKVRHVAR_PRWAOAOK |
decimal |
Income Ratio Variable Uniform Premium WAO / Differentiated Premium WGA |
|
|
INKVRHVAR_PRWGF |
decimal |
Income Ratio Variable Premium Industry Fund |
|
|
INKVRHVAR_SRTVAKBNCD |
int64 |
Income Ratio Variable Holiday Coupon Type Code |
|
|
INKVRHVAR_VRDLRGLTGPSTJN |
string(1) |
Income Ratio Variable itgen_xas_vrdlrgl_tgpst_jn |
|
|
INKVRHVAR_WRDPRGEBRAUT |
decimal |
Income Ratio Variable Value Personal Use Car |
|
|
INKVRHVAR_WRKNBIJDRAUT |
decimal |
Income Ratio Variable Employee Participation Car |
|
|
INKVRHVST_AANSLNRUWV |
string(20) |
Employee Fixed Salary Ratio Connection Number UWV |
|
|
INKVRHVST_BRPOMS |
string(35) |
Employee Fixed Salary Ratio Job Description |
|
|
INKVRHVST_CAOCD |
int64 |
Employee Fixed Salary Ratio CLA Code |
|
|
INKVRHVST_ENDDAT |
datetime |
Employee Fixed Salary Ratio End Date |
|
|
INKVRHVST_INGDAT |
datetime |
Employee Fixed Salary Ratio Start Date |
|
|
INKVRHVST_JRLNTBBZBEL |
int64 |
Employee Fixed Salary Ratio Annual Income for Special Income Table |
|
|
INKVRHVST_SRTINKCD |
int64 |
Employee Fixed Salary Ratio Income Type Code |
|
|
INKVRHVST_WRKNMR_GEBDAT |
datetime |
Employee Date of Birth |
|
|
INKVRHVST_WRKNMR_GESL |
string(1) |
Employee Gender |
|
|
INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATAUD |
datetime |
Message General Creation Date Audit File |
|
|
INKVRHVST_WRKNMR_MESSAGE_BRALG_AANDATBR |
datetime |
Message General Creation Date Message |
|
|
INKVRHVST_WRKNMR_MESSAGE_BRALG_BLJR |
int64 |
Message General Fiscal Year |
|
|
INKVRHVST_WRKNMR_MESSAGE_BRALG_BRCD |
string(5) |
Message General Message Code |
|
|
INKVRHVST_WRKNMR_MESSAGE_BRALG_TOTLNLBPH |
decimal |
Message General Total Salary LB/PH |
|
|
INKVRHVST_WRKNMR_MESSAGE_BRALG_VNRBRCD |
string(5) |
Message General Message Version Number |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_BDRVRLPGVRMSPONTW |
decimal |
Employer Provisional Amount Remittance S&O |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_KLNTNRLSB |
string(12) |
Employer Salary Administration Customer Number Payroll Service Office |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_LHNR |
string(12) |
Employer Salary Administration Payroll Tax Number |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_NMAPPL |
string(35) |
Employer Salary Administration Application Name |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VALCD |
string(3) |
Employer Salary Administration Currency Code |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_LNADM_VERAPPL |
string(70) |
Employer Salary Administration Application Version |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_NM |
string(35) |
Employer Name |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISNR |
int64 |
Street Address the Netherlands House Number |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_HUISTOEV |
string(4) |
Street Address the Netherlands House Number Addition |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_STRADRNL_PC |
string(6) |
Street Address the Netherlands Postal Code |
|
|
INKVRHVST_WRKNMR_MESSAGE_INHPL_TWDLNM |
string(35) |
Employer Second Part Name |
|
|
INKVRHVST_WRKNMR_NAT |
string(4) |
Employee Nationality |
|
|
INKVRHVST_WRKNMR_PERSNR |
string(35) |
Employee Employee Number |
|
|
INKVRHVST_WRKNMR_SIGNNM |
string(200) |
Employee Significant Part Last Name |
|
|
INKVRHVST_WRKNMR_SOFINR |
int64 |
Employee Social Security Number |
|
|
INKVRHVST_WRKNMR_VOORL |
string(6) |
Employee Initials |
|
|
INKVRHVST_WRKNMR_VOORV |
string(10) |
Employee Prefixes |
|
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
{res:itgen_interface_url_def} |
PRDNR |
int64 |
Period Number |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☑ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☑ |
|
Generated 11-01-2019 19:48 on version 17.30.0-PROD+1821.