Specifies whether primary key columns are treated as normal columns, meaning records with identical PK values are not discarded.

Data Type

bool

Default Value

false

Remarks

When the ApiVersion connection property is set to V2 and the Service connection property is set to "BaqSvc", the Epicor Kinetic API may return records that share an identical value in the primary key column, but have different values in the other columns.

If this connection property is left to its default value of False, such records are dropped despite the unique values in the non-PK columns.

When this property is set to True, the driver treats primary key columns like normal columns, ensuring that all records are returned and none are discarded as duplicates.

Note: Disabling primary keys limits the driver's ability to uniquely identify rows. As a result, UPDATE and DELETE statements may not be supported, and INSERT operations may produce unexpected results depending on the target table and application behavior.