Table INVOICEL

Table	Abbreviation	Description	Module	Activity code
INVOICEL	IVL	Preinvoice line	Geode GX

Key	Description	Duplicates	Activity code
IVL0	FCY+DEP+INVNUM+IVLLIN	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
DEP	Depositor		DEP			[DEP]DEP0=FCY;DEP	Block
FCY	Site		FCY			[FCY]FCY0=[IVL]FCY	Block
HISPTR	Archive		L	8
IFHCUR	Currency		CUR			[TCU]TCU0=[IVL]IFHCUR	Block
IHHCOD	Heading		IHH			[IHH]IHH0=IHHCOD	Block
INVNUM	Invoice		INV			[IVH]IVH0=FCY;DEP;INVNUM	Other
IPCCOD	Price list code		A	10
IPHCOD	Price list		A	10
IPLLIN	Line		L	8
ISHCOD	Service provision		A	10
IVLAMT	Amount -tax		MD1
IVLFIXAMT	Fixed amount		MD1
IVLLIN	Line		L	8
IVLPRIAMT	Calculated price		MD1
IVLTEX	Text		A	10
IVLTYP	Line type		M	15	439
IVLUNINBR	Value		DCB	11.4
IVLUNIPRI	Unit price		MD1
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5