Inventory Audit Report

The inventory audit report object stores information about the reports generated by Oracle CRM On Demand when a sales representative chooses to create a new interim or final audit count for an inventory period.

Support for Attachments

You can exchange attachments through the following fields:

UI Display Name	Integration Tag Name
Attachment	AttachFileFullName
Attachment: Extension	AttachFileExt
Attachment: File Name	AttachFileName
Attachment: Size (in Bytes)	AttachFileSizeDisp

The Attachment tag is used for the actual attachment and is a string type Base64.

Child Objects

Audit Trail, Book, Sample Inventory

Methods Called

The following table details the methods called by the Inventory Audit Report service.

Table Methods Called by Inventory Audit Report Service

Method	Name as Defined in Service
Delete	InventoryAuditReportDelete
Execute	InventoryAuditReportExecute
Insert	InventoryAuditReportInsert
QueryPage	InventoryPeriodQueryPage
Update	InventoryPeriodUpdate

Fields

The following table details the required and read-only fields for the inventory audit report object.

Table Required and Read-Only Fields for the Inventory Audit Report Object

Field Name	Type
Type	Required
Status	Required
Reason	Required
CountCompletedOn	Required
InventoryPeriodStartDate	Required
OwnerUserSignId	Required
Audit Fields	Read-only

The following table details the pick map fields for the inventory audit report object.

Table Pick Map Field for the Inventory Audit Report Object

Pick Map Field	Maps To
InventoryPeriodExternalSystemId	InventoryPeriodId
InventoryPeriodIdIntegrationId	InventoryPeriodId
OwnerUserSignId	OwnerId
OwnerExternalSystemId	OwnerId
OwnerIntegrationId	OwnerId

The following table provides a list of the user key combinations for the inventory audit report object.

Table User Key Fields on the Inventory Audit Report Object

User Key Field Combinations
Id
ExternalSystemId
InventoryPeriodId and OwnerId and CountCompletedOn
Type

The following table details the picklists available for the inventory audit report object.

Table Picklists Available for the Inventory Audit Report Object

Field Name
Type
Status
Reason