web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Description Fields item2hist

(0) ShareShare
ReportReport
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

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    PTD = Period to Date

    Qty = Quantitiy

    Shp = Ship

    Trsfr = Transfer

  • Suggested answer
    Apps Mexico Profile Picture
    1,090 on at

    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans