PA Contract Master File (PA01101)

azurecurve Products Project 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:

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

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