| 主要采购类 |
Item.Purchasing Major Class |
| 次要采购类 |
Item.Purchasing Minor Class |
| 项目编号 |
Item.Item |
| 项目描述 |
Item. ItemDescription |
| 存货计量单位 |
Item.StockUOM |
| 数量 |
Measures.ICT Quantity |
| 过去 3 天使用量（报告计算） |
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'))))
|
| 之前的 3 天使用率（报告计算） |
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')))) )
|
| 30 天平均使用率（报告计算） |
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 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')))) )
|