Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PP000010
Product: Revenue Expense Deferrals (1045)
Series:
Display Name: Deferral Profiles Header
Physical Name: PP000010
Technical Name: PP_Profiles_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PP_Profile_Name 
PP Profile Name String STR20_Document_Number 20 2 PP_Module PP Module Integer INT3 3 3 OFFINDX Offset Account Index Long Integer LI_14 14 4 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Deferral Profiles Header'].ACTINDX AS 'Deferral Profiles Header-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PP000010 AS ['Deferral Profiles Header']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Deferral Profiles Header'].ACTINDX = ['Account Index Master'].ACTINDX5 PP_Deferred_BC_Index PP Deferred BC Index Long Integer LI_14 14 6 PP_Deferrals_Transfer_In PP Deferrals Transfer Index Long Integer LI_14 14 7 PP_Recognition_Index PP Recognition Index Long Integer LI_14 14 8 PP_Calculation_Method PP Calculation Method Integer DDL_PP_Calculation_Method 0 9 PP_Debit_Credit_1 PP Debit Credit[1] Integer PP_Dr_Cr 0 10 PP_Debit_Credit PP Debit Credit PP_Dr_Cr Integer 0 11 PP_Debit_Credit_2 PP Debit Credit[2] Integer PP_Dr_Cr 0 12 PP_Debit_Credit_3 PP Debit Credit[3] Integer PP_Dr_Cr 0 13 PP_Debit_Credit_4 PP Debit Credit[4] Integer PP_Dr_Cr 0 14 PP_Debit_Credit_5 PP Debit Credit[5] Integer PP_Dr_Cr 0 15 PP_Debit_Credit_6 PP Debit Credit[6] Integer PP_Dr_Cr 0 16 PP_Debit_Credit_7 PP Debit Credit[7] Integer PP_Dr_Cr 0 17 PP_Debit_Credit_8 PP Debit Credit[8] Integer PP_Dr_Cr 0 18 PP_Debit_Credit_9 PP Debit Credit[9] Integer PP_Dr_Cr 0 19 PP_Debit_Credit_10 PP Debit Credit[10] Integer PP_Dr_Cr 0 20 STRTNGDT Starting Date Date DT 8 21 ENDINGDT Ending Date Date DT 8 22 NUMOFPER Number of Periods Integer INT2 2 23 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Deferral Profiles Header'].NOTEINDX AS 'Deferral Profiles Header-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PP000010 AS ['Deferral Profiles Header']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Deferral Profiles Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX24 PP_Overwrite_Original_Di PP Overwrite Original Distribution Account Boolean PP_CB_Overwrite_Original_Distribution_Account 0 25 PP_Miscellaneous_Periods PP Miscellaneous Periods Integer INT5 4