Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01221
Product: Project Accounting (258)
Series:
Display Name: PA Project Periodic Totals MSTR Group Display Name: PA Budgeting Cards
Physical Name: PA01221
Technical Name: PA_Project_Periodic_Totals_MSTR
Group Technical Name: PA Budgeting Cards
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | PAPROJNUMBER | PA Project Number | String | STR15_LBAU | 15 |
2 | YEAR1 | Year | Integer | Year | 4 |
3 | PERIODID | Period ID | Integer | INT3 | 3 |
4 | PABQuantity | PA Baseline Quantity | Currency | DLR15_RBU2 | 15 |
5 | PABTotalCost | PA Baseline Total Cost | Currency | DLR17_RBS0_UTR$ | 17 |
6 | PABProfit | PA Baseline Profit | Currency | DLR17_RBS0_STR$ | 17 |
7 | PABBillings | PA Baseline Billings | Currency | DLR17_RBS0_UTR$ | 17 |
8 | PABTaxPaidAmt | PA Baseline Tax Paid Amount | Currency | DLR17_RBS0_UTR$ | 17 |
9 | PABTaxChargedAmt | PA Baseline Tax Charged Amount | Currency | DLR17_RBS0_UTR$ | 17 |
10 | PABaselineOvhdCost | PA Baseline Overhead Cost | Currency | DLR17_RBS0_UTR$ | 17 |
11 | PAFQuantity | PA Forecast Quantity | Currency | DLR15_RBU2 | 15 |
12 | PAFTotalCost | PA Forecast Total Cost | Currency | DLR17_RBS0_UTR$ | 17 |
13 | PAFProfit | PA Forecast Profit | Currency | DLR17_RBS0_STR$ | 17 |
14 | PAFBillings | PA Forecast Billings | Currency | DLR17_RBS0_UTR$ | 17 |
15 | PAFTaxPaidAmt | PA Forecast Tax Paid Amount | Currency | DLR17_RBS0_UTR$ | 17 |
16 | PAFTaxChargedAmt | PA Forecast Tax Charged Amount | Currency | DLR17_RBS0_UTR$ | 17 |
17 | PAForecastOvhdCost | PA Forecast Overhead Cost | Currency | DLR17_RBS0_UTR$ | 17 |
18 | PA_Earnings | PA Earnings | Currency | PA_DLR17_RBS0_STR$ | 17 |
19 | PA_Cost_of_Earnings | PA Cost of Earnings | Currency | PA_DLR17_RBS0_STR$ | 17 |
20 | PAUnpostedQty | PA Unposted Qty | Currency | PA_DLR15_RBS0_STR | 15 |
21 | PAPostedQty | PA Actual Qty | Currency | PA_DLR15_RBS0_STR | 15 |
22 | PAUnpostedProfitN | PA Unposted Profit | Currency | PA_DLR17_RBS0_STR$ | 17 |
23 | PAPostedProfitN | PA Actual Profit | Currency | PA_DLR17_RBS0_STR$ | 17 |
24 | PAUnpostAccrRevN | PA Unposted Accrued Revenues | Currency | PA_DLR17_RBS0_STR$ | 17 |
25 | PAPosted_Accr_RevN | PA Actual Accrued Revenues | Currency | PA_DLR17_RBS0_STR$ | 17 |
26 | PAUnpostedTotalCostN | PA Unposted Total Cost | Currency | PA_DLR17_RBS0_STR$ | 17 |
27 | PAPostedTotalCostN | PA Actual Total Cost | Currency | PA_DLR17_RBS0_STR$ | 17 |
28 | PAUnposted_Overhead | PA Unposted Overhead | Currency | PA_DLR17_RBS0_STR$ | 17 |
29 | PAPosted_Overhead | PA Actual Overhead | Currency | PA_DLR17_RBS0_STR$ | 17 |
30 | PAUnpostBillN | PA Unposted Billings | Currency | PA_DLR17_RBS0_STR$ | 17 |
31 | PAPostedBillingsN | PA Actual Billings | Currency | PA_DLR17_RBS0_STR$ | 17 |
32 | PAUnposted_Fee_Amount | PA Unposted Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
33 | PAPosted_Fee_Amount | PA Actual Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
34 | PAUnpostedRecogRevN | PA Unposted Recognized Revenue | Currency | PA_DLR17_RBS0_STR$ | 17 |
35 | PAPostRecogRevN | PA Actual Recognized Revenue | Currency | PA_DLR17_RBS0_STR$ | 17 |
36 | PAUNPEIEBAMOUNT | PA Unposted EIEB Amount | Currency | DLR17_RBS0_UTR$ | 17 |
37 | PAPOSEIEBAMOUNT | PA Actual EIEB Amount | Currency | DLR17_RBS0_UTR$ | 17 |
38 | PAUNPOSTBIEEAMOUNT | PA Unposted BIEE Amount | Currency | DLR17_RBS0_UTR$ | 17 |
39 | PAPOSBIEEAMOUNT | PA Actual BIEE Amount | Currency | DLR17_RBS0_UTR$ | 17 |
40 | PAWrite_UpDown_Amount | PA Write Up/Down Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
41 | PA_Unposted_Billed_Reten | PA Unposted Billed Retention | Currency | PA_DLR17_RBS0_STR$ | 17 |
42 | PAUnposted_Project_Fee | PA Unposted Project Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
43 | PAUnposted_Retainer_Fee | PA Unposted Retainer Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
44 | PAUNPOSTRETAMT | PA Unposted Retention Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
45 | PAUnposted_Service_Fee | PA Unposted Service Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
46 | PA_Receipts_Amount | PA Receipts Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
47 | PA_Actual_Receipts_Amoun | PA Actual Receipts Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
48 | PA_Actual_Billed_Retenti | PA Actual Billed Retention | Currency | PA_DLR17_RBS0_STR$ | 17 |
49 | PAPosted_Project_Fee | PA Actual Project Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
50 | PAPosted_Retainer_Fee | PA Actual Retainer Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
51 | PAPOSTRETAMT | PA Actual Retention Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
52 | PAPosted_Service_Fee | PA Actual Service Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
53 | PAFeeAmount | PA Fee Amount | Currency | DLR17_RBSO_STR$ | 17 |
54 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 |
55 | ActualWriteOffAmount | Actual Write Off Amount | Currency | DLR17_RBS0_UTR$ | 17 |
56 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 |
57 | ActualDiscTakenAmount | Actual Discount Taken Amount | 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 | PAPOCost | PA PO Cost | Currency | DLR17_RBS0_UTR$ | 17 |
65 | PAPOQty | PA PO Qty | Currency | DLR15_RBU2 | 15 |
66 | PAPOPostedCost | PA PO Actual Cost | Currency | DLR17_RBS0_UTR$ | 17 |
67 | PAPOPostedQty | PA PO Actual Qty | Currency | PA_DLR15_RBS0_STR | 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_Write_Off_Tax_Amount | PA Write Off Tax Amount | Currency | DLR17_RBS0_STR$ | 17 |
81 | PAActualWOTaxAmt | PA Actual Write Off Tax Amount | Currency | PA_DLR17_RBS0_STR$ | 17 |
82 | PA_Terms_Taken_Tax_Amt | PA Terms Taken Tax Amt | Currency | DLR17_RBS0_STR$ | 17 |
83 | PAActualTermsTakenTax | PA Actual Terms Taken Tax Amt | Currency | PA_DLR17_RBS0_STR$ | 17 |
84 | PAPosted_Earnings | PA Actual Earnings | Currency | PA_DLR17_RBS0_STR$ | 17 |
85 | PAActualCostofEarnings | PA Actual Cost of Earnings | Currency | PA_DLR17_RBS0_STR$ | 17 |
86 | PAUnpostedLossAmount | PA Unposted Loss Amount | Currency | DLR17_RBS0_UTR$ | 17 |
87 | PAActualLossAmount | PA Actual Loss Amount | Currency | DLR17_RBS0_UTR$ | 17 |
88 | PAFQLaborOnly | PA Forecast Quantity - Labor Only | Currency | DLR15_RBU2 | 15 |
89 | PAAQLaborOnly | PA Actual Qty - Labor Only | Currency | PA_DLR15_RBS0_STR | 15 |