Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Description Fields item2hist

Posted on by 55

Anyone know what are the meaning of this fields in item2hist table.

PTDIRCompletes

PTDIRhits

PTDQtyAdjd

PTDQtyDShpSls

PTDQtyIssd

PTDQtyrcvd

PTDQtysls

PTDQtyTrsfrln

PTDQtyTrsfrout

  • Suggested answer
    Apps Mexico Profile Picture
    Apps Mexico 1,090 on at
    RE: Description Fields item2hist

    You can look that on this file "C:\Archivos de programa\Microsoft Dynamics\SL\Applications\Help\Full_schema.chm"

    PTDIRCompletes

    Float

    Period To Date Inventory Replenishment Completes – NOT USED

    ARRAY(13) - Fiscal period sum of the number of non-cancelled lines that the Inventory ID/Site ID combination ships complete before the Promise Date on a customer Sales Order, Assembly Order, or Transfer Order.

    PTDIRHits

    Float

    Period To Date Inventory Replenishment Hits – NOT USED

    ARRAY(13) - Fiscal period sum of the number of non-cancelled lines that the Inventory ID/Site ID combination appears on a customer Sales Order, Assembly Order, or Transfer Order.

    PTDQtyAdjd

    FLOAT (8)

    Period To Date Quantity Adjusted

    ARRAY(13) - Sum of INTran.Qty where TranType = "AJ" (Adjustments) or "AC" (Cost Adjustments) or "PI" (Physical Inventory) for each period.

    PTDQtyDShpSls

    FLOAT (8)

    Period To Date Quantity Drop Ship Sales

    ARRAY(13) - Sum of INTran.Qty for drop-ship transactions.

    PTDQtyIssd

    FLOAT (8)

    Period To Date Quantity Issued

    ARRAY(13) - Sum of INTran.Qty where (TranType = "AS" and KitID <> "") (Component Assemblies ) or TranType = "II" (Issues) for each period.

    PTDQtyRcvd

    FLOAT (8)

    Period To Date Quantity Received

    ARRAY(13) - Sum of INTran.Qty where TranType = "RC (Receipts) or (TranType = "AS" And KitID = "") (Kit Assemblies) for each period.

    PTDQtySls

    FLOAT (8)

    Period To Date Quantity Sales

    ARRAY(13) - Sum of INTran.Qty * -1 if TranType = "CM" (Credit Memo) or Sum INTran.Qty if TranType = "DM" (Debit Memo) or "IN" (Invoice) for each period. These values are positive for Debit Memos and negative for Credit Memos. CM's and DM's are only updated if the INTran.NoQtyUpdate is false (stock items).

    PTDQtyTrsfrIn

    FLOAT (8)

    Period To Date Quantity Transfer In

    ARRAY(13) - Sum of INTran.Qty where TranType = "TR" and ToSiteID = "" (Transferred In) for each period.

    PTDQtyTrsfrOut

    FLOAT (8)

    Period To Date Quantity Transfer Out

    ARRAY(13) - Sum of INTran.Qty where TranType = "TR" and ToSiteID <> "" (Transferred Out) for each period.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Description Fields item2hist

    PTD = Period to Date

    Qty = Quantitiy

    Shp = Ship

    Trsfr = Transfer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans