Who's On?

	Membership:
	Latest: DaptonConsultancyServices
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5206

	People Online:
	Visitors: 472
	Members: 0
	Total: 472

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

MS Tables

2 Replies

1 Subscribed to this topic

39 Subscribed to this forum

Sort:

Author

Messages

ALB

Veteran Member

Posts: 132

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

7/7/2016 12:44 PM

Does anyone have any information on the MS tables? I ran a verify. Two tables were missing. The table which exists is missing an index.

JonA

Veteran Member

Posts: 1163

7/7/2016 1:37 PM

I don't know much about them but an educated guess says they hold information related to MSCM. We have 3 tables: MSCITEMLOC, MSCITEMSRC, and MSCQOO. None of which have index fields.

ALB

Veteran Member

Posts: 132

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

7/7/2016 2:26 PM

I found out that we have 4 VIEWS (MSCCYCL, MSCITEMLOC, MSCITEMSRC, and MSCQOO). MSCITEMSRC is not in FILEDEF. It seems our issue with MSCITEMLOC is that there is an invalid operator. I did not think Lawson delivered any views.