Service Transfer Header History (SVC30700)

azurecurveProductsFieldService (949)ProjectService Transfer Header History (SVC30700)

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

Product: FieldService (949)
Series:

Display Name: Service Transfer Header History
Physical Name: SVC30700
Technical Name: SVC_Transfer_HDR_HIST

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ORDDOCID SearchOrder Document IDStringSTR15_LBAU15
2RFRNCDOC SearchReference DocumentStringSTR2020
3TECHID SearchTech IDStringSTR10_LBAU10
4OFFID SearchOffice IDStringSTR10_LBAU10
5STATUS SearchTransfer StatusIntegerINT0
6ORDRDATE SearchOrder DateDateDT8
7ETADTE SearchETA DateDateDT_Date6
8CUSTNAME SearchCustomer NameStringSTR64_Customer_Name64
9ADDRESS1 SearchAddress 1StringSTR6060
10ADDRESS2 SearchAddress 2StringSTR6060
11CITY SearchCityStringSTR3535
12STATE SearchStateStringSTR30_State29
13ZIPCODE SearchZip CodeStringSTR1010
14SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Service Transfer Header History'].SHIPMTHD AS 'Service Transfer Header History-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC30700 AS ['Service Transfer Header History']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Service Transfer Header History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
15TRNSFLOC SearchTransfer From LocationStringSTR10_Location_Code10
16ITLOCN SearchIntransit LocationStringSTR10_Location_Code10
17LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Service Transfer Header History'].LOCNCODE AS 'Service Transfer Header History-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC30700 AS ['Service Transfer Header History']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Service Transfer Header History'].LOCNCODE = ['Site Setup'].LOCNCODE
18NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Service Transfer Header History'].NOTEINDX AS 'Service Transfer Header History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC30700 AS ['Service Transfer Header History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Service Transfer Header History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19SVC_Address_Option SearchSVC_Address_OptionIntegerDDL_Address_Option0
20SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeStringSTR15_Address_Code15
21ADDRESS3 SearchAddress 3StringSTR6060
22COUNTRY SearchCountryStringSTR6060
23USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Service Transfer Header History'].USERID AS 'Service Transfer Header History-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC30700 AS ['Service Transfer Header History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Service Transfer Header History'].USERID = ['Users Master'].USERID
azurecurveProductsFieldService (949)ProjectService Transfer Header History (SVC30700)

Leave a Reply

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