SVC_RTV_Line_HIST (SVC35601)

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_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RTV_Number SearchRTV NumberStringSTR15_LBAU15
2RTV_Line SearchRTV LineCurrencySequence_Number19
3RTV_Type SearchRTV TypeStringSTR10_LBAU10
4RTV_Status SearchRTV StatusIntegerDDL_RTV_Type0
5RTV_Return_Status SearchRTV Return StatusStringSTR3_LBAU3
6VRMA_Document_ID SearchVRMA Document IDStringSTR15_LBAU15
7RETDOCID SearchReturn Document IDStringSTR15_LBAU15
8LNSEQNBR SearchLine SEQ NumberCurrencySequence_Number19
9SVC_Process_SEQ_Number SearchSVC Process SEQ NumberCurrencySequence_Number19
10DSCRIPTN SearchDescriptionStringSTR3030
11REFRENCE SearchReferenceStringSTR3030
12Reference2 SearchReference2StringSTR3030
13ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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'].ITEMNMBR
14ITEMDESC SearchItem DescriptionStringSTR100100
15ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
16DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
17QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
18QTYSHPPD SearchQTY ShippedCurrencyDLR17_QTY_RBS0_UTR17
19QTY_To_Receive SearchQTY To ReceiveCurrencyDLR17_QTY_RBS0_STR17
20QTYRECVD SearchQTY ReceivedCurrencyDLR17_QTY_RBS0_UTR17
21QTYCANCE SearchQTY CanceledCurrencyDLR17_QTY_RBS0_UTR17
22UOFM SearchU Of MStringU_Of_M8
23VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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'].VENDORID
24VNDITNUM SearchVendor Item NumberStringItem_Number30
25Return_Item_Number SearchReturn Item NumberStringSTR30_Item_Number30
26OFFID SearchOffice IDStringSTR10_LBAU10
27LOCCODEB SearchLocation Code BadStringSTR10_Location_Code10
28LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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'].LOCNCODE
29ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
30Ship_Address_Name SearchShip Address NameStringSTR64_Vendor_Name64
31Ship_Address_1 SearchShip Address 1StringSTR6060
32Ship_Address_2 SearchShip Address 2StringSTR6060
33Ship_Address_3 SearchShip Address 3StringSTR6060
34Ship_City SearchShip CityStringSTR3535
35Ship_State SearchShip StateStringSTR30_State29
36ZIPCODE SearchZip CodeStringSTR1010
37Ship_Country SearchShip CountryStringSTR6060
38ENTDTE SearchEntry DateDateDT_Date6
39ENTTME SearchEntry TimeTimeTM66
40PRMDATE SearchPromised DateDateDATE_L0
41Promised_Time SearchPromised TimeTimeTM66
42Shipped_Date SearchShipped DateDateDT_Date6
43Shipped_Time SearchShipped TimeTimeTM66
44receiptdate SearchReceipt DateDateDT8
45Receipt_Time SearchReceipt TimeTimeTM66
46COMPDTE SearchComplete DateDateDT_Date6
47COMPTME SearchComplete TimeTimeTM66
48PONMBRSTR SearchPurchase_Order_Number_STRStringSTR17_LBAU17
49POLNSEQ SearchPurchase_Order_Line_Sequence_DOLCurrencyDLR17_RBS0_STR17
50POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
51RCPTLNNM SearchReceipt Line NumberLong IntegerLI_Sequence_Number10
52Transfer_Reference SearchTransfer ReferenceStringSTR3030
53TRANSLINESEQ SearchTransfer Line Item SequenceLong IntegerLI_Sequence_Number10
54CALLNBR SearchService Call NumberStringSTR10_LBAU10
55EQPLINE SearchEquipment Line Item SequenceLong IntegerLI_Sequence_Number10
56LINITMTYP SearchLine Item TypeStringSTR33
57LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
58Bill_of_Lading_Out SearchBill of Lading OutStringSTR3030
59Shipping_Method_Out SearchShipping Method OutStringSTR15_Shipping_Method15
60Bill_of_Lading SearchBill of LadingStringSTR3030
61SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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'].SHIPMTHD
62Tracking_Number SearchTracking NumberStringSTR4040
63NOTEINDX SearchNote IndexCurrencyDLR1414
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'].NOTEINDX
64VCHNUMWK SearchVoucher Number - WORKStringSTR17_LBAU17
65Voucher_Number_Invoice SearchVoucher Number InvoiceStringSTR17_LBAU17
66Voucher_Number_Reimburse SearchVoucher Number ReimbursementStringSTR17_LBAU17
67CUSTOWN SearchCustomer OwnedBooleanCB0
68USERDEF1 SearchUser Defined 1StringSTR2020
69USERDEF2 SearchUser Defined 2StringSTR2020
70USRDEF03 SearchUser Defined 3StringSTR2020
71USRDEF04 SearchUser Defined 4StringSTR2020
72USRDEF05 SearchUser Defined 5StringSTR2020
73Part_Price SearchPart PriceCurrencyDLR17_RBS0_STR$17
74Part_Cost SearchPart CostCurrencyDLR17_RBS0_STR$17
75Labor_Price SearchLabor PriceCurrencyDLR17_RBS0_STR$17
76Labor_Cost SearchLabor CostCurrencyDLR17_RBS0_STR$17
77Expense_Price SearchExpense PriceCurrencyDLR17_RBS0_STR$17
78Expense_Cost SearchExpense CostCurrencyDLR17_RBS0_STR$17
79Travel_Price SearchTravel PriceCurrencyDLR17_RBS0_STR$17
80Travel_Cost SearchTravel CostCurrencyDLR17_RBS0_STR$17
81Originating_Part_Price SearchOriginating Part PriceCurrencyDLR17_RBS0_STR$17
82Originating_Part_Cost SearchOriginating Part CostCurrencyDLR17_RBS0_STR$17
83Originating_Labor_Price SearchOriginating Labor PriceCurrencyDLR17_RBS0_STR$17
84Originating_Labor_Cost SearchOriginating Labor CostCurrencyDLR17_RBS0_STR$17
85Originating_ExpensePrice SearchOriginating Expense PriceCurrencyDLR17_RBS0_STR$17
86Originating_Expense_Cost SearchOriginating Expense CostCurrencyDLR17_RBS0_STR$17
87Originating_Travel_Price SearchOriginating Travel PriceCurrencyDLR17_RBS0_STR$17
88Originating_Travel_Cost SearchOriginating Travel CostCurrencyDLR17_RBS0_STR$17
89QTYTYPE SearchQTY TypeIntegerDDL_QTY_Type0

Leave a Reply

Your email address will not be published. Required fields are marked *