AHR2AP02 - Archive_HR_Applicant_History
Dynamics GP table AHR2AP02 (Archive_HR_Applicant_History) contains 21 columns including APPLICANTNUMBER_I, ISEQUENCENUMBER_I, APPLYDATE_I....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| APPLICANTNUMBER_I | Applicant Number | Currency | 10 | |
| ISEQUENCENUMBER_I | ISequence Number | Integer | 2 | |
| APPLYDATE_I | Apply Date | Date | 4 | |
| REQUISITIONNUMBER_I | Requisition Number | Long Integer | 4 | |
| COMPANYCODE_I | Company Code | String | 8 | |
| DIVISIONCODE_I | Division Code | String | 8 | |
| DEPARTMENTCODE_I | Department Code | String | 8 | |
| POSITIONCODE_I | Position Code | String | 8 | |
| LOCCODE_I | Loc Code | String | 16 | |
| STATUS0_I | Status0 | Integer | 2 | |
| REJECTREASON_I | Reject Reason | Integer | 2 | |
| DSCRIPTN | Description | String | 32 | |
| NOTESINDEX_I | Notes Index | Currency | 10 | |
| COLORCODE_I | Color Code | Integer | 2 | |
| COLORSTRING_I | Color String | String | 8 | |
| REFSOURCEDDL_I | Ref Source DDL | Integer | 2 | |
| REFERENCESOURCE_I | Reference Source | String | 32 | |
| RELOCATION_I | Relocation | Integer | 2 | |
| REPLYLETTERSENT_I | Reply Letter Sent | Boolean | 2 | |
| CHANGEBY_I | Change By | String | 16 | |
| CHANGEDATE_I | Change Date | Date | 4 |
Related Tables
Tables that share columns with AHR2AP02. Click "Join" to add to your query.
APPLYDATE_I
COMPANYCODE_I