Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS20003
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS_MT_POP_WORK
Physical Name: WS20003
Technical Name: WS_MT_POP_WORKSeq 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 Technician Technician STR10_LBAU String 10 4 PONUMBER PO Number STR17_POP_Number String 17 5 ORD Ord LI_Sequence_Number Long Integer 10 6 WS_Transaction_Date WS Transaction Date DT Date 8 7 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['WS_MT_POP_WORK'].VENDORID AS 'WS_MT_POP_WORK-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
WS20003 AS ['WS_MT_POP_WORK']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['WS_MT_POP_WORK'].VENDORID = ['PM Vendor Master File'].VENDORID8 VENDNAME Vendor Name STR64_Vendor_Name String 64 9 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['WS_MT_POP_WORK'].ITEMNMBR AS 'WS_MT_POP_WORK-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
WS20003 AS ['WS_MT_POP_WORK']
INNER JOIN
IV00101 AS ['Item Master']
ON
['WS_MT_POP_WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR10 ITEMDESC Item Description STR100 String 100 11 UOFM U Of M U_Of_M String 8 12 QTYORDER QTY Ordered DLR17_QTY_RBS0_UTR Currency 17 13 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 14 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['WS_MT_POP_WORK'].LOCNCODE AS 'WS_MT_POP_WORK-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
WS20003 AS ['WS_MT_POP_WORK']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['WS_MT_POP_WORK'].LOCNCODE = ['Site Setup'].LOCNCODE15 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 16 WS_Other_Cost_Sub_Code WS Other Cost Sub Code LI8_U0 Long Integer 8 17 Product_Indicator Product Indicator DDL_Product_Indicator Integer 0 18 Billable_Amount Billable Amount DLR14_RBS0_STR$ Currency 14 19 Invoiced Invoiced True/False Boolean 0 20 eConnect_Error_Code eConnect Error Code long Long Integer 8 21 WS_Job_Number WS Job Number STR17_LBAU String 17 22 Cost_Code_Alias Cost Code Alias STR26 String 26