| 1 |
purchaseOrderNumber |
Channel Order ID of the inward order (which is a b2b return) |
No |
abcd123 |
| 2 |
clientSku |
Client SKU ID or EAN inwarded as part of B2B returns |
No |
abcd123 |
| 3 |
skuDesc |
Description of the SKU inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
abcd123 |
| 4 |
hsnCode |
HSN ID of the SKU that is inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
abcd123 |
| 5 |
taxRule |
Tax rule of the SKU that is inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
abcd123 |
| 6 |
quantity |
Quantity inwarded |
No |
12 |
| 7 |
channelName |
Channel ID through which the B2B Return is placed |
No |
INTERNAL |
| 8 |
timeZone |
Timezone of the warehouse which received the B2B return |
No |
Asia/Kolkata |
| 9 |
returnOrderTime |
B2B Return Order Created Timestamp |
No |
2024-01-01 12:34:56 |
| 10 |
styleId |
Style ID of the SKU that is inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
abcd123 |
| 11 |
mrp |
MRP of the SKU that is inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
123 |
| 12 |
category |
Category of the SKU that is inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
abcd123 |
| 13 |
size |
Size of the SKU that is inwarded as part of B2B returns |
If not uploaded or configured in SKU Master in Increff’s system |
abcd123 |
| 14 |
returnOrderId |
Increff’s Unique Order ID of Inwards (which is B2B Return) |
No |
312 |
| 15 |
forwardChannelOrderId |
Channel order ID of the recent last outward transaction of the item that is received as B2B return |
No |
|
| (This can be null if the outwards cannot be traced back. However, those line items won't populate in the report if the corresponding outwards is not found. They are purposefully eliminated) |
abcd123 |
|
|
|
| 16 |
baseSellingPricePerUnit |
Selling price of a single piece of the SKU as per the invoice amount of the outwards. (without taxes) |
No |
|
| (This can be null if the outwards cannot be traced back. However, those line items won't populate in the report if the corresponding outwards is not found. They are purposefully eliminated) |
42 |
|
|
|
| 17 |
actualSellingPricePerUnit |
Total selling price of a single piece of the SKU as per the invoice amount of the outwards. (including the taxes) |
No |
|
| (This can be null if the outwards cannot be traced back. However, those line items won't populate in the report if the corresponding outwards is not found. They are purposefully eliminated) |
42 |
|
|
|
| 18 |
forwardOrderInvoiceId |
External invoice ID of the corresponding forward or outward order invoice |
Same as mentioned for column forwardChannelOrderId |
abcd123 |
| 19 |
forwardInvoiceDate |
External invoice |
|
|
| timestamp of the corresponding forward or outward order invoice |
Same as mentioned for column forwardChannelOrderId |
2024-01-01 12:34:56 |
|
|
| 20 |
returnFromStreet1 |
Street1 of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 21 |
returnFromStreet2 |
Street2 of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 22 |
returnFromStreet3 |
Street3 of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 23 |
returnFromCity |
City of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 24 |
returnFromState |
State of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 25 |
returnFromCountry |
Country of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 26 |
returnFromZip |
Zip or pin code of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 27 |
returnFromEmail |
Contact email of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 28 |
returnFromPhone |
Contact number of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 29 |
returnFromName |
Contact name of the warehouse which received the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 30 |
shippingAddressStreet1 |
Street1 of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 31 |
shippingAddressStreet2 |
Street2 of the entity or vendor or partner who sent back the goods asthe inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 32 |
shippingAddressStreet3 |
Street3 of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 33 |
shippingAddressCity |
City of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 34 |
shippingAddressState |
State of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 35 |
shippingAddressCountry |
Country of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 36 |
shippingAddressZip |
Zip or pin code of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 37 |
shippingAddressEmail |
Contact email of the entity or vendor or partner who sent back the goods asthe inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 38 |
shippingAddressPhone |
Contact number of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 39 |
shippingAddressName |
Contact name of the entity or vendor or partner who sent back the goods as the inward order (B2B return) |
If address is not fully configured in the Increff’s System |
abcd123 |
| 40 |
fromGstin |
GSTIN of the warehouse which received the B2B return |
No |
abcd123 |
| 41 |
toGstin |
GSTIN of the entity or vendor or partner who sent the B2B return |
No |
abcd123 |
| 42 |
fromParty |
Warehouse which received the inwards (B2B returns) |
No |
wms_abc |
| 43 |
toParty |
Increff’s unique partner ID of the partner or vendor or entity that sent the B2B return order to the warehouse |
No |
2 |
| 44 |
lineItemId |
Increff’s unique Invoice line item ID of the outwards (which is forward orders) |
No |
51 |
| 45 |
billingAddressStreet1 |
Street1 of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 46 |
billingAddressStreet2 |
Street2 of the entity or vendor or partner who sent back the goods asthe inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 47 |
billingAddressStreet3 |
Street3 of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 48 |
billingAddressCity |
City of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 49 |
billingAddressState |
State of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 50 |
billingAddressCountry |
Country of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 51 |
billingAddressZip |
Zip or pin code of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 52 |
billingAddressEmail |
Contact email of the entity or vendor or partner who sent back the goods asthe inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 53 |
billingAddressPhone |
Contact number of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |
| 54 |
billingAddressName |
Contact name of the entity or vendor or partner who sent back the goods as the inward order (B2B return) as per the billing address of the partner |
If address is not fully configured in the Increff’s System |
abcd123 |