Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Fields

Description

This column can be null

Sample Data

1

Client Name

Name of the client

NA

Increff

2

Fulfilment Location Name

Name of fulfilment location

NA

wms_hosur

3

Fulfilment Location ID

Increff’s unique ID of a fulfilment location

NA

1231212312

4

Sales Channel

Channel through which order is placed

NA

FLIPKARTV3

5

Channel Order No

Order ID by channel

 NA

aB12Pq34

6

Channel Parent Order ID

Parent Order ID from the Channel

 

 abcd123

7

System Order ID

Increff’s unique Order ID

NA

1231212312

8

System Sub Order ID

Increff’s Unique Sub Order ID

NA

12

9

Order Type

Type of order

NA

SALES

10

Gift

Is it gift or not

NA

TRUE or FALSE

11

Party

Partner’s name

NA

abcd

12

Partner ID

Partner’s ID

NA

124231

13

Reservation Pool

Reservation Pool Name

abcd123

14

Status

Status of Order

NA

PICKING

15

Order QC Status

QC Status of the Sub Order

NA

  1. PASS

  2. FAIL

16

Final Resolution

Order Resolution

CUSTOMER_CANCELLED

1617

On Hold

If order is on hold or not

NA

TRUE or FALSE

1718

Priority

Is on priority or not

NA

TRUE or FALSE

1819

Future Picklist Express Orders

If order is in CREATED, UNFULFILLABLE, FULFILLABLE and

If order is Express or Not

TRUE or FALSE

1920

Channel Order Time

Order received Timestamp by Channel

NA

2023-01-01 12:34:56

2021

Channel Order Status

Status of order w.r.t. channel

NA

CREATED

2122

System Order Time

OMS Order Creation Timestamp

NA

2023-01-01 12:34:56

2223

Last Status Updated Time

OMS Order Status Last Updated Timestamp

NA

2023-01-01 12:34:56

2324

Warehouse Order Creation Time

WMS Order Creation Timestamp

NA

2023-01-01 12:34:56

2425

SLA Time

SLA Required By Timestamp

 

2023-01-03 12:34:56

2526

Order Release Time

Start Processing Timestamp

2023-01-03 12:34:56

2627

Invoice Time

Channel Invoice’s timestampNA

If it is a bulk order

2023-01-01 12:34:56

2728

Manifest Created Time

Timestamp of Manifest CreatedNA

If it is a bulk order

2023-01-01 12:34:56

2829

Manifest Closed Time

Timestamp of Manifest ClosedNA

If it is a bulk order

2023-01-01 12:34:56

2930

Handover Time

Timestamp of shipment handover 

If it is a bulk order

2023-01-01 12:34:56

3031

Delivered Time

 Shipment Delivered Timestamp 

If it is a bulk order

2023-01-01 12:34:56

3132

Order And Manifest Time Difference in Hours

Time taken from orders created to manifest closed in hours

7

3233

Manifested within 24 Hours

If manifest is closed in 24 hours from order creation or not

If manifest is not yet closed

YES or NO

3334

SLA Breach

Whether order has breached SLA or not

NA

YES or NO

3435

Order Qty

Ordered Quantity

NA

3

3536

Cancelled Qty

Cancelled Qty

1

3637

Reserve Qty

Allocated Quantity for an order

2

3738

Processing Qty

Quantity currently being processed.

When Marketplace perspective is selected or order is still not moved to processing stage.

1

3839

Picked Qty

Total Quantity in Picked Status

When Marketplace perspective is selected

1

3940

Dispatched / Packed Qty

Total quantity Fulfilled

When no qty is fulfilled

0

4041

Pending Qty

Quantity pending to be Fulfilled

1

4142

Unfulfillable Qty

Unfulfillable Qty

0

4243

Pick List Created Qty

Total Quantity for which Picklist is in created status.

In case of Market Place Perspective

1

4344

Pick List Not Released Qty

Total Quantity for which Picklist for which picklist is not created.

In case of Market Place Perspective

1

4445

Invoice Pending Quantity

Total Quantity for which Invoicing is pending.

In case of Market Place Perspective

1

4546

Fulfilled %

Percentage fulfilment till now.

50%

4647

Order Amount

Total Value of entire order.

3999

4748

External Pick Order Group Code

A unique ID for Pick Order Group which consists of multiple orders Items that are grouped together to be picked at once.

Yes. If Pick order group is not applicable

abcd123

4849

Pre/Post Pack Staging Location

Pre/Post Pack Staging Location ID

1231241

4950

Remarks

Remarks if any

If not provided

String

5051

Retry Count

No. of times an order, oms tries syncing with wms if sync is getting failed

NA

1

...