大家好，
系统字段如 CreatedBy、CreatedDateTime、ModifiedBy 和 ModifiedDateTime 会出现在 D365FO 实体的元数据中，但它们不会出现在导出或 OData 中。这是因为系统字段不会通过预备表自动暴露。
为了让它们可用，创建不同名称的包装字段——如 CreatedBy1、CreatedDateTime1、ModifiedBy1 和 ModifiedDateTime1——并映射到系统字段。
步骤
– 将新字段添加到预设表或其扩展中。
– 将它们添加到数据实体中，并对应到对应的系统字段。
– 构建并同步项目。
– 通过 OData 导出或呼叫实体以确认字段是否出现。
这种简单的方法确保审计字段可用于集成、导出和报告。
——哈利
：关注我们的Facebook，保持我们的节奏。https:fb.com/theaxapta
Hi Folks,
System fields like CreatedBy, CreatedDateTime, ModifiedBy, and ModifiedDateTime appear in a D365FO entity’s metadata, but they don’t show up in exports or OData. This happens because system fields aren’t automatically exposed through the staging table.
To make them available, create wrapper fields with different names—such as CreatedBy1, CreatedDateTime1, ModifiedBy1, and ModifiedDateTime1—and map them to the system fields.
Steps
– Add the new fields to the staging table or its extension.
– Add them to the data entity and map each one to the corresponding system field.
– Build and synchronize the project.
– Export or call the entity via OData to confirm the fields appear.
This simple approach ensures audit fields are available for integrations, exports, and reporting.
-Harry
Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta
转载请注明：ww12345678 的部落格 | AX Helper » 值得了解：在数据实体中添加系统字段WorthKnowing: Adding system fields in data entity