| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | LIFNR | Allow NULL? |
| 4 | SMONTH | Month | nvarchar | 2 | 0 | NUMC | (N'00') | No | | SMONTH | Allow NULL? |
| 5 | SYEAR | YEAR | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | SYEAR | Allow NULL? |
| 6 | WITHT | Indicator for withholding tax type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WITHT | Allow NULL? |
| 7 | WT_WITHCD | Withholding tax code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WT_WITHCD | Allow NULL? |
| 8 | TOT_AMTACRCMP | Total Amount Service for Vendor | decimal | 13 | 2 | CURR | ((0)) | Yes | | TOT_AMTACRCMP | |
| 9 | TOT_AMT | Amount of service for the company | decimal | 13 | 2 | CURR | ((0)) | Yes | | TOT_AMT | |
| 10 | VOL_CONTRIBUTION | Volunteer Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | VOL_CONTRIBUTION | |
| 11 | TOTAL_POST_AMNT | Tax base Amount posted till now | decimal | 13 | 2 | CURR | ((0)) | Yes | | TOTAL_POST_AMNT | |
| 12 | VOLN_CON_NXT_INV | Volunteer Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | VOL_CONTRIBUTION | |
| 13 | TOTAL_TAX_AMNT | Total Tax Amount posted till now | decimal | 13 | 2 | CURR | ((0)) | Yes | | TOTAL_TAX_AMNT | |
| 14 | TOTAL_VOL_CONTRI | Total Volunteer Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | TOTAL_VOL_CONTRI | |
| 15 | IDWTCO_ARPVALUE | ARP Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | IDWTCO_ARPVALUE | |
| 16 | IDWTCO_ARPRATE | ARP Contribution rate | decimal | 7 | 4 | DEC | ((0)) | Yes | | IDWTCO_ARPRATE | |
| 17 | FIWTCO_AMTSCI | Scientific/Technological paid amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIWTCO_AMTSCI | |
| 18 | FIWTCO_PENSION | Pension rate | decimal | 7 | 4 | DEC | ((0)) | Yes | | FIWTCO_PENSION | |
| 19 | FIWTCO_PREVINT | Previous year interest | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIWTCO_PREVINT | |
| 20 | FIWTCO_APREVINT | Previous year interest | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIWTCO_PREVINT | |
| 21 | FIWTCO_PREVPAY | Previous year payment | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIWTCO_PREVPAY | |
| 22 | FIWTCO_APREVPAY | Previous year payment | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIWTCO_PREVPAY | |
| 23 | FIWTCO_DEDDEPEND | Dependent deduction | char | 1 | 0 | CHAR | (N' ') | Yes | | FIWTCO_DEDDEPEND | Allow NULL? |
| 24 | REV_AMTSCI | Scientific/Technological paid amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | FIWTCO_AMTSCI | |
| 25 | REV_PENSIONRATE | Pension rate | decimal | 7 | 4 | DEC | ((0)) | Yes | | FIWTCO_PENSION | |
| 26 | REV_VOL_CONTRI | Volunteer Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | VOL_CONTRIBUTION | |
| 27 | REV_ARPVALUE | ARP Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | IDWTCO_ARPVALUE | |
| 28 | MANDATORY | Mandatory Contribution | char | 1 | 0 | CHAR | (N' ') | Yes | | FIWTCO_MANDT | Allow NULL? |
| 29 | MONTH_DATA | Freelancer's Monthly Data | char | 1 | 0 | CHAR | (N' ') | Yes | | FIWTCO_MTHDATA | Allow NULL? |
| 30 | MAND_PENSION | Mandatory Pension Contribution | char | 1 | 0 | CHAR | (N' ') | Yes | | FIWTCO_MANPENSION | Allow NULL? |
| 31 | MAND_SOLIDARITY | Mandatory Solidarity fund | char | 1 | 0 | CHAR | (N' ') | Yes | | FIWTCO_MANSOLIDARITY | Allow NULL? |
| 32 | MAND_HEALTH | Mandatory Health Contribution | char | 1 | 0 | CHAR | (N' ') | Yes | | FIWTCO_MANHEALTH | Allow NULL? |
