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