1. Home
  2. Resources
  3. SAP Tables
  4. IDWTINTDME - Interface to DME Engine

SAP Table IDWTINTDME

Interface to DME Engine

IDWTINTDME (Interface to DME Engine) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link IDWTINTDME to other SAP tables.

IDWTINTDME table fields

Field Data element Checktable Datatype Length Decimals
IDWTCOMPCD IDWTCOMPCD STRU 0 0
BUKRS Company Code BUKRS CHAR 4 0
BUPLA Business Place BUPLA CHAR 4 0
BUTXT Name of Company Code or Company BUTXT CHAR 25 0
WT_NEWWT Indicator: Extended withholding tax active WT_NEWWT CHAR 1 0
X Yes
NULL No
STCEG VAT Registration Number STCEG CHAR 20 0
WT_TAXREF1_VAL Company ( or Business place ) Tax reference 1 WT_REFV1 CHAR 48 0
WT_TAXREF2_VAL Company ( or business place ) Tax reference 2 WT_REFV2 CHAR 48 0
WT_EDIREF_VAL EDI reference of the company for Withholding tax reporting WT_EDIREF CHAR 48 0
KTOPL Chart of Accounts KTOPL CHAR 4 0
KR_REPRES Name of Representative REPRES CHAR 10 0
KR_TAXOFF District Tax Office TAXOFF CHAR 3 0
KR_TAXOFF_NAME Name of Tax Office OFFICENAME CHAR 40 0
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
NAME_TXT Converted name field (with form of address) AD_NAMETXT CHAR 50 0
NAME_CO c/o name AD_NAME_CO CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
CITY_CODE City code for city/street file AD_CITYNUM CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM CHAR 12 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP CHAR 4 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
CITY_CODE2 City PO box code (City file) AD_CIT2NUM CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY CHAR 3 0
POSTALAREA (Not Supported) Post Delivery District AD_PSTLAR CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES CHAR 4 0
STREETCODE Street Number for City/Street File AD_STRNUM CHAR 12 0
STREETABBR (Not Supported) Abbreviation of Street Name AD_STRABBR CHAR 2 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
LANGU Language Key SPRAS LANG 1 0
REGION Region (State, Province, County) REGIO CHAR 3 0
SORT1 Search Term 1 AD_SORT1UL CHAR 20 0
SORT2 Search Term 2 AD_SORT2UL CHAR 20 0
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGINA CHAR 4 0
EXTENSION1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENSION2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID CHAR 10 0
REMARK Address notes AD_REMARK1 CHAR 50 0
LANGU_CREA Address record creation original language AD_LANGUCR LANG 1 0
PO_BOX_LOBBY PO Box Lobby AD_PO_BOX_LBY CHAR 40 0
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
COUNTY_CODE County code for county AD_CNTYNUM CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM CHAR 3 0
LANDX Country Name LANDX CHAR 15 0
NATIO Nationality NATIO CHAR 15 0
BEZEI Region AD_REGION CHAR 20 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
TXTID Sender Variant TXTID_001G CHAR 2 0
TXTKO Header Text Name in Word Processing TXTKO_001G CHAR 16 0
TXTFU Footer Text Name in Word Processing TXTFU_001G CHAR 16 0
TXTUN Text Name for the Signature TXTUN_001G CHAR 16 0
TXTAB Text Name for the Sender Details in the Letter Window TXTAB_001G CHAR 16 0
WT_GROUP1 Grouping criterion WT_GROUP CHAR 10 0
WAERS Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
DMBTR Gross amount in Reporting Currency WT_DMBTR CURR 15 2
WT_QSSHH Withholding Tax Base Amount in Reporting Currency WT_BASE_AMT CURR 15 2
WT_QBSHH Withholding Tax Amount in Reporting Currency WT_TAX_AMT CURR 15 2
WT_QSFHH Amount exempt from withholding tax (in reporting currency) WT_EXMP_AMT CURR 15 2
WT_TAXHH Tax Amount in Reporting Currency WT_HWSTE CURR 15 2
WT_AMEXCLVAT Net amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVAT CURR 15 2
WT_AMRBASE WT base amount excluding taxes ( in reporting currency) WT_RBASE CURR 15 2
WT_AMREXMP Amount Exempt from WH Tax - VAT (in Reporting Currency) WT_REXMP CURR 15 2
SKNTO Cash discount amount in local currency WT_SKNTO CURR 15 2
GB_CIS_WTAOR Account Office Reference for CIS Reporting Comp Code WT_WTAOR CHAR 50 0
GB_CIS_WTTOR Tax office Reference Number for Contractor (PAYE Reference) WT_WTTOR CHAR 25 0
GB_CIS_WTTON Tax Office Number for contractor (reporting company code) WT_WTTON CHAR 10 0
GB_CIS_WTCER Contractor's Employer Reference WT_WTCER CHAR 50 0
GB_CIS_WTUTR Universal Tax Referen WT_WTUTR CHAR 50 0
GB_CIS_SNDRID Sender Id WT_SENDRID CHAR 30 0
GB_CIS_AUTHVAL password WT_AUTHVAL CHAR 30 0
GB_CIS_SNDRENUM SENDER ENUMERATION WT_SNDRENUM CHAR 30 0
BE_TAXID1 Tax Identification Number for Belgium BE_TAX_ID CHAR 2 0
BE_TAXID2 Tax Identification Number for Belgium BE_TAX_ID CHAR 2 0
BE_CONTACT_ID Contact Person Name BE_CONTACT_ID CHAR 34 0
BE_CONTACT_EM Email Address of the Contact Person BE_CONTACT_EM CHAR 44 0
BE_MINBASE Minimum Base Amount BE_MINBASE CURR 13 2
BE_REPORTYEAR Reporting Year in the Withholding Tax Return BE_REPORTYEAR NUMC 4 0
BE_SEQ_NUM Sequential Number for Fiche - Belgium BE_SEQ_NUM CHAR 4 0
BE_CORR_INDICATOR Correction Indicator for Withholding Tax Return BE_CORR_INDICATOR CHAR 1 0
0 Ordinary
1 Grouped Correction - Correction
2 Grouped Correction - Addition
3 Grouped Correction - Deletion
4 Complete Replacement
BE_TEST_RUN Test Run Indicator - Belgium BE_TEST_RUN CHAR 1 0
BE_CORR_REFERENCE Reference Number for the Correction BE_CORR_REFERENCE CHAR 6 0
BE_NIHIL Payment Indicator - Fiche- Belgium BE_NIHIL CHAR 1 0
BE_HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
BE_REPORTDATE Date DATUM DATS 8 0
BE_R8010_REC Number of Records BE_REC_LEN NUMC 8 0
BE_R9010_REC Number of Records BE_REC_LEN NUMC 8 0
BE_R9011_TOTREC Number of Records BE_REC_LEN NUMC 8 0
BE_SEND_STREET Street AD_STREET CHAR 60 0
BE_SEND_STR_NO Street Number for City/Street File AD_STRNUM CHAR 12 0
BE_SEND_POCODE Sender Postal Code BE_SEND_POCODE CHAR 4 0
BE_SEND_CITY City AD_CITY1 CHAR 40 0
BE_SEND_NAME Sender's Name BE_SEND_NAME CHAR 40 0
BE_SEND_ENT_NO Sender Enterprise Number BE_SEND_ENTNO CHAR 10 0
BE_GEN_INFO_HDR BE General Information Header BE_GEN_INFO_HDR CHAR 35 0
BE_SEND_INFO_HDR BE Sender Information Header BE_SEND_INFO_HDR CHAR 35 0
BE_DIVISION Division Code BE_DIVISION CHAR 35 0
BE_DIVISION_HDR BE Division Header Information BE_DIVISION_HDR CHAR 35 0
BE_SEND_TEL_NO First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
BE_NR_INTERVAL Sender Number Range Interval BE_NR_INTERVAL CHAR 2 0
BE_SPRAS Language of Sender Company BE_SPRAS CHAR 1 0
BE_QLAND Belgium Sender Country Key BE_QLAND CHAR 5 0
BE_MIN_9314 Minimum Base Amount BE_MINBASE CURR 13 2
FR_MIN_AMT Minimum Amount for Partner (FR) FR_MIN_AMT CURR 13 2
FR_GEN_INFO_HDR FR General Information Header FR_GEN_INFO_HDR CHAR 35 0
FR_HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
FR_CONTACT_NAME Name of Contact Person (FR) FR_CONTACT_NAME CHAR 50 0
FR_CONTACT_EM Email Address of Contact Person (FR) FR_CONTACT_EM CHAR 60 0
VE_COMPCD_RIF Parameter value PAVAL CHAR 48 0
VE_PERIOD Character field of length 6 CHAR6 CHAR 6 0
VE_HR_INDICATOR Checkbox XFELD CHAR 1 0
X Yes
NULL No
TH_SUB_NATURE Submit Nature for withholding tax TH_SUB_NATURE CHAR 1 0
1 Ordinary Submit
2 Additional Submit
TH_SUB_NO Submit Number TH_SUB_NO NUMC 3 0
TH_ADD_SUB Additional Submission Indicator TH_ADD_SUB CHAR 1 0
X Yes
NULL No
TH_PAYT_DATE Overwrite Payment Date TH_PAYT_DATE DATS 8 0
TH_BRANCH Official branch code Thailand TH_BRANCH CHAR 5 0
TH_PAYER Tax Payer type TH_PAYER NUMC 1 0
1 Withhold at Source
2 Pay every time
3 Pay one time
4 Others
IE_GEN_INFO_HDR BE General Information Header IE_GEN_INFO_HDR CHAR 35 0
IE_DUEDATE Due Date IE_DUEDATE DATS 8 0
IE_RTYPE Return Type IE_RTYPE CHAR 6 0
NEW New Return
CANCEL Cancel
IE_AMNT_DECL Withholding Tax Base Amount in Reporting Currency WT_BASE_AMT CURR 15 2
IE_AMNT_UNDECL Amount Undeclared IE_AMNT_UNDECL CURR 13 2
IE_FILED_STATUS Filed Status IE_FILED_STATUS CHAR 17 0
IE_BUKRS_TITLE Title text AD_TITLETX CHAR 30 0
IE_BUKRS_SUFFIX Company Code suffix IE_BUKRS_SUFFIX CHAR 30 0
IE_BUKRS_ADDRESS One-line short form of formatted address AD_LINE_S CHAR 80 0
IE_TAX_RATE Contract Deduction Rate IE_CONTRACT_RATE DEC 5 2
IDWTPARTNER IDWTPARTNER STRU 0 0
BUKRS Company Code BUKRS CHAR 4 0
PARTNO_TYPE Type of partner number WT_PARTNO_TYPE CHAR 1 0
NULL Vendor/Customer (FI-AP/AR)
1 Business Partner (FI-CA)
PARTNERNO Partner ID PARTNERNO CHAR 35 0
WT_PERIOD Reporting Period WT_REPPERIOD NUMC 2 0
MONA Posting date calendar month BUMON NUMC 2 0
WITHT Indicator for withholding tax type WITHT CHAR 2 0
WT_WITHCD Withholding tax code WT_WITHCD CHAR 2 0
QLAND Withholding Tax Country Key QLAND CHAR 3 0
QLTXT Country for the Withholding Tax WT_QLTXT CHAR 30 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
PARTNER_SEQ_NB Partner sequential number on Withholding Tax lists PARTNER_SEQ_NB NUMC 6 0
TEXT40 Description of Withholding tax type for Ext. WT WT_TYPE_DESC CHAR 40 0
WT_TYPECODE_TEXT Description of Wth/Tax Type + code for Ext. WT WT_TYPE_CODE_DESC CHAR 40 0
QSCOD Official Withholding Tax Key WT_OWTCD CHAR 4 0
WT_OFFWT_TEXT Text of the Official Withholding Tax Code WT_OFFWT_TEXT CHAR 40 0
TAX_REGION Tax Region Code for Withholding Tax Code TAX_REGIO CHAR 3 0
TAX_REGION_NUM Official numerical state code WT_REGIO_NUM CHAR 3 0
TAX_REGION_TXT Tax Region Name for Wtihholding Tax Code TAX_REGION_TXT CHAR 20 0
CTNUMBER Withholding Tax Certificate Number CTNUMBER CHAR 10 0
WT_POSTM Posting time WT_POSTM CHAR 1 0
1 Posting at time of invoice entry
2 Posting at time of payment
WT_POSIN Posting indicator WT_POSIN CHAR 1 0
1 Standard posting: Bank/vendor/customer line item reduced
2 Offsetting entry to G/L account ("grossing up")
3 Offsetting entry to G/L account
FPRCD Provincial tax code FPRCD CHAR 3 0
QEKAR Income Type QEKAR CHAR 4 0
EATXT Description of the income type WT_INCOME_TYPE_DESC CHAR 40 0
XQFOR Indicator: Calculate withholding tax according to formula? XQFOR CHAR 1 0
X Yes
NULL No
QPROZ Percentage Subject to Withholding Tax QPROZ DEC 5 2
QSATZ Withholding tax rate WT_QSATZ DEC 7 4
QSATR Reduced withholding tax rate WT_QSATR DEC 7 4
SORTL Sort field SORTL CHAR 10 0
SPRAS Language Key SPRAS LANG 1 0
BRSCH Industry key BRSCH CHAR 4 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
STCEG VAT Registration Number STCEG CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
WERKS Plant WERKS_D CHAR 4 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
NAME_TXT Converted name field (with form of address) AD_NAMETXT CHAR 50 0
NAME_CO c/o name AD_NAME_CO CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
CITY_CODE City code for city/street file AD_CITYNUM CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM CHAR 12 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP CHAR 4 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
CITY_CODE2 City PO box code (City file) AD_CIT2NUM CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY CHAR 3 0
POSTALAREA (Not Supported) Post Delivery District AD_PSTLAR CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES CHAR 4 0
STREETCODE Street Number for City/Street File AD_STRNUM CHAR 12 0
STREETABBR (Not Supported) Abbreviation of Street Name AD_STRABBR CHAR 2 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
LANGU Language Key SPRAS LANG 1 0
REGION Region (State, Province, County) REGIO CHAR 3 0
SORT1 Search Term 1 AD_SORT1UL CHAR 20 0
SORT2 Search Term 2 AD_SORT2UL CHAR 20 0
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGINA CHAR 4 0
EXTENSION1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENSION2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID CHAR 10 0
REMARK Address notes AD_REMARK1 CHAR 50 0
LANGU_CREA Address record creation original language AD_LANGUCR LANG 1 0
PO_BOX_LOBBY PO Box Lobby AD_PO_BOX_LBY CHAR 40 0
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
COUNTY_CODE County code for county AD_CNTYNUM CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM CHAR 3 0
LANDX Country Name LANDX CHAR 15 0
NATIO Nationality NATIO CHAR 15 0
BEZEI Region AD_REGION CHAR 20 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
WT_SHORT_ADDR One-line short form of formatted address AD_LINE_S CHAR 80 0
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
KUKLA Customer classification KUKLA CHAR 2 0
BAHNS Train station BAHNS CHAR 25 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
QSREC Vendor Recipient Type QSREC CHAR 2 0
WT_WTSTCD Withholding tax identification number WT_WTSTCD CHAR 16 0
WT_EXNR Exemption certificate number WT_EXNR CHAR 15 0
WT_EXRT Exemption rate WT_EXRT DEC 5 2
WT_EXDF Date on which exemption begins WT_EXDF DATS 8 0
WT_EXDT Date on which exemption ends WT_EXDT DATS 8 0
WT_WTEXRS Reason for exemption WT_WTEXRS CHAR 2 0
WT_WTAGT Indicator: Withholding tax agent? WT_WTAGT CHAR 1 0
X Yes
NULL No
WT_AGTDF Obligated to withhold tax from WT_AGTDF DATS 8 0
WT_AGTDT Obligated to withhold tax until WT_AGTDT DATS 8 0
QSZNR Certificate Number of the Withholding Tax Exemption (old WT) WT_QSZNR CHAR 10 0
QSZDT Validity Date for Wth/Tax Exemption Certificate (old WT) WT_QSZDT DATS 8 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
GFORM Legal status GFORM CHAR 2 0
NIELS Nielsen ID NIELS CHAR 2 0
HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
WT_GROUP1 Grouping criterion WT_GROUP CHAR 10 0
DMBTR Gross amount in Reporting Currency WT_DMBTR CURR 15 2
WT_QSSHH Withholding Tax Base Amount in Reporting Currency WT_BASE_AMT CURR 15 2
WT_QBSHH Withholding Tax Amount in Reporting Currency WT_TAX_AMT CURR 15 2
WT_QSFHH Amount exempt from withholding tax (in reporting currency) WT_EXMP_AMT CURR 15 2
WT_TAXHH Tax Amount in Reporting Currency WT_HWSTE CURR 15 2
WT_AMEXCLVAT Net amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVAT CURR 15 2
WT_AMRBASE WT base amount excluding taxes ( in reporting currency) WT_RBASE CURR 15 2
WT_AMREXMP Amount Exempt from WH Tax - VAT (in Reporting Currency) WT_REXMP CURR 15 2
SKNTO Cash discount amount in local currency WT_SKNTO CURR 15 2
PROFS Profession PROFS CHAR 30 0
CIIU Economic Code Activity CIIU CHAR 16 0
ADDITIONAL_INFO Additional Vendor information ADDITIONAL_INFO CHAR 1 0
BUPLA Business Place BUPLA CHAR 4 0
ALT_PAYEE Partner ID PARTNERNO CHAR 35 0
GB_CIS_SC_TRDNM Subcontractor's Trading Name GB_CIS_SC_TRDNM CHAR 64 0
GB_CIS_SC_FSNM Subcontractor's First Name GB_CIS_SC_FSNM CHAR 64 0
GB_CIS_SC_SCNM Subcontractor's Second Name GB_CIS_SC_SCNM CHAR 64 0
GB_CIS_SC_INTL Subcontractor's Last Name GB_CIS_SC_INTL CHAR 64 0
GB_CIS_SC_VFNNUM Verification Number GB_CIS_SC_VFNNUM CHAR 20 0
GB_CIS_SC_UTR Subcontractor's Unique Tax Reference (UTR) GB_CIS_SC_UTR CHAR 20 0
GB_CIS_SC_VFNSTS Sub contractor verification status GB_CIS_SC_VFNSTS CHAR 1 0
GB_CIS_SCNUM Numerical Character Field of Length 6 NUM6 NUMC 6 0
BE_BA_5060 Minimum Base Amount BE_MINBASE CURR 13 2
BE_BA_5061 Minimum Base Amount BE_MINBASE CURR 13 2
BE_BA_5062 Minimum Base Amount BE_MINBASE CURR 13 2
BE_BA_5063 Minimum Base Amount BE_MINBASE CURR 13 2
BE_CO_TOTAL Minimum Base Amount BE_MINBASE CURR 13 2
STENR Tax Number at Responsible Tax Authority STENR CHAR 18 0
KVERM Memo KVERM CHAR 30 0
BE_NIHIL Payment Indicator - Fiche- Belgium BE_NIHIL CHAR 1 0
KR_QSREC Vendor Recipient Type KR_QSREC CHAR 6 0
IE_CONTRACT_ID Contract identifier from Tax Authority IE_CONTRACT_ID INT4 10 0
IE_AMNT_UNDECL Amount Undeclared IE_AMNT_UNDECL CURR 13 2
IE_LST_PRTNR Last Partner Flag IE_LST_PRTNR CHAR 1 0
US_1099K_TRANS Number of transactions-1099K US_1099K_TRANS INT4 10 0
IDWTFIDOC IDWTFIDOC STRU 0 0
BUKRS Company Code BUKRS CHAR 4 0
BUPLA Business Place BUPLA CHAR 4 0
PARTNO_TYPE Type of partner number WT_PARTNO_TYPE CHAR 1 0
NULL Vendor/Customer (FI-AP/AR)
1 Business Partner (FI-CA)
PARTNERNO Partner ID PARTNERNO CHAR 35 0
WT_REVERSED Indicator: Document reversed? REVERSED CHAR 1 0
X Yes
NULL No
WT_PERIOD Reporting Period WT_REPPERIOD NUMC 2 0
WITHT Indicator for withholding tax type WITHT CHAR 2 0
WT_WITHCD Withholding tax code WT_WITHCD CHAR 2 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
ITEM_SOURCE Data source of item WT_ITEM_SOURCE CHAR 1 0
NULL FI-AP/AR
1 FI-CA
ITEM_REF Reference to WT item WT_ITEM_REF CHAR 24 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
PARTNER_SEQ_NB Partner sequential number on Withholding Tax lists PARTNER_SEQ_NB NUMC 6 0
WT_SHORT_ADDR One-line short form of formatted address AD_LINE_S CHAR 80 0
WT_BASMAN Indicator: Withholding tax base amount entered manually WT_BASMAN CHAR 1 0
X Yes
NULL No
WT_AMNMAN Indicator: Withholding tax amount entered manually WT_AMNMAN CHAR 1 0
X Yes
NULL No
WT_OPEN_ITEM Item status ( open, paid ...) WT_OPEN_ITEM CHAR 4 0
WT_NEWWT Indicator: Extended withholding tax active WT_NEWWT CHAR 1 0
X Yes
NULL No
WT_POSTM Posting time WT_POSTM CHAR 1 0
1 Posting at time of invoice entry
2 Posting at time of payment
QSREC Type of recipient WT_QSREC CHAR 2 0
HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
WAERS Currency Key WAERS CUKY 5 0
DMBTR Gross amount in Reporting Currency WT_DMBTR CURR 15 2
WRBTR Amount in Document Currency WT_WRBTR CURR 15 2
WT_QSSHH Withholding Tax Base Amount in Reporting Currency WT_BASE_AMT CURR 15 2
WT_QSSHB Withholding tax base amount in document currency WT_BS1 CURR 15 2
WT_QBSHH Withholding Tax Amount in Reporting Currency WT_TAX_AMT CURR 15 2
WT_QBSHB Withholding tax amount in document currency WT_WT1 CURR 15 2
WT_QSFHH Amount exempt from withholding tax (in reporting currency) WT_EXMP_AMT CURR 15 2
WT_QSFHB Amount exempt from withholding tax in document currency WT_EXMP1 CURR 15 2
WT_NETHH Net amount = Invoice amount - withholding tax amount in LC WT_NET CURR 15 2
WT_NETHB Net amount = Invoice amount - w/hold.tax amount in doc.crcy WT_NET1 CURR 15 2
WT_TAXHH Tax Amount in Reporting Currency WT_HWSTE CURR 15 2
WT_TAXHB Tax Amount in Document Currency WT_FWSTE CURR 15 2
WT_AMEXCLVAT Net amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVAT CURR 15 2
WT_AMEXCLVAT1 Net amount = Invoice amount - VAT in doc.crcy WT_EXCLVAT1 CURR 15 2
WT_AMRBASE WT base amount excluding taxes ( in reporting currency) WT_RBASE CURR 15 2
WT_AMRBASE1 WT base amount excluding taxes (doc. cur) WT_RBASE1 CURR 15 2
WT_AMREXMP Amount Exempt from WH Tax - VAT (in Reporting Currency) WT_REXMP CURR 15 2
WT_AMREXMP1 Amount Exempt from WH Tax - VAT (in Document Currency) WT_REXMP1 CURR 15 2
WT_XDMBTR Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XWRBTR Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XDMBTR1 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XWRBTR1 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XDMBTR2 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_XWRBTR2 Free amount field for country specific WT_FREE_DMBTR CURR 15 2
WT_PAYBH Payment amount in local currency WT_PAYBH CURR 15 2
WT_PAYBB Payment amount in document currency WT_PAYBB CURR 15 2
SKNTO Cash discount amount in local currency WT_SKNTO CURR 15 2
WSKTO Cash discount amount in document currency WT_WSKTO CURR 15 2
WT_SLFWTPD Indicator: Entry posted as self-withholding tax WT_SLFWTPD CHAR 1 0
X Yes
NULL No
WT_GRUWTPD Indicator: Entry posted as "Grossing up" WT_GRUWTPD CHAR 1 0
X Yes
NULL No
WT_OPOWTPD Indicator: Entry posted as a debit/credit WT_OPOWTPD CHAR 1 0
X Yes
NULL No
CTNUMBER Withholding Tax Certificate Number CTNUMBER CHAR 10 0
WT_WTEXMN Exemption certificate number WT_EXNR CHAR 15 0
WT_QSZRT Exemption rate WT_EXRT DEC 5 2
WT_ISSDT Issue or Print Date of Withholding Tax Certificate CTISSUEDATE DATS 8 0
WT_POSIN Posting indicator WT_POSIN CHAR 1 0
1 Standard posting: Bank/vendor/customer line item reduced
2 Offsetting entry to G/L account ("grossing up")
3 Offsetting entry to G/L account
XREF2 Business partner reference key XREF2 CHAR 12 0
XREF3 Reference key for line item XREF3 CHAR 20 0
BLDAT Document Date in Document BLDAT DATS 8 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART CHAR 2 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
GSBER Business Area GSBER CHAR 4 0
HKONT General Ledger Account HKONT CHAR 10 0
VORGN Transaction Type for General Ledger VORGN CHAR 4 0
SGTXT Item Text SGTXT CHAR 50 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
WT_PAYDT Payment date WT_PAYDT DATS 8 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
ZUMSK Target Special G/L Indicator DZUMSK CHAR 1 0
BSCHL Posting Key BSCHL CHAR 2 0
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
XCPDD Indicator: Address and bank data set individually XCPDD CHAR 1 0
X Yes
NULL No
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
REBZT Follow-On Document Type REBZT CHAR 1 0
SECCO Section Code SECCO CHAR 4 0
KURSF Exchange rate KURSF DEC 9 5
WT_GROUP1 Grouping criterion WT_GROUP CHAR 10 0
WT_FREE1 Free for country specific field WT_FREE CHAR 10 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
QSCOD Official Withholding Tax Code QSCOD CHAR 4 0
BUKRS_ORG Company Code BUKRS CHAR 4 0
LIFNR_ORG Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR_ORG Customer Number KUNNR CHAR 10 0
US_INFO_1042_00 Long Field Label SCRTEXT_L CHAR 40 0
US_REPORT_YEAR Fiscal Year GJAHR NUMC 4 0
US_INFO_1042_10 Long Field Label SCRTEXT_L CHAR 40 0
US_CONT_NAME Name NAME1 CHAR 30 0
US_CONT_TELNO Phone number of person responsible for company area TELE CHAR 12 0
US_INFO_1042_20 Long Field Label SCRTEXT_L CHAR 40 0
US_PAYER_NAME Name NAME1 CHAR 30 0
US_PAYER_TAXNO Tax Number 1 STCD1 CHAR 16 0
US_INFO_1042_30 Long Field Label SCRTEXT_L CHAR 40 0
US_TRANS_TEST File type indicator WT_TEST_FILE CHAR 4 0
TEST Test file creation
NULL Transfer file creation
US_TRANS_AGENT Withholding Agent's EIN indicator WT_EIN_IND NUMC 1 0
1 Withholding Agent's EIN indicator 1
2 Withholding Agent's EIN indicator 2
US_TRANS_NAME Name NAME1 CHAR 30 0
US_TRANS_STRAS House number and street STRAS_GP CHAR 35 0
US_TRANS_CITY City CITY CHAR 25 0
US_TRANS_REGIO Region (State, Province, County) REGIO CHAR 3 0
US_TRANS_PSTLZ Postal Code PSTLZ CHAR 10 0
US_TRANS_TAXNO Tax Number 1 STCD1 CHAR 16 0
US_TCC Transmitter Control WT_T_CTRL CHAR 5 0
US_INFO_1099_10 Long Field Label SCRTEXT_L CHAR 40 0
US_VENDOR_STCD1 Tax Number 1 STCD1 CHAR 16 0
US_VENDOR_STCD2 Tax Number 2 STCD2 CHAR 11 0
US_VENDOR_REGIO Region (State, Province, County) REGIO CHAR 3 0
US_INFO_1099_20 Long Field Label SCRTEXT_L CHAR 40 0
US_HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
US_MIN_FED Minimum Amount Federal Tax WT_MINTAX CURR 13 2
US_MIN_ROYAL Minimum Base Amount - Royalties WT_MBASE2 CURR 13 2
US_MIN_DIVID Minimum Base Amount - Dividends WT_MBASE8 CURR 13 2
US_MIN_DIRECT Minimum Base Amount - Direct Sales WT_MBASE9 CURR 13 2
US_MIN_INT_GEN Minimum Base Amount - Interest income WT_MBASE1J CURR 13 2
US_MIN_INT_BUS Minimum Base Amount - Interest income for trade and business WT_MBASE1I CURR 13 2
US_MIN_G_UNEMPLOY Minimum Base Amount - Unemployment WT_MBASE1G CURR 13 2
US_MIN_G_TAX_REFUND Minimum Base Amount - State and Local Tax Refund WT_MBASE2G CURR 13 2
US_MIN_G_OTH_GRANT Minimum Base Amount - Other Taxable Grant WT_MBASE5G CURR 13 2
US_MIN_G_ATAA_PYMNT Minimum Base Amount - Other Taxable Grant WT_MBASE5G CURR 13 2
US_INFO_1099_30 Long Field Label SCRTEXT_L CHAR 40 0
US_TRANS_NAME1 Name 1 WT_NAME1 CHAR 40 0
US_TRANS_NAME2 Name 2 WT_NAME2 CHAR 40 0
US_TRANS_TCC Transmitter Control WT_T_CTRL CHAR 5 0
US_TRANS_TIN Character Length 11 CHAR11 CHAR 11 0
US_CONTACT_PERS Name NAME1 CHAR 30 0
US_CONTACT_TELNO Phone number of person responsible for company area TELE CHAR 12 0
US_CONTACT_EMAIL E-mail address WT_EMAIL CHAR 35 0
US_COMP_NAME1 Name 1 WT_NAME1 CHAR 40 0
US_COMP_NAME2 Name 2 WT_NAME2 CHAR 40 0
US_COMP_STRAS House number and street STRAS_GP CHAR 35 0
US_COMP_CITY City ORT01 CHAR 25 0
US_COMP_STATE Region (State, Province, County) REGIO CHAR 3 0
US_TRANS_POST Postal Code PSTLZ CHAR 10 0
US_INFO_1099_40 Long Field Label SCRTEXT_L CHAR 40 0
US_PAYER_AGENT Payer (P) / Transfer Agent (A) WT_US_PAYER_AGENT CHAR 1 0
P Payer
A Transfer Agent
US_PAYER_NAME1 Name 1 WT_NAME1 CHAR 40 0
US_PAYER_NAME2 Name 2 WT_NAME2 CHAR 40 0
US_PAYER_CTRL Payer Name Control WT_P_CTRL CHAR 4 0
US_PAYER_STRAS House number and street STRAS_GP CHAR 35 0
US_PAYER_CITY City ORT01 CHAR 25 0
US_PAYER_REGIO Region (State, Province, County) REGIO CHAR 3 0
US_PAYER_POST Postal Code PSTLZ CHAR 10 0
US_PAYER_TELNO Phone number of person responsible for company area TELE CHAR 12 0
US_PAYER_TIN Character Length 11 CHAR11 CHAR 11 0
US_INFO_1099_50 Long Field Label SCRTEXT_L CHAR 40 0
US_FILE_COMBINE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_FILE_TEST Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_FILE_TAPE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_FILE_CORR_IND Correction File Indicator WT_CORR_IND CHAR 1 0
NULL No Correction
G First Correction
C Second Correction
US_FILE_TM_NO Transmitter Media Number WT_TM_NO CHAR 6 0
US_ALPHA_REPLACE Alpha Replacement Co WT_F_ALPHA CHAR 2 0
US_IRS_FNAME IRS File Name WT_F_EFILE CHAR 15 0
US_APPL_FILE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_APPL_FNAME Character field of length 40 CHAR40 CHAR 40 0
US_LOCAL_FILE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_LOCAL_FNAME Character field of length 40 CHAR40 CHAR 40 0
US_AGENT_NAME Withholding Tax Agent Contact Name US_1042_AGENT_NAME CHAR 45 0
US_DEPT_TITLE Withholding Agent's Department Title US_1042_DEPT_NAME CHAR 45 0
US_INFO_MULTI Long Field Label SCRTEXT_L CHAR 40 0
US_CONT_MULTI Check Box XFELD_US CHAR 1 0
X Yes
NULL No
US_CONT_COMPANY Company Code BUKRS_US CHAR 4 0
US_REC_TRUNC Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_MIN_CHECK Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_INFO_FILLER Long Field Label SCRTEXT_L CHAR 40 0
US_FILLER_PSE Payment Settlement Entity US_FILER_PSE CHAR 1 0
X Yes
NULL No
US_FILLER_EPF Electronic Payment Facilitator US_FILER_EPF CHAR 1 0
X Yes
NULL No
US_FILLER_TPP Indicator to check if Filer is TPP US_FILER_TPP CHAR 1 0
X Yes
NULL No
US_PSE_NAME Name of the PSE US_PSE_NAME CHAR 30 0
US_PSE_PHONE Telephone Number of the PSE US_PSE_PHONE CHAR 12 0
US_MIN_TRANS Minimum Number of Transactions US_MIN_TRANS NUMC 3 0
US_MIN_AMT Minimum Amount US_MIN_AMT CURR 13 2
US_POS_PERIOD Posting period US_POS_PERIOD NUMC 2 0
US_TRANS_PAYMT Check whether transaction type is payment card US_TRANS_PAYMT CHAR 1 0
X Yes
NULL No
US_TRANS_TPN Check whether transaction is third party network US_TRANS_TPN CHAR 1 0
X Yes
NULL No
IT_KANTIVA General Ledger Account HKONT CHAR 10 0
IT_ENASARCO General Ledger Account HKONT CHAR 10 0
IT_TAX_NO_SUBJ Tax on sales/purchases code MWSKZ CHAR 2 0
IT_RF07_BUKRS Company Code BUKRS CHAR 4 0
IT_RF07_GJAHR Fiscal Year GJAHR NUMC 4 0
IT_RF07_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
IT_RF07_CAUS Modello 770 - Reason for payment of service CAUS CHAR 1 0
IT_RF07_NASSC Annual amount not subject to WT on the basis of std. system NASSC CHAR 13 0
IT_RF07_CDINAIL Withholding tax in Italy : Modello 770 - additional data CDINAIL CHAR 10 0
IT_RF07_DTINIZ Starting date of INAIL insurance covering DTINIZ DATS 8 0
IT_RF07_DTFINE Ending date of INAIL insurance covering DTFINE DATS 8 0
IT_RF07_CDCOMU Municipal code CDCOMU CHAR 4 0
IT_REP_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
IT_REP_LAND1 Country Key LAND1 CHAR 3 0
IT_REP_SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
IT_REP_NAME1 Name NAME1 CHAR 30 0
IT_REP_NAME2 Name NAME1 CHAR 30 0
IT_REP_GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
IT_REP_GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
IT_REP_CMDOM City ORT01 CHAR 25 0
IT_REP_PRDOM Region (State, Province, County) REGIO CHAR 3 0
IT_REP_INDOM House number and street STRAS CHAR 30 0
ES_FILL_DME Checkbox XFELD CHAR 1 0
X Yes
NULL No
ES_INV_DATE Update date for table QSTRE from invoice document WT_QSTRE_INV_DATE NUMC 1 0
1 Posting date
2 Document date
ES_PYMT_DATE Update date for table QSTRE from payment document WT_QSTRE_PYMT_DATE NUMC 1 0
1 Clearing date
2 Posting date
3 Document date
ES_QSTRE_DATE Field of type DATS DATS DATS 8 0
ES_OUTPUT Output option for ES/PT WT_ES_OUTPUT NUMC 1 0
1 Diskette
2 Tape
3 Internet
ES_DECL Declaration for Spain WT_ES_DECL NUMC 1 0
1 Ordinary declaration
2 Substitute declaration
3 Supplementary declaration
ES_ID_DECL ID of the declaration WT_ES_ID_DECL NUMC 13 0
ES_ID_PRV_DEC ID of the previous declaration WT_ES_ID_PRV_DEC NUMC 13 0
ES_NIF_WH_AG NIF of withholding agent WT_ES_NIF_WH_AG CHAR 16 0
ES_NAME_WH_AG Name of withholding agent WT_ES_NAME_AG CHAR 40 0
ES_TEL Telephone number WT_ES_TEL NUMC 9 0
ES_CONTACT_PERS Contact person WT_ES_PERS CHAR 40 0
ES_TAX_DEPT Provincial tax code FPRCD CHAR 3 0
KR_WT_TYPE1 Indicator for withholding tax type WITHT CHAR 2 0
KR_WT_TYPE2 Indicator for withholding tax type WITHT CHAR 2 0
KR_WT_CODE1 Withholding tax code WT_WITHCD CHAR 2 0
KR_WT_CODE2 Withholding tax code WT_WITHCD CHAR 2 0
KR_WT_DATE Reporting Date for Tax Report MLDDT_BSET DATS 8 0
KR_WT_PYDT1 Clearing Date AUGDT DATS 8 0
KR_WT_PYDT2 Clearing Date AUGDT DATS 8 0
KR_WT_SECCO1 Section Code SECCO CHAR 4 0
KR_WT_SECCO2 Section Code SECCO CHAR 4 0
KR_WT_QBSHH Withholding Tax Amount in Reporting Currency WT_TAX_AMT CURR 15 2
VE_L_BLART Document Type BLART CHAR 2 0
VE_U_BLART Document Type BLART CHAR 2 0
VE_CERTNUMBER Text field length 14 CHAR14 CHAR 14 0
VE_CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
VE_CPUTM Time of Entry CPUTM TIMS 6 0
VE_TAXHB Tax Amount in Document Currency FWSTE CURR 13 2
VE_TAXHH Tax Amount in Local Currency HWSTE CURR 13 2
VE_CERT_RGN_FLG Reprint the Certificate? CERT_RGN_FLG CHAR 1 0
X Yes
NULL No
VE_DM_HDR Text field, length 35 CHAR_35 CHAR 35 0
VE_CERT_HDR Text field, length 35 CHAR_35 CHAR 35 0
VE_STCD1 Tax Number 1 STCD1 CHAR 16 0
VE_CNUM Document Header Text BKTXT CHAR 25 0
VE_WT_RATE Withholding tax rate WT_QSATZ DEC 7 4
GB_PERIOD_END_DATE New CIS Return - End date for a return Period GB_PERIOD_END_DATE DATS 8 0
GB_NIL_RETURN_INDICATOR Specifies if the current return is a Nil Return or n GB_NIL_RETURN_INDICATOR CHAR 1 0
X Yes
NULL No
GB_EMPSTAT_VFD_DCLRTN Employment Status Declaration GB_EMPSTAT_VFD_DCLRTN CHAR 1 0
X Yes
NULL No
GB_SC_VFD_DCLRTN Subcontractor Verification Declaration GB_SC_VFD_DCLRTN CHAR 1 0
X Yes
NULL No
GB_INFO_CRCT_DCLRTN Information Correct Declaration GB_INFO_CRCT_DCLRTN CHAR 1 0
X Yes
NULL No
GB_INACTIVITY_INDICATOR GB_INACTIVITY_INDICATOR GB_INACTIVITY_INDICATOR CHAR 1 0
X Yes
NULL No
GB_RETURN_HDR Text field, length 35 CHAR_35 CHAR 35 0
GB_DCLRTN_HDR Text field, length 35 CHAR_35 CHAR 35 0
GB_CIS_RTN_PSWRD Password for the Return filing GB_CIS_RTN_PSWRD CHAR 25 0
GB_CIS_GFF_SNDRID Sender Id for GFF EDI Transmission GB_GFF_SNDR_ID CHAR 35 0
GB_CIS_GFF_RCVRID GB CIS GFF Transmission Receiver Id GB_GFF_RCVR_ID CHAR 35 0
GB_FILE_HDR Data Element Type CHAR Length 35 CHAR35 CHAR 35 0
GB_CIS_ICR Text field length 14 CHAR14 CHAR 14 0
GB_CIS_TEST_TRNS TEST TRANSMISSION FLAG CIS_TEST_TRANS CHAR 1 0
X Yes
NULL No
ID_WT_PERIOD Reporting Period of Electronic Tax Return UMSVDPER NUMC 2 0
ID_WT_YEAR Reporting Year of Electronic Tax Return UMSVDYEA NUMC 4 0
ID_WT_CORRECTION Number of correction CORR_NUMBER NUMC 1 0
ID_WT_FORMCODE 30 Characters CHAR30 CHAR 30 0
ID_WT_RATE Withholding tax rate WT_QSATZ DEC 7 4
ID_WT_ADDRESS Char255 CHAR255 CHAR 255 0
ID_WT_SERVICE1 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE2 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE3 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE4 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE5 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE6 Version Number Component CHAR2 CHAR 2 0
ID_WT_ESTPERC Percentage Subject to Withholding Tax QPROZ DEC 5 2
ID_WT_GROSSAMT Net amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVAT CURR 15 2
BE_CONTACT_ID Contact Person Name BE_CONTACT_ID CHAR 34 0
BE_CONTACT_EM Email Address of the Contact Person BE_CONTACT_EM CHAR 44 0
BE_MINBASE Minimum Base Amount BE_MINBASE CURR 13 2
BE_REPORTYEAR Reporting Year in the Withholding Tax Return BE_REPORTYEAR NUMC 4 0
BE_REPORTDATE Date of Report - Fiche (Belgium) BE_REPORTDATE DATS 8 0
BE_SEQ_NUM Sequential Number for Fiche - Belgium BE_SEQ_NUM CHAR 4 0
BE_CORR_INDICATOR Correction Indicator for Withholding Tax Return BE_CORR_INDICATOR CHAR 1 0
0 Ordinary
1 Grouped Correction - Correction
2 Grouped Correction - Addition
3 Grouped Correction - Deletion
4 Complete Replacement
BE_TEST_RUN Test Run Indicator - Belgium BE_TEST_RUN CHAR 1 0
BE_CORR_REFERENCE Reference Number for the Correction BE_CORR_REFERENCE CHAR 6 0
BE_NIHIL Payment Indicator - Fiche- Belgium BE_NIHIL CHAR 1 0
BE_HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
BE_INFO_MULTI Long Field Label SCRTEXT_L CHAR 40 0
BE_CONT_MULTI Multiple Company Codes XFELD_BE CHAR 1 0
X Yes
NULL No
BE_CONT_COMPANY Leading Company Code BUKRS_BE CHAR 4 0
TH_PAYER Tax Payer type TH_PAYER NUMC 1 0
1 Withhold at Source
2 Pay every time
3 Pay one time
4 Others