Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PP000001
Product: Revenue Expense Deferrals (1045)
Series:
Display Name: Deferral Setup
Physical Name: PP000001
Technical Name: PP_Prepayment_SETUPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UNIQKEY 
Key String STR1 1 2 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['Deferral Setup'].SOURCDOC AS 'Deferral Setup-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
PP000001 AS ['Deferral Setup']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['Deferral Setup'].SOURCDOC = ['Source Document Master'].SOURCDOC3 TRXSRCPX Transaction Source Prefix String Transaction Source Prefix 5 4 NTRXSNUM Next Transaction Source Number Long Integer LI_8_POS 8 5 PP_Document_Number PP Document Number String STR20 20 6 PP_Open_Closed_Periods PP Open Closed Periods Integer PP_Open_Closed_Periods 0 7 PP_Auto_Post PP Auto Post Integer PP_Open_Closed_Periods 0 8 PP_Auto_Post_Back PP Auto Post Back Integer PP_Open_Closed_Periods 0 9 PP_RM_Initial_Posting PP RM Initial Posting Integer PP_RG_RM_Initial_Posting 0 10 PP_PM_Initial_Posting PP PM Initial Posting Integer PP_RG_PM_Initial_Posting 0 11 PP_Calculation_Method PP Calculation Method Integer DDL_PP_Calculation_Method 0 12 PPPRTRPT PP Print Report Boolean CB 0 13 PPPRTPRT PP Print To Printer Boolean CB 0 14 PPPRTSCN PP Print To Screen Boolean CB 0 15 PRNTOFIL Print to File Boolean CB_Print_to_File 0 16 PP_Void_Trns PP Void Trns Integer RG_PP_Void_Trns 0 17 PP_Overide_Access PP Overide Access Integer RG_PP_Override_Access 0 18 PP_Profile_Account_Overw PP Profile Account Overwrite Options Integer RG_PP_Profile_Account_Overwite 0