Dynamics Community Forum Thread Details

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.

Quick Links

Leaderboard