Table PRETURND @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
PRETURND	PND	Detail return	Purchasing

Key	Description	Duplicates	Activity code
PND0	PNHNUM+PNDLIN	No
PND1	PTHNUM+PTDLIN	Yes
PND2	LININVFLG+BPSINV+ITMREF+PNHNUM+PNDLIN	No
PND3	POHNUM+POPLIN+POQSEQ	Yes
PJMPJT1	PJT	Yes	PJM

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AMTTAXISS	Issue tax amount		MD1					PTX
AMTTAXLIN1	Tax amount 1		MD1
AMTTAXLIN2	Tax amount 2		MD1
AMTTAXLIN3	Tax amount 3		MD1
AMTTAXOTH1	Amount other tax 1		MD1					PTX
AMTTAXOTH2	Amount other tax 2		MD1					PTX
AMTTAXRCP	Receipt tax amount		MD1					PTX
AUUID	Single identifier		AUUID
BASTAXLIN1	Tax basis 1		MD1
BPAINV	Billing address		ADR
BPOCRY	Shipping country		CRY			[TCY]TCY0=[PND]BPOCRY	Block
BPSINV	Bill-by BP		BPR			[BPR]BPR0=[PND]BPSINV	Block
BPSNDE	Supplier packing slip no.		A	20
BPSNUM	Supplier		BPR			[BPR]BPR0=[PND]BPSNUM	Block
CLCAMT1	Tax calculation basis 1		MD1
CLCAMT2	Tax calculation basis 2		MD1
CLCAMT3	Tax calculation basis 3		MD1
CLCAMT4	Tax calculation basis 4		MD1					PTX
CLCAMT5	Tax calculation basis 5		MD1					PTX
CLCAMT6	Tax calculation basis 6		MD1					PTX
CLCAMT7	Tax calculation basis 7		MD1					PTX
CPR	Cost price		MD8
CPRCOE	Landed cost coef.		COE
CPRCUR	Currency		CUR			[TCU]TCU0=[PND]CPRCUR	Block
CPY	Company		CPY			[CPY]CPY0=[PND]CPY	Block
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
DEDTAXISS	Deductible tax		MD1					PTX
DEDTAXLIN1	Deductible tax 1		MD1
DEDTAXLIN2	Deductible tax 2		MD1
DEDTAXLIN3	Deductible tax 3		MD1
DEDTAXOTH1	Deductible tax		MD1					PTX
DEDTAXOTH2	Deductible tax		MD1					PTX
DEDTAXRCP	Deductible tax		MD1					PTX
DISCRGREN1	Discount 1 reason		PPR			[PPR]PPR0=[PND]DISCRGREN1	Block	PP1
DISCRGREN2	Discount 2 reason		PPR			[PPR]PPR0=[PND]DISCRGREN2	Block	PP2
DISCRGREN3	Discount 3 reason		PPR			[PPR]PPR0=[PND]DISCRGREN3	Block	PP3
DISCRGREN4	Discount 4 reason		C	4				PP4
DISCRGREN5	Discount 5 reason		C	4				PP5
DISCRGREN6	Discount 6 reason		C	4				PP6
DISCRGREN7	Discount 7 reason		C	4				PP7
DISCRGREN8	Discount 8 reason		C	4				PP8
DISCRGREN9	Discount 9 reason		C	4				PP9
DISCRGVAL1	Discount/Charge 1		MD8					PP1
DISCRGVAL2	Discount/Charge 2		MD8					PP2
DISCRGVAL3	Discount/Charge 3		MD8					PP3
DISCRGVAL4	Discount/Charge 4		DCB	19.8				PP4
DISCRGVAL5	Discount/Charge 5		DCB	19.8				PP5
DISCRGVAL6	Discount/Charge 6		DCB	19.8				PP6
DISCRGVAL7	Discount/Charge 7		DCB	19.8				PP7
DISCRGVAL8	Discount/Charge 8		DCB	19.8				PP8
DISCRGVAL9	Discount/Charge 9		DCB	19.8				PP9
EECINCRAT	Intrastat increase		RAT					DEB
GROPRI	Gross price		MD8
INVQTYPUU	Invoiced PUR		QTY
INVQTYSTU	Invoiced STU		QTY
ITMDES	Description		DES
ITMDES1	Description		DES
ITMKND	Product type		M	15	2513
ITMREF	Product		ITM			[ITM]ITM0=[PND]ITMREF	Block
LIKQTYCOE	Link qty. coef.		COE
LINAMT	Line amount - tax		MD1
LINATIAMT	Line amount + tax		MD1
LINAUTFLG	Automatic flow		M	4	1
LINCAT	Movement category		M	15	574
LINEECFLG	Debit line		M	4	1			DEB
LININVFLG	Invoiced line		M	4	1
LINPRNFLG	Line printed		M	4	1
LINPSTDAT	Reversal date		D
LINPSTFLG	Posted line		M	4	1
LINPURTYP	Purchase type		M	5	646
LINSTOFCY	Shipment site		FCY			[FCY]FCY0=[PND]LINSTOFCY	Block
LINTEX	Text		TXC
LINTYP	Line type		M	20	570
NETCUR	Currency		CUR			[TCU]TCU0=[PND]NETCUR	Block
NETPRI	Net price		MD8
NETPRIPUU	Net price PUR		MD8
ORDFLG	Reinstatement		M	15	540
ORICRY	Destination country		CRY			[TCY]TCY0=[PND]ORICRY	Block
PJT	Project		PJT			[PIM]PIM0=[PND]PJT	Block
PNDLIN	Line		L	8
PNHFCY	Return site		FCY			[FCY]FCY0=[PND]PNHFCY	Block
PNHNUM	Return no.		VCR
POHFCY	Order site		FCY			[FCY]FCY0=[PND]POHFCY	Block
POHNUM	Order no.		VCR
POHTYP	Order type		M	20	506
POPLIN	Line		L	8
POQSEQ	PO sequence no.		L	8
PRIREN	Price reason		PPR			[PPR]PPR0=[PND]PRIREN	Block
PTDLIN	Line		L	8
PTHNUM	Receipt no.		VCR
PUU	Purchase unit		UOM			[TUN]TUN0=[PND]PUU	Block
QTYPUU	PUR quantity		QTY
QTYSTU	STK quantity		QTY
QTYUOM	Quantity		QTY
RTNDAT	Return date		D
RTNDES	Reason description		DES
RTNREN	Return reason		SHO
SATISS	Issue region		SAT					PTX
SRDLIN	Sales return line		L	8
SRDQTYSTU	Sale return qty STK		QTY
SRHNUM	Sales return no.		VCR
STOMGTCOD	Stock management		M	15	215
STU	Stock unit		UOM			[TUN]TUN0=[PND]STU	Block
TAXISS	Issue tax		VAT			[TVT]TVT0=TAXISS;[V]GSUPCLE	Block	PTX
TAXOTH1	Other tax 1		VAT			[TVT]TVT0=TAXOTH1;[V]GSUPCLE	Block	PTX
TAXOTH2	Other tax 2		VAT			[TVT]TVT0=TAXOTH2;[V]GSUPCLE	Block	PTX
TAXRCP	Receipt tax		VAT			[TVT]TVT0=TAXRCP;[V]GSUPCLE	Block	PTX
TRSFAM	Transaction group		ADI			[ADI]CODE=9;TRSFAM	RTZ
TSICOD	Statistical group		ADI			[ADI]CODE=indice+20;TSICOD(indice)	Other	STI
UNTWEI	Unit weight		WEI
UOM	Return unit		UOM			[TUN]TUN0=[PND]UOM	Block
UOMFLG	Return PAC		M	4	1
UOMPUUCOE	STK-PUR conversion		COE
UOMSTUCOE	STK conversion		COE
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5
VAT	Tax	3	VAT			[TVT]TVT0=VAT(indice);[V]GSUPCLE	Block
WEU	Weight unit		UOM			[TUN]TUN0=[PND]WEU	Block
WRH	Warehouse		WRH			[WRH]WRH0=WRH	Other	WRH