PP100100 - Deferral Header History
Dynamics GP table PP100100 (Deferral Header History) contains 26 columns including PP_Module, PP_Record_Type, PP_Document_Number....
SQL Query Builder
26 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 | ||
| PP_Sequencer | PP Sequencer | Long Integer | 4 | ||
| PPOFFSEQ | PP Offset Sequence | Long Integer | 4 | ||
| VCHRNMBR | Voucher Number | String | 22 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| DSTSQNUM | Distribution Sequence Number | Long Integer | 4 | ||
| STRTNGDT | Starting Date | Date | 4 | ||
| ENDINGDT | Ending Date | Date | 4 | ||
| OFFACCT | Offset Account | 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 | ||
| TRXAMNT | TRX Amount | Currency | 10 | ||
| USERID | User ID | String | 16 | ||
| REFRENCE | Reference | String | 32 | ||
| IntegerValue | IntegerValue | Integer | 2 | ||
| PP_Calculation_Method | PP Calculation Method | Integer | 2 | ||
| PP_Miscellaneous_Periods | PP Miscellaneous Periods | Integer | 2 | ||
| VOIDSTTS | Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. | Integer | 2 | ||
Void Status values (2) 0 = Normal1 = Voided | |||||
| CUSTVNDR | Customer or Vendor ID | String | 16 | ||
| DOCDATE | Document Date | Date | 4 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| JRNENTRY | Journal Entry | Long Integer | 4 | ||
Related Tables
Tables that share columns with PP100100. Click "Join" to add to your query.