Dictionary > Module Common Data > Table Loan details

Table HRLDETAILS

Table	Abbreviation	Title	Module	Activity code
HRLDETAILS	HRLDET	Loan details	Common Data	LOA

Key	Description	Duplicates	Activity code
HRLDET0	LOACOD	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ADMCST	Administration cost		M	30	10651
ADMVAL	Value		HRLDM
AGE	Age		C	3
AUUID	Single identifier		AUUID
CAP	Capital		HRLDM					LOA
CPY	Company		CPY			[CPY]CPY0=[HRLDET]CPY	Delete
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[HRLDET]CREUSR	Other
DATANC	Seniority date		D
DATBRN	Birth date		D
DBTRAT	Debt rate		HRLDM					LOA
FCY	Site		FCY			[FCY]FCY0=[HRLDET]FCY	Delete
FIXADMVAL	Fixed rate		HRLDM					LOA
FIXCST	Fixed cost		M	4	1
FIXINIVAL	Fixed rate		HRLDM					LOA
FIXITT	Fixed interest		M	4	1
FIXNSSRAT	Fixed rate		DCB	3.2
FIXRATVAL	Fixed rate		DCB	3.2
HEARNK	Variable range		C	4
INICST	Initiation cost		M	30	10651
INIVAL	Value		HRLDM
ITTRAT	Interest rate		DCB	3.2
ITTTYP	Interest type		M	15	10652
LOACOD	Loan code		HRLLA			[HRLHEA]HRLHEA0=[HRLDET]LOACOD	Delete
LOAREN	Loan reason		A	250
LOASET	Loan setting		HRLLS			[HRLSET]HRLSET0=[HRLDET]LOASET	Delete
LOAVARADDPAY	Additional payments		A	7
LOAVARADM	Administration cost		A	7
LOAVARCAP	Capital		A	7
LOAVARINI	Initiation cost		A	7
LOAVARITT	Interest		A	7
LOAVARNSS	Insurance		A	7
LOAVARVAT	VAT		A	7
MATAMT	Maturity amount		HRLDM					LOA
MATDAT	Maturity date		D
MTHINS	Monthly installment		HRLDM
NATCON	Nature of contract		ADI			[ADI]CODE=354;NATCON	Delete
NBRPER	Duration (number)		C	4
NSSCLCBAS	Insurance calculation base		M	15	10654
NSSRAT	Insurance rate		DCB	3.2
POT	Position		POT			[POT]POT0=POT	Delete
RTAINS	Retain installment		M	4	1
SNR	Seniority		C	3
SRV	Department		SRV			[SRV]SRV0=SRV	Delete
STRDAT	Start date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[HRLDET]UPDUSR	Other
VAT	VAT		DCB	3.2
VLYDAT	Validation date		D