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 |
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 |
<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.