Table > Module A/P-A/R accounting > Table Temporary table - Expenses

Table TMPEXPENSE

Table	Abbreviation	Description	Module	Activity code
TMPEXPENSE	EXT	Temporary table - Expenses	A/P-A/R accounting

Key	Description	Duplicates	Activity code
EXT0	CPY+CUR+BPRGTETYP+FCY+SEP+DATEXS	Yes
EXT1	ACCNUM	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACCNUM	Internal number		UNQ
AMTATI	Amount + tax		MD2
AMTCUR	Amount in currency		MD2
AMTPAY	Actual amt.		MD2
AMTTAX1	Tax amount		MD2
AMTTAX2	Tax amount		MD2
AMTVAT	Tax amount		MD2
AUUID	Single identifier		AUUID
BPRGTETYP	Entry type		GTE			[GTE]GTE0=BPRGTETYP;[V]GSUPCLE	Delete
CCE	Analytical dimension		CCE			[CCE]CCE0=DIE(indice);CCE(indice)	Block	ANA
CLB	Employee		AUS			[AUS]CODUSR=[EXT]CLB	Delete
CODEXP	Expense codes		TES			[TES]TES0=[EXT]CODEXP	Delete
CPY	Company		CPY			[CPY]CPY0=[EXT]CPY	Delete
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
CUR	Currency		CUR			[TCU]TCU0=[EXT]CUR	Delete
DATEXS	Date		D
DEDTAX1	Deductible tax		MD2
DEDTAX2	Deductible tax		MD2
DEDVAT	Input VAT		MD2
DES	Comments		A	250
DIE	Analytical dimension type		DIE			[DIE]DIE0=[EXT]DIE	Block	ANA
EXPBPR	Miscellaneous BP		BPR			[BPR]BPR0=[EXT]EXPBPR	Delete
FCY	Site		FCY			[FCY]FCY0=[EXT]FCY	Delete
NBREXS	Line no.		C	2
PJTLIN	Project		PJT			[PIM]PIM0=[EXT]PJTLIN	BSRA	PJM
QTY	Quantity		L	6
RATDAT	Rate date		D
RATDIV	Dividing rate	10	RCU
RATMLT	Multiplying rate	10	RCU
SEP	Separator		A	30
STA	Status		M	15	2806
TAX1	Tax 1		VAT			[TVT]TVT0=TAX1;[V]GSUPCLE	Block
TAX2	Tax 2		VAT			[TVT]TVT0=TAX2;[V]GSUPCLE	Block
TYPRAT	Rate type		M	15	202
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5
VAT	Tax 3		VAT			[TVT]TVT0=VAT;[V]GSUPCLE	Block
VCRNUM	Entry		VCR
VCRTYP	Entry type		GTE			[GTE]GTE0=VCRTYP;[V]GSUPCLE	Block
VISA			AUS			[AUS]CODUSR=[EXT]VISA	Block