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 TypeLength
1SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger0
2CALLNBR SearchService Call NumberSTR10_LBAUString10
3EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer10
4LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
5LINITMTYP SearchLine Item TypeSTR3String3
6SRVSTAT SearchService Call StatusSTR3_LBUString3
7TECHID SearchTech IDSTR10_LBAUString10
8ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 TypeSTR2String2
10ITEMDESC SearchItem DescriptionSTR100String100
11LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_MString8
13QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency17
14ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
15QTYBACKO SearchQTY BackorderedDLR17_QTY_RBS0_UTRCurrency17
16QTYSOLD SearchQTY SoldDLR17_QTY_RBS0_UTRCurrency17
17UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
18UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
19EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
20XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency17
21NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
23STRTTIME SearchStart TimeTM6Time6
24ENDDATE SearchEnd DateDTDate8
25ENDTME SearchSVC_End TimeTM6Time6
26TRANSTME SearchTransaction TimeSTR_Bill_TimeString6
27BILLABLTIM SearchBillable TimeSTR_Bill_TimeString6
28TRNSFLOC SearchTransfer From LocationSTR10_Location_CodeString10
29TRNSFQTY SearchTransfer From QTYDLR17_QTY_RBS0_UTRCurrency17
30TRNFLAG SearchTransfer FlagCBBoolean0
31ORDDOCID SearchOrder Document IDSTR15_LBAUString15
32TRANSLINESEQ SearchTransfer Line Item SequenceLI_Sequence_NumberLong Integer10
33LABPCT SearchLabor PctDLR5_%2Currency8
34PARTPCT SearchPart PctDLR5_%2Currency8
35MISCPCT SearchMisc PctDLR5_%2Currency8
36FUFILDAT SearchFulfillment DateDTDate8
37PONMBRSTR SearchPurchase_Order_Number_STRSTR17_LBAUString17
38POLNSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
39On_Return SearchOn ReturnBooleanBoolean0
40RETDOCID SearchReturn Document IDSTR15_LBAUString15
41LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
42Miles_Start SearchMiles StartLong IntLong Integer8
43Miles_End SearchMiles EndLong IntLong Integer8
44Miles_Used SearchMiles UsedLong IntLong Integer8
45PRICELVL SearchPrice LevelSTR15_LBAUString15
46SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger0
47SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeSTR15_Address_CodeString15
48SVC_Disable_XFR_Grouping SearchSVC_Disable_XFR_GroupingCBBoolean0
49Work_Type SearchWork TypeSTR10_LBAUString10
50ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency17
51ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency17
52OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
53OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency17
54TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
55ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
56SVC_FO_ID SearchSVC FO IDSTR50String50
57svcCreateVoucher SearchsvcCreateVoucherCBBoolean0
58VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
59CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer10
60CMPITQTY SearchComponent Item QTYDLR17_QTY_RBS0_UTRCurrency17
61DEX_ROW_ID Searchintint10

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 *