| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | GPDATP | Data Source | String | Generic Edit | 30 | 0 | Allow NULL? |
| 2 | GPDBTBLNM | Table Name | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | GPDBROLE | Database Role | String | Generic Edit | 150 | 0 | Allow NULL? |
| 4 | GPDBPRVLGE | Allow Set Database Security | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 5 | GPDBROLETYP | Database Role Type | Character | UDC (H95 DP) | 1 | 0 | Allow NULL? |
| 6 | GPDBALLPRV | Database All Privilege | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 7 | GPDBEXEC | Database Allow Execute | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 8 | GPDBALTER | Database Allow Alter | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 9 | GPDBDROP | Database Allow Drop | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 10 | GPDBCREATE | Database Allow Create | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 11 | GPDBNDXATR | Database Allow Alter Index | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 12 | GPDBNDXDRP | Database Allow Drop Index | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 13 | GPDBNDXCRT | Database Allow Create Index | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 14 | GPDBSELECT | Database Allow Select | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 15 | GPDBINSERT | Database Allow Insert | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 16 | GPDBDELETE | Database Allow Delete | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 17 | GPDBUPDATE | Database Allow Update | Character | UDC (H95 EN) | 1 | 0 | Allow NULL? |
| 18 | GPDBPRVLG1 | Database Future Privilege Flags | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | GPDBPRVLG2 | Database Future Privilege Flags | String | Generic Edit | 30 | 0 | Allow NULL? |
| 20 | GPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | GPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | GPDBUPTIME | Updated Date Time | JDE UTime | Generic Edit | 11 | 0 | |
| 23 | GPDBFUCHR1 | Database Future Character | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | GPDBFUCHR2 | Database Future Character | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | GPDBFUCHR3 | Database Future Character | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | GPDBFUSTR1 | Database Future String | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | GPDBFUSTR2 | Database Future String | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | GPDBFUSTR3 | Database Future String | String | Generic Edit | 30 | 0 | Allow NULL? |
| 29 | GPDBFUSTR4 | Database Future String | String | Generic Edit | 30 | 0 | Allow NULL? |
| 30 | GPDBFUMTH1 | Database Future Math | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | GPDBFUMTH2 | Database Future Math | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 32 | GPDBFUMTH3 | Database Future Math | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 33 | GPDBFUDTE1 | Database Future Date | Date | Generic Edit | 6 | 0 | |
| 34 | GPDBFUDTE2 | Database Future Date | Date | Generic Edit | 6 | 0 | |