svcContractLineMoveWork (SVC00675)

azurecurveProductsFieldService (949)ProjectsvcContractLineMoveWork (SVC00675)

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: svcContractLineMoveWork

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CONSTS SearchContract Record TypeIntegerDDL_Contract_Status0
2CONTNBR SearchContract NumberStringSTR1111
3LNSEQNBR SearchLine SEQ NumberCurrencySequence_Number19
4CNTTYPE SearchContract TypeStringSTR10_LBAU10
5STRTDATE SearchStart DateDateDT8
6ENDDATE SearchEnd DateDateDT8
7ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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'].ITEMNMBR
8SERLNMBR SearchSerial NumberStringSTR20_LBAU20
9EQUIPID SearchEquipment IDLong IntegerLong Int8
10DSCRIPTN SearchDescriptionStringSTR3030
11QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
12Effective_Date SearchEffective DateDateDT8
13CMXFRNUM SearchTransfer NumberStringSTR20_Document_Number20
14To_Customer_Number SearchTo Customer NumberStringSTR15_Customer_Number15
15ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
16PRICSHED SearchPrice ScheduleStringSTR10_Schedule10
17CNTPRCOVR SearchContract Price OverriddenBooleanCB0
18TOTAL SearchTotalCurrencyDollar1919
19SVC_Monthly_Price SearchSVC Monthly_PriceCurrencyDLR17_RBS0_UTR$17
20DEDCAMNT SearchDeduction AmountDLR11_$S2Currency14
21DEDCAMNT_1 SearchDeduction Amount[1]CurrencyDLR11_$S214
22DEDCAMNT_2 SearchDeduction Amount[2]CurrencyDLR11_$S214
23DEDCAMNT_3 SearchDeduction Amount[3]CurrencyDLR11_$S214
24DEDCAMNT_4 SearchDeduction Amount[4]CurrencyDLR11_$S214
25DEDCAMNT_5 SearchDeduction Amount[5]CurrencyDLR11_$S214
26RETNAGAM SearchRetainage AmountCurrencyDLR17_RBS0_UTR$17
27RTNBILLD SearchRetainage BilledCurrencyDLR11_RBS0_UTR$11
28NBRCAL SearchMax Number of CallsIntegerINT54
29ACTCAL SearchActual Number of CallsIntegerINT54
30BLKTIM SearchBlocked TimeCurrencyCURR_TIME10
31VALTIM SearchValue of TimeCurrencyCURR_TIME10
32MKDTOPST SearchMarked To PostBooleanCB0
33POSTDATE SearchPost DateDateDT_Date6
azurecurveProductsFieldService (949)ProjectsvcContractLineMoveWork (SVC00675)

Leave a Reply

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