CustomerApi Odata Help Page

Customer - PurchaseDetail

PurchaseDetail entities

Required HTTP Headers

X-Crm360Api-Token
X-Crm360Api-CustomerName
X-Crm360Api-DatabaseAlias

Functions

Create
Read
Update
Delete

Entity Properties

Name	Type	Is Mandatory
PurchaseDetailId	Int32
PurchaseHeaderId	Int32
PurchaseGoodId	Int32
Amount	Decimal
TaxFreeAmount	Decimal
DiscountAmount	Decimal
DiscountTypeId	Int16
RefAmount	Decimal
RefTaxFreeAmount	Decimal
RefDiscountAmount	Decimal
Quantity	Int16
SKU	String
FreeField1	String
FreeField2	String
FreeField3	String
FreeField4	String
FreeField5	String
FreeFieldDateTime1	DateTime
FreeFieldDateTime2	DateTime
FreeFieldDateTime3	DateTime
FreeFieldDateTime4	DateTime
FreeFieldDateTime5	DateTime
FreeFieldNumber1	Decimal
FreeFieldNumber2	Decimal
FreeFieldNumber3	Decimal
FreeFieldNumber4	Decimal
FreeFieldNumber5	Decimal
FreeFieldBoolean1	Boolean
FreeFieldBoolean2	Boolean
FreeFieldBoolean3	Boolean
FreeFieldBoolean4	Boolean
FreeFieldBoolean5	Boolean
DeletionFlag	Boolean
PurchaseDate	DateTime
PurchaseDetailIdentifier	String
SourceId	Int16
PurchaseHeader	PurchaseHeader
PurchaseGood	PurchaseGood
DiscountType	DiscountType
Source	Source

Examples

Select all PurchaseDetails
https://customerapi.fts-crm360.com/data/PurchaseDetails()
HttpMethod : GET                                                                                       
Json Result : 

[
{
"PurchaseDetailId" : "58",
"PurchaseHeaderId" : "46",
"PurchaseGoodId" : "88",
"Amount" : "5184988.433",
"TaxFreeAmount" : "6486113.758",
"DiscountAmount" : "1553342.318",
"DiscountTypeId" : "2",
"RefAmount" : "6414679.382",
"RefTaxFreeAmount" : "6618757.296",
"RefDiscountAmount" : "4178955.157",
"Quantity" : "5",
"SKU" : "gG6EuOZWVf",
"FreeField1" : "qd7bck8YGBHxnqO",
"FreeField2" : "HIyvJkMB 4o",
"FreeField3" : "hvlT6U V EEghTa",
"FreeField4" : "ZUS f RNhv",
"FreeField5" : "FR5cj6P0Wb 1T",
"FreeFieldDateTime1" : "2014-08-03T00:00:00",
"FreeFieldDateTime2" : "2021-05-17T00:00:00",
"FreeFieldDateTime3" : "2007-02-20T00:00:00",
"FreeFieldDateTime4" : "1996-06-26T00:00:00",
"FreeFieldDateTime5" : "1996-11-26T00:00:00",
"FreeFieldNumber1" : "3282866.632",
"FreeFieldNumber2" : "7547279.116",
"FreeFieldNumber3" : "5635196.597",
"FreeFieldNumber4" : "6432357.943",
"FreeFieldNumber5" : "8971281.175",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PurchaseDate" : "2022-04-11T00:00:00",
"PurchaseDetailIdentifier" : "D7DMndlTPO",
"SourceId" : "5"
},
{
"PurchaseDetailId" : "65",
"PurchaseHeaderId" : "6",
"PurchaseGoodId" : "97",
"Amount" : "6886834.285",
"TaxFreeAmount" : "8497186.663",
"DiscountAmount" : "8526334.868",
"DiscountTypeId" : "6",
"RefAmount" : "1582569.871",
"RefTaxFreeAmount" : "8164258.356",
"RefDiscountAmount" : "9171263.368",
"Quantity" : "5",
"SKU" : "A6v6MhlMmx5S",
"FreeField1" : "nKHulkJLq",
"FreeField2" : "qD1WvJ1fQDoqQRSn",
"FreeField3" : "GHaFw D",
"FreeField4" : "4N6b0P",
"FreeField5" : "Jhcv12nCxuT9f2cS",
"FreeFieldDateTime1" : "2023-03-17T00:00:00",
"FreeFieldDateTime2" : "2021-07-17T00:00:00",
"FreeFieldDateTime3" : "2000-06-18T00:00:00",
"FreeFieldDateTime4" : "2011-10-14T00:00:00",
"FreeFieldDateTime5" : "2020-02-24T00:00:00",
"FreeFieldNumber1" : "4638363.668",
"FreeFieldNumber2" : "3491788.425",
"FreeFieldNumber3" : "1645163.599",
"FreeFieldNumber4" : "5679892.963",
"FreeFieldNumber5" : "4429166.775",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "True",
"PurchaseDate" : "2000-12-20T00:00:00",
"PurchaseDetailIdentifier" : "ztZzslRktARxq9 4F",
"SourceId" : "6"
},
...
]

Select PurchaseDetail by Id
https://customerapi.fts-crm360.com/data/PurchaseDetails(58)
HttpMethod : GET                                                                                       
Json Result : 

{
"PurchaseDetailId" : "43",
"PurchaseHeaderId" : "46",
"PurchaseGoodId" : "37",
"Amount" : "5957591.662",
"TaxFreeAmount" : "2731886.766",
"DiscountAmount" : "5865981.729",
"DiscountTypeId" : "2",
"RefAmount" : "3754791.373",
"RefTaxFreeAmount" : "9292148.915",
"RefDiscountAmount" : "9888649.878",
"Quantity" : "4",
"SKU" : "k 1 yuF3fe5",
"FreeField1" : "fspV3ZNtDc",
"FreeField2" : "c5mwU9Q",
"FreeField3" : "56hi5TAkI2LA",
"FreeField4" : "3cX3wm5SjmZ",
"FreeField5" : "zYFL8x",
"FreeFieldDateTime1" : "2021-09-08T00:00:00",
"FreeFieldDateTime2" : "2002-01-01T00:00:00",
"FreeFieldDateTime3" : "2023-03-13T00:00:00",
"FreeFieldDateTime4" : "1995-04-27T00:00:00",
"FreeFieldDateTime5" : "2007-12-12T00:00:00",
"FreeFieldNumber1" : "9271881.884",
"FreeFieldNumber2" : "7653964.434",
"FreeFieldNumber3" : "3241994.213",
"FreeFieldNumber4" : "8581471.615",
"FreeFieldNumber5" : "5857186.912",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "False",
"PurchaseDate" : "2015-11-30T00:00:00",
"PurchaseDetailIdentifier" : "H7a3vkoNsa1Jgx",
"SourceId" : "3"
}

Create a PurchaseDetail
https://customerapi.fts-crm360.com/data/PurchaseDetails()
HttpMethod : POST                                                                                                
Json Post :
{
"PurchaseHeaderId" : "75",
"PurchaseGoodId" : "86",
"Amount" : "5671135.287",
"TaxFreeAmount" : "9728614.511",
"DiscountAmount" : "6191812.197",
"DiscountTypeId" : "7",
"RefAmount" : "6986396.169",
"RefTaxFreeAmount" : "7887555.322",
"RefDiscountAmount" : "4273577.291",
"Quantity" : "4",
"SKU" : "K8Tx QVC",
"FreeField1" : "abE1IES mpxwjaYR",
"FreeField2" : "GiPdAjkhs3bqE",
"FreeField3" : "8EV4vmZVk",
"FreeField4" : "tYalblg5f1J",
"FreeField5" : "yT 3fTbM0uhY rOg",
"FreeFieldDateTime1" : "2013-11-30T00:00:00",
"FreeFieldDateTime2" : "2014-04-11T00:00:00",
"FreeFieldDateTime3" : "1999-05-01T00:00:00",
"FreeFieldDateTime4" : "2017-06-21T00:00:00",
"FreeFieldDateTime5" : "2023-08-04T00:00:00",
"FreeFieldNumber1" : "8762911.452",
"FreeFieldNumber2" : "2223158.219",
"FreeFieldNumber3" : "4698187.493",
"FreeFieldNumber4" : "8748957.752",
"FreeFieldNumber5" : "4836336.421",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "False",
"PurchaseDate" : "2017-08-17T00:00:00",
"PurchaseDetailIdentifier" : "ELVuWQUfuYUdtFk3i",
"SourceId" : "5"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Update a PurchaseDetail
https://customerapi.fts-crm360.com/data/PurchaseDetails(58)
HttpMethod : PUT                                                                                                
Json Post :
{
"PurchaseDetailId" : "27",
"PurchaseHeaderId" : "42",
"PurchaseGoodId" : "52",
"Amount" : "8242953.652",
"TaxFreeAmount" : "7797486.513",
"DiscountAmount" : "8531737.923",
"DiscountTypeId" : "1",
"RefAmount" : "9433196.481",
"RefTaxFreeAmount" : "8226774.319",
"RefDiscountAmount" : "1327383.468",
"Quantity" : "4",
"SKU" : "NItaqXR2BEPN",
"FreeField1" : "VEa iPsHW vKkBKrHv",
"FreeField2" : "V9A5REC9J58 9u5",
"FreeField3" : "1aFioX2I8PFVGL4V",
"FreeField4" : "hnWDgtdL",
"FreeField5" : "9aBwL1GX roaB8F",
"FreeFieldDateTime1" : "2020-11-26T00:00:00",
"FreeFieldDateTime2" : "2023-01-04T00:00:00",
"FreeFieldDateTime3" : "1995-10-11T00:00:00",
"FreeFieldDateTime4" : "2023-10-13T00:00:00",
"FreeFieldDateTime5" : "2016-04-21T00:00:00",
"FreeFieldNumber1" : "8916741.674",
"FreeFieldNumber2" : "7649441.213",
"FreeFieldNumber3" : "2742785.632",
"FreeFieldNumber4" : "6755814.417",
"FreeFieldNumber5" : "7665911.266",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PurchaseDate" : "2012-10-19T00:00:00",
"PurchaseDetailIdentifier" : "656bTiw G5BYBqKSe",
"SourceId" : "6"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Patch a PurchaseDetail
https://customerapi.fts-crm360.com/data/PurchaseDetails(93)
HttpMethod : PATCH                                                                                                
Json Post :
{
"DiscountTypeId" : "1",
"Amount" : "8267416.487",
"DeletionFlag" : "False",
"FreeField1" : "vZleG SOEt95JELnFjq",
"FreeFieldBoolean3" : "True",
"FreeFieldDateTime5" : "2020-02-10T00:00:00",
"PurchaseDate" : "1995-10-30T00:00:00",
"FreeFieldBoolean2" : "True",
"FreeFieldNumber3" : "6325472.934",
"RefAmount" : "9394215.241",
"FreeFieldBoolean1" : "True",
"SKU" : "vlS47SOD",
"FreeFieldBoolean5" : "False",
"FreeFieldDateTime4" : "1997-07-31T00:00:00",
"FreeFieldNumber4" : "7613939.597",
"Quantity" : "7"
}
            
Informations : 
 - Non mandatory fields are optional for Json Post

Delete a PurchaseDetail
https://customerapi.fts-crm360.com/data/PurchaseDetails(93)
HttpMethod : DELETE