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