# Schema Information

## Tables/APIs&#x20;

The following is the list of tables or APIs associated with the Unicommerce connector:

* [Invoice](#invoice)&#x20;
* [ReturnInvoices](#returninvoices)&#x20;
* [ReversePickup](#reversepickup)&#x20;
* [Putaway](#putaway)&#x20;
* [Vendors](#vendors)&#x20;
* [InventorySnapshot](#inventorysnapshot)&#x20;
* [VendorItemMaster](#vendoritemmaster)&#x20;
* [GRN](#grn)&#x20;
* [Gatepass](#gatepass)&#x20;
* [ItemMaster](#itemmaster)&#x20;
* [PurchaseOrders](#purchaseorders)&#x20;
* [SaleOrders](#saleorders)&#x20;
* [ShippingPackage](#shippingpackage)&#x20;
* [CourierReturnItemwise](#courierreturnitemwise)&#x20;
* [ShelfwiseInventory](#shelfwiseinventory)&#x20;
* [TallyGSTReport](#tallygstreport)&#x20;
* [TallyCancelGSTReport](#tallycancelgstreport)&#x20;
* [TallyReturnGSTReport](#tallyreturngstreport)

#### Invoice&#x20;

The Invoice API allows you to create and manage invoices for your orders and transactions within the Unicommerce platform.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS&#x20;

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>OrderNo</td><td>STRING</td></tr><tr><td>InvoiceNo</td><td>STRING</td></tr><tr><td>ShippingPackageCode</td><td>STRING</td></tr><tr><td>ShippingPackageStatusCode</td><td>STRING</td></tr><tr><td>InvoiceCreatedDate</td><td>STRING</td></tr><tr><td>ChannelInvoiceCreatedDate</td><td>STRING</td></tr><tr><td>CustomerName</td><td>STRING</td></tr><tr><td>SKUCode</td><td>STRING</td></tr><tr><td>SKUName</td><td>STRING</td></tr><tr><td>Quantity</td><td>STRING</td></tr><tr><td>InvoiceTax</td><td>STRING</td></tr><tr><td>InvoiceTotal</td><td>STRING</td></tr><tr><td>InvoiceCancelled</td><td>STRING</td></tr><tr><td>HSNCode</td><td>STRING</td></tr><tr><td>GSTTaxTypeCode</td><td>STRING</td></tr><tr><td>CGST</td><td>STRING</td></tr><tr><td>IGST</td><td>STRING</td></tr><tr><td>SGST</td><td>STRING</td></tr><tr><td>UTGST</td><td>STRING</td></tr><tr><td>CGSTRate</td><td>STRING</td></tr><tr><td>IGSTRate</td><td>STRING</td></tr><tr><td>SGSTRate</td><td>STRING</td></tr><tr><td>UTGSTRate</td><td>STRING</td></tr><tr><td>CESSRate</td><td>STRING</td></tr><tr><td>ShippingCharge</td><td>STRING</td></tr><tr><td>CODCharge</td><td>STRING</td></tr><tr><td>TCSAmount</td><td>STRING</td></tr><tr><td>ChannelName</td><td>STRING</td></tr><tr><td>UniwareInvoiceCode</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr><tr><td>EWayBillDate</td><td>STRING</td></tr><tr><td>EWayBillNo</td><td>STRING</td></tr><tr><td>EWayBillValidTill</td><td>STRING</td></tr><tr><td>TaxTypeCode</td><td>STRING</td></tr><tr><td>VAT</td><td>STRING</td></tr><tr><td>CST</td><td>STRING</td></tr><tr><td>AdditionalTax</td><td>STRING</td></tr><tr><td>AdditionalTaxPercentage</td><td>STRING</td></tr><tr><td>TaxPercentage</td><td>STRING</td></tr><tr><td>CESS</td><td>STRING</td></tr></tbody></table>

#### ReturnInvoices &#x20;

ReturnInvoices API isused to handle invoices related to product returns or refunds, ensuring accurate accounting of return transactions.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>DisplayOrderCode</td><td>STRING</td></tr><tr><td>InvoiceCode</td><td>STRING</td></tr><tr><td>ReturnInvoiceCode</td><td>STRING</td></tr><tr><td>ShippingPackageCode</td><td>STRING</td></tr><tr><td>ShippingPackageStatusCode</td><td>STRING</td></tr><tr><td>ReturnDate</td><td>STRING</td></tr><tr><td>CustomerName</td><td>STRING</td></tr><tr><td>ItemSKUCode</td><td>STRING</td></tr><tr><td>ItemTypeName</td><td>STRING</td></tr><tr><td>Quantity</td><td>STRING</td></tr><tr><td>UnitPrice</td><td>STRING</td></tr><tr><td>CGST</td><td>STRING</td></tr><tr><td>IGST</td><td>STRING</td></tr><tr><td>SGST</td><td>STRING</td></tr><tr><td>UTGST</td><td>STRING</td></tr><tr><td>CESS</td><td>STRING</td></tr><tr><td>CGSTRate</td><td>STRING</td></tr><tr><td>IGSTRate</td><td>STRING</td></tr><tr><td>SGSTRate</td><td>STRING</td></tr><tr><td>UTGSTRate</td><td>STRING</td></tr><tr><td>CESSRate</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### ReversePickup &#x20;

The ReversePickup API enables the management of reverse pickups, ensuring efficient handling of returned goods.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>SaleOrderItemCode</td><td>STRING</td></tr><tr><td>SaleOrderReceived</td><td>STRING</td></tr><tr><td>OriginalSaleOrderCode</td><td>STRING</td></tr><tr><td>ItemName</td><td>STRING</td></tr><tr><td>ItemSkuCode</td><td>STRING</td></tr><tr><td>ReversePickupNo</td><td>STRING</td></tr><tr><td>TrackingNo</td><td>STRING</td></tr><tr><td>DispatchedDate</td><td>STRING</td></tr><tr><td>ReferenceCode</td><td>STRING</td></tr><tr><td>BulkReturnId</td><td>STRING</td></tr><tr><td>ReversePickupCreated</td><td>STRING</td></tr><tr><td>ReversePickupLastUpdated</td><td>STRING</td></tr><tr><td>ReversePickupStatus</td><td>STRING</td></tr><tr><td>ReversePickupAction</td><td>STRING</td></tr><tr><td>ReturnReason</td><td>STRING</td></tr><tr><td>ReplacementSaleOrderCode</td><td>STRING</td></tr><tr><td>ChannelName</td><td>STRING</td></tr><tr><td>TotalReceivedItems</td><td>STRING</td></tr><tr><td>QCComment</td><td>STRING</td></tr><tr><td>ReversePickupCreatedBy</td><td>STRING</td></tr><tr><td>PutawayCode</td><td>STRING</td></tr><tr><td>PutawayCreatedBy</td><td>STRING</td></tr><tr><td>PutawayStatus</td><td>STRING</td></tr><tr><td>PutawayLastUpdated</td><td>STRING</td></tr><tr><td>CourierProviderName</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### Putaway &#x20;

With the Putaway API, you can effectively manage your inventory by recording the process of putting away received stock.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>PutawayItemId</td><td>STRING</td></tr><tr><td>ShelfCode</td><td>STRING</td></tr><tr><td>PutawayCode</td><td>STRING</td></tr><tr><td>Created</td><td>STRING</td></tr><tr><td>CreatedBy</td><td>STRING</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>ItemTypeskuCode</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Category</td><td>STRING</td></tr><tr><td>PutawayQuantity</td><td>STRING</td></tr><tr><td>StatusCode</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>InventoryType</td><td>STRING</td></tr><tr><td>BatchCode</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### Vendors &#x20;

The Vendors API is used to manage vendor information and relationships, ensuring seamless communication and collaboration with suppliers.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>VendorCode</td><td>STRING</td></tr><tr><td>VendorName</td><td>STRING</td></tr><tr><td>PAN</td><td>STRING</td></tr><tr><td>TIN</td><td>STRING</td></tr><tr><td>Created</td><td>STRING</td></tr><tr><td>CSTNumber</td><td>STRING</td></tr><tr><td>ServiceTaxNumber</td><td>STRING</td></tr><tr><td>GSTNumber</td><td>STRING</td></tr><tr><td>Website</td><td>STRING</td></tr><tr><td>PrimaryContactName</td><td>STRING</td></tr><tr><td>PrimaryContactEmail</td><td>STRING</td></tr><tr><td>PrimaryContactPhone</td><td>STRING</td></tr><tr><td>ShippingAddressLine1</td><td>STRING</td></tr><tr><td>ShippingAddressLine2</td><td>STRING</td></tr><tr><td>ShippingAddressCity</td><td>STRING</td></tr><tr><td>ShippingAddressState</td><td>STRING</td></tr><tr><td>ShippingAddressPincode</td><td>STRING</td></tr><tr><td>ShippingAddressPhone</td><td>STRING</td></tr><tr><td>BillingAddressLine1</td><td>STRING</td></tr><tr><td>BillingAddressLine2</td><td>STRING</td></tr><tr><td>BillingAddressCity</td><td>STRING</td></tr><tr><td>BillingAddressState</td><td>STRING</td></tr><tr><td>BillingAddressPincode</td><td>STRING</td></tr><tr><td>BillingAddressPhone</td><td>STRING</td></tr><tr><td>PurchaseExpiryPeriod</td><td>STRING</td></tr><tr><td>AgreementName</td><td>STRING</td></tr><tr><td>AgreementStartTime</td><td>STRING</td></tr><tr><td>AgreementEndTime</td><td>STRING</td></tr><tr><td>AgreementText</td><td>STRING</td></tr><tr><td>AcceptsCForm</td><td>STRING</td></tr><tr><td>TaxExempted</td><td>STRING</td></tr><tr><td>RegisteredDealer</td><td>STRING</td></tr><tr><td>Username</td><td>STRING</td></tr><tr><td>Enabled</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### InventorySnapshot &#x20;

Capture real-time snapshots of your inventory levels with the InventorySnapshot API to facilitate accurate stock management.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Facility</td><td>STRING</td></tr><tr><td>ItemTypeName</td><td>STRING</td></tr><tr><td>ItemSkuCode</td><td>STRING</td></tr><tr><td>Ean</td><td>STRING</td></tr><tr><td>UPC</td><td>STRING</td></tr><tr><td>ISBN</td><td>STRING</td></tr><tr><td>Color</td><td>STRING</td></tr><tr><td>Size</td><td>STRING</td></tr><tr><td>Brand</td><td>STRING</td></tr><tr><td>CategoryName</td><td>STRING</td></tr><tr><td>MRP</td><td>STRING</td></tr><tr><td>OpenSale</td><td>STRING</td></tr><tr><td>Inventory</td><td>STRING</td></tr><tr><td>InventoryBlocked</td><td>STRING</td></tr><tr><td>BadInventory</td><td>STRING</td></tr><tr><td>PutawayPending</td><td>STRING</td></tr><tr><td>PendingInventoryAssessment</td><td>STRING</td></tr><tr><td>StockInTransfer</td><td>STRING</td></tr><tr><td>OpenPurchase</td><td>STRING</td></tr><tr><td>Enabled</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>CostPrice</td><td>STRING</td></tr></tbody></table>

#### VendorItemMaster &#x20;

Use the VendorItemMaster API to manage and maintain vendor-specific item details for streamlined procurement processes.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Facility</td><td>STRING</td></tr><tr><td>ProductCode</td><td>STRING</td></tr><tr><td>ProductName</td><td>STRING</td></tr><tr><td>UnitPrice</td><td>STRING</td></tr><tr><td>Inventory</td><td>STRING</td></tr><tr><td>VendorCode</td><td>STRING</td></tr><tr><td>VendorSkuCode</td><td>STRING</td></tr><tr><td>LeadTime_inHours_</td><td>STRING</td></tr><tr><td>Priority</td><td>STRING</td></tr><tr><td>Enabled</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr></tbody></table>

#### GRN &#x20;

The GRN API enables the creation and management of Goods Receipt Notes to track goods received from vendors accurately.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>GRNCode</td><td>STRING</td></tr><tr><td>GRNDate</td><td>STRING</td></tr><tr><td>GRNCreatedBy</td><td>STRING</td></tr><tr><td>ItemSkuCode</td><td>STRING</td></tr><tr><td>ItemTypeName</td><td>STRING</td></tr><tr><td>ItemTypeColor</td><td>STRING</td></tr><tr><td>ItemTypeSize</td><td>STRING</td></tr><tr><td>ItemTypeBrand</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr><tr><td>Category</td><td>STRING</td></tr><tr><td>BatchCode</td><td>STRING</td></tr><tr><td>AdditionalCost</td><td>STRING</td></tr><tr><td>VendorSkuCode</td><td>STRING</td></tr><tr><td>VendorName</td><td>STRING</td></tr><tr><td>VendorCode</td><td>STRING</td></tr><tr><td>GRNInvoiceNo</td><td>STRING</td></tr><tr><td>GRNInvoiceDate</td><td>STRING</td></tr><tr><td>POCode</td><td>STRING</td></tr><tr><td>PODate</td><td>DATETIME</td></tr><tr><td>QuantityReceived</td><td>STRING</td></tr><tr><td>QuantityRejected</td><td>STRING</td></tr><tr><td>PercentageRejection</td><td>STRING</td></tr><tr><td>ValuesofGoodsReceivedwithouttaxes</td><td>STRING</td></tr><tr><td>ValuesofGoodsReceivedwithtaxes</td><td>STRING</td></tr><tr><td>ValuesofGoodsRejectedwithouttaxes</td><td>STRING</td></tr><tr><td>ValuesofGoodsRejectedwithtaxes</td><td>STRING</td></tr><tr><td>RejectionReason</td><td>STRING</td></tr><tr><td>GrnitemStatus</td><td>STRING</td></tr><tr><td>Updated</td><td>DATETIME</td></tr><tr><td>ExpiryDate</td><td>STRING</td></tr></tbody></table>

#### Gatepass &#x20;

Manage the movement of goods in and out of your facility efficiently with the Gatepass API, ensuring proper tracking and control.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>GatepassCode</td><td>STRING</td></tr><tr><td>GatepassCreatedBy</td><td>STRING</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>GatepassStatus</td><td>STRING</td></tr><tr><td>GatepassCreatedAt</td><td>STRING</td></tr><tr><td>GatepassUpdatedAt</td><td>STRING</td></tr><tr><td>Purpose</td><td>STRING</td></tr><tr><td>Reference</td><td>STRING</td></tr><tr><td>ToParty</td><td>STRING</td></tr><tr><td>ItemName</td><td>STRING</td></tr><tr><td>ItemSkuCode</td><td>STRING</td></tr><tr><td>Color</td><td>STRING</td></tr><tr><td>Size</td><td>STRING</td></tr><tr><td>Brand</td><td>STRING</td></tr><tr><td>HSNCode</td><td>STRING</td></tr><tr><td>UnitPrice</td><td>STRING</td></tr><tr><td>Quantity</td><td>STRING</td></tr><tr><td>ReceivedQuantity</td><td>STRING</td></tr><tr><td>InventoryType</td><td>STRING</td></tr><tr><td>GatepassItemStatus</td><td>STRING</td></tr><tr><td>Shelf</td><td>STRING</td></tr><tr><td>Reason</td><td>STRING</td></tr><tr><td>GatepassItemCreated</td><td>STRING</td></tr><tr><td>GatepassItemUpdated</td><td>STRING</td></tr><tr><td>GatepassOrderCode</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### ItemMaster &#x20;

The ItemMaster API allows you to manage product and item information, ensuring accurate product data across your system.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>CategoryCode</td><td>STRING</td></tr><tr><td>ProductCode</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Description</td><td>STRING</td></tr><tr><td>ScanIdentifier</td><td>STRING</td></tr><tr><td>RequiresCustomization</td><td>STRING</td></tr><tr><td>Length_mm_</td><td>STRING</td></tr><tr><td>Width_mm_</td><td>STRING</td></tr><tr><td>Height_mm_</td><td>STRING</td></tr><tr><td>Weight_gms_</td><td>STRING</td></tr><tr><td>EAN</td><td>STRING</td></tr><tr><td>UPC</td><td>STRING</td></tr><tr><td>ISBN</td><td>STRING</td></tr><tr><td>Color</td><td>STRING</td></tr><tr><td>Size</td><td>STRING</td></tr><tr><td>Brand</td><td>STRING</td></tr><tr><td>ItemDetailFields</td><td>STRING</td></tr><tr><td>Tags</td><td>STRING</td></tr><tr><td>ImageUrl</td><td>STRING</td></tr><tr><td>ProductPageUrl</td><td>STRING</td></tr><tr><td>TaxTypeCode</td><td>STRING</td></tr><tr><td>GSTTaxTypeCode</td><td>STRING</td></tr><tr><td>BasePrice</td><td>STRING</td></tr><tr><td>CostPrice</td><td>STRING</td></tr><tr><td>TAT</td><td>STRING</td></tr><tr><td>MRP</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>CategoryName</td><td>STRING</td></tr><tr><td>Enabled</td><td>STRING</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>ComponentProductCode</td><td>STRING</td></tr><tr><td>ComponentQuantity</td><td>STRING</td></tr><tr><td>ComponentPrice</td><td>STRING</td></tr><tr><td>HSNCODE</td><td>STRING</td></tr><tr><td>TaxCalculationType</td><td>STRING</td></tr><tr><td>BatchGroup</td><td>STRING</td></tr><tr><td>GRNexpirytolerance_inDays_</td><td>STRING</td></tr><tr><td>Dispatchexpirytolerance_inDays_</td><td>STRING</td></tr><tr><td>Returnexpirytolerance_inDays_</td><td>STRING</td></tr><tr><td>Expirable</td><td>STRING</td></tr><tr><td>DetermineExpiryFrom</td><td>STRING</td></tr><tr><td>ShelfLife</td><td>STRING</td></tr><tr><td>ExpiryDate</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### PurchaseOrders &#x20;

Create, manage, and track purchase orders with the PurchaseOrders API, streamlining your procurement processes.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>POCode</td><td>STRING</td></tr><tr><td>Created</td><td>STRING</td></tr><tr><td>POCreatedBy</td><td>STRING</td></tr><tr><td>POApprovedDate</td><td>STRING</td></tr><tr><td>DeliveryDate</td><td>STRING</td></tr><tr><td>ItemTypeName</td><td>STRING</td></tr><tr><td>ItemSkuCode</td><td>STRING</td></tr><tr><td>Category</td><td>STRING</td></tr><tr><td>HSNCode</td><td>STRING</td></tr><tr><td>GSTTaxTypeCode</td><td>STRING</td></tr><tr><td>VendorName</td><td>STRING</td></tr><tr><td>VendorCode</td><td>STRING</td></tr><tr><td>VendorSkuCode</td><td>STRING</td></tr><tr><td>OrderQuantity</td><td>STRING</td></tr><tr><td>RecievedQuantity</td><td>STRING</td></tr><tr><td>RejectedQuantity</td><td>STRING</td></tr><tr><td>PendingQuantity</td><td>STRING</td></tr><tr><td>_Pending</td><td>STRING</td></tr><tr><td>_Rejection</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr><tr><td>SubTotal</td><td>STRING</td></tr><tr><td>CGST</td><td>STRING</td></tr><tr><td>IGST</td><td>STRING</td></tr><tr><td>SGST</td><td>STRING</td></tr><tr><td>UTGST</td><td>STRING</td></tr><tr><td>CESS</td><td>STRING</td></tr><tr><td>CGSTRate</td><td>STRING</td></tr><tr><td>IGSTRate</td><td>STRING</td></tr><tr><td>SGSTRate</td><td>STRING</td></tr><tr><td>UTGSTRate</td><td>STRING</td></tr><tr><td>CESSRate</td><td>STRING</td></tr><tr><td>Total</td><td>STRING</td></tr><tr><td>PurchaseOrderStatus</td><td>STRING</td></tr><tr><td>RejectionReason</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>POAgeing_Days_</td><td>STRING</td></tr><tr><td>UnitPrice</td><td>STRING</td></tr></tbody></table>

#### SaleOrders &#x20;

The SaleOrders API facilitates the creation, management, and tracking of sales orders for efficient order fulfillment.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>NotificationEmail</td><td>STRING</td></tr><tr><td>NotificationMobile</td><td>STRING</td></tr><tr><td>SaleOrderItemCode</td><td>STRING</td></tr><tr><td>DisplayOrderCode</td><td>STRING</td></tr><tr><td>ReversePickupCode</td><td>STRING</td></tr><tr><td>ReversePickupCreatedDate</td><td>STRING</td></tr><tr><td>ReversePickupReason</td><td>STRING</td></tr><tr><td>RequireCustomization</td><td>STRING</td></tr><tr><td>COD</td><td>STRING</td></tr><tr><td>ShippingAddressId</td><td>STRING</td></tr><tr><td>Category</td><td>STRING</td></tr><tr><td>InvoiceCode</td><td>STRING</td></tr><tr><td>InvoiceCreated</td><td>STRING</td></tr><tr><td>ShippingAddressState</td><td>STRING</td></tr><tr><td>ShippingAddressCountry</td><td>STRING</td></tr><tr><td>ShippingAddressPincode</td><td>STRING</td></tr><tr><td>BillingAddressState</td><td>STRING</td></tr><tr><td>BillingAddressPincode</td><td>STRING</td></tr><tr><td>ShippingMethod</td><td>STRING</td></tr><tr><td>ItemSKUCode</td><td>STRING</td></tr><tr><td>ChannelProductId</td><td>STRING</td></tr><tr><td>ItemTypeName</td><td>STRING</td></tr><tr><td>ItemTypeColor</td><td>STRING</td></tr><tr><td>ItemTypeSize</td><td>STRING</td></tr><tr><td>ItemTypeBrand</td><td>STRING</td></tr><tr><td>ChannelName</td><td>STRING</td></tr><tr><td>SKURequireCustomization</td><td>STRING</td></tr><tr><td>GiftWrap</td><td>STRING</td></tr><tr><td>GiftMessage</td><td>STRING</td></tr><tr><td>HSNCode</td><td>STRING</td></tr><tr><td>MRP</td><td>STRING</td></tr><tr><td>TotalPrice</td><td>STRING</td></tr><tr><td>SellingPrice</td><td>STRING</td></tr><tr><td>CostPrice</td><td>STRING</td></tr><tr><td>PrepaidAmount</td><td>STRING</td></tr><tr><td>Subtotal</td><td>STRING</td></tr><tr><td>Discount</td><td>STRING</td></tr><tr><td>GSTTaxTypeCode</td><td>STRING</td></tr><tr><td>CGST</td><td>STRING</td></tr><tr><td>IGST</td><td>STRING</td></tr><tr><td>SGST</td><td>STRING</td></tr><tr><td>UTGST</td><td>STRING</td></tr><tr><td>CESS</td><td>STRING</td></tr><tr><td>CGSTRate</td><td>STRING</td></tr><tr><td>IGSTRate</td><td>STRING</td></tr><tr><td>SGSTRate</td><td>STRING</td></tr><tr><td>UTGSTRate</td><td>STRING</td></tr><tr><td>CESSRate</td><td>STRING</td></tr><tr><td>Tax_</td><td>STRING</td></tr><tr><td>TaxValue</td><td>STRING</td></tr><tr><td>VoucherCode</td><td>STRING</td></tr><tr><td>ShippingCharges</td><td>STRING</td></tr><tr><td>ShippingMethodCharges</td><td>STRING</td></tr><tr><td>CODServiceCharges</td><td>STRING</td></tr><tr><td>GiftWrapCharges</td><td>STRING</td></tr><tr><td>PacketNumber</td><td>STRING</td></tr><tr><td>OrderDateasdd_mm_yyyyhh_MM_ss</td><td>STRING</td></tr><tr><td>SaleOrderCode</td><td>STRING</td></tr><tr><td>OnHold</td><td>STRING</td></tr><tr><td>SaleOrderStatus</td><td>STRING</td></tr><tr><td>Priority</td><td>STRING</td></tr><tr><td>Currency</td><td>STRING</td></tr><tr><td>CurrencyConversionRate</td><td>STRING</td></tr><tr><td>SaleOrderItemStatus</td><td>STRING</td></tr><tr><td>CancellationReason</td><td>STRING</td></tr><tr><td>Shippingprovider</td><td>STRING</td></tr><tr><td>ShippingArrangedBy</td><td>STRING</td></tr><tr><td>ShippingPackageCode</td><td>STRING</td></tr><tr><td>ShippingPackageCreationDate</td><td>STRING</td></tr><tr><td>ShippingPackageStatusCode</td><td>STRING</td></tr><tr><td>ShippingPackageType</td><td>STRING</td></tr><tr><td>Length_mm_</td><td>STRING</td></tr><tr><td>Width_mm_</td><td>STRING</td></tr><tr><td>Height_mm_</td><td>STRING</td></tr><tr><td>DeliveryTime</td><td>STRING</td></tr><tr><td>TrackingNumber</td><td>STRING</td></tr><tr><td>DispatchDate</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr><tr><td>ReturnDate</td><td>STRING</td></tr><tr><td>ReturnReason</td><td>STRING</td></tr><tr><td>Created</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>CombinationIdentifier</td><td>STRING</td></tr><tr><td>CombinationDescription</td><td>STRING</td></tr><tr><td>TransferPrice</td><td>STRING</td></tr><tr><td>ItemCode</td><td>STRING</td></tr><tr><td>IMEI</td><td>STRING</td></tr><tr><td>Weight</td><td>STRING</td></tr><tr><td>GSTIN</td><td>STRING</td></tr><tr><td>CustomerGSTIN</td><td>STRING</td></tr><tr><td>TIN</td><td>STRING</td></tr><tr><td>FulfillmentTAT</td><td>STRING</td></tr><tr><td>ChannelShipping</td><td>STRING</td></tr><tr><td>ItemDetails</td><td>STRING</td></tr><tr><td>EWayBillNo</td><td>STRING</td></tr><tr><td>EWayBillDate</td><td>STRING</td></tr><tr><td>EWayBillValidTill</td><td>STRING</td></tr><tr><td>TCSAmount</td><td>STRING</td></tr><tr><td>ShippingCourier</td><td>STRING</td></tr><tr><td>PaymentInstrument</td><td>STRING</td></tr><tr><td>ShippingAddressName</td><td>STRING</td></tr><tr><td>ShippingAddressLine1</td><td>STRING</td></tr><tr><td>ShippingAddressLine2</td><td>STRING</td></tr><tr><td>ShippingAddressCity</td><td>STRING</td></tr><tr><td>ShippingAddressPhone</td><td>STRING</td></tr><tr><td>BillingAddressId</td><td>STRING</td></tr><tr><td>BillingAddressName</td><td>STRING</td></tr><tr><td>BillingAddressLine1</td><td>STRING</td></tr><tr><td>BillingAddressLine2</td><td>STRING</td></tr><tr><td>BillingAddressCity</td><td>STRING</td></tr><tr><td>BillingAddressCountry</td><td>STRING</td></tr><tr><td>BillingAddressPhone</td><td>STRING</td></tr></tbody></table>

#### ShippingPackage &#x20;

Manage shipping-related information and packaging details with the ShippingPackage API, ensuring accurate shipping processes.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Facility</td><td>STRING</td></tr><tr><td>ShippingPackageNo</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>InvoiceCode</td><td>STRING</td></tr><tr><td>EWayBillNo</td><td>STRING</td></tr><tr><td>EWayBillDate</td><td>STRING</td></tr><tr><td>EWayBillValidTill</td><td>STRING</td></tr><tr><td>ShippingProvider</td><td>STRING</td></tr><tr><td>ShippingCourier</td><td>STRING</td></tr><tr><td>ShippingMethod</td><td>STRING</td></tr><tr><td>CashOnDelivery</td><td>STRING</td></tr><tr><td>ShippingAddressName</td><td>STRING</td></tr><tr><td>ShippingAddressLine1</td><td>STRING</td></tr><tr><td>ShippingAddressLine2</td><td>STRING</td></tr><tr><td>ShippingAddressCity</td><td>STRING</td></tr><tr><td>ShippingAddressState</td><td>STRING</td></tr><tr><td>ShippingAddressPincode</td><td>STRING</td></tr><tr><td>ShippingAddressPhone</td><td>STRING</td></tr><tr><td>PicklistNumber</td><td>STRING</td></tr><tr><td>SaleOrderCode</td><td>STRING</td></tr><tr><td>Zone</td><td>STRING</td></tr><tr><td>TrackingNumber</td><td>STRING</td></tr><tr><td>ActualWeight</td><td>STRING</td></tr><tr><td>ShippingCharges</td><td>STRING</td></tr><tr><td>CODCharges</td><td>STRING</td></tr><tr><td>AdditionalInfo</td><td>STRING</td></tr><tr><td>TotalPrice</td><td>STRING</td></tr><tr><td>NoOfItems</td><td>STRING</td></tr><tr><td>NoOfBoxes</td><td>STRING</td></tr><tr><td>PackingCost</td><td>STRING</td></tr><tr><td>PackageCode</td><td>STRING</td></tr><tr><td>Length</td><td>STRING</td></tr><tr><td>Width</td><td>STRING</td></tr><tr><td>Height</td><td>STRING</td></tr><tr><td>Created</td><td>STRING</td></tr><tr><td>DispatchTime</td><td>STRING</td></tr><tr><td>ShippingManifestCode</td><td>STRING</td></tr><tr><td>ReturnTime</td><td>STRING</td></tr><tr><td>ShipmentTracking</td><td>STRING</td></tr><tr><td>ProviderShipmentStatus</td><td>STRING</td></tr><tr><td>DeliveryTime</td><td>STRING</td></tr><tr><td>Updated</td><td>STRING</td></tr><tr><td>Channel</td><td>STRING</td></tr><tr><td>CollectableAmount</td><td>STRING</td></tr></tbody></table>

#### CourierReturnItemwise &#x20;

Track returns on a per-item basis with the CourierReturnItemwise API, providing detailed insights into return transactions.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Facility</td><td>STRING</td></tr><tr><td>SaleOrderNo</td><td>STRING</td></tr><tr><td>ShippingProvider</td><td>STRING</td></tr><tr><td>AWBNo</td><td>STRING</td></tr><tr><td>SaleOrderItem</td><td>STRING</td></tr><tr><td>SKUCode</td><td>STRING</td></tr><tr><td>ReturnDate</td><td>DATETIME</td></tr><tr><td>ReturnManifestCode</td><td>STRING</td></tr><tr><td>ReturnReason</td><td>STRING</td></tr><tr><td>ReturnStatus</td><td>STRING</td></tr><tr><td>InventoryType</td><td>STRING</td></tr><tr><td>PutawayComment</td><td>STRING</td></tr><tr><td>PutawayNo</td><td>STRING</td></tr></tbody></table>

#### ShelfwiseInventory &#x20;

Efficiently manage inventory by shelf location or storage area using the ShelfwiseInventory API, ensuring organized stock control.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Facility</td><td>STRING</td></tr><tr><td>ItemTypeSKUCode</td><td>STRING</td></tr><tr><td>ItemTypeName</td><td>STRING</td></tr><tr><td>InventoryType</td><td>STRING</td></tr><tr><td>Shelf</td><td>STRING</td></tr><tr><td>Quantity</td><td>STRING</td></tr><tr><td>QuantityBlocked</td><td>STRING</td></tr><tr><td>QuantityNotFound</td><td>STRING</td></tr><tr><td>QuantityDamaged</td><td>STRING</td></tr><tr><td>Priority</td><td>STRING</td></tr><tr><td>Section</td><td>STRING</td></tr><tr><td>BatchCode</td><td>STRING</td></tr><tr><td>Expiry</td><td>STRING</td></tr></tbody></table>

#### TallyGSTReport &#x20;

Generate comprehensive GST (Goods and Services Tax) reports for accounting and compliance purposes with the TallyGSTReport API.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Date</td><td>STRING</td></tr><tr><td>SaleOrderNumber</td><td>STRING</td></tr><tr><td>Invoicenumber</td><td>STRING</td></tr><tr><td>Channelentry</td><td>INTEGER</td></tr><tr><td>ChannelLedger</td><td>STRING</td></tr><tr><td>ProductName</td><td>STRING</td></tr><tr><td>ProductSKUCode</td><td>STRING</td></tr><tr><td>Qty</td><td>INTEGER</td></tr><tr><td>UnitPrice</td><td>NUMERIC</td></tr><tr><td>Currency</td><td>STRING</td></tr><tr><td>conversionrate</td><td>INTEGER</td></tr><tr><td>Total</td><td>INTEGER</td></tr><tr><td>CustomerName</td><td>STRING</td></tr><tr><td>ShippingAddressName</td><td>STRING</td></tr><tr><td>ShippingAddressLine1</td><td>INTEGER</td></tr><tr><td>ShippingAddressLine2</td><td>STRING</td></tr><tr><td>ShippingAddressCity</td><td>STRING</td></tr><tr><td>ShippingAddressState</td><td>STRING</td></tr><tr><td>ShippingAddressCountry</td><td>STRING</td></tr><tr><td>ShippingAddressPincode</td><td>STRING</td></tr><tr><td>ShippingAddressPhone</td><td>STRING</td></tr><tr><td>ShippingProvider</td><td>STRING</td></tr><tr><td>AWBnum</td><td>NUMERIC</td></tr><tr><td>Sales</td><td>NUMERIC</td></tr><tr><td>SalesLedger</td><td>STRING</td></tr><tr><td>CGST</td><td>INTEGER</td></tr><tr><td>CGSTRate</td><td>STRING</td></tr><tr><td>SGST</td><td>INTEGER</td></tr><tr><td>SGSTRate</td><td>STRING</td></tr><tr><td>IGST</td><td>NUMERIC</td></tr><tr><td>IGSTRate</td><td>STRING</td></tr><tr><td>UTGST</td><td>INTEGER</td></tr><tr><td>UTGSTRate</td><td>STRING</td></tr><tr><td>CESS</td><td>INTEGER</td></tr><tr><td>CESSRate</td><td>STRING</td></tr><tr><td>Othercharges</td><td>INTEGER</td></tr><tr><td>OtherchargesLedger</td><td>STRING</td></tr><tr><td>Othercharges1</td><td>INTEGER</td></tr><tr><td>OtherchargesLedger1</td><td>STRING</td></tr><tr><td>Servicetax</td><td>STRING</td></tr><tr><td>STLedger</td><td>STRING</td></tr><tr><td>DiscountLedger</td><td>STRING</td></tr><tr><td>DiscountAmount</td><td>INTEGER</td></tr><tr><td>IMEI</td><td>STRING</td></tr><tr><td>Godown</td><td>STRING</td></tr><tr><td>DispatchDate_CancellationDate</td><td>STRING</td></tr><tr><td>Narration</td><td>STRING</td></tr><tr><td>Entity</td><td>STRING</td></tr><tr><td>VoucherTypeName</td><td>STRING</td></tr><tr><td>TINNO</td><td>STRING</td></tr><tr><td>OriginalInvoiceDate</td><td>STRING</td></tr><tr><td>OriginalSaleNo</td><td>STRING</td></tr><tr><td>ChannelInvoiceCreated</td><td>STRING</td></tr><tr><td>ChannelState</td><td>STRING</td></tr><tr><td>CustomerGSTIN</td><td>STRING</td></tr><tr><td>Channel_PartyGSTIN</td><td>STRING</td></tr><tr><td>BillingPartyCode</td><td>STRING</td></tr><tr><td>TaxVerification</td><td>INTEGER</td></tr><tr><td>GSTRegistrationType</td><td>STRING</td></tr><tr><td>TCSAmount</td><td>INTEGER</td></tr><tr><td>AdjustmentInSellingPrice</td><td>INTEGER</td></tr><tr><td>AdjustmentInDiscount</td><td>INTEGER</td></tr><tr><td>OtherchargesLedger2</td><td>STRING</td></tr><tr><td>Othercharges2</td><td>INTEGER</td></tr><tr><td>StoreCredit</td><td>INTEGER</td></tr><tr><td>PrepaidAmount</td><td>INTEGER</td></tr><tr><td>TaxOnOtherCharges</td><td>INTEGER</td></tr><tr><td>TaxOnOtherCharges1</td><td>INTEGER</td></tr><tr><td>TaxOnOtherCharges2</td><td>INTEGER</td></tr><tr><td>IRN</td><td>STRING</td></tr><tr><td>AcknowledgementNumber</td><td>STRING</td></tr><tr><td>HSNCode</td><td>INTEGER</td></tr><tr><td>PaymentMethod</td><td>STRING</td></tr><tr><td>BillingAddressLine1</td><td>INTEGER</td></tr><tr><td>BillingAddressLine2</td><td>STRING</td></tr><tr><td>ISBN</td><td>STRING</td></tr><tr><td>BundleSKUCodeNumber</td><td>STRING</td></tr><tr><td>Facility</td><td>STRING</td></tr></tbody></table>

#### TallyCancelGSTReport &#x20;

The TallyCancelGSTReport API allows you to generate reports specifically for canceled GST transactions.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS

#### TallyReturnGSTReport&#x20;

Generate reports for GST returns and related transactions with the TallyReturnGSTReport API to ensure accurate tax compliance.

For more information, see the [Unicommerce API Documentation](https://documentation.unicommerce.com/docs/using-the-uniware-apis.html).

FIELDS
