Table TMPPIN

Table	Abbreviation	Description	Module	Activity code
TMPPIN	TPI	Temporary table	Geode GX

Key	Description	Duplicates	Activity code
TPI0	UID+DEP+DLONUM+QYM2	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[TPI]CREUSR	Other
CRM2	Transportation method		CRM			[CRM]CRM0=[V]GFCY;CRM2	Other
CRR2	Carrier		CRR			[CRR]CRR0=[V]GFCY;CRR2	Other
DAT	Date		D
DEP	Depositor		DEP			[DEP]DEP0=[V]GFCY;DEP	Other
DLONUM	DO number		DLO			[DOH]DOH0=[V]GFCY;DEP;DLONUM	Other
GDR2	Generic round		GDR			[GDR]GDR0=[V]GFCY;GDR2	Other
LMT	Linear meters		QTY
NBLIG	DO/RDV no		C	4
QYM2	Round no.		DRN			[QYM]QYM0=[V]GFCY;2;QYM2	Other
TIM	Time		HM
UID	Identifier		C	4
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[TPI]UPDUSR	Other
VOL	Volume		QTY
WEI	Weight		QTY