| Główna klasa nabycia |
Item.Purchasing Major Class |
| Podrzędna klasa nabycia |
Item.Purchasing Minor Class |
| Numer pozycji |
Item.Item |
| Opis pozycji |
Item. ItemDescription |
| Jednostka miary zapasów |
Item.StockUOM |
| Ilość |
Measures.ICT Quantity |
| Użycie w ciągu 3 dni (obliczenia raportu) |
LOOKUPVALUE(0, [Item.ItemKey], 1, SELECT [Item.ItemKey], [Transaction Date: Avg: ICT Quantity], [Time.Date] FROM [All] WHERE ([ITL Attributes.Document Type] = 'InventoryIssue') AND ([Company.Company] = GETPROMPTVALUE('Company.Company')) AND ([Item.Purchasing Major Class] = GETPROMPTVALUE('Item.Purchasing Major Class')) AND ([Item.Purchasing Minor Class] = GETPROMPTVALUE('Item.Purchasing Minor Class')) AND ([Item.ItemKey] = GETPROMPTVALUE('IOH Attributes.ItemKey')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Critical Item')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Personal Protective Equipment')) AND ([Time.Date] <= DATETIME(GETPROMPTVALUE('Time.Date'))) AND ([Time.Date] >= DateAdd(Day,-3,DATETIME(GETPROMPTVALUE('Time.Date'))))
|
| Użycie w ciągu 3 ostatnich dni (obliczenia raportu) |
LOOKUPVALUE(0, [Item.ItemKey], 1, SELECT [Item.ItemKey], [Transaction Date: Avg: ICT Quantity], [Time.Date] FROM [All] WHERE ([ITL Attributes.Document Type] = 'InventoryIssue') AND ([Company.Company] = GETPROMPTVALUE('Company.Company')) AND ([Item.Purchasing Major Class] = GETPROMPTVALUE('Item.Purchasing Major Class')) AND ([Item.Purchasing Minor Class] = GETPROMPTVALUE('Item.Purchasing Minor Class')) AND ([Item.ItemKey] = GETPROMPTVALUE('IOH Attributes.ItemKey')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Critical Item')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Personal Protective Equipment')) AND ([Time.Date] <= DateAdd(Day,-3,DATETIME(GETPROMPTVALUE('Time.Date')))) AND ([Time.Date] >= DateAdd(Day,-6,DATETIME(GETPROMPTVALUE('Time.Date')))) )
|
| Średnie użycie w ciągu 30 dni (obliczenia raportu) |
LOOKUPVALUE(0, [Item.ItemKey], 1, SELECT [Item.ItemKey], [Transaction Date: Avg: ICT Quantity], [Time.Date] FROM [All] WHERE ([ITL Attributes.Document Type] = 'InventoryIssue') AND ([Company.Company] = GETPROMPTVALUE('Company.Company')) AND ([Item.Purchasing Major Class] = GETPROMPTVALUE('Item.Purchasing Major Class')) AND ([Item.Purchasing Minor Class] = GETPROMPTVALUE('Item.Purchasing Minor Class')) AND ([Item.ItemKey] = GETPROMPTVALUE('IOH Attributes.ItemKey')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Critical Item')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Personal Protective Equipment')) AND ([Time.Date] <= DATETIME(GETPROMPTVALUE('Time.Date'))) AND ([Time.Date] >= DateAdd(Day,-30,DATETIME(GETPROMPTVALUE('Time.Date')))) )
|
| Szacowana liczba dni w magazynie (obliczenia raportu) |
[Transaction Date: Sum: ICT After Quantity] / LOOKUPVALUE(0, [Item.ItemKey], 1, SELECT [Item.ItemKey], ABS([Transaction Date: Avg: ICT Quantity]) FROM [All] WHERE ([ITL Attributes.Document Type] = 'InventoryIssue') AND ([Company.Company] = GETPROMPTVALUE('Company.Company')) AND ([Inventory Location.InventoryLocationKey] = GETPROMPTVALUE('Inventory Location.InventoryLocationKey')) AND ([Item.Purchasing Major Class] = GETPROMPTVALUE('Item.Purchasing Major Class')) AND ([Item.Purchasing Minor Class] = GETPROMPTVALUE('Item.Purchasing Minor Class')) AND ([Item.ItemKey] = GETPROMPTVALUE('IOH Attributes.ItemKey')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Critical Item')) AND ([Item.Critical Item] = GETPROMPTVALUE('Item.Personal Protective Equipment')) AND ([Time.Date] <= DATETIME(GETPROMPTVALUE('Time.Date'))) AND ([Time.Date] >= DateAdd(Day,-3,DATETIME(GETPROMPTVALUE('Time.Date')))) )
|