J_3RFTAX_EXTRD - Tax Extract Detail Lines

Tax Extract Detail Lines information is stored in SAP table J_3RFTAX_EXTRD.
It is part of development package J3RFTAX in software component FI-LOC-FI-RU. This development package consists of objects that can be grouped under "Tax Accounting".

Fields for table J_3RFTAX_EXTRD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
EXTRT	Extract name	X	J_3RF_TAX_EXTRACT	CHAR	24	J_3RFTAX_EXTRH
BUKRS1	Company Code	X	BUKRS	CHAR	8	T001
BELNR1	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
GJAHR1	Fiscal Year	X	GJAHR	NUMC	8
BUZEI1	Number of Line Item Within Accounting Document	X	BUZEI	NUMC	6
.INCLUDE				J_3RF_RFPOS	0
ACTIV	List Level in Which the Line Item Is Active		ACTIV	NUMC	4
ANLN1	Main Asset Number		ANLN1	CHAR	24	*
ANLN2	New asset subnumber, 4 characters		ANLN2_4	CHAR	8
AUFNR	Order Number		AUFNR	CHAR	24	*
AUGBL	Document Number of the Clearing Document		AUGBL	CHAR	20
AUGDT	Clearing Date		AUGDT	DATS	16
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BLART	Document Type		BLART	CHAR	4	T003
BLDAT	Document Date in Document		BLDAT	DATS	16
BSCHL	Posting Key		BSCHL	CHAR	4	TBSL
BSTAT	Document Status		BSTAT_D	CHAR	2
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BUKRS	Company Code		BUKRS	CHAR	8	T001
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
BWWRT	Amount Valuated in Local Currency		BWWRT	CURR	12
BWWR2	Amount Valuated in Local Currency 2		BWWR2	CURR	12
BWWR3	Amount Valuated in Local Currency 3		BWWR3	CURR	12
DMSHB	Amount in Local Currency with +/- Signs		DMSHB	CURR	12
HWAER	Local Currency		HWAER	CUKY	10	TCURC
DMBE2	Amount in Second Local Currency with +/- Sign		DMBE2_VZ	CURR	12
HWAE2	Currency Key of Second Local Currency		HWAE2	CUKY	10	*
DMBE3	Amount in Third Local Currency with +/- Sign		DMBE3_VZ	CURR	12
HWAE3	Currency Key of Third Local Currency		HWAE3	CUKY	10	*
EBELN	Purchasing Document Number		EBELN	CHAR	20
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	*
ETEN2	Schedule Line Number		ETENR	NUMC	8	*
FAEDT	Net Due Date		FAEDT_FPOS	DATS	16
FILKD	Account Number of the Branch		FILKD	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
GSBER	Business Area		GSBER	CHAR	8	TGSB
JAMON	Fiscal Year/Posting Period from Posting Date		JAMON_XPO	CHAR	14
KOART	Account type		KOART	CHAR	2
KONTO	Account Number		KTONR_AV	CHAR	20
KOSTL	Cost Center		KOSTL	CHAR	20	*
MABER	Dunning Area		MABER	CHAR	4	*
MADAT	Date of Last Dunning Notice		MADAT	DATS	16
MANSP	Dunning Block		MANSP	CHAR	2	T040S
MANST	Dunning Level		MAHNS_D	NUMC	2
MONAT	Fiscal period		MONAT	NUMC	4
MSCHL	Dunning Key		MSCHL	CHAR	2	T040
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
POSN2	Sales Document Item		POSNR_VA	NUMC	12
PRCTR	Profit Center		PRCTR	CHAR	20
QBSHB	Withholding Tax Amount (in Doc. Currency) with +/- Sign		QBSHB_VZ	CURR	12
QSFBT	Withholding Tax-Exempt Amount (in Doc. Crcy) with +/- Sign		QSFBT_VZ	CURR	12
QSSHB	Withholding Tax Base Amount with +/- Sign		QSSHB_VZ	CURR	12
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
SAMNR	Invoice List Number		SAMNR	NUMC	16
SGTXT	Item Text		SGTXT	CHAR	100
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
SKFBT	Amount Subject to Discount in Document Curr. with +/- Sign		SKFBT_VZ	CURR	12
SKNTO	Cash Discount Amount (+/-) in Local Currency		SKNTO_VZ	CURR	12
STAKZ	Indicator: Statistical Document?		XSTKZ	CHAR	2
UMSKS	Special G/L Transaction Type		UMSKS	CHAR	2
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2	*
UZAWE	Payment method supplement		UZAWE	CHAR	4	*
VALUT	Value date		VALUT	DATS	16
VBEL2	Sales Document		VBELN_VA	CHAR	20
VBELN	Billing Document		VBELN_VF	CHAR	20
VBEWA	Flow Type		SBEWART	CHAR	8	*
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	*
VERTN	Contract Number		RANL	CHAR	26
VERTT	Contract Type		RANTYP	CHAR	2
VERZ1	Days in Arrears for Cash Discount Terms 1		VERZ1	DEC	3
VERZN	Days in Arrears by Net Due Date		VERZN	DEC	3
WERKS	Plant		WERKS_D	CHAR	8
WRSHB	Foreign Currency Amount with Signs (+/-)		WRSHB	CURR	12
WAERS	Currency Key		WAERS	CUKY	10	TCURC
WSKTO	Cash Discount Amount in Document Currency with +/- Sign		WSKTO_VZ	CURR	12
WVERW	Bill of Exchange Usage Type		WVERW	CHAR	2
XBLNR	Reference Document Number		XBLNR1	CHAR	32
XSTRP	Indicator: Disputed Item?		XSTRP	CHAR	2
XZAHL	Indicator: Is Posting Key Used in a Payment Transaction?		XZAHL	CHAR	2
XREF1	Business Partner Reference Key		XREF1	CHAR	24
XREF2	Business Partner Reference Key		XREF2	CHAR	24
XARCH	Indicator: Document Already Archived?		XARCH	CHAR	2
RSTGR	Reason Code for Payments		RSTGR	CHAR	6	*
ASKTO	Current Cash Disc. Amount in Document Currency with +/- Sign		ASKTO_VZ	CURR	12
KURSE	Effective Exchange Rate in the Line Item		KURSE	DEC	5
REBZT	Follow-On Document Type		REBZT	CHAR	2
PSWSL	Update Currency for General Ledger Transaction Figures		PSWSL	CUKY	10	TCURC
PSWBT	Amount for Updating in General Ledger		PSWBT	CURR	12
HKONT	General Ledger Account		HKONT	CHAR	20	*
XNEGP	Indicator: Negative Posting		XNEGP	CHAR	2
RFZEI	Payment Card Item		RFZEI_CC	NUMC	6
CCBTC	Payment cards: Settlement run		CCBTC	CHAR	20
KKBER	Credit control area		KKBER	CHAR	8	T014
XREF3	Reference key for line item		XREF3	CHAR	40
DTWS1	Instruction Key 1		DTAT16	NUMC	4	*
DTWS2	Instruction Key 2		DTAT17	NUMC	4	*
DTWS3	Instruction key 3		DTAT18	NUMC	4	*
DTWS4	Instruction key 4		DTAT19	NUMC	4	*
ABSBT	Credit Management: Hedged Amount		ABSBT	CURR	12
KKBWR	Currency of Credit Control Area		KKBWR	CUKY	10	*
PROJK	Individual Structural Element (WBS Element) in Ext. Format		PROJK_EXT	CHAR	48
XPYPR	Indicator: Items from Payment Program Blocked		XPYPR	CHAR	2
KIDNO	Payment Reference		KIDNO	CHAR	60
XAUGP	Indicator: Item Has Been Cleared?		XAUGP	CHAR	2
BUPLA	Business Place		BUPLA	CHAR	8	*
SECCO	Section Code		SECCO	CHAR	8
GKART	Offsetting Account Type		GKART	CHAR	2
GKONT	Offsetting Account Number		GKONT	CHAR	20
PYCUR	Currency for Automatic Payment		PYCUR	CUKY	10	*
PYAMT	Amount in Payment Currency		PYAMT	CURR	12
PYORD	Payment Order		PYORD	CHAR	20
XTEXT	Indicator: Texts Exist?		XTEXT_F02L	CHAR	2
TDID	Text ID		TDID	CHAR	8	*
XDUEN	Indicator: Item Is Due Net?		XDUEN	CHAR	2
XDUE1	Indicator: Cash Discount Term 1 Is Due on Item?		XDUE1	CHAR	2
XRAGL	Indicator: Clearing Was Reversed		XRAGL	CHAR	2
XSELP	Item selected (selected, chosen, ...)		XSELP	CHAR	2
CESSION_KZ	Accounts Receivable Pledging Indicator		CESSION_KZ	CHAR	4	*
BUZID	Identification of the Line Item		BUZID	CHAR	2
AUGGJ	Fiscal Year of Clearing Document		AUGGJ	NUMC	8
AGZEI	Clearing Item		AGZEI	DEC	3
VNAME	Joint venture		JV_NAME	CHAR	12	T8JV
EGRUP	Equity group		JV_EGROUP	CHAR	6	T8JF
BTYPE	Billing Indicator		JV_BILIND	CHAR	4	T8JA
VORGN	Transaction Type for General Ledger		VORGN	CHAR	8