Navigate To:

1 Description
2 Fields
3 Filters

Description

Provides invoiced B2C Outward Orders with tax information, Customer details, life-cycle timestamps(creation, packed, SLA, manifest etc) for SFS orders.

Fields

	Fields	Description	This column can be null	Sample Data

	Fields	Description	This column can be null	Sample Data
1	Fulfillment Location Name	Name of the fulfilment location	NA	wms_sfast
2	Fulfilment Location City	City of the fulfilment location	NA	BANGALORE
3	Channel Order ID	Order ID from Channel	NA	DFZB3V1v7
4	System Order ID	Increff’s unique Order ID	NA	24041298
5	System Sub Order ID	Increff’s Unique Sub Order ID	NA	22975618
6	Channel Parent Order ID	Parent Order ID from the Channel	NA	406-4063010-1309931
7	Order QC Status	QC status of the order	NA	PASS
8	Channel Invoice No	ID of the invoice created by channel	NA	IN-26338
9	System Invoice No	Increff’s Invoice ID	NA	20483435
10	System Invoice Line Item ID	Increff’s Invoice Line Item ID	NA	49704894
11	Channel Invoice Time	Invoice Created Timestamp	NA	01/07/23 0:00
12	Sales Channel	Channel through which order is placed	NA	AMAZON_SC_ES
13	Client SKU ID / EAN	Client SKU ID	NA	4.06545E+12
14	SKU Description	Description of the SKU	NA	Quarter Socks 3P
15	Style	Style ID of the SKU		93371801
16	Brand	Brand of the SKU		PUMA
17	Size	Size of the item		39/42
18	Color	Color of the SKU		Black/ Forest Night/ Navy
19	Category	Category of the SKU		Accessories
20	MRP	MRP of the SKU		599
21	SO Quantity	Sales Order Quantity	NA	1
22	Dispatched Quantity	Quantity of items dispatched		1
23	Payment Type	Customer’s payment type while placing order		NCOD
24	Unit Sale Price	Selling Price per unit (Base plus Tax)		389
25	Unit Base Price	Base price per unit		347.32
26	Unit Tax	Tax per unit		41.68
27	Total Base Price	Base Price per unit multiplied by quantity		347.32
28	Total Tax	Tax value per unit multiplied by quantity		41.68
29	Total Sale Price	Actual Selling Price per unit multiplied by quantity		389
30	Discount	Total Discount at Order SKU level		0
31	IGST Rate	IGST Tax Rate		12
32	CGST Rate	CGST Tax Rate
33	SGST Rate	SGST Tax Rate
34	HSN Code	HSN Code of the SKU		61159500
35	Customer TIN	GST No. of customer		NA
36	Outward AWB No	Outward tracking number		3.24849E+11
37	Transporter	Transporter of shipment		ATS
38	Customer Name	Name of customer		John Doe
39	Customer E-Mail	Email ID of customer
40	Customer Contact Number	Contact number of customer
41	Customer City	City of the Customer
42	Customer State	State of the Customer		KARNATAKA
43	Customer Pin	Shipping Pin Code of the Customer		854318
44	Customer Billing Pin	Billing Pin Code of the Customer		854318
45	Order Status	Status of the order		COMPLETED
46	System Manifest ID	Increff’s Manifest ID		676352
47	Picklist ID	Increff’s picklist ID		37495
48	System Order Time	Time when Order was created in the Increff System		29/06/23 8:23
49	Channel Order Time	Time when Order was placed in the Channel		29/06/23 8:22
50	SLA Time	Timestamp of SLA required by		01/07/23 23:59
51	Packed Time	Timestamp of SKU packed		30/06/23 23:59
52	Manifest Time	Timestamp of shipment manifest		01/07/23 13:06
53	Handover Time	Timestamp of shipment handover		01/07/23 13:24
54	Manifested within 24 hours	If manifest is closed in 24 hours from order creation or not	NA	NO
55	SLA Breached	Whether order has breached SLA or not	NA	NO
56	Order Remarks	Remarks of order	yes

Filters

	Filters	Description	Limitation

	Filters	Description	Limitation
1	Client	Name of the client	Mandatory
2	SFS Locations	Name of the fulfilment locations	Mandatory
3	Sales Channel	Name of the Sales Channel	NA
4	Invoice Created From	Invoice created from the date	Maximum date range : 31
5	Invoice Created To	Invoice created till the date	Maximum date range : 31
6	Order Created From	Order created from the date	Maximum date range : 1
7	Order Created To	Order created till the date	Maximum date range : 1
8	Channel Order ID	Order ID by channel	NA

Omni Public

SFS : B2C Outward Sku Wise Report - OMS

Navigate To:

Description

Fields

Filters