PA Customer Periodic Totals MSTR (PA00511)

azurecurveProductsProject 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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
2YEAR1 SearchYearIntegerYear4
3PERIODID SearchPeriod IDIntegerINT33
4PABQuantity SearchPA Baseline QuantityCurrencyDLR15_RBU215
5PABProfit SearchPA Baseline ProfitCurrencyDLR17_RBS0_STR$17
6PABBillings SearchPA Baseline BillingsCurrencyDLR17_RBS0_UTR$17
7PABTaxPaidAmt SearchPA Baseline Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
8PABTaxChargedAmt SearchPA Baseline Tax Charged AmountCurrencyDLR17_RBS0_UTR$17
9PABaselineOvhdCost SearchPA Baseline Overhead CostCurrencyDLR17_RBS0_UTR$17
10PAFQuantity SearchPA Forecast QuantityCurrencyDLR15_RBU215
11PAFProfit SearchPA Forecast ProfitCurrencyDLR17_RBS0_STR$17
12PAFBillings SearchPA Forecast BillingsCurrencyDLR17_RBS0_UTR$17
13PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
14PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountCurrencyDLR17_RBS0_UTR$17
15PAForecastOvhdCost SearchPA Forecast Overhead CostCurrencyDLR17_RBS0_UTR$17
16PA_Earnings SearchPA EarningsCurrencyPA_DLR17_RBS0_STR$17
17PA_Cost_of_Earnings SearchPA Cost of EarningsCurrencyPA_DLR17_RBS0_STR$17
18PAUnpostedQty SearchPA Unposted QtyCurrencyPA_DLR15_RBS0_STR15
19PAPostedQty SearchPA Actual QtyCurrencyPA_DLR15_RBS0_STR15
20PAUnpostedProfitN SearchPA Unposted ProfitCurrencyPA_DLR17_RBS0_STR$17
21PAPostedProfitN SearchPA Actual ProfitCurrencyPA_DLR17_RBS0_STR$17
22PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
23PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
24PAUnpostedTotalCostN SearchPA Unposted Total CostCurrencyPA_DLR17_RBS0_STR$17
25PAPostedTotalCostN SearchPA Actual Total CostCurrencyPA_DLR17_RBS0_STR$17
26PAUnposted_Overhead SearchPA Unposted OverheadCurrencyPA_DLR17_RBS0_STR$17
27PAPosted_Overhead SearchPA Actual OverheadCurrencyPA_DLR17_RBS0_STR$17
28PAUnpostBillN SearchPA Unposted BillingsCurrencyPA_DLR17_RBS0_STR$17
29PAPostedBillingsN SearchPA Actual BillingsCurrencyPA_DLR17_RBS0_STR$17
30PAUnposted_Fee_Amount SearchPA Unposted Fee AmountCurrencyPA_DLR17_RBS0_STR$17
31PAPosted_Fee_Amount SearchPA Actual Fee AmountCurrencyPA_DLR17_RBS0_STR$17
32PAUnpostedRecogRevN SearchPA Unposted Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
33PAPostRecogRevN SearchPA Actual Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
34PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountCurrencyDLR17_RBS0_UTR$17
35PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountCurrencyDLR17_RBS0_UTR$17
36PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountCurrencyDLR17_RBS0_UTR$17
37PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountCurrencyDLR17_RBS0_UTR$17
38PAWrite_UpDown_Amount SearchPA Write Up/Down AmountCurrencyPA_DLR17_RBS0_STR$17
39PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
40PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionCurrencyPA_DLR17_RBS0_STR$17
41PAUNPOSTRETAMT SearchPA Unposted Retention AmountCurrencyPA_DLR17_RBS0_STR$17
42PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
43PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
44PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionCurrencyPA_DLR17_RBS0_STR$17
45PAPosted_Project_Fee SearchPA Actual Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
46PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
47PAPOSTRETAMT SearchPA Actual Retention AmountCurrencyPA_DLR17_RBS0_STR$17
48PAPosted_Service_Fee SearchPA Actual Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
49PA_Receipts_Amount SearchPA Receipts AmountCurrencyPA_DLR17_RBS0_STR$17
50PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountCurrencyPA_DLR17_RBS0_STR$17
51PAFeeAmount SearchPA Fee AmountCurrencyDLR17_RBSO_STR$17
52WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
53ActualWriteOffAmount SearchActual Write Off AmountCurrencyDLR17_RBS0_UTR$17
54DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
55ActualDiscTakenAmount SearchActual Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
56PABTotalCost SearchPA Baseline Total CostCurrencyDLR17_RBS0_UTR$17
57PAFTotalCost SearchPA Forecast Total CostCurrencyDLR17_RBS0_UTR$17
58PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountCurrencyPA_DLR17_RBS0_STR$17
59PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountCurrencyPA_DLR17_RBS0_STR$17
60PACostPcntCompleted SearchPA Cost Percent CompletedCurrencyDLR5_%28
61PAQuantityPcntCompleted SearchPA Quantity Percent CompletedCurrencyDLR5_%28
62PACommitted_Costs SearchPA Committed CostsCurrencyDLR17_RBS0_UTR$17
63PACommitted_Qty SearchPA Committed QtyCurrencyDLR15_RBU215
64PAPOPostedCost SearchPA PO Actual CostCurrencyDLR17_RBS0_UTR$17
65PAPOPostedQty SearchPA PO Actual QtyCurrencyPA_DLR15_RBS0_STR15
66PAPOCost SearchPA PO CostCurrencyDLR17_RBS0_UTR$17
67PAPOQty SearchPA PO QtyCurrencyDLR15_RBU215
68PAUnposted_Tax_Amount SearchPA Unposted Tax AmountCurrencyPA_DLR17_RBS0_STR$17
69PAPosted_Tax_Amount SearchPA Actual Tax AmountCurrencyPA_DLR17_RBS0_STR$17
70PAtaxpaidamt SearchPA Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
71PAPostedTaxPaidN SearchPA Actual Tax PaidCurrencyPA_DLR17_RBS0_STR$17
72PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountCurrencyPA_DLR17_RBS0_STR$17
73PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountCurrencyPA_DLR17_RBS0_STR$17
74PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
75PABilled_QtyN SearchPA Billed QtyCurrencyPA_DLR15_RBS0_STR15
76PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
77PAApproved_Quantity SearchPA Approved QuantityCurrencyPA_DLR15_RBS0_STR15
78PApretainage SearchPA Actual RetainageCurrencyDLR17_RBS0_UTR$17
79PAunpretainage SearchPA Unposted RetainageCurrencyDLR17_RBS0_UTR$17
80PA_Actual_Freight_Amount SearchPA Actual Freight AmountCurrencyPA_DLR17_RBS0_STR$17
81PA_Unposted_Freight_Amou SearchPA Unposted Freight AmountCurrencyPA_DLR17_RBS0_STR$17
82PA_Actual_Misc_Amount SearchPA Actual Misc AmountCurrencyPA_DLR17_RBS0_STR$17
83PA_Unposted_Misc_Amount SearchPA Unposted Misc AmountCurrencyPA_DLR17_RBS0_STR$17
84PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountCurrencyDLR17_RBS0_STR$17
85PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountCurrencyPA_DLR17_RBS0_STR$17
86PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtCurrencyDLR17_RBS0_STR$17
87PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtCurrencyPA_DLR17_RBS0_STR$17
88PAPosted_Earnings SearchPA Actual EarningsCurrencyPA_DLR17_RBS0_STR$17
89PAActualCostofEarnings SearchPA Actual Cost of EarningsCurrencyPA_DLR17_RBS0_STR$17
90PAUnpostedLossAmount SearchPA Unposted Loss AmountCurrencyDLR17_RBS0_UTR$17
91PAActualLossAmount SearchPA Actual Loss AmountCurrencyDLR17_RBS0_UTR$17
92PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyCurrencyDLR15_RBU215
93PAAQLaborOnly SearchPA Actual Qty - Labor OnlyCurrencyPA_DLR15_RBS0_STR15
azurecurveProductsProject Accounting (258)ProjectPA Customer Periodic Totals MSTR (PA00511)

Leave a Reply

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