J_1IQRDEP - Quarterly Returns Depot structure

Quarterly Returns Depot structure information is stored in SAP table J_1IQRDEP.
It is part of development package J1I2 in software component FI-LOC-LO-IN. This development package consists of objects that can be grouped under "India, Phase II".

Fields for table J_1IQRDEP

Field Name	Description	Is Key	Data Element	Data Type	Length
DOCNO	Internal Excise Document Number	X	J_1IDOCNO	NUMC	20
DOCYR	Excise year	X	J_1IDOCYR	NUMC	8
WERKS	Plant	X	WERKS_D	CHAR	8
FOLIO	Register Entry Serial Number	X	J_1ISRLNO1	NUMC	20
SERIALNO	Item in Material Document	X	MBLPO	NUMC	8
EXNUM	Official Excise Document Number		J_1IEXCNUM	CHAR	20
EXDAT	Date			CHAR	20
NAME1	Name 1		AD_NAME1	CHAR	80
ADDR1	Street 2		AD_STRSPP1	CHAR	80
ADDR2	Street 2		AD_STRSPP1	CHAR	80
ADDR3	Street 2		AD_STRSPP1	CHAR	80
ADDR4	Street 2		AD_STRSPP1	CHAR	80
EXCCD	ECC Number		J_1IEXCD	CHAR	80
EXCRN	Excise Registration Number		J_1IEXRN	CHAR	80
EXCRG	Excise Range		J_1IEXRG	CHAR	120
EXCDI	Excise Division		J_1IEXDI	CHAR	120
EXCCO	Excise Commissionerate		J_1IEXCO	CHAR	120
MAKTX	Material Description		MAKTX	CHAR	80
MENGE	Excise Invoice Quantity		J_1IEXMENGE	QUAN	7
CHAPID	Chapter ID		J_1ICHID	CHAR	24
CURR	Currency		J_1IEXCCUR	CUKY	10
EXBED	Basic Excise Duty		J_1IEXCBED	CURR	7
EXAED	Special Excise Duty		J_1IEXCSED	CURR	7
EXSED	Additional Excise Duty		J_1IEXCAED	CURR	7
CESS	Cess amount		J_1IEXCESS	CURR	7
BEDRATE	BED percentage		J_1IBEDRAT	DEC	4
SEDRATE	Special Excise Duty %		J_1ISEDRAT	DEC	4
AEDRATE	Additional Excise Duty %		J_1IAEDRAT	DEC	4
CESSRATE	Cess Rate		J_1ICESS	DEC	4
VBELN	Delivery		VBELN_VL	CHAR	20
PDATE	Actual Goods Movement Date		WADAT_IST	DATS	16
NAME1B	Name 1		NAME1_GP	CHAR	70
ORT01B	City		ORT01_GP	CHAR	70
PSTLZB	Postal Code		PSTLZ	CHAR	20
S_EXNUM	Official Excise Document Number		J_1IEXCNUM	CHAR	20
S_EXDAT	Excise Document Date		J_1IEXCDAT	DATS	16
S_MENGE	Quantity mentioned in the excise invoice		J_1IMENGE	QUAN	7
S_EXCCD	ECC Number		J_1IEXCD	CHAR	80
S_EXCRN	Excise Registration Number		J_1IEXRN	CHAR	80
S_EXCRG	Excise Range		J_1IEXRG	CHAR	120
S_EXCDI	Excise Division		J_1IEXDI	CHAR	120
S_EXCCO	Excise Commissionerate		J_1IEXCO	CHAR	120
TOT_AMTDUTY	Basic Excise Duty		J_1IEXCBED	CURR	7
SNO	Serial Number			NUMC	8
REMARKS	Rule/Section		J_2IRULE	CHAR	20
MBLNR	Number of Material Document		MBLNR	CHAR	20
NCCD	National Calamity Contingency Duty		J_1IEXCNCCD	CURR	7
ECS	ECS Value		J_1IEXECS	CURR	7
EXADDTAX1	Additional Tax1 value		J_1IEXADDTAX1	CURR	7
EXADDTAX2	Additional Tax2 value		J_1IEXADDTAX2	CURR	7
EXADDTAX3	Additional Tax3 value		J_1IEXADDTAX3	CURR	7
NCCDRATE	NCCD Rate in %		J_1INCCDRAT	DEC	4
ECSRATE	ECS rate in %		J_1IECSRAT	DEC	4
EXADDRATE1	AT1 rate in %		J_1IEXADDRAT1	DEC	4
EXADDRATE2	AT2 rate in %		J_1IEXADDRAT2	DEC	4
EXADDRATE3	AT3 rate in %		J_1IEXADDRAT3	DEC	4
J_1IREGID	Excise Registration		J_1IREGID	NUMC	6
MEINS	Base Unit of Measure		MEINS	UNIT	6
QUARTER	Name of Company Code or Company		BUTXT	CHAR	50
NIL_RETURN	Excise Document Series Group		J_1ISERGRP	CHAR	6