PP100101 - Deferral Line History
Dynamics GP table PP100101 (Deferral Line History) contains 12 columns including PP_Module, PP_Record_Type, PP_Document_Number....
SQL Query Builder
12 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 | ||
| DSCRIPTN | Description | String | 32 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| TRXAMNT | TRX Amount | Currency | 10 | ||
| JRNENTRY | Journal Entry | Long Integer | 4 | ||
Related Tables
Tables that share columns with PP100101. Click "Join" to add to your query.