| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | NPDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | NPDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | NPPRDC | Product Code | String | UDC (15 PC) | 4 | 0 | Allow NULL? |
| 4 | NPSET | Set Grouping | String | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | NPBKPT | Dollar Breakpoint | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 6 | NPEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 7 | NPEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 8 | NPMCUS | Business Unit - Subsequent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 9 | NPCMPM | Computation Method | Character | UDC (15 CO) | 1 | 0 | Allow NULL? |
| 10 | NPPDUE | Percentage Due on Sales | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | NPSBJR | Subject to Minimum Rent | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | NPGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 13 | NPMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 14 | NPUNIT | Unit | String | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | NPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | NPUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 17 | NPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | NPJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | NPLRYF | Year - Lease/Rent Year (From) | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 20 | NPLRYT | Year - Lease/Rent Year (To) | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 21 | NPYT | Year Type | Character | UDC (15 YT) | 1 | 0 | Allow NULL? |
| 22 | NPPRRO | Prorate Overage | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | NPULI | ULI Code | String | UDC (15 UL) | 8 | 0 | Allow NULL? |
| 24 | NPSUSA | Units - Sales Usable Area (Sq. Ft.) | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | NPBCI | Billing Control ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | NPYEOV | Year End Override Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | NPDBAN | Doing Business As | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | NPDEAL | Deal Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | NPSOPC | Sales Overage - Process Code | Character | UDC (15 SO) | 1 | 0 | Allow NULL? |
| 30 | NPRM13 | Reporting Code - Property Management 13 | String | UDC (15 13) | 4 | 0 | Allow NULL? |
| 31 | NPRM14 | Reporting Code - Property Management 14 | String | UDC (15 14) | 4 | 0 | Allow NULL? |
| 32 | NPRM15 | Reporting Code - Property Management 15 | String | UDC (15 15) | 4 | 0 | Allow NULL? |
| 33 | NPSRLS | Sales Reporting Lease | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | NPSUSP | Suspend Code | Character | UDC (15 SU) | 1 | 0 | Allow NULL? |
| 35 | NPSUDT | Date - Suspended | Date | Generic Edit | 6 | 0 | |
| 36 | NPUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
