Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV000811
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Job_Costs_WORK_Report
Physical Name: SV000811
Technical Name: SV_Job_Costs_WORK_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Service_Call_ID 
Service Call ID STR17_LBAU String 17 2 Call_Invoice_Number Call Invoice Number STR17_LBAU String 17 3 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 4 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 5 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 6 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Job_Costs_WORK_Report'].USERID AS 'SV_Job_Costs_WORK_Report-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV000811 AS ['SV_Job_Costs_WORK_Report']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Job_Costs_WORK_Report'].USERID = ['Users Master'].USERID7 Technician_ID Technician ID STR15_Employee_ID String 15 8 Technician_Team Technician Team STR15_LBAU String 15 9 Reference_TRX_Number Reference TRX Number STR17_LBAU String 17 10 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Job_Costs_WORK_Report'].CUSTNMBR AS 'SV_Job_Costs_WORK_Report-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV000811 AS ['SV_Job_Costs_WORK_Report']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Job_Costs_WORK_Report'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR11 ADRSCODE Address Code STR15_Address_Code String 15 12 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 13 WS_Job_Name WS Job Name STR30 String 30 14 Job_Type Job Type STR7_LBAU String 7 15 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 16 Cost_Code_Description Cost Code Description STR30 String 30 17 Task_Code Task Code STR10 String 10 18 DOCTYPE Document Type DDL_Document_Type Integer 0 19 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 20 DOCDATE Document Date DT Date 8 21 TRXDSCRN Transaction Description STR30 String 30 22 Billable_Check_Box Billable Check Box CB_Billable Boolean 0 23 TAXABLE Taxable CB_Taxable Boolean 0 24 TRXSOURC Transaction Source STR25 String 25 25 Billing_Amount Billing Amount DLR14_RBS0_STR$ Currency 14 26 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['SV_Job_Costs_WORK_Report'].VENDORID AS 'SV_Job_Costs_WORK_Report-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SV000811 AS ['SV_Job_Costs_WORK_Report']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SV_Job_Costs_WORK_Report'].VENDORID = ['PM Vendor Master File'].VENDORID27 VENDNAME Vendor Name STR64_Vendor_Name String 64 28 Equipment_ID Equipment ID STR30 String 30 29 Equipment_Type Equipment Type STR30 String 30 30 Dynamics_Status Dynamics Status STR4_LBAU String 4 31 Wennsoft_Status Wennsoft Status STR4_LBAU String 4 32 BACHNUMB Batch Number STR15_LBAU String 15 33 BCHSOURC Batch Source STR15 String 15 34 TRXHRUNT TRX Hours/Units LI6_S2 Long Integer 6 35 EMPLOYID Employee ID STR15_Employee_ID String 15 36 EMPLNAME Employee Name STR40 String 40 37 VCHNUMWK Voucher Number - WORK STR17_LBAU String 17 38 OH_Amount OH Amount DLR14_RBS0_STR$ Currency 14 39 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 17 40 WS_Extended_Cost WS Extended Cost DLR14_RBS0_STR$ Currency 14 41 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 17 42 UOFM U Of M U_Of_M String 8 43 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SV_Job_Costs_WORK_Report'].ITEMNMBR AS 'SV_Job_Costs_WORK_Report-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SV000811 AS ['SV_Job_Costs_WORK_Report']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SV_Job_Costs_WORK_Report'].ITEMNMBR = ['Item Master'].ITEMNMBR44 ITEMDESC Item Description STR100 String 100 45 UNITPRCE Unit Price DLR17_RBS0_STR$ Currency 17 46 JOBTITLE Job Title STR6_Payroll_Code String 6 47 PAYRCORD Pay Record STR6_Payroll_Code String 6 48 PAYRATE Pay Rate DLR11_$S2 Currency 14 49 Billing_Rate Billing Rate DLR14_RBS0_STR$ Currency 14 50 Add_New_Equipment_Record Add New Equipment Record CB Boolean 0 51 New_Equipment_ID New Equipment ID STR10 String 10 52 Wennsoft_Model_Number Wennsoft Model Number STR20 String 20 53 Wennsoft_Serial_Number Wennsoft Serial Number STR40 String 40 54 Manufacturer_ID Manufacturer ID STR15_LBAU String 15 55 Note_Checkbox Note Checkbox CB Boolean 0 56 TRXHRUNTBILL TRX Hours/Units Bill LI6_S2 Long Integer 6 57 WS_Committed_Cost WS Committed Cost DLR14_RBS0_STR$ Currency 14 58 TRXQTYBILL TRX QTY BILL DLR17_QTY_RBS0_STR Currency 17 59 ACTINDX_CR Account Index Credit LI_14 Long Integer 14 60 ACTINDX_DR Account Index Debit LI_14 Long Integer 14 61 SHFTCODE Shift Code STR6_Payroll_Code String 6 62 SHFTPREM Shift Premium DLR11_$S2 Currency 14 63 Labor_Group_Name Labor Group Name STR15_RM_Customer_Number String 15 64 Pricing_Matrix_Name Pricing Matrix Name STR15_RM_Customer_Number String 15 65 Travel_Rate_Name Travel Rate Name STR15_RM_Customer_Number String 15 66 Service_User_Define_1 Service User Define 1 STR20 String 20 67 Service_User_Define_2 Service User Define 2 STR20 String 20 68 Service_User_Define_5 Service User Define 5 LI6_S2 Long Integer 6 69 Service_User_Define_6 Service User Define 6 LI6_S2 Long Integer 6 70 Service_User_Define_7 Service User Define 7 LI6_S2 Long Integer 6 71 Service_User_Define_8 Service User Define 8 LI6_S2 Long Integer 6 72 Service_User_Define_9 Service User Define 9 DT Date 8 73 Service_User_Define_10 Service User Define 10 DT Date 8 74 Service_User_Define_11 Service User Define 11 DT Date 8 75 Service_User_Define_12 Service User Define 12 DT Date 8 76 Service_User_Define_18 Service User Define 18 CB Boolean 0 77 Service_User_Define_19 Service User Define 19 CB Boolean 0 78 Service_User_Define_20 Service User Define 20 CB Boolean 0 79 Service_User_Define_21 Service User Define 21 CB Boolean 0 80 Service_User_Define_22 Service User Define 22 DLR14_RBS0_STR$ Currency 14 81 Service_User_Define_23 Service User Define 23 DLR14_RBS0_STR$ Currency 14 82 Service_User_Define_24 Service User Define 24 DLR14_RBS0_STR$ Currency 14 83 Service_User_Define_25 Service User Define 25 DLR14_RBS0_STR$ Currency 14 84 MODIFDT Modified Date DT Date 8 85 Modified_Time Modified Time TM6 Time 6 86 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Job_Costs_WORK_Report'].MDFUSRID AS 'SV_Job_Costs_WORK_Report-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV000811 AS ['SV_Job_Costs_WORK_Report']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Job_Costs_WORK_Report'].MDFUSRID = ['Users Master'].USERID87 Time_Zone Time Zone STR3 String 3 88 SV_Language_ID SV Language ID INT2 Integer 2 89 Base_Currency_ID Base Currency ID STR15_Currency_ID String 15 90 Base_Curr_Conv_Factor Base Curr Conversion Factor DLR14_Exchange_Rate Currency (Variable) 14 91 Billing_Currency_ID Billing Currency ID STR15_Currency_ID String 15 92 Billing_Curr_Conv_Factor Billing Curr Conversion Factor DLR14_Exchange_Rate Currency (Variable) 14 93 Local_Currency_ID Local Currency ID STR15_Currency_ID String 15 94 WSReserved_CB1 WSReserved CB1 CB Boolean 0 95 WSReserved_CB2 WSReserved CB2 CB Boolean 0 96 WSReserved_CB3 WSReserved CB3 CB Boolean 0 97 WSReserved_CB4 WSReserved CB4 CB Boolean 0 98 WSReserved_CB5 WSReserved CB5 CB Boolean 0 99 WSReserved_CB6 WSReserved CB6 CB Boolean 0 100 WSReserved_CB7 WSReserved CB7 CB Boolean 0 101 WSReserved_CB8 WSReserved CB8 CB Boolean 0 102 WSReserved_CB9 WSReserved CB9 CB Boolean 0 103 WSReserved_CB10 WSReserved CB10 CB Boolean 0 104 WSReserved_STR1 WSReserved STR1 STR10 String 10 105 WSReserved_STR2 WSReserved STR2 STR10 String 10 106 WS_Created_Date WS Created Date DT Date 8 107 WS_Created_Time WS Created Time TM6 Time 6 108 WS_Transaction_Note WS Transaction Note TX500 Text 500