J_1ICO_VENDDET - Columbia: Monthly data for freelancers/vendors

Columbia: Monthly data for freelancers/vendors information is stored in SAP table J_1ICO_VENDDET.
It is part of development package ID-FI-WT in software component FI-AP-AP-Q1. This development package consists of objects that can be grouped under "Withholding Tax reporting".

Fields for table J_1ICO_VENDDET

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
BUKRSCompany CodeXBUKRSCHAR8T001
LIFNRAccount Number of SupplierXLIFNRCHAR20LFA1
SMONTHMonthXSMONTHNUMC4
SYEARYEARXSYEARNUMC8
WITHTIndicator for Withholding Tax TypeWITHTCHAR4
WT_WITHCDWithholding Tax CodeWT_WITHCDCHAR4
TOT_AMTACRCMPTotal Amount Service for VendorTOT_AMTACRCMPCURR12
TOT_AMTAmount of service for the companyTOT_AMTCURR12
VOL_CONTRIBUTIONVolunteers' Pension ContributionVOL_CONTRIBUTIONCURR12
TOTAL_POST_AMNTTax base Amount posted till nowTOTAL_POST_AMNTCURR12
VOLN_CON_NXT_INVVolunteers' Pension ContributionVOL_CONTRIBUTIONCURR12
TOTAL_TAX_AMNTTotal Tax Amount posted till nowTOTAL_TAX_AMNTCURR12
TOTAL_VOL_CONTRITotal Volunteer ContributionTOTAL_VOL_CONTRICURR12
IDWTCO_ARPVALUEARP ContributionIDWTCO_ARPVALUECURR12
IDWTCO_ARPRATEARP Contribution rateIDWTCO_ARPRATEDEC4
FIWTCO_AMTSCIScientific/Technolgy ExemptionFIWTCO_AMTSCICURR12
FIWTCO_PENSIONPension rateFIWTCO_PENSIONDEC4
FIWTCO_PREVINTMonthly Interest Paid Last YearFIWTCO_PREVINTCURR12
FIWTCO_APREVINTMonthly Interest Paid Last YearFIWTCO_PREVINTCURR12
FIWTCO_PREVPAYMonthly Payments Last YearFIWTCO_PREVPAYCURR12
FIWTCO_APREVPAYMonthly Payments Last YearFIWTCO_PREVPAYCURR12
FIWTCO_DEDDEPENDDependent ContributionFIWTCO_DEDDEPENDCHAR2
REV_AMTSCIScientific/Technolgy ExemptionFIWTCO_AMTSCICURR12
REV_PENSIONRATEPension rateFIWTCO_PENSIONDEC4
REV_VOL_CONTRIVolunteers' Pension ContributionVOL_CONTRIBUTIONCURR12
REV_ARPVALUEARP ContributionIDWTCO_ARPVALUECURR12
MANDATORYMandatory ContributFIWTCO_MANDTCHAR2
MONTH_DATAFreelancer's Monthly DataFIWTCO_MTHDATACHAR2
MAND_PENSIONMandatory Pension ContributionFIWTCO_MANPENSIONCHAR2
MAND_SOLIDARITYMandatory Solidarity fundFIWTCO_MANSOLIDARITYCHAR2
MAND_HEALTHMandatory Health ContributionFIWTCO_MANHEALTHCHAR2
FIWTCO_YEARYearly Pension ContributionFIWTCO_YEARCHAR2
FIWTCO_VOL_BASEDetermine Volunteer ContributionFIWTCO_VOL_BASECHAR2
FIWTCO_PEN_VOL_DEDOVoluntary Pension ContributionFIWTCO_PEN_VOL_DEDOCURR12
FIWTCO_MAXDEDUC_MONTHMax Deduction MonthlyFIWTCO_MAXDEDUC_MONTHCHAR2
FIWTCO_PENSIONERPensioner VendorFIWTCO_PENSIONERCHAR2
FIWTCO_VOL_CONT_HOUSEVoluntary Contribution Towards HousingFIWTCO_VOL_CONT_HOUSECURR7
FIWTCO_VOL_CONT_MONTHConsider Monthly Voluntary Contribution LimitFIWTCO_VOL_CONT_MONTHCHAR2
FIWTCO_ARLVendor Location Risk Level (ARL)FIWTCO_ARLCHAR2
FIWTCO_FAMILY_FUNDFamily Compensation FundFIWTCO_FAMILY_FUNDCHAR2
FIWTCO_MAND_RATEMandatory Contribution RateFIWTCO_MAND_RATEDEC4
FIWTCO_MAX_YEARYearly Deduction LimitFIWTCO_MAX_YEARCHAR2
FIWTCO_HEALTH_ENTEntity for Health ContributionFIWTCO_HEALTH_ENTCHAR20LFA1
FIWTCO_MAND_PEN_ENTEntity for Mandatory Pension ContributionFIWTCO_MAND_PEN_ENTCHAR20LFA1
FIWTCO_ARL_ENTEntity for ARL ContributionFIWTCO_ARL_ENTCHAR20LFA1
FIWTCO_VOL_PEN_ENTEntity for Voluntary Pension ContributionFIWTCO_VOL_PEN_ENTCHAR20LFA1
FIWTCO_HOUSE_ENTEntity for Volunteers' Pension and Housing ContributionFIWTCO_HOUSE_ENTCHAR20LFA1
FIWTCO_FAMILY_ENTEntity for Family Compensation FundFIWTCO_FAMILY_ENTCHAR20LFA1
Privacy Policy