| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | NRDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | NRDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | NRMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | NRPRDC | Product Code | String | UDC (15 PC) | 4 | 0 | Allow NULL? |
| 5 | NRCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | NRYR | Year - Calendar Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 7 | NRRPRD | Sales Report Period | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 8 | NRLIN | Line Number - General | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 9 | NRDTRT | Date Through | Date | Generic Edit | 6 | 0 | |
| 10 | NRDTSR | Date Sales Report Received | Date | Generic Edit | 6 | 0 | |
| 11 | NRICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | NRICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 13 | NRDIC | Date - Batch | Date | Generic Edit | 6 | 0 | |
| 14 | NRANRP | Annual Sales Report | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | NRUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | NRMCUS | Business Unit - Subsequent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 17 | NRAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 18 | NRPSLS | Product Sales Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | NRU | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | NRDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | NRSADJ | Adjustment | Character | UDC | 1 | 0 | Allow NULL? |
| 22 | NRSATY | Adjustment Type | Character | UDC (15 AT) | 1 | 0 | Allow NULL? |
| 23 | NRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | NRUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | NRPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | NRJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | NRDBAN | Doing Business As | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | NRSOSS | Sales Overage - Sales Report Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | NRSOIC | Sales Overage - Sales Invited Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | NRSRTY | Sales Report Type | Character | UDC (15 RT) | 1 | 0 | Allow NULL? |
| 31 | NRSUSA | Units - Sales Usable Area (Sq. Ft.) | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | NRDSLD | Date - Sales Report Due | Date | Generic Edit | 6 | 0 | |
| 33 | NRLTRC | Letter Code | String | UDC (15 LC) | 2 | 0 | Allow NULL? |
| 34 | NRDLTR | Date - Last Letter Date | Date | Generic Edit | 6 | 0 | |
| 35 | NRULI | ULI Code | String | UDC (15 UL) | 8 | 0 | Allow NULL? |
| 36 | NRRM11 | Reporting Code - Property Management 11 | String | UDC (15 11) | 4 | 0 | Allow NULL? |
| 37 | NRRM12 | Reporting Code - Property Management 12 | String | UDC (15 12) | 4 | 0 | Allow NULL? |
| 38 | NRRM13 | Reporting Code - Property Management 13 | String | UDC (15 13) | 4 | 0 | Allow NULL? |
| 39 | NRRM14 | Reporting Code - Property Management 14 | String | UDC (15 14) | 4 | 0 | Allow NULL? |
| 40 | NRRM15 | Reporting Code - Property Management 15 | String | UDC (15 15) | 4 | 0 | Allow NULL? |
| 41 | NRUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |