SVC_RTV_MSTR_HIST (SVC35600)

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

Product: FieldService (949)
Series: Project

Display Name: SVC_RTV_MSTR_HIST
Physical Name: SVC35600
Technical Name: SVC_RTV_MSTR_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RTV_Number SearchRTV NumberSTR15_LBAUString1615
2RTV_Type SearchRTV TypeSTR10_LBAUString1210
3RTV_Return_Status SearchRTV Return StatusSTR3_LBAUString43
4RTV_Status SearchRTV StatusDDL_RTV_TypeInteger20
5VRMA_Document_ID SearchVRMA Document IDSTR15_LBAUString1615
6RETDOCID SearchReturn Document IDSTR15_LBAUString1615
7LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
8DSCRIPTN SearchDescriptionSTR30String3230
9VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].VENDORID AS 'SVC_RTV_MSTR_HIST-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SVC_RTV_MSTR_HIST'].VENDORID = ['PM Vendor Master File'].VENDORID
10VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
11ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
12Ship_Address_Name SearchShip Address NameSTR64_Vendor_NameString6664
13Ship_Address_1 SearchShip Address 1STR60String6260
14Ship_Address_2 SearchShip Address 2STR60String6260
15Ship_Address_3 SearchShip Address 3STR60String6260
16Ship_City SearchShip CitySTR35String3635
17Ship_State SearchShip StateSTR30_StateString3029
18ZIPCODE SearchZip CodeSTR10String1210
19Ship_Country SearchShip CountrySTR60String6260
20ENTDTE SearchEntry DateDT_DateDate46
21ENTTME SearchEntry TimeTM6Time46
22PRMDATE SearchPromised DateDATE_LDate40
23Promised_Time SearchPromised TimeTM6Time46
24Shipped_Date SearchShipped DateDT_DateDate46
25Shipped_Time SearchShipped TimeTM6Time46
26receiptdate SearchReceipt DateDTDate48
27Receipt_Time SearchReceipt TimeTM6Time46
28COMPDTE SearchComplete DateDT_DateDate46
29COMPTME SearchComplete TimeTM6Time46
30LOCCODEB SearchLocation Code BadSTR10_Location_CodeString1210
31LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].LOCNCODE AS 'SVC_RTV_MSTR_HIST-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SVC_RTV_MSTR_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE
32Part_Price SearchPart PriceDLR17_RBS0_STR$Currency1017
33Part_Cost SearchPart CostDLR17_RBS0_STR$Currency1017
34Labor_Price SearchLabor PriceDLR17_RBS0_STR$Currency1017
35Labor_Cost SearchLabor CostDLR17_RBS0_STR$Currency1017
36Expense_Price SearchExpense PriceDLR17_RBS0_STR$Currency1017
37Expense_Cost SearchExpense CostDLR17_RBS0_STR$Currency1017
38Travel_Price SearchTravel PriceDLR17_RBS0_STR$Currency1017
39Travel_Cost SearchTravel CostDLR17_RBS0_STR$Currency1017
40Bill_of_Lading_Out SearchBill of Lading OutSTR30String3230
41Shipping_Method_Out SearchShipping Method OutSTR15_Shipping_MethodString1615
42Bill_of_Lading SearchBill of LadingSTR30String3230
43SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].SHIPMTHD AS 'SVC_RTV_MSTR_HIST-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SVC_RTV_MSTR_HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
44OFFID SearchOffice IDSTR10_LBAUString1210
45NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].NOTEINDX AS 'SVC_RTV_MSTR_HIST-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SVC_RTV_MSTR_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX
46VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
47Voucher_Number_Invoice SearchVoucher Number InvoiceSTR17_LBAUString1817
48Voucher_Number_Reimburse SearchVoucher Number ReimbursementSTR17_LBAUString1817
49CUSTOWN SearchCustomer OwnedCBBoolean20
50USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].USERID AS 'SVC_RTV_MSTR_HIST-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SVC_RTV_MSTR_HIST'].USERID = ['Users Master'].USERID
51USERDEF1 SearchUser Defined 1STR20String2220
52USERDEF2 SearchUser Defined 2STR20String2220
53USRDEF03 SearchUser Defined 3STR20String2220
54USRDEF04 SearchUser Defined 4STR20String2220
55USRDEF05 SearchUser Defined 5STR20String2220
56CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].CURNCYID AS 'SVC_RTV_MSTR_HIST-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SVC_RTV_MSTR_HIST'].CURNCYID = ['Currency Setup'].CURNCYID
57CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].CURRNIDX AS 'SVC_RTV_MSTR_HIST-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SVC_RTV_MSTR_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
58RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].RATETPID AS 'SVC_RTV_MSTR_HIST-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SVC_RTV_MSTR_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
59EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['SVC_RTV_MSTR_HIST'].EXGTBLID AS 'SVC_RTV_MSTR_HIST-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SVC35600 AS ['SVC_RTV_MSTR_HIST']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['SVC_RTV_MSTR_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
60XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
61EXCHDATE SearchExchange DateDT_DateDate46
62DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
63TIME1 SearchTimeTM6Time46
64RATECALC SearchRate Calc MethodINTInteger20
65VIEWMODE SearchView ModeINTInteger20
66ISMCTRX SearchIS MC TrxINTInteger20
67EXPNDATE SearchExpiration DateDT_DateDate46
68DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
69MCTRXSTT SearchMC Transaction StateINT1Integer21
70Originating_Part_Price SearchOriginating Part PriceDLR17_RBS0_STR$Currency1017
71Originating_Part_Cost SearchOriginating Part CostDLR17_RBS0_STR$Currency1017
72Originating_Labor_Price SearchOriginating Labor PriceDLR17_RBS0_STR$Currency1017
73Originating_Labor_Cost SearchOriginating Labor CostDLR17_RBS0_STR$Currency1017
74Originating_ExpensePrice SearchOriginating Expense PriceDLR17_RBS0_STR$Currency1017
75Originating_Expense_Cost SearchOriginating Expense CostDLR17_RBS0_STR$Currency1017
76Originating_Travel_Price SearchOriginating Travel PriceDLR17_RBS0_STR$Currency1017
77Originating_Travel_Cost SearchOriginating Travel CostDLR17_RBS0_STR$Currency1017
78VOIDSTTS SearchVoid StatusINTInteger20
79DEX_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.

Leave a Reply

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