| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SHMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | SHRVNB | Revision Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | SHSOID | Sales Overage ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 4 | SHDESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | SHSGPN | Sales Growth Pattern | String | Generic Edit | 10 | 0 | Allow NULL? |
| 6 | SHSGOV | Natural Break Point | Character | UDC (00 AA) | 1 | 0 | Allow NULL? |
| 7 | SHMBCD | Market Rate Bill Code | String | Generic Edit | 4 | 0 | Allow NULL? |
| 8 | SHCMTB | Date - Beginning Commitment | Date | Generic Edit | 6 | 0 | |
| 9 | SHCMTE | Date - Ending Commitment | Date | Generic Edit | 6 | 0 | |
| 10 | SHCMPM | Computation Method | Character | UDC (15 CO) | 1 | 0 | Allow NULL? |
| 11 | SHRL01 | Reporting Code - Unit Master 01 | String | UDC (15 U1) | 3 | 0 | Allow NULL? |
| 12 | SHRL02 | Reporting Code - Unit Master 02 | String | UDC (15 U2) | 3 | 0 | Allow NULL? |
| 13 | SHRL03 | Reporting Code - Unit Master 03 | String | UDC (15 U3) | 3 | 0 | Allow NULL? |
| 14 | SHRL04 | Reporting Code - Unit Master 04 | String | UDC (15 U4) | 3 | 0 | Allow NULL? |
| 15 | SHRL05 | Reporting Code - Unit Master 05 | String | UDC (15 U5) | 3 | 0 | Allow NULL? |
| 16 | SHURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 17 | SHURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 18 | SHURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | SHURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 20 | SHURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | SHUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | SHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | SHUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 24 | SHUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 25 | SHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | SHTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | SHENTJ | Date - Entered | Date | Generic Edit | 6 | 0 | |
