PA Contract Master File (PA01101)

azurecurveProductsProject Accounting (258)ProjectPA Contract Master File (PA01101)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Contract Master File
Physical Name: PA01101
Technical Name: PA_Contract_MSTR

Group Display Name: PA Budgeting Cards
Group Technical Name: PA Budgeting 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 Contract Master File'].CUSTNMBR AS 'PA Contract Master File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA01101 AS ['PA Contract Master File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Contract Master File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2PAcontid SearchPA Contract IDSTR15_Contract IDString1615
3PALONGID SearchPA Long Contract IDPA_Long_Contract_IDComposite 500
4PALONGID_1 SearchPA Long Contract ID:PA Long Contract Segment1PA_STR9_SEG1String109
5PALONGID_2 SearchPA Long Contract ID:PA Long Contract Segment2PA_STR9_SEG2String109
6PALONGID_3 SearchPA Long Contract ID:PA Long Contract Segment3PA_STR9_SEG3String109
7PALONGID_4 SearchPA Long Contract ID:PA Long Contract Segment4PA_STR9_SEG4String109
8PALONGID_5 SearchPA Long Contract ID:PA Long Contract Segment5PA_STR9_SEG5String109
9PAcontname SearchPA Contract NameSTR30_PTBS Description 1String3230
10PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
11PAcontclassid SearchPA Contract Class IDSTR15_Contract_Class_IDString1615
12PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
13PAAcctgMethod SearchPA Accounting MethodPA_DDL_Accounting_MethodInteger20
14PASTAT SearchPA StatusPA_DDL_StatusInteger20
15CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Contract Master File'].CURRNIDX AS 'PA Contract Master File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PA01101 AS ['PA Contract Master File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Contract Master File'].CURRNIDX = ['Currency Setup'].CURRNIDX
16PApurordnum SearchPA Purchase Order No.STR17_LBAUString1817
17PABBeginDate SearchPA Baseline Begin DateDATEDate46
18PABEndDate SearchPA Baseline End DateDATEDate46
19PAFBeginDate SearchPA Forecast Begin DateDATEDate46
20PAFEndDate SearchPA Forecast End DateDATEDate46
21PAACTUALBEGDATE SearchPA Actual Begin DateDATEDate46
22PA_Actual_End_Date SearchPA Actual End DateDATEDate46
23PAcloseProjcosts SearchPA Close to Project CostsPA_CB_Close_to_Project_CostsBoolean20
24PAclosetobillings SearchPA Close to BillingsPA_CB_Close_to_BillingsBoolean20
25PAContMgrID SearchPA Contract Manager IDSTR15_Employee_IDString1615
26PABusMgrID SearchPA Business Manager IDSTR15_Employee_IDString1615
27LOCATNID SearchLocation IDSTR15_Location_IDString1615
28SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['PA Contract Master File'].SLPRSNID AS 'PA Contract Master File-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       PA01101 AS ['PA Contract Master File']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['PA Contract Master File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
29SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['PA Contract Master File'].SALSTERR AS 'PA Contract Master File-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       PA01101 AS ['PA Contract Master File']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['PA Contract Master File'].SALSTERR = ['Sales Territory Master File'].SALSTERR
30COMPRCNT SearchCommission PercentINT5_%2Integer25
31COMAPPTO SearchCommission Applied ToGBInteger20
32PABILLFORMAT SearchPA Bill FormatSTR15_LBAUString1615
33ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
34CNTCPRSN SearchContact PersonSTR60String6260
35PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
36PAUD1_Cont SearchPA User Defined 1 - ContractSTR50String5250
37PAUD2_Cont SearchPA User Defined 2 - ContractSTR50String5250
38PASegmentCB SearchPA Segment CBPA_CB_SegmentBoolean20
39PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
40PAbillnoteidxts SearchPA Billing Note Index - TSDLR14Currency1014
41PAELbillniteidx SearchPA Billing Note Index - ELDLR14Currency1014
42PAbillnoteidxML SearchPA Billing Note Index - MLDLR14Currency1014
43PAbillnoteidxvi SearchPA Billing Note Index - VIDLR14Currency1014
44PAbillnoteidxee SearchPA Billing Note Index - EEDLR14Currency1014
45PAbillnoteidxinv SearchPA Billing Note Index - INVDLR14Currency1014
46PAbillnoteidxfee SearchPA Billing Note Index - FEEDLR14Currency1014
47PABQuantity SearchPA Baseline QuantityDLR15_RBU2Currency1015
48PABTotalCost SearchPA Baseline Total CostDLR17_RBS0_UTR$Currency1017
49PABBillings SearchPA Baseline BillingsDLR17_RBS0_UTR$Currency1017
50PABProfit SearchPA Baseline ProfitDLR17_RBS0_STR$Currency1017
51PABTaxPaidAmt SearchPA Baseline Tax Paid AmountDLR17_RBS0_UTR$Currency1017
52PABTaxChargedAmt SearchPA Baseline Tax Charged AmountDLR17_RBS0_UTR$Currency1017
53PABaselineOvhdCost SearchPA Baseline Overhead CostDLR17_RBS0_UTR$Currency1017
54PAFQuantity SearchPA Forecast QuantityDLR15_RBU2Currency1015
55PAFTotalCost SearchPA Forecast Total CostDLR17_RBS0_UTR$Currency1017
56PAFBillings SearchPA Forecast BillingsDLR17_RBS0_UTR$Currency1017
57PAFProfit SearchPA Forecast ProfitDLR17_RBS0_STR$Currency1017
58PAFTaxPaidAmt SearchPA Forecast Tax Paid AmountDLR17_RBS0_UTR$Currency1017
59PAFTaxChargedAmt SearchPA Forecast Tax Charged AmountDLR17_RBS0_UTR$Currency1017
60PAForecastOvhdCost SearchPA Forecast Overhead CostDLR17_RBS0_UTR$Currency1017
61PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
62PAUnpostedQty SearchPA Unposted QtyPA_DLR15_RBS0_STRCurrency1015
63PAUnpostedTotalCostN SearchPA Unposted Total CostPA_DLR17_RBS0_STR$Currency1017
64PAUnposted_Overhead SearchPA Unposted OverheadPA_DLR17_RBS0_STR$Currency1017
65PAUnpostedProfitN SearchPA Unposted ProfitPA_DLR17_RBS0_STR$Currency1017
66PAUnposted_Tax_Amount SearchPA Unposted Tax AmountPA_DLR17_RBS0_STR$Currency1017
67PAUnpostAccrRevN SearchPA Unposted Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
68PAUnpostedCommitedQty SearchPA Unposted Commited QtyDLR15_RBU2Currency1015
69PAUnpostedCommitedCost SearchPA Unposted Commited CostDLR17_RBS0_UTR$Currency1017
70PAUnpostedCommitedTaxAmt SearchPA Unposted Commited Tax AmountPA_DLR17_RBS0_STR$Currency1017
71PAUnpostedRecogRevN SearchPA Unposted Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
72PAUnposted_Project_Fee SearchPA Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
73PAUnposted_Retainer_Fee SearchPA Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
74PAUnposted_Service_Fee SearchPA Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
75PAUNPOSTRETAMT SearchPA Unposted Retention AmountPA_DLR17_RBS0_STR$Currency1017
76PAUNPOSTBIEEAMOUNT SearchPA Unposted BIEE AmountDLR17_RBS0_UTR$Currency1017
77PAUNPEIEBAMOUNT SearchPA Unposted EIEB AmountDLR17_RBS0_UTR$Currency1017
78PA_Unposted_Billed_Reten SearchPA Unposted Billed RetentionPA_DLR17_RBS0_STR$Currency1017
79PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
80PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
81PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency1017
82PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency1017
83PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency1017
84PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
85PAPostedCommitedQty SearchPA Actual Commited QtyDLR15_RBU2Currency1015
86PAPostedCommitedCost SearchPA Actual Commited CostDLR17_RBS0_UTR$Currency1017
87PAPostedCommitedTaxAmt SearchPA Actual Commited Tax AmountPA_DLR17_RBS0_STR$Currency1017
88PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
89PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
90PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
91PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
92PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
93PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency1017
94PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency1017
95PA_Actual_Billed_Retenti SearchPA Actual Billed RetentionPA_DLR17_RBS0_STR$Currency1017
96PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency1017
97PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency1015
98PABilled_Cost SearchPA Billed CostPA_DLR17_RBS0_STR$Currency1017
99PABilled_Accrued_Revenu SearchPA Billed Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
100PACostPcntCompleted SearchPA Cost Percent CompletedDLR5_%2Currency108
101PAQuantityPcntCompleted SearchPA Quantity Percent CompletedDLR5_%2Currency108
102PA_Receipts_Amount SearchPA Receipts AmountPA_DLR17_RBS0_STR$Currency1017
103PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency1017
104PA_Earnings SearchPA EarningsPA_DLR17_RBS0_STR$Currency1017
105PA_Cost_of_Earnings SearchPA Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
106PAUnpostBillN SearchPA Unposted BillingsPA_DLR17_RBS0_STR$Currency1017
107PAUnpostDiscDolAmtN SearchPA Unposted Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
108PAUnposted_Sales_Tax_Am SearchPA Unposted Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
109PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
110PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
111PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
112PAService_Fee_Amount SearchPA Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
113PARetainer_Fee_Amount SearchPA Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
114PAProject_Fee_Amount SearchPA Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
115PARetentionFeeAmount SearchPA Retention Fee AmountPA_DLR17_RBS0_STR$Currency1017
116DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
117PABCWPAMT SearchPA BCWP AmountPA_DLR17_RBS0_STR$Currency1017
118PABCWSAMT SearchPA BCWS AmountPA_DLR17_RBS0_STR$Currency1017
119PAACWPAMT SearchPA ACWP AmountPA_DLR17_RBS0_STR$Currency1017
120NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Contract Master File'].NOTEINDX AS 'PA Contract Master File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA01101 AS ['PA Contract Master File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Contract Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
121PAApproved_Accrued_Reve SearchPA Approved Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
122PAApproved_Cost SearchPA Approved CostPA_DLR17_RBS0_STR$Currency1017
123PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency1015
124WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
125ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
126DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
127ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
128PACommitted_Costs SearchPA Committed CostsDLR17_RBS0_UTR$Currency1017
129PACommitted_Qty SearchPA Committed QtyDLR15_RBU2Currency1015
130PAPOCost SearchPA PO CostDLR17_RBS0_UTR$Currency1017
131PAPOQty SearchPA PO QtyDLR15_RBU2Currency1015
132PAPOPostedCost SearchPA PO Actual CostDLR17_RBS0_UTR$Currency1017
133PAPOPostedQty SearchPA PO Actual QtyPA_DLR15_RBS0_STRCurrency1015
134PAtaxpaidamt SearchPA Tax Paid AmountDLR17_RBS0_UTR$Currency1017
135PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency1017
136PApretainage SearchPA Actual RetainageDLR17_RBS0_UTR$Currency1017
137PAunpretainage SearchPA Unposted RetainageDLR17_RBS0_UTR$Currency1017
138PA_Write_Off_Tax_Amount SearchPA Write Off Tax AmountDLR17_RBS0_STR$Currency1017
139PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency1017
140PA_Terms_Taken_Tax_Amt SearchPA Terms Taken Tax AmtDLR17_RBS0_STR$Currency1017
141PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency1017
142PA_RestrictCustomerList SearchPA Restrict Customer ListPA_CB_Restrict_Customer_ListBoolean20
143PAPosted_Earnings SearchPA Actual EarningsPA_DLR17_RBS0_STR$Currency1017
144PAActualCostofEarnings SearchPA Actual Cost of EarningsPA_DLR17_RBS0_STR$Currency1017
145PAUnpostedLossAmount SearchPA Unposted Loss AmountDLR17_RBS0_UTR$Currency1017
146PAActualLossAmount SearchPA Actual Loss AmountDLR17_RBS0_UTR$Currency1017
147PAFQLaborOnly SearchPA Forecast Quantity - Labor OnlyDLR15_RBU2Currency1015
148PAAQLaborOnly SearchPA Actual Qty - Labor OnlyPA_DLR15_RBS0_STRCurrency1015
149PAMCCURNCYID SearchPA MC Currency IDSTR15_Currency_IDString1615
150PAMCProjectAmount SearchPA MC Project AmountPA_DLR17_RBS0_UTR$Currency1017
151PAMCUnpostBillN SearchPA MC Unposted BillingsPA_DLR17_RBS0_UTR$Currency1017
152PAMCUnpostedSalesTax SearchPA MC Unposted Sales Tax AmtPA_DLR17_RBS0_UTR$Currency1017
153PAMCUnpostedDiscount SearchPA MC Unposted Discount AmtPA_DLR17_RBS0_UTR$Currency1017
154PAMCActualBillings SearchPA MC Actual BillingsPA_DLR17_RBS0_UTR$Currency1017
155PAMCActualSalesTaxAmt SearchPA MC Actual Sales Tax AmtPA_DLR17_RBS0_UTR$Currency1017
156PAMCActualDiscountAmt SearchPA MC Actual Discount AmtPA_DLR17_RBS0_UTR$Currency1017
157PAMCBBillings SearchPA MC Baseline BillingsPA_DLR17_RBS0_UTR$Currency1017
158PAMCFBillings SearchPA MC Forecast BillingsPA_DLR17_RBS0_UTR$Currency1017
159PA_MC_Project_Fee_Amount SearchPA MC Project Fee AmountPA_DLR17_RBS0_UTR$Currency1017
160PA_MC_Retainer_Fee_Amt SearchPA MC Retainer Fee AmountPA_DLR17_RBS0_UTR$Currency1017
161PA_MC_Service_Fee_Amount SearchPA MC Service Fee AmountPA_DLR17_RBS0_UTR$Currency1017
162PA_MC_UnpostedProjectFee SearchPA MC Unposted Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
163PA_MC_Unposted_Retainer SearchPA MC Unposted Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
164PA_MC_UnpostedServiceFee SearchPA MC Unposted Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
165PA_MC_Actual_Project_Fee SearchPA MC Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
166PA_MC_Actual_RetainerFee SearchPA MC Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
167PA_MC_Actual_Service_Fee SearchPA MC Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
168DEX_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.

azurecurveProductsProject Accounting (258)ProjectPA Contract Master File (PA01101)

Leave a Reply

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