PP000010 - Deferral Profiles Header
Dynamics GP table PP000010 (Deferral Profiles Header) contains 24 columns including PP_Profile_Name, PP_Module, OFFINDX....
SQL Query Builder
24 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PP_Profile_Name | PP Profile Name | String | 22 | |
| PP_Module | PP Module | Integer | 2 | |
| OFFINDX | Offset Account Index | Long Integer | 4 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| PP_Deferred_BC_Index | PP Deferred BC Index | Long Integer | 4 | |
| PP_Deferrals_Transfer_In | PP Deferrals Transfer Index | Long Integer | 4 | |
| PP_Recognition_Index | PP Recognition Index | Long Integer | 4 | |
| PP_Calculation_Method | PP Calculation Method | Integer | 2 | |
| PP_Debit_Credit_1 | PP Debit Credit[1] | Integer | 2 | |
| PP_Debit_Credit_2 | PP Debit Credit[2] | Integer | 2 | |
| PP_Debit_Credit_3 | PP Debit Credit[3] | Integer | 2 | |
| PP_Debit_Credit_4 | PP Debit Credit[4] | Integer | 2 | |
| PP_Debit_Credit_5 | PP Debit Credit[5] | Integer | 2 | |
| PP_Debit_Credit_6 | PP Debit Credit[6] | Integer | 2 | |
| PP_Debit_Credit_7 | PP Debit Credit[7] | Integer | 2 | |
| PP_Debit_Credit_8 | PP Debit Credit[8] | Integer | 2 | |
| PP_Debit_Credit_9 | PP Debit Credit[9] | Integer | 2 | |
| PP_Debit_Credit_10 | PP Debit Credit[10] | Integer | 2 | |
| STRTNGDT | Starting Date | Date | 4 | |
| ENDINGDT | Ending Date | Date | 4 | |
| NUMOFPER | Number of Periods | Integer | 2 | |
| NOTEINDX | Note Index | Currency | 10 | |
| PP_Overwrite_Original_Di | PP Overwrite Original Distribution Account | Boolean | 2 | |
| PP_Miscellaneous_Periods | PP Miscellaneous Periods | Integer | 2 |
Related Tables
Tables that share columns with PP000010. Click "Join" to add to your query.