Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00660
Product: FieldService (949)
Series:
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 | Length | |
|---|---|---|---|---|---|---|
| 1 | SOPTYPE  | SOP Type | Integer | DDL_SOP_Type | 0 | |
| 2 | SOPNUMBE | SOP Number | String | STR20_SOP_Number | 17 | |
| 3 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 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 | String | STR64_Customer_Name | 64 | |
| 5 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
| 6 | CNTTYPE | Contract Type | String | STR10_LBAU | 10 | |
| 7 | Contract_Length | Contract Length | Integer | INT3 | 3 | |
| 8 | Contract_Period | Contract Period | Integer | DDL_Bill_Period | 0 | |
| 9 | STRTDATE | Start Date | Date | DT | 8 | |
| 10 | ENDDATE | End Date | Date | DT | 8 | |
| 11 | PREPAID | Pre Paid | Boolean | CB | 0 | |
| 12 | PRICSHED | Price Schedule | String | STR10_Schedule | 10 | |
| 13 | BILLNGTH | Bill Length | Integer | INT3 | 3 | |
| 14 | BILPRD | Bill Period | Integer | DDL_Bill_Period | 0 | |
| 15 | BILSTRT | Bill Start | Date | DATE | 6 | |
| 16 | BILEND | Bill End | Date | DATE | 6 | |
| 17 | BILONDY | Bill On Day | Integer | INT2_U0 | 2 | |
| 18 | BILCYC | Billing Cycle | Integer | SVC_DDL_Billing_Cycle | 0 | |
| 19 | SVC_Liability_Type | SVC_Liability_Type | Integer | DDL_Liability_Type | 0 | |
| 20 | Bill_To_Customer | Bill To Customer | String | STR15_RM_Customer_Number | 15 | |
| 21 | SVC_Bill_To_Address_Code | SVC Bill To Address Code | String | STR15_Address_Code | 15 | |
| 22 | PORDNMBR | Purchase Order Number | String | Purchase Order Number | 20 | |
| 23 | SVC_Invoice_Detail | SVC Invoice Detail | Boolean | CB_Invoice_Detail | 0 | |
| 24 | PARTPCT | Part Pct | Currency | DLR5_%2 | 8 | |
| 25 | LABPCT | Labor Pct | Currency | DLR5_%2 | 8 | |
| 26 | MISCPCT | Misc Pct | Currency | DLR5_%2 | 8 | |
| 27 | PMPRTPCT | PM Part Pct | Currency | DLR5_%2 | 8 | |
| 28 | PMLABPCT | PM Labor Pct | Currency | DLR5_%2 | 8 | |
| 29 | PMMSCPCT | PM Misc Pct | Currency | DLR5_%2 | 8 | |
| 30 | SVC_Paid_Contract | SVC Paid Contract | Boolean | CB | 0 | |
| 31 | DSCPCTAM | Discount Percent Amount | Integer | INT5_%2 | 5 | |
| 32 | CURNCYID | Currency ID | String | STR15_Currency_ID | 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 | Integer | INT3 | 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 | String | STR15_Rate_Type_ID | 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 | String | STR15_Exchange_Table_ID | 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 | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 37 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
| 38 | TIME1 | Time | Time | TM6 | 6 | |
| 39 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 40 | MCTRXSTT | MC Transaction State | Integer | INT1 | 1 | |
| 41 | svcBillingFrequency | svcBillingFrequency | Integer | svcAtEvery | 0 | |
| 42 | svcFrequencyQty | svcFrequencyQty | Integer | INT3 | 3 | |