PA Budget Periodic Totals Master File (PA01304)

azurecurveProductsProject Accounting (258)ProjectPA Budget Periodic Totals Master File (PA01304)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Budget Periodic Totals Master File
Physical Name: PA01304
Technical Name: PA_Budget_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
2PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
3PAsfid SearchPA Source File IDINT3Integer3
4PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
5PERIODID SearchPeriod IDINT3Integer3
6YEAR1 SearchYearYearInteger4
7PAPeriodStartDate SearchPA Period Start DateDATEDate6
8PAPeriodEndDate SearchPA Period End DateDATEDate6
9PERIODDT SearchPeriod DateDT_DateDate6
10PAACTUALBEGDATE SearchPA Actual Begin DateDATEDate6
11PA_Actual_End_Date SearchPA Actual End DateDATEDate6
12PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
13PAFeeAmount SearchPA Fee AmountDLR17_RBSO_STR$Currency17
14PABUnitCost SearchPA Baseline Unit CostDLR17_RBS0_UTR$Currency17
15PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
16PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency17
17PABProfitAmt SearchPA Baseline Profit AmountDLR17_RBS0_UTR$Currency17
18PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency17
19PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency17
20PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency17
21PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency17
22PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
23PAFUnitCost SearchPA Forecast Unit CostDLR17_RBS0_UTR$Currency17
24PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
25PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency17
26PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
27PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
28PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
29PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
30LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
31PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency15
32PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency17
33PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency17
34PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency17
35PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency17
36PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
37PAUnpostedCommitedQty SearchPA Unposted Commited QtyDLR15_RBU2Currency15
38PAUnpostedCommitedCost SearchPA Unposted Commited CostDLR17_RBS0_UTR$Currency17
39PAUnpostedCommitedTaxAmt SearchPA Unposted Commited Tax AmountPA_DLR17_RBS0_STR$Currency17
40PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency17
41PAUnposted_Fee_Amount SearchPA Unposted Fee AmountPA_DLR17_RBS0_STR$Currency17
42PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency17
43PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency17
44PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionPA_DLR17_RBS0_STR$Currency17
45PAunpostbillamt SearchPA Unposted Billed AmountDLR17_RBS0_UTR$Currency17
46PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
47PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
48PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency17
49PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency17
50PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency17
51PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
52PAPostedCommitedQty SearchPA Actual Commited QtyDLR15_RBU2Currency15
53PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
54PAPostedCommitedCost SearchPA Actual Commited CostDLR17_RBS0_UTR$Currency17
55PAPostedCommitedTaxAmt SearchPA Actual Commited Tax AmountPA_DLR17_RBS0_STR$Currency17
56PAPosted_Fee_Amount SearchPA Actual Fee AmountPA_DLR17_RBS0_STR$Currency17
57PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency17
58PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency17
59PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionPA_DLR17_RBS0_STR$Currency17
60PApostbillamt SearchPA Actual Billed AmountDLR17_RBS0_UTR$Currency17
61PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency17
62PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency15
63PARemaining_Quantity SearchPA Remaining QuantityPA_DLR15_RBS0_STRCurrency15
64PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency15
65PAApproved_Cost SearchPA Approved CostPA_DLR17_RBS0_STR$Currency17
66PARemaining_Cost SearchPA Remaining CostPA_DLR17_RBS0_STR$Currency17
67PABilled_Cost SearchPA Billed CostPA_DLR17_RBS0_STR$Currency17
68PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
69PARemaining_Accrued_Rev SearchPA Remaining Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
70PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
71PACostPcntCompleted SearchPA Cost Percent CompletedDLR5_%2Currency8
72PAQuantityPcntCompleted SearchPA Quantity Percent CompletedDLR5_%2Currency8
73PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency17
74PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency17
75PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency17
76PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency17
77PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency17
78PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
79PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
80PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
81PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
82PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
83WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
84ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
85DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
86ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
87PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency17
88PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency15
89PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency17
90PAPOQty SearchPA PO QtyDLR15_RBU2Currency15
91PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency17
92PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency15
93PAtaxpaidamt SearchPA Tax Paid AmountDLR17_RBS0_UTR$Currency17
94PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency17
95PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency17
96PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency17
97PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency17
98PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency17
99PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency17
100PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency17
101PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency17
102PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency17
103PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency17
104PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency17
105DEX_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 Budget Periodic Totals Master File (PA01304)

Leave a Reply

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