InventoryTransferLog.Type

Discussion in 'Microsoft Point Of Sale' started by Julien Bonnier, Apr 30, 2007.

  1. Hello People!

    Where can I get list that explains the Transfers Type

    These are the values I have in my HQ DB 1,5,8

    But I need the complete list

    Thank You


    Julien
     
    Julien Bonnier, Apr 30, 2007
    #1
    1. Advertisements

  2. Julien Bonnier

    MOH. OWN Guest

    Hi Julien

    On Invenory Transferlog this which type you well find:
    1-for Inventory history (which item you issued /riceved/ po planner).
    3-Sales Item.
    4-transfear Item to Offline inventory.
    5-Manual adjustmint for qty (If happen on store).
    7-physical Inventory.
    8-HQ Adjustmint.

    I hoppe if this help you

    Best Regards

    --
    MOH.OWN
    THE BODY SHOP
    K.S.A
    MOB:+966 557266607




    "Julien Bonnier" <> wrote in message
    news:...
    > Hello People!
    >
    > Where can I get list that explains the Transfers Type
    >
    > These are the values I have in my HQ DB 1,5,8
    >
    > But I need the complete list
    >
    > Thank You
    >
    >
    > Julien
    >
     
    MOH. OWN, May 1, 2007
    #2
    1. Advertisements

  3. Yes thanks alot!

    Regards

    Julien


    "MOH. OWN" <> wrote in message
    news:...
    > Hi Julien
    >
    > On Invenory Transferlog this which type you well find:
    > 1-for Inventory history (which item you issued /riceved/ po planner).
    > 3-Sales Item.
    > 4-transfear Item to Offline inventory.
    > 5-Manual adjustmint for qty (If happen on store).
    > 7-physical Inventory.
    > 8-HQ Adjustmint.
    >
    > I hoppe if this help you
    >
    > Best Regards
    >
    > --
    > MOH.OWN
    > THE BODY SHOP
    > K.S.A
    > MOB:+966 557266607
    >
    >
    >
    >
    > "Julien Bonnier" <> wrote in message
    > news:...
    >> Hello People!
    >>
    >> Where can I get list that explains the Transfers Type
    >>
    >> These are the values I have in my HQ DB 1,5,8
    >>
    >> But I need the complete list
    >>
    >> Thank You
    >>
    >>
    >> Julien
    >>

    >
    >
     
    Julien Bonnier, May 1, 2007
    #3
  4. BTW where do you get this type of informations ?

    Because I like to know almost every fields of every tables
    Is-it documented on the microsoft website?

    Thanks

    Julien

    "MOH. OWN" <> wrote in message
    news:...
    > Hi Julien
    >
    > On Invenory Transferlog this which type you well find:
    > 1-for Inventory history (which item you issued /riceved/ po planner).
    > 3-Sales Item.
    > 4-transfear Item to Offline inventory.
    > 5-Manual adjustmint for qty (If happen on store).
    > 7-physical Inventory.
    > 8-HQ Adjustmint.
    >
    > I hoppe if this help you
    >
    > Best Regards
    >
    > --
    > MOH.OWN
    > THE BODY SHOP
    > K.S.A
    > MOB:+966 557266607
    >
    >
    >
    >
    > "Julien Bonnier" <> wrote in message
    > news:...
    >> Hello People!
    >>
    >> Where can I get list that explains the Transfers Type
    >>
    >> These are the values I have in my HQ DB 1,5,8
    >>
    >> But I need the complete list
    >>
    >> Thank You
    >>
    >>
    >> Julien
    >>

    >
    >
     
    Julien Bonnier, May 1, 2007
    #4
  5. Julien Bonnier

    MOH. OWN Guest

    HI Julien

    I don't have any docmunt. How i find?
    I open inventory transferlog table on sql and start check i select type 5
    and last day i do that after that on HQ manager from Item movemint i check
    what's that? you can do for all taple only check evry table what's the
    report for that or is link to other table. (like that).

    I hoppe if this help you.


    --
    MOH.OWN
    THE BODY SHOP
    K.S.A
    MOB:+966 557266607
     
    MOH. OWN, May 1, 2007
    #5
  6. Julien Bonnier

    Mark Guest

    I'm kind of curious, is the inventorytransferlog what is used to determine
    the inventory quantity for a store? For example does it recalc everytime a
    quantity is changed using the values from this table?

    "MOH. OWN" wrote:

    > HI Julien
    >
    > I don't have any docmunt. How i find?
    > I open inventory transferlog table on sql and start check i select type 5
    > and last day i do that after that on HQ manager from Item movemint i check
    > what's that? you can do for all taple only check evry table what's the
    > report for that or is link to other table. (like that).
    >
    > I hoppe if this help you.
    >
    >
    > --
    > MOH.OWN
    > THE BODY SHOP
    > K.S.A
    > MOB:+966 557266607
    >
    >
    >
     
    Mark, May 2, 2007
    #6
  7. No, it's a history of inventory movements. Any actions that change
    current inventory - sales, returns, receiving, tranfsers, manual
    adjustments, pbobably some more that I'm missing - all insert records
    into this table. This is the core table of the Inventory Movement
    reports. Given the current quantity on hand, you can use the
    inventoryTransferLog to calculate back to the quantity at a previous date.

    The only thing I know of that is unlogged is a direct update to quantity
    using SQL. There may be other things that are missed, I just don't know
    of any off hand.

    Glenn Adams
    Tiber Creek Consulting
    http://www.tibercreek.com

    ----------------------------------------------
    Please DO NOT respond to me directly but post all responses here in the
    newsgroup so that all can share the information.


    Mark wrote:
    > I'm kind of curious, is the inventorytransferlog what is used to determine
    > the inventory quantity for a store? For example does it recalc everytime a
    > quantity is changed using the values from this table?
    >
    > "MOH. OWN" wrote:
    >
    >> HI Julien
    >>
    >> I don't have any docmunt. How i find?
    >> I open inventory transferlog table on sql and start check i select type 5
    >> and last day i do that after that on HQ manager from Item movemint i check
    >> what's that? you can do for all taple only check evry table what's the
    >> report for that or is link to other table. (like that).
    >>
    >> I hoppe if this help you.
    >>
    >>
    >> --
    >> MOH.OWN
    >> THE BODY SHOP
    >> K.S.A
    >> MOB:+966 557266607
    >>
    >>
    >>
     
    Glenn Adams [MVP - Retail Mgmt], May 2, 2007
    #7
  8. Julien Bonnier

    Mark Guest

    Thank you Glenn, that is great insight to the system that I have always
    wanted to know.

    "Glenn Adams [MVP - Retail Mgmt]" wrote:

    > No, it's a history of inventory movements. Any actions that change
    > current inventory - sales, returns, receiving, tranfsers, manual
    > adjustments, pbobably some more that I'm missing - all insert records
    > into this table. This is the core table of the Inventory Movement
    > reports. Given the current quantity on hand, you can use the
    > inventoryTransferLog to calculate back to the quantity at a previous date.
    >
    > The only thing I know of that is unlogged is a direct update to quantity
    > using SQL. There may be other things that are missed, I just don't know
    > of any off hand.
    >
    > Glenn Adams
    > Tiber Creek Consulting
    > http://www.tibercreek.com
    >
    > ----------------------------------------------
    > Please DO NOT respond to me directly but post all responses here in the
    > newsgroup so that all can share the information.
    >
    >
    > Mark wrote:
    > > I'm kind of curious, is the inventorytransferlog what is used to determine
    > > the inventory quantity for a store? For example does it recalc everytime a
    > > quantity is changed using the values from this table?
    > >
    > > "MOH. OWN" wrote:
    > >
    > >> HI Julien
    > >>
    > >> I don't have any docmunt. How i find?
    > >> I open inventory transferlog table on sql and start check i select type 5
    > >> and last day i do that after that on HQ manager from Item movemint i check
    > >> what's that? you can do for all taple only check evry table what's the
    > >> report for that or is link to other table. (like that).
    > >>
    > >> I hoppe if this help you.
    > >>
    > >>
    > >> --
    > >> MOH.OWN
    > >> THE BODY SHOP
    > >> K.S.A
    > >> MOB:+966 557266607
    > >>
    > >>
    > >>

    >
     
    Mark, May 2, 2007
    #8
  9. I made a QRY that simulate a snapshot for a selected date using this table.
    I tested like 30 times and it's always good. If anybody need it, I can post
    it.


    "Mark" <> wrote in message
    news:...
    > I'm kind of curious, is the inventorytransferlog what is used to determine
    > the inventory quantity for a store? For example does it recalc everytime
    > a
    > quantity is changed using the values from this table?
    >
    > "MOH. OWN" wrote:
    >
    >> HI Julien
    >>
    >> I don't have any docmunt. How i find?
    >> I open inventory transferlog table on sql and start check i select type 5
    >> and last day i do that after that on HQ manager from Item movemint i
    >> check
    >> what's that? you can do for all taple only check evry table what's the
    >> report for that or is link to other table. (like that).
    >>
    >> I hoppe if this help you.
    >>
    >>
    >> --
    >> MOH.OWN
    >> THE BODY SHOP
    >> K.S.A
    >> MOB:+966 557266607
    >>
    >>
    >>
     
    Julien Bonnier, May 3, 2007
    #9
  10. Julien Bonnier

    Mark Guest

    Moh,

    I'm really curious what table(s) are used to programmatically calculate
    headquarters OH qty for an item when a change is made at the store. As an
    example if I do an adjustment to an item at the store. When Headquarters
    server runs what table(s) are used to recalc the oh quantity for the item?
    Maybe the question should be where in headquarters would i set the record
    that tells Headquarters to recalc oh qty using this adjusted amount?

    Mark

    "MOH. OWN" wrote:

    > Hi Julien
    >
    > On Invenory Transferlog this which type you well find:
    > 1-for Inventory history (which item you issued /riceved/ po planner).
    > 3-Sales Item.
    > 4-transfear Item to Offline inventory.
    > 5-Manual adjustmint for qty (If happen on store).
    > 7-physical Inventory.
    > 8-HQ Adjustmint.
    >
    > I hoppe if this help you
    >
    > Best Regards
    >
    > --
    > MOH.OWN
    > THE BODY SHOP
    > K.S.A
    > MOB:+966 557266607
    >
    >
    >
    >
    > "Julien Bonnier" <> wrote in message
    > news:...
    > > Hello People!
    > >
    > > Where can I get list that explains the Transfers Type
    > >
    > > These are the values I have in my HQ DB 1,5,8
    > >
    > > But I need the complete list
    > >
    > > Thank You
    > >
    > >
    > > Julien
    > >

    >
    >
    >
     
    Mark, May 9, 2007
    #10
  11. Julien Bonnier

    Lam Hoang Guest

    Re: I made a QRY that simulate a snapshot for a selected date usingthis table.

    Hi,

    I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?

    I'm looking forward to hear from you soon.

    Thanks and regards,
    Lam Hoang



    > On Monday, April 30, 2007 3:51 PM Julien Bonnier wrote:


    > Hello People!
    >
    > Where can I get list that explains the Transfers Type
    >
    > These are the values I have in my HQ DB 1,5,8
    >
    > But I need the complete list
    >
    > Thank You
    >
    >
    > Julien



    >> On Tuesday, May 01, 2007 3:13 AM MOH. OWN wrote:


    >> Hi Julien
    >>
    >> On Invenory Transferlog this which type you well find:
    >> 1-for Inventory history (which item you issued /riceved/ po planner).
    >> 3-Sales Item.
    >> 4-transfear Item to Offline inventory.
    >> 5-Manual adjustmint for qty (If happen on store).
    >> 7-physical Inventory.
    >> 8-HQ Adjustmint.
    >>
    >> I hoppe if this help you
    >>
    >> Best Regards
    >>
    >> --
    >> MOH.OWN
    >> THE BODY SHOP
    >> K.S.A
    >> MOB:+966 557266607
    >>
    >>
    >>
    >>
    >> "Julien Bonnier" <> wrote in message
    >> news:...



    >>> On Tuesday, May 01, 2007 11:34 AM Julien Bonnier wrote:


    >>> Yes thanks alot!
    >>>
    >>> Regards
    >>>
    >>> Julien



    >>>> On Tuesday, May 01, 2007 11:49 AM Julien Bonnier wrote:


    >>>> BTW where do you get this type of informations ?
    >>>>
    >>>> Because I like to know almost every fields of every tables
    >>>> Is-it documented on the microsoft website?
    >>>>
    >>>> Thanks
    >>>>
    >>>> Julien



    >>>>> On Tuesday, May 01, 2007 12:48 PM MOH. OWN wrote:


    >>>>> HI Julien
    >>>>>
    >>>>> I don't have any docmunt. How i find?
    >>>>> I open inventory transferlog table on sql and start check i select type 5
    >>>>> and last day i do that after that on HQ manager from Item movemint i check
    >>>>> what's that? you can do for all taple only check evry table what's the
    >>>>> report for that or is link to other table. (like that).
    >>>>>
    >>>>> I hoppe if this help you.
    >>>>>
    >>>>>
    >>>>> --
    >>>>> MOH.OWN
    >>>>> THE BODY SHOP
    >>>>> K.S.A
    >>>>> MOB:+966 557266607



    >>>>>> On Wednesday, May 02, 2007 3:58 PM Mar wrote:


    >>>>>> I'm kind of curious, is the inventorytransferlog what is used to determine
    >>>>>> the inventory quantity for a store? For example does it recalc everytime a
    >>>>>> quantity is changed using the values from this table?
    >>>>>>
    >>>>>> "MOH. OWN" wrote:



    >>>>>>> On Wednesday, May 02, 2007 4:26 PM Glenn Adams [MVP - Retail Mgmt] wrote:


    >>>>>>> No, it's a history of inventory movements. Any actions that change
    >>>>>>> current inventory - sales, returns, receiving, tranfsers, manual
    >>>>>>> adjustments, pbobably some more that I'm missing - all insert records
    >>>>>>> into this table. This is the core table of the Inventory Movement
    >>>>>>> reports. Given the current quantity on hand, you can use the
    >>>>>>> inventoryTransferLog to calculate back to the quantity at a previous date.
    >>>>>>>
    >>>>>>> The only thing I know of that is unlogged is a direct update to quantity
    >>>>>>> using SQL. There may be other things that are missed, I just don't know
    >>>>>>> of any off hand.
    >>>>>>>
    >>>>>>> Glenn Adams
    >>>>>>> Tiber Creek Consulting
    >>>>>>> http://www.tibercreek.com
    >>>>>>>
    >>>>>>> ----------------------------------------------
    >>>>>>> Please DO NOT respond to me directly but post all responses here in the
    >>>>>>> newsgroup so that all can share the information.
    >>>>>>>
    >>>>>>>
    >>>>>>> Mark wrote:



    >>>>>>>> On Wednesday, May 02, 2007 4:33 PM Mar wrote:


    >>>>>>>> Thank you Glenn, that is great insight to the system that I have always
    >>>>>>>> wanted to know.
    >>>>>>>>
    >>>>>>>> "Glenn Adams [MVP - Retail Mgmt]" wrote:



    >>>>>>>>> On Thursday, May 03, 2007 12:58 PM Julien Bonnier wrote:


    >>>>>>>>> I made a QRY that simulate a snapshot for a selected date using this table.
    >>>>>>>>> I tested like 30 times and it is always good. If anybody need it, I can post
    >>>>>>>>> it.



    >>>>>>>>>> On Friday, May 04, 2007 7:24 AM Ahmed Nashat wrote:


    >>>>>>>>>> This is a multi-part message in MIME format.
    >>>>>>>>>>
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0
    >>>>>>>>>> Content-Type: text/plain;
    >>>>>>>>>> charset="windows-1256"
    >>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>
    >>>>>>>>>> Julien,
    >>>>>>>>>>
    >>>>>>>>>> You can usually find this kind of information in RMS reports, for =
    >>>>>>>>>> example, you can find the movement types in "Items - Item Movement =
    >>>>>>>>>> Report.qrp", you will find the following string in the formula line of =
    >>>>>>>>>> "Type" column,=20
    >>>>>>>>>>
    >>>>>>>>>> "CASE Type WHEN 1 THEN 'PO/Inventory Transfer' WHEN 2 THEN 'Return to =
    >>>>>>>>>> Off-Line' WHEN 3 THEN 'Transfer Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 =
    >>>>>>>>>> THEN 'Manual Adjustment' WHEN 6 THEN 'Inventory Wizard' WHEN 7 THEN =
    >>>>>>>>>> 'Physical Inventory Adjustment' WHEN 8 THEN 'HQ Adjustment' WHEN 9 THEN =
    >>>>>>>>>> 'Parent Child Adjustment' WHEN 10 THEN 'Kit Component Transfer' WHEN 99 =
    >>>>>>>>>> THEN 'Sales/Return' ELSE 'Unknown' END"
    >>>>>>>>>>
    >>>>>>>>>> This is true too for other unknow values like the PriceSource in =
    >>>>>>>>>> TransactionEntry, you might know its details in "Sales - Detailed Sales =
    >>>>>>>>>> Report.qrp":-
    >>>>>>>>>>
    >>>>>>>>>> "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 =
    >>>>>>>>>> THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 THEN =
    >>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>> Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>> Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' =
    >>>>>>>>>> WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component' WHEN 12 THEN 'Price =
    >>>>>>>>>> Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price =
    >>>>>>>>>> Level C Disc.' WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>> from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"
    >>>>>>>>>>
    >>>>>>>>>> Nashat
    >>>>>>>>>>
    >>>>>>>>>> "Julien Bonnier" <> wrote in message =
    >>>>>>>>>> news:...
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0
    >>>>>>>>>> Content-Type: text/html;
    >>>>>>>>>> charset="windows-1256"
    >>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>
    >>>>>>>>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    >>>>>>>>>> <HTML><HEAD>
    >>>>>>>>>> <META http-equiv=3DContent-Type content=3D"text/html; =
    >>>>>>>>>> charset=3Dwindows-1256">
    >>>>>>>>>> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
    >>>>>>>>>> <STYLE></STYLE>
    >>>>>>>>>> </HEAD>
    >>>>>>>>>> <BODY>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2>Julien,</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>You can =
    >>>>>>>>>> usually find this=20
    >>>>>>>>>> kind of information in RMS reports, for example, you can find the =
    >>>>>>>>>> movement types=20
    >>>>>>>>>> in "Items - Item Movement Report.qrp", you will find the following =
    >>>>>>>>>> string in the=20
    >>>>>>>>>> formula line of "Type" column, </FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE Type =
    >>>>>>>>>> WHEN 1 THEN=20
    >>>>>>>>>> 'PO/Inventory Transfer' WHEN 2 THEN 'Return to Off-Line' WHEN 3 THEN =
    >>>>>>>>>> 'Transfer=20
    >>>>>>>>>> Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 THEN 'Manual Adjustment' WHEN 6 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Inventory Wizard' WHEN 7 THEN 'Physical Inventory Adjustment' WHEN 8 =
    >>>>>>>>>> THEN 'HQ=20
    >>>>>>>>>> Adjustment' WHEN 9 THEN 'Parent Child Adjustment' WHEN 10 THEN 'Kit =
    >>>>>>>>>> Component=20
    >>>>>>>>>> Transfer' WHEN 99 THEN 'Sales/Return' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>This is true =
    >>>>>>>>>> too for other=20
    >>>>>>>>>> unknow values like the PriceSource in TransactionEntry, you might know =
    >>>>>>>>>> its=20
    >>>>>>>>>> details in "Sales - Detailed Sales Report.qrp":-</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE=20
    >>>>>>>>>> TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 THEN =
    >>>>>>>>>> (CASE WHEN=20
    >>>>>>>>>> TransactionEntry.QuantityDiscountID &lt;&gt; 0 THEN =
    >>>>>>>>>> QuantityDiscount.Description=20
    >>>>>>>>>> ELSE 'Quantity Discount' END) WHEN 3 THEN 'Buydown Discount' WHEN 4 THEN =
    >>>>>>>>>> 'Price=20
    >>>>>>>>>> Level Disc.' WHEN 5 THEN 'Sale Price' WHEN 6 THEN 'Disc. from Reg. =
    >>>>>>>>>> Price' WHEN 7=20
    >>>>>>>>>> THEN 'Disc. from Cur. Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN =
    >>>>>>>>>> 'Profit=20
    >>>>>>>>>> Margin Disc.' WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component'&nbsp; =
    >>>>>>>>>> WHEN 12=20
    >>>>>>>>>> THEN 'Price Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Price Level C Disc.'&nbsp; WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Disc. from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN =
    >>>>>>>>>> 'Profit=20
    >>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2>Nashat</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3DArial size=3D2>"Julien Bonnier" &lt;</FONT><A=20
    >>>>>>>>>> href=3D"mailto:"><FONT face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in message=20
    >>>>>>>>>> </FONT><A href=3D"news:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; BTW where do =
    >>>>>>>>>> you get this=20
    >>>>>>>>>> type of informations ?<BR>&gt; <BR>&gt; Because I like to know almost =
    >>>>>>>>>> every=20
    >>>>>>>>>> fields of every tables<BR>&gt; Is-it documented on the microsoft=20
    >>>>>>>>>> website?<BR>&gt; <BR>&gt; Thanks<BR>&gt; <BR>&gt; Julien<BR>&gt; =
    >>>>>>>>>> <BR>&gt; "MOH.=20
    >>>>>>>>>> OWN" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in=20
    >>>>>>>>>> message <BR>&gt; </FONT><A=20
    >>>>>>>>>> href=3D"news:"><FONT face=3DArial=20
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>...<BR>&gt;&gt; Hi Julien<BR>&gt;&gt;<BR>&gt;&gt; On Invenory =
    >>>>>>>>>> Transferlog=20
    >>>>>>>>>> this which type you well find:<BR>&gt;&gt; 1-for Inventory history =
    >>>>>>>>>> (which item=20
    >>>>>>>>>> you issued /riceved/ po planner).<BR>&gt;&gt; 3-Sales Item.<BR>&gt;&gt;=20
    >>>>>>>>>> 4-transfear Item to Offline inventory.<BR>&gt;&gt; 5-Manual adjustmint =
    >>>>>>>>>> for qty=20
    >>>>>>>>>> (If happen on store).<BR>&gt;&gt; 7-physical Inventory.<BR>&gt;&gt; 8-HQ =
    >>>>>>>>>>
    >>>>>>>>>> Adjustmint.<BR>&gt;&gt;<BR>&gt;&gt; I hoppe if this help=20
    >>>>>>>>>> you<BR>&gt;&gt;<BR>&gt;&gt; Best Regards<BR>&gt;&gt;<BR>&gt;&gt; -- =
    >>>>>>>>>> <BR>&gt;&gt;=20
    >>>>>>>>>> MOH.OWN<BR>&gt;&gt; THE BODY SHOP<BR>&gt;&gt; K.S.A<BR>&gt;&gt; MOB:+966 =
    >>>>>>>>>>
    >>>>>>>>>> 557266607<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; =
    >>>>>>>>>> "Julien=20
    >>>>>>>>>> Bonnier" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in message=20
    >>>>>>>>>> <BR>&gt;&gt; </FONT><A =
    >>>>>>>>>> href=3D"news:"><FONT=20
    >>>>>>>>>> face=3DArial =
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT=20
    >>>>>>>>>> face=3DArial size=3D2>...<BR>&gt;&gt;&gt; Hello=20
    >>>>>>>>>> People!<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Where can I get list that =
    >>>>>>>>>> explains the=20
    >>>>>>>>>> Transfers Type<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; These are the values I =
    >>>>>>>>>> have in my=20
    >>>>>>>>>> HQ DB 1,5,8<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; But I need the complete=20
    >>>>>>>>>> list<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thank=20
    >>>>>>>>>> You<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;=20
    >>>>>>>>>> Julien<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; <BR>&gt;=20
    >>>>>>>>>> <BR>&gt;</FONT></BODY></HTML>
    >>>>>>>>>>
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0--



    >>>>>>>>>>> On Monday, May 07, 2007 9:21 AM Julien Bonnier wrote:


    >>>>>>>>>>> This is a multi-part message in MIME format.
    >>>>>>>>>>>
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0
    >>>>>>>>>>> Content-Type: text/plain;
    >>>>>>>>>>> charset="windows-1256"
    >>>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>>
    >>>>>>>>>>> Oh man!=20
    >>>>>>>>>>>
    >>>>>>>>>>> Thanks alot Nashat!!!
    >>>>>>>>>>>
    >>>>>>>>>>> You're the BOMB!!
    >>>>>>>>>>>
    >>>>>>>>>>>
    >>>>>>>>>>> "Ahmed Nashat" <> wrote in message =
    >>>>>>>>>>> news:%...
    >>>>>>>>>>> Julien,
    >>>>>>>>>>>
    >>>>>>>>>>> You can usually find this kind of information in RMS reports, for =
    >>>>>>>>>>> example, you can find the movement types in "Items - Item Movement =
    >>>>>>>>>>> Report.qrp", you will find the following string in the formula line of =
    >>>>>>>>>>> "Type" column,=20
    >>>>>>>>>>>
    >>>>>>>>>>> "CASE Type WHEN 1 THEN 'PO/Inventory Transfer' WHEN 2 THEN 'Return to =
    >>>>>>>>>>> Off-Line' WHEN 3 THEN 'Transfer Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 =
    >>>>>>>>>>> THEN 'Manual Adjustment' WHEN 6 THEN 'Inventory Wizard' WHEN 7 THEN =
    >>>>>>>>>>> 'Physical Inventory Adjustment' WHEN 8 THEN 'HQ Adjustment' WHEN 9 THEN =
    >>>>>>>>>>> 'Parent Child Adjustment' WHEN 10 THEN 'Kit Component Transfer' WHEN 99 =
    >>>>>>>>>>> THEN 'Sales/Return' ELSE 'Unknown' END"
    >>>>>>>>>>>
    >>>>>>>>>>> This is true too for other unknow values like the PriceSource in =
    >>>>>>>>>>> TransactionEntry, you might know its details in "Sales - Detailed Sales =
    >>>>>>>>>>> Report.qrp":-
    >>>>>>>>>>>
    >>>>>>>>>>> "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 =
    >>>>>>>>>>> THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 THEN =
    >>>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>>> Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>>> Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' =
    >>>>>>>>>>> WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component' WHEN 12 THEN 'Price =
    >>>>>>>>>>> Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price =
    >>>>>>>>>>> Level C Disc.' WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>>> from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"
    >>>>>>>>>>>
    >>>>>>>>>>> Nashat
    >>>>>>>>>>>
    >>>>>>>>>>> "Julien Bonnier" <> wrote in message =
    >>>>>>>>>>> news:...
    >>>>>>>>>>> > BTW where do you get this type of informations ?
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Because I like to know almost every fields of every tables
    >>>>>>>>>>> > Is-it documented on the microsoft website?
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Thanks
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Julien
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > "MOH. OWN" <> wrote in message=20
    >>>>>>>>>>> > news:...
    >>>>>>>>>>> >> Hi Julien
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> On Invenory Transferlog this which type you well find:
    >>>>>>>>>>> >> 1-for Inventory history (which item you issued /riceved/ po =
    >>>>>>>>>>> planner).
    >>>>>>>>>>> >> 3-Sales Item.
    >>>>>>>>>>> >> 4-transfear Item to Offline inventory.
    >>>>>>>>>>> >> 5-Manual adjustmint for qty (If happen on store).
    >>>>>>>>>>> >> 7-physical Inventory.
    >>>>>>>>>>> >> 8-HQ Adjustmint.
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> I hoppe if this help you
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> Best Regards
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> --=20
    >>>>>>>>>>> >> MOH.OWN
    >>>>>>>>>>> >> THE BODY SHOP
    >>>>>>>>>>> >> K.S.A
    >>>>>>>>>>> >> MOB:+966 557266607
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> "Julien Bonnier" <> wrote in message=20
    >>>>>>>>>>> >> news:...
    >>>>>>>>>>> >>> Hello People!
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Where can I get list that explains the Transfers Type
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> These are the values I have in my HQ DB 1,5,8
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> But I need the complete list
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Thank You
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Julien
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>=20
    >>>>>>>>>>> >=20
    >>>>>>>>>>> >
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0
    >>>>>>>>>>> Content-Type: text/html;
    >>>>>>>>>>> charset="windows-1256"
    >>>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>>
    >>>>>>>>>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    >>>>>>>>>>> <HTML><HEAD>
    >>>>>>>>>>> <META http-equiv=3DContent-Type content=3D"text/html; =
    >>>>>>>>>>> charset=3Dwindows-1256">
    >>>>>>>>>>> <META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
    >>>>>>>>>>> <STYLE></STYLE>
    >>>>>>>>>>> </HEAD>
    >>>>>>>>>>> <BODY bgColor=3D#ffffff>
    >>>>>>>>>>> <DIV><FONT size=3D2>Oh man! </FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2>Thanks alot Nashat!!!</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2>You're the BOMB!!</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <BLOCKQUOTE=20
    >>>>>>>>>>> style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
    >>>>>>>>>>> BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    >>>>>>>>>>> <DIV>"Ahmed Nashat" &lt;<A=20
    >>>>>>>>>>> href=3D"mailto:"></A>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message <A=20
    >>>>>>>>>>> =
    >>>>>>>>>>> href=3D"news:%">news:%23Tlk66jjHHA.=
    >>>>>>>>>>> </A>...</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2>Julien,</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>You can =
    >>>>>>>>>>> usually find=20
    >>>>>>>>>>> this kind of information in RMS reports, for example, you can find the =
    >>>>>>>>>>>
    >>>>>>>>>>> movement types in "Items - Item Movement Report.qrp", you will find =
    >>>>>>>>>>> the=20
    >>>>>>>>>>> following string in the formula line of "Type" column, </FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE Type =
    >>>>>>>>>>> WHEN 1 THEN=20
    >>>>>>>>>>> 'PO/Inventory Transfer' WHEN 2 THEN 'Return to Off-Line' WHEN 3 THEN =
    >>>>>>>>>>> 'Transfer=20
    >>>>>>>>>>> Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 THEN 'Manual Adjustment' WHEN =
    >>>>>>>>>>> 6 THEN=20
    >>>>>>>>>>> 'Inventory Wizard' WHEN 7 THEN 'Physical Inventory Adjustment' WHEN 8 =
    >>>>>>>>>>> THEN 'HQ=20
    >>>>>>>>>>> Adjustment' WHEN 9 THEN 'Parent Child Adjustment' WHEN 10 THEN 'Kit =
    >>>>>>>>>>> Component=20
    >>>>>>>>>>> Transfer' WHEN 99 THEN 'Sales/Return' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>This is =
    >>>>>>>>>>> true too for=20
    >>>>>>>>>>> other unknow values like the PriceSource in TransactionEntry, you =
    >>>>>>>>>>> might know=20
    >>>>>>>>>>> its details in "Sales - Detailed Sales Report.qrp":-</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE=20
    >>>>>>>>>>> TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 THEN =
    >>>>>>>>>>> (CASE=20
    >>>>>>>>>>> WHEN TransactionEntry.QuantityDiscountID &lt;&gt; 0 THEN=20
    >>>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>>>
    >>>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>>> Price'=20
    >>>>>>>>>>> WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>>> Price' WHEN 8=20
    >>>>>>>>>>> THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' WHEN 10 =
    >>>>>>>>>>> THEN=20
    >>>>>>>>>>> 'Cashier Set' WHEN 11 THEN 'Component'&nbsp; WHEN 12 THEN 'Price Level =
    >>>>>>>>>>> A=20
    >>>>>>>>>>> Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price Level C=20
    >>>>>>>>>>> Disc.'&nbsp; WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>>> from=20
    >>>>>>>>>>> Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>>> Margin=20
    >>>>>>>>>>> Disc.' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2>Nashat</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3DArial size=3D2>"Julien Bonnier" &lt;</FONT><A=20
    >>>>>>>>>>> href=3D"mailto:"><FONT face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message </FONT><A =
    >>>>>>>>>>> href=3D"news:"><FONT=20
    >>>>>>>>>>> face=3DArial =
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT=20
    >>>>>>>>>>> face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> BTW where do=20
    >>>>>>>>>>> you get this type of informations ?<BR>&gt; <BR>&gt; Because I like to =
    >>>>>>>>>>> know=20
    >>>>>>>>>>> almost every fields of every tables<BR>&gt; Is-it documented on the =
    >>>>>>>>>>> microsoft=20
    >>>>>>>>>>> website?<BR>&gt; <BR>&gt; Thanks<BR>&gt; <BR>&gt; Julien<BR>&gt; =
    >>>>>>>>>>> <BR>&gt;=20
    >>>>>>>>>>> "MOH. OWN" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial =
    >>>>>>>>>>> size=3D2>&gt; wrote in=20
    >>>>>>>>>>> message <BR>&gt; </FONT><A=20
    >>>>>>>>>>> href=3D"news:"><FONT face=3DArial =
    >>>>>>>>>>>
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2>...<BR>&gt;&gt; Hi Julien<BR>&gt;&gt;<BR>&gt;&gt; On Invenory =
    >>>>>>>>>>>
    >>>>>>>>>>> Transferlog this which type you well find:<BR>&gt;&gt; 1-for Inventory =
    >>>>>>>>>>> history=20
    >>>>>>>>>>> (which item you issued /riceved/ po planner).<BR>&gt;&gt; 3-Sales=20
    >>>>>>>>>>> Item.<BR>&gt;&gt; 4-transfear Item to Offline inventory.<BR>&gt;&gt; =
    >>>>>>>>>>> 5-Manual=20
    >>>>>>>>>>> adjustmint for qty (If happen on store).<BR>&gt;&gt; 7-physical=20
    >>>>>>>>>>> Inventory.<BR>&gt;&gt; 8-HQ Adjustmint.<BR>&gt;&gt;<BR>&gt;&gt; I =
    >>>>>>>>>>> hoppe if=20
    >>>>>>>>>>> this help you<BR>&gt;&gt;<BR>&gt;&gt; Best =
    >>>>>>>>>>> Regards<BR>&gt;&gt;<BR>&gt;&gt; --=20
    >>>>>>>>>>> <BR>&gt;&gt; MOH.OWN<BR>&gt;&gt; THE BODY SHOP<BR>&gt;&gt; =
    >>>>>>>>>>> K.S.A<BR>&gt;&gt;=20
    >>>>>>>>>>> MOB:+966 =
    >>>>>>>>>>> 557266607<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;=20
    >>>>>>>>>>> "Julien Bonnier" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message <BR>&gt;&gt; </FONT><A=20
    >>>>>>>>>>> href=3D"news:"><FONT face=3DArial =
    >>>>>>>>>>>
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2>...<BR>&gt;&gt;&gt; Hello =
    >>>>>>>>>>> People!<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Where=20
    >>>>>>>>>>> can I get list that explains the Transfers=20
    >>>>>>>>>>> Type<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; These are the values I have in my =
    >>>>>>>>>>> HQ DB=20
    >>>>>>>>>>> 1,5,8<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; But I need the complete=20
    >>>>>>>>>>> list<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thank=20
    >>>>>>>>>>> You<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;=20
    >>>>>>>>>>> Julien<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; <BR>&gt; =
    >>>>>>>>>>> <BR>&gt;</FONT>=20
    >>>>>>>>>>> </BLOCKQUOTE></BODY></HTML>
    >>>>>>>>>>>
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0--



    >>>>>>>>>>>> On Wednesday, May 09, 2007 3:33 PM Mar wrote:


    >>>>>>>>>>>> Moh,
    >>>>>>>>>>>>
    >>>>>>>>>>>> I'm really curious what table(s) are used to programmatically calculate
    >>>>>>>>>>>> headquarters OH qty for an item when a change is made at the store. As an
    >>>>>>>>>>>> example if I do an adjustment to an item at the store. When Headquarters
    >>>>>>>>>>>> server runs what table(s) are used to recalc the oh quantity for the item?
    >>>>>>>>>>>> Maybe the question should be where in headquarters would i set the record
    >>>>>>>>>>>> that tells Headquarters to recalc oh qty using this adjusted amount?
    >>>>>>>>>>>>
    >>>>>>>>>>>> Mark
    >>>>>>>>>>>>
    >>>>>>>>>>>> "MOH. OWN" wrote:
     
    Lam Hoang, May 5, 2011
    #11
  12. Julien Bonnier

    Lam Hoang Guest

    Re: I made a QRY that simulate a snapshot for a selected date usingthis table.

    Hi,

    I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?

    I'm looking forward to hear from you soon.

    Thanks and regards,
    Lam Hoang



    > On Monday, April 30, 2007 3:51 PM Julien Bonnier wrote:


    > Hello People!
    >
    > Where can I get list that explains the Transfers Type
    >
    > These are the values I have in my HQ DB 1,5,8
    >
    > But I need the complete list
    >
    > Thank You
    >
    >
    > Julien



    >> On Tuesday, May 01, 2007 3:13 AM MOH. OWN wrote:


    >> Hi Julien
    >>
    >> On Invenory Transferlog this which type you well find:
    >> 1-for Inventory history (which item you issued /riceved/ po planner).
    >> 3-Sales Item.
    >> 4-transfear Item to Offline inventory.
    >> 5-Manual adjustmint for qty (If happen on store).
    >> 7-physical Inventory.
    >> 8-HQ Adjustmint.
    >>
    >> I hoppe if this help you
    >>
    >> Best Regards
    >>
    >> --
    >> MOH.OWN
    >> THE BODY SHOP
    >> K.S.A
    >> MOB:+966 557266607
    >>
    >>
    >>
    >>
    >> "Julien Bonnier" <> wrote in message
    >> news:...



    >>> On Tuesday, May 01, 2007 11:34 AM Julien Bonnier wrote:


    >>> Yes thanks alot!
    >>>
    >>> Regards
    >>>
    >>> Julien



    >>>> On Tuesday, May 01, 2007 11:49 AM Julien Bonnier wrote:


    >>>> BTW where do you get this type of informations ?
    >>>>
    >>>> Because I like to know almost every fields of every tables
    >>>> Is-it documented on the microsoft website?
    >>>>
    >>>> Thanks
    >>>>
    >>>> Julien



    >>>>> On Tuesday, May 01, 2007 12:48 PM MOH. OWN wrote:


    >>>>> HI Julien
    >>>>>
    >>>>> I don't have any docmunt. How i find?
    >>>>> I open inventory transferlog table on sql and start check i select type 5
    >>>>> and last day i do that after that on HQ manager from Item movemint i check
    >>>>> what's that? you can do for all taple only check evry table what's the
    >>>>> report for that or is link to other table. (like that).
    >>>>>
    >>>>> I hoppe if this help you.
    >>>>>
    >>>>>
    >>>>> --
    >>>>> MOH.OWN
    >>>>> THE BODY SHOP
    >>>>> K.S.A
    >>>>> MOB:+966 557266607



    >>>>>> On Wednesday, May 02, 2007 3:58 PM Mar wrote:


    >>>>>> I'm kind of curious, is the inventorytransferlog what is used to determine
    >>>>>> the inventory quantity for a store? For example does it recalc everytime a
    >>>>>> quantity is changed using the values from this table?
    >>>>>>
    >>>>>> "MOH. OWN" wrote:



    >>>>>>> On Wednesday, May 02, 2007 4:26 PM Glenn Adams [MVP - Retail Mgmt] wrote:


    >>>>>>> No, it's a history of inventory movements. Any actions that change
    >>>>>>> current inventory - sales, returns, receiving, tranfsers, manual
    >>>>>>> adjustments, pbobably some more that I'm missing - all insert records
    >>>>>>> into this table. This is the core table of the Inventory Movement
    >>>>>>> reports. Given the current quantity on hand, you can use the
    >>>>>>> inventoryTransferLog to calculate back to the quantity at a previous date.
    >>>>>>>
    >>>>>>> The only thing I know of that is unlogged is a direct update to quantity
    >>>>>>> using SQL. There may be other things that are missed, I just don't know
    >>>>>>> of any off hand.
    >>>>>>>
    >>>>>>> Glenn Adams
    >>>>>>> Tiber Creek Consulting
    >>>>>>> http://www.tibercreek.com
    >>>>>>>
    >>>>>>> ----------------------------------------------
    >>>>>>> Please DO NOT respond to me directly but post all responses here in the
    >>>>>>> newsgroup so that all can share the information.
    >>>>>>>
    >>>>>>>
    >>>>>>> Mark wrote:



    >>>>>>>> On Wednesday, May 02, 2007 4:33 PM Mar wrote:


    >>>>>>>> Thank you Glenn, that is great insight to the system that I have always
    >>>>>>>> wanted to know.
    >>>>>>>>
    >>>>>>>> "Glenn Adams [MVP - Retail Mgmt]" wrote:



    >>>>>>>>> On Thursday, May 03, 2007 12:58 PM Julien Bonnier wrote:


    >>>>>>>>> I made a QRY that simulate a snapshot for a selected date using this table.
    >>>>>>>>> I tested like 30 times and it is always good. If anybody need it, I can post
    >>>>>>>>> it.



    >>>>>>>>>> On Friday, May 04, 2007 7:24 AM Ahmed Nashat wrote:


    >>>>>>>>>> This is a multi-part message in MIME format.
    >>>>>>>>>>
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0
    >>>>>>>>>> Content-Type: text/plain;
    >>>>>>>>>> charset="windows-1256"
    >>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>
    >>>>>>>>>> Julien,
    >>>>>>>>>>
    >>>>>>>>>> You can usually find this kind of information in RMS reports, for =
    >>>>>>>>>> example, you can find the movement types in "Items - Item Movement =
    >>>>>>>>>> Report.qrp", you will find the following string in the formula line of =
    >>>>>>>>>> "Type" column,=20
    >>>>>>>>>>
    >>>>>>>>>> "CASE Type WHEN 1 THEN 'PO/Inventory Transfer' WHEN 2 THEN 'Return to =
    >>>>>>>>>> Off-Line' WHEN 3 THEN 'Transfer Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 =
    >>>>>>>>>> THEN 'Manual Adjustment' WHEN 6 THEN 'Inventory Wizard' WHEN 7 THEN =
    >>>>>>>>>> 'Physical Inventory Adjustment' WHEN 8 THEN 'HQ Adjustment' WHEN 9 THEN =
    >>>>>>>>>> 'Parent Child Adjustment' WHEN 10 THEN 'Kit Component Transfer' WHEN 99 =
    >>>>>>>>>> THEN 'Sales/Return' ELSE 'Unknown' END"
    >>>>>>>>>>
    >>>>>>>>>> This is true too for other unknow values like the PriceSource in =
    >>>>>>>>>> TransactionEntry, you might know its details in "Sales - Detailed Sales =
    >>>>>>>>>> Report.qrp":-
    >>>>>>>>>>
    >>>>>>>>>> "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 =
    >>>>>>>>>> THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 THEN =
    >>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>> Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>> Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' =
    >>>>>>>>>> WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component' WHEN 12 THEN 'Price =
    >>>>>>>>>> Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price =
    >>>>>>>>>> Level C Disc.' WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>> from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"
    >>>>>>>>>>
    >>>>>>>>>> Nashat
    >>>>>>>>>>
    >>>>>>>>>> "Julien Bonnier" <> wrote in message =
    >>>>>>>>>> news:...
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0
    >>>>>>>>>> Content-Type: text/html;
    >>>>>>>>>> charset="windows-1256"
    >>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>
    >>>>>>>>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    >>>>>>>>>> <HTML><HEAD>
    >>>>>>>>>> <META http-equiv=3DContent-Type content=3D"text/html; =
    >>>>>>>>>> charset=3Dwindows-1256">
    >>>>>>>>>> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
    >>>>>>>>>> <STYLE></STYLE>
    >>>>>>>>>> </HEAD>
    >>>>>>>>>> <BODY>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2>Julien,</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>You can =
    >>>>>>>>>> usually find this=20
    >>>>>>>>>> kind of information in RMS reports, for example, you can find the =
    >>>>>>>>>> movement types=20
    >>>>>>>>>> in "Items - Item Movement Report.qrp", you will find the following =
    >>>>>>>>>> string in the=20
    >>>>>>>>>> formula line of "Type" column, </FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE Type =
    >>>>>>>>>> WHEN 1 THEN=20
    >>>>>>>>>> 'PO/Inventory Transfer' WHEN 2 THEN 'Return to Off-Line' WHEN 3 THEN =
    >>>>>>>>>> 'Transfer=20
    >>>>>>>>>> Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 THEN 'Manual Adjustment' WHEN 6 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Inventory Wizard' WHEN 7 THEN 'Physical Inventory Adjustment' WHEN 8 =
    >>>>>>>>>> THEN 'HQ=20
    >>>>>>>>>> Adjustment' WHEN 9 THEN 'Parent Child Adjustment' WHEN 10 THEN 'Kit =
    >>>>>>>>>> Component=20
    >>>>>>>>>> Transfer' WHEN 99 THEN 'Sales/Return' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>This is true =
    >>>>>>>>>> too for other=20
    >>>>>>>>>> unknow values like the PriceSource in TransactionEntry, you might know =
    >>>>>>>>>> its=20
    >>>>>>>>>> details in "Sales - Detailed Sales Report.qrp":-</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE=20
    >>>>>>>>>> TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 THEN =
    >>>>>>>>>> (CASE WHEN=20
    >>>>>>>>>> TransactionEntry.QuantityDiscountID &lt;&gt; 0 THEN =
    >>>>>>>>>> QuantityDiscount.Description=20
    >>>>>>>>>> ELSE 'Quantity Discount' END) WHEN 3 THEN 'Buydown Discount' WHEN 4 THEN =
    >>>>>>>>>> 'Price=20
    >>>>>>>>>> Level Disc.' WHEN 5 THEN 'Sale Price' WHEN 6 THEN 'Disc. from Reg. =
    >>>>>>>>>> Price' WHEN 7=20
    >>>>>>>>>> THEN 'Disc. from Cur. Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN =
    >>>>>>>>>> 'Profit=20
    >>>>>>>>>> Margin Disc.' WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component'&nbsp; =
    >>>>>>>>>> WHEN 12=20
    >>>>>>>>>> THEN 'Price Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Price Level C Disc.'&nbsp; WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Disc. from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN =
    >>>>>>>>>> 'Profit=20
    >>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2>Nashat</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3DArial size=3D2>"Julien Bonnier" &lt;</FONT><A=20
    >>>>>>>>>> href=3D"mailto:"><FONT face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in message=20
    >>>>>>>>>> </FONT><A href=3D"news:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; BTW where do =
    >>>>>>>>>> you get this=20
    >>>>>>>>>> type of informations ?<BR>&gt; <BR>&gt; Because I like to know almost =
    >>>>>>>>>> every=20
    >>>>>>>>>> fields of every tables<BR>&gt; Is-it documented on the microsoft=20
    >>>>>>>>>> website?<BR>&gt; <BR>&gt; Thanks<BR>&gt; <BR>&gt; Julien<BR>&gt; =
    >>>>>>>>>> <BR>&gt; "MOH.=20
    >>>>>>>>>> OWN" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in=20
    >>>>>>>>>> message <BR>&gt; </FONT><A=20
    >>>>>>>>>> href=3D"news:"><FONT face=3DArial=20
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>...<BR>&gt;&gt; Hi Julien<BR>&gt;&gt;<BR>&gt;&gt; On Invenory =
    >>>>>>>>>> Transferlog=20
    >>>>>>>>>> this which type you well find:<BR>&gt;&gt; 1-for Inventory history =
    >>>>>>>>>> (which item=20
    >>>>>>>>>> you issued /riceved/ po planner).<BR>&gt;&gt; 3-Sales Item.<BR>&gt;&gt;=20
    >>>>>>>>>> 4-transfear Item to Offline inventory.<BR>&gt;&gt; 5-Manual adjustmint =
    >>>>>>>>>> for qty=20
    >>>>>>>>>> (If happen on store).<BR>&gt;&gt; 7-physical Inventory.<BR>&gt;&gt; 8-HQ =
    >>>>>>>>>>
    >>>>>>>>>> Adjustmint.<BR>&gt;&gt;<BR>&gt;&gt; I hoppe if this help=20
    >>>>>>>>>> you<BR>&gt;&gt;<BR>&gt;&gt; Best Regards<BR>&gt;&gt;<BR>&gt;&gt; -- =
    >>>>>>>>>> <BR>&gt;&gt;=20
    >>>>>>>>>> MOH.OWN<BR>&gt;&gt; THE BODY SHOP<BR>&gt;&gt; K.S.A<BR>&gt;&gt; MOB:+966 =
    >>>>>>>>>>
    >>>>>>>>>> 557266607<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; =
    >>>>>>>>>> "Julien=20
    >>>>>>>>>> Bonnier" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in message=20
    >>>>>>>>>> <BR>&gt;&gt; </FONT><A =
    >>>>>>>>>> href=3D"news:"><FONT=20
    >>>>>>>>>> face=3DArial =
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT=20
    >>>>>>>>>> face=3DArial size=3D2>...<BR>&gt;&gt;&gt; Hello=20
    >>>>>>>>>> People!<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Where can I get list that =
    >>>>>>>>>> explains the=20
    >>>>>>>>>> Transfers Type<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; These are the values I =
    >>>>>>>>>> have in my=20
    >>>>>>>>>> HQ DB 1,5,8<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; But I need the complete=20
    >>>>>>>>>> list<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thank=20
    >>>>>>>>>> You<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;=20
    >>>>>>>>>> Julien<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; <BR>&gt;=20
    >>>>>>>>>> <BR>&gt;</FONT></BODY></HTML>
    >>>>>>>>>>
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0--



    >>>>>>>>>>> On Monday, May 07, 2007 9:21 AM Julien Bonnier wrote:


    >>>>>>>>>>> This is a multi-part message in MIME format.
    >>>>>>>>>>>
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0
    >>>>>>>>>>> Content-Type: text/plain;
    >>>>>>>>>>> charset="windows-1256"
    >>>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>>
    >>>>>>>>>>> Oh man!=20
    >>>>>>>>>>>
    >>>>>>>>>>> Thanks alot Nashat!!!
    >>>>>>>>>>>
    >>>>>>>>>>> You're the BOMB!!
    >>>>>>>>>>>
    >>>>>>>>>>>
    >>>>>>>>>>> "Ahmed Nashat" <> wrote in message =
    >>>>>>>>>>> news:%...
    >>>>>>>>>>> Julien,
    >>>>>>>>>>>
    >>>>>>>>>>> You can usually find this kind of information in RMS reports, for =
    >>>>>>>>>>> example, you can find the movement types in "Items - Item Movement =
    >>>>>>>>>>> Report.qrp", you will find the following string in the formula line of =
    >>>>>>>>>>> "Type" column,=20
    >>>>>>>>>>>
    >>>>>>>>>>> "CASE Type WHEN 1 THEN 'PO/Inventory Transfer' WHEN 2 THEN 'Return to =
    >>>>>>>>>>> Off-Line' WHEN 3 THEN 'Transfer Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 =
    >>>>>>>>>>> THEN 'Manual Adjustment' WHEN 6 THEN 'Inventory Wizard' WHEN 7 THEN =
    >>>>>>>>>>> 'Physical Inventory Adjustment' WHEN 8 THEN 'HQ Adjustment' WHEN 9 THEN =
    >>>>>>>>>>> 'Parent Child Adjustment' WHEN 10 THEN 'Kit Component Transfer' WHEN 99 =
    >>>>>>>>>>> THEN 'Sales/Return' ELSE 'Unknown' END"
    >>>>>>>>>>>
    >>>>>>>>>>> This is true too for other unknow values like the PriceSource in =
    >>>>>>>>>>> TransactionEntry, you might know its details in "Sales - Detailed Sales =
    >>>>>>>>>>> Report.qrp":-
    >>>>>>>>>>>
    >>>>>>>>>>> "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 =
    >>>>>>>>>>> THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 THEN =
    >>>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>>> Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>>> Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' =
    >>>>>>>>>>> WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component' WHEN 12 THEN 'Price =
    >>>>>>>>>>> Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price =
    >>>>>>>>>>> Level C Disc.' WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>>> from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"
    >>>>>>>>>>>
    >>>>>>>>>>> Nashat
    >>>>>>>>>>>
    >>>>>>>>>>> "Julien Bonnier" <> wrote in message =
    >>>>>>>>>>> news:...
    >>>>>>>>>>> > BTW where do you get this type of informations ?
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Because I like to know almost every fields of every tables
    >>>>>>>>>>> > Is-it documented on the microsoft website?
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Thanks
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Julien
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > "MOH. OWN" <> wrote in message=20
    >>>>>>>>>>> > news:...
    >>>>>>>>>>> >> Hi Julien
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> On Invenory Transferlog this which type you well find:
    >>>>>>>>>>> >> 1-for Inventory history (which item you issued /riceved/ po =
    >>>>>>>>>>> planner).
    >>>>>>>>>>> >> 3-Sales Item.
    >>>>>>>>>>> >> 4-transfear Item to Offline inventory.
    >>>>>>>>>>> >> 5-Manual adjustmint for qty (If happen on store).
    >>>>>>>>>>> >> 7-physical Inventory.
    >>>>>>>>>>> >> 8-HQ Adjustmint.
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> I hoppe if this help you
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> Best Regards
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> --=20
    >>>>>>>>>>> >> MOH.OWN
    >>>>>>>>>>> >> THE BODY SHOP
    >>>>>>>>>>> >> K.S.A
    >>>>>>>>>>> >> MOB:+966 557266607
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> "Julien Bonnier" <> wrote in message=20
    >>>>>>>>>>> >> news:...
    >>>>>>>>>>> >>> Hello People!
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Where can I get list that explains the Transfers Type
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> These are the values I have in my HQ DB 1,5,8
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> But I need the complete list
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Thank You
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Julien
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>=20
    >>>>>>>>>>> >=20
    >>>>>>>>>>> >
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0
    >>>>>>>>>>> Content-Type: text/html;
    >>>>>>>>>>> charset="windows-1256"
    >>>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>>
    >>>>>>>>>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    >>>>>>>>>>> <HTML><HEAD>
    >>>>>>>>>>> <META http-equiv=3DContent-Type content=3D"text/html; =
    >>>>>>>>>>> charset=3Dwindows-1256">
    >>>>>>>>>>> <META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
    >>>>>>>>>>> <STYLE></STYLE>
    >>>>>>>>>>> </HEAD>
    >>>>>>>>>>> <BODY bgColor=3D#ffffff>
    >>>>>>>>>>> <DIV><FONT size=3D2>Oh man! </FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2>Thanks alot Nashat!!!</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2>You're the BOMB!!</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <BLOCKQUOTE=20
    >>>>>>>>>>> style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
    >>>>>>>>>>> BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    >>>>>>>>>>> <DIV>"Ahmed Nashat" &lt;<A=20
    >>>>>>>>>>> href=3D"mailto:"></A>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message <A=20
    >>>>>>>>>>> =
    >>>>>>>>>>> href=3D"news:%">news:%23Tlk66jjHHA.=
    >>>>>>>>>>> </A>...</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2>Julien,</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>You can =
    >>>>>>>>>>> usually find=20
    >>>>>>>>>>> this kind of information in RMS reports, for example, you can find the =
    >>>>>>>>>>>
    >>>>>>>>>>> movement types in "Items - Item Movement Report.qrp", you will find =
    >>>>>>>>>>> the=20
    >>>>>>>>>>> following string in the formula line of "Type" column, </FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE Type =
    >>>>>>>>>>> WHEN 1 THEN=20
    >>>>>>>>>>> 'PO/Inventory Transfer' WHEN 2 THEN 'Return to Off-Line' WHEN 3 THEN =
    >>>>>>>>>>> 'Transfer=20
    >>>>>>>>>>> Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 THEN 'Manual Adjustment' WHEN =
    >>>>>>>>>>> 6 THEN=20
    >>>>>>>>>>> 'Inventory Wizard' WHEN 7 THEN 'Physical Inventory Adjustment' WHEN 8 =
    >>>>>>>>>>> THEN 'HQ=20
    >>>>>>>>>>> Adjustment' WHEN 9 THEN 'Parent Child Adjustment' WHEN 10 THEN 'Kit =
    >>>>>>>>>>> Component=20
    >>>>>>>>>>> Transfer' WHEN 99 THEN 'Sales/Return' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>This is =
    >>>>>>>>>>> true too for=20
    >>>>>>>>>>> other unknow values like the PriceSource in TransactionEntry, you =
    >>>>>>>>>>> might know=20
    >>>>>>>>>>> its details in "Sales - Detailed Sales Report.qrp":-</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE=20
    >>>>>>>>>>> TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 THEN =
    >>>>>>>>>>> (CASE=20
    >>>>>>>>>>> WHEN TransactionEntry.QuantityDiscountID &lt;&gt; 0 THEN=20
    >>>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>>>
    >>>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>>> Price'=20
    >>>>>>>>>>> WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>>> Price' WHEN 8=20
    >>>>>>>>>>> THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' WHEN 10 =
    >>>>>>>>>>> THEN=20
    >>>>>>>>>>> 'Cashier Set' WHEN 11 THEN 'Component'&nbsp; WHEN 12 THEN 'Price Level =
    >>>>>>>>>>> A=20
    >>>>>>>>>>> Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price Level C=20
    >>>>>>>>>>> Disc.'&nbsp; WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>>> from=20
    >>>>>>>>>>> Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>>> Margin=20
    >>>>>>>>>>> Disc.' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2>Nashat</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3DArial size=3D2>"Julien Bonnier" &lt;</FONT><A=20
    >>>>>>>>>>> href=3D"mailto:"><FONT face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message </FONT><A =
    >>>>>>>>>>> href=3D"news:"><FONT=20
    >>>>>>>>>>> face=3DArial =
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT=20
    >>>>>>>>>>> face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> BTW where do=20
    >>>>>>>>>>> you get this type of informations ?<BR>&gt; <BR>&gt; Because I like to =
    >>>>>>>>>>> know=20
    >>>>>>>>>>> almost every fields of every tables<BR>&gt; Is-it documented on the =
    >>>>>>>>>>> microsoft=20
    >>>>>>>>>>> website?<BR>&gt; <BR>&gt; Thanks<BR>&gt; <BR>&gt; Julien<BR>&gt; =
    >>>>>>>>>>> <BR>&gt;=20
    >>>>>>>>>>> "MOH. OWN" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial =
    >>>>>>>>>>> size=3D2>&gt; wrote in=20
    >>>>>>>>>>> message <BR>&gt; </FONT><A=20
    >>>>>>>>>>> href=3D"news:"><FONT face=3DArial =
    >>>>>>>>>>>
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2>...<BR>&gt;&gt; Hi Julien<BR>&gt;&gt;<BR>&gt;&gt; On Invenory =
    >>>>>>>>>>>
    >>>>>>>>>>> Transferlog this which type you well find:<BR>&gt;&gt; 1-for Inventory =
    >>>>>>>>>>> history=20
    >>>>>>>>>>> (which item you issued /riceved/ po planner).<BR>&gt;&gt; 3-Sales=20
    >>>>>>>>>>> Item.<BR>&gt;&gt; 4-transfear Item to Offline inventory.<BR>&gt;&gt; =
    >>>>>>>>>>> 5-Manual=20
    >>>>>>>>>>> adjustmint for qty (If happen on store).<BR>&gt;&gt; 7-physical=20
    >>>>>>>>>>> Inventory.<BR>&gt;&gt; 8-HQ Adjustmint.<BR>&gt;&gt;<BR>&gt;&gt; I =
    >>>>>>>>>>> hoppe if=20
    >>>>>>>>>>> this help you<BR>&gt;&gt;<BR>&gt;&gt; Best =
    >>>>>>>>>>> Regards<BR>&gt;&gt;<BR>&gt;&gt; --=20
    >>>>>>>>>>> <BR>&gt;&gt; MOH.OWN<BR>&gt;&gt; THE BODY SHOP<BR>&gt;&gt; =
    >>>>>>>>>>> K.S.A<BR>&gt;&gt;=20
    >>>>>>>>>>> MOB:+966 =
    >>>>>>>>>>> 557266607<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;=20
    >>>>>>>>>>> "Julien Bonnier" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message <BR>&gt;&gt; </FONT><A=20
    >>>>>>>>>>> href=3D"news:"><FONT face=3DArial =
    >>>>>>>>>>>
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2>...<BR>&gt;&gt;&gt; Hello =
    >>>>>>>>>>> People!<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Where=20
    >>>>>>>>>>> can I get list that explains the Transfers=20
    >>>>>>>>>>> Type<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; These are the values I have in my =
    >>>>>>>>>>> HQ DB=20
    >>>>>>>>>>> 1,5,8<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; But I need the complete=20
    >>>>>>>>>>> list<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thank=20
    >>>>>>>>>>> You<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;=20
    >>>>>>>>>>> Julien<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; <BR>&gt; =
    >>>>>>>>>>> <BR>&gt;</FONT>=20
    >>>>>>>>>>> </BLOCKQUOTE></BODY></HTML>
    >>>>>>>>>>>
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0--



    >>>>>>>>>>>> On Wednesday, May 09, 2007 3:33 PM Mar wrote:


    >>>>>>>>>>>> Moh,
    >>>>>>>>>>>>
    >>>>>>>>>>>> I'm really curious what table(s) are used to programmatically calculate
    >>>>>>>>>>>> headquarters OH qty for an item when a change is made at the store. As an
    >>>>>>>>>>>> example if I do an adjustment to an item at the store. When Headquarters
    >>>>>>>>>>>> server runs what table(s) are used to recalc the oh quantity for the item?
    >>>>>>>>>>>> Maybe the question should be where in headquarters would i set the record
    >>>>>>>>>>>> that tells Headquarters to recalc oh qty using this adjusted amount?
    >>>>>>>>>>>>
    >>>>>>>>>>>> Mark
    >>>>>>>>>>>>
    >>>>>>>>>>>> "MOH. OWN" wrote:



    >>>>>>>>>>>>> On Thursday, May 05, 2011 4:57 AM Lam Hoang wrote:


    >>>>>>>>>>>>> Hi,
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> I'm looking forward to hear from you soon.
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> Thanks and regards,
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> Lam Hoang
     
    Lam Hoang, May 5, 2011
    #12
  13. Julien Bonnier

    Lam Hoang Guest

    Re: I made a QRY that simulate a snapshot for a selected date usingthis table.

    Hi,

    I've currently used RMS and need to capture Inventory quantity in a specific date range. I'm very appreciated if you can send this QRY for me.

    Looking forward to hearing from you.

    Thanks and regards,
    Lam Hoang


    > On Monday, April 30, 2007 3:51 PM Julien Bonnier wrote:


    > Hello People!
    >
    > Where can I get list that explains the Transfers Type
    >
    > These are the values I have in my HQ DB 1,5,8
    >
    > But I need the complete list
    >
    > Thank You
    >
    >
    > Julien



    >> On Tuesday, May 01, 2007 3:13 AM MOH. OWN wrote:


    >> Hi Julien
    >>
    >> On Invenory Transferlog this which type you well find:
    >> 1-for Inventory history (which item you issued /riceved/ po planner).
    >> 3-Sales Item.
    >> 4-transfear Item to Offline inventory.
    >> 5-Manual adjustmint for qty (If happen on store).
    >> 7-physical Inventory.
    >> 8-HQ Adjustmint.
    >>
    >> I hoppe if this help you
    >>
    >> Best Regards
    >>
    >> --
    >> MOH.OWN
    >> THE BODY SHOP
    >> K.S.A
    >> MOB:+966 557266607
    >>
    >>
    >>
    >>
    >> "Julien Bonnier" <> wrote in message
    >> news:...



    >>> On Tuesday, May 01, 2007 11:34 AM Julien Bonnier wrote:


    >>> Yes thanks alot!
    >>>
    >>> Regards
    >>>
    >>> Julien



    >>>> On Tuesday, May 01, 2007 11:49 AM Julien Bonnier wrote:


    >>>> BTW where do you get this type of informations ?
    >>>>
    >>>> Because I like to know almost every fields of every tables
    >>>> Is-it documented on the microsoft website?
    >>>>
    >>>> Thanks
    >>>>
    >>>> Julien



    >>>>> On Tuesday, May 01, 2007 12:48 PM MOH. OWN wrote:


    >>>>> HI Julien
    >>>>>
    >>>>> I don't have any docmunt. How i find?
    >>>>> I open inventory transferlog table on sql and start check i select type 5
    >>>>> and last day i do that after that on HQ manager from Item movemint i check
    >>>>> what's that? you can do for all taple only check evry table what's the
    >>>>> report for that or is link to other table. (like that).
    >>>>>
    >>>>> I hoppe if this help you.
    >>>>>
    >>>>>
    >>>>> --
    >>>>> MOH.OWN
    >>>>> THE BODY SHOP
    >>>>> K.S.A
    >>>>> MOB:+966 557266607



    >>>>>> On Wednesday, May 02, 2007 3:58 PM Mar wrote:


    >>>>>> I'm kind of curious, is the inventorytransferlog what is used to determine
    >>>>>> the inventory quantity for a store? For example does it recalc everytime a
    >>>>>> quantity is changed using the values from this table?
    >>>>>>
    >>>>>> "MOH. OWN" wrote:



    >>>>>>> On Wednesday, May 02, 2007 4:26 PM Glenn Adams [MVP - Retail Mgmt] wrote:


    >>>>>>> No, it's a history of inventory movements. Any actions that change
    >>>>>>> current inventory - sales, returns, receiving, tranfsers, manual
    >>>>>>> adjustments, pbobably some more that I'm missing - all insert records
    >>>>>>> into this table. This is the core table of the Inventory Movement
    >>>>>>> reports. Given the current quantity on hand, you can use the
    >>>>>>> inventoryTransferLog to calculate back to the quantity at a previous date.
    >>>>>>>
    >>>>>>> The only thing I know of that is unlogged is a direct update to quantity
    >>>>>>> using SQL. There may be other things that are missed, I just don't know
    >>>>>>> of any off hand.
    >>>>>>>
    >>>>>>> Glenn Adams
    >>>>>>> Tiber Creek Consulting
    >>>>>>> http://www.tibercreek.com
    >>>>>>>
    >>>>>>> ----------------------------------------------
    >>>>>>> Please DO NOT respond to me directly but post all responses here in the
    >>>>>>> newsgroup so that all can share the information.
    >>>>>>>
    >>>>>>>
    >>>>>>> Mark wrote:



    >>>>>>>> On Wednesday, May 02, 2007 4:33 PM Mar wrote:


    >>>>>>>> Thank you Glenn, that is great insight to the system that I have always
    >>>>>>>> wanted to know.
    >>>>>>>>
    >>>>>>>> "Glenn Adams [MVP - Retail Mgmt]" wrote:



    >>>>>>>>> On Thursday, May 03, 2007 12:58 PM Julien Bonnier wrote:


    >>>>>>>>> I made a QRY that simulate a snapshot for a selected date using this table.
    >>>>>>>>> I tested like 30 times and it is always good. If anybody need it, I can post
    >>>>>>>>> it.



    >>>>>>>>>> On Friday, May 04, 2007 7:24 AM Ahmed Nashat wrote:


    >>>>>>>>>> This is a multi-part message in MIME format.
    >>>>>>>>>>
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0
    >>>>>>>>>> Content-Type: text/plain;
    >>>>>>>>>> charset="windows-1256"
    >>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>
    >>>>>>>>>> Julien,
    >>>>>>>>>>
    >>>>>>>>>> You can usually find this kind of information in RMS reports, for =
    >>>>>>>>>> example, you can find the movement types in "Items - Item Movement =
    >>>>>>>>>> Report.qrp", you will find the following string in the formula line of =
    >>>>>>>>>> "Type" column,=20
    >>>>>>>>>>
    >>>>>>>>>> "CASE Type WHEN 1 THEN 'PO/Inventory Transfer' WHEN 2 THEN 'Return to =
    >>>>>>>>>> Off-Line' WHEN 3 THEN 'Transfer Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 =
    >>>>>>>>>> THEN 'Manual Adjustment' WHEN 6 THEN 'Inventory Wizard' WHEN 7 THEN =
    >>>>>>>>>> 'Physical Inventory Adjustment' WHEN 8 THEN 'HQ Adjustment' WHEN 9 THEN =
    >>>>>>>>>> 'Parent Child Adjustment' WHEN 10 THEN 'Kit Component Transfer' WHEN 99 =
    >>>>>>>>>> THEN 'Sales/Return' ELSE 'Unknown' END"
    >>>>>>>>>>
    >>>>>>>>>> This is true too for other unknow values like the PriceSource in =
    >>>>>>>>>> TransactionEntry, you might know its details in "Sales - Detailed Sales =
    >>>>>>>>>> Report.qrp":-
    >>>>>>>>>>
    >>>>>>>>>> "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 =
    >>>>>>>>>> THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 THEN =
    >>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>> Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>> Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' =
    >>>>>>>>>> WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component' WHEN 12 THEN 'Price =
    >>>>>>>>>> Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price =
    >>>>>>>>>> Level C Disc.' WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>> from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"
    >>>>>>>>>>
    >>>>>>>>>> Nashat
    >>>>>>>>>>
    >>>>>>>>>> "Julien Bonnier" <> wrote in message =
    >>>>>>>>>> news:...
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0
    >>>>>>>>>> Content-Type: text/html;
    >>>>>>>>>> charset="windows-1256"
    >>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>
    >>>>>>>>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    >>>>>>>>>> <HTML><HEAD>
    >>>>>>>>>> <META http-equiv=3DContent-Type content=3D"text/html; =
    >>>>>>>>>> charset=3Dwindows-1256">
    >>>>>>>>>> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
    >>>>>>>>>> <STYLE></STYLE>
    >>>>>>>>>> </HEAD>
    >>>>>>>>>> <BODY>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2>Julien,</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>You can =
    >>>>>>>>>> usually find this=20
    >>>>>>>>>> kind of information in RMS reports, for example, you can find the =
    >>>>>>>>>> movement types=20
    >>>>>>>>>> in "Items - Item Movement Report.qrp", you will find the following =
    >>>>>>>>>> string in the=20
    >>>>>>>>>> formula line of "Type" column, </FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE Type =
    >>>>>>>>>> WHEN 1 THEN=20
    >>>>>>>>>> 'PO/Inventory Transfer' WHEN 2 THEN 'Return to Off-Line' WHEN 3 THEN =
    >>>>>>>>>> 'Transfer=20
    >>>>>>>>>> Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 THEN 'Manual Adjustment' WHEN 6 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Inventory Wizard' WHEN 7 THEN 'Physical Inventory Adjustment' WHEN 8 =
    >>>>>>>>>> THEN 'HQ=20
    >>>>>>>>>> Adjustment' WHEN 9 THEN 'Parent Child Adjustment' WHEN 10 THEN 'Kit =
    >>>>>>>>>> Component=20
    >>>>>>>>>> Transfer' WHEN 99 THEN 'Sales/Return' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>This is true =
    >>>>>>>>>> too for other=20
    >>>>>>>>>> unknow values like the PriceSource in TransactionEntry, you might know =
    >>>>>>>>>> its=20
    >>>>>>>>>> details in "Sales - Detailed Sales Report.qrp":-</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE=20
    >>>>>>>>>> TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 THEN =
    >>>>>>>>>> (CASE WHEN=20
    >>>>>>>>>> TransactionEntry.QuantityDiscountID &lt;&gt; 0 THEN =
    >>>>>>>>>> QuantityDiscount.Description=20
    >>>>>>>>>> ELSE 'Quantity Discount' END) WHEN 3 THEN 'Buydown Discount' WHEN 4 THEN =
    >>>>>>>>>> 'Price=20
    >>>>>>>>>> Level Disc.' WHEN 5 THEN 'Sale Price' WHEN 6 THEN 'Disc. from Reg. =
    >>>>>>>>>> Price' WHEN 7=20
    >>>>>>>>>> THEN 'Disc. from Cur. Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN =
    >>>>>>>>>> 'Profit=20
    >>>>>>>>>> Margin Disc.' WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component'&nbsp; =
    >>>>>>>>>> WHEN 12=20
    >>>>>>>>>> THEN 'Price Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Price Level C Disc.'&nbsp; WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 =
    >>>>>>>>>> THEN=20
    >>>>>>>>>> 'Disc. from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN =
    >>>>>>>>>> 'Profit=20
    >>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>> size=3D2>Nashat</FONT></DIV>
    >>>>>>>>>> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>> <DIV><FONT face=3DArial size=3D2>"Julien Bonnier" &lt;</FONT><A=20
    >>>>>>>>>> href=3D"mailto:"><FONT face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in message=20
    >>>>>>>>>> </FONT><A href=3D"news:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; BTW where do =
    >>>>>>>>>> you get this=20
    >>>>>>>>>> type of informations ?<BR>&gt; <BR>&gt; Because I like to know almost =
    >>>>>>>>>> every=20
    >>>>>>>>>> fields of every tables<BR>&gt; Is-it documented on the microsoft=20
    >>>>>>>>>> website?<BR>&gt; <BR>&gt; Thanks<BR>&gt; <BR>&gt; Julien<BR>&gt; =
    >>>>>>>>>> <BR>&gt; "MOH.=20
    >>>>>>>>>> OWN" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in=20
    >>>>>>>>>> message <BR>&gt; </FONT><A=20
    >>>>>>>>>> href=3D"news:"><FONT face=3DArial=20
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2>...<BR>&gt;&gt; Hi Julien<BR>&gt;&gt;<BR>&gt;&gt; On Invenory =
    >>>>>>>>>> Transferlog=20
    >>>>>>>>>> this which type you well find:<BR>&gt;&gt; 1-for Inventory history =
    >>>>>>>>>> (which item=20
    >>>>>>>>>> you issued /riceved/ po planner).<BR>&gt;&gt; 3-Sales Item.<BR>&gt;&gt;=20
    >>>>>>>>>> 4-transfear Item to Offline inventory.<BR>&gt;&gt; 5-Manual adjustmint =
    >>>>>>>>>> for qty=20
    >>>>>>>>>> (If happen on store).<BR>&gt;&gt; 7-physical Inventory.<BR>&gt;&gt; 8-HQ =
    >>>>>>>>>>
    >>>>>>>>>> Adjustmint.<BR>&gt;&gt;<BR>&gt;&gt; I hoppe if this help=20
    >>>>>>>>>> you<BR>&gt;&gt;<BR>&gt;&gt; Best Regards<BR>&gt;&gt;<BR>&gt;&gt; -- =
    >>>>>>>>>> <BR>&gt;&gt;=20
    >>>>>>>>>> MOH.OWN<BR>&gt;&gt; THE BODY SHOP<BR>&gt;&gt; K.S.A<BR>&gt;&gt; MOB:+966 =
    >>>>>>>>>>
    >>>>>>>>>> 557266607<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; =
    >>>>>>>>>> "Julien=20
    >>>>>>>>>> Bonnier" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>> face=3DArial=20
    >>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>> wrote in message=20
    >>>>>>>>>> <BR>&gt;&gt; </FONT><A =
    >>>>>>>>>> href=3D"news:"><FONT=20
    >>>>>>>>>> face=3DArial =
    >>>>>>>>>> size=3D2>news:</FONT></A><FONT=20
    >>>>>>>>>> face=3DArial size=3D2>...<BR>&gt;&gt;&gt; Hello=20
    >>>>>>>>>> People!<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Where can I get list that =
    >>>>>>>>>> explains the=20
    >>>>>>>>>> Transfers Type<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; These are the values I =
    >>>>>>>>>> have in my=20
    >>>>>>>>>> HQ DB 1,5,8<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; But I need the complete=20
    >>>>>>>>>> list<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thank=20
    >>>>>>>>>> You<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;=20
    >>>>>>>>>> Julien<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; <BR>&gt;=20
    >>>>>>>>>> <BR>&gt;</FONT></BODY></HTML>
    >>>>>>>>>>
    >>>>>>>>>> ------=_NextPart_000_004D_01C78E57.DF9FA8B0--



    >>>>>>>>>>> On Monday, May 07, 2007 9:21 AM Julien Bonnier wrote:


    >>>>>>>>>>> This is a multi-part message in MIME format.
    >>>>>>>>>>>
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0
    >>>>>>>>>>> Content-Type: text/plain;
    >>>>>>>>>>> charset="windows-1256"
    >>>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>>
    >>>>>>>>>>> Oh man!=20
    >>>>>>>>>>>
    >>>>>>>>>>> Thanks alot Nashat!!!
    >>>>>>>>>>>
    >>>>>>>>>>> You're the BOMB!!
    >>>>>>>>>>>
    >>>>>>>>>>>
    >>>>>>>>>>> "Ahmed Nashat" <> wrote in message =
    >>>>>>>>>>> news:%...
    >>>>>>>>>>> Julien,
    >>>>>>>>>>>
    >>>>>>>>>>> You can usually find this kind of information in RMS reports, for =
    >>>>>>>>>>> example, you can find the movement types in "Items - Item Movement =
    >>>>>>>>>>> Report.qrp", you will find the following string in the formula line of =
    >>>>>>>>>>> "Type" column,=20
    >>>>>>>>>>>
    >>>>>>>>>>> "CASE Type WHEN 1 THEN 'PO/Inventory Transfer' WHEN 2 THEN 'Return to =
    >>>>>>>>>>> Off-Line' WHEN 3 THEN 'Transfer Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 =
    >>>>>>>>>>> THEN 'Manual Adjustment' WHEN 6 THEN 'Inventory Wizard' WHEN 7 THEN =
    >>>>>>>>>>> 'Physical Inventory Adjustment' WHEN 8 THEN 'HQ Adjustment' WHEN 9 THEN =
    >>>>>>>>>>> 'Parent Child Adjustment' WHEN 10 THEN 'Kit Component Transfer' WHEN 99 =
    >>>>>>>>>>> THEN 'Sales/Return' ELSE 'Unknown' END"
    >>>>>>>>>>>
    >>>>>>>>>>> This is true too for other unknow values like the PriceSource in =
    >>>>>>>>>>> TransactionEntry, you might know its details in "Sales - Detailed Sales =
    >>>>>>>>>>> Report.qrp":-
    >>>>>>>>>>>
    >>>>>>>>>>> "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 =
    >>>>>>>>>>> THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 THEN =
    >>>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>>> Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>>> Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' =
    >>>>>>>>>>> WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component' WHEN 12 THEN 'Price =
    >>>>>>>>>>> Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price =
    >>>>>>>>>>> Level C Disc.' WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>>> from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>>> Margin Disc.' ELSE 'Unknown' END"
    >>>>>>>>>>>
    >>>>>>>>>>> Nashat
    >>>>>>>>>>>
    >>>>>>>>>>> "Julien Bonnier" <> wrote in message =
    >>>>>>>>>>> news:...
    >>>>>>>>>>> > BTW where do you get this type of informations ?
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Because I like to know almost every fields of every tables
    >>>>>>>>>>> > Is-it documented on the microsoft website?
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Thanks
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > Julien
    >>>>>>>>>>> >=20
    >>>>>>>>>>> > "MOH. OWN" <> wrote in message=20
    >>>>>>>>>>> > news:...
    >>>>>>>>>>> >> Hi Julien
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> On Invenory Transferlog this which type you well find:
    >>>>>>>>>>> >> 1-for Inventory history (which item you issued /riceved/ po =
    >>>>>>>>>>> planner).
    >>>>>>>>>>> >> 3-Sales Item.
    >>>>>>>>>>> >> 4-transfear Item to Offline inventory.
    >>>>>>>>>>> >> 5-Manual adjustmint for qty (If happen on store).
    >>>>>>>>>>> >> 7-physical Inventory.
    >>>>>>>>>>> >> 8-HQ Adjustmint.
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> I hoppe if this help you
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> Best Regards
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> --=20
    >>>>>>>>>>> >> MOH.OWN
    >>>>>>>>>>> >> THE BODY SHOP
    >>>>>>>>>>> >> K.S.A
    >>>>>>>>>>> >> MOB:+966 557266607
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >> "Julien Bonnier" <> wrote in message=20
    >>>>>>>>>>> >> news:...
    >>>>>>>>>>> >>> Hello People!
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Where can I get list that explains the Transfers Type
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> These are the values I have in my HQ DB 1,5,8
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> But I need the complete list
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Thank You
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>> Julien
    >>>>>>>>>>> >>>
    >>>>>>>>>>> >>
    >>>>>>>>>>> >>=20
    >>>>>>>>>>> >=20
    >>>>>>>>>>> >
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0
    >>>>>>>>>>> Content-Type: text/html;
    >>>>>>>>>>> charset="windows-1256"
    >>>>>>>>>>> Content-Transfer-Encoding: quoted-printable
    >>>>>>>>>>>
    >>>>>>>>>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    >>>>>>>>>>> <HTML><HEAD>
    >>>>>>>>>>> <META http-equiv=3DContent-Type content=3D"text/html; =
    >>>>>>>>>>> charset=3Dwindows-1256">
    >>>>>>>>>>> <META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
    >>>>>>>>>>> <STYLE></STYLE>
    >>>>>>>>>>> </HEAD>
    >>>>>>>>>>> <BODY bgColor=3D#ffffff>
    >>>>>>>>>>> <DIV><FONT size=3D2>Oh man! </FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2>Thanks alot Nashat!!!</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2>You're the BOMB!!</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <BLOCKQUOTE=20
    >>>>>>>>>>> style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
    >>>>>>>>>>> BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    >>>>>>>>>>> <DIV>"Ahmed Nashat" &lt;<A=20
    >>>>>>>>>>> href=3D"mailto:"></A>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message <A=20
    >>>>>>>>>>> =
    >>>>>>>>>>> href=3D"news:%">news:%23Tlk66jjHHA.=
    >>>>>>>>>>> </A>...</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2>Julien,</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>You can =
    >>>>>>>>>>> usually find=20
    >>>>>>>>>>> this kind of information in RMS reports, for example, you can find the =
    >>>>>>>>>>>
    >>>>>>>>>>> movement types in "Items - Item Movement Report.qrp", you will find =
    >>>>>>>>>>> the=20
    >>>>>>>>>>> following string in the formula line of "Type" column, </FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE Type =
    >>>>>>>>>>> WHEN 1 THEN=20
    >>>>>>>>>>> 'PO/Inventory Transfer' WHEN 2 THEN 'Return to Off-Line' WHEN 3 THEN =
    >>>>>>>>>>> 'Transfer=20
    >>>>>>>>>>> Out' WHEN 4 THEN 'Main/Off-Line' WHEN 5 THEN 'Manual Adjustment' WHEN =
    >>>>>>>>>>> 6 THEN=20
    >>>>>>>>>>> 'Inventory Wizard' WHEN 7 THEN 'Physical Inventory Adjustment' WHEN 8 =
    >>>>>>>>>>> THEN 'HQ=20
    >>>>>>>>>>> Adjustment' WHEN 9 THEN 'Parent Child Adjustment' WHEN 10 THEN 'Kit =
    >>>>>>>>>>> Component=20
    >>>>>>>>>>> Transfer' WHEN 99 THEN 'Sales/Return' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 size=3D2>This is =
    >>>>>>>>>>> true too for=20
    >>>>>>>>>>> other unknow values like the PriceSource in TransactionEntry, you =
    >>>>>>>>>>> might know=20
    >>>>>>>>>>> its details in "Sales - Detailed Sales Report.qrp":-</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 size=3D2>"CASE=20
    >>>>>>>>>>> TransactionEntry.PriceSource WHEN 1 THEN 'Regular Price' WHEN 2 THEN =
    >>>>>>>>>>> (CASE=20
    >>>>>>>>>>> WHEN TransactionEntry.QuantityDiscountID &lt;&gt; 0 THEN=20
    >>>>>>>>>>> QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 THEN =
    >>>>>>>>>>>
    >>>>>>>>>>> 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN 'Sale =
    >>>>>>>>>>> Price'=20
    >>>>>>>>>>> WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from Cur. =
    >>>>>>>>>>> Price' WHEN 8=20
    >>>>>>>>>>> THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin Disc.' WHEN 10 =
    >>>>>>>>>>> THEN=20
    >>>>>>>>>>> 'Cashier Set' WHEN 11 THEN 'Component'&nbsp; WHEN 12 THEN 'Price Level =
    >>>>>>>>>>> A=20
    >>>>>>>>>>> Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN 'Price Level C=20
    >>>>>>>>>>> Disc.'&nbsp; WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN 'Disc. =
    >>>>>>>>>>> from=20
    >>>>>>>>>>> Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN 'Profit =
    >>>>>>>>>>> Margin=20
    >>>>>>>>>>> Disc.' ELSE 'Unknown' END"</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#ff0000 =
    >>>>>>>>>>> size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3D"Century Gothic" color=3D#800000 =
    >>>>>>>>>>> size=3D2>Nashat</FONT></DIV>
    >>>>>>>>>>> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    >>>>>>>>>>> <DIV><FONT face=3DArial size=3D2>"Julien Bonnier" &lt;</FONT><A=20
    >>>>>>>>>>> href=3D"mailto:"><FONT face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message </FONT><A =
    >>>>>>>>>>> href=3D"news:"><FONT=20
    >>>>>>>>>>> face=3DArial =
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT=20
    >>>>>>>>>>> face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> BTW where do=20
    >>>>>>>>>>> you get this type of informations ?<BR>&gt; <BR>&gt; Because I like to =
    >>>>>>>>>>> know=20
    >>>>>>>>>>> almost every fields of every tables<BR>&gt; Is-it documented on the =
    >>>>>>>>>>> microsoft=20
    >>>>>>>>>>> website?<BR>&gt; <BR>&gt; Thanks<BR>&gt; <BR>&gt; Julien<BR>&gt; =
    >>>>>>>>>>> <BR>&gt;=20
    >>>>>>>>>>> "MOH. OWN" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial =
    >>>>>>>>>>> size=3D2>&gt; wrote in=20
    >>>>>>>>>>> message <BR>&gt; </FONT><A=20
    >>>>>>>>>>> href=3D"news:"><FONT face=3DArial =
    >>>>>>>>>>>
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2>...<BR>&gt;&gt; Hi Julien<BR>&gt;&gt;<BR>&gt;&gt; On Invenory =
    >>>>>>>>>>>
    >>>>>>>>>>> Transferlog this which type you well find:<BR>&gt;&gt; 1-for Inventory =
    >>>>>>>>>>> history=20
    >>>>>>>>>>> (which item you issued /riceved/ po planner).<BR>&gt;&gt; 3-Sales=20
    >>>>>>>>>>> Item.<BR>&gt;&gt; 4-transfear Item to Offline inventory.<BR>&gt;&gt; =
    >>>>>>>>>>> 5-Manual=20
    >>>>>>>>>>> adjustmint for qty (If happen on store).<BR>&gt;&gt; 7-physical=20
    >>>>>>>>>>> Inventory.<BR>&gt;&gt; 8-HQ Adjustmint.<BR>&gt;&gt;<BR>&gt;&gt; I =
    >>>>>>>>>>> hoppe if=20
    >>>>>>>>>>> this help you<BR>&gt;&gt;<BR>&gt;&gt; Best =
    >>>>>>>>>>> Regards<BR>&gt;&gt;<BR>&gt;&gt; --=20
    >>>>>>>>>>> <BR>&gt;&gt; MOH.OWN<BR>&gt;&gt; THE BODY SHOP<BR>&gt;&gt; =
    >>>>>>>>>>> K.S.A<BR>&gt;&gt;=20
    >>>>>>>>>>> MOB:+966 =
    >>>>>>>>>>> 557266607<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt;=20
    >>>>>>>>>>> "Julien Bonnier" &lt;</FONT><A href=3D"mailto:"><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2></FONT></A><FONT face=3DArial size=3D2>&gt; =
    >>>>>>>>>>> wrote in=20
    >>>>>>>>>>> message <BR>&gt;&gt; </FONT><A=20
    >>>>>>>>>>> href=3D"news:"><FONT face=3DArial =
    >>>>>>>>>>>
    >>>>>>>>>>> size=3D2>news:</FONT></A><FONT =
    >>>>>>>>>>> face=3DArial=20
    >>>>>>>>>>> size=3D2>...<BR>&gt;&gt;&gt; Hello =
    >>>>>>>>>>> People!<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Where=20
    >>>>>>>>>>> can I get list that explains the Transfers=20
    >>>>>>>>>>> Type<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; These are the values I have in my =
    >>>>>>>>>>> HQ DB=20
    >>>>>>>>>>> 1,5,8<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; But I need the complete=20
    >>>>>>>>>>> list<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt; Thank=20
    >>>>>>>>>>> You<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;<BR>&gt;&gt;&gt;=20
    >>>>>>>>>>> Julien<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; <BR>&gt; =
    >>>>>>>>>>> <BR>&gt;</FONT>=20
    >>>>>>>>>>> </BLOCKQUOTE></BODY></HTML>
    >>>>>>>>>>>
    >>>>>>>>>>> ------=_NextPart_000_0020_01C79089.145F07C0--



    >>>>>>>>>>>> On Wednesday, May 09, 2007 3:33 PM Mar wrote:


    >>>>>>>>>>>> Moh,
    >>>>>>>>>>>>
    >>>>>>>>>>>> I'm really curious what table(s) are used to programmatically calculate
    >>>>>>>>>>>> headquarters OH qty for an item when a change is made at the store. As an
    >>>>>>>>>>>> example if I do an adjustment to an item at the store. When Headquarters
    >>>>>>>>>>>> server runs what table(s) are used to recalc the oh quantity for the item?
    >>>>>>>>>>>> Maybe the question should be where in headquarters would i set the record
    >>>>>>>>>>>> that tells Headquarters to recalc oh qty using this adjusted amount?
    >>>>>>>>>>>>
    >>>>>>>>>>>> Mark
    >>>>>>>>>>>>
    >>>>>>>>>>>> "MOH. OWN" wrote:



    >>>>>>>>>>>>> On Thursday, May 05, 2011 4:57 AM Lam Hoang wrote:


    >>>>>>>>>>>>> Hi,
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> I'm looking forward to hear from you soon.
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> Thanks and regards,
    >>>>>>>>>>>>>
    >>>>>>>>>>>>> Lam Hoang



    >>>>>>>>>>>>>> On Thursday, May 05, 2011 4:57 AM Lam Hoang wrote:


    >>>>>>>>>>>>>> Hi,
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>> I've currently used RMS and need to capture quantity in a selected date for report purpose. Can you send me this qry?
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>> I'm looking forward to hear from you soon.
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>> Thanks and regards,
    >>>>>>>>>>>>>>
    >>>>>>>>>>>>>> Lam Hoang
     
    Lam Hoang, May 5, 2011
    #13
  14. Julien Bonnier

    Chris Bailey Guest

    Julien, I would greatly appreciate it you could either post our send me the qry. Thanks, Chris
     
    Chris Bailey, Feb 28, 2014
    #14
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Michael
    Replies:
    19
    Views:
    642
  2. Michael
    Replies:
    1
    Views:
    321
    Keith
    Aug 3, 2003
  3. Bamboo Sticks in Gelly
    Replies:
    0
    Views:
    1,196
    Bamboo Sticks in Gelly
    Sep 5, 2005
  4. Vince

    Investment Type vs Savings Type Accounts

    Vince, May 21, 2008, in forum: Microsoft Money
    Replies:
    2
    Views:
    428
    Cal Learner-- MVP
    May 22, 2008
  5. Steve Curtis

    Different Receipts by either account type or payment type

    Steve Curtis, Sep 21, 2006, in forum: Microsoft Point Of Sale
    Replies:
    0
    Views:
    1,036
    Steve Curtis
    Sep 21, 2006
Loading...

Share This Page