IDFIVATT_EXT_ITM - External Data (Items)

External Data (Items) information is stored in SAP table IDFIVATT_EXT_ITM.
It is part of development package ID-FI-REU-VAT in software component FI-LOC-FI-CZ. This development package consists of objects that can be grouped under "FI Localization: Country-specific VAT implementations".

Fields for table IDFIVATT_EXT_ITM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
EXT_TYPE	External Data Type	X	IDFIVAT_EXT_TYPE	CHAR	2
LOGSYS	Logical system	X	LOGSYS	CHAR	20
TBUKRS	Dominant Enterprise/Company Code	X	FOT_TBUKRS	CHAR	8
DECL_CTRY	Reporting Country/Region	X	FOT_DCCTRY	CHAR	6
DECL_YEAR	Reporting Year of Data Transmission to Authorities	X	FOT_DEYEAR	NUMC	8
DECL_PER	Reporting Period	X	IDFIVAT_DECL_PER	CHAR	4
DECL_RUNID	Counter of a Corrected Return	X	FOT_RUNID	NUMC	6	IDFIVATT_EXT_HDR
DECL_ITEM	Multinational ATR Item ID	X	FOT_ITEM	CHAR	16
.INCLUDE				IDFIVATS_EXT_ITM	0
VATSECTION	VAT Ledger Section		IDFIVAT_SECTION	CHAR	4
STCEG	VAT Registration Number		STCEG	CHAR	40
VATDATE	Tax Reporting Date		VATDATE	DATS	16
INVNUMBER	Invoice Number		IDFIVAT_INVOICE	CHAR	64
REFNUMBER	Reference Number		IDFIVAT_REFERENCE	CHAR	64
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
TAXRATE	Tax Rate		PROSATZ	CHAR	14
BASE_AMT	Base Amount in Document Currency		FOT_BASE_AMT	CURR	12
TAX_AMT	Tax Amount in Document Currency		FOT_TAX_AMT	CURR	12
TAX_DEDUCT	Tax Deductible/Payable		IDFIVAT_TAX_DEDUCT	CURR	12
ORIG_CURR	Document Currency		FOT_ORIG_CURR	CUKY	10	*
CLASS_CODE	Classification Code for Material		IDFIVAT_CLASS_CODE	CHAR	40
MENGE	Quantity		MENGE_D	QUAN	7
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
XREVERSAL	Specifies Whether Document Is Reversal Doc. or Reversed Doc.		XREVERSAL	CHAR	2
PARTNER	Business Partner Number		BU_PARTNER	CHAR	20
CPDINFO	Checkbox		XFELD	CHAR	2
MULT_FACTOR	Multiplication Factor for Unit Change		IDFIVAT_MULT_FACTOR	DEC	8
MEINSTARGET	Target Unit of Measurement		IDFIVAT_MEINSTARGET	CHAR	34
OPBEL	Number of External Document		IDFIVAT_OPBEL	CHAR	24
INVNUMBER_ADD	Invoice Number		IDFIVAT_INVOICE	CHAR	64
REFNUMBER_ADD	Reference Number		IDFIVAT_REFERENCE	CHAR	64