Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC35601
Product: FieldService (949)
Series:
Display Name: SVC_RTV_Line_HIST
Physical Name: SVC35601
Technical Name: SVC_RTV_Line_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RTV_Number 
RTV Number String STR15_LBAU 15 2 RTV_Line RTV Line Currency Sequence_Number 19 3 RTV_Type RTV Type String STR10_LBAU 10 4 RTV_Status RTV Status Integer DDL_RTV_Type 0 5 RTV_Return_Status RTV Return Status String STR3_LBAU 3 6 VRMA_Document_ID VRMA Document ID String STR15_LBAU 15 7 RETDOCID Return Document ID String STR15_LBAU 15 8 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 9 SVC_Process_SEQ_Number SVC Process SEQ Number Currency Sequence_Number 19 10 DSCRIPTN Description String STR30 30 11 REFRENCE Reference String STR30 30 12 Reference2 Reference2 String STR30 30 13 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SVC_RTV_Line_HIST'].ITEMNMBR AS 'SVC_RTV_Line_HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC35601 AS ['SVC_RTV_Line_HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC_RTV_Line_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR14 ITEMDESC Item Description String STR100 100 15 ITMTRKOP Item Tracking Option Integer DDL_Track 0 16 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 17 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 18 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 19 QTY_To_Receive QTY To Receive Currency DLR17_QTY_RBS0_STR 17 20 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 21 QTYCANCE QTY Canceled Currency DLR17_QTY_RBS0_UTR 17 22 UOFM U Of M String U_Of_M 8 23 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['SVC_RTV_Line_HIST'].VENDORID AS 'SVC_RTV_Line_HIST-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVC35601 AS ['SVC_RTV_Line_HIST']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SVC_RTV_Line_HIST'].VENDORID = ['PM Vendor Master File'].VENDORID24 VNDITNUM Vendor Item Number String Item_Number 30 25 Return_Item_Number Return Item Number String STR30_Item_Number 30 26 OFFID Office ID String STR10_LBAU 10 27 LOCCODEB Location Code Bad String STR10_Location_Code 10 28 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['SVC_RTV_Line_HIST'].LOCNCODE AS 'SVC_RTV_Line_HIST-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SVC35601 AS ['SVC_RTV_Line_HIST']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SVC_RTV_Line_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE29 ADRSCODE Address Code String STR15_Address_Code 15 30 Ship_Address_Name Ship Address Name String STR64_Vendor_Name 64 31 Ship_Address_1 Ship Address 1 String STR60 60 32 Ship_Address_2 Ship Address 2 String STR60 60 33 Ship_Address_3 Ship Address 3 String STR60 60 34 Ship_City Ship City String STR35 35 35 Ship_State Ship State String STR30_State 29 36 ZIPCODE Zip Code String STR10 10 37 Ship_Country Ship Country String STR60 60 38 ENTDTE Entry Date Date DT_Date 6 39 ENTTME Entry Time Time TM6 6 40 PRMDATE Promised Date Date DATE_L 0 41 Promised_Time Promised Time Time TM6 6 42 Shipped_Date Shipped Date Date DT_Date 6 43 Shipped_Time Shipped Time Time TM6 6 44 receiptdate Receipt Date Date DT 8 45 Receipt_Time Receipt Time Time TM6 6 46 COMPDTE Complete Date Date DT_Date 6 47 COMPTME Complete Time Time TM6 6 48 PONMBRSTR Purchase_Order_Number_STR String STR17_LBAU 17 49 POLNSEQ Purchase_Order_Line_Sequence_DOL Currency DLR17_RBS0_STR 17 50 POPRCTNM POP Receipt Number String STR17_POP_Number 17 51 RCPTLNNM Receipt Line Number Long Integer LI_Sequence_Number 10 52 Transfer_Reference Transfer Reference String STR30 30 53 TRANSLINESEQ Transfer Line Item Sequence Long Integer LI_Sequence_Number 10 54 CALLNBR Service Call Number String STR10_LBAU 10 55 EQPLINE Equipment Line Item Sequence Long Integer LI_Sequence_Number 10 56 LINITMTYP Line Item Type String STR3 3 57 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 58 Bill_of_Lading_Out Bill of Lading Out String STR30 30 59 Shipping_Method_Out Shipping Method Out String STR15_Shipping_Method 15 60 Bill_of_Lading Bill of Lading String STR30 30 61 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['SVC_RTV_Line_HIST'].SHIPMTHD AS 'SVC_RTV_Line_HIST-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
SVC35601 AS ['SVC_RTV_Line_HIST']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SVC_RTV_Line_HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD62 Tracking_Number Tracking Number String STR40 40 63 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SVC_RTV_Line_HIST'].NOTEINDX AS 'SVC_RTV_Line_HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVC35601 AS ['SVC_RTV_Line_HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SVC_RTV_Line_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX64 VCHNUMWK Voucher Number - WORK String STR17_LBAU 17 65 Voucher_Number_Invoice Voucher Number Invoice String STR17_LBAU 17 66 Voucher_Number_Reimburse Voucher Number Reimbursement String STR17_LBAU 17 67 CUSTOWN Customer Owned Boolean CB 0 68 USERDEF1 User Defined 1 String STR20 20 69 USERDEF2 User Defined 2 String STR20 20 70 USRDEF03 User Defined 3 String STR20 20 71 USRDEF04 User Defined 4 String STR20 20 72 USRDEF05 User Defined 5 String STR20 20 73 Part_Price Part Price Currency DLR17_RBS0_STR$ 17 74 Part_Cost Part Cost Currency DLR17_RBS0_STR$ 17 75 Labor_Price Labor Price Currency DLR17_RBS0_STR$ 17 76 Labor_Cost Labor Cost Currency DLR17_RBS0_STR$ 17 77 Expense_Price Expense Price Currency DLR17_RBS0_STR$ 17 78 Expense_Cost Expense Cost Currency DLR17_RBS0_STR$ 17 79 Travel_Price Travel Price Currency DLR17_RBS0_STR$ 17 80 Travel_Cost Travel Cost Currency DLR17_RBS0_STR$ 17 81 Originating_Part_Price Originating Part Price Currency DLR17_RBS0_STR$ 17 82 Originating_Part_Cost Originating Part Cost Currency DLR17_RBS0_STR$ 17 83 Originating_Labor_Price Originating Labor Price Currency DLR17_RBS0_STR$ 17 84 Originating_Labor_Cost Originating Labor Cost Currency DLR17_RBS0_STR$ 17 85 Originating_ExpensePrice Originating Expense Price Currency DLR17_RBS0_STR$ 17 86 Originating_Expense_Cost Originating Expense Cost Currency DLR17_RBS0_STR$ 17 87 Originating_Travel_Price Originating Travel Price Currency DLR17_RBS0_STR$ 17 88 Originating_Travel_Cost Originating Travel Cost Currency DLR17_RBS0_STR$ 17 89 QTYTYPE QTY Type Integer DDL_QTY_Type 0