SVC_SOP_Contract (SVC00660)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00660

Product: FieldService (949)
Series:

Display Name: SVC_SOP_Contract
Physical Name: SVC00660
Technical Name: SVC_SOP_Contract

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
2SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
3CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['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
4CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
5ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
6CNTTYPE SearchContract TypeStringSTR10_LBAU10
7Contract_Length SearchContract LengthIntegerINT33
8Contract_Period SearchContract PeriodIntegerDDL_Bill_Period0
9STRTDATE SearchStart DateDateDT8
10ENDDATE SearchEnd DateDateDT8
11PREPAID SearchPre PaidBooleanCB0
12PRICSHED SearchPrice ScheduleStringSTR10_Schedule10
13BILLNGTH SearchBill LengthIntegerINT33
14BILPRD SearchBill PeriodIntegerDDL_Bill_Period0
15BILSTRT SearchBill StartDateDATE6
16BILEND SearchBill EndDateDATE6
17BILONDY SearchBill On DayIntegerINT2_U02
18BILCYC SearchBilling CycleIntegerSVC_DDL_Billing_Cycle0
19SVC_Liability_Type SearchSVC_Liability_TypeIntegerDDL_Liability_Type0
20Bill_To_Customer SearchBill To CustomerStringSTR15_RM_Customer_Number15
21SVC_Bill_To_Address_Code SearchSVC Bill To Address CodeStringSTR15_Address_Code15
22PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
23SVC_Invoice_Detail SearchSVC Invoice DetailBooleanCB_Invoice_Detail0
24PARTPCT SearchPart PctCurrencyDLR5_%28
25LABPCT SearchLabor PctCurrencyDLR5_%28
26MISCPCT SearchMisc PctCurrencyDLR5_%28
27PMPRTPCT SearchPM Part PctCurrencyDLR5_%28
28PMLABPCT SearchPM Labor PctCurrencyDLR5_%28
29PMMSCPCT SearchPM Misc PctCurrencyDLR5_%28
30SVC_Paid_Contract SearchSVC Paid ContractBooleanCB0
31DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
32CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['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
33CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['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
34RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['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
35EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['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
36XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
37EXCHDATE SearchExchange DateDateDT_Date6
38TIME1 SearchTimeTimeTM66
39DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
40MCTRXSTT SearchMC Transaction StateIntegerINT11
41svcBillingFrequency SearchsvcBillingFrequencyIntegersvcAtEvery0
42svcFrequencyQty SearchsvcFrequencyQtyIntegerINT33

Leave a Reply

Your email address will not be published. Required fields are marked *