J_1ICO_VENDDET

Columbia: Monthly data for freelancers/vendors | #masterdata | Component: Withholding Tax Reporting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
LIFNR FK Account Number of Supplier
SMONTH Month
SYEAR YEAR
Column Name Description
💲 Currency Key (T001.WAERS):
TOT_AMTACRCMP Total Amount Service for Vendor
TOT_AMT Amount of service for the company
VOL_CONTRIBUTION Volunteers' Pension Contribution
TOTAL_POST_AMNT Tax base Amount posted till now
VOLN_CON_NXT_INV Volunteers' Pension Contribution
TOTAL_TAX_AMNT Total Tax Amount posted till now
TOTAL_VOL_CONTRI Total Volunteer Contribution
IDWTCO_ARPVALUE ARP Contribution
FIWTCO_AMTSCI Scientific/Technolgy Exemption
FIWTCO_PREVINT Monthly Interest Paid Last Year
FIWTCO_APREVINT Monthly Interest Paid Last Year
FIWTCO_PREVPAY Monthly Payments Last Year
FIWTCO_APREVPAY Monthly Payments Last Year
REV_AMTSCI Scientific/Technolgy Exemption
REV_VOL_CONTRI Volunteers' Pension Contribution
REV_ARPVALUE ARP Contribution
FIWTCO_PEN_VOL_DEDO Voluntary Pension Contribution
FIWTCO_VOL_CONT_HOUSE Voluntary Contribution Towards Housing
Column Name Description
Column Name Description
Column Name Description
FIWTCO_DEDDEPEND Dependent Contribution Show values
MANDATORY Mandatory Contribut Show values
MONTH_DATA Freelancer's Monthly Data Show values
MAND_PENSION Mandatory Pension Contribution Show values
MAND_SOLIDARITY Mandatory Solidarity fund Show values
MAND_HEALTH Mandatory Health Contribution Show values
FIWTCO_YEAR Yearly Pension Contribution Show values
FIWTCO_VOL_BASE Determine Volunteer Contribution Show values
FIWTCO_MAXDEDUC_MONTH Max Deduction Monthly Show values
FIWTCO_PENSIONER Pensioner Vendor Show values
FIWTCO_VOL_CONT_MONTH Consider Monthly Voluntary Contribution Limit Show values
FIWTCO_ARL Vendor Location Risk Level (ARL) Show values
FIWTCO_FAMILY_FUND Family Compensation Fund Show values
FIWTCO_MAX_YEAR Yearly Deduction Limit Show values
Column Name Description Domain name
WITHT Indicator for Withholding Tax Type WITHT
WT_WITHCD Withholding Tax Code WT_WITHCD
IDWTCO_ARPRATE ARP Contribution rate PRZ34
FIWTCO_PENSION Pension rate PRZ34
REV_PENSIONRATE Pension rate PRZ34
FIWTCO_MAND_RATE Mandatory Contribution Rate PRZ34
Master Data Relations Join Conditions
Company Code
  • J_1ICO_VENDDET.MANDT == T001.MANDT
  • J_1ICO_VENDDET.BUKRS == T001.BUKRS
Entity for ARL Contribution
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.FIWTCO_ARL_ENT == LFA1.LIFNR
Entity for Family Compensation Fund
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.FIWTCO_FAMILY_ENT == LFA1.LIFNR
Entity for Health Contribution
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.FIWTCO_HEALTH_ENT == LFA1.LIFNR
Entity for Volunteers' Pension and Housing Contribution
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.FIWTCO_HOUSE_ENT == LFA1.LIFNR
Entity for Mandatory Pension Contribution
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.FIWTCO_MAND_PEN_ENT == LFA1.LIFNR
Entity for Voluntary Pension Contribution
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.FIWTCO_VOL_PEN_ENT == LFA1.LIFNR
Account Number of Supplier
  • J_1ICO_VENDDET.MANDT == LFA1.MANDT
  • J_1ICO_VENDDET.LIFNR == LFA1.LIFNR
Client J_1ICO_VENDDET.MANDT == T000.MANDT