GP Tables

AEU10130 - Archive_HR_User_Defined

Dynamics GP table AEU10130 (Archive_HR_User_Defined) contains 38 columns including MSEQUENCE_I, EMPID_I, MSTRING_I_1....

SQL Query Builder

38 Columns

Column Description Type Length
MSEQUENCE_I MSequence Integer 2
EMPID_I Emp ID String 16
MSTRING_I_1 MString[1] String 32
MSTRING_I_2 MString[2] String 32
MSTRING_I_3 MString[3] String 32
MSTRING_I_4 MString[4] String 32
MSTRING_I_5 MString[5] String 32
MLINT_I_1 MLint[1] Long Integer 4
MLINT_I_2 MLint[2] Long Integer 4
MLINT_I_3 MLint[3] Long Integer 4
MLINT_I_4 MLint[4] Long Integer 4
MLINT_I_5 MLint[5] Long Integer 4
MDLR_I_1 MDLR[1] Currency 10
MDLR_I_2 MDLR[2] Currency 10
MDLR_I_3 MDLR[3] Currency 10
MDLR_I_4 MDLR[4] Currency 10
MDLR_I_5 MDLR[5] Currency 10
MCHECK_I_1 MCheck[1] Boolean 2
MCHECK_I_2 MCheck[2] Boolean 2
MCHECK_I_3 MCheck[3] Boolean 2
MCHECK_I_4 MCheck[4] Boolean 2
MCHECK_I_5 MCheck[5] Boolean 2
MCHECK_I_6 MCheck[6] Boolean 2
MCHECK_I_7 MCheck[7] Boolean 2
MCHECK_I_8 MCheck[8] Boolean 2
MCHECK_I_9 MCheck[9] Boolean 2
MCHECK_I_10 MCheck[10] Boolean 2
MDATE1_I MDate1 Date 4
MDATE2_I MDate2 Date 4
MDATE3_I MDate3 Date 4
MDATE4_I MDate4 Date 4
MDATE5_I MDate5 Date 4
MTIME_I_1 MTime[1] String 6
MTIME_I_2 MTime[2] String 6
MTIME_I_3 MTime[3] String 6
MTIME_I_4 MTime[4] String 6
MTIME_I_5 MTime[5] String 6
NOTESINDEX_I Notes Index Currency 10

Related Tables

Tables that share columns with AEU10130. Click "Join" to add to your query.

MSEQUENCE_I

MSTRING_I_1

MSTRING_I_2

MSTRING_I_3

MSTRING_I_4

MSTRING_I_5

MLINT_I_1

MLINT_I_2