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".
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 |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
LIFNR | Account Number of Supplier | X | LIFNR | CHAR | 20 | LFA1 |
SMONTH | Month | X | SMONTH | NUMC | 4 | |
SYEAR | YEAR | X | SYEAR | NUMC | 8 | |
WITHT | Indicator for Withholding Tax Type | WITHT | CHAR | 4 | ||
WT_WITHCD | Withholding Tax Code | WT_WITHCD | CHAR | 4 | ||
TOT_AMTACRCMP | Total Amount Service for Vendor | TOT_AMTACRCMP | CURR | 12 | ||
TOT_AMT | Amount of service for the company | TOT_AMT | CURR | 12 | ||
VOL_CONTRIBUTION | Volunteers' Pension Contribution | VOL_CONTRIBUTION | CURR | 12 | ||
TOTAL_POST_AMNT | Tax base Amount posted till now | TOTAL_POST_AMNT | CURR | 12 | ||
VOLN_CON_NXT_INV | Volunteers' Pension Contribution | VOL_CONTRIBUTION | CURR | 12 | ||
TOTAL_TAX_AMNT | Total Tax Amount posted till now | TOTAL_TAX_AMNT | CURR | 12 | ||
TOTAL_VOL_CONTRI | Total Volunteer Contribution | TOTAL_VOL_CONTRI | CURR | 12 | ||
IDWTCO_ARPVALUE | ARP Contribution | IDWTCO_ARPVALUE | CURR | 12 | ||
IDWTCO_ARPRATE | ARP Contribution rate | IDWTCO_ARPRATE | DEC | 4 | ||
FIWTCO_AMTSCI | Scientific/Technolgy Exemption | FIWTCO_AMTSCI | CURR | 12 | ||
FIWTCO_PENSION | Pension rate | FIWTCO_PENSION | DEC | 4 | ||
FIWTCO_PREVINT | Monthly Interest Paid Last Year | FIWTCO_PREVINT | CURR | 12 | ||
FIWTCO_APREVINT | Monthly Interest Paid Last Year | FIWTCO_PREVINT | CURR | 12 | ||
FIWTCO_PREVPAY | Monthly Payments Last Year | FIWTCO_PREVPAY | CURR | 12 | ||
FIWTCO_APREVPAY | Monthly Payments Last Year | FIWTCO_PREVPAY | CURR | 12 | ||
FIWTCO_DEDDEPEND | Dependent Contribution | FIWTCO_DEDDEPEND | CHAR | 2 | ||
REV_AMTSCI | Scientific/Technolgy Exemption | FIWTCO_AMTSCI | CURR | 12 | ||
REV_PENSIONRATE | Pension rate | FIWTCO_PENSION | DEC | 4 | ||
REV_VOL_CONTRI | Volunteers' Pension Contribution | VOL_CONTRIBUTION | CURR | 12 | ||
REV_ARPVALUE | ARP Contribution | IDWTCO_ARPVALUE | CURR | 12 | ||
MANDATORY | Mandatory Contribut | FIWTCO_MANDT | CHAR | 2 | ||
MONTH_DATA | Freelancer's Monthly Data | FIWTCO_MTHDATA | CHAR | 2 | ||
MAND_PENSION | Mandatory Pension Contribution | FIWTCO_MANPENSION | CHAR | 2 | ||
MAND_SOLIDARITY | Mandatory Solidarity fund | FIWTCO_MANSOLIDARITY | CHAR | 2 | ||
MAND_HEALTH | Mandatory Health Contribution | FIWTCO_MANHEALTH | CHAR | 2 | ||
FIWTCO_YEAR | Yearly Pension Contribution | FIWTCO_YEAR | CHAR | 2 | ||
FIWTCO_VOL_BASE | Determine Volunteer Contribution | FIWTCO_VOL_BASE | CHAR | 2 | ||
FIWTCO_PEN_VOL_DEDO | Voluntary Pension Contribution | FIWTCO_PEN_VOL_DEDO | CURR | 12 | ||
FIWTCO_MAXDEDUC_MONTH | Max Deduction Monthly | FIWTCO_MAXDEDUC_MONTH | CHAR | 2 | ||
FIWTCO_PENSIONER | Pensioner Vendor | FIWTCO_PENSIONER | CHAR | 2 | ||
FIWTCO_VOL_CONT_HOUSE | Voluntary Contribution Towards Housing | FIWTCO_VOL_CONT_HOUSE | CURR | 7 | ||
FIWTCO_VOL_CONT_MONTH | Consider Monthly Voluntary Contribution Limit | FIWTCO_VOL_CONT_MONTH | CHAR | 2 | ||
FIWTCO_ARL | Vendor Location Risk Level (ARL) | FIWTCO_ARL | CHAR | 2 | ||
FIWTCO_FAMILY_FUND | Family Compensation Fund | FIWTCO_FAMILY_FUND | CHAR | 2 | ||
FIWTCO_MAND_RATE | Mandatory Contribution Rate | FIWTCO_MAND_RATE | DEC | 4 | ||
FIWTCO_MAX_YEAR | Yearly Deduction Limit | FIWTCO_MAX_YEAR | CHAR | 2 | ||
FIWTCO_HEALTH_ENT | Entity for Health Contribution | FIWTCO_HEALTH_ENT | CHAR | 20 | LFA1 | |
FIWTCO_MAND_PEN_ENT | Entity for Mandatory Pension Contribution | FIWTCO_MAND_PEN_ENT | CHAR | 20 | LFA1 | |
FIWTCO_ARL_ENT | Entity for ARL Contribution | FIWTCO_ARL_ENT | CHAR | 20 | LFA1 | |
FIWTCO_VOL_PEN_ENT | Entity for Voluntary Pension Contribution | FIWTCO_VOL_PEN_ENT | CHAR | 20 | LFA1 | |
FIWTCO_HOUSE_ENT | Entity for Volunteers' Pension and Housing Contribution | FIWTCO_HOUSE_ENT | CHAR | 20 | LFA1 | |
FIWTCO_FAMILY_ENT | Entity for Family Compensation Fund | FIWTCO_FAMILY_ENT | CHAR | 20 | LFA1 |