Depot Master Line (SVC06101)

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

Product: FieldService (949)
Series:

Display Name: Depot Master Line
Physical Name: SVC06101
Technical Name: SVC_Depot_MSTR_Line

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1WORECTYPE SearchWork Order Record TypeIntegerDDL_Work_Order_Record_Type0
2WORKORDNUM SearchWork Order NumberStringSTR10_LBAU10
3WOSTAT SearchWork Order StatusStringSTR3_LBU3
4LINITMTYP SearchLine Item TypeStringSTR33
5LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
6ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Depot Master Line'].ITEMNMBR AS 'Depot Master Line-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC06101 AS ['Depot Master Line']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Depot Master Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
7ITEMUSETYPE SearchItem Use TypeStringSTR22
8ITEMDESC SearchItem DescriptionStringSTR100100
9STATIONID SearchDepot Station IDStringSTR10_LBAU10
10LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Depot Master Line'].LOCNCODE AS 'Depot Master Line-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC06101 AS ['Depot Master Line']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Depot Master Line'].LOCNCODE = ['Site Setup'].LOCNCODE
11UOFM SearchU Of MStringU_Of_M8
12TECHID SearchTech IDStringSTR10_LBAU10
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
21STRTDATE SearchStart DateDateDT8
22STRTTIME SearchStart TimeTimeTM66
23ENDDATE SearchEnd DateDateDT8
24ENDTIME SearchEnd TimeTimeTM66
25TRANSTME SearchTransaction TimeStringSTR_Bill_Time6
26BILLABLTIM SearchBillable TimeStringSTR_Bill_Time6
27NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Depot Master Line'].NOTEINDX AS 'Depot Master Line-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC06101 AS ['Depot Master Line']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Depot Master Line'].NOTEINDX = ['Record Notes Master'].NOTEINDX
28SEQUENCE1 SearchSequenceCurrencyDLR19_$S219
29ORDDOCID SearchOrder Document IDStringSTR15_LBAU15
30TRANSLINESEQ SearchTransfer Line Item SequenceLong IntegerLI_Sequence_Number10
31PONMBRSTR SearchPurchase_Order_Number_STRStringSTR17_LBAU17
32POLNSEQ SearchPurchase_Order_Line_Sequence_DOLCurrencyDLR17_RBS0_STR17
33FUFILDAT SearchFulfillment DateDateDT8
34CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
35CMPITQTY SearchComponent Item QTYCurrencyDLR17_QTY_RBS0_UTR17

Leave a Reply

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