| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | HMHBMCUS | Community | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | HMHBLOT | Lot Number | String | Generic Edit | 4 | 0 | Allow NULL? |
| 3 | HMHBMSID | Milestone Id | String | Generic Edit | 4 | 0 | Allow NULL? |
| 4 | HMMSSEQ | Milestone Sequence | String | Generic Edit | 4 | 0 | Allow NULL? |
| 5 | HMDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 6 | HMPASQ | Precedent Activity Sequence | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | HMAN8V | Address Number - Supplier | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | HMHPF | Hold Payment Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | HMMSC | Milestone Status Code | Character | UDC (44H7 MS) | 1 | 0 | Allow NULL? |
| 10 | HMNDAP | Days After Prior Milestone | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 11 | HMPNST | Date - Planned Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 12 | HMOSF | Original Schedule Finish | Date | Generic Edit | 6 | 0 | |
| 13 | HMODWD | Original Duration Work Days | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 14 | HMODCD | Original Duration Calendar Days | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 15 | HMCSHST | Revisded Start Date | Date | Generic Edit | 6 | 0 | |
| 16 | HMCSHF | Current Schedule Finish | Date | Generic Edit | 6 | 0 | |
| 17 | HMRDWD | Revised Duration Work Days | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 18 | HMRDCD | Revised Duration Calendar Days | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 19 | HMASJ | Actual Start Date | Date | Generic Edit | 6 | 0 | |
| 20 | HMATFN | Date - Actual Finish (Julian) | Date | Generic Edit | 6 | 0 | |
| 21 | HMADWD | Actual Duration Work Days | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 22 | HMADCD | Actual Duration Calendar Days | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 23 | HMDRC | Delay Reason Code | String | UDC (44H7 DR) | 10 | 0 | Allow NULL? |
| 24 | HMDDL01 | Delay Reason Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 25 | HMMSNOTE | Milestone Note | String | Generic Edit | 80 | 0 | Allow NULL? |
| 26 | HMSCHTMPT | Schedule Template | String | Generic Edit | 12 | 0 | Allow NULL? |
| 27 | HMAPRV | Address Number - Approved by | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | HMHBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | HMHBST2 | HomeBuilder Status Code 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | HMHBST3 | HomeBuilder Status Code 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | HMHBST4 | HomeBuilder Status Code 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | HMHBST5 | HomeBuilder Status Code 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 33 | HMGS3A | Generic String x 30 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 34 | HMGS3B | Generic String x 30 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 35 | HMGS3C | Generic String x 30 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 36 | HMGS3D | Generic String x 30 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 37 | HMGS3E | Generic String x 30 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 38 | HMCRTU | Created by user | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | HMCRTJ | Date - Created | Date | Generic Edit | 6 | 0 | |
| 40 | HMWRKSTNID | Original Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 41 | HMHBOPID | Original Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 42 | HMUPMB | Updated By - User | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | HMUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 44 | HMUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 45 | HMJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | HMPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |