PA Customer MSTR (PA00501)

azurecurve Products Project Accounting (258)ProjectPA Customer MSTR (PA00501)

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

Product: Project Accounting (258)
Series:

Display Name: PA Customer MSTR
Physical Name: PA00501
Technical Name: PA_Customer_MSTR

Group Display Name: PA Cards
Group Technical Name: PA 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 Customer MSTR'].CUSTNMBR AS 'PA Customer MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM PA00501 AS ['PA Customer MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['PA Customer MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	PAcustalias	PA Customer Alias	String	PA_Str5_LBAU	5
3	PAcloseProjcosts	PA Close to Project Costs	Boolean	PA_CB_Close_to_Project_Costs	0
4	PAclosetobillings	PA Close to Billings	Boolean	PA_CB_Close_to_Billings	0
5	PABILLFORMAT	PA Bill Format	String	STR15_LBAU	15
6	PAUD1	PA User Defined 1	String	STR20	20
7	PAUD2	PA User Defined 2	String	STR20	20
8	PABQuantity	PA Baseline Quantity	Currency	DLR15_RBU2	15
9	PABTotalCost	PA Baseline Total Cost	Currency	DLR17_RBS0_UTR$	17
10	PABBillings	PA Baseline Billings	Currency	DLR17_RBS0_UTR$	17
11	PABProfit	PA Baseline Profit	Currency	DLR17_RBS0_STR$	17
12	PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
13	PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
14	PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	DLR17_RBS0_UTR$	17
15	PAFQuantity	PA Forecast Quantity	Currency	DLR15_RBU2	15
16	PAFTotalCost	PA Forecast Total Cost	Currency	DLR17_RBS0_UTR$	17
17	PAFBillings	PA Forecast Billings	Currency	DLR17_RBS0_UTR$	17
18	PAFProfit	PA Forecast Profit	Currency	DLR17_RBS0_STR$	17
19	PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
20	PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	DLR17_RBS0_UTR$	17
21	PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	DLR17_RBS0_UTR$	17
22	PAProject_Amount	PA Project Amount	Currency	DLR17_RBS0_UTR$	17
23	PAUnpostedQty	PA Unposted Qty	Currency	PA_DLR15_RBS0_STR	15
24	PAUnpostedTotalCostN	PA Unposted Total Cost	Currency	PA_DLR17_RBS0_STR$	17
25	PAUnposted_Overhead	PA Unposted Overhead	Currency	PA_DLR17_RBS0_STR$	17
26	PAUnpostedProfitN	PA Unposted Profit	Currency	PA_DLR17_RBS0_STR$	17
27	PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
28	PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
29	PAUnpostedCommitedQty	PA Unposted Commited Qty	Currency	DLR15_RBU2	15
30	PAUnpostedCommitedCost	PA Unposted Commited Cost	Currency	DLR17_RBS0_UTR$	17
31	PAUnpostedCommitedTaxAmt	PA Unposted Commited Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
32	PAUnpostedRecogRevN	PA Unposted Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
33	PAUnposted_Project_Fee	PA Unposted Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
34	PAUnposted_Retainer_Fee	PA Unposted Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
35	PAUnposted_Service_Fee	PA Unposted Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
36	PAUNPOSTRETAMT	PA Unposted Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
37	PA_Unposted_Billed_Reten	PA Unposted Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
38	PAUNPOSTBIEEAMOUNT	PA Unposted BIEE Amount	Currency	DLR17_RBS0_UTR$	17
39	PAUNPEIEBAMOUNT	PA Unposted EIEB Amount	Currency	DLR17_RBS0_UTR$	17
40	PAPostedQty	PA Actual Qty	Currency	PA_DLR15_RBS0_STR	15
41	PAPostedTotalCostN	PA Actual Total Cost	Currency	PA_DLR17_RBS0_STR$	17
42	PAPosted_Overhead	PA Actual Overhead	Currency	PA_DLR17_RBS0_STR$	17
43	PAPostedProfitN	PA Actual Profit	Currency	PA_DLR17_RBS0_STR$	17
44	PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
45	PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
46	PA_Actual_Billed_Retenti	PA Actual Billed Retention	Currency	PA_DLR17_RBS0_STR$	17
47	PAPostedCommitedQty	PA Actual Commited Qty	Currency	DLR15_RBU2	15
48	PAPostedCommitedCost	PA Actual Commited Cost	Currency	DLR17_RBS0_UTR$	17
49	PAPostedCommitedTaxAmt	PA Actual Commited Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
50	PAPostRecogRevN	PA Actual Recognized Revenue	Currency	PA_DLR17_RBS0_STR$	17
51	PAPosted_Project_Fee	PA Actual Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
52	PAPosted_Retainer_Fee	PA Actual Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
53	PAPosted_Service_Fee	PA Actual Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
54	PAPOSTRETAMT	PA Actual Retention Amount	Currency	PA_DLR17_RBS0_STR$	17
55	PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	DLR17_RBS0_UTR$	17
56	PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	DLR17_RBS0_UTR$	17
57	PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	PA_DLR17_RBS0_STR$	17
58	PABilled_QtyN	PA Billed Qty	Currency	PA_DLR15_RBS0_STR	15
59	PABilled_Cost	PA Billed Cost	Currency	PA_DLR17_RBS0_STR$	17
60	PABilled_Accrued_Revenu	PA Billed Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
61	PACostPcntCompleted	PA Cost Percent Completed	Currency	DLR5_%2	8
62	PAQuantityPcntCompleted	PA Quantity Percent Completed	Currency	DLR5_%2	8
63	PA_Receipts_Amount	PA Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
64	PA_Actual_Receipts_Amoun	PA Actual Receipts Amount	Currency	PA_DLR17_RBS0_STR$	17
65	PA_Earnings	PA Earnings	Currency	PA_DLR17_RBS0_STR$	17
66	PA_Cost_of_Earnings	PA Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
67	PAUnpostBillN	PA Unposted Billings	Currency	PA_DLR17_RBS0_STR$	17
68	PAUnpostDiscDolAmtN	PA Unposted Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
69	PAUnposted_Sales_Tax_Am	PA Unposted Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
70	PAPostedBillingsN	PA Actual Billings	Currency	PA_DLR17_RBS0_STR$	17
71	PAPostedDiscDolAmtN	PA Actual Discount Dollar Amount	Currency	PA_DLR17_RBS0_STR$	17
72	PAPosted_Sales_Tax_Amou	PA Actual Sales Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
73	PAService_Fee_Amount	PA Service Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
74	PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
75	PAProject_Fee_Amount	PA Project Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
76	PARetentionFeeAmount	PA Retention Fee Amount	Currency	PA_DLR17_RBS0_STR$	17
77	PABCWPAMT	PA BCWP Amount	Currency	PA_DLR17_RBS0_STR$	17
78	PABCWSAMT	PA BCWS Amount	Currency	PA_DLR17_RBS0_STR$	17
79	PAACWPAMT	PA ACWP Amount	Currency	PA_DLR17_RBS0_STR$	17
80	PAApproved_Accrued_Reve	PA Approved Accrued Revenues	Currency	PA_DLR17_RBS0_STR$	17
81	PAApproved_Cost	PA Approved Cost	Currency	PA_DLR17_RBS0_STR$	17
82	PAApproved_Quantity	PA Approved Quantity	Currency	PA_DLR15_RBS0_STR	15
83	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
84	ActualWriteOffAmount	Actual Write Off Amount	Currency	DLR17_RBS0_UTR$	17
85	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
86	ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
87	PACommitted_Costs	PA Committed Costs	Currency	DLR17_RBS0_UTR$	17
88	PACommitted_Qty	PA Committed Qty	Currency	DLR15_RBU2	15
89	PAPOCost	PA PO Cost	Currency	DLR17_RBS0_UTR$	17
90	PAPOQty	PA PO Qty	Currency	DLR15_RBU2	15
91	PAPOPostedCost	PA PO Actual Cost	Currency	DLR17_RBS0_UTR$	17
92	PAPOPostedQty	PA PO Actual Qty	Currency	PA_DLR15_RBS0_STR	15
93	PAtaxpaidamt	PA Tax Paid Amount	Currency	DLR17_RBS0_UTR$	17
94	PAPostedTaxPaidN	PA Actual Tax Paid	Currency	PA_DLR17_RBS0_STR$	17
95	PApretainage	PA Actual Retainage	Currency	DLR17_RBS0_UTR$	17
96	PAunpretainage	PA Unposted Retainage	Currency	DLR17_RBS0_UTR$	17
97	PA_Actual_Freight_Amount	PA Actual Freight Amount	Currency	PA_DLR17_RBS0_STR$	17
98	PA_Unposted_Freight_Amou	PA Unposted Freight Amount	Currency	PA_DLR17_RBS0_STR$	17
99	PA_Actual_Misc_Amount	PA Actual Misc Amount	Currency	PA_DLR17_RBS0_STR$	17
100	PA_Unposted_Misc_Amount	PA Unposted Misc Amount	Currency	PA_DLR17_RBS0_STR$	17
101	PA_Write_Off_Tax_Amount	PA Write Off Tax Amount	Currency	DLR17_RBS0_STR$	17
102	PAActualWOTaxAmt	PA Actual Write Off Tax Amount	Currency	PA_DLR17_RBS0_STR$	17
103	PA_Terms_Taken_Tax_Amt	PA Terms Taken Tax Amt	Currency	DLR17_RBS0_STR$	17
104	PAActualTermsTakenTax	PA Actual Terms Taken Tax Amt	Currency	PA_DLR17_RBS0_STR$	17
105	PANOPENDCO	PA Number of Pending CO	Integer	INT5_RU0	5
106	PANUMCO	PA Number of Change Order	Integer	INT5_RU0	5
107	PACOBASEPROJAMT	PA CO Baseline Project Amount	Currency	PA_DLR17_RBS0_STR$	17
108	PACOBSLNFEEPROJAMT	PA CO Baseline Fee Project Amount	Currency	PA_DLR17_RBS0_STR$	17
109	PAUNPRRTOTPROJAMT	PA Unapproved Total Project Amount	Currency	PA_DLR17_RBS0_STR$	17
110	PAUNABSTOTBILL	PA Unapproved Baseline Total Billings	Currency	PA_DLR17_RBS0_STR$	17
111	PAUNPBSTOTCST	PA Unapproved Baseline Total Cost	Currency	PA_DLR17_RBS0_STR$	17
112	PAUNPBSLTOTPROF	PA Unapproved Baseline Total Profit	Currency	PA_DLR17_RBS0_STR$	17
113	PAUNPBSTOTQTY	PA Unapproved Baseline Total Qty	Currency	PA_DLR15_RBS0_STR	15
114	PAUNAPFRTOTBILL	PA Unapproved Forecast Total Billings	Currency	PA_DLR17_RBS0_STR$	17
115	PAUNAPPFRTOTCST	PA Unapproved Forecast Total Cost	Currency	PA_DLR17_RBS0_STR$	17
116	PAUNFRCTOTPROF	PA Unapproved Forecast Total Profit	Currency	PA_DLR17_RBS0_STR$	17
117	PAUNPFRTOTQTY	PA Unapproved Forecast Total Qty	Currency	PA_DLR15_RBS0_STR	15
118	PATOTCHGORDAMT	PA Total Change Order Amount	Currency	DLR17_RBS0_UTR$	17
119	PAPosted_Earnings	PA Actual Earnings	Currency	PA_DLR17_RBS0_STR$	17
120	PAActualCostofEarnings	PA Actual Cost of Earnings	Currency	PA_DLR17_RBS0_STR$	17
121	PAUnpostedLossAmount	PA Unposted Loss Amount	Currency	DLR17_RBS0_UTR$	17
122	PAActualLossAmount	PA Actual Loss Amount	Currency	DLR17_RBS0_UTR$	17
123	PAFQLaborOnly	PA Forecast Quantity - Labor Only	Currency	DLR15_RBU2	15
124	PAAQLaborOnly	PA Actual Qty - Labor Only	Currency	PA_DLR15_RBS0_STR	15

azurecurve Products Project Accounting (258)ProjectPA Customer MSTR (PA00501)

Click to show/hide

Leave a Reply Cancel reply