| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | FRDTAI | Data Item | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | FRCLAS | Data Item Class | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | FRDTAT | Data Item Type | Character | UDC (98 DT) | 1 | 0 | Allow NULL? |
| 4 | FRDTAS | Data Item Size | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | FRDTAD | Data File Decimals | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | FRPDTA | Data Field - Parent | String | Generic Edit | 10 | 0 | Allow NULL? |
| 7 | FRARRN | Number of Array Elements | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 8 | FRDVAL | Value for Entry - Default | String | Generic Edit | 40 | 0 | Allow NULL? |
| 9 | FRLR | Justify - Left or Right | Character | UDC (H98 LR) | 1 | 0 | Allow NULL? |
| 10 | FRCDEC | Display Decimals | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | FRDRUL | Data Display Rules | String | UDC (98 DR) | 6 | 0 | Allow NULL? |
| 12 | FRDRO1 | Data Display Parameters | String | Generic Edit | 40 | 0 | Allow NULL? |
| 13 | FRERUL | Data Edit Rules | String | UDC (98 ER) | 6 | 0 | Allow NULL? |
| 14 | FRERO1 | Edit Rules Specification 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 15 | FRERO2 | Edit Rules Specification 2 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 16 | FRHLP1 | Help Text Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | FRHLP2 | Help List Program | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | FRNNIX | Next Numbering Index Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 19 | FRNSY | System Code - Next Numbers | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 20 | FRRLS | Release Number | String | UDC (98 RL) | 10 | 0 | Allow NULL? |
| 21 | FRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | FRUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 23 | FRPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | FRJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | FRUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 26 | FROWDI | Data Item (EnterpriseOne) | String | Generic Edit | 40 | 0 | Allow NULL? |
| 27 | FROWTP | Data Type - EnterpriseOne | String | UDC (H98 DT) | 2 | 0 | Allow NULL? |
| 28 | FRCNTT | Control Type | Character | UDC | 1 | 0 | Allow NULL? |
| 29 | FRSCFG | Flag - EnterpriseOne Security | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | FRUPER | Upper Case Only | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | FRALBK | Allow Blank Entry | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | FROWER | Data Edit Rules (EnterpriseOne) | String | UDC (H98 ER) | 6 | 0 | Allow NULL? |
| 33 | FROER1 | Edit Rules Specification 1- E1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 34 | FROER2 | Edit Rules Specification 2- E1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 35 | FROWDR | Data Display Rules (EnterpriseOne) | String | UDC (H98 DR) | 6 | 0 | Allow NULL? |
| 36 | FRODR1 | Data Display Rules Spec (EnterpriseOne) | String | Generic Edit | 40 | 0 | Allow NULL? |
| 37 | FRDBID | Display Business Function ID | Identifier (ID) | Generic Edit | 11 | 0 | |
| 38 | FRBFDN | Object Name - Display Business Function | String | Generic Edit | 32 | 0 | Allow NULL? |
| 39 | FREBID | Edit Business Function ID - E1 | Identifier (ID) | Generic Edit | 11 | 0 | |
| 40 | FRBFEN | Object Name - Edit Business Function | String | Generic Edit | 32 | 0 | Allow NULL? |
| 41 | FRSFID | Search Form ID - EnterpriseOne | Identifier (ID) | Generic Edit | 11 | 0 | |
| 42 | FRSFMN | Object Name - Search Form | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | FRBVID | Business View ID - EnterpriseOne | Identifier (ID) | Generic Edit | 11 | 0 | |
| 44 | FRBVNM | Object Name - Business View | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | FRPLFG | Platform Flag (EnterpriseOne/AS400) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | FRDDID | Data Dictionary Identifier - E1 | Identifier (ID) | Generic Edit | 11 | 0 | |
| 47 | FRAUIN | Auto Include Flag (Y/N) | Character | Check Box | 1 | 0 | Allow NULL? |