PA Customer Periodic Totals MSTR (PA00511)

azurecurve Products Project Accounting (258)ProjectPA Customer Periodic Totals MSTR (PA00511)

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

Product: Project Accounting (258)
Series:

Display Name: PA Customer Periodic Totals MSTR
Physical Name: PA00511
Technical Name: PA_Customer_Periodic_Totals_MSTR

Group Display Name: PA Budgeting Cards
Group Technical Name: PA Budgeting Cards

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['PA Customer Periodic Totals MSTR'].CUSTNMBR AS 'PA Customer Periodic Totals MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM PA00511 AS ['PA Customer Periodic Totals MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['PA Customer Periodic Totals MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	YEAR1	Year	Integer	Year	4
3	PERIODID	Period ID	Integer	INT3	3
4	PABQuantity	PA Baseline Quantity	Currency	DLR15_RBU2	15
5	PABProfit	PA Baseline Profit	Currency	DLR17_RBS0_STR$	17
6	PABBillings	PA Baseline Billings	Currency	DLR17_RBS0_UTR$	17
7	PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
8	PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
9	PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	DLR17_RBS0_UTR$	17
10	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
11	PAFProfit	PA Forecast Profit	Currency	DLR17_RBS0_STR$	17
12	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
13	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
14	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
15	PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	DLR17_RBS0_UTR$	17
16	PA_Earnings	PA Earnings	Currency	PA_DLR17_RBS0_STR$	17
17	PA_Cost_of_Earnings	PA Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
18	PAUnpostedQty	PA Unposted Qty	Currency	PA_DLR15_RBS0_STR	15
19	PAPostedQty	PA Actual Qty	Currency	PA_DLR15_RBS0_STR	15
20	PAUnpostedProfitN	PA Unposted Profit	Currency	PA_DLR17_RBS0_STR$	17
21	PAPostedProfitN	PA Actual Profit	Currency	PA_DLR17_RBS0_STR$	17
22	PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
23	PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
24	PAUnpostedTotalCostN	PA Unposted Total Cost	Currency	PA_DLR17_RBS0_STR$	17
25	PAPostedTotalCostN	PA Actual Total Cost	Currency	PA_DLR17_RBS0_STR$	17
26	PAUnposted_Overhead	PA Unposted Overhead	Currency	PA_DLR17_RBS0_STR$	17
27	PAPosted_Overhead	PA Actual Overhead	Currency	PA_DLR17_RBS0_STR$	17
28	PAUnpostBillN	PA Unposted Billings	Currency	PA_DLR17_RBS0_STR$	17
29	PAPostedBillingsN	PA Actual Billings	Currency	PA_DLR17_RBS0_STR$	17
30	PAUnposted_Fee_Amount	PA Unposted Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
31	PAPosted_Fee_Amount	PA Actual Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
32	PAUnpostedRecogRevN	PA Unposted Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
33	PAPostRecogRevN	PA Actual Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
34	PAUNPEIEBAMOUNT	PA Unposted EIEB Amount	Currency	DLR17_RBS0_UTR$	17
35	PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	DLR17_RBS0_UTR$	17
36	PAUNPOSTBIEEAMOUNT	PA Unposted BIEE Amount	Currency	DLR17_RBS0_UTR$	17
37	PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	DLR17_RBS0_UTR$	17
38	PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	PA_DLR17_RBS0_STR$	17
39	PAUnposted_Retainer_Fee	PA Unposted Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
40	PA_Unposted_Billed_Reten	PA Unposted Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
41	PAUNPOSTRETAMT	PA Unposted Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
42	PAUnposted_Service_Fee	PA Unposted Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
43	PAUnposted_Project_Fee	PA Unposted Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
44	PA_Actual_Billed_Retenti	PA Actual Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
45	PAPosted_Project_Fee	PA Actual Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
46	PAPosted_Retainer_Fee	PA Actual Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
47	PAPOSTRETAMT	PA Actual Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
48	PAPosted_Service_Fee	PA Actual Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
49	PA_Receipts_Amount	PA Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
50	PA_Actual_Receipts_Amoun	PA Actual Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
51	PAFeeAmount	PA Fee Amount	Currency	DLR17_RBSO_STR$	17
52	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
53	ActualWriteOffAmount	Actual Write Off Amount	Currency	DLR17_RBS0_UTR$	17
54	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
55	ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
56	PABTotalCost	PA Baseline Total Cost	Currency	DLR17_RBS0_UTR$	17
57	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
58	PAUnposted_Sales_Tax_Am	PA Unposted Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
59	PAPosted_Sales_Tax_Amou	PA Actual Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
60	PACostPcntCompleted	PA Cost Percent Completed	Currency	DLR5_%2	8
61	PAQuantityPcntCompleted	PA Quantity Percent Completed	Currency	DLR5_%2	8
62	PACommitted_Costs	PA Committed Costs	Currency	DLR17_RBS0_UTR$	17
63	PACommitted_Qty	PA Committed Qty	Currency	DLR15_RBU2	15
64	PAPOPostedCost	PA PO Actual Cost	Currency	DLR17_RBS0_UTR$	17
65	PAPOPostedQty	PA PO Actual Qty	Currency	PA_DLR15_RBS0_STR	15
66	PAPOCost	PA PO Cost	Currency	DLR17_RBS0_UTR$	17
67	PAPOQty	PA PO Qty	Currency	DLR15_RBU2	15
68	PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
69	PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
70	PAtaxpaidamt	PA Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
71	PAPostedTaxPaidN	PA Actual Tax Paid	Currency	PA_DLR17_RBS0_STR$	17
72	PAPostedDiscDolAmtN	PA Actual Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
73	PAUnpostDiscDolAmtN	PA Unposted Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
74	PABilled_Accrued_Revenu	PA Billed Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
75	PABilled_QtyN	PA Billed Qty	Currency	PA_DLR15_RBS0_STR	15
76	PAApproved_Accrued_Reve	PA Approved Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
77	PAApproved_Quantity	PA Approved Quantity	Currency	PA_DLR15_RBS0_STR	15
78	PApretainage	PA Actual Retainage	Currency	DLR17_RBS0_UTR$	17
79	PAunpretainage	PA Unposted Retainage	Currency	DLR17_RBS0_UTR$	17
80	PA_Actual_Freight_Amount	PA Actual Freight Amount	Currency	PA_DLR17_RBS0_STR$	17
81	PA_Unposted_Freight_Amou	PA Unposted Freight Amount	Currency	PA_DLR17_RBS0_STR$	17
82	PA_Actual_Misc_Amount	PA Actual Misc Amount	Currency	PA_DLR17_RBS0_STR$	17
83	PA_Unposted_Misc_Amount	PA Unposted Misc Amount	Currency	PA_DLR17_RBS0_STR$	17
84	PA_Write_Off_Tax_Amount	PA Write Off Tax Amount	Currency	DLR17_RBS0_STR$	17
85	PAActualWOTaxAmt	PA Actual Write Off Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
86	PA_Terms_Taken_Tax_Amt	PA Terms Taken Tax Amt	Currency	DLR17_RBS0_STR$	17
87	PAActualTermsTakenTax	PA Actual Terms Taken Tax Amt	Currency	PA_DLR17_RBS0_STR$	17
88	PAPosted_Earnings	PA Actual Earnings	Currency	PA_DLR17_RBS0_STR$	17
89	PAActualCostofEarnings	PA Actual Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
90	PAUnpostedLossAmount	PA Unposted Loss Amount	Currency	DLR17_RBS0_UTR$	17
91	PAActualLossAmount	PA Actual Loss Amount	Currency	DLR17_RBS0_UTR$	17
92	PAFQLaborOnly	PA Forecast Quantity - Labor Only	Currency	DLR15_RBU2	15
93	PAAQLaborOnly	PA Actual Qty - Labor Only	Currency	PA_DLR15_RBS0_STR	15

azurecurve Products Project Accounting (258)ProjectPA Customer Periodic Totals MSTR (PA00511)

Click to show/hide

Leave a Reply Cancel reply