Deferral Profiles Header (PP000010)

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_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PP_Profile_Name SearchPP Profile NameStringSTR20_Document_Number20
2PP_Module SearchPP ModuleIntegerINT33
3OFFINDX SearchOffset Account IndexLong IntegerLI_1414
4ACTINDX SearchAccount IndexLong IntegerLI_1414
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'].ACTINDX
5PP_Deferred_BC_Index SearchPP Deferred BC IndexLong IntegerLI_1414
6PP_Deferrals_Transfer_In SearchPP Deferrals Transfer IndexLong IntegerLI_1414
7PP_Recognition_Index SearchPP Recognition IndexLong IntegerLI_1414
8PP_Calculation_Method SearchPP Calculation MethodIntegerDDL_PP_Calculation_Method0
9PP_Debit_Credit_1 SearchPP Debit Credit[1]IntegerPP_Dr_Cr0
10PP_Debit_Credit SearchPP Debit CreditPP_Dr_CrInteger0
11PP_Debit_Credit_2 SearchPP Debit Credit[2]IntegerPP_Dr_Cr0
12PP_Debit_Credit_3 SearchPP Debit Credit[3]IntegerPP_Dr_Cr0
13PP_Debit_Credit_4 SearchPP Debit Credit[4]IntegerPP_Dr_Cr0
14PP_Debit_Credit_5 SearchPP Debit Credit[5]IntegerPP_Dr_Cr0
15PP_Debit_Credit_6 SearchPP Debit Credit[6]IntegerPP_Dr_Cr0
16PP_Debit_Credit_7 SearchPP Debit Credit[7]IntegerPP_Dr_Cr0
17PP_Debit_Credit_8 SearchPP Debit Credit[8]IntegerPP_Dr_Cr0
18PP_Debit_Credit_9 SearchPP Debit Credit[9]IntegerPP_Dr_Cr0
19PP_Debit_Credit_10 SearchPP Debit Credit[10]IntegerPP_Dr_Cr0
20STRTNGDT SearchStarting DateDateDT8
21ENDINGDT SearchEnding DateDateDT8
22NUMOFPER SearchNumber of PeriodsIntegerINT22
23NOTEINDX SearchNote IndexCurrencyDLR1414
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'].NOTEINDX
24PP_Overwrite_Original_Di SearchPP Overwrite Original Distribution AccountBooleanPP_CB_Overwrite_Original_Distribution_Account0
25PP_Miscellaneous_Periods SearchPP Miscellaneous PeriodsIntegerINT54

Leave a Reply

Your email address will not be published. Required fields are marked *