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

azurecurve Products Project Accounting (258)ProjectPA Contract Master File (PA01101)

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