PA Budget Master File (PA01301)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Budget Master File
Physical Name: PA01301
Technical Name: PA_Budget_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
2PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
3PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
4PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean20
5PASTAT SearchPA StatusPA_DDL_StatusInteger20
6PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger20
7PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger20
8PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
9PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
10PABaseProfitAmount SearchPA Base Profit AmountDLR17_RBS0_UTR$Currency1017
11PABaseOvhdCost SearchPA Base Overhead CostDLR17_RBS0_UTR$Currency1017
12PAForecastBaseOvrhdAmt SearchPA Forecast Base Overhead AmountDLR17_RBS0_UTR$Currency1017
13PAForecastBaseQty SearchPA Forecast Base QtyDLR15_RBU2Currency1015
14PAForecastBaseUnitCost SearchPA Forecast Base Unit CostDLR17_RBS0_UTR$Currency1017
15PAForecastBaseProfitAmt SearchPA Forecast Base Profit AmountDLR17_RBS0_UTR$Currency1017
16PABBeginDate SearchPA Baseline Begin DateDATEDate46
17PABEndDate SearchPA Baseline End DateDATEDate46
18PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency1015
19PABUnitCost SearchPA Baseline Unit CostDLR17_RBS0_UTR$Currency1017
20PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency1017
21PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency1017
22PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency1017
23PABProfitAmt SearchPA Baseline Profit AmountDLR17_RBS0_UTR$Currency1017
24PABProfitPcnt SearchPA Baseline Profit PercentDLR5_%2Currency108
25PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency1017
26PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency1017
27PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency1017
28PABaselinePTaxOptions SearchPA Baseline Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
29PABaselineCTaxSchedID SearchPA Baseline Cost Tax Schedule IDSTR15_Tax_Schedule_IDString1615
30PABaselineSTaxOptions SearchPA Baseline Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
31PABaselineBTaxSchedID SearchPA Baseline Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
32PAACTUALBEGDATE SearchPA Actual Begin DateDATEDate46
33PA_Actual_End_Date SearchPA Actual End DateDATEDate46
34PAFBeginDate SearchPA Forecast Begin DateDATEDate46
35PAFEndDate SearchPA Forecast End DateDATEDate46
36PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
37PAFUnitCost SearchPA Forecast Unit CostDLR17_RBS0_UTR$Currency1017
38PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
39PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
40PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency1017
41PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency1017
42PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency1017
43PAFProfitAmt SearchPA Forecast Profit AmountDLR17_RBS0_UTR$Currency1017
44PAFProfitPcnt SearchPA Forecast Profit PercentDLR5_%2Currency108
45PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency1017
46PAForecastPTaxOptions SearchPA Forecast Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
47PAForecastCTaxSchedID SearchPA Forecast Cost Tax Schedule IDSTR15_Tax_Schedule_IDString1615
48PAForecastSTaxOptions SearchPA Forecast Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
49PAForecastBTaxSchedID SearchPA Forecast Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
50PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString108
51UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Budget Master File'].UOMSCHDL AS 'PA Budget Master File-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA01301 AS ['PA Budget Master File']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Budget Master File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
52PAUOfMMult SearchPA UOfM MultiplierDLR17_QTY_RBS0_UTRCurrency1017
53DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
54PAPay_Code_Hourly SearchPA Pay Code HourlySTR6_Payroll_CodeString86
55PAPay_Code_Salary SearchPA Pay Code SalarySTR6_Payroll_CodeString86
56DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
57PALabor_Rate_Table_ID SearchPA Labor Rate Table IDSTR30_Rate_Table_IDString3230
58PALabor_RateTable_Type SearchPA Labor Rate Table TypePA_DDL_Rate_Table_TypeInteger20
59PALabor_Rate_Table_Acc SearchPA Labor Rate Table AcceptCB_Rate_Table_AcceptBoolean20
60PAEquip_Rate_Table_ID SearchPA Equip Rate Table IDSTR30_Rate_Table_IDString3230
61PAEquip_Rate_Table_Acc SearchPA Equip Rate Table AcceptCB_Rate_Table_AcceptBoolean20
62TM_WIP_SRC SearchTM WIP SRCDDL_AccountSourceInteger20
63TM_COGS_SRC SearchTM COGS SRCDDL_AccountSourceInteger20
64TM_Cost_Contra_SRC SearchTM Cost Contra SRCDDL_AccountSourceInteger20
65TM_Unbilled_AR_SRC SearchTM Unbilled AR SRCDDL_AccountSourceInteger20
66TM_Unbilled_Rev_SRC SearchTM Unbilled Rev SRCDDL_AccountSourceInteger20
67TM_AR_SRC SearchTM AR SRCDDL_AccountSourceInteger20
68TM_Prj_Rev_SRC SearchTM Prj Rev SRCDDL_AccountSourceInteger20
69TM_OVHD_SRC SearchTM OVHD SRCDDL_AccountSourceInteger20
70FF_WIP_SRC SearchFF WIP SRCDDL_AccountSourceInteger20
71FF_Cost_Contra_SRC SearchFF Cost Contra SRCDDL_AccountSourceInteger20
72FF_AR_SRC SearchFF AR SRCDDL_AccountSourceInteger20
73FF_Prj_Billings_SRC SearchFF Prj Billings SRCDDL_AccountSourceInteger20
74FF_Prj_Expense_SRC SearchFF Prj Expense SRCDDL_AccountSourceInteger20
75FF_Prj_Revenue_SRC SearchFF Prj Revenue SRCDDL_AccountSourceInteger20
76FF_Prj_Loss_SRC SearchFF Prj Loss SRCDDL_AccountSourceInteger20
77FF_BIEE_SRC SearchFF BIEE SRCDDL_AccountSourceInteger20
78FF_EIEB_SRC SearchFF EIEB SRCDDL_AccountSourceInteger20
79FF_OVHD_SRC SearchFF OVHD SRCDDL_AccountSourceInteger20
80PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
81PAOverheadRateMethod SearchPA Overhead Rate MethodGBInteger20
82PABaselineOvhdAmtPerUnit SearchPA Baseline Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
83PABaselineOvrhdPct SearchPA Baseline Overhead PercentageDLR5_%2Currency108
84PAForecastOvrhdAmtPerUnt SearchPA Forecast Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
85PAForecastOvrhdPct SearchPA Forecast Overhead PercentageDLR5_%2Currency108
86PAUBeginDate SearchPA Unposted Begin DateDATEDate46
87PAUEndDate SearchPA Unposted End DateDATEDate46
88PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency1015
89PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency1017
90PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency1017
91PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency1017
92PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency1017
93PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
94PAUnpostedCommitedQty SearchPA Unposted Commited QtyDLR15_RBU2Currency1015
95PAUnpostedCommitedCost SearchPA Unposted Commited CostDLR17_RBS0_UTR$Currency1017
96PAUnpostedCommitedTaxAmt SearchPA Unposted Commited Tax AmountPA_DLR17_RBS0_STR$Currency1017
97PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency1017
98PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency1017
99PAunpostbillamt SearchPA Unposted Billed AmountDLR17_RBS0_UTR$Currency1017
100PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
101PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
102PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency1017
103PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency1017
104PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency1017
105PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
106PAPostedCommitedQty SearchPA Actual Commited QtyDLR15_RBU2Currency1015
107PAPostedCommitedCost SearchPA Actual Commited CostDLR17_RBS0_UTR$Currency1017
108PAPostedCommitedTaxAmt SearchPA Actual Commited Tax AmountPA_DLR17_RBS0_STR$Currency1017
109PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
110PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency1017
111PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency1017
112PApostbillamt SearchPA Actual Billed AmountDLR17_RBS0_UTR$Currency1017
113PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency1017
114PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency1015
115PABilled_Cost SearchPA Billed CostPA_DLR17_RBS0_STR$Currency1017
116PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
117PACostPcntCompleted SearchPA Cost Percent CompletedDLR5_%2Currency108
118PAQuantityPcntCompleted SearchPA Quantity Percent CompletedDLR5_%2Currency108
119PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency1017
120PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency1017
121PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency1017
122PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
123PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency1017
124PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
125PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
126PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
127PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
128PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
129PABCWPAMT SearchPA BCWP AmountPA_DLR17_RBS0_STR$Currency1017
130PABCWSAMT SearchPA BCWS AmountPA_DLR17_RBS0_STR$Currency1017
131PAACWPAMT SearchPA ACWP AmountPA_DLR17_RBS0_STR$Currency1017
132LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
133PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
134PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
135PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
136PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
137PAApproved_Cost SearchPA Approved CostPA_DLR17_RBS0_STR$Currency1017
138PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency1015
139PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency1017
140PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency1015
141PAPOQty SearchPA PO QtyDLR15_RBU2Currency1015
142PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency1017
143PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency1015
144PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency1017
145WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
146ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
147DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
148ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
149PAsfid SearchPA Source File IDINT3Integer23
150PAPreviouslyOpen SearchPA Previously OpenBooleanBoolean20
151PAtaxpaidamt SearchPA Tax Paid AmountDLR17_RBS0_UTR$Currency1017
152PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency1017
153PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
154PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency1017
155PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency1017
156PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency1017
157PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency1017
158PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency1017
159PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
160PAUNAPPRVPROJAMT SearchPA Unapproved Project AmountPA_DLR17_RBS0_STR$Currency1017
161PAUNAPFRTOTBILL SearchPA Unapproved Forecast Total BillingsPA_DLR17_RBS0_STR$Currency1017
162PAUNAPPFRTOTCST SearchPA Unapproved Forecast Total CostPA_DLR17_RBS0_STR$Currency1017
163PAUNFRCTOTPROF SearchPA Unapproved Forecast Total ProfitPA_DLR17_RBS0_STR$Currency1017
164PAUNPFRTOTQTY SearchPA Unapproved Forecast Total QtyPA_DLR15_RBS0_STRCurrency1015
165PAUNABSTOTBILL SearchPA Unapproved Baseline Total BillingsPA_DLR17_RBS0_STR$Currency1017
166PAUNPBSTOTCST SearchPA Unapproved Baseline Total CostPA_DLR17_RBS0_STR$Currency1017
167PAUNPBSLTOTPROF SearchPA Unapproved Baseline Total ProfitPA_DLR17_RBS0_STR$Currency1017
168PAUNPBSTOTQTY SearchPA Unapproved Baseline Total QtyPA_DLR15_RBS0_STRCurrency1015
169PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency1017
170PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency1017
171PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
172PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency1017
173PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency1017
174PAMCCURNCYID SearchPA MC Currency IDSTR15_Currency_IDString1615
175PAMCBProfitAmt SearchPA MC Baseline Profit AmtPA_DLR17_RBS0_UTR$Currency1017
176PAMCBBillings SearchPA MC Baseline BillingsPA_DLR17_RBS0_UTR$Currency1017
177PAMCFProfitAmt SearchPA MC Forecast Profit AmtPA_DLR17_RBS0_UTR$Currency1017
178PAMCFBillings SearchPA MC Forecast BillingsPA_DLR17_RBS0_UTR$Currency1017
179PAMCBaseProfitAmount SearchPA MC Base Profit AmountPA_DLR17_RBS0_UTR$Currency1017
180PAMCForecastBProfitAmt SearchPA MC Forecast Base Profit AmountPA_DLR17_RBS0_UTR$Currency1017
181PAMCProjectAmount SearchPA MC Project AmountPA_DLR17_RBS0_UTR$Currency1017
182PAMCActualBillings SearchPA MC Actual BillingsPA_DLR17_RBS0_UTR$Currency1017
183PAMCActualDiscountAmt SearchPA MC Actual Discount AmtPA_DLR17_RBS0_UTR$Currency1017
184PAMCActualSalesTaxAmt SearchPA MC Actual Sales Tax AmtPA_DLR17_RBS0_UTR$Currency1017
185PAMCUnpostBillN SearchPA MC Unposted BillingsPA_DLR17_RBS0_UTR$Currency1017
186PAMCUnpostedDiscount SearchPA MC Unposted Discount AmtPA_DLR17_RBS0_UTR$Currency1017
187PAMCUnpostedSalesTax SearchPA MC Unposted Sales Tax AmtPA_DLR17_RBS0_UTR$Currency1017
188PABILLMIN SearchpaBillMinimumDLR17_RBS0_UTR$Currency1017
189PAMCBILLMIN SearchpaMCBillMinimumDLR17_RBS0_UTR$Currency1017
190DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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