Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS30002
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS_MT_INV_WORK_HIST
Physical Name: WS30002
Technical Name: WS_MT_INV_WORK_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Service_Call_ID 
Service Call ID STR17_LBAU String 17 2 Appointment Appointment STR25 String 25 3 WS_Transaction_Date WS Transaction Date DT Date 8 4 Equipment_ID Equipment ID STR30 String 30 5 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 6 WS_Other_Cost_Sub_Code WS Other Cost Sub Code LI8_U0 Long Integer 8 7 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['WS_MT_INV_WORK_HIST'].ITEMNMBR AS 'WS_MT_INV_WORK_HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
WS30002 AS ['WS_MT_INV_WORK_HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['WS_MT_INV_WORK_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR8 ITEMDESC Item Description STR100 String 100 9 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 17 10 Cost_Per_Unit Cost Per Unit DLR8_RBU Currency 8 11 UOFM U Of M U_Of_M String 8 12 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['WS_MT_INV_WORK_HIST'].LOCNCODE AS 'WS_MT_INV_WORK_HIST-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
WS30002 AS ['WS_MT_INV_WORK_HIST']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['WS_MT_INV_WORK_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE13 Billable_Amount Billable Amount DLR14_RBS0_STR$ Currency 14 14 Invoiced Invoiced True/False Boolean 0 15 eConnect_Error_Code eConnect Error Code long Long Integer 8 16 SERLNMBR Serial Number STR20_LBAU String 20 17 WS_Job_Number WS Job Number STR17_LBAU String 17 18 Cost_Code_Alias Cost Code Alias STR26 String 26 19 Product_Indicator Product Indicator DDL_Product_Indicator Integer 0 20 UNITPRCE Unit Price DLR17_RBS0_STR$ Currency 17