Anyone know what are the meaning of this fields in item2hist table.
PTDIRCompletes
PTDIRhits
PTDQtyAdjd
PTDQtyDShpSls
PTDQtyIssd
PTDQtyrcvd
PTDQtysls
PTDQtyTrsfrln
PTDQtyTrsfrout
Anyone know what are the meaning of this fields in item2hist table.
PTDIRCompletes
PTDIRhits
PTDQtyAdjd
PTDQtyDShpSls
PTDQtyIssd
PTDQtyrcvd
PTDQtysls
PTDQtyTrsfrln
PTDQtyTrsfrout
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.
PTD = Period to Date
Qty = Quantitiy
Shp = Ship
Trsfr = Transfer
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148