PP000011 - Deferral Profiles Header WORK
SQL Query Builder
19 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| PP_Module | smallint 0 | ||||
| PP_Record_Type | smallint 0 | ||||
| PP_Document_Number | char(21) '' | ||||
| PPOFFSEQ | int 0 | ||||
| PP_Sequencer | int 0 | ||||
| DISTTYPE | smallint 0 | ||||
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 | char(21) '' | ||||
| OFFINDX | int 0 | ||||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | |||
| PP_Deferred_BC_Index | int 0 | ||||
| PP_Deferrals_Transfer_In | int 0 | ||||
| PP_Recognition_Index | int 0 | ||||
| PP_Calculation_Method | smallint 0 | ||||
| STRTNGDT | datetime '1/1/1900' | ||||
| ENDINGDT | datetime '1/1/1900' | ||||
| NUMOFPER | smallint 0 | ||||
| NOTEINDX | numeric(19,5) 0.00 | ||||
| PP_Miscellaneous_Periods | smallint 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with PP000011. Click "Join" to add to your query.