Table > Module A/P-A/R accounting > Table Expense

Table EXPENSES

Table	Abbreviation	Description	Module	Activity code
EXPENSES	EXS	Expense	A/P-A/R accounting

Key	Description	Duplicates	Activity code
EXS0	CLB+DATEXS+NBREXS	No
EXS1	ACCNUM	No
EXS2	CPY+CUR+FCY+DATEXS	Yes
EXS3	VCRTYP+VCRNUM+ACCNUM	No
EXS4	PJTLIN	Yes	PJM

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACC	Account	10	GAC			[GAC]GAC0=COA;ACC	Delete
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
CCE	Analytical dimension		CCE			[CCE]CCE0=DIE(indice);CCE(indice)	Block	ANA
CLB	Employee		AUS			[AUS]CODUSR=[EXS]CLB	Delete
COA	Chart code	10	COA			[COA]COA0=[EXS]COA	Delete
CODEXP	Expense codes		TES			[TES]TES0=[EXS]CODEXP	Block
CPY	Company		CPY			[CPY]CPY0=[EXS]CPY	Delete
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
CUR	Currency		CUR			[TCU]TCU0=[EXS]CUR	Block
CURLED	Ledger currency	10	CUR			[TCU]TCU0=[EXS]CURLED	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=[EXS]DIE	Block	ANA
FCY	Site		FCY			[FCY]FCY0=[EXS]FCY	Delete
LED	Ledger	10	LED			[LED]LED0=[EXS]LED	Delete
NBREXS	Line no.		C	2
PJTLIN	Project		PJT			[PIM]PIM0=[EXS]PJTLIN	Block	PJM
QTY	Quantity		L	6
RATDAT	Rate date		D
RATDIV	Dividing rate	10	RCU
RATMLT	Multiplying rate	10	RCU
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=[EXS]VISA	Block