Table > Module Common Data > Table Detailed expense

Table PJMDE

Table	Abbreviation	Description	Module	Activity code
PJMDE	PJE	Detailed expense	Common Data	PJM

Key	Description	Duplicates	Activity code
PJE0	PDESSS+PDESEQ	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
OBJECT			A	30
OPPNUM	Project number		PIM			[PIM]PIM0=[PJE]OPPNUM	BSRA
PBUCOD	Budget code		PBU
PCCCOD	Cost type		PJCC			[PJCC]PCC0=[PJE]PCCCOD	BSRA
PDEAMT1	Amount		MD1
PDEAMT2			MD1
PDEAMT3			MD1
PDEAMT4			MD1
PDEAMT5			MD1
PDEDAT			D
PDEDES			A	80
PDEFREEC10A			QTY
PDEFREEC10B			MD1
PDEFREEC6A	Quantity		QTY
PDEFREEC6B	Amount		MD1
PDEFREEC7A			QTY
PDEFREEC7B			MD1
PDEFREEC8A			QTY
PDEFREEC8B			MD1
PDEFREEC9A			QTY
PDEFREEC9B			MD1
PDEGRPDAT			D
PDEGRPDES	Group		A	80
PDEGRPNUM	Group		A	30
PDEIMG			DCB	14.2
PDENUM	Number		A	30
PDEORICOD			A	80
PDEORIDES			A	80
PDEQTY1	Quantity		QTY
PDEQTY2			QTY
PDEQTY3			QTY
PDEQTY4			QTY
PDEQTY5			QTY
PDESEQ	Sequence		L	8
PDESSS	Session		L	8
PDETYP	Data type		L	8
PDEU	Unit		UOM			[TUN]TUN0=[PJE]PDEU	BSRA
PDEUQTY1	Quantity		QTY
PDEUQTY2	Quantity		QTY
PDEUQTY3	Quantity		QTY
PDEUQTY4	Quantity		QTY
PDEUQTY5	Quantity		QTY
PDEWQA	Quantity		L	8
PDEWWIPA	WIP		L	8
PIMNUM	Project link		PIM			[PIM]PIM0=[PJE]PIMNUM	BSRA
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5