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 Group Display Name: PA Revenue Recog Transactions History
Physical Name: PA33301
Technical Name: PA_Rev_Recog_HDR_HIST
Group Technical Name: PA Revenue Recog Transactions History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
2 | PADOCDT | PA Document Date | Date | PA_Date | 8 | |
3 | CUTOFDAT | Cutoff Date | Date | DT | 8 | |
4 | PAPD | PA Post Date | Date | PA_Date | 8 | |
5 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
6 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
7 | TRXSORCE | TRX Source | String | STR13 | 13 | |
8 | BCHSOURC | Batch Source | String | STR15 | 15 | |
9 | PARecognizedProjRev | PA Recognized Project Revenue | Currency | DLR17_RBS0_STR$ | 17 | |
10 | PARecognizedBudgRev | PA Recognized Budget Revenue | Currency | DLR17_RBS0_STR$ | 17 | |
11 | PARecognizedFeeRev | PA Recognized Fee Revenue | Currency | DLR17_RBS0_STR$ | 17 | |
12 | PABIEEAMOUNT | PA BIEE Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
13 | PAEIEBAMOUNT | PA EIEB Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
14 | LNITMSEQ | Line Item Sequence | Long Integer | LI_Sequence_Number | 10 | |
15 | DSTSQNUM | Distribution Sequence Number | Long Integer | Long Int | 8 | |
16 | PARRDISTERR | PA RR Distribution Errors | Long Integer | ML_RR_Distribution_Errors | 0 | |
17 | PARRHDRERR | PA RR HDR Errors | Long Integer | ML_RR_Header_Errors | 0 | |
18 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 |