Deferral Line Work (PP000101)

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

Product: Revenue Expense Deferrals (1045)
Series: Financial

Display Name: Deferral Line Work
Physical Name: PP000101
Technical Name: PP_PrePayment_LINE_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
9DSCRIPTN SearchDescriptionSTR30String30
10GLPOSTDT SearchGL Posting DateDTDate8
11TRXAMNT SearchTRX AmountDLR19_$S2Currency19
12JRNENTRY SearchJournal EntryLI8_U0Long Integer8
13DEX_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 *