Service Call Line Detail (SVC00203)

azurecurveProductsFieldService (949)ProjectService Call Line Detail (SVC00203)

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

Product: FieldService (949)
Series:

Display Name: Service Call Line Detail
Physical Name: SVC00203
Technical Name: SVC_Service_MSTR_Line

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SRVRECTYPE SearchService Record TypeIntegerDDL_Service_Record_Type0
2CALLNBR SearchService Call NumberStringSTR10_LBAU10
3EQPLINE SearchEquipment Line Item SequenceLong IntegerLI_Sequence_Number10
4LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
5LINITMTYP SearchLine Item TypeStringSTR33
6SRVSTAT SearchService Call StatusStringSTR3_LBU3
7TECHID SearchTech IDStringSTR10_LBAU10
8ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

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

Click to show/hide

SELECT
       ['Service Call Line Detail'].LOCNCODE AS 'Service Call Line Detail-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC00203 AS ['Service Call Line Detail']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Service Call Line Detail'].LOCNCODE = ['Site Setup'].LOCNCODE
12UOFM SearchU Of MStringU_Of_M8
13QTYORDER SearchQTY OrderedCurrencyDLR17_QTY_RBS0_UTR17
14ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
15QTYBACKO SearchQTY BackorderedCurrencyDLR17_QTY_RBS0_UTR17
16QTYSOLD SearchQTY SoldCurrencyDLR17_QTY_RBS0_UTR17
17UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
18UNITPRCE SearchUnit PriceCurrencyDLR17_RBS0_STR$17
19EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
20XTNDPRCE SearchExtended PriceCurrencyDLR17_RBS0_STR$17
21NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Service Call Line Detail'].NOTEINDX AS 'Service Call Line Detail-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC00203 AS ['Service Call Line Detail']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Service Call Line Detail'].NOTEINDX = ['Record Notes Master'].NOTEINDX
22STRTDATE SearchStart DateDateDT8
23STRTTIME SearchStart TimeTimeTM66
24ENDDATE SearchEnd DateDateDT8
25ENDTME SearchSVC_End TimeTimeTM66
26TRANSTME SearchTransaction TimeStringSTR_Bill_Time6
27BILLABLTIM SearchBillable TimeStringSTR_Bill_Time6
28TRNSFLOC SearchTransfer From LocationStringSTR10_Location_Code10
29TRNSFQTY SearchTransfer From QTYCurrencyDLR17_QTY_RBS0_UTR17
30TRNFLAG SearchTransfer FlagBooleanCB0
31ORDDOCID SearchOrder Document IDStringSTR15_LBAU15
32TRANSLINESEQ SearchTransfer Line Item SequenceLong IntegerLI_Sequence_Number10
33LABPCT SearchLabor PctCurrencyDLR5_%28
34PARTPCT SearchPart PctCurrencyDLR5_%28
35MISCPCT SearchMisc PctCurrencyDLR5_%28
36FUFILDAT SearchFulfillment DateDateDT8
37PONMBRSTR SearchPurchase_Order_Number_STRStringSTR17_LBAU17
38POLNSEQ SearchPurchase_Order_Line_Sequence_DOLCurrencyDLR17_RBS0_STR17
39On_Return SearchOn ReturnBooleanBoolean0
40RETDOCID SearchReturn Document IDStringSTR15_LBAU15
41LNSEQNBR SearchLine SEQ NumberCurrencySequence_Number19
42Miles_Start SearchMiles StartLong IntegerLong Int8
43Miles_End SearchMiles EndLong IntegerLong Int8
44Miles_Used SearchMiles UsedLong IntegerLong Int8
45PRICELVL SearchPrice LevelStringSTR15_LBAU15
46SVC_Address_Option SearchSVC_Address_OptionIntegerDDL_Address_Option0
47SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeStringSTR15_Address_Code15
48SVC_Disable_XFR_Grouping SearchSVC_Disable_XFR_GroupingBooleanCB0
49Work_Type SearchWork TypeStringSTR10_LBAU10
50ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
51ORUNTPRC SearchOriginating Unit PriceCurrencyDLR17_RBS0_STR$17
52OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
53OXTNDPRC SearchOriginating Extended PriceCurrencyDLR17_RBS0_STR$17
54TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
55ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
56SVC_FO_ID SearchSVC FO IDStringSTR5050
57svcCreateVoucher SearchsvcCreateVoucherBooleanCB0
58VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
59CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
60CMPITQTY SearchComponent Item QTYCurrencyDLR17_QTY_RBS0_UTR17
azurecurveProductsFieldService (949)ProjectService Call Line Detail (SVC00203)

Leave a Reply

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