PA Project Periodic Totals MSTR (PA01221)

azurecurveProductsProject Accounting (258)ProjectPA Project Periodic Totals MSTR (PA01221)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Periodic Totals MSTR
Physical Name: PA01221
Technical Name: PA_Project_Periodic_Totals_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
2YEAR1 SearchYearYearInteger4
3PERIODID SearchPeriod IDINT3Integer3
4PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
5PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
6PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency17
7PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency17
8PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency17
9PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency17
10PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency17
11PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
12PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
13PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency17
14PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
15PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
16PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
17PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
18PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency17
19PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency17
20PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency15
21PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
22PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency17
23PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency17
24PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
25PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
26PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency17
27PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
28PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency17
29PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency17
30PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency17
31PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
32PAUnposted_Fee_Amount SearchPA Unposted Fee AmountPA_DLR17_RBS0_STR$Currency17
33PAPosted_Fee_Amount SearchPA Actual Fee AmountPA_DLR17_RBS0_STR$Currency17
34PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency17
35PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
36PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency17
37PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency17
38PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency17
39PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency17
40PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency17
41PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionPA_DLR17_RBS0_STR$Currency17
42PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency17
43PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
44PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency17
45PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency17
46PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency17
47PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency17
48PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionPA_DLR17_RBS0_STR$Currency17
49PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency17
50PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
51PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency17
52PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency17
53PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
54WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
55ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
56DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
57ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_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
64PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency17
65PAPOQty SearchPA PO QtyDLR15_RBU2Currency15
66PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency17
67PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency15
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_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency17
81PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency17
82PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency17
83PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency17
84PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency17
85PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency17
86PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency17
87PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency17
88PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency15
89PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency15
90DEX_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 Project Periodic Totals MSTR (PA01221)

Leave a Reply

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