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