PA Project Master File (PA01201)

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

Product: Project Accounting (258)
Series:

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 NumberStringSTR15_RM_Customer_Number15
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 NumberStringSTR10_LBAU10
3PAcontid SearchPA Contract IDStringSTR15_Contract ID15
4PAprojid SearchPA Project IDStringSTR15_Project ID15
5PAprojname SearchPA Project NameStringSTR30_PTBS Description 130
6PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
7PAprjclsid SearchPA Project Class IDStringSTR15_Project_Class_ID15
8PAProjectType SearchPA Project TypeIntegerPA_DDL_Project_Type0
9PAAcctgMethod SearchPA Accounting MethodIntegerPA_DDL_Accounting_Method0
10PASTAT SearchPA StatusIntegerPA_DDL_Status0
11CURRNIDX SearchCurrency IndexIntegerINT33
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.StringSTR17_LBAU17
13PABBeginDate SearchPA Baseline Begin DateDateDATE6
14PABEndDate SearchPA Baseline End DateDateDATE6
15PABQuantity SearchPA Baseline QuantityCurrencyDLR15_RBU215
16PABTotalCost SearchPA Baseline Total CostCurrencyDLR17_RBS0_UTR$17
17PABProfit SearchPA Baseline ProfitCurrencyDLR17_RBS0_STR$17
18PABBillings SearchPA Baseline BillingsCurrencyDLR17_RBS0_UTR$17
19PABTaxPaidAmt SearchPA Baseline Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
20PABTaxChargedAmt SearchPA Baseline Tax Charged AmountCurrencyDLR17_RBS0_UTR$17
21PABaselineOvhdCost SearchPA Baseline Overhead CostCurrencyDLR17_RBS0_UTR$17
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 QuantityCurrencyDLR15_RBU215
27PAFTotalCost SearchPA Forecast Total CostCurrencyDLR17_RBS0_UTR$17
28PAFProfit SearchPA Forecast ProfitCurrencyDLR17_RBS0_STR$17
29PAFBillings SearchPA Forecast BillingsCurrencyDLR17_RBS0_UTR$17
30PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
31PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountCurrencyDLR17_RBS0_UTR$17
32PAForecastOvhdCost SearchPA Forecast Overhead CostCurrencyDLR17_RBS0_UTR$17
33PAcloseProjcosts SearchPA Close to Project CostsBooleanPA_CB_Close_to_Project_Costs0
34PAclosetobillings SearchPA Close to BillingsBooleanPA_CB_Close_to_Billings0
35PADepartment SearchPA DepartmentStringSTR6_Payroll_Code6
36PAEstimatorID SearchPA Estimator IDStringSTR15_Employee_ID15
37PAprojmngrid SearchPA Project Manager IDStringSTR15_Employee_ID15
38PABusMgrID SearchPA Business Manager IDStringSTR15_Employee_ID15
39LOCATNID SearchLocation IDStringSTR15_Location_ID15
40SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
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 TerritoryStringSTR15_Sales_Territory15
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 PercentIntegerINT5_%25
43COMAPPTO SearchCommission Applied ToIntegerGB0
44CNTCPRSN SearchContact PersonStringSTR6060
45PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
46PALabor_Rate_Table_ID SearchPA Labor Rate Table IDStringSTR30_Rate_Table_ID30
47PALabor_RateTable_Type SearchPA Labor Rate Table TypeIntegerPA_DDL_Rate_Table_Type0
48PALabor_Rate_Table_Acc SearchPA Labor Rate Table AcceptBooleanCB_Rate_Table_Accept0
49PAEquip_Rate_Table_ID SearchPA Equip Rate Table IDStringSTR30_Rate_Table_ID30
50PAEquip_Rate_Table_Acc SearchPA Equip Rate Table AcceptBooleanCB_Rate_Table_Accept0
51PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
52PAService_Fee_Amount SearchPA Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
53PAProject_Fee_Amount SearchPA Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
54PARetainer_Fee_Amount SearchPA Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
55PARetentionFeeAmount SearchPA Retention Fee AmountCurrencyPA_DLR17_RBS0_STR$17
56PAProject_Amount SearchPA Project AmountCurrencyDLR17_RBS0_UTR$17
57ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
58PABILLFORMAT SearchPA Bill FormatStringSTR15_LBAU15
59DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
60PA_Retention_Percent SearchPA Retention PercentCurrencyDLR5_%28
61PAtotcbts SearchPA Label Checkbox - TSBooleanCB0
62PAtotcbEL SearchPA Label Checkbox - ELBooleanCB0
63PAtotcbML SearchPA Label Checkbox - MLBooleanCB0
64PAtotcbvi SearchPA Label Checkbox - VIBooleanCB0
65PAtotcber SearchPA Label Checkbox - EEBooleanCB0
66PAtotcbinv SearchPA Label Checkbox - INVBooleanCB0
67PAtotcbfee SearchPA Label Checkbox - FEEBooleanCB0
68PAUD1Proj SearchPA User Defined 1 - ProjectStringSTR5050
69PAUD2_Proj SearchPA User Defined 2 - ProjectStringSTR5050
70PASegmentCB SearchPA Segment CBBooleanPA_CB_Segment0
71PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
72PAbillnoteidxts SearchPA Billing Note Index - TSCurrencyDLR1414
73PAELbillniteidx SearchPA Billing Note Index - ELCurrencyDLR1414
74PAbillnoteidxML SearchPA Billing Note Index - MLCurrencyDLR1414
75PAbillnoteidxvi SearchPA Billing Note Index - VICurrencyDLR1414
76PAbillnoteidxee SearchPA Billing Note Index - EECurrencyDLR1414
77PAbillnoteidxinv SearchPA Billing Note Index - INVCurrencyDLR1414
78PAbillnoteidxfee SearchPA Billing Note Index - FEECurrencyDLR1414
79PAUnpostedQty SearchPA Unposted QtyCurrencyPA_DLR15_RBS0_STR15
80PAUnpostedTotalCostN SearchPA Unposted Total CostCurrencyPA_DLR17_RBS0_STR$17
81PAUnposted_Overhead SearchPA Unposted OverheadCurrencyPA_DLR17_RBS0_STR$17
82PAUnpostedProfitN SearchPA Unposted ProfitCurrencyPA_DLR17_RBS0_STR$17
83PAUnposted_Tax_Amount SearchPA Unposted Tax AmountCurrencyPA_DLR17_RBS0_STR$17
84PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
85PAUnpostedRecogRevN SearchPA Unposted Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
86PAUnpostedCommitedQty SearchPA Unposted Commited QtyCurrencyDLR15_RBU215
87PAUnpostedCommitedCost SearchPA Unposted Commited CostCurrencyDLR17_RBS0_UTR$17
88PAUnpostedCommitedTaxAmt SearchPA Unposted Commited Tax AmountCurrencyPA_DLR17_RBS0_STR$17
89PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
90PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
91PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
92PAUNPOSTRETAMT SearchPA Unposted Retention AmountCurrencyPA_DLR17_RBS0_STR$17
93PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountCurrencyDLR17_RBS0_UTR$17
94PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountCurrencyDLR17_RBS0_UTR$17
95PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionCurrencyPA_DLR17_RBS0_STR$17
96PAPostedQty SearchPA Actual QtyCurrencyPA_DLR15_RBS0_STR15
97PAPostedTotalCostN SearchPA Actual Total CostCurrencyPA_DLR17_RBS0_STR$17
98PAPostedProfitN SearchPA Actual ProfitCurrencyPA_DLR17_RBS0_STR$17
99PAPosted_Tax_Amount SearchPA Actual Tax AmountCurrencyPA_DLR17_RBS0_STR$17
100PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
101PAPostRecogRevN SearchPA Actual Recognized RevenueCurrencyPA_DLR17_RBS0_STR$17
102PAPostedCommitedQty SearchPA Actual Commited QtyCurrencyDLR15_RBU215
103PAPostedCommitedCost SearchPA Actual Commited CostCurrencyDLR17_RBS0_UTR$17
104PAPostedCommitedTaxAmt SearchPA Actual Commited Tax AmountCurrencyPA_DLR17_RBS0_STR$17
105PAPosted_Project_Fee SearchPA Actual Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
106PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
107PAPosted_Service_Fee SearchPA Actual Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
108PAPOSTRETAMT SearchPA Actual Retention AmountCurrencyPA_DLR17_RBS0_STR$17
109PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountCurrencyDLR17_RBS0_UTR$17
110PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountCurrencyDLR17_RBS0_UTR$17
111PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionCurrencyPA_DLR17_RBS0_STR$17
112PAWrite_UpDown_Amount SearchPA Write Up/Down AmountCurrencyPA_DLR17_RBS0_STR$17
113PABilled_QtyN SearchPA Billed QtyCurrencyPA_DLR15_RBS0_STR15
114PABilled_Cost SearchPA Billed CostCurrencyPA_DLR17_RBS0_STR$17
115PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
116PACostPcntCompleted SearchPA Cost Percent CompletedCurrencyDLR5_%28
117PAQuantityPcntCompleted SearchPA Quantity Percent CompletedCurrencyDLR5_%28
118PA_Receipts_Amount SearchPA Receipts AmountCurrencyPA_DLR17_RBS0_STR$17
119PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountCurrencyPA_DLR17_RBS0_STR$17
120PA_Earnings SearchPA EarningsCurrencyPA_DLR17_RBS0_STR$17
121PA_Cost_of_Earnings SearchPA Cost of EarningsCurrencyPA_DLR17_RBS0_STR$17
122PAUnpostBillN SearchPA Unposted BillingsCurrencyPA_DLR17_RBS0_STR$17
123PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountCurrencyPA_DLR17_RBS0_STR$17
124PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountCurrencyPA_DLR17_RBS0_STR$17
125PAPostedBillingsN SearchPA Actual BillingsCurrencyPA_DLR17_RBS0_STR$17
126PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountCurrencyPA_DLR17_RBS0_STR$17
127PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountCurrencyPA_DLR17_RBS0_STR$17
128PABCWPAMT SearchPA BCWP AmountCurrencyPA_DLR17_RBS0_STR$17
129PABCWSAMT SearchPA BCWS AmountCurrencyPA_DLR17_RBS0_STR$17
130PAACWPAMT SearchPA ACWP AmountCurrencyPA_DLR17_RBS0_STR$17
131NOTEINDX SearchNote IndexCurrencyDLR1414
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 OverheadCurrencyPA_DLR17_RBS0_STR$17
133PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
134PAApproved_Cost SearchPA Approved CostCurrencyPA_DLR17_RBS0_STR$17
135PAApproved_Quantity SearchPA Approved QuantityCurrencyPA_DLR15_RBS0_STR15
136WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
137ActualWriteOffAmount SearchActual Write Off AmountCurrencyDLR17_RBS0_UTR$17
138DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
139ActualDiscTakenAmount SearchActual Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
140PACommitted_Costs SearchPA Committed CostsCurrencyDLR17_RBS0_UTR$17
141PACommitted_Qty SearchPA Committed QtyCurrencyDLR15_RBU215
142PAPOCost SearchPA PO CostCurrencyDLR17_RBS0_UTR$17
143PAPOQty SearchPA PO QtyCurrencyDLR15_RBU215
144PAPOPostedCost SearchPA PO Actual CostCurrencyDLR17_RBS0_UTR$17
145PAPOPostedQty SearchPA PO Actual QtyCurrencyPA_DLR15_RBS0_STR15
146PAtaxpaidamt SearchPA Tax Paid AmountCurrencyDLR17_RBS0_UTR$17
147PAPostedTaxPaidN SearchPA Actual Tax PaidCurrencyPA_DLR17_RBS0_STR$17
148PApretainage SearchPA Actual RetainageCurrencyDLR17_RBS0_UTR$17
149PAunpretainage SearchPA Unposted RetainageCurrencyDLR17_RBS0_UTR$17
150PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountCurrencyDLR17_RBS0_STR$17
151PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountCurrencyPA_DLR17_RBS0_STR$17
152PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtCurrencyDLR17_RBS0_STR$17
153PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtCurrencyPA_DLR17_RBS0_STR$17
154WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
155SUTASTAT SearchSuta StateStringSTR2_State_Code2
156PA_Actual_Billing_not_RM SearchPA Actual Billing not RMCurrencyPA_DLR17_RBS0_STR$17
157PA_ActualDiscnotRM SearchPA Actual Discount Dollar not RMCurrencyPA_DLR17_RBS0_STR$17
158PA_RestrictCustomerList SearchPA Restrict Customer ListBooleanPA_CB_Restrict_Customer_List0
159PAPosted_Earnings SearchPA Actual EarningsCurrencyPA_DLR17_RBS0_STR$17
160PAActualCostofEarnings SearchPA Actual Cost of EarningsCurrencyPA_DLR17_RBS0_STR$17
161PAUnpostedLossAmount SearchPA Unposted Loss AmountCurrencyDLR17_RBS0_UTR$17
162PAActualLossAmount SearchPA Actual Loss AmountCurrencyDLR17_RBS0_UTR$17
163PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyCurrencyDLR15_RBU215
164PAAQLaborOnly SearchPA Actual Qty - Labor OnlyCurrencyPA_DLR15_RBS0_STR15
165PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
166PAMCProjectAmount SearchPA MC Project AmountCurrencyPA_DLR17_RBS0_UTR$17
167PAMCUnpostBillN SearchPA MC Unposted BillingsCurrencyPA_DLR17_RBS0_UTR$17
168PAMCUnpostedSalesTax SearchPA MC Unposted Sales Tax AmtCurrencyPA_DLR17_RBS0_UTR$17
169PAMCUnpostedDiscount SearchPA MC Unposted Discount AmtCurrencyPA_DLR17_RBS0_UTR$17
170PAMCActualBillings SearchPA MC Actual BillingsCurrencyPA_DLR17_RBS0_UTR$17
171PAMCActualSalesTaxAmt SearchPA MC Actual Sales Tax AmtCurrencyPA_DLR17_RBS0_UTR$17
172PAMCActualDiscountAmt SearchPA MC Actual Discount AmtCurrencyPA_DLR17_RBS0_UTR$17
173PAMCBBillings SearchPA MC Baseline BillingsCurrencyPA_DLR17_RBS0_UTR$17
174PAMCFBillings SearchPA MC Forecast BillingsCurrencyPA_DLR17_RBS0_UTR$17
175PA_MC_Project_Fee_Amount SearchPA MC Project Fee AmountCurrencyPA_DLR17_RBS0_UTR$17
176PA_MC_Service_Fee_Amount SearchPA MC Service Fee AmountCurrencyPA_DLR17_RBS0_UTR$17
177PA_MC_Retainer_Fee_Amt SearchPA MC Retainer Fee AmountCurrencyPA_DLR17_RBS0_UTR$17
178PA_MC_UnpostedProjectFee SearchPA MC Unposted Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
179PA_MC_Unposted_Retainer SearchPA MC Unposted Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
180PA_MC_UnpostedServiceFee SearchPA MC Unposted Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
181PA_MC_Actual_Project_Fee SearchPA MC Actual Project Fee AmountCurrencyPA_DLR17_RBS0_STR$17
182PA_MC_Actual_RetainerFee SearchPA MC Actual Retainer Fee AmountCurrencyPA_DLR17_RBS0_STR$17
183PA_MC_Actual_Service_Fee SearchPA MC Actual Service Fee AmountCurrencyPA_DLR17_RBS0_STR$17
184PANOTIFBILL SearchpaNotificationForBillingBooleanPA_CB_Notification_For_Billing0

Leave a Reply

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