Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00675
Product: FieldService (949)
Series:
Display Name: svcContractLineMoveWork
Physical Name: SVC00675
Technical Name: svcContractLineMoveWorkSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CONSTS 
Contract Record Type Integer DDL_Contract_Status 0 2 CONTNBR Contract Number String STR11 11 3 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 4 CNTTYPE Contract Type String STR10_LBAU 10 5 STRTDATE Start Date Date DT 8 6 ENDDATE End Date Date DT 8 7 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['svcContractLineMoveWork'].ITEMNMBR AS 'svcContractLineMoveWork-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC00675 AS ['svcContractLineMoveWork']
INNER JOIN
IV00101 AS ['Item Master']
ON
['svcContractLineMoveWork'].ITEMNMBR = ['Item Master'].ITEMNMBR8 SERLNMBR Serial Number String STR20_LBAU 20 9 EQUIPID Equipment ID Long Integer Long Int 8 10 DSCRIPTN Description String STR30 30 11 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 12 Effective_Date Effective Date Date DT 8 13 CMXFRNUM Transfer Number String STR20_Document_Number 20 14 To_Customer_Number To Customer Number String STR15_Customer_Number 15 15 ADRSCODE Address Code String STR15_Address_Code 15 16 PRICSHED Price Schedule String STR10_Schedule 10 17 CNTPRCOVR Contract Price Overridden Boolean CB 0 18 TOTAL Total Currency Dollar19 19 19 SVC_Monthly_Price SVC Monthly_Price Currency DLR17_RBS0_UTR$ 17 20 DEDCAMNT_1 Deduction Amount[1] Currency DLR11_$S2 14 21 DEDCAMNT Deduction Amount DLR11_$S2 Currency 14 22 DEDCAMNT_2 Deduction Amount[2] Currency DLR11_$S2 14 23 DEDCAMNT_3 Deduction Amount[3] Currency DLR11_$S2 14 24 DEDCAMNT_4 Deduction Amount[4] Currency DLR11_$S2 14 25 DEDCAMNT_5 Deduction Amount[5] Currency DLR11_$S2 14 26 RETNAGAM Retainage Amount Currency DLR17_RBS0_UTR$ 17 27 RTNBILLD Retainage Billed Currency DLR11_RBS0_UTR$ 11 28 NBRCAL Max Number of Calls Integer INT5 4 29 ACTCAL Actual Number of Calls Integer INT5 4 30 BLKTIM Blocked Time Currency CURR_TIME 10 31 VALTIM Value of Time Currency CURR_TIME 10 32 MKDTOPST Marked To Post Boolean CB 0 33 POSTDATE Post Date Date DT_Date 6