Section H - Import Fields Available

Modified on Wed, 22 Dec, 2021 at 9:50 AM

Section H - Interest free and low interest loans

Full Description
Database Field
Data Type
Field Length
Inclusion
Pre-Format

Number of Joint Borrowers

BORROW

Numeric

1

Optional

 

Cash Equivalent 

(Pre-calculated)

CASHEQV

Numeric

10

Optional

COMPLEX Loans Type only

Closing Balance

CLOSING

Numeric

10

Compulsory

 

Description of Loan

DESCRIPTIO

Character

50

Compulsory

 

Available from Date

FROM

Date

8

Compulsory

dd/mm/yyyy

Interest Payable

(Pre-calculated)

INTPAYABLE

Numeric

10

Optional

COMPLEX Loans Type only

Amount Made Good

MADEGOOD

Numeric

10

Optional

 

Maximum Balance

MAXIMUM

Numeric

10

Compulsory

 

N I Number

NI_NUMBER

Character

10

Key field

 

Additional Description

NOTES

Character

50

Optional

 

Opening Balance

OPENING

Numeric

10

Compulsory

 

Payroll Number

PAYROLL

Character

20

Key field

 

Tax payable value 

(Pre-calculated)

TAXTOPAY

Character

3

Optional

COMPLEX Loans Type only

Available to Date

TO

Date

8

Compulsory

dd/mm/yyyy


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article