Table EMPLOIDAFR @ L.V. Expertise X3

Table	Abbreviation	Title	Module	Activity code
EMPLOIDAFR	EAF	Additional Africa fields	Common Data	KAQ

Key	Description	Duplicates	Activity code
EAF0	REFNUM	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AFRCNTCDE	Country code	4	CRY			[TCY]TCY0=[EAF]AFRCNTCDE	Block
AFRCOR	Set as default	4	M	4	1
AFRCPX	Complex	4	A	50
AFRPOSCDE	Postal code	4	A	10
AFRPOSNUM	Unit/postal number	4	A	10
AFRPRI	Priority	4	C	1
AFRPRV	State/province	4	SAT
AFRSTA	Active	4	M	4	1
AFRSTRNAM	Street	4	A	50
AFRSTRNUM	Street number	4	A	10
AFRSUB	Suburb/District	4	A	50
AFRTRDAUZ	Traditional authority	4	A	50
AFRTWN	City	4	A	35
AFRTYP	Type	4	M	12	11701
AFRVIG	Village	4	A	50
AUUID	Single identifier		AUUID
BRNCERNUM	Birth certificate no		A	20
BRNDAT	Birth date		D
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[EAF]CREUSR	Other
EMPNUM	Employee		A	10				KMA
EMPTAXNUM	Emp tax number		A	15
EMPTYP	Employee type		M	12	11745			KMA
EMPUID	ID number		A	20
EXOATTNUM	Exempt certificate		A	20
HLTNSS	Health insurance		M	4	1			KMA
MRGDAT	Marriage date		D
NBRAFR	Counter		C	4
PLCBRN	Place of birth		A	30
RDEPITNUM	Residence permit		A	15				KMA
REFNUM	Employee ID		MAT			[ID]ID0=[EAF]REFNUM	Delete
RETDAT	Affiliation number		D					KMA
RETFDSNUM	Retirement fund no.		ADI			[ADI]CODE=11704;RETFDSNUM	Block	KMA
RETNUM	Retirement fund no.		A	10				KMA
SPOMDNNAM	Spouse maiden name		A	20
SSCDAT	Social Security		D					KMA
SSCFDS	Social Security		M	4	1			KMA
SSCSIT	Social Security		ADI			[ADI]CODE=11705;SSCSIT	Block	KMA
TAXLIANUM	Tax		A	10				KMA
TAXRAT	Tax rates		A	15				KMA
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[EAF]UPDUSR	Other