| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | NBDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | NBLSET | Lease Type | String | UDC (15 LT) | 2 | 0 | Allow NULL? |
| 3 | NBMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | NBSTYL | Business Unit Type | String | UDC (00 MC) | 2 | 0 | Allow NULL? |
| 5 | NBUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | NBUTTY | Unit Type | String | UDC (15 UT) | 5 | 0 | Allow NULL? |
| 7 | NBLGCL | Property Log Class | String | UDC (15 LG) | 2 | 0 | Allow NULL? |
| 8 | NBLGNO | Log Number | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 9 | NBDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 10 | NBEXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | NBSTSC | Log Status Code | Character | UDC (H00 SX) | 1 | 0 | Allow NULL? |
| 12 | NBEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 13 | NBEXPR | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 14 | NBTKDT | Tickle Date | Date | Generic Edit | 6 | 0 | |
| 15 | NBEPCD | Expense Participation Code | String | UDC (15 EP) | 2 | 0 | Allow NULL? |
| 16 | NBAMID | Amenity Identification | String | UDC (15 AM) | 4 | 0 | Allow NULL? |
| 17 | NBPMU1 | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | NBUM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 19 | NBRO01 | Reporting Code - PM Log 01 | String | UDC (15 L1) | 3 | 0 | Allow NULL? |
| 20 | NBRO02 | Reporting Code - PM Log 02 | String | UDC (15 L2) | 3 | 0 | Allow NULL? |
| 21 | NBRQ | Required Standards | Character | UDC | 1 | 0 | Allow NULL? |
| 22 | NBJOB# | Job Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 23 | NBSUSC | Suspense Update Code (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | NBUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | NBUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | NBPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | NBJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | NBAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 29 | NBANP | Address Number - Assigned To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | NBFLOR | Number - Floor | String | UDC (15 FL) | 4 | 0 | Allow NULL? |
| 31 | NBFOTY | Floor Type | String | UDC (15 FT) | 5 | 0 | Allow NULL? |
| 32 | NBARGC | Area Grouping Code | String | UDC (15 GC) | 4 | 0 | Allow NULL? |
| 33 | NBARGV | Area Grouping Value | String | Generic Edit | 5 | 0 | Allow NULL? |
| 34 | NBUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |