| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SGKVER | Summary Code | String | UDC (40 KV) | 3 | 0 | Allow NULL? |
| 2 | SGTYPF | Forecast Type | String | UDC (34 DF) | 2 | 0 | Allow NULL? |
| 3 | SGKV01 | Key Value - Category Codes 01 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 4 | SGKV02 | Key Value - Category Codes 02 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 5 | SGKV03 | Key Value - Category Codes 03 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 6 | SGKV04 | Key Value - Category Codes 04 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 7 | SGKV05 | Key Value - Category Codes 05 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 8 | SGKV06 | Key Value - Category Codes 06 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 9 | SGKV07 | Key Value - Category Codes 07 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 10 | SGKV08 | Key Value - Category Codes 08 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 11 | SGKV09 | Key Value - Category Codes 09 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 12 | SGKV10 | Key Value - Category Codes 10 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 13 | SGCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 14 | SGITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | SGAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 16 | SGDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 17 | SGUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | SGAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | SGFAM | Amount - Forecast | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | SGFQT | Quantity - Forecast | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | SGSFKY | Summary Forecast Key - Parent Level | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 22 | SGSFKE | Summary Forecast Key - Component Level | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 23 | SGBPFC | Bypass Forcing Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | SGRVIS | Revised Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | SGUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 26 | SGUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | SGJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | SGPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 29 | SGTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
