PA Project Master File (PA01201)

azurecurve Products Project Accounting (258)ProjectPA 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	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
2	PACONTNUMBER	PA Contract Number	String	STR10_LBAU	10
3	PAcontid	PA Contract ID	String	STR15_Contract ID	15
4	PAprojid	PA Project ID	String	STR15_Project ID	15
5	PAprojname	PA Project Name	String	STR30_PTBS Description 1	30
6	PAPROJNUMBER	PA Project Number	String	STR15_LBAU	15
7	PAprjclsid	PA Project Class ID	String	STR15_Project_Class_ID	15
8	PAProjectType	PA Project Type	Integer	PA_DDL_Project_Type	0
9	PAAcctgMethod	PA Accounting Method	Integer	PA_DDL_Accounting_Method	0
10	PASTAT	PA Status	Integer	PA_DDL_Status	0
11	CURRNIDX	Currency Index	Integer	INT3	3
	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
12	PApurordnum	PA Purchase Order No.	String	STR17_LBAU	17
13	PABBeginDate	PA Baseline Begin Date	Date	DATE	6
14	PABEndDate	PA Baseline End Date	Date	DATE	6
15	PABQuantity	PA Baseline Quantity	Currency	DLR15_RBU2	15
16	PABTotalCost	PA Baseline Total Cost	Currency	DLR17_RBS0_UTR$	17
17	PABProfit	PA Baseline Profit	Currency	DLR17_RBS0_STR$	17
18	PABBillings	PA Baseline Billings	Currency	DLR17_RBS0_UTR$	17
19	PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
20	PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
21	PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	DLR17_RBS0_UTR$	17
22	PAACTUALBEGDATE	PA Actual Begin Date	Date	DATE	6
23	PA_Actual_End_Date	PA Actual End Date	Date	DATE	6
24	PAFBeginDate	PA Forecast Begin Date	Date	DATE	6
25	PAFEndDate	PA Forecast End Date	Date	DATE	6
26	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
27	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
28	PAFProfit	PA Forecast Profit	Currency	DLR17_RBS0_STR$	17
29	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
30	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
31	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
32	PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	DLR17_RBS0_UTR$	17
33	PAcloseProjcosts	PA Close to Project Costs	Boolean	PA_CB_Close_to_Project_Costs	0
34	PAclosetobillings	PA Close to Billings	Boolean	PA_CB_Close_to_Billings	0
35	PADepartment	PA Department	String	STR6_Payroll_Code	6
36	PAEstimatorID	PA Estimator ID	String	STR15_Employee_ID	15
37	PAprojmngrid	PA Project Manager ID	String	STR15_Employee_ID	15
38	PABusMgrID	PA Business Manager ID	String	STR15_Employee_ID	15
39	LOCATNID	Location ID	String	STR15_Location_ID	15
40	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	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
41	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	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
42	COMPRCNT	Commission Percent	Integer	INT5_%2	5
43	COMAPPTO	Commission Applied To	Integer	GB	0
44	CNTCPRSN	Contact Person	String	STR60	60
45	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
46	PALabor_Rate_Table_ID	PA Labor Rate Table ID	String	STR30_Rate_Table_ID	30
47	PALabor_RateTable_Type	PA Labor Rate Table Type	Integer	PA_DDL_Rate_Table_Type	0
48	PALabor_Rate_Table_Acc	PA Labor Rate Table Accept	Boolean	CB_Rate_Table_Accept	0
49	PAEquip_Rate_Table_ID	PA Equip Rate Table ID	String	STR30_Rate_Table_ID	30
50	PAEquip_Rate_Table_Acc	PA Equip Rate Table Accept	Boolean	CB_Rate_Table_Accept	0
51	PAbllngtype	PA Billing Type	Integer	PA_DDL_Billing_Type	0
52	PAService_Fee_Amount	PA Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
53	PAProject_Fee_Amount	PA Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
54	PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
55	PARetentionFeeAmount	PA Retention Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
56	PAProject_Amount	PA Project Amount	Currency	DLR17_RBS0_UTR$	17
57	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
58	PABILLFORMAT	PA Bill Format	String	STR15_LBAU	15
59	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
60	PA_Retention_Percent	PA Retention Percent	Currency	DLR5_%2	8
61	PAtotcbts	PA Label Checkbox - TS	Boolean	CB	0
62	PAtotcbEL	PA Label Checkbox - EL	Boolean	CB	0
63	PAtotcbML	PA Label Checkbox - ML	Boolean	CB	0
64	PAtotcbvi	PA Label Checkbox - VI	Boolean	CB	0
65	PAtotcber	PA Label Checkbox - EE	Boolean	CB	0
66	PAtotcbinv	PA Label Checkbox - INV	Boolean	CB	0
67	PAtotcbfee	PA Label Checkbox - FEE	Boolean	CB	0
68	PAUD1Proj	PA User Defined 1 - Project	String	STR50	50
69	PAUD2_Proj	PA User Defined 2 - Project	String	STR50	50
70	PASegmentCB	PA Segment CB	Boolean	PA_CB_Segment	0
71	PAbillnoteidx	PA Billing Note Index	Currency	DLR14	14
72	PAbillnoteidxts	PA Billing Note Index - TS	Currency	DLR14	14
73	PAELbillniteidx	PA Billing Note Index - EL	Currency	DLR14	14
74	PAbillnoteidxML	PA Billing Note Index - ML	Currency	DLR14	14
75	PAbillnoteidxvi	PA Billing Note Index - VI	Currency	DLR14	14
76	PAbillnoteidxee	PA Billing Note Index - EE	Currency	DLR14	14
77	PAbillnoteidxinv	PA Billing Note Index - INV	Currency	DLR14	14
78	PAbillnoteidxfee	PA Billing Note Index - FEE	Currency	DLR14	14
79	PAUnpostedQty	PA Unposted Qty	Currency	PA_DLR15_RBS0_STR	15
80	PAUnpostedTotalCostN	PA Unposted Total Cost	Currency	PA_DLR17_RBS0_STR$	17
81	PAUnposted_Overhead	PA Unposted Overhead	Currency	PA_DLR17_RBS0_STR$	17
82	PAUnpostedProfitN	PA Unposted Profit	Currency	PA_DLR17_RBS0_STR$	17
83	PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
84	PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
85	PAUnpostedRecogRevN	PA Unposted Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
86	PAUnpostedCommitedQty	PA Unposted Commited Qty	Currency	DLR15_RBU2	15
87	PAUnpostedCommitedCost	PA Unposted Commited Cost	Currency	DLR17_RBS0_UTR$	17
88	PAUnpostedCommitedTaxAmt	PA Unposted Commited Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
89	PAUnposted_Project_Fee	PA Unposted Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
90	PAUnposted_Retainer_Fee	PA Unposted Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
91	PAUnposted_Service_Fee	PA Unposted Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
92	PAUNPOSTRETAMT	PA Unposted Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
93	PAUNPOSTBIEEAMOUNT	PA Unposted BIEE Amount	Currency	DLR17_RBS0_UTR$	17
94	PAUNPEIEBAMOUNT	PA Unposted EIEB Amount	Currency	DLR17_RBS0_UTR$	17
95	PA_Unposted_Billed_Reten	PA Unposted Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
96	PAPostedQty	PA Actual Qty	Currency	PA_DLR15_RBS0_STR	15
97	PAPostedTotalCostN	PA Actual Total Cost	Currency	PA_DLR17_RBS0_STR$	17
98	PAPostedProfitN	PA Actual Profit	Currency	PA_DLR17_RBS0_STR$	17
99	PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
100	PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
101	PAPostRecogRevN	PA Actual Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
102	PAPostedCommitedQty	PA Actual Commited Qty	Currency	DLR15_RBU2	15
103	PAPostedCommitedCost	PA Actual Commited Cost	Currency	DLR17_RBS0_UTR$	17
104	PAPostedCommitedTaxAmt	PA Actual Commited Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
105	PAPosted_Project_Fee	PA Actual Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
106	PAPosted_Retainer_Fee	PA Actual Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
107	PAPosted_Service_Fee	PA Actual Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
108	PAPOSTRETAMT	PA Actual Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
109	PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	DLR17_RBS0_UTR$	17
110	PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	DLR17_RBS0_UTR$	17
111	PA_Actual_Billed_Retenti	PA Actual Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
112	PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	PA_DLR17_RBS0_STR$	17
113	PABilled_QtyN	PA Billed Qty	Currency	PA_DLR15_RBS0_STR	15
114	PABilled_Cost	PA Billed Cost	Currency	PA_DLR17_RBS0_STR$	17
115	PABilled_Accrued_Revenu	PA Billed Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
116	PACostPcntCompleted	PA Cost Percent Completed	Currency	DLR5_%2	8
117	PAQuantityPcntCompleted	PA Quantity Percent Completed	Currency	DLR5_%2	8
118	PA_Receipts_Amount	PA Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
119	PA_Actual_Receipts_Amoun	PA Actual Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
120	PA_Earnings	PA Earnings	Currency	PA_DLR17_RBS0_STR$	17
121	PA_Cost_of_Earnings	PA Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
122	PAUnpostBillN	PA Unposted Billings	Currency	PA_DLR17_RBS0_STR$	17
123	PAUnpostDiscDolAmtN	PA Unposted Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
124	PAUnposted_Sales_Tax_Am	PA Unposted Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
125	PAPostedBillingsN	PA Actual Billings	Currency	PA_DLR17_RBS0_STR$	17
126	PAPostedDiscDolAmtN	PA Actual Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
127	PAPosted_Sales_Tax_Amou	PA Actual Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
128	PABCWPAMT	PA BCWP Amount	Currency	PA_DLR17_RBS0_STR$	17
129	PABCWSAMT	PA BCWS Amount	Currency	PA_DLR17_RBS0_STR$	17
130	PAACWPAMT	PA ACWP Amount	Currency	PA_DLR17_RBS0_STR$	17
131	NOTEINDX	Note Index	Currency	DLR14	14
	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
132	PAPosted_Overhead	PA Actual Overhead	Currency	PA_DLR17_RBS0_STR$	17
133	PAApproved_Accrued_Reve	PA Approved Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
134	PAApproved_Cost	PA Approved Cost	Currency	PA_DLR17_RBS0_STR$	17
135	PAApproved_Quantity	PA Approved Quantity	Currency	PA_DLR15_RBS0_STR	15
136	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
137	ActualWriteOffAmount	Actual Write Off Amount	Currency	DLR17_RBS0_UTR$	17
138	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
139	ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
140	PACommitted_Costs	PA Committed Costs	Currency	DLR17_RBS0_UTR$	17
141	PACommitted_Qty	PA Committed Qty	Currency	DLR15_RBU2	15
142	PAPOCost	PA PO Cost	Currency	DLR17_RBS0_UTR$	17
143	PAPOQty	PA PO Qty	Currency	DLR15_RBU2	15
144	PAPOPostedCost	PA PO Actual Cost	Currency	DLR17_RBS0_UTR$	17
145	PAPOPostedQty	PA PO Actual Qty	Currency	PA_DLR15_RBS0_STR	15
146	PAtaxpaidamt	PA Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
147	PAPostedTaxPaidN	PA Actual Tax Paid	Currency	PA_DLR17_RBS0_STR$	17
148	PApretainage	PA Actual Retainage	Currency	DLR17_RBS0_UTR$	17
149	PAunpretainage	PA Unposted Retainage	Currency	DLR17_RBS0_UTR$	17
150	PA_Write_Off_Tax_Amount	PA Write Off Tax Amount	Currency	DLR17_RBS0_STR$	17
151	PAActualWOTaxAmt	PA Actual Write Off Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
152	PA_Terms_Taken_Tax_Amt	PA Terms Taken Tax Amt	Currency	DLR17_RBS0_STR$	17
153	PAActualTermsTakenTax	PA Actual Terms Taken Tax Amt	Currency	PA_DLR17_RBS0_STR$	17
154	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
155	SUTASTAT	Suta State	String	STR2_State_Code	2
156	PA_Actual_Billing_not_RM	PA Actual Billing not RM	Currency	PA_DLR17_RBS0_STR$	17
157	PA_ActualDiscnotRM	PA Actual Discount Dollar not RM	Currency	PA_DLR17_RBS0_STR$	17
158	PA_RestrictCustomerList	PA Restrict Customer List	Boolean	PA_CB_Restrict_Customer_List	0
159	PAPosted_Earnings	PA Actual Earnings	Currency	PA_DLR17_RBS0_STR$	17
160	PAActualCostofEarnings	PA Actual Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
161	PAUnpostedLossAmount	PA Unposted Loss Amount	Currency	DLR17_RBS0_UTR$	17
162	PAActualLossAmount	PA Actual Loss Amount	Currency	DLR17_RBS0_UTR$	17
163	PAFQLaborOnly	PA Forecast Quantity - Labor Only	Currency	DLR15_RBU2	15
164	PAAQLaborOnly	PA Actual Qty - Labor Only	Currency	PA_DLR15_RBS0_STR	15
165	PAMCCURNCYID	PA MC Currency ID	String	STR15_Currency_ID	15
166	PAMCProjectAmount	PA MC Project Amount	Currency	PA_DLR17_RBS0_UTR$	17
167	PAMCUnpostBillN	PA MC Unposted Billings	Currency	PA_DLR17_RBS0_UTR$	17
168	PAMCUnpostedSalesTax	PA MC Unposted Sales Tax Amt	Currency	PA_DLR17_RBS0_UTR$	17
169	PAMCUnpostedDiscount	PA MC Unposted Discount Amt	Currency	PA_DLR17_RBS0_UTR$	17
170	PAMCActualBillings	PA MC Actual Billings	Currency	PA_DLR17_RBS0_UTR$	17
171	PAMCActualSalesTaxAmt	PA MC Actual Sales Tax Amt	Currency	PA_DLR17_RBS0_UTR$	17
172	PAMCActualDiscountAmt	PA MC Actual Discount Amt	Currency	PA_DLR17_RBS0_UTR$	17
173	PAMCBBillings	PA MC Baseline Billings	Currency	PA_DLR17_RBS0_UTR$	17
174	PAMCFBillings	PA MC Forecast Billings	Currency	PA_DLR17_RBS0_UTR$	17
175	PA_MC_Project_Fee_Amount	PA MC Project Fee Amount	Currency	PA_DLR17_RBS0_UTR$	17
176	PA_MC_Service_Fee_Amount	PA MC Service Fee Amount	Currency	PA_DLR17_RBS0_UTR$	17
177	PA_MC_Retainer_Fee_Amt	PA MC Retainer Fee Amount	Currency	PA_DLR17_RBS0_UTR$	17
178	PA_MC_UnpostedProjectFee	PA MC Unposted Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
179	PA_MC_Unposted_Retainer	PA MC Unposted Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
180	PA_MC_UnpostedServiceFee	PA MC Unposted Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
181	PA_MC_Actual_Project_Fee	PA MC Actual Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
182	PA_MC_Actual_RetainerFee	PA MC Actual Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
183	PA_MC_Actual_Service_Fee	PA MC Actual Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
184	PANOTIFBILL	paNotificationForBilling	Boolean	PA_CB_Notification_For_Billing	0

azurecurve Products Project Accounting (258)ProjectPA Project Master File (PA01201)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply