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

Fulfillment Fulfilllment Location Name

Name of the Fulfilment Location

NA

wms_abc

3

Fulfilment Fulfillment Location City

City of the Fulfilment Location

NA

Bengaluru

4

Fulfillment Location ID

Increff’s Internal ID of Fulfillment Location

NA

1891238124

5

Gate Entry ID

gate entry no

NA

123456789

56

PO Date

Purchase order date

NA

2023-01-01

67

Vendor Invoice No

External invoice number.

NA

abc134

78

Vendor Invoice Date

External Invoice Date.

Yes if the external invoice is not present.

2023-01-01

89

PO No

Inward Purchase Order ID

Yes if the order is not placed by any channel.

abc245

910

Parent Order ID

Order ID of parent order

NA

abc245

1011

Order Type

Type of Order

NA

  1. STOCK_TRANSFER

  2. PURCHASE

  3. OPEN_PO

  4. RETURN

  5. OPEN_RETURN

1112

Order Status

Status of the Order

NA

  1. CREATED

  2. CANCELLED

  3. COMPLETED

1213

Vendor Name

Partner Name

abc333

1314

Vendor ID

Partner ID

1243234322

15

Vendor City

City of Partner

 

abc345

1416

Client SKU ID/EAN

client sku id

NA

abc123

1517

Channel SKU ID

Channel SKU ID

NA

123445566

1618

SKU Desc

Sku description

If not configured in Article/SKU Master

abc345

1719

Style

Style

If not configured in Article/SKU Master

acb345

1820

Size

Size

If not configured in Article/SKU Master

abc433

1921

Color

Color

If not configured in Article/SKU Master

abc134

2022

MRP

MRP

If not configured in Article/SKU Master

123.50

2123

Value

123.40

2224

Brand

Brand

If not configured in Article/SKU Master

abc345

2325

LR No

AWB Number

 

abc123

2426

Vehicle No

Vehicle Number

 

abc123

2527

HSN Code

 

If not configured in Article/SKU Master

abc123

2628

Vendor Tin

GST Number

abc123

2729

PO Qty

Purchase quantity

NA

12343

2830

Pass Qty

QC Passed Quantity

NA

123

2931

Fail Qty

QC Failed Quantity

NA

23

3032

Received Qty

Quantity Received

NA

134

3133

Putaway Qty

Putaway
Quantity

123

3234

Pending Putaway Qty

Pending Putaway Quantity

123

3335

Pending GRN Qty

Quantity which is not yet GRNed.

123

3436

Balance Qty

134

3537

Gate Entry Created Time

Gate entry created time

2023-01-01 12:34:56

3638

GRN Start Time

Grn Start time

2023-01-01 12:34:56

3739

Gate Entry Closed Time

Gate entry closed time

2023-01-01 12:34:56

3840

Latest GRN Time

Latest GRN time

2023-01-01 12:34:56

3941

Latest Putaway Time

Latest Putaway Time

2023-01-01 12:34:56

4042

Gate Entry Status

Gate entry status

  1. OPEN

  2. CLOSE

4143

Gate Entry Updated Time

Gate entry updated time

2023-01-01

4244

Remarks

Remark

abc444

Filters

...