| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | IASY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 2 | IAMMCU | Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | IADORS | Date or Serial Number | Character | UDC (30 DO) | 1 | 0 | Allow NULL? |
| 4 | IAMAXL | Maximum Levels | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 5 | IALOGB | Log Bill of Material | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | IAPORR | Percents or Rates | Character | UDC (H40 PO) | 1 | 0 | Allow NULL? |
| 7 | IAMWCE | Modify cost by Work Center Efficiency | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | IAIVO | Include Var. Labor Overhead in Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | IACVDL | Calculate Var. on Direct Labor | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | IACVSL | Calculate Var. on Setup Labor | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | IACVDS | Include Work Center Eff. in Overhead | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | IAIFO | Include Fixed Labor Overhead in Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | IACFDL | Calculate Fixed on Direct Labor | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | IACFSL | Calculate Fixed on Setup Labor | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 15 | IACFDS | On-Line BOM Validation (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | IAIVMO | Include Var. Machine Overhead in Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 17 | IAIFMO | Include Fixed Machine Overhead in Cost | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | IABFOP | Backflush Options | Character | UDC (H40 BF) | 1 | 0 | Allow NULL? |
| 19 | IAMRYN | Master Routings | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | IAWRHR | Hours - Work Hours Per Day | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | IAFLD1 | Commitment Control | Character | UDC (H40 FL) | 1 | 0 | Allow NULL? |
| 22 | IAFLD2 | Hard/Soft Commit | Character | UDC (H40 FM) | 1 | 0 | Allow NULL? |
| 23 | IAFLD3 | Log Quality Management Changes | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | IAFLD4 | % Bill Storage | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | IAFLD5 | Future Use 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | IAUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | IAPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | IAUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 29 | IAJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | IAWRH2 | Hours - Work Hours Shift 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | IAWRH3 | Hours - Work Hours Shift 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | IAWRH4 | Hours - Work Hours Shift 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | IAWRH5 | Hours - Work Hours Shift 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | IAWRH6 | Hours - Work Hours Shift 6 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 35 | IASHFT | Shift Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 36 | IASHF2 | Shift 2 Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 37 | IASHF3 | Shift 3 Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 38 | IASHF4 | Shift 4 Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 39 | IASHF5 | Shift 5 Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 40 | IASHF6 | Shift 6 Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 41 | IAPBVD | Percent Bill Validation | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | IASRS1 | Status Code 1 | String | UDC (00 SS) | 2 | 0 | Allow NULL? |
| 43 | IAURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 44 | IAURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 45 | IAURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 46 | IAURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 47 | IAURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 48 | IAMARS | Machine Rate Source | Character | UDC (30 MR) | 1 | 0 | Allow NULL? |
| 49 | IALARS | Labor Rate Source | Character | UDC (30 LR) | 1 | 0 | Allow NULL? |
| 50 | IACWC | Cost by Work Center Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
