Service Call Line Detail History (SVC30203)

azurecurveProductsFieldService (949)ProjectService Call Line Detail History (SVC30203)

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

Product: FieldService (949)
Series: Project

Display Name: Service Call Line Detail History
Physical Name: SVC30203
Technical Name: SVC_Service_MSTR_Line_HIST

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger20
2CALLNBR SearchService Call NumberSTR10_LBAUString1210
3EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer410
4LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
5LINITMTYP SearchLine Item TypeSTR3String43
6SRVSTAT SearchService Call StatusSTR3_LBUString43
7TECHID SearchTech IDSTR10_LBAUString1210
8ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Service Call Line Detail History'].ITEMNMBR AS 'Service Call Line Detail History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC30203 AS ['Service Call Line Detail History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Service Call Line Detail History'].ITEMNMBR = ['Item Master'].ITEMNMBR
9ITEMUSETYPE SearchItem Use TypeSTR2String42
10ITEMDESC SearchItem DescriptionSTR100String102100
11LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Service Call Line Detail History'].LOCNCODE AS 'Service Call Line Detail History-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC30203 AS ['Service Call Line Detail History']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Service Call Line Detail History'].LOCNCODE = ['Site Setup'].LOCNCODE
12UOFM SearchU Of MU_Of_MString108
13QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency1017
14ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
15QTYBACKO SearchQTY BackorderedDLR17_QTY_RBS0_UTRCurrency1017
16QTYSOLD SearchQTY SoldDLR17_QTY_RBS0_UTRCurrency1017
17UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
18UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
19EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
20XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
21NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Service Call Line Detail History'].NOTEINDX AS 'Service Call Line Detail History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC30203 AS ['Service Call Line Detail History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Service Call Line Detail History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
22STRTDATE SearchStart DateDTDate48
23STRTTIME SearchStart TimeTM6Time46
24ENDDATE SearchEnd DateDTDate48
25ENDTME SearchSVC_End TimeTM6Time46
26TRANSTME SearchTransaction TimeSTR_Bill_TimeString86
27BILLABLTIM SearchBillable TimeSTR_Bill_TimeString86
28TRNSFLOC SearchTransfer From LocationSTR10_Location_CodeString1210
29TRNSFQTY SearchTransfer From QTYDLR17_QTY_RBS0_UTRCurrency1017
30TRNFLAG SearchTransfer FlagCBBoolean20
31ORDDOCID SearchOrder Document IDSTR15_LBAUString1615
32TRANSLINESEQ SearchTransfer Line Item SequenceLI_Sequence_NumberLong Integer410
33LABPCT SearchLabor PctDLR5_%2Currency108
34PARTPCT SearchPart PctDLR5_%2Currency108
35MISCPCT SearchMisc PctDLR5_%2Currency108
36FUFILDAT SearchFulfillment DateDTDate48
37PONMBRSTR SearchPurchase_Order_Number_STRSTR17_LBAUString1817
38POLNSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
39On_Return SearchOn ReturnBooleanBoolean20
40RETDOCID SearchReturn Document IDSTR15_LBAUString1615
41LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
42Miles_Start SearchMiles StartLong IntLong Integer48
43Miles_End SearchMiles EndLong IntLong Integer48
44Miles_Used SearchMiles UsedLong IntLong Integer48
45PRICELVL SearchPrice LevelSTR15_LBAUString1615
46SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger20
47SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeSTR15_Address_CodeString1615
48SVC_Disable_XFR_Grouping SearchSVC_Disable_XFR_GroupingCBBoolean20
49Work_Type SearchWork TypeSTR10_LBAUString1210
50ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
51ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency1017
52OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
53OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency1017
54TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
55ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
56SVC_FO_ID SearchSVC FO IDSTR50String5250
57svcCreateVoucher SearchsvcCreateVoucherCBBoolean20
58VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
59CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer410
60CMPITQTY SearchComponent Item QTYDLR17_QTY_RBS0_UTRCurrency1017
61DEX_ROW_ID Searchintint1010

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.

azurecurveProductsFieldService (949)ProjectService Call Line Detail History (SVC30203)

Leave a Reply

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