SAP table IDWTADD (Country speicific additional info for DME file)

Field Description Data Type Length Decimals Checktable Data Element
US_INFO_1042_00 Long Field Label CHAR 40 0 SCRTEXT_L
US_REPORT_YEAR Fiscal Year NUMC 4 0 GJAHR
US_DIRECT_SALES_INDICATOR Indicator for Direct Sales Reporting CHAR 10 0 FIWTUS_DIRECT_SALES_INDICATOR
MISC Direct Sales to be reported under 1099 MISC
NEC Direct Sales to be reported under 1099 NEC
US_INFO_1042_10 Long Field Label CHAR 40 0 SCRTEXT_L
US_CONT_NAME Name CHAR 30 0 NAME1
US_CONT_TELNO Phone Number of Employee Group Responsible for Company Area CHAR 12 0 TELE
US_INFO_1042_20 Long Field Label CHAR 40 0 SCRTEXT_L
US_PAYER_NAME Name CHAR 30 0 NAME1
US_PAYER_TAXNO Tax Number 1 CHAR 16 0 STCD1
US_INFO_1042_30 Long Field Label CHAR 40 0 SCRTEXT_L
US_TRANS_TEST File type indicator CHAR 4 0 WT_TEST_FILE
US_TRANS_AGENT Withholding Agent's EIN indicator NUMC 1 0 WT_EIN_IND
US_TRANS_NAME Name CHAR 30 0 NAME1
US_TRANS_STRAS Street and House Number CHAR 35 0 STRAS_GP
US_TRANS_CITY City CHAR 25 0 CITY
US_TRANS_REGIO Region (State, Province, County) CHAR 3 0 * REGIO
US_TRANS_PSTLZ Postal Code CHAR 10 0 PSTLZ
US_TRANS_TAXNO Tax Number 1 CHAR 16 0 STCD1
US_TCC Transmitter Control CHAR 5 0 WT_T_CTRL
US_INFO_1099_10 Long Field Label CHAR 40 0 SCRTEXT_L
US_VENDOR_STCD1 Tax Number 1 CHAR 16 0 STCD1
US_VENDOR_STCD2 Tax Number 2 CHAR 11 0 STCD2
US_VENDOR_REGIO Region (State, Province, County) CHAR 3 0 * REGIO
US_INFO_1099_20 Long Field Label CHAR 40 0 SCRTEXT_L
US_HWAER Reporting currency ( local or alternative ) CUKY 5 0 * WT_HWAER
US_MIN_FED Minimum Amount Federal Tax CURR 23 2 WT_MINTAX
US_MIN_ROYAL Minimum Base Amount - Royalties CURR 23 2 WT_MBASE2
US_MIN_DIVID Minimum Base Amount - Dividends CURR 23 2 WT_MBASE8
US_MIN_DIRECT Minimum Base Amount - Direct Sales CURR 23 2 WT_MBASE9
US_MIN_COMBINE Minimum Amount Validation CHAR 1 0 WT_COMB
US_MIN_INT_GEN Minimum Base Amount - Interest income CURR 23 2 WT_MBASE1J
US_MIN_INT_BUS Minimum Base Amount - Interest income for trade and business CURR 23 2 WT_MBASE1I
US_MIN_G_UNEMPLOY Minimum Base Amount - Unemployment CURR 23 2 WT_MBASE1G
US_MIN_G_TAX_REFUND Minimum Base Amount - State and Local Tax Refund CURR 23 2 WT_MBASE2G
US_MIN_G_OTH_GRANT Minimum Base Amount - Other Taxable Grant CURR 23 2 WT_MBASE5G
US_MIN_G_ATAA_PYMNT Minimum Base Amount - Other Taxable Grant CURR 23 2 WT_MBASE5G
US_INFO_1099_30 Long Field Label CHAR 40 0 SCRTEXT_L
US_TRANS_NAME1 Name 1 CHAR 40 0 WT_NAME1
US_TRANS_NAME2 Name 2 CHAR 40 0 WT_NAME2
US_TRANS_TCC Transmitter Control CHAR 5 0 WT_T_CTRL
US_TRANS_TIN US Transmitter TIN CHAR 11 0 WT_US_TRANS_TIN
US_CONTACT_PERS Name CHAR 30 0 NAME1
US_CONTACT_TELNO Phone Number of Employee Group Responsible for Company Area CHAR 12 0 TELE
US_CONTACT_EMAIL E-mail address CHAR 35 0 WT_EMAIL
US_COMP_NAME1 Name 1 CHAR 40 0 WT_NAME1
US_COMP_NAME2 Name 2 CHAR 40 0 WT_NAME2
US_COMP_STRAS Street and House Number CHAR 35 0 STRAS_GP
US_COMP_CITY City CHAR 25 0 ORT01
US_COMP_STATE Region (State, Province, County) CHAR 3 0 * REGIO
US_TRANS_POST Postal Code CHAR 10 0 PSTLZ
US_INFO_1099_40 Long Field Label CHAR 40 0 SCRTEXT_L
US_PAYER_AGENT Payer (P) / Transfer Agent (A) CHAR 1 0 WT_US_PAYER_AGENT
US_PAYER_NAME1 Name 1 CHAR 40 0 WT_NAME1
US_PAYER_NAME2 Name 2 CHAR 40 0 WT_NAME2
US_PAYER_CTRL Payer Name Control CHAR 4 0 WT_P_CTRL
US_PAYER_STRAS Street and House Number CHAR 35 0 STRAS_GP
US_PAYER_CITY City CHAR 25 0 ORT01
US_PAYER_REGIO Region (State, Province, County) CHAR 3 0 * REGIO
US_PAYER_CTRY Name of Country/Region (Short) CHAR 15 0 LANDX
US_PAYER_POST Postal Code CHAR 10 0 PSTLZ
US_PAYER_TELNO Phone Number of Employee Group Responsible for Company Area CHAR 12 0 TELE
US_PAYER_TIN US Payer TIN CHAR 11 0 WT_US_PAYER_TIN
US_INFO_1099_50 Long Field Label CHAR 40 0 SCRTEXT_L
US_FILE_COMBINE Checkbox CHAR 1 0 XFELD
No
X Yes
US_FILE_TEST Checkbox CHAR 1 0 XFELD
No
X Yes
US_FILE_TAPE Checkbox CHAR 1 0 XFELD
No
X Yes
US_FILE_CORR_IND Correction File Indicator CHAR 1 0 WT_CORR_IND
No Correction
C Second Correction
G First Correction
US_FILE_TM_NO Transmitter Media Number CHAR 6 0 WT_TM_NO
US_ALPHA_REPLACE Alpha Replacement Co CHAR 2 0 WT_F_ALPHA
US_IRS_FNAME IRS File Name CHAR 15 0 WT_F_EFILE
US_APPL_FILE Checkbox CHAR 1 0 XFELD
No
X Yes
US_APPL_FNAME Character field of length 40 CHAR 40 0 CHAR40
US_LOCAL_FILE Checkbox CHAR 1 0 XFELD
No
X Yes
US_LOCAL_FNAME Character field of length 40 CHAR 40 0 CHAR40
US_AGENT_NAME Withholding Tax Agent Contact Name CHAR 45 0 US_1042_AGENT_NAME
US_DEPT_TITLE Withholding Agent's Department Title CHAR 45 0 US_1042_DEPT_NAME
US_INFO_MULTI Long Field Label CHAR 40 0 SCRTEXT_L
US_CONT_MULTI Check Box CHAR 1 0 XFELD_US
US_CONT_COMPANY Company Code CHAR 4 0 * BUKRS_US
US_REC_TRUNC Checkbox CHAR 1 0 XFELD
No
X Yes
US_MIN_CHECK Checkbox CHAR 1 0 XFELD
No
X Yes
US_INFO_FILLER Long Field Label CHAR 40 0 SCRTEXT_L
US_FILLER_PSE Payment Settlement Entity CHAR 1 0 US_FILER_PSE
US_FILLER_EPF Electronic Payment Facilitator CHAR 1 0 US_FILER_EPF
US_FILLER_TPP Indicator to check if Filer is TPP CHAR 1 0 US_FILER_TPP
US_PSE_NAME Name of the PSE CHAR 30 0 US_PSE_NAME
US_PSE_PHONE Telephone Number of the PSE CHAR 12 0 US_PSE_PHONE
US_MIN_TRANS Minimum Number of Transactions NUMC 3 0 US_MIN_TRANS
US_MIN_AMT Minimum Amount CURR 23 2 US_MIN_AMT
US_POS_PERIOD Posting period NUMC 2 0 US_POS_PERIOD
US_TRANS_PAYMT Check whether transaction type is payment card CHAR 1 0 US_TRANS_PAYMT
US_TRANS_TPN Check whether transaction is third party network CHAR 1 0 US_TRANS_TPN
US_PAYER_GIIN Payer GIIN CHAR 15 0 FIWTUS_GIIN
US_INT_ID Intermediary ID CHAR 4 0 FIWTUS_INT_ID
US_CODEPAGE SAP Character Set ID NUMC 4 0 * CPCODEPAGE
US_AMEN_NO Amendment number NUMC 1 0 FIWTUS_AMEN_NO
US_AMEN_CHECK Boolean Variable (X = True, - = False, Space = Unknown) CHAR 1 0 BOOLEAN
unknown
- false
X true
IT_KANTIVA General Ledger Account CHAR 10 0 * HKONT
IT_ENASARCO General Ledger Account CHAR 10 0 * HKONT
IT_TAX_NO_SUBJ Tax on sales/purchases code CHAR 2 0 * MWSKZ
IT_RF07_BUKRS Company Code CHAR 4 0 BUKRS
IT_RF07_GJAHR Fiscal Year NUMC 4 0 GJAHR
IT_RF07_LIFNR Account Number of Supplier CHAR 10 0 LIFNR
IT_RF07_CAUS Modello 770 - Reason for payment of service CHAR 2 0 CAUS
IT_RF07_NASSC Annual amount not subject to WT on the basis of std. system CHAR 13 0 NASSC
IT_RF07_CDINAIL Withholding tax in Italy : Modello 770 - additional data CHAR 10 0 CDINAIL
IT_RF07_DTINIZ Starting date of INAIL insurance covering DATS 8 0 DTINIZ
IT_RF07_DTFINE Ending date of INAIL insurance covering DATS 8 0 DTFINE
IT_RF07_CDCOMU Municipal code CHAR 4 0 CDCOMU
IT_REP_LIFNR Account Number of Supplier CHAR 10 0 LIFNR
IT_REP_LAND1 Country/Region Key CHAR 3 0 * LAND1
IT_REP_SEXKZ Key for the Sex of the Person Subject to Withholding Tax CHAR 1 0 SEXKZ
Gender Not Known
1 Male
2 Female
IT_REP_NAME1 Name CHAR 30 0 NAME1
IT_REP_NAME2 Name CHAR 30 0 NAME1
IT_REP_GBDAT Date of Birth of the Person Subject to Withholding Tax DATS 8 0 GBDAT_Q
IT_REP_GBORT Place of birth of the person subject to withholding tax CHAR 25 0 GBORT_Q
IT_REP_CMDOM City CHAR 25 0 ORT01
IT_REP_PRDOM Region (State, Province, County) CHAR 3 0 * REGIO
IT_REP_INDOM Street and House Number CHAR 30 0 STRAS
ES_FILL_DME Checkbox CHAR 1 0 XFELD
No
X Yes
ES_INV_DATE Update date for table QSTRE from invoice document NUMC 1 0 WT_QSTRE_INV_DATE
1 Posting date
2 Document date
ES_PYMT_DATE Update date for table QSTRE from payment document NUMC 1 0 WT_QSTRE_PYMT_DATE
1 Clearing date
2 Posting date
3 Document date
ES_QSTRE_DATE Field of type DATS DATS 8 0 DATS
ES_OUTPUT Output option for ES/PT NUMC 1 0 WT_ES_OUTPUT
1 Diskette
2 Tape
3 Internet
ES_DECL Declaration for Spain NUMC 1 0 WT_ES_DECL
1 Ordinary declaration
2 Substitute declaration
3 Supplementary declaration
ES_ID_DECL ID of the declaration NUMC 13 0 WT_ES_ID_DECL
ES_ID_PRV_DEC ID of the previous declaration NUMC 13 0 WT_ES_ID_PRV_DEC
ES_NIF_WH_AG NIF of withholding agent CHAR 16 0 WT_ES_NIF_WH_AG
ES_NAME_WH_AG Name of withholding agent CHAR 40 0 WT_ES_NAME_AG
ES_TEL Telephone number NUMC 9 0 WT_ES_TEL
ES_CONTACT_PERS Contact person CHAR 40 0 WT_ES_PERS
ES_TAX_DEPT Provincial Tax Code CHAR 3 0 FPRCD
KR_WT_TYPE1 Indicator for Withholding Tax Type CHAR 2 0 * WITHT
KR_WT_TYPE2 Indicator for Withholding Tax Type CHAR 2 0 * WITHT
KR_WT_CODE1 Withholding Tax Code CHAR 2 0 * WT_WITHCD
KR_WT_CODE2 Withholding Tax Code CHAR 2 0 * WT_WITHCD
KR_WT_DATE Reporting Date for Tax Report DATS 8 0 MLDDT_BSET
KR_WT_PYDT1 Clearing Date DATS 8 0 AUGDT
KR_WT_PYDT2 Clearing Date DATS 8 0 AUGDT
KR_WT_SECCO1 Section Code CHAR 4 0 SECCO
KR_WT_SECCO2 Section Code CHAR 4 0 SECCO
KR_WT_QBSHH Withholding Tax Amount in Reporting Currency CURR 23 2 WT_TAX_AMT
VE_L_BLART Document Type CHAR 2 0 * BLART
VE_U_BLART Document Type CHAR 2 0 * BLART
VE_CERTNUMBER Text field length 14 CHAR 14 0 CHAR14
VE_CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
VE_CPUTM Time of Entry TIMS 6 0 CPUTM
VE_TAXHB Tax Amount in Document Currency CURR 23 2 FWSTE
VE_TAXHH Tax Amount in Local Currency CURR 23 2 HWSTE
VE_CERT_RGN_FLG Reprint the Certificate? CHAR 1 0 CERT_RGN_FLG
VE_DM_HDR Text field, length 35 CHAR 35 0 CHAR_35
VE_CERT_HDR Text field, length 35 CHAR 35 0 CHAR_35
VE_STCD1 Tax Number 1 CHAR 16 0 STCD1
VE_CNUM Document Header Text CHAR 25 0 BKTXT
VE_WT_RATE Withholding Tax Rate DEC 7 4 WT_QSATZ
GB_PERIOD_END_DATE New CIS Return - End date for a return Period DATS 8 0 GB_PERIOD_END_DATE
GB_NIL_RETURN_INDICATOR Specifies if the current return is a Nil Return or n CHAR 1 0 GB_NIL_RETURN_INDICATOR
GB_EMPSTAT_VFD_DCLRTN Employment Status Declaration CHAR 1 0 GB_EMPSTAT_VFD_DCLRTN
GB_SC_VFD_DCLRTN Subcontractor Verification Declaration CHAR 1 0 GB_SC_VFD_DCLRTN
GB_INFO_CRCT_DCLRTN Information Correct Declaration CHAR 1 0 GB_INFO_CRCT_DCLRTN
GB_INACTIVITY_INDICATOR GB_INACTIVITY_INDICATOR CHAR 1 0 GB_INACTIVITY_INDICATOR
GB_RETURN_HDR Text field, length 35 CHAR 35 0 CHAR_35
GB_DCLRTN_HDR Text field, length 35 CHAR 35 0 CHAR_35
GB_CIS_RTN_PSWRD Password for the Return filing CHAR 25 0 GB_CIS_RTN_PSWRD
GB_CIS_GFF_SNDRID Sender Id for GFF EDI Transmission CHAR 35 0 GB_GFF_SNDR_ID
GB_CIS_GFF_RCVRID GB CIS GFF Transmission Receiver Id CHAR 35 0 GB_GFF_RCVR_ID
GB_FILE_HDR Data Element Type CHAR Length 35 CHAR 35 0 CHAR35
GB_CIS_ICR Text field length 14 CHAR 14 0 CHAR14
GB_CIS_TEST_TRNS TEST TRANSMISSION FLAG CHAR 1 0 CIS_TEST_TRANS
ID_WT_PERIOD Reporting Period of Electronic Tax Return NUMC 2 0 UMSVDPER
ID_WT_YEAR Reporting Year of Electronic Tax Return NUMC 4 0 UMSVDYEA
ID_WT_CORRECTION Number of correction NUMC 1 0 CORR_NUMBER
ID_WT_FORMCODE 30 Characters CHAR 30 0 CHAR30
ID_WT_RATE Withholding Tax Rate DEC 7 4 WT_QSATZ
ID_WT_ADDRESS Char255 CHAR 255 0 CHAR255
ID_WT_SERVICE1 Component of the Version Number CHAR 2 0 CHAR2
ID_WT_SERVICE2 Component of the Version Number CHAR 2 0 CHAR2
ID_WT_SERVICE3 Component of the Version Number CHAR 2 0 CHAR2
ID_WT_SERVICE4 Component of the Version Number CHAR 2 0 CHAR2
ID_WT_SERVICE5 Component of the Version Number CHAR 2 0 CHAR2
ID_WT_SERVICE6 Component of the Version Number CHAR 2 0 CHAR2
ID_WT_ESTPERC Percentage Subject to Withholding Tax DEC 5 2 QPROZ
ID_WT_GROSSAMT Net amount 2 = Invoice amount - VAT ( in Reporting currency) CURR 23 2 WT_EXCLVAT
BE_CONTACT_ID Contact Person Name CHAR 34 0 BE_CONTACT_ID
BE_CONTACT_EM Email Address of the Contact Person CHAR 44 0 BE_CONTACT_EM
BE_MINBASE Minimum Base Amount CURR 23 2 BE_MINBASE
BE_REPORTYEAR Reporting Year in the Withholding Tax Return NUMC 4 0 BE_REPORTYEAR
BE_REPORTDATE Date of Report - Fiche (Belgium) DATS 8 0 BE_REPORTDATE
BE_SEQ_NUM Sequential Number for Fiche - Belgium CHAR 4 0 BE_SEQ_NUM
BE_CORR_INDICATOR Correction Indicator for Withholding Tax Return CHAR 1 0 BE_CORR_INDICATOR
0 Ordinary
1 Grouped Correction - Correction
2 Grouped Correction - Addition
3 Grouped Correction - Deletion
4 Complete Replacement
BE_TEST_RUN Test Run Indicator - Belgium CHAR 1 0 BE_TEST_RUN
BE_CORR_REFERENCE Reference Number for the Correction CHAR 6 0 BE_CORR_REFERENCE
BE_NIHIL Payment Indicator - Fiche- Belgium CHAR 1 0 BE_NIHIL
BE_HWAER Reporting currency ( local or alternative ) CUKY 5 0 * WT_HWAER
BE_INFO_MULTI Long Field Label CHAR 40 0 SCRTEXT_L
BE_CONT_MULTI Multiple Company Codes CHAR 1 0 XFELD_BE
BE_CONT_COMPANY Leading Company Code CHAR 4 0 * BUKRS_BE
TH_PAYER Tax Payer type NUMC 1 0 TH_PAYER
1 Withhold at Source
2 Pay every time
3 Pay one time
4 Others
J_1TPBUPL Branch Code CHAR 5 0 BCODE
QEKAR Income Type CHAR 4 0 * QEKAR
CLASSIF1 Description of Wth/Tax Type + code for Ext. WT CHAR 40 0 WT_TYPE_CODE_DESC
TIMEE1 Reference to WT item CHAR 24 0 WT_ITEM_REF
DESCRIPTION1 Withholding Tax Certificate Number CHAR 10 0 CTNUMBER
DEATISL1 Item Text CHAR 50 0 SGTXT
BASAMT1 Withholding Tax Base Amount in Reporting Currency CURR 23 2 WT_BASE_AMT
BSAMTN_C1 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
WHT_TAMT1 Withholding Tax Amount in Reporting Currency CURR 23 2 WT_TAX_AMT
WHTN_C1 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
CLASSIF2 Description of Wth/Tax Type + code for Ext. WT CHAR 40 0 WT_TYPE_CODE_DESC
TIMEE2 Reference to WT item CHAR 24 0 WT_ITEM_REF
DESCRIPTION2 Withholding Tax Certificate Number CHAR 10 0 CTNUMBER
DEATISL2 Item Text CHAR 50 0 SGTXT
BASAMT2 Withholding Tax Base Amount in Reporting Currency CURR 23 2 WT_BASE_AMT
BSAMTN_C2 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
WHT_TAMT2 Withholding Tax Amount in Reporting Currency CURR 23 2 WT_TAX_AMT
WHTN_C2 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
CLASSIF3 Description of Wth/Tax Type + code for Ext. WT CHAR 40 0 WT_TYPE_CODE_DESC
TIMEE3 Reference to WT item CHAR 24 0 WT_ITEM_REF
DESCRIPTION3 Withholding Tax Certificate Number CHAR 10 0 CTNUMBER
DEATISL3 Item Text CHAR 50 0 SGTXT
BASAMT3 Withholding Tax Base Amount in Reporting Currency CURR 23 2 WT_BASE_AMT
BSAMTN_C3 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
WHT_TAMT3 Withholding Tax Amount in Reporting Currency CURR 23 2 WT_TAX_AMT
WHTN_C3 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
CLASSIF4 Description of Wth/Tax Type + code for Ext. WT CHAR 40 0 WT_TYPE_CODE_DESC
TIMEE4 Reference to WT item CHAR 24 0 WT_ITEM_REF
DESCRIPTION4 Withholding Tax Certificate Number CHAR 10 0 CTNUMBER
DEATISL4 Item Text CHAR 50 0 SGTXT
BASAMT4 Withholding Tax Base Amount in Reporting Currency CURR 23 2 WT_BASE_AMT
BSAMTN_C4 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
WHT_TAMT4 Withholding Tax Amount in Reporting Currency CURR 23 2 WT_TAX_AMT
WHTN_C4 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
CLASSIF5 Description of Wth/Tax Type + code for Ext. WT CHAR 40 0 WT_TYPE_CODE_DESC
TIMEE5 Reference to WT item CHAR 24 0 WT_ITEM_REF
DESCRIPTION5 Withholding Tax Certificate Number CHAR 10 0 CTNUMBER
DEATISL5 Item Text CHAR 50 0 SGTXT
BASAMT5 Withholding Tax Base Amount in Reporting Currency CURR 23 2 WT_BASE_AMT
BSAMTN_C5 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR
WHT_TAMT5 Withholding Tax Amount in Reporting Currency CURR 23 2 WT_TAX_AMT
WHTN_C5 Free amount field for country specific CURR 23 2 WT_FREE_DMBTR