PA Rev Recognition Header Work File (PA23301)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Header Work File (PA23301)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Rev Recognition Header Work File
Physical Name: PA23301
Technical Name: PA_Rev_Recog_HDR_WORK

Group Display Name: PA Revenue Recog Transactions
Group Technical Name: PA Revenue Recog Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PADocnumber20 SearchPA Document No.STR17_LBAUString17
2PADOCDT SearchPA Document DatePA_DateDate8
3CUTOFDAT SearchCutoff DateDTDate8
4PAPD SearchPA Post DatePA_DateDate8
5CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Rev Recognition Header Work File'].CUSTNMBR AS 'PA Rev Recognition Header Work File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA23301 AS ['PA Rev Recognition Header Work File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Header Work File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
6BACHNUMB SearchBatch NumberSTR15_LBAUString15
7TRXSORCE SearchTRX SourceSTR13String13
8BCHSOURC SearchBatch SourceSTR15String15
9PARecognizedProjRev SearchPA Recognized Project RevenueDLR17_RBS0_STR$Currency17
10PARecognizedBudgRev SearchPA Recognized Budget RevenueDLR17_RBS0_STR$Currency17
11PARecognizedFeeRev SearchPA Recognized Fee RevenueDLR17_RBS0_STR$Currency17
12PABIEEAMOUNT SearchPA BIEE AmountDLR17_RBS0_UTR$Currency17
13PAEIEBAMOUNT SearchPA EIEB AmountDLR17_RBS0_UTR$Currency17
14LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
15DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer8
16PARRDISTERR SearchPA RR Distribution ErrorsML_RR_Distribution_ErrorsLong Integer0
17PARRHDRERR SearchPA RR HDR ErrorsML_RR_Header_ErrorsLong Integer0
18NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Rev Recognition Header Work File'].NOTEINDX AS 'PA Rev Recognition Header Work File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA23301 AS ['PA Rev Recognition Header Work File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Rev Recognition Header Work File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19DEX_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.

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Header Work File (PA23301)

Leave a Reply

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