Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVINTER7
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: ServiceJCHWarehouse
Physical Name: SVINTER7
Technical Name: ServiceJCHWarehouseSeq 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
['ServiceJCHWarehouse'].USERID AS 'ServiceJCHWarehouse-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ServiceJCHWarehouse'].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
['ServiceJCHWarehouse'].CUSTNMBR AS 'ServiceJCHWarehouse-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ServiceJCHWarehouse'].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
['ServiceJCHWarehouse'].VENDORID AS 'ServiceJCHWarehouse-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ServiceJCHWarehouse'].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
['ServiceJCHWarehouse'].ITEMNMBR AS 'ServiceJCHWarehouse-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ServiceJCHWarehouse'].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 Service_User_Define_1 Service User Define 1 STR20 String 20 57 Service_User_Define_2 Service User Define 2 STR20 String 20 58 Service_User_Define_5 Service User Define 5 LI6_S2 Long Integer 6 59 Service_User_Define_6 Service User Define 6 LI6_S2 Long Integer 6 60 Service_User_Define_7 Service User Define 7 LI6_S2 Long Integer 6 61 Service_User_Define_8 Service User Define 8 LI6_S2 Long Integer 6 62 Service_User_Define_9 Service User Define 9 DT Date 8 63 Service_User_Define_10 Service User Define 10 DT Date 8 64 Service_User_Define_11 Service User Define 11 DT Date 8 65 Service_User_Define_12 Service User Define 12 DT Date 8 66 Service_User_Define_18 Service User Define 18 CB Boolean 0 67 Service_User_Define_19 Service User Define 19 CB Boolean 0 68 Service_User_Define_20 Service User Define 20 CB Boolean 0 69 Service_User_Define_21 Service User Define 21 CB Boolean 0 70 Service_User_Define_22 Service User Define 22 DLR14_RBS0_STR$ Currency 14 71 Service_User_Define_23 Service User Define 23 DLR14_RBS0_STR$ Currency 14 72 Service_User_Define_24 Service User Define 24 DLR14_RBS0_STR$ Currency 14 73 Service_User_Define_25 Service User Define 25 DLR14_RBS0_STR$ Currency 14 74 MODIFDT Modified Date DT Date 8 75 Modified_Time Modified Time TM6 Time 6 76 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ServiceJCHWarehouse'].MDFUSRID AS 'ServiceJCHWarehouse-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVINTER7 AS ['ServiceJCHWarehouse']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ServiceJCHWarehouse'].MDFUSRID = ['Users Master'].USERID77 Time_Zone Time Zone STR3 String 3 78 SV_Language_ID SV Language ID INT2 Integer 2 79 Base_Currency_ID Base Currency ID STR15_Currency_ID String 15 80 Base_Curr_Conv_Factor Base Curr Conversion Factor DLR14_Exchange_Rate Currency (Variable) 14 81 Billing_Currency_ID Billing Currency ID STR15_Currency_ID String 15 82 Billing_Curr_Conv_Factor Billing Curr Conversion Factor DLR14_Exchange_Rate Currency (Variable) 14 83 Local_Currency_ID Local Currency ID STR15_Currency_ID String 15 84 WSReserved_CB1 WSReserved CB1 CB Boolean 0 85 WSReserved_CB2 WSReserved CB2 CB Boolean 0 86 WSReserved_CB3 WSReserved CB3 CB Boolean 0 87 WSReserved_CB4 WSReserved CB4 CB Boolean 0 88 WSReserved_CB5 WSReserved CB5 CB Boolean 0 89 WSReserved_CB6 WSReserved CB6 CB Boolean 0 90 WSReserved_CB7 WSReserved CB7 CB Boolean 0 91 WSReserved_CB8 WSReserved CB8 CB Boolean 0 92 WSReserved_CB9 WSReserved CB9 CB Boolean 0 93 WSReserved_CB10 WSReserved CB10 CB Boolean 0 94 WSReserved_STR1 WSReserved STR1 STR10 String 10 95 WSReserved_STR2 WSReserved STR2 STR10 String 10 96 WS_Created_Date WS Created Date DT Date 8 97 WS_Created_Time WS Created Time TM6 Time 6 98 WS_Transaction_Note WS Transaction Note TX500 Text 500