V3.UnifyProductWiseDemandVsSale

ErpID of the Outlet from which the order was generated

ID of the beat of the outlet from which the order was generated

Name of the beat of the outlet from which the order was generated

Id of the territory of the outlet from which the order was generated

Name of the territory of the outlet from which the order was generated

Id of the Region of the outlet from which the order was generated

Name of the Region of the outlet from which the order was generated

Id of the Zone of the outlet from which the order was generated

Name of the Zone of the outlet from which the order was generated

Id of the level 5 geo of the outlet from the which the order was generated

Name of the level 5 geo of the outlet from the which the order was generated

Id of the level 6 geo of the outlet from the which the order was generated

Name of the level 6 geo of the outlet from the which the order was generated

Id of the level 7 geo of the outlet from the which the order was generated

Name of the level 7 geo of the outlet from the which the order was generated

ErpID of distributor that is mapped to the beat / user (first or default)

Name of the Distributor that is mapped to the beat / User (first or default)

Address of the Distributor that is mapped to the beat / User (first or default)

Phone number of the Distributor that is mapped to the beat / User (first or default)

Distributor StockistType should be valid Possible values are 0. Unknown 1. Stockist 2. Super Stockist 3. Sub Stockist

ErpID of the parent (SuperStockist) of the concerned Distributor's Stockist type being "Substockist"

Name of the parent (SuperStockist) of the concerned Distributor's Stockist type being "Substockist"

ErpId of GSM mapped with Distributor

ErpId of GSM mapped with Distributor

ErpId of NSM mapped with Distributor

ErpId of NSM mapped with Distributor

ErpId of ZSM mapped with Distributor

ErpId of ZSM mapped with Distributor

ErpId of RSM mapped with Distributor

ErpId of RSM mapped with Distributor

ErpId of ASM mapped with Distributor

ErpId of ASM mapped with Distributor

ErpId of ESM mapped with Distributor

ErpId of ESM mapped with Distributor

Name of the Product Division of the concerned Product

Name of the Primary Category of the concerned Product

Name of the Secondary Category of the concerned Product

Boolean Value (0=False,1=True) to show if Product booked is Promoted

Boolean Value (0=False,1=True) to show if Product booked is Recommended

Boolean Value (0=False,1=True) to show if Product booked is IsFastMoving

Boolean Value (0=False,1=True) to show if Product booked is Focussed

Boolean Value (0=False,1=True) to show if Product booked is must Sell

Boolean Value (0=False,1=True) to show if Product booked is Assorted

Display category name

ErpId of the concerned Product

Name of the concerned Product

MRP of the concerned Product

Original PTR of the concerned Product

Price to Retailer of the Product at which order (SFA/ DMS Direct Order) was booked

Date on which the Order was booked in SFA / was created in DMS (as per Journey Calendar)

Week in which the Order was booked in SFA / was created in DMS (as per Journey Calendar)

Month in which the Order was booked in SFA / was created in DMS (as per Journey Calendar)

Unique Id of an order

Type / Source of the order - types of orders for now -> 0-"SFA", 1="Direct" , 2="Others"

Boolean Value (0=False, 1=True) , if status of the order remains partaially invoiced

Order Qty of concerned product in Units booked (SFA/ DMS Direct) against the OrderId

Order Qty of concerned product in StdUnits booked (SFA/ DMS Direct) against the OrderId

Order Qty of concerned product in SuperUnits booked (SFA/ DMS Direct) against the OrderId

Gross Value of concerned product (Qty*PTR) booked (SFA/ DMS Direct) against the OrderId

TotalTradeDiscount applied for concerned product against orderId generation

PrimarySchemeDiscount applied for concerned product against orderId generation

SecondarySchemeDiscount applied for concerned product against orderId generation

PrimarySchemeDiscrount + SecondarySchemeDiscount applied for concerned product against orderId generation

TotalCashDiscount applied for concerned product against orderId generation

Order Booked value in Value - Scheme Discount - Trade Discount - Cash Discount for concerned product against orderId

Value of SGST tax applied on concerned product against orderId generation

Value of CGST tax applied on concerned product against orderId generation

Value of IGST tax applied on concerned product against orderId generation

Value of UTGST tax applied on concerned product against orderId generation

Total Value of the order value booked for a concerned product (OrderNetValue + SGST+CGST+IGST+UGST) against orderId generation

if the Sales Order is cancelled - 0,1

Level1 Position User Name

Level1 Position Code

Level1 Position Name

Level1 Position User Erp Id

Level2 Position User Name

Level2 Position Code

Level2 Position Name

Level2 Position User Erp Id

Level3 Position User Name

Level3 Position Code

Level3 Position Name

Level3 Position User Erp Id

Level4 Position User Name

Level4 Position Code

Level4 Position Name

Level4 Position User Erp Id

Level5 Position User Name

Level5 Position Code

Level5 Position Name

Level5 Position User Erp Id

Level6 Position User Name

Level6 Position Code

Level6 Position Name

Level6 Position User Erp Id

Level7 Position User Name

Level7 Position Code

Level7 Position Name

Level7 Position User Erp Id

Level8 Position User Name

Level8 Position Code

Level8 Position Name

Level8 Position User Erp Id

Invoice Number

Date of the Invoice creation

Type of sales/invoice - none -0,sfa-1,dms-2

1 - true

Price at which invoice made

Invoice Qunatity in units

Invoice Qunatity in standard units

Invoice Qunatity in Super units

Invoice Gross Value

Total trade discount in invoice

Primary scheme discount in invoice

Secondary scheme discount in invoice

Total scheme discount in invoice

Cash discount in invoice

Invoice Net Value

Invoice Total Value

Retailer stock Quantity

Retailer stock Quantity in standard units

Retailer stock Quantity in super units

Retailer stock Value

total Return quantity in units

total Return quantity in standard units

total Return quantity in super units

total Return Value

Net Return Value

Gross Return Value

Qty of Goods Return that are fresh (non damaged, non expired) against concerned InvoiceID

Qty of Goods Return that are fresh (non damaged, non expired) against concerned InvoiceID in StdUnit

Qty of Goods Return that are fresh (non damaged, non expired) against concerned InvoiceID in SuperUnit

Total Value of goods return that are fresh (non damaged, non expired) against the concerned invoiceID

Net Value of goods return that are fresh (non damaged, non expired) against the concerned invoiceID

Gross Value of goods return that are fresh (non damaged, non expired) against the concerned invoiceID

Qty of Goods Return that are damaged against concerned InvoiceID

Qty of Goods Return that are damaged against concerned InvoiceID in StdUnit

Qty of Goods Return that are damaged against concerned InvoiceID in SuperUnit

Total Value of Damaged Goods Return against the concerned InvoiceID

Net Value of Damaged Goods Return against the concerned InvoiceID

Gross Value of Damaged Goods Return against the concerned InvoiceID

Qty of Goods Return that are expired against concerned InvoiceID

Qty of Goods Return that are expired against concerned InvoiceID in StdUnit

Qty of Goods Return that are expired against concerned InvoiceID in SuperUnit

Total Value of goods return that are expired against the concerned invoiceID

Net Value of goods return that are expired against the concerned invoiceID

Gross Value of goods return that are expired against the concerned invoiceID