Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00660
Product: FieldService (949)
Series: Project
Display Name: SVC_SOP_Contract Group Display Name: Service Table Group
Physical Name: SVC00660
Technical Name: SVC_SOP_Contract
Group Technical Name: Service
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | SOPTYPE ![]() | SOP Type | DDL_SOP_Type | Integer | 2 | 0 |
2 | SOPNUMBE ![]() | SOP Number | STR20_SOP_Number | String | 22 | 17 |
3 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 16 | 15 |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['SVC_SOP_Contract'].CUSTNMBR AS 'SVC_SOP_Contract-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVC00660 AS ['SVC_SOP_Contract']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SVC_SOP_Contract'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
4 | CUSTNAME ![]() | Customer Name | STR64_Customer_Name | String | 66 | 64 |
5 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 16 | 15 |
6 | CNTTYPE ![]() | Contract Type | STR10_LBAU | String | 12 | 10 |
7 | Contract_Length ![]() | Contract Length | INT3 | Integer | 2 | 3 |
8 | Contract_Period ![]() | Contract Period | DDL_Bill_Period | Integer | 2 | 0 |
9 | STRTDATE ![]() | Start Date | DT | Date | 4 | 8 |
10 | ENDDATE ![]() | End Date | DT | Date | 4 | 8 |
11 | PREPAID ![]() | Pre Paid | CB | Boolean | 2 | 0 |
12 | PRICSHED ![]() | Price Schedule | STR10_Schedule | String | 12 | 10 |
13 | BILLNGTH ![]() | Bill Length | INT3 | Integer | 2 | 3 |
14 | BILPRD ![]() | Bill Period | DDL_Bill_Period | Integer | 2 | 0 |
15 | BILSTRT ![]() | Bill Start | DATE | Date | 4 | 6 |
16 | BILEND ![]() | Bill End | DATE | Date | 4 | 6 |
17 | BILONDY ![]() | Bill On Day | INT2_U0 | Integer | 2 | 2 |
18 | BILCYC ![]() | Billing Cycle | SVC_DDL_Billing_Cycle | Integer | 2 | 0 |
19 | SVC_Liability_Type ![]() | SVC_Liability_Type | DDL_Liability_Type | Integer | 2 | 0 |
20 | Bill_To_Customer ![]() | Bill To Customer | STR15_RM_Customer_Number | String | 16 | 15 |
21 | SVC_Bill_To_Address_Code ![]() | SVC Bill To Address Code | STR15_Address_Code | String | 16 | 15 |
22 | PORDNMBR ![]() | Purchase Order Number | Purchase Order Number | String | 22 | 20 |
23 | SVC_Invoice_Detail ![]() | SVC Invoice Detail | CB_Invoice_Detail | Boolean | 2 | 0 |
24 | PARTPCT ![]() | Part Pct | DLR5_%2 | Currency | 10 | 8 |
25 | LABPCT ![]() | Labor Pct | DLR5_%2 | Currency | 10 | 8 |
26 | MISCPCT ![]() | Misc Pct | DLR5_%2 | Currency | 10 | 8 |
27 | PMPRTPCT ![]() | PM Part Pct | DLR5_%2 | Currency | 10 | 8 |
28 | PMLABPCT ![]() | PM Labor Pct | DLR5_%2 | Currency | 10 | 8 |
29 | PMMSCPCT ![]() | PM Misc Pct | DLR5_%2 | Currency | 10 | 8 |
30 | SVC_Paid_Contract ![]() | SVC Paid Contract | CB | Boolean | 2 | 0 |
31 | DSCPCTAM ![]() | Discount Percent Amount | INT5_%2 | Integer | 2 | 5 |
32 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 16 | 15 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SVC_SOP_Contract'].CURNCYID AS 'SVC_SOP_Contract-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVC00660 AS ['SVC_SOP_Contract']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SVC_SOP_Contract'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
33 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SVC_SOP_Contract'].CURRNIDX AS 'SVC_SOP_Contract-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVC00660 AS ['SVC_SOP_Contract']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SVC_SOP_Contract'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
34 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 16 | 15 |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['SVC_SOP_Contract'].RATETPID AS 'SVC_SOP_Contract-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
SVC00660 AS ['SVC_SOP_Contract']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SVC_SOP_Contract'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
35 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 16 | 15 |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['SVC_SOP_Contract'].EXGTBLID AS 'SVC_SOP_Contract-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
SVC00660 AS ['SVC_SOP_Contract']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SVC_SOP_Contract'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
36 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
37 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 4 | 6 |
38 | TIME1 ![]() | Time | TM6 | Time | 4 | 6 |
39 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
40 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 2 | 1 |
41 | svcBillingFrequency ![]() | svcBillingFrequency | svcAtEvery | Integer | 2 | 0 |
42 | svcFrequencyQty ![]() | svcFrequencyQty | INT3 | Integer | 2 | 3 |
43 | 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. |