| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | LDUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | LDLONG | Longitude | String | Generic Edit | 25 | 0 | Allow NULL? |
| 3 | LDLATT | Latitude | String | Generic Edit | 25 | 0 | Allow NULL? |
| 4 | LDLEVAT | Equipment Location Elevation | String | Generic Edit | 25 | 0 | Allow NULL? |
| 5 | LDBUILD | Equipment Location Building | String | Generic Edit | 25 | 0 | Allow NULL? |
| 6 | LDFLOOR | Equipment Location Floor | String | Generic Edit | 25 | 0 | Allow NULL? |
| 7 | LDROOM1 | Equipment Location Room | String | Generic Edit | 25 | 0 | Allow NULL? |
| 8 | LDOTHR1 | Equipment Location Other 1 | String | Generic Edit | 25 | 0 | Allow NULL? |
| 9 | LDOTHR2 | Equipment Location Other 2 | String | Generic Edit | 25 | 0 | Allow NULL? |
| 10 | LDWHO | Contact Name | String | Generic Edit | 120 | 0 | Allow NULL? |
| 11 | LDCPHC1 | Case From Phone Contact 1 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 12 | LDMLNM | Name - Mailing | String | Generic Edit | 40 | 0 | Allow NULL? |
| 13 | LDADD1 | Address Line 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 14 | LDADD2 | Address Line 2 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 15 | LDADD3 | Address Line 3 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 16 | LDADD4 | Address Line 4 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 17 | LDCTY1 | City | String | Generic Edit | 25 | 0 | Allow NULL? |
| 18 | LDCOUN | County | String | UDC (00 CT) | 25 | 0 | Allow NULL? |
| 19 | LDADDS | State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 20 | LDADDZ | Postal Code | String | Generic Edit | 12 | 0 | Allow NULL? |
| 21 | LDCTR | Country | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 22 | LDCRTU | Created by user | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | LDCADT | Creation Date | Date | Generic Edit | 6 | 0 | |
| 24 | LDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | LDUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | LDJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | LDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | LDUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |