SV_Service_Costs_VIEW (SV_Costs)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Service_Costs_VIEW
Physical Name: SV_Costs
Technical Name: SV_Service_Costs_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Service_Call_ID SearchService Call IDSTR17_LBAUString1817
2Call_Invoice_Number SearchCall Invoice NumberSTR17_LBAUString1817
3JRNENTRY SearchJournal EntryLI8_U0Long Integer48
4OH_ACTINDX_CR SearchOH Account Index CRLI_14Long Integer414
5OH_ACTINDX_DR SearchOH Account Index DRLI_14Long Integer414
6Divisions SearchDivisionsSTR15_LBAUString1615
7UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
8Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
9Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
10Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
11USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_Costs_VIEW'].USERID AS 'SV_Service_Costs_VIEW-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV_Costs AS ['SV_Service_Costs_VIEW']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_Costs_VIEW'].USERID = ['Users Master'].USERID
12Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
13Technician_Team SearchTechnician TeamSTR15_LBAUString1615
14Reference_TRX_Number SearchReference TRX NumberSTR17_LBAUString1817
15CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Service_Costs_VIEW'].CUSTNMBR AS 'SV_Service_Costs_VIEW-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV_Costs AS ['SV_Service_Costs_VIEW']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Service_Costs_VIEW'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
16ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
17SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
18WS_Job_Name SearchWS Job NameSTR30String3230
19Job_Type SearchJob TypeSTR7_LBAUString87
20WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
21WS_Cost_Code_STR SearchWS Cost Code STRSTR20_LBAUString2220
22Cost_Code_Description SearchCost Code DescriptionSTR30String3230
23Task_Code SearchTask CodeSTR10String1210
24DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
25DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
26DOCDATE SearchDocument DateDTDate48
27TRXDSCRN SearchTransaction DescriptionSTR30String3230
28Billable_Check_Box SearchBillable Check BoxCB_BillableBoolean20
29TAXABLE SearchTaxableCB_TaxableBoolean20
30TRXSOURC SearchTransaction SourceSTR25String2625
31Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency1014
32VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SV_Service_Costs_VIEW'].VENDORID AS 'SV_Service_Costs_VIEW-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       SV_Costs AS ['SV_Service_Costs_VIEW']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SV_Service_Costs_VIEW'].VENDORID = ['PM Vendor Master File'].VENDORID
33VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
34Equipment_ID SearchEquipment IDSTR30String3230
35Equipment_Type SearchEquipment TypeSTR30String3230
36Dynamics_Status SearchDynamics StatusSTR4_LBAUString64
37Wennsoft_Status SearchWennsoft StatusSTR4_LBAUString64
38BACHNUMB SearchBatch NumberSTR15_LBAUString1615
39BCHSOURC SearchBatch SourceSTR15String1615
40TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
41EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
42EMPLNAME SearchEmployee NameSTR40String4240
43VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
44OH_Amount SearchOH AmountDLR14_RBS0_STR$Currency1014
45EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
46WS_Extended_Cost SearchWS Extended CostDLR14_RBS0_STR$Currency1014
47TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
48UOFM SearchU Of MU_Of_MString108
49ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SV_Service_Costs_VIEW'].ITEMNMBR AS 'SV_Service_Costs_VIEW-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SV_Costs AS ['SV_Service_Costs_VIEW']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SV_Service_Costs_VIEW'].ITEMNMBR = ['Item Master'].ITEMNMBR
50ITEMDESC SearchItem DescriptionSTR100String102100
51UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
52JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
53PAYRCORD SearchPay RecordSTR6_Payroll_CodeString86
54PAYRATE SearchPay RateDLR11_$S2Currency1014
55Billing_Rate SearchBilling RateDLR14_RBS0_STR$Currency1014
56Add_New_Equipment_Record SearchAdd New Equipment RecordCBBoolean20
57New_Equipment_ID SearchNew Equipment IDSTR10String1210
58Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String2220
59Wennsoft_Serial_Number SearchWennsoft Serial NumberSTR40String4240
60Manufacturer_ID SearchManufacturer IDSTR15_LBAUString1615
61Note_Checkbox SearchNote CheckboxCBBoolean20
62TRXHRUNTBILL SearchTRX Hours/Units BillLI6_S2Long Integer46
63WS_Committed_Cost SearchWS Committed CostDLR14_RBS0_STR$Currency1014
64TRXQTYBILL SearchTRX QTY BILLDLR17_QTY_RBS0_STRCurrency1017
65WIP_ACTINDX_CR SearchWIP Account Index CreditLI_14Long Integer414
66OH_WIP_ACTINDX_CR SearchOH WIP Account Index CreditLI_14Long Integer414
67ACTINDX_CR SearchAccount Index CreditLI_14Long Integer414
68ACTINDX_DR SearchAccount Index DebitLI_14Long Integer414
69INV_ACTINDX_DR SearchInvoice Account Index DebitLI_14Long Integer414
70INV_ACTINDX_CR SearchInvoice Account Index CreditLI_14Long Integer414
71SHFTCODE SearchShift CodeSTR6_Payroll_CodeString86
72SHFTPREM SearchShift PremiumDLR11_$S2Currency1014
73Labor_Group_Name SearchLabor Group NameSTR15_RM_Customer_NumberString1615
74Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString1615
75Travel_Rate_Name SearchTravel Rate NameSTR15_RM_Customer_NumberString1615
76Service_User_Define_1 SearchService User Define 1STR20String2220
77Service_User_Define_2 SearchService User Define 2STR20String2220
78Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
79Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
80Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer46
81Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer46
82Service_User_Define_9 SearchService User Define 9DTDate48
83Service_User_Define_10 SearchService User Define 10DTDate48
84Service_User_Define_11 SearchService User Define 11DTDate48
85Service_User_Define_12 SearchService User Define 12DTDate48
86Service_User_Define_18 SearchService User Define 18CBBoolean20
87Service_User_Define_19 SearchService User Define 19CBBoolean20
88Service_User_Define_20 SearchService User Define 20CBBoolean20
89Service_User_Define_21 SearchService User Define 21CBBoolean20
90Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
91Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
92Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
93Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency1014
94MODIFDT SearchModified DateDTDate48
95Modified_Time SearchModified TimeTM6Time46
96MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Service_Costs_VIEW'].MDFUSRID AS 'SV_Service_Costs_VIEW-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV_Costs AS ['SV_Service_Costs_VIEW']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Service_Costs_VIEW'].MDFUSRID = ['Users Master'].USERID
97Time_Zone SearchTime ZoneSTR3String43
98SV_Language_ID SearchSV Language IDINT2Integer22
99Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
100Base_Curr_Conv_Factor SearchBase Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)1014
101Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
102Billing_Curr_Conv_Factor SearchBilling Curr Conversion FactorDLR14_Exchange_RateCurrency (Variable)1014
103Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
104WSReserved_CB1 SearchWSReserved CB1CBBoolean20
105WSReserved_CB2 SearchWSReserved CB2CBBoolean20
106WSReserved_CB3 SearchWSReserved CB3CBBoolean20
107WSReserved_CB4 SearchWSReserved CB4CBBoolean20
108WSReserved_CB5 SearchWSReserved CB5CBBoolean20
109WSReserved_CB6 SearchWSReserved CB6CBBoolean20
110WSReserved_CB7 SearchWSReserved CB7CBBoolean20
111WSReserved_CB8 SearchWSReserved CB8CBBoolean20
112WSReserved_CB9 SearchWSReserved CB9CBBoolean20
113WSReserved_CB10 SearchWSReserved CB10CBBoolean20
114WSReserved_STR1 SearchWSReserved STR1STR10String1210
115WSReserved_STR2 SearchWSReserved STR2STR10String1210
116WS_Created_Date SearchWS Created DateDTDate48
117WS_Created_Time SearchWS Created TimeTM6Time46
118GLPOSTDT SearchGL Posting DateDTDate48
119DATE1 SearchDateDT6Date46
120Contract_Number SearchWS Contract NumberSTR10String1210
121WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer410
122Contract_Start_Date SearchWS Contract Start DateDTDate48
123Contract_Expiration_Date SearchContract Experation DateDTDate48
124WS_Transaction_Note SearchWS Transaction NoteTX500Text2500

Leave a Reply

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