Copy of Various SFCC Order related fields

Field name	Calculation Logic	Related sfcc logic

Field name	Calculation Logic	Related sfcc logic
`isCod`	if `paymentMethodId` is `COD`	`paymentMethodId`
`totalCredits`	summation of all the `CREDIT amount`
`totalAmt`	summation of all the COD `amount`
`totalCODFee`	summation of `OrderPriceAdjustment` when `promotionId` equals to `codFee`	`OrderPriceAdjustment`.price
`requiredByTime`	currentTime + standard sla days ( with time as `18:00:00`
`isOnHold`	if it is an exchange order then yes, else no	`isExchange`
`shippingCharge`	order’s `shippingTotal` - summation of `extraCustomisationPrice` for every item.	`shippingTotal` `extraCustomisationPrice`
`totalBasePrice`	summation of `base_price` * `quantity` for each item	`base_price`, `quantity`
`isGiftOrder`	if `gift` is true for any of the item , then that suborder is being treated as giftOrder	`gift`
`perItemDiscount`	summation of `order_price_adjustments` .`price` with an exception of ( `promotionId` equals `“Personalized_Jersey_Charge"` ) divides by total no. of items	`order_price_adjustments`
`giftCharge`	item.`c_myCustomizationCost` / item.`quantity`	`c_myCustomizationCost`
`codFeeShare` per subOrder	`((item.base_price * item.quantity) / totalBasePrice) * totalCODFee`
`sellingPrice`(item level)	if (`isGiftOrder`) item.`price_after_item_discount` - `CODFeeShare` / item.`quantity` -`perItemDiscount` else item.`price_after_item_discount` - `CODFeeShare` / item.`quantity`	`price_after_item_discount`
`orderDiscount`	(item.`price` - item.`price_after_item_discount`) / item.`quantity`
`itemDiscount`	if(`isGiftOrder`) `perItemDiscount + (CODFeeShare / item.quantity)` else `item.price_after_item_discount - item.price_after_order_discount` +`(CODFeeShare / item.quantity)`