PA Customer MSTR (PA00501)

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

Product: Project Accounting (258)
Series: Project

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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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
2PAcustalias SearchPA Customer AliasPA_Str5_LBAUString65
3PAcloseProjcosts SearchPA Close to Project CostsPA_CB_Close_to_Project_CostsBoolean20
4PAclosetobillings SearchPA Close to BillingsPA_CB_Close_to_BillingsBoolean20
5PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString1615
6PAUD1 SearchPA User Defined 1STR20String2220
7PAUD2 SearchPA User Defined 2STR20String2220
8PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency1015
9PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency1017
10PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency1017
11PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency1017
12PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency1017
13PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency1017
14PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency1017
15PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
16PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
17PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
18PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency1017
19PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency1017
20PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency1017
21PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency1017
22PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
23PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency1015
24PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency1017
25PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency1017
26PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency1017
27PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency1017
28PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
29PAUnpostedCommitedQty SearchPA Unposted Commited QtyDLR15_RBU2Currency1015
30PAUnpostedCommitedCost SearchPA Unposted Commited CostDLR17_RBS0_UTR$Currency1017
31PAUnpostedCommitedTaxAmt SearchPA Unposted Commited Tax AmountPA_DLR17_RBS0_STR$Currency1017
32PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
33PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
34PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
35PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
36PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency1017
37PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionPA_DLR17_RBS0_STR$Currency1017
38PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency1017
39PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency1017
40PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
41PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
42PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency1017
43PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency1017
44PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency1017
45PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
46PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionPA_DLR17_RBS0_STR$Currency1017
47PAPostedCommitedQty SearchPA Actual Commited QtyDLR15_RBU2Currency1015
48PAPostedCommitedCost SearchPA Actual Commited CostDLR17_RBS0_UTR$Currency1017
49PAPostedCommitedTaxAmt SearchPA Actual Commited Tax AmountPA_DLR17_RBS0_STR$Currency1017
50PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
51PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
52PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
53PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
54PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
55PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency1017
56PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency1017
57PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency1017
58PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency1015
59PABilled_Cost SearchPA Billed CostPA_DLR17_RBS0_STR$Currency1017
60PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
61PACostPcntCompleted SearchPA Cost Percent CompletedDLR5_%2Currency108
62PAQuantityPcntCompleted SearchPA Quantity Percent CompletedDLR5_%2Currency108
63PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency1017
64PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency1017
65PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency1017
66PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
67PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency1017
68PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
69PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
70PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
71PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
72PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
73PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
74PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
75PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
76PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency1017
77PABCWPAMT SearchPA BCWP AmountPA_DLR17_RBS0_STR$Currency1017
78PABCWSAMT SearchPA BCWS AmountPA_DLR17_RBS0_STR$Currency1017
79PAACWPAMT SearchPA ACWP AmountPA_DLR17_RBS0_STR$Currency1017
80PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
81PAApproved_Cost SearchPA Approved CostPA_DLR17_RBS0_STR$Currency1017
82PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency1015
83WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
84ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
85DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
86ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
87PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency1017
88PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency1015
89PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency1017
90PAPOQty SearchPA PO QtyDLR15_RBU2Currency1015
91PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency1017
92PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency1015
93PAtaxpaidamt SearchPA Tax Paid AmountDLR17_RBS0_UTR$Currency1017
94PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency1017
95PApretainage SearchPA Actual RetainageDLR17_RBS0_UTR$Currency1017
96PAunpretainage SearchPA Unposted RetainageDLR17_RBS0_UTR$Currency1017
97PA_Actual_Freight_Amount SearchPA Actual Freight AmountPA_DLR17_RBS0_STR$Currency1017
98PA_Unposted_Freight_Amou SearchPA Unposted Freight AmountPA_DLR17_RBS0_STR$Currency1017
99PA_Actual_Misc_Amount SearchPA Actual Misc AmountPA_DLR17_RBS0_STR$Currency1017
100PA_Unposted_Misc_Amount SearchPA Unposted Misc AmountPA_DLR17_RBS0_STR$Currency1017
101PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency1017
102PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency1017
103PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency1017
104PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency1017
105PANOPENDCO SearchPA Number of Pending COINT5_RU0Integer25
106PANUMCO SearchPA Number of Change OrderINT5_RU0Integer25
107PACOBASEPROJAMT SearchPA CO Baseline Project AmountPA_DLR17_RBS0_STR$Currency1017
108PACOBSLNFEEPROJAMT SearchPA CO Baseline Fee Project AmountPA_DLR17_RBS0_STR$Currency1017
109PAUNPRRTOTPROJAMT SearchPA Unapproved Total Project AmountPA_DLR17_RBS0_STR$Currency1017
110PAUNABSTOTBILL SearchPA Unapproved Baseline Total BillingsPA_DLR17_RBS0_STR$Currency1017
111PAUNPBSTOTCST SearchPA Unapproved Baseline Total CostPA_DLR17_RBS0_STR$Currency1017
112PAUNPBSLTOTPROF SearchPA Unapproved Baseline Total ProfitPA_DLR17_RBS0_STR$Currency1017
113PAUNPBSTOTQTY SearchPA Unapproved Baseline Total QtyPA_DLR15_RBS0_STRCurrency1015
114PAUNAPFRTOTBILL SearchPA Unapproved Forecast Total BillingsPA_DLR17_RBS0_STR$Currency1017
115PAUNAPPFRTOTCST SearchPA Unapproved Forecast Total CostPA_DLR17_RBS0_STR$Currency1017
116PAUNFRCTOTPROF SearchPA Unapproved Forecast Total ProfitPA_DLR17_RBS0_STR$Currency1017
117PAUNPFRTOTQTY SearchPA Unapproved Forecast Total QtyPA_DLR15_RBS0_STRCurrency1015
118PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency1017
119PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency1017
120PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
121PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency1017
122PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency1017
123PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency1015
124PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency1015
125DEX_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 *