| Codice ubicazione scorte |
Inventory Location.Inventory Location Code |
| Classe di acquisto principale |
Item.Purchasing Major Class |
| Classe di acquisto secondaria |
Item.Purchasing Minor Class |
| Numero articolo |
Item.Item |
| Descrizione articolo |
Item.ItemDescription |
| Data |
Time.Date |
| Ubicazione richiedente |
Transaction Attributes.Requesting Location |
| UdM scorte |
Item.StockUOM |
| Quantità |
Measures.ICT Quantity |
| Utilizzo in 3 giorni (calcolo report) |
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'))))
|
| Utilizzo ultimi 3 giorni (calcolo report) |
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')))) )
|
| Utilizzo medio in 30 giorni (calcolo report) |
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')))) )
|
| Transazione scorte |
Transaction Attributes.Inventory Transaction
|
| Filtri creati nel report |
|
|
Company.Company |