| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | NCNCID | Named Calculation Id | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | NCNCNAME | Named Calculation Name | String | Generic Edit | 30 | 0 | Allow NULL? |
| 3 | NCNCCOLNM | Column Title | String | Generic Edit | 20 | 0 | Allow NULL? |
| 4 | NCWCRTR | Creator ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | NCNCRLTYP | Rule Type | Character | UDC (31B NC) | 1 | 0 | Allow NULL? |
| 6 | NCNCENT | Named Calculation Entity | String | UDC (31B EN) | 10 | 0 | Allow NULL? |
| 7 | NCNCFTOF | Entity Field To Find | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | NCNCFTOF2 | Entity Field To Find 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 9 | NCNCFTOF3 | Entity Field To Find 3 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 10 | NCNCRULE | Named Calculation Rule | String | UDC (31B RR) | 4 | 0 | Allow NULL? |
| 11 | NCNCWHR | Where Field | String | Generic Edit | 10 | 0 | Allow NULL? |
| 12 | NCNCVAL | Value To Evaluate | String | Generic Edit | 30 | 0 | Allow NULL? |
| 13 | NCNCVAL2 | Value To Evaluate 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 14 | NCNCVAL3 | Value To Evaluate 3 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 15 | NCNCTHRES | Named Calculation Threshold | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 16 | NCNCFTOS | Entity Field To Select | String | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | NCNCFTOS2 | Entity Field To Select 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | NCNCFTOS3 | Entity Field To Select 3 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | NCNCFTOR | Entity Field To Return | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | NCNCFTOR2 | Entity Field To Return 2 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | NCNCFTOR3 | Entity Field To Return 3 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | NCNCCC1 | Named Calculation Category Code 1 | String | UDC (31B N7) | 10 | 0 | Allow NULL? |
| 23 | NCNCCC2 | Named Calculation Category Code 2 | String | UDC (31B N8) | 10 | 0 | Allow NULL? |
| 24 | NCNCCC3 | Named Calculation Category Code 3 | String | UDC (31B N9) | 10 | 0 | Allow NULL? |
| 25 | NCNCCUSF | Named Calculation Custom Function | String | Generic Edit | 32 | 0 | Allow NULL? |
| 26 | NCURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | NCURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | NCURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 29 | NCURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 30 | NCURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | NCWAB | Blend Mgmt Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | NCWNUM | Blend Mgmt Numeric | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 33 | NCWCD | Blend Mgmt Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 34 | NCWMDT | Blend Mgmt Date | Date | Generic Edit | 6 | 0 | |
| 35 | NCWRF | Blend Mgmt Reference | String | Generic Edit | 30 | 0 | Allow NULL? |
| 36 | NCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | NCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 38 | NCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 39 | NCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 40 | NCMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 41 | NCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
