Integration with Computers Unlimited 3.0 - Revision history

Jgreco: Initial proofread pass - docs

2021-12-01T17:40:13Z

Initial proofread pass - docs

Lsilverman at 18:58, 12 February 2010

2010-02-12T18:58:57Z

Lsilverman: moved Integration with Computers Unlimited 3.0 clients to Integration with Computers Unlimited 3.0

2009-09-22T20:45:11Z

moved Integration with Computers Unlimited 3.0 clients to Integration with Computers Unlimited 3.0

Lsilverman: /* Queries */

2009-09-22T19:28:39Z

Queries

Lsilverman: /* Queries */

2009-09-22T19:25:16Z

Queries

Lsilverman: /* VB Module */

2009-09-22T19:24:17Z

VB Module

Lsilverman: /* What you'll need on the client PC */

2009-09-22T19:23:46Z

What you'll need on the client PC

Lsilverman at 19:21, 22 September 2009

2009-09-22T19:21:35Z

Jnichols at 14:09, 27 May 2009

2009-05-27T14:09:42Z

Jnichols at 14:08, 27 May 2009

2009-05-27T14:08:14Z

@@ Line 52: / Line 52: @@
 Function lpad(MyValue$, MyPadCharacter$, MyPaddedLength%)
-      PadLength = MyPaddedLength - Len(MyValue)
+   PadLength = MyPaddedLength - Len(MyValue)
-      Dim PadString As String
+   Dim PadString As String
-      For x = 1 To PadLength
+   For x = 1 To PadLength
-         PadString = PadString &amp; MyPadCharacter
+     PadString = PadString &amp; MyPadCharacter
-      Next
+   Next
-      lpad = PadString + MyValue
+   lpad = PadString + MyValue
 End Function
@@ Line 75: / Line 75: @@
 <syntaxhighlight lang="tsql">
 SELECT
-  jwe_LINHST.CUSNO,
+ jwe_LINHST.CUSNO,
-  jwe_CUSMAS.LAST_NAME,
+ jwe_CUSMAS.LAST_NAME,
-  lpad(jwe_LINHST.ORDNO,0,8) & lpad(jwe_LINHST.BAKNO,0,2) AS Ordno,
+ lpad(jwe_LINHST.ORDNO,0,8) & lpad(jwe_LINHST.BAKNO,0,2) AS Ordno,
-  jwe_LINHST.INVDTE,
+ jwe_LINHST.INVDTE,
-  jwe_LINHST. INVDTE,
+ jwe_LINHST. INVDTE,
-  jwe_LINHST. INVDTE,
+ jwe_LINHST. INVDTE,
-  jwe_LINHST.PART AS Expr3,
+ jwe_LINHST.PART AS Expr3,
-  Replace(jwe_INVMAS.DESCR1+jwe_INVMAS.DESCR2,',',' ') AS Expr4,
+ Replace(jwe_INVMAS.DESCR1+jwe_INVMAS.DESCR2,',',' ') AS Expr4,
-  jwe_LINHST.CYLSHIP,
+ jwe_LINHST.CYLSHIP,
-  jwe_LINHST.CYLRET,
+ jwe_LINHST.CYLRET,
-  jwe_LINHST.PONO
+ jwe_LINHST.PONO
 FROM jwe_LINHST,
 	jwe_CUSMAS,
@@ Line 98: / Line 98: @@
 <syntaxhighlight lang="tsql">
 SELECT
-  jwe_ORDHDR.OCUSNO,
+ jwe_ORDHDR.OCUSNO,
-  jwe_ORDHDR.OCUSNM,
+ jwe_ORDHDR.OCUSNM,
-  lpad(jwe_ORDHDR.OORDNO,0,8) & lpad(jwe_ORDHDR.OBAKNO,0,2) AS Expr1,
+ lpad(jwe_ORDHDR.OORDNO,0,8) & lpad(jwe_ORDHDR.OBAKNO,0,2) AS Expr1,
-  jwe_ORDHDR.OORDDT,
+ jwe_ORDHDR.OORDDT,
-  jwe_ORDHDR.OORDDT,
+ jwe_ORDHDR.OORDDT,
-  jwe_ORDHDR.OORDDT,
+ jwe_ORDHDR.OORDDT,
-  jwe_ORDLIN.LITMNO_ITEM,
+ jwe_ORDLIN.LITMNO_ITEM,
-  jwe_ORDLIN.LDESCR1,
+ jwe_ORDLIN.LDESCR1,
-  jwe_ORDLGAS.LSHIP,
+ jwe_ORDLGAS.LSHIP,
-  jwe_ORDLGAS.LRET,
+ jwe_ORDLGAS.LRET,
-  jwe_ORDHDR.OPONO
+ jwe_ORDHDR.OPONO
 FROM jwe_ORDHDR,
-  jwe_ORDLGAS,
+ jwe_ORDLGAS,
-  jwe_ORDLIN
+ jwe_ORDLIN
 WHERE (((jwe_ORDHDR.OORDNO)=[jwe_ORDLGAS].[LGAS_ORDNO] And (jwe_ORDHDR.OORDNO)=[jwe_ORDLIN].[LORDNO]) AND ((jwe_ORDHDR.OBAKNO)=[jwe_ORDLGAS].[LGAS_SEQNO] And (jwe_ORDHDR.OBAKNO)=[jwe_ORDLIN].[LSEQNO]) AND ((jwe_ORDLIN.LITMNO_SUP)='GAS') AND ((jwe_ORDLIN.LINENUMA)=[jwe_ORDLGAS].[LGAS_LINENUMA])) and jwe_ORDHDR.OFLAG=1;
 </syntaxhighlight>

← Older revision		Revision as of 18:58, 12 February 2010
Line 1:		Line 1:
		+	==Overview==
	CU 3.0 runs on Microsoft SQL Server. TrackAbout customers interact with TIMS 3.0 by logging into a Remote Desktop connection, and running the TIMS front end directly on their server.		CU 3.0 runs on Microsoft SQL Server. TrackAbout customers interact with TIMS 3.0 by logging into a Remote Desktop connection, and running the TIMS front end directly on their server.

@@ Line 71: / Line 71: @@
 ===Query for "invoiced" invoices in the current calendar month ===
+Adjust the query parameters for the dates.
 <syntaxhighlight lang="tsql">
-SELECT jwe_LINHST.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINHST.ORDNO,0,8) & lpad(jwe_LINHST.BAKNO,0,2) AS Ordno, jwe_LINHST.INVDTE, jwe_LINHST. INVDTE, jwe_LINHST. INVDTE, jwe_LINHST.PART AS Expr3, Replace(jwe_INVMAS.DESCR1+jwe_INVMAS.DESCR2,',',' ') AS Expr4, jwe_LINHST.CYLSHIP, jwe_LINHST.CYLRET, jwe_LINHST.PONO FROM jwe_LINHST, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINHST.CUSNO)=jwe_CUSMAS.CUSNO) And ((jwe_LINHST.GASFLG)=1) And ((jwe_LINHST.SUP)=jwe_INVMAS.SUP) And ((jwe_LINHST.PART)=jwe_INVMAS.PART)) And jwe_LINHST. INVDTE >=20071218 And jwe_LINHST. INVDTE <=20071219 ORDER BY ordno;
+SELECT
 </syntaxhighlight>
@@ Line 80: / Line 96: @@
 <syntaxhighlight lang="tsql">
-SELECT jwe_ORDHDR.OCUSNO, jwe_ORDHDR.OCUSNM, lpad(jwe_ORDHDR.OORDNO,0,8) & lpad(jwe_ORDHDR.OBAKNO,0,2) AS Expr1, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDLIN.LITMNO_ITEM, jwe_ORDLIN.LDESCR1, jwe_ORDLGAS.LSHIP, jwe_ORDLGAS.LRET, jwe_ORDHDR.OPONO FROM jwe_ORDHDR, jwe_ORDLGAS, jwe_ORDLIN WHERE (((jwe_ORDHDR.OORDNO)=[jwe_ORDLGAS].[LGAS_ORDNO] And (jwe_ORDHDR.OORDNO)=[jwe_ORDLIN].[LORDNO]) AND ((jwe_ORDHDR.OBAKNO)=[jwe_ORDLGAS].[LGAS_SEQNO] And (jwe_ORDHDR.OBAKNO)=[jwe_ORDLIN].[LSEQNO]) AND ((jwe_ORDLIN.LITMNO_SUP)='GAS') AND ((jwe_ORDLIN.LINENUMA)=[jwe_ORDLGAS].[LGAS_LINENUMA])) and jwe_ORDHDR.OFLAG=1;
+SELECT
 </syntaxhighlight>
 ===Query for Customer Balances===
 <syntaxhighlight lang="tsql">
-SELECT [jwe_CYO_BF].[CUSNO], [jwe_CYO_BF].[SUP]+[jwe_CYO_BF].[PART], [QTY], [jwe_CUSMAS].[LAST_NAME] FROM jwe_CYO_BF, jwe_CUSMAS WHERE [jwe_CYO_BF].[CUSNO]=[jwe_CUSMAS].[CUSNO];
+SELECT
 </syntaxhighlight>

@@ Line 67: / Line 67: @@
 <syntaxhighlight lang="tsql">
-SELECT jwe_LINPRM.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINPRM.ORDNO,0,8) &amp; lpad(jwe_LINPRM.BAKNO,0,2) AS Expr1, jwe_LINPRM.LINHST_DATE, jwe_LINPRM.LINPRM_DATE, jwe_LINPRM.SHIP_DATE, jwe_LINPRM.PART, Replace([jwe_INVMAS].[DESCR1]+[jwe_INVMAS].[DESCR2],',',' ') AS Expr2, jwe_LINPRM.CYLSHIP, jwe_LINPRM.CYLRET, jwe_LINPRM.PONO FROM jwe_LINPRM, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINPRM.CUSNO)=[jwe_CUSMAS].[CUSNO]) AND ((jwe_LINPRM.LINPRM_DATE)&gt;=20071001 And (jwe_LINPRM.LINPRM_DATE)&lt;=20071015) AND ((jwe_LINPRM.PART)=[jwe_INVMAS].[PART]) AND ((jwe_LINPRM.GASFLG)=1) AND ((jwe_LINPRM.SUP)=[jwe_INVMAS].[SUP]));
+SELECT jwe_LINPRM.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINPRM.ORDNO,0,8) & lpad(jwe_LINPRM.BAKNO,0,2) AS Expr1, jwe_LINPRM.LINHST_DATE, jwe_LINPRM.LINPRM_DATE, jwe_LINPRM.SHIP_DATE, jwe_LINPRM.PART, Replace([jwe_INVMAS].[DESCR1]+[jwe_INVMAS].[DESCR2],',',' ') AS Expr2, jwe_LINPRM.CYLSHIP, jwe_LINPRM.CYLRET, jwe_LINPRM.PONO FROM jwe_LINPRM, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINPRM.CUSNO)=[jwe_CUSMAS].[CUSNO]) AND ((jwe_LINPRM.LINPRM_DATE)>=20071001 And (jwe_LINPRM.LINPRM_DATE)<=20071015) AND ((jwe_LINPRM.PART)=[jwe_INVMAS].[PART]) AND ((jwe_LINPRM.GASFLG)=1) AND ((jwe_LINPRM.SUP)=[jwe_INVMAS].[SUP]));
 </syntaxhighlight>
@@ Line 73: / Line 73: @@
 <syntaxhighlight lang="tsql">
-SELECT jwe_LINHST.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINHST.ORDNO,0,8) &amp; lpad(jwe_LINHST.BAKNO,0,2) AS Ordno, jwe_LINHST.INVDTE, jwe_LINHST. INVDTE, jwe_LINHST. INVDTE, jwe_LINHST.PART AS Expr3, Replace(jwe_INVMAS.DESCR1+jwe_INVMAS.DESCR2,',',' ') AS Expr4, jwe_LINHST.CYLSHIP, jwe_LINHST.CYLRET, jwe_LINHST.PONO FROM jwe_LINHST, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINHST.CUSNO)=jwe_CUSMAS.CUSNO) And ((jwe_LINHST.GASFLG)=1) And ((jwe_LINHST.SUP)=jwe_INVMAS.SUP) And ((jwe_LINHST.PART)=jwe_INVMAS.PART)) And jwe_LINHST. INVDTE &gt;=20071218 And jwe_LINHST. INVDTE &lt;=20071219 ORDER BY ordno;
+SELECT jwe_LINHST.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINHST.ORDNO,0,8) & lpad(jwe_LINHST.BAKNO,0,2) AS Ordno, jwe_LINHST.INVDTE, jwe_LINHST. INVDTE, jwe_LINHST. INVDTE, jwe_LINHST.PART AS Expr3, Replace(jwe_INVMAS.DESCR1+jwe_INVMAS.DESCR2,',',' ') AS Expr4, jwe_LINHST.CYLSHIP, jwe_LINHST.CYLRET, jwe_LINHST.PONO FROM jwe_LINHST, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINHST.CUSNO)=jwe_CUSMAS.CUSNO) And ((jwe_LINHST.GASFLG)=1) And ((jwe_LINHST.SUP)=jwe_INVMAS.SUP) And ((jwe_LINHST.PART)=jwe_INVMAS.PART)) And jwe_LINHST. INVDTE >=20071218 And jwe_LINHST. INVDTE <=20071219 ORDER BY ordno;
 </syntaxhighlight>
@@ Line 80: / Line 80: @@
 <syntaxhighlight lang="tsql">
-SELECT jwe_ORDHDR.OCUSNO, jwe_ORDHDR.OCUSNM, lpad(jwe_ORDHDR.OORDNO,0,8) &amp; lpad(jwe_ORDHDR.OBAKNO,0,2) AS Expr1, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDLIN.LITMNO_ITEM, jwe_ORDLIN.LDESCR1, jwe_ORDLGAS.LSHIP, jwe_ORDLGAS.LRET, jwe_ORDHDR.OPONO FROM jwe_ORDHDR, jwe_ORDLGAS, jwe_ORDLIN WHERE (((jwe_ORDHDR.OORDNO)=[jwe_ORDLGAS].[LGAS_ORDNO] And (jwe_ORDHDR.OORDNO)=[jwe_ORDLIN].[LORDNO]) AND ((jwe_ORDHDR.OBAKNO)=[jwe_ORDLGAS].[LGAS_SEQNO] And (jwe_ORDHDR.OBAKNO)=[jwe_ORDLIN].[LSEQNO]) AND ((jwe_ORDLIN.LITMNO_SUP)='GAS') AND ((jwe_ORDLIN.LINENUMA)=[jwe_ORDLGAS].[LGAS_LINENUMA])) and jwe_ORDHDR.OFLAG=1;
+SELECT jwe_ORDHDR.OCUSNO, jwe_ORDHDR.OCUSNM, lpad(jwe_ORDHDR.OORDNO,0,8) & lpad(jwe_ORDHDR.OBAKNO,0,2) AS Expr1, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDLIN.LITMNO_ITEM, jwe_ORDLIN.LDESCR1, jwe_ORDLGAS.LSHIP, jwe_ORDLGAS.LRET, jwe_ORDHDR.OPONO FROM jwe_ORDHDR, jwe_ORDLGAS, jwe_ORDLIN WHERE (((jwe_ORDHDR.OORDNO)=[jwe_ORDLGAS].[LGAS_ORDNO] And (jwe_ORDHDR.OORDNO)=[jwe_ORDLIN].[LORDNO]) AND ((jwe_ORDHDR.OBAKNO)=[jwe_ORDLGAS].[LGAS_SEQNO] And (jwe_ORDHDR.OBAKNO)=[jwe_ORDLIN].[LSEQNO]) AND ((jwe_ORDLIN.LITMNO_SUP)='GAS') AND ((jwe_ORDLIN.LINENUMA)=[jwe_ORDLGAS].[LGAS_LINENUMA])) and jwe_ORDHDR.OFLAG=1;
 </syntaxhighlight>

@@ Line 42: / Line 42: @@
 'Declarations section of the module.
 '*********************************************************************
-Option Explicit Dim x As Integer Dim PadLength As Integer
+Option Explicit
 '=====================================================================

@@ Line 11: / Line 11: @@
 #Some facility for transferring the file to TrackAbout. Typically we've used Novell's free utility, NetDrive, which maps an FTP site to a network drive on the PC. You could certainly do the same with Windows XP/NT/2000/Vista's mapped network drive functionality. ftp login information for the particular client
-In Access, you'll need to create links to the following tables in CU's database: LINPRM—permanent archived invoices LINHST—"invoiced" invoices from the current calendar month ORDHDR—orderline header info CUSMAS—customer master INVMAS—inventory master CY_BF—cylinder balances ORDLGAS—gas orderline ORDLIN—orderline
+In Access, you'll need to create links to the following tables in CU's database:
 ==VB Module==

@@ Line 1: / Line 1: @@
-CU 3.0 runs on MS SQL server. Our customers interact with TIMS 3.0 by logging into a remote desktop connection, and running the TIMS front end directly from their server.
+CU 3.0 runs on Microsoft SQL Server. TrackAbout customers interact with TIMS 3.0 by logging into a Remote Desktop connection, and running the TIMS front end directly on their server.
 The local admin for the TIMS server should also have the administrator login for the TIMS server, and the SQL server login for the TIMS server.
-So far, at 2 clients, the sql server login has been: user: sa Password: cusqlxxx with ‘xxx’ being some three letter abbreviation for the client.
+So far, at 2 clients, the sql server login has been: user: sa Password: cusqlxxx with 'xxx' being some three letter abbreviation for the client.
-What you’ll need on the client PC:
+==What you'll need on the client PC==
-#some version of Microsoft Access or other SQL query tool to handle pulling the information from the TIMS database, and exporting the resulting text to TrackAbout.
+#Some version of Microsoft Access or other SQL query tool to handle pulling the information from the TIMS database, and exporting the resulting text to TrackAbout.
 #IP address of the TIMS SQL server Login information for the TIMS server, and SQL server.
 #Some facility for transferring the file to TrackAbout. Typically we've used Novell's free utility, NetDrive, which maps an FTP site to a network drive on the PC. You could certainly do the same with Windows XP/NT/2000/Vista's mapped network drive functionality. ftp login information for the particular client
-<br>
+In Access, you'll need to create links to the following tables in CU's database: LINPRM—permanent archived invoices LINHST—"invoiced" invoices from the current calendar month ORDHDR—orderline header info CUSMAS—customer master INVMAS—inventory master CY_BF—cylinder balances ORDLGAS—gas orderline ORDLIN—orderline
 'Declarations section of the module.
 '*********************************************************************
 Option Explicit Dim x As Integer Dim PadLength As Integer
 '=====================================================================
 'The following function will left pad a string with a specified 'character. It accepts a base string which is to be left padded with 'characters, a character to be used as the pad character, and a 'length which specifies the total length of the padded result.
 '=====================================================================
 Function lpad(MyValue$, MyPadCharacter$, MyPaddedLength%)
@@ Line 39: / Line 34: @@
 End Function
-<br> In all of the queries below, you’ll need to change the “JWE” to the three letter prefix for your client.
+==Queries==
-Historical invoice Query: for all invoices not in CURRENT CALENDAR MONTH
+===Historical invoice Query: for all invoices not in CURRENT CALENDAR MONTH ===
 SELECT jwe_LINPRM.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINPRM.ORDNO,0,8) &amp; lpad(jwe_LINPRM.BAKNO,0,2) AS Expr1, jwe_LINPRM.LINHST_DATE, jwe_LINPRM.LINPRM_DATE, jwe_LINPRM.SHIP_DATE, jwe_LINPRM.PART, Replace([jwe_INVMAS].[DESCR1]+[jwe_INVMAS].[DESCR2],',',' ') AS Expr2, jwe_LINPRM.CYLSHIP, jwe_LINPRM.CYLRET, jwe_LINPRM.PONO FROM jwe_LINPRM, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINPRM.CUSNO)=[jwe_CUSMAS].[CUSNO]) AND ((jwe_LINPRM.LINPRM_DATE)&gt;=20071001 And (jwe_LINPRM.LINPRM_DATE)&lt;=20071015) AND ((jwe_LINPRM.PART)=[jwe_INVMAS].[PART]) AND ((jwe_LINPRM.GASFLG)=1) AND ((jwe_LINPRM.SUP)=[jwe_INVMAS].[SUP]));
-<br>
+===Query for "invoiced" invoices in the current calendar month ===
 SELECT jwe_LINHST.CUSNO, jwe_CUSMAS.LAST_NAME, lpad(jwe_LINHST.ORDNO,0,8) &amp; lpad(jwe_LINHST.BAKNO,0,2) AS Ordno, jwe_LINHST.INVDTE, jwe_LINHST. INVDTE, jwe_LINHST. INVDTE, jwe_LINHST.PART AS Expr3, Replace(jwe_INVMAS.DESCR1+jwe_INVMAS.DESCR2,',',' ') AS Expr4, jwe_LINHST.CYLSHIP, jwe_LINHST.CYLRET, jwe_LINHST.PONO FROM jwe_LINHST, jwe_CUSMAS, jwe_INVMAS WHERE (((jwe_LINHST.CUSNO)=jwe_CUSMAS.CUSNO) And ((jwe_LINHST.GASFLG)=1) And ((jwe_LINHST.SUP)=jwe_INVMAS.SUP) And ((jwe_LINHST.PART)=jwe_INVMAS.PART)) And jwe_LINHST. INVDTE &gt;=20071218 And jwe_LINHST. INVDTE &lt;=20071219 ORDER BY ordno;
-<br>
+===Query for "Selected Invoices"===
+Includes closed invoices that will go to "invoiced" status overnight, but which can still be changed.
 SELECT jwe_ORDHDR.OCUSNO, jwe_ORDHDR.OCUSNM, lpad(jwe_ORDHDR.OORDNO,0,8) &amp; lpad(jwe_ORDHDR.OBAKNO,0,2) AS Expr1, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDHDR.OORDDT, jwe_ORDLIN.LITMNO_ITEM, jwe_ORDLIN.LDESCR1, jwe_ORDLGAS.LSHIP, jwe_ORDLGAS.LRET, jwe_ORDHDR.OPONO FROM jwe_ORDHDR, jwe_ORDLGAS, jwe_ORDLIN WHERE (((jwe_ORDHDR.OORDNO)=[jwe_ORDLGAS].[LGAS_ORDNO] And (jwe_ORDHDR.OORDNO)=[jwe_ORDLIN].[LORDNO]) AND ((jwe_ORDHDR.OBAKNO)=[jwe_ORDLGAS].[LGAS_SEQNO] And (jwe_ORDHDR.OBAKNO)=[jwe_ORDLIN].[LSEQNO]) AND ((jwe_ORDLIN.LITMNO_SUP)='GAS') AND ((jwe_ORDLIN.LINENUMA)=[jwe_ORDLGAS].[LGAS_LINENUMA])) and jwe_ORDHDR.OFLAG=1;
-<br> Query for Customer Balances:
+===Query for Customer Balances===
+<syntaxhighlight lang="tsql">
 SELECT [jwe_CYO_BF].[CUSNO], [jwe_CYO_BF].[SUP]+[jwe_CYO_BF].[PART], [QTY], [jwe_CUSMAS].[LAST_NAME] FROM jwe_CYO_BF, jwe_CUSMAS WHERE [jwe_CYO_BF].[CUSNO]=[jwe_CUSMAS].[CUSNO];
-<br>
+===Query for List of customers with customer numbers===
+<syntaxhighlight lang="tsql">
 SELECT [jwe_CUSMAS].[CUSNO], [jwe_CUSMAS].[LAST_NAME] FROM jwe_CUSMAS;