Table PINVOICED @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
PINVOICED	PID	Purchase invoice detail	Purchasing

Key	Description	Duplicates	Activity code
PID0	NUM+PIDLIN	No
PID1	TYPORI+NUMORI+LINORI+SEQORI+NUM+PIDLIN	No
PID2	ITMREF+NUM+PIDLIN	No
PID3	BPR+INVTYP+ITMREF+NUM+PIDLIN	No
PID4	POHNUM+POPLIN+POQSEQ	Yes
PJMPJT1	PJT	Yes	PJM

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACCDAT	Accounting date		D
AMTATILIN	Line amount + tax		MD1
AMTDEPLIN	Discount amount		MD1
AMTNOTLIN	Line amount - tax		MD1
AMTNOTLINCAL	Line amount - tax		MD1
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
BPR	BP		BPR			[BPR]BPR0=[PID]BPR	Block
BPSNUM	Supplier		BPR			[BPR]BPR0=[PID]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
CMMNUM	Commitment no.		VCR
CPR	Cost price		DCB	10.8
CPRAMT	Fixed cost per unit		MD5
CPRCOE	Landed cost coef.		COE
CPRCUR	Currency		CUR			[TCU]TCU0=[PID]CPRCUR	Block
CPY	Company		CPY			[CPY]CPY0=[PID]CPY	Block
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
CSTMAJLIN	New cost		M	4	1
CSTPUR	Purchase cost per unit		MD8
DCLEECNUM	VAT declaration no.		EEC					KPO
DDTADEP1	Dist. line inv. elmt. 1		MD1
DDTADEP2	Dist. line inv. elmt. 2		MD1
DDTADEP3	Dist. line inv. elmt. 3		MD1
DDTADEP4	Dist. line inv. elmt. 4		MD1
DDTADEP5	Dist. line inv. elmt. 5		MD1
DDTADEP6	Dist. line inv. elmt. 6		MD1
DDTADEP7	Dist. line inv. elmt. 7		MD1
DDTADEP8	Dist. line inv. elmt. 8		MD1
DDTADEP9	Dist. line inv. elmt. 9		MD1
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
DISBASLIN1	Rebate tax basis 1		MD1
DISCRGAMT1	Discount/Charge 1		MD1
DISCRGAMT2	Discount/Charge 2		MD1
DISCRGAMT3	Discount/Charge 3		MD1
DISCRGAMT4	Discount/Charge 4		MD1
DISCRGAMT5	Discount/Charge 5		MD1
DISCRGAMT6	Discount/Charge 6		MD1
DISCRGAMT7	Discount/Charge 7		MD1
DISCRGAMT8	Discount/Charge 8		MD1
DISCRGAMT9	Discount/Charge 9		MD1
DISCRGREN1	Discount 1 reason		PPR			[PPR]PPR0=[PID]DISCRGREN1	Block	PP1
DISCRGREN2	Discount 2 reason		PPR			[PPR]PPR0=[PID]DISCRGREN2	Block	PP2
DISCRGREN3	Discount 3 reason		PPR			[PPR]PPR0=[PID]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
EECFLOPHY	Physical flow		M	4	1			DEB
ENDDAT	End date		D
FASREF	FA reference		A	30
FCSCOD	Cost		FCS			[FCS]FCS0=[PID]FCSCOD	Block
FCSCPR	Stock cost total		MD1
FCSCSTPUR	Purchase cost total		MD1
FCY	Site		FCY			[FCY]FCY0=[PID]FCY	Block
FCYLIN	Line site		FCY			[FCY]FCY0=[PID]FCYLIN	Block
FLG1099	1099		M	4	1			S1099
GLU	Non-financial unit		UOM			[TUN]TUN0=[PID]GLU	Block
GROPRI	Gross price		MD8
INVLIN	Line		L	8
INVNUM	Invoice number		VCR
INVTYP	Invoice category		M	15	645
ITMDES	Description		DES
ITMDES1	Description		DES
ITMKND	Product type		M	15	2513
ITMREF	Product		ITM			[ITM]ITM0=[PID]ITMREF	Block
LIKQTYCOE	Link qty. coef.		COE
LINAMTCPR	Stock cost		MD8
LINCSTPUR	Purchase cost		MD8
LINEECFLG	Debit line		M	4	1			DEB
LINORI	Source line		L	8
LINPURTYP	Purchase type		M	5	646
LINTEX	Text		TXC
LINTYP	Line type		M	20	570
LINVOU	Volume unit		UOM			[TUN]TUN0=[PID]LINVOU	Block
LINWEU	Weight unit		UOM			[TUN]TUN0=[PID]LINWEU	Block
MATTOL	Matching tolerance		MAT			[MAT]MAT0=[PID]MATTOL	Block
NETCUR	Currency		CUR			[TCU]TCU0=[PID]NETCUR	Block
NETPRI	Net price		MD8
NUM	Document no.		VCR
NUMORI	Source number		VCR
ORINETPRI	Source net price		MD8
ORIQTYPUU	Source quantity		QTY
ORIQTYVOU	Original volume		QTY
ORIQTYWEU	Original weight		QTY
PERNBR	Periodicity		C	4
PERTYP	Periodicity		M	15	635
PIDLIN	Line		L	8
PIHTYP	Purchase invoice cat.		M	20	533
PIVTYP	Usr invoice type		TPV			[TPV]TPV0=PIVTYP;[V]GSUPCLE	Block
PJT	Project		PJT			[PIM]PIM0=[PID]PJT	Block
PNDLIN	Line		L	8
PNHNUM	Return no.		VCR
POHNUM	Order no.		VCR
POPLIN	PO line		L	8
POQSEQ	Sequence number		L	8
PRIREN	Price reason		PPR			[PPR]PPR0=[PID]PRIREN	Block
PRTFLG	Partial invoice		M	4	1
PTDLIN	Line		L	8
PTHNUM	Receipt no.		VCR
PUU	Purchase unit		UOM			[TUN]TUN0=[PID]PUU	Block
QTYBUDLIN	Qty to be decommitted		QTY
QTYGLU	Actual quantity		QTY
QTYPUU	PUR quantity		QTY
QTYSTU	STK quantity		QTY
QTYUOM	Invoiced qty.		QTY
QTYVOU	Volume		QTY
QTYWEU	Weight		QTY
RCPDAT	Receipt date		D
SATISS	Issue region		SAT					PTX
SATRCP	Receipt region		SAT					PTX
SEQORI	Original sequence		L	8
SHIPLIN	Line		L	8
SHIPNUM	Shipment number		VCR
SIDLIN	Sales invoice line		L	8
STCNUM	Cost structure		VCR
STCRFLG	Reconciled		M	4	1
STRDAT	Start date		D
STU	Stock unit		UOM			[TUN]TUN0=[PID]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
TSICOD	Statistical group		ADI			[ADI]CODE=indice+20;TSICOD(indice)	Other	STI
TWMSTA	Match status		M	15	585
TYPORI	Line origin		M	10	511
UOM	Invoicing unit		UOM			[TUN]TUN0=[PID]UOM	Block
UOMPUUCOE	STK-PUR 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