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: Project

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 NumberSTR15_RM_Customer_NumberString15
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 SearchYearYearInteger4
3PERIODID SearchPeriod IDINT3Integer3
4PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
5PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency17
6PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency17
7PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency17
8PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency17
9PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency17
10PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
11PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency17
12PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
13PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
14PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
15PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
16PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency17
17PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency17
18PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency15
19PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
20PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency17
21PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency17
22PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
23PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
24PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency17
25PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
26PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency17
27PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency17
28PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency17
29PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
30PAUnposted_Fee_Amount SearchPA Unposted Fee AmountPA_DLR17_RBS0_STR$Currency17
31PAPosted_Fee_Amount SearchPA Actual Fee AmountPA_DLR17_RBS0_STR$Currency17
32PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency17
33PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
34PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency17
35PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency17
36PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency17
37PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency17
38PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency17
39PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
40PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionPA_DLR17_RBS0_STR$Currency17
41PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency17
42PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency17
43PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency17
44PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionPA_DLR17_RBS0_STR$Currency17
45PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency17
46PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
47PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency17
48PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency17
49PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency17
50PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency17
51PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
52WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
53ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
54DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
55ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
56PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
57PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
58PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
59PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
60PACostPcntCompleted SearchPA Cost Percent CompletedDLR5_%2Currency8
61PAQuantityPcntCompleted SearchPA Quantity Percent CompletedDLR5_%2Currency8
62PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency17
63PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency15
64PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency17
65PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency15
66PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency17
67PAPOQty SearchPA PO QtyDLR15_RBU2Currency15
68PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency17
69PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency17
70PAtaxpaidamt SearchPA Tax Paid AmountDLR17_RBS0_UTR$Currency17
71PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency17
72PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
73PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
74PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
75PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency15
76PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
77PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency15
78PApretainage SearchPA Actual RetainageDLR17_RBS0_UTR$Currency17
79PAunpretainage SearchPA Unposted RetainageDLR17_RBS0_UTR$Currency17
80PA_Actual_Freight_Amount SearchPA Actual Freight AmountPA_DLR17_RBS0_STR$Currency17
81PA_Unposted_Freight_Amou SearchPA Unposted Freight AmountPA_DLR17_RBS0_STR$Currency17
82PA_Actual_Misc_Amount SearchPA Actual Misc AmountPA_DLR17_RBS0_STR$Currency17
83PA_Unposted_Misc_Amount SearchPA Unposted Misc AmountPA_DLR17_RBS0_STR$Currency17
84PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency17
85PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency17
86PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency17
87PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency17
88PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency17
89PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency17
90PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency17
91PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency17
92PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency15
93PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency15
94DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsProject Accounting (258)ProjectPA Customer Periodic Totals MSTR (PA00511)

Leave a Reply

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