Record Type FUND

Unique ID: Option Code, Funding Code

ERP Table Name: FUNDHDR

 

Field

Data Type

ERP

FUND

IDENTIFIER

 

Option Code

NUMERIC

FUND_OPT_ID

Funding Code

NUMERIC

FUND_ID

Name

DESC_STRING

NAME

Limit

NUMERIC

LIMIT

Start Date

DATE

START_DATE

End Date

DATE

END_DATE

Capitalise Interest

BOOLEAN

CAPITALISED_INT

Loan Type

NUMERIC

1 – Develop & Hold
2 – Amoritised
3 – Interest on Outstanding Balance (Bank Funded)
4 – Interest on Outstanding Balance (Equity Funded)
5 – Interest on Total Facility (Bank Funded)
6 – Interest on Total Facility (Equity Funded)
7 – Equity Injection

LOAN_TYPE

Equity

BOOLEAN

EQUITY

Bond Amount

NUMERIC

BOND_AMOUNT

Bond Start Date

DATE

BOND_START

Bond End Date

DATE

BOND_END

Ranking

NUMERIC

RANKING

Repayment Ranking

NUMERIC

REPAY_RANKING

Limit Type

NUMERIC

0 - $ AMOUNT
1 - % of Costs

<Not Used>

% of Cost Percent

NUMERIC

<Not Used>

Interest Transfer Class

NUMERIC

INT_CLASS_CODE

Finance Costs Transfer Class

NUMERIC

FIN_CLASS_CODE

Shutdown Transfer Class

NUMERIC

SHUT_CLASS_CODE

Future Payment

NUMERIC

FUTURE_PAYMENT

Amortised Repayment

NUMERIC

Creates a FUND_REPAY record

 

The import procedure will ask for a bank account for each fund.