AEX10130 - Archive_HR_Employee_Extra
Dynamics GP table AEX10130 (Archive_HR_Employee_Extra) contains 29 columns including EMPID_I, DATE1_I, DATE2_I....
SQL Query Builder
29 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EMPID_I | Emp ID | String | 16 | |
| DATE1_I | Date1 | Date | 4 | |
| DATE2_I | Date2 | Date | 4 | |
| DATE3_I | Date3 | Date | 4 | |
| DATE4_I | Date4 | Date | 4 | |
| DATE5_I | Date5 | Date | 4 | |
| STRINGS_I_1 | Strings[1] | String | 32 | |
| STRINGS_I_2 | Strings[2] | String | 32 | |
| STRINGS_I_3 | Strings[3] | String | 32 | |
| STRINGS_I_4 | Strings[4] | String | 32 | |
| STRINGS_I_5 | Strings[5] | String | 32 | |
| NUMERICEXTRA_1 | NumericExtra[1] | Long Integer | 4 | |
| NUMERICEXTRA_2 | NumericExtra[2] | Long Integer | 4 | |
| NUMERICEXTRA_3 | NumericExtra[3] | Long Integer | 4 | |
| NUMERICEXTRA_4 | NumericExtra[4] | Long Integer | 4 | |
| NUMERICEXTRA_5 | NumericExtra[5] | Long Integer | 4 | |
| DOLLARS_I_1 | Dollars[1] | Currency | 10 | |
| DOLLARS_I_2 | Dollars[2] | Currency | 10 | |
| DOLLARS_I_3 | Dollars[3] | Currency | 10 | |
| DOLLARS_I_4 | Dollars[4] | Currency | 10 | |
| DOLLARS_I_5 | Dollars[5] | Currency | 10 | |
| CHECKBOXES_I_1 | Checkboxes[1] | Boolean | 2 | |
| CHECKBOXES_I_2 | Checkboxes[2] | Boolean | 2 | |
| CHECKBOXES_I_3 | Checkboxes[3] | Boolean | 2 | |
| CHECKBOXES_I_4 | Checkboxes[4] | Boolean | 2 | |
| CHECKBOXES_I_5 | Checkboxes[5] | Boolean | 2 | |
| NOTESINDEX_I | Notes Index | Currency | 10 | |
| CHANGEBY_I | Change By | String | 16 | |
| CHANGEDATE_I | Change Date | Date | 4 |
Related Tables
Tables that share columns with AEX10130. Click "Join" to add to your query.