PA Rev Recognition Proj Detail HIST File (PA33304)

azurecurve Products Project Accounting (258)ProjectPA Rev Recognition Proj Detail HIST File (PA33304)

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

Product: Project Accounting (258)
Series:

Display Name: PA Rev Recognition Proj Detail HIST File
Physical Name: PA33304
Technical Name: PA_Rev_Recog_DTL_HIST

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
2	PADocnumber20	PA Document No.	String	STR17_LBAU	17
3	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['PA Rev Recognition Proj Detail HIST File'].CUSTNMBR AS 'PA Rev Recognition Proj Detail HIST File-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM PA33304 AS ['PA Rev Recognition Proj Detail HIST File'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['PA Rev Recognition Proj Detail HIST File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4	PACONTNUMBER	PA Contract Number	String	STR10_LBAU	10
5	PADOCDT	PA Document Date	Date	PA_Date	8
6	CUTOFDAT	Cutoff Date	Date	DT	8
7	PAPROJNUMBER	PA Project Number	String	STR15_LBAU	15
8	PAprojname	PA Project Name	String	STR30_PTBS Description 1	30
9	PASegmentCB	PA Segment CB	Boolean	PA_CB_Segment	0
10	PA_Combine_Mode	PA RR Combine Mode	Integer	INT1	1
11	PAProjectType	PA Project Type	Integer	PA_DDL_Project_Type	0
12	PAAcctgMethod	PA Accounting Method	Integer	PA_DDL_Accounting_Method	0
13	PASTAT	PA Status	Integer	PA_DDL_Status	0
14	PAPercentCompleted	PA Percent Completed	Currency	DLR5_%2	8
15	PAProject_Amount	PA Project Amount	Currency	DLR17_RBS0_UTR$	17
16	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
17	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
18	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
19	PAPostCost	PA Actual Cost	Currency	DLR17_RBS0_UTR$	17
20	PAPostedQty	PA Actual Qty	Currency	PA_DLR15_RBS0_STR	15
21	PA_Actual_CostContract	PA Actual Cost-Contract	Currency	DLR17_RBS0_UTR$	17
22	PA_Actual_QtyContract	PA Actual Qty-Contract	Currency	PA_DLR15_RBS0_STR	15
23	PARevenueEarned	PA Revenue Earned	Currency	DLR17_RBS0_UTR$	17
24	PAREB	PA Revenue Earned-Budget	Currency	DLR17_RBS0_UTR$	17
25	PAREF	PA Revenue Earned-Fee	Currency	DLR17_RBS0_UTR$	17
26	PA_Cost_of_Earnings	PA Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
27	PABRecognizedProjAmt	PA Recognized Project Amount	Currency	DLR17_RBS0_STR$	17
28	PABRecognizedBudgAmount	PA Recognized Budget Amount	Currency	DLR17_RBS0_STR$	17
29	PARecognizedFeeAmount	PA Recognized Fee Amount	Currency	DLR17_RBS0_STR$	17
30	PABIEEAMOUNT	PA BIEE Amount	Currency	DLR17_RBS0_UTR$	17
31	PAEIEBAMOUNT	PA EIEB Amount	Currency	DLR17_RBS0_UTR$	17
32	PARRLNEERR	PA RR Line Errors	Long Integer	ML_RR_Line_Errors	0
33	PA_ActualCost__LossTest	PA ActualCost - LossTest	Currency	DLR17_RBS0_UTR$	17
34	PA_ProjAmt__LossTest	PA ProjAmt - LossTest	Currency	DLR17_RBS0_UTR$	17
35	PA_ActualRecogRev__LossT	PA ActualRecogRev - LossTest	Currency	DLR17_RBS0_UTR$	17
36	PA_ActualBlgs__XcessTest	PA ActualBlgs - XcessTest	Currency	DLR17_RBS0_UTR$	17
37	PA_Earnings__XcessTest	PA Earnings - XcessTest	Currency	DLR17_RBS0_UTR$	17
38	PAPostedBillingsN	PA Actual Billings	Currency	PA_DLR17_RBS0_STR$	17
39	PAPostRecogRevN	PA Actual Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
40	PALossAmount	PA Loss Amount	Currency	DLR17_RBS0_UTR$	17
41	PAFQLaborOnly	PA Forecast Quantity - Labor Only	Currency	DLR15_RBU2	15
42	PAFTCLaborOnly	PA Forecast Total Cost - Labor Only	Currency	DLR17_RBS0_UTR$	17
43	PAAQLaborOnly	PA Actual Qty - Labor Only	Currency	PA_DLR15_RBS0_STR	15
44	PAACLaborOnly	PA Actual Cost - Labor Only	Currency	PA_DLR17_RBS0_STR$	17

azurecurve Products Project Accounting (258)ProjectPA Rev Recognition Proj Detail HIST File (PA33304)

Click to show/hide

Leave a Reply Cancel reply