PA Rev Recognition Header HIST File (PA33301)

azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Header HIST File (PA33301)

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

Product: Project Accounting (258)
Series:

Display Name: PA Rev Recognition Header HIST File
Physical Name: PA33301
Technical Name: PA_Rev_Recog_HDR_HIST

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

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

Click to show/hide

SELECT
       ['PA Rev Recognition Header HIST File'].CUSTNMBR AS 'PA Rev Recognition Header HIST File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA33301 AS ['PA Rev Recognition Header HIST File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Rev Recognition Header HIST File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
6BACHNUMB SearchBatch NumberStringSTR15_LBAU15
7TRXSORCE SearchTRX SourceStringSTR1313
8BCHSOURC SearchBatch SourceStringSTR1515
9PARecognizedProjRev SearchPA Recognized Project RevenueCurrencyDLR17_RBS0_STR$17
10PARecognizedBudgRev SearchPA Recognized Budget RevenueCurrencyDLR17_RBS0_STR$17
11PARecognizedFeeRev SearchPA Recognized Fee RevenueCurrencyDLR17_RBS0_STR$17
12PABIEEAMOUNT SearchPA BIEE AmountCurrencyDLR17_RBS0_UTR$17
13PAEIEBAMOUNT SearchPA EIEB AmountCurrencyDLR17_RBS0_UTR$17
14LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
15DSTSQNUM SearchDistribution Sequence NumberLong IntegerLong Int8
16PARRDISTERR SearchPA RR Distribution ErrorsLong IntegerML_RR_Distribution_Errors0
17PARRHDRERR SearchPA RR HDR ErrorsLong IntegerML_RR_Header_Errors0
18NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Rev Recognition Header HIST File'].NOTEINDX AS 'PA Rev Recognition Header HIST File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA33301 AS ['PA Rev Recognition Header HIST File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Rev Recognition Header HIST File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
azurecurveProductsProject Accounting (258)ProjectPA Rev Recognition Header HIST File (PA33301)

Leave a Reply

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