| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | ACALRTSL | Alert Serial Number | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 2 | ACSRMALERT | SRM Alert Identifier | Integer | Generic Edit | 11 | 0 | Allow NULL? |
| 3 | ACALERTDES | Alert Name | String | Generic Edit | 150 | 0 | Allow NULL? |
| 4 | ACUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 5 | ACVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 6 | ACALRTLBL | Alert Name | String | Generic Edit | 150 | 0 | Allow NULL? |
| 7 | ACALUGRL | User Role | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | ACALPARLS | Alert Parameter Line Status | String | Generic Edit | 500 | 0 | Allow NULL? |
| 9 | ACALPARRS | Alert Parameter Route Status | String | Generic Edit | 500 | 0 | Allow NULL? |
| 10 | ACAOSC | Acknowledge Status | String | UDC (40 AT) | 3 | 0 | Allow NULL? |
| 11 | ACALPARDT | Alert Parameter Document Type | String | Generic Edit | 500 | 0 | Allow NULL? |
| 12 | ACOPRC | Code - Operation | String | UDC (43 OC) | 4 | 0 | Allow NULL? |
| 13 | ACALDMCP | Alert Demand Capacity Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | ACAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | ACPOISD | PO Inquiry Search Date Type | String | UDC (43S ID) | 2 | 0 | Allow NULL? |
| 16 | ACSTRT | Date - Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 17 | ACGENQJ | Date-Generated | Date | Generic Edit | 6 | 0 | |
| 18 | ACJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | ACUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 20 | ACUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 21 | ACALCFGS1 | Configured String - Future Use 1 | String | Generic Edit | 500 | 0 | Allow NULL? |
| 22 | ACALCFGS2 | Configured String - Future Use 2 | String | Generic Edit | 500 | 0 | Allow NULL? |
| 23 | ACALCFGS3 | Configured String - Future Use 3 | String | Generic Edit | 500 | 0 | Allow NULL? |
| 24 | ACALRTDJ1 | Alert Parm Date1 - Future Use | Date | Generic Edit | 6 | 0 | |
| 25 | ACALRTDJ2 | Alert Parm Date2 - Future Use | Date | Generic Edit | 6 | 0 | |