PP000012 - Deferral Profiles Header History
Dynamics GP table PP000012 (Deferral Profiles Header History) contains 19 columns including PP_Module, PP_Record_Type, PP_Document_Number....
SQL Query Builder
19 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| PP_Module | PP Module | Integer | 2 | ||
| PP_Record_Type | PP Record Type | Integer | 2 | ||
| PP_Document_Number | PP Document Number | String | 22 | ||
| PPOFFSEQ | PP Offset Sequence | Long Integer | 4 | ||
| PP_Sequencer | PP Sequencer | Long Integer | 4 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| PP_Profile_Name | PP Profile Name | String | 22 | ||
| 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 | ||
| 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 PP000012. Click "Join" to add to your query.