Open Forum

Expand all | Collapse all

WINTYPE column in DYNAMICS..SY00800 table

  • 1.  WINTYPE column in DYNAMICS..SY00800 table

    GPUG ALL STAR
    Posted Oct 25, 2017 01:49 PM
    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)
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: WINTYPE column in DYNAMICS..SY00800 table

    TOP CONTRIBUTOR
    Posted Oct 26, 2017 11:42 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: WINTYPE column in DYNAMICS..SY00800 table

    GPUG ALL STAR
    Posted Oct 26, 2017 12:14 PM
    Thanks @Thaddeus Suter  (Don't know why I can't tag you!)

    I knew some of these but couldn't find a comprehensive listing (or close to it).

    Ha @Steve Erbach, be careful what you ask for:-)
    ​​​

    ------------------------------
    Frank Heslin
    Financial Systems Administrator
    ExamWorks, Inc.
    Atlanta GA

    Member, GPUG Advisory Committee
    Chairman, Georgia Regional GPUG Chapter
    Summit Track Leader
    GPUG All Star 2016

    GP2015 R2
    MR CU14

    Follow me on Twitter: @Automate_It

    GPUGGA - www.gpug.com/Atlanta


    *** Help Us, Help You...provide enough info so that we don't have to ask for more:) ***
    *** If you solve your issue please share the solution to assist others! ***
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: WINTYPE column in DYNAMICS..SY00800 table

    GPUG ALL STAR
    Posted Oct 26, 2017 12:30 PM
    @Frank Heslin,

    If you hover over Thaddeus' name you'll see that he's a "Hidden Member", whatever that is. I suppose that's what prevents the @ link from working.​​

    As far as asking, I don't mind it when the fire hose is turned on!

    Regards,

    ------------------------------
    "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)
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: WINTYPE column in DYNAMICS..SY00800 table

    GPUG ALL STAR
    Posted Oct 26, 2017 12:28 PM
    Thaddeus,

    Holy cow! (An expression we have here in the Dairy State!) That's a hell of a list! And just now I saw that -32767 value appear for a GL batch in my Dashboard. Sheesh!

    Thank you for the detailed response. I'm going to use the general descriptions for my Dashboard.

    Regards,

    ------------------------------
    "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)
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role