| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | GLMCUS | Business Unit - Subsequent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | GLMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | GLRVNB | Revision Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 4 | GLFLOR | Number - Floor | String | UDC (15 FL) | 4 | 0 | Allow NULL? |
| 5 | GLUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | GLCENTYR | Century/Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 7 | GLMT | Calendar Month | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 8 | GLGLOA | Gross Lease Occupied Area | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | GLGOCF | Gross Occupied Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | GLGLAA | Gross Leaseable Area | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | GLGLCF | Gross Leaseable Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | GLDYOC | Days Occupied | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 13 | GLUM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 14 | GLARTY | Area Type | String | UDC (15 AR) | 3 | 0 | Allow NULL? |
| 15 | GLAM01 | EP Unit Type | String | UDC (15 EU) | 3 | 0 | Allow NULL? |
| 16 | GLGLMD | Gross Lease Area Method | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | GLDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 18 | GLURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 19 | GLURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 20 | GLURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | GLURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | GLURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | GLUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | GLPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | GLJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | GLUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | GLUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 28 | GLTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | GLENTJ | Date - Entered | Date | Generic Edit | 6 | 0 | |