物料主数据创建时间查询
小于 1 分钟
- 方案名称：物料主数据创建时间查询
- 使用说明：查询某个期间内创建或更新的物料主数据
SELECT T0.[ItemCode], T0.[ItemName], t0.CreateDate AS '创建日期', T0.[UpdateDate] AS '更新日期'
FROM OITM T0
WHERE T0.[UpdateDate] >= [%1]
OR t0.CreateDate >= [%1]
SELECT T0.[ItemCode], T0.[ItemName], t0.CreateDate AS '创建日期', T0.[UpdateDate] AS '更新日期'
FROM OITM T0
WHERE T0.[UpdateDate] >= [%1]
OR t0.CreateDate >= [%1]