| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | NCMCUS | Business Unit - Subsequent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | NCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | NCFLOR | Number - Floor | String | UDC (15 FL) | 4 | 0 | Allow NULL? |
| 4 | NCUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | NCCENTYR | Century/Year | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 6 | NCMT | Calendar Month | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 7 | NCGLOA | Gross Lease Occupied Area | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | NCGOCF | Gross Occupied Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | NCGLAA | Gross Leaseable Area | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 10 | NCGLCF | Gross Leaseable Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | NCDYOC | Days Occupied | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 12 | NCUM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 13 | NCARTY | Area Type | String | UDC (15 AR) | 3 | 0 | Allow NULL? |
| 14 | NCAM01 | EP Unit Type | String | UDC (15 EU) | 3 | 0 | Allow NULL? |
| 15 | NCGLMD | Area Calculation Method | Character | UDC (15 OM) | 1 | 0 | Allow NULL? |
| 16 | NCDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | NCURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 18 | NCURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 19 | NCURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | NCURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 21 | NCURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | NCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | NCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | NCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | NCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | NCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 27 | NCARDEFID | Area Definition ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | NCGLOAU | Gross Lease Occupied Area Unadjusted | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | NCGLAAU | Gross Leaseable Area Unadjusted | Numeric | Generic Edit | 15 | 2 | Allow NULL? |