Service Transfer Header (SVC00700)

azurecurveProductsFieldService (949)ProjectService Transfer Header (SVC00700)

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

Product: FieldService (949)
Series: Project

Display Name: Service Transfer Header
Physical Name: SVC00700
Technical Name: SVC_Transfer_HDR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ORDDOCID SearchOrder Document IDSTR15_LBAUString1615
2RFRNCDOC SearchReference DocumentSTR20String2220
3TECHID SearchTech IDSTR10_LBAUString1210
4OFFID SearchOffice IDSTR10_LBAUString1210
5STATUS SearchTransfer StatusINTInteger20
6ORDRDATE SearchOrder DateDTDate48
7ETADTE SearchETA DateDT_DateDate46
8CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
9ADDRESS1 SearchAddress 1STR60String6260
10ADDRESS2 SearchAddress 2STR60String6260
11CITY SearchCitySTR35String3635
12STATE SearchStateSTR30_StateString3029
13ZIPCODE SearchZip CodeSTR10String1210
14SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['Service Transfer Header'].NOTEINDX AS 'Service Transfer Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC00700 AS ['Service Transfer Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Service Transfer Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger20
20SVC_Misc_Address_Code SearchSVC_Misc_Address_CodeSTR15_Address_CodeString1615
21ADDRESS3 SearchAddress 3STR60String6260
22COUNTRY SearchCountrySTR60String6260
23USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Service Transfer Header'].USERID AS 'Service Transfer Header-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC00700 AS ['Service Transfer Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Service Transfer Header'].USERID = ['Users Master'].USERID
24DEX_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 Transfer Header (SVC00700)

Leave a Reply

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