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 TypeLength
1RTV_Number SearchRTV NumberSTR15_LBAUString15
2RTV_Line SearchRTV LineSequence_NumberCurrency19
3RTV_Type SearchRTV TypeSTR10_LBAUString10
4RTV_Status SearchRTV StatusDDL_RTV_TypeInteger0
5RTV_Return_Status SearchRTV Return StatusSTR3_LBAUString3
6VRMA_Document_ID SearchVRMA Document IDSTR15_LBAUString15
7RETDOCID SearchReturn Document IDSTR15_LBAUString15
8LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
9SVC_Process_SEQ_Number SearchSVC Process SEQ NumberSequence_NumberCurrency19
10DSCRIPTN SearchDescriptionSTR30String30
11REFRENCE SearchReferenceSTR30String30
12Reference2 SearchReference2STR30String30
13ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
15ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger0
16DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
17QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
18QTYSHPPD SearchQTY ShippedDLR17_QTY_RBS0_UTRCurrency17
19QTY_To_Receive SearchQTY To ReceiveDLR17_QTY_RBS0_STRCurrency17
20QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency17
21QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency17
22UOFM SearchU Of MU_Of_MString8
23VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_NumberString30
25Return_Item_Number SearchReturn Item NumberSTR30_Item_NumberString30
26OFFID SearchOffice IDSTR10_LBAUString10
27LOCCODEB SearchLocation Code BadSTR10_Location_CodeString10
28LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_CodeString15
30Ship_Address_Name SearchShip Address NameSTR64_Vendor_NameString64
31Ship_Address_1 SearchShip Address 1STR60String60
32Ship_Address_2 SearchShip Address 2STR60String60
33Ship_Address_3 SearchShip Address 3STR60String60
34Ship_City SearchShip CitySTR35String35
35Ship_State SearchShip StateSTR30_StateString29
36ZIPCODE SearchZip CodeSTR10String10
37Ship_Country SearchShip CountrySTR60String60
38ENTDTE SearchEntry DateDT_DateDate6
39ENTTME SearchEntry TimeTM6Time6
40PRMDATE SearchPromised DateDATE_LDate0
41Promised_Time SearchPromised TimeTM6Time6
42Shipped_Date SearchShipped DateDT_DateDate6
43Shipped_Time SearchShipped TimeTM6Time6
44receiptdate SearchReceipt DateDTDate8
45Receipt_Time SearchReceipt TimeTM6Time6
46COMPDTE SearchComplete DateDT_DateDate6
47COMPTME SearchComplete TimeTM6Time6
48PONMBRSTR SearchPurchase_Order_Number_STRSTR17_LBAUString17
49POLNSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
50POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString17
51RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer10
52Transfer_Reference SearchTransfer ReferenceSTR30String30
53TRANSLINESEQ SearchTransfer Line Item SequenceLI_Sequence_NumberLong Integer10
54CALLNBR SearchService Call NumberSTR10_LBAUString10
55EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer10
56LINITMTYP SearchLine Item TypeSTR3String3
57LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
58Bill_of_Lading_Out SearchBill of Lading OutSTR30String30
59Shipping_Method_Out SearchShipping Method OutSTR15_Shipping_MethodString15
60Bill_of_Lading SearchBill of LadingSTR30String30
61SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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 NumberSTR40String40
63NOTEINDX SearchNote IndexDLR14Currency14
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_LBAUString17
65Voucher_Number_Invoice SearchVoucher Number InvoiceSTR17_LBAUString17
66Voucher_Number_Reimburse SearchVoucher Number ReimbursementSTR17_LBAUString17
67CUSTOWN SearchCustomer OwnedCBBoolean0
68USERDEF1 SearchUser Defined 1STR20String20
69USERDEF2 SearchUser Defined 2STR20String20
70USRDEF03 SearchUser Defined 3STR20String20
71USRDEF04 SearchUser Defined 4STR20String20
72USRDEF05 SearchUser Defined 5STR20String20
73Part_Price SearchPart PriceDLR17_RBS0_STR$Currency17
74Part_Cost SearchPart CostDLR17_RBS0_STR$Currency17
75Labor_Price SearchLabor PriceDLR17_RBS0_STR$Currency17
76Labor_Cost SearchLabor CostDLR17_RBS0_STR$Currency17
77Expense_Price SearchExpense PriceDLR17_RBS0_STR$Currency17
78Expense_Cost SearchExpense CostDLR17_RBS0_STR$Currency17
79Travel_Price SearchTravel PriceDLR17_RBS0_STR$Currency17
80Travel_Cost SearchTravel CostDLR17_RBS0_STR$Currency17
81Originating_Part_Price SearchOriginating Part PriceDLR17_RBS0_STR$Currency17
82Originating_Part_Cost SearchOriginating Part CostDLR17_RBS0_STR$Currency17
83Originating_Labor_Price SearchOriginating Labor PriceDLR17_RBS0_STR$Currency17
84Originating_Labor_Cost SearchOriginating Labor CostDLR17_RBS0_STR$Currency17
85Originating_ExpensePrice SearchOriginating Expense PriceDLR17_RBS0_STR$Currency17
86Originating_Expense_Cost SearchOriginating Expense CostDLR17_RBS0_STR$Currency17
87Originating_Travel_Price SearchOriginating Travel PriceDLR17_RBS0_STR$Currency17
88Originating_Travel_Cost SearchOriginating Travel CostDLR17_RBS0_STR$Currency17
89QTYTYPE SearchQTY TypeDDL_QTY_TypeInteger0
90DEX_ROW_ID Searchintint10

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 *