SVC_RTV_Line (SVC05601)

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

Product: FieldService (949)
Series: Project

Display Name: SVC_RTV_Line
Physical Name: SVC05601
Technical Name: SVC_RTV_Line

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RTV_Number SearchRTV NumberSTR15_LBAUString1615
2RTV_Line SearchRTV LineSequence_NumberCurrency1019
3RTV_Type SearchRTV TypeSTR10_LBAUString1210
4RTV_Status SearchRTV StatusDDL_RTV_TypeInteger20
5RTV_Return_Status SearchRTV Return StatusSTR3_LBAUString43
6VRMA_Document_ID SearchVRMA Document IDSTR15_LBAUString1615
7RETDOCID SearchReturn Document IDSTR15_LBAUString1615
8LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
9SVC_Process_SEQ_Number SearchSVC Process SEQ NumberSequence_NumberCurrency1019
10DSCRIPTN SearchDescriptionSTR30String3230
11REFRENCE SearchReferenceSTR30String3230
12Reference2 SearchReference2STR30String3230
13ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SVC_RTV_Line'].ITEMNMBR AS 'SVC_RTV_Line-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC05601 AS ['SVC_RTV_Line']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SVC_RTV_Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
14ITEMDESC SearchItem DescriptionSTR100String102100
15ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
16DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
17QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
18QTYSHPPD SearchQTY ShippedDLR17_QTY_RBS0_UTRCurrency1017
19QTY_To_Receive SearchQTY To ReceiveDLR17_QTY_RBS0_STRCurrency1017
20QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency1017
21QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency1017
22UOFM SearchU Of MU_Of_MString108
23VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SVC_RTV_Line'].VENDORID AS 'SVC_RTV_Line-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SVC05601 AS ['SVC_RTV_Line']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SVC_RTV_Line'].VENDORID = ['PM Vendor Master File'].VENDORID
24VNDITNUM SearchVendor Item NumberItem_NumberString3230
25Return_Item_Number SearchReturn Item NumberSTR30_Item_NumberString3230
26OFFID SearchOffice IDSTR10_LBAUString1210
27LOCCODEB SearchLocation Code BadSTR10_Location_CodeString1210
28LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SVC_RTV_Line'].LOCNCODE AS 'SVC_RTV_Line-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC05601 AS ['SVC_RTV_Line']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SVC_RTV_Line'].LOCNCODE = ['Site Setup'].LOCNCODE
29ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
30Ship_Address_Name SearchShip Address NameSTR64_Vendor_NameString6664
31Ship_Address_1 SearchShip Address 1STR60String6260
32Ship_Address_2 SearchShip Address 2STR60String6260
33Ship_Address_3 SearchShip Address 3STR60String6260
34Ship_City SearchShip CitySTR35String3635
35Ship_State SearchShip StateSTR30_StateString3029
36ZIPCODE SearchZip CodeSTR10String1210
37Ship_Country SearchShip CountrySTR60String6260
38ENTDTE SearchEntry DateDT_DateDate46
39ENTTME SearchEntry TimeTM6Time46
40PRMDATE SearchPromised DateDATE_LDate40
41Promised_Time SearchPromised TimeTM6Time46
42Shipped_Date SearchShipped DateDT_DateDate46
43Shipped_Time SearchShipped TimeTM6Time46
44receiptdate SearchReceipt DateDTDate48
45Receipt_Time SearchReceipt TimeTM6Time46
46COMPDTE SearchComplete DateDT_DateDate46
47COMPTME SearchComplete TimeTM6Time46
48PONMBRSTR SearchPurchase_Order_Number_STRSTR17_LBAUString1817
49POLNSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
50POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
51RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer410
52Transfer_Reference SearchTransfer ReferenceSTR30String3230
53TRANSLINESEQ SearchTransfer Line Item SequenceLI_Sequence_NumberLong Integer410
54CALLNBR SearchService Call NumberSTR10_LBAUString1210
55EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer410
56LINITMTYP SearchLine Item TypeSTR3String43
57LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
58Bill_of_Lading_Out SearchBill of Lading OutSTR30String3230
59Shipping_Method_Out SearchShipping Method OutSTR15_Shipping_MethodString1615
60Bill_of_Lading SearchBill of LadingSTR30String3230
61SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SVC_RTV_Line'].SHIPMTHD AS 'SVC_RTV_Line-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC05601 AS ['SVC_RTV_Line']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SVC_RTV_Line'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
62Tracking_Number SearchTracking NumberSTR40String4240
63NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SVC_RTV_Line'].NOTEINDX AS 'SVC_RTV_Line-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SVC05601 AS ['SVC_RTV_Line']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SVC_RTV_Line'].NOTEINDX = ['Record Notes Master'].NOTEINDX
64VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
65Voucher_Number_Invoice SearchVoucher Number InvoiceSTR17_LBAUString1817
66Voucher_Number_Reimburse SearchVoucher Number ReimbursementSTR17_LBAUString1817
67CUSTOWN SearchCustomer OwnedCBBoolean20
68USERDEF1 SearchUser Defined 1STR20String2220
69USERDEF2 SearchUser Defined 2STR20String2220
70USRDEF03 SearchUser Defined 3STR20String2220
71USRDEF04 SearchUser Defined 4STR20String2220
72USRDEF05 SearchUser Defined 5STR20String2220
73Part_Price SearchPart PriceDLR17_RBS0_STR$Currency1017
74Part_Cost SearchPart CostDLR17_RBS0_STR$Currency1017
75Labor_Price SearchLabor PriceDLR17_RBS0_STR$Currency1017
76Labor_Cost SearchLabor CostDLR17_RBS0_STR$Currency1017
77Expense_Price SearchExpense PriceDLR17_RBS0_STR$Currency1017
78Expense_Cost SearchExpense CostDLR17_RBS0_STR$Currency1017
79Travel_Price SearchTravel PriceDLR17_RBS0_STR$Currency1017
80Travel_Cost SearchTravel CostDLR17_RBS0_STR$Currency1017
81Originating_Part_Price SearchOriginating Part PriceDLR17_RBS0_STR$Currency1017
82Originating_Part_Cost SearchOriginating Part CostDLR17_RBS0_STR$Currency1017
83Originating_Labor_Price SearchOriginating Labor PriceDLR17_RBS0_STR$Currency1017
84Originating_Labor_Cost SearchOriginating Labor CostDLR17_RBS0_STR$Currency1017
85Originating_ExpensePrice SearchOriginating Expense PriceDLR17_RBS0_STR$Currency1017
86Originating_Expense_Cost SearchOriginating Expense CostDLR17_RBS0_STR$Currency1017
87Originating_Travel_Price SearchOriginating Travel PriceDLR17_RBS0_STR$Currency1017
88Originating_Travel_Cost SearchOriginating Travel CostDLR17_RBS0_STR$Currency1017
89QTYTYPE SearchQTY TypeDDL_QTY_TypeInteger20
90DEX_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 *