Table SUPPORTH

Table	Abbreviation	Description	Module	Activity code
SUPPORTH	SPH	Support	Geode GX	SPM

Key	Description	Duplicates	Activity code
SPR0	FCY+SPRNUM	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ADD	Address		SLO			[SLO]SLO0=FCY;STO;ADD	Block
AUUID	Single identifier		AUUID
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[SPH]CREUSR	Other
ENAFLG	Active		M	4	1
FCY	Site		FCY			[FCY]FCY0=[SPH]FCY	Block
ITM	Product		ITM			[ITM]ITM0=[SPH]ITM	BSRA
LOT	Lot no.		A	20
OWNCPY	Company		CPY			[CPY]CPY0=[SPH]OWNCPY	Block
OWNDVR	Supplier		DVR			[DVR]DVR0=FCY;OWNDVR	Block
OWNFCY	Site		FCY			[FCY]FCY0=[SPH]OWNFCY	Block
SNGITMMGT	Single item		M	4	1
SNGLOTMGT	Single lot		M	4	1
SPRNUM			SPR			[SPH]SPR0=FCY;SPRNUM	Delete
SPROWNTYP			M	15	484
SPRPARENT	Relative		SPR			[SPH]SPR0=FCY;SPRPARENT	Block
SPRPERM	Permanent		M	4	1
SPRSKIND	Undifferentiated stock		M	4	1
SPRSTATUS			M	15	485
SPRT			SPRT			[SPRT]SPRT0=FCY;SPRT	Block
STO	Store		STO			[STO]STO0=FCY;STO	Block
UFTPIC	Undifferentiated picking		M	4	1
UFTSKO	Undifferentiated stock		M	4	1
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[SPH]UPDUSR	Other