For the folks that have been around a while, GP used to do all the locks in the tempdb database dex_lock table.
With the release of GP10 around 2003 they added two new lock tables in the DYNAMICS database. SY00800 and SY00801.
This new design for locks was not implemented consistently however the design for the SY00800 was as follows:
WINTYPE
1: A Batch Lock on an Open Transaction record
100: A Transaction Lock on and Open Transaction record with or without a Batch Number
2: A batch Lock on and Open Batch ( not in a transaction window)
This should have covered it....
But then programmers went to work and added inconsistencies.
A few examples:
1. An IV Transaction Open window w Batch is coded to 1 and 1 when it should be 1 and 100.
2. The IV Transfer Trx window w Batch is coded 1 and 100 correct.
3. PA Timesheets in Open window with Batch are coded to 1 and dex_lock but should be 1 and 100
4. POP Returns Batch open coded to 2 correct
Here is a laundry list though for sure it is NOT COMPLETE and who knows to which WINTYPE third parties code their locks if they aren't still using dex_lock.
Read em and weep!
| WINTYPE |
Batch Lock SY00800 |
Trx Lock SY00800 |
| 1 |
GL w Trx |
|
| 1 |
IV-Transaction |
IV-Transaction |
| 1 |
PM w Trx |
|
| 1 |
POP Receipts w Trx |
|
| 1 |
POP Enter Match w Trx |
|
| 1 |
POP Returns w Trx |
|
| 1 |
PM Computer Checks |
|
| 1 |
SOP Sales w Trx |
|
| 1 |
Invoice Entry w Trx |
|
| 1 |
RM Entry w Trx |
|
| 1 |
PA Timesheet |
|
| 1 |
PA Expenses |
|
| 1 |
PA Billing |
|
| 100 |
|
PO Entry |
| 100 |
|
PM Trx |
| 100 |
|
RM Trx |
| 100 |
|
POP Returns |
| 100 |
|
POP Receipts |
| 100 |
|
POP Enter Match |
| 100 |
|
SVC Transactions |
| 100 |
|
RMA Transactions |
| 2 |
|
IV Transfer |
| 2 |
GL Entry - no Trx |
|
| 2 |
IV Transfer - no Trx |
|
| 2 |
IV Transaction - No Trx |
|
| 2 |
PM Entry - No Trx |
|
| 2 |
PM Computer Checks - no Trx |
|
| 2 |
POP Receipts - no Trx |
|
| 2 |
POP Enter Match - no Trx |
|
| 2 |
POP Returns - No Trx |
|
| 2 |
RM Entry - no Trx |
|
| 2 |
SOP Sales - no Trx |
|
| 2 |
Invoice Entry no Trx |
|
| 2 |
PA Timesheet no Trx |
|
| 2 |
PA Expenses no Trx |
|
| 2 |
PA Billing - no Trx |
|
| 3 |
|
Invoice Entry |
| 4 |
|
SOP Sales Trx Entry |
| 5 |
IV-Transfer |
|
| 13 |
|
IV Intransit Transfer |
| -32767 |
|
GL Entry |
| Table |
Other Locks |
Description |
| dex_Lock |
|
PA Timesheets |
| dex_Lock |
|
PA Billing |
| dex_Lock |
|
IV Transfer |
| dex_lock |
|
IV Transaction |
| dex_Lock |
|
SOP Sales Trx Entry |
| dex_Lock |
|
Invoice Entry |
| dex_Lock |
|
PM Trx |
| dex_Lock |
|
POP Entry |
| dex_Lock |
|
POP Trx |
| PA000001 |
|
PA Proj/Contr Cards |
------------------------------
Thaddeus Suter
Retus, Inc
TX
------------------------------
Original Message:
Sent: 10-25-2017 01:49 PM
From: Steve Erbach
Subject: WINTYPE column in DYNAMICS..SY00800 table
Dear Collaborators,
Yet another esoteric "Sparkly" Steve question...
On my GP Admin Excel Dashboard, there's a table that lists the open batches in the DYNAMICS..SY00800 table. Simple enough. However, the table contains a WINTYPE column. That column can contain several different values: 1, 2, 100 mainly.
What I'm looking for is a description of what those WINTYPEs are. I used Redgate SQL Search to look for the WINTYPE field... but all it found was the SY00800 table itself.
Is there a DYNAMICS lookup table that contains a description of each WINTYPE?
Sincerely,
------------------------------
"Sparkly" Steve Erbach - Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company - Appleton, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 (16.00.0439) / MR 2012 CU15
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach
------------------------------
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
------------------------------