Deferral Header Work (PP000100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PP000100

Product: Revenue Expense Deferrals (1045)
Series: Financial

Display Name: Deferral Header Work
Physical Name: PP000100
Technical Name: PP_PrePayment_HDR_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PP_Module SearchPP ModuleINT3Integer3
2PP_Record_Type SearchPP Record TypeINT3Integer3
3PP_Document_Number SearchPP Document NumberSTR20String20
4PP_Sequencer SearchPP SequencerLI_14Long Integer14
5PPOFFSEQ SearchPP Offset SequenceLI_14Long Integer14
6VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
7CNTRLTYP SearchControl TypeINT1Integer1
8DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer8
9STRTNGDT SearchStarting DateDTDate8
10ENDINGDT SearchEnding DateDTDate8
11OFFACCT SearchOffset AccountLI_14Long Integer14
12ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Deferral Header Work'].ACTINDX AS 'Deferral Header Work-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PP000100 AS ['Deferral Header Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Deferral Header Work'].ACTINDX = ['Account Index Master'].ACTINDX
13PP_Deferred_BC_Index SearchPP Deferred BC IndexLI_14Long Integer14
14PP_Deferrals_Transfer_In SearchPP Deferrals Transfer IndexLI_14Long Integer14
15PP_Recognition_Index SearchPP Recognition IndexLI_14Long Integer14
16TRXAMNT SearchTRX AmountDLR19_$S2Currency19
17REFRENCE SearchReferenceSTR30String30
18USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Deferral Header Work'].USERID AS 'Deferral Header Work-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PP000100 AS ['Deferral Header Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Deferral Header Work'].USERID = ['Users Master'].USERID
19POSTING SearchPostingCBBoolean0
20IntegerValue SearchIntegerValueINTInteger0
21PP_Calculation_Method SearchPP Calculation MethodDDL_PP_Calculation_MethodInteger0
22PP_Miscellaneous_Periods SearchPP Miscellaneous PeriodsINT5Integer4
23NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Deferral Header Work'].NOTEINDX AS 'Deferral Header Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PP000100 AS ['Deferral Header Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Deferral Header Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
24JRNENTRY SearchJournal EntryLI8_U0Long Integer8
25DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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