| Code emplacement stockage |
Inventory Location.Inventory Location Code |
| Classe d'achat principale |
Item.Purchasing Major Class |
| Classe d'achat secondaire. |
Item.Purchasing Minor Class |
| No article |
Item.Item |
| Description article |
Item.ItemDescription |
| Date |
Time.Date |
| Site demandeur |
Transaction Attributes.Requesting Location |
| UDM stock |
Item.StockUOM |
| Quantité |
Measures.ICT Quantity |
| Utilisation sur trois jours (calcul rapport) |
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'))))
|
| Utilisation trois jours précédents (calcul rapport) |
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')))) )
|
| Utilisation moyenne sur 30 jours (calcul rapport) |
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')))) )
|
| Transaction stocks |
Transaction Attributes.Inventory Transaction
|
| Filtres intégrés dans le rapport |
|
|
Company.Company |