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. | ||||||