Unique ID: Estate Code, Stage Code, Project Code, Improvement Code
ERP Table Name: IMPROVEMENTS
|
Field |
Data Type |
ERP |
|
IMPROVEMENT |
IDENTIFIER |
|
|
Estate Code |
NUMERIC |
ESTATE |
|
Stage Code |
NUMERIC |
STAGE |
|
Project Code |
NUMERIC |
PROJECT |
|
Improvement Code |
NUMERIC |
IMPROVEMENT |
|
Name |
DESC_STRING |
NAME |
|
Expected Sale Date |
DATE |
SALE_DUE |
|
Expected Sale Value |
NUMERIC |
SALE_VALUE |
|
Expected Settlement Date |
DATE |
SETT_DUE |
|
Price |
NUMERIC |
In related table JCIMPPRICE |