PA Project Master File (PA01201)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Master File
Physical Name: PA01201
Technical Name: PA_Project_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 Project Master File'].CUSTNMBR AS 'PA Project Master File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA01201 AS ['PA Project Master File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Project Master File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
3PAcontid SearchPA Contract IDSTR15_Contract IDString15
4PAprojid SearchPA Project IDSTR15_Project IDString15
5PAprojname SearchPA Project NameSTR30_PTBS Description 1String30
6PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
7PAprjclsid SearchPA Project Class IDSTR15_Project_Class_IDString15
8PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
9PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger0
10PASTAT SearchPA StatusPA_DDL_StatusInteger0
11CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Project Master File'].CURRNIDX AS 'PA Project Master File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PA01201 AS ['PA Project Master File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Project Master File'].CURRNIDX = ['Currency Setup'].CURRNIDX
12PApurordnum SearchPA Purchase Order No.STR17_LBAUString17
13PABBeginDate SearchPA Baseline Begin DateDATEDate6
14PABEndDate SearchPA Baseline End DateDATEDate6
15PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency15
16PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency17
17PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$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
22PAACTUALBEGDATE SearchPA Actual Begin DateDATEDate6
23PA_Actual_End_Date SearchPA Actual End DateDATEDate6
24PAFBeginDate SearchPA Forecast Begin DateDATEDate6
25PAFEndDate SearchPA Forecast End DateDATEDate6
26PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency15
27PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency17
28PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency17
29PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency17
30PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency17
31PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency17
32PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency17
33PAcloseProjcosts SearchPA Close to Project CostsPA_CB_Close_to_Project_CostsBoolean0
34PAclosetobillings SearchPA Close to BillingsPA_CB_Close_to_BillingsBoolean0
35PADepartment SearchPA DepartmentSTR6_Payroll_CodeString6
36PAEstimatorID SearchPA Estimator IDSTR15_Employee_IDString15
37PAprojmngrid SearchPA Project Manager IDSTR15_Employee_IDString15
38PABusMgrID SearchPA Business Manager IDSTR15_Employee_IDString15
39LOCATNID SearchLocation IDSTR15_Location_IDString15
40SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['PA Project Master File'].SLPRSNID AS 'PA Project Master File-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       PA01201 AS ['PA Project Master File']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['PA Project Master File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
41SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['PA Project Master File'].SALSTERR AS 'PA Project Master File-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       PA01201 AS ['PA Project Master File']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['PA Project Master File'].SALSTERR = ['Sales Territory Master File'].SALSTERR
42COMPRCNT SearchCommission PercentINT5_%2Integer5
43COMAPPTO SearchCommission Applied ToGBInteger0
44CNTCPRSN SearchContact PersonSTR60String60
45PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
46PALabor_Rate_Table_ID SearchPA Labor Rate Table IDSTR30_Rate_Table_IDString30
47PALabor_RateTable_Type SearchPA Labor Rate Table TypePA_DDL_Rate_Table_TypeInteger0
48PALabor_Rate_Table_Acc SearchPA Labor Rate Table AcceptCB_Rate_Table_AcceptBoolean0
49PAEquip_Rate_Table_ID SearchPA Equip Rate Table IDSTR30_Rate_Table_IDString30
50PAEquip_Rate_Table_Acc SearchPA Equip Rate Table AcceptCB_Rate_Table_AcceptBoolean0
51PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger0
52PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency17
53PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency17
54PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
55PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency17
56PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
57ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
58PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString15
59DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
60PA_Retention_Percent SearchPA Retention PercentDLR5_%2Currency8
61PAtotcbts SearchPA Label Checkbox - TSCBBoolean0
62PAtotcbEL SearchPA Label Checkbox - ELCBBoolean0
63PAtotcbML SearchPA Label Checkbox - MLCBBoolean0
64PAtotcbvi SearchPA Label Checkbox - VICBBoolean0
65PAtotcber SearchPA Label Checkbox - EECBBoolean0
66PAtotcbinv SearchPA Label Checkbox - INVCBBoolean0
67PAtotcbfee SearchPA Label Checkbox - FEECBBoolean0
68PAUD1Proj SearchPA User Defined 1 - ProjectSTR50String50
69PAUD2_Proj SearchPA User Defined 2 - ProjectSTR50String50
70PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean0
71PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
72PAbillnoteidxts SearchPA Billing Note Index - TSDLR14Currency14
73PAELbillniteidx SearchPA Billing Note Index - ELDLR14Currency14
74PAbillnoteidxML SearchPA Billing Note Index - MLDLR14Currency14
75PAbillnoteidxvi SearchPA Billing Note Index - VIDLR14Currency14
76PAbillnoteidxee SearchPA Billing Note Index - EEDLR14Currency14
77PAbillnoteidxinv SearchPA Billing Note Index - INVDLR14Currency14
78PAbillnoteidxfee SearchPA Billing Note Index - FEEDLR14Currency14
79PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency15
80PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency17
81PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency17
82PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency17
83PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency17
84PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
85PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency17
86PAUnpostedCommitedQty SearchPA Unposted Commited QtyDLR15_RBU2Currency15
87PAUnpostedCommitedCost SearchPA Unposted Commited CostDLR17_RBS0_UTR$Currency17
88PAUnpostedCommitedTaxAmt SearchPA Unposted Commited Tax AmountPA_DLR17_RBS0_STR$Currency17
89PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency17
90PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
91PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency17
92PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency17
93PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency17
94PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency17
95PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionPA_DLR17_RBS0_STR$Currency17
96PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
97PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
98PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency17
99PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency17
100PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
101PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
102PAPostedCommitedQty SearchPA Actual Commited QtyDLR15_RBU2Currency15
103PAPostedCommitedCost SearchPA Actual Commited CostDLR17_RBS0_UTR$Currency17
104PAPostedCommitedTaxAmt SearchPA Actual Commited Tax AmountPA_DLR17_RBS0_STR$Currency17
105PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency17
106PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
107PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency17
108PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency17
109PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency17
110PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency17
111PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionPA_DLR17_RBS0_STR$Currency17
112PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency17
113PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency15
114PABilled_Cost SearchPA Billed CostPA_DLR17_RBS0_STR$Currency17
115PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
116PACostPcntCompleted SearchPA Cost Percent CompletedDLR5_%2Currency8
117PAQuantityPcntCompleted SearchPA Quantity Percent CompletedDLR5_%2Currency8
118PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency17
119PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency17
120PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency17
121PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency17
122PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency17
123PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
124PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
125PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
126PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
127PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
128PABCWPAMT SearchPA BCWP AmountPA_DLR17_RBS0_STR$Currency17
129PABCWSAMT SearchPA BCWS AmountPA_DLR17_RBS0_STR$Currency17
130PAACWPAMT SearchPA ACWP AmountPA_DLR17_RBS0_STR$Currency17
131NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Project Master File'].NOTEINDX AS 'PA Project Master File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA01201 AS ['PA Project Master File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Project Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
132PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency17
133PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
134PAApproved_Cost SearchPA Approved CostPA_DLR17_RBS0_STR$Currency17
135PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency15
136WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
137ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
138DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
139ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
140PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency17
141PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency15
142PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency17
143PAPOQty SearchPA PO QtyDLR15_RBU2Currency15
144PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency17
145PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency15
146PAtaxpaidamt SearchPA Tax Paid AmountDLR17_RBS0_UTR$Currency17
147PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency17
148PApretainage SearchPA Actual RetainageDLR17_RBS0_UTR$Currency17
149PAunpretainage SearchPA Unposted RetainageDLR17_RBS0_UTR$Currency17
150PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency17
151PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency17
152PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency17
153PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency17
154WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
155SUTASTAT SearchSuta StateSTR2_State_CodeString2
156PA_Actual_Billing_not_RM SearchPA Actual Billing not RMPA_DLR17_RBS0_STR$Currency17
157PA_ActualDiscnotRM SearchPA Actual Discount Dollar not RMPA_DLR17_RBS0_STR$Currency17
158PA_RestrictCustomerList SearchPA Restrict Customer ListPA_CB_Restrict_Customer_ListBoolean0
159PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency17
160PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency17
161PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency17
162PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency17
163PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency15
164PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency15
165PAMCCURNCYID SearchPA MC Currency IDSTR15_Currency_IDString15
166PAMCProjectAmount SearchPA MC Project AmountPA_DLR17_RBS0_UTR$Currency17
167PAMCUnpostBillN SearchPA MC Unposted BillingsPA_DLR17_RBS0_UTR$Currency17
168PAMCUnpostedSalesTax SearchPA MC Unposted Sales Tax AmtPA_DLR17_RBS0_UTR$Currency17
169PAMCUnpostedDiscount SearchPA MC Unposted Discount AmtPA_DLR17_RBS0_UTR$Currency17
170PAMCActualBillings SearchPA MC Actual BillingsPA_DLR17_RBS0_UTR$Currency17
171PAMCActualSalesTaxAmt SearchPA MC Actual Sales Tax AmtPA_DLR17_RBS0_UTR$Currency17
172PAMCActualDiscountAmt SearchPA MC Actual Discount AmtPA_DLR17_RBS0_UTR$Currency17
173PAMCBBillings SearchPA MC Baseline BillingsPA_DLR17_RBS0_UTR$Currency17
174PAMCFBillings SearchPA MC Forecast BillingsPA_DLR17_RBS0_UTR$Currency17
175PA_MC_Project_Fee_Amount SearchPA MC Project Fee AmountPA_DLR17_RBS0_UTR$Currency17
176PA_MC_Service_Fee_Amount SearchPA MC Service Fee AmountPA_DLR17_RBS0_UTR$Currency17
177PA_MC_Retainer_Fee_Amt SearchPA MC Retainer Fee AmountPA_DLR17_RBS0_UTR$Currency17
178PA_MC_UnpostedProjectFee SearchPA MC Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency17
179PA_MC_Unposted_Retainer SearchPA MC Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
180PA_MC_UnpostedServiceFee SearchPA MC Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency17
181PA_MC_Actual_Project_Fee SearchPA MC Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency17
182PA_MC_Actual_RetainerFee SearchPA MC Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency17
183PA_MC_Actual_Service_Fee SearchPA MC Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency17
184PANOTIFBILL SearchpaNotificationForBillingPA_CB_Notification_For_BillingBoolean0
185DEX_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.

Leave a Reply

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