Database Table "hyp_Projects"
Table Description
The projects table of HyperNormal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Project Number | Integer | 0 | Edit | Read Only Key Field |
ProjectNumber | |
| Project Name | String | 100 | Edit | Mandatory | ProjectName | |
| Use Currency by Default | String | 5 | Select | Mandatory | UseCurrencyByDefault | |
| Linked to Catalogic Number | String | 30 | PopupList | LinkedToCatalogicNumber | ||
| Authorized Groups | String | 500 | PopupList | AuthorizedGroups | ||
| Authorized Users | String | 500 | PopupList | AuthorizedUsers | ||
| Hide on Search | Bool | 0 | Select | HideOnSearch | ||
| Created On | FixDT | 0 | Edit | Read Only | CreatedOn | |
| Created By | String | 40 | Edit | Read Only | CreatedBy | |
| Locked Name & ID | Bool | 0 | Edit | Hidden Read Only |
LockedNameId | |
| Software Module | String | 10 | Edit | Hidden Read Only |
SoftwareModule | |
| Export Account to 3rd party | Integer | 0 | Edit | ExportAccountTo3rdParty | ||
| Docs & Forms Language | Status | 0 | Select | DocsFormsLanguage | ||
| Mandatory Documents | Values List: 0 = Not Tested Yet1 = Empty 2 = Missing 3 = OK |
Status | 0 | Select | MandatoryDocuments | |
| Review Status | Values List: 0 = No Need1 = Waiting 2 = Confirmed 3 = Denied / Wrong |
Status | 0 | Select | ReviewStatus | |
| Street Address | String | 80 | PopupEdit | StreetAddress | ||
| City | String | 40 | PopupEdit | City | ||
| Region | String | 40 | PopupEdit | Region | ||
| Country | String | 40 | Select | Country | ||
| Zip Code | String | 15 | Edit | ZipCode | ||
| Project Gross Value | Integer | 0 | Edit | ProjectGrossValue | ||
| Project Cost | Integer | 0 | Edit | ProjectCost | ||
| % LTV | Real | 0 | Edit | Read Only | Ltv | |
| % LTC | Real | 0 | Edit | Read Only | Ltc | |
| Project Funding Amount | Integer | 0 | Edit | ProjectFundingAmount | ||
| Price Index Linkage | String | 50 | Select | PriceIndexLinkage | ||
| PIL From Date | Date | 0 | SelectEdit | PilFromDate | ||
| PIL Begin Rate | Real | 0 | Edit | Read Only | PilBeginRate | |
| Agency | Status | 0 | Select | Agency | ||
| Sales Agent | String | 40 | PopupList | SalesAgent | ||
| Internal Notes | String | 500 | TextMemo | InternalNotes | ||
| Commission to Middleman | String | 120 | PopupList | CommissionToMiddleman | ||
| Middleman Account Number | Integer | 0 | Edit | Read Only | MiddlemanAccountNumber | |
| Link to Client Number | Integer | 0 | Edit | Read Only | LinkToClientNumber | |
| Link to Client Name | String | 105 | PopupList | LinkToClientName | ||
| Link to Supplier Number | Integer | 0 | Edit | Read Only | LinkToSupplierNumber | |
| Link to Supplier Name | String | 105 | PopupList | LinkToSupplierName | ||
| GIS Latitude | Real | 0 | Edit | Read Only | GisLatitude | |
| GIS Longitude | Real | 0 | Edit | Read Only | GisLongitude |