This entity links discount records to client relationships. The attached contains the required format for the IDiscountRelationship.CSV with a sample record.


The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.

Fields

Field Name 

Required 

Type 

Description 

DiscountID 

Y 

nvarchar(MAX) 

Value of Idiscount.key 

RelationshipID 

Y 

nvarchar(MAX) 

Value of Iclient.Key 

RelationshipType 

Y 

nvarchar(4000) 

Defaults to Client 

[Key] 

 

nvarchar(4000) 

Unique record ID  

PmsID 

 

nvarchar(MAX) 

Unique record ID -can be the same as the [Key]  


Sample File