PP000030 - Deferral User Access
Dynamics GP table PP000030 (Deferral User Access) contains 15 columns including PP_User_Security_Type, USERID, PP_Profile_Name....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PP_User_Security_Type | PP User Security Type | Integer | 2 | |
| USERID | User ID | String | 16 | |
| PP_Profile_Name | PP Profile Name | String | 22 | |
| PP_User_Access | PP_User_Access | Boolean | 2 | |
| PP_Edit_Profile_Original | PP Edit Profile Original Account | Boolean | 2 | |
| PP_Edit_Profile_Offset_A | PP Edit Profile Offset Account | Boolean | 2 | |
| PP_Edit_Profile_Deferred | PP Edit Profile Deferred BC Account | Boolean | 2 | |
| PP_Edit_Profile_CI_Accou | PP Edit Profile Recog Account | Boolean | 2 | |
| PP_Edit_Profile_Transfer | PP Edit Profile Transfer Account | Boolean | 2 | |
| PP_Edit_Profile_Start_Da | PP Edit Profile Start Date | Boolean | 2 | |
| PP_Edit_Profile_Calculat | PP Edit Profile Calculation Method | Boolean | 2 | |
| PP_Edit_Profile_Periods | PP Edit Profile Periods | Boolean | 2 | |
| PP_Edit_Profile_Miscella | PP Edit Profile Miscellaneous Periods | Boolean | 2 | |
| PP_Edit_Debit_Credit | PP Edit Debit Credit | Boolean | 2 | |
| PP_Module | PP Module | Integer | 2 |
Related Tables
Tables that share columns with PP000030. Click "Join" to add to your query.