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 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.
Physical Name: SVC35600
Technical Name: SVC_RTV_MSTR_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RTV_Number 
RTV Number STR15_LBAU String 15 2 RTV_Type RTV Type STR10_LBAU String 10 3 RTV_Return_Status RTV Return Status STR3_LBAU String 3 4 RTV_Status RTV Status DDL_RTV_Type Integer 0 5 VRMA_Document_ID VRMA Document ID STR15_LBAU String 15 6 RETDOCID Return Document ID STR15_LBAU String 15 7 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 8 DSCRIPTN Description STR30 String 30 9 VENDORID Vendor ID STR_15_Vendor_ID String 15 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'].VENDORID10 VENDNAME Vendor Name STR64_Vendor_Name String 64 11 ADRSCODE Address Code STR15_Address_Code String 15 12 Ship_Address_Name Ship Address Name STR64_Vendor_Name String 64 13 Ship_Address_1 Ship Address 1 STR60 String 60 14 Ship_Address_2 Ship Address 2 STR60 String 60 15 Ship_Address_3 Ship Address 3 STR60 String 60 16 Ship_City Ship City STR35 String 35 17 Ship_State Ship State STR30_State String 29 18 ZIPCODE Zip Code STR10 String 10 19 Ship_Country Ship Country STR60 String 60 20 ENTDTE Entry Date DT_Date Date 6 21 ENTTME Entry Time TM6 Time 6 22 PRMDATE Promised Date DATE_L Date 0 23 Promised_Time Promised Time TM6 Time 6 24 Shipped_Date Shipped Date DT_Date Date 6 25 Shipped_Time Shipped Time TM6 Time 6 26 receiptdate Receipt Date DT Date 8 27 Receipt_Time Receipt Time TM6 Time 6 28 COMPDTE Complete Date DT_Date Date 6 29 COMPTME Complete Time TM6 Time 6 30 LOCCODEB Location Code Bad STR10_Location_Code String 10 31 LOCNCODE Location Code STR10_Location_Code String 10 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'].LOCNCODE32 Part_Price Part Price DLR17_RBS0_STR$ Currency 17 33 Part_Cost Part Cost DLR17_RBS0_STR$ Currency 17 34 Labor_Price Labor Price DLR17_RBS0_STR$ Currency 17 35 Labor_Cost Labor Cost DLR17_RBS0_STR$ Currency 17 36 Expense_Price Expense Price DLR17_RBS0_STR$ Currency 17 37 Expense_Cost Expense Cost DLR17_RBS0_STR$ Currency 17 38 Travel_Price Travel Price DLR17_RBS0_STR$ Currency 17 39 Travel_Cost Travel Cost DLR17_RBS0_STR$ Currency 17 40 Bill_of_Lading_Out Bill of Lading Out STR30 String 30 41 Shipping_Method_Out Shipping Method Out STR15_Shipping_Method String 15 42 Bill_of_Lading Bill of Lading STR30 String 30 43 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 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'].SHIPMTHD44 OFFID Office ID STR10_LBAU String 10 45 NOTEINDX Note Index DLR14 Currency 14 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'].NOTEINDX46 VCHNUMWK Voucher Number - WORK STR17_LBAU String 17 47 Voucher_Number_Invoice Voucher Number Invoice STR17_LBAU String 17 48 Voucher_Number_Reimburse Voucher Number Reimbursement STR17_LBAU String 17 49 CUSTOWN Customer Owned CB Boolean 0 50 USERID User ID STR15_User_ID String 15 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'].USERID51 USERDEF1 User Defined 1 STR20 String 20 52 USERDEF2 User Defined 2 STR20 String 20 53 USRDEF03 User Defined 3 STR20 String 20 54 USRDEF04 User Defined 4 STR20 String 20 55 USRDEF05 User Defined 5 STR20 String 20 56 CURNCYID Currency ID STR15_Currency_ID String 15 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'].CURNCYID57 CURRNIDX Currency Index INT3 Integer 3 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'].CURRNIDX58 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 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'].RATETPID59 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 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'].EXGTBLID60 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 61 EXCHDATE Exchange Date DT_Date Date 6 62 DECPLACS Decimal Places DDL_Decimal_Places Integer 0 63 TIME1 Time TM6 Time 6 64 RATECALC Rate Calc Method INT Integer 0 65 VIEWMODE View Mode INT Integer 0 66 ISMCTRX IS MC Trx INT Integer 0 67 EXPNDATE Expiration Date DT_Date Date 6 68 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 69 MCTRXSTT MC Transaction State INT1 Integer 1 70 Originating_Part_Price Originating Part Price DLR17_RBS0_STR$ Currency 17 71 Originating_Part_Cost Originating Part Cost DLR17_RBS0_STR$ Currency 17 72 Originating_Labor_Price Originating Labor Price DLR17_RBS0_STR$ Currency 17 73 Originating_Labor_Cost Originating Labor Cost DLR17_RBS0_STR$ Currency 17 74 Originating_ExpensePrice Originating Expense Price DLR17_RBS0_STR$ Currency 17 75 Originating_Expense_Cost Originating Expense Cost DLR17_RBS0_STR$ Currency 17 76 Originating_Travel_Price Originating Travel Price DLR17_RBS0_STR$ Currency 17 77 Originating_Travel_Cost Originating Travel Cost DLR17_RBS0_STR$ Currency 17 78 VOIDSTTS Void Status INT Integer 0 79 DEX_ROW_ID int int 10