...
Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Description
Inward received at GRN date and UOM SKU level data is populated and this report can be filtered on GRN done date.
Fields
Fields | Description | This Column Can be NULL | Sample Data | |
---|---|---|---|---|
1 | Client Name | Name of the Client | NA | Increff |
2 | Fulfillment Location Name | Name of the Fulfilment Location | NA | wms_hsr |
3 | Fulfilment Location City | City of the Fulfilment Location | NA | Bengaluru |
4 | Gate Entry ID | gate entry no | NA | 123456789 |
5 | GRN Date | Date of GRN | NA | 2023-01-01 |
6 | PO Date | Purchase order date | NA | 2023-01-01 |
7 | Vendor Invoice Date | External Invoice Date. | Yes if the external invoice is not present. | 2023-01-01 |
8 | PO No | Inward Purchase Order ID | Yes if the order is not placed by any channel. | abc245 |
9 | Parent Order ID | Order ID of parent order |
| abc245 |
10 | Vendor Invoice No | External invoice number. | NA | abc134 |
11 | Order Type | Type of Order | NA |
|
12 | Vendor Name | Partner Name |
| abc333 |
13 | Vendor City | City of Partner |
| abc345 |
14 | Client SKU ID/EAN | client sku id | NA | abc123 |
15 | Global SKU ID | global sku id | NA | 123455678 |
16 | Each Client SKU ID | client sku id | NA | abc123 |
17 | Each Global SKU ID | global sku id | NA | 123455678 |
18 | SKU Desc | Sku description | NA | abc345 |
19 | Style | Style | NA | acb345 |
20 | Size | Size | NA | abc433 |
21 | color | color | NA | abc134 |
22 | Brand | Brand | NA | abc345 |
23 | LR No | AWB Number |
| abc123 |
24 | Vehicle No | Vehicle Number |
| abc123 |
25 | HSN Code |
| NA | abc123 |
26 | Vendor Tin | GST Number |
| abc123 |
27 | Category | Category | NA | abc123 |
28 | Fail Qty | Total QC Failed Quantity | NA | 12345 |
29 | Pass Qty | Total QC Passed Quantity | NA | 12345 |
30 | Received Qty | Total Received Quantity | NA | 12345 |
31 | Received Each Qty | Total quantity received in each box | NA | 1234 |
...