Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Unicommerce connector and the associated fields and tables.

Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Unicommerce connector and the associated fields and tables.

Tables/APIs

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

Invoice
ReturnInvoices
ReversePickup
Putaway
Vendors
InventorySnapshot
VendorItemMaster
GRN
Gatepass
ItemMaster
PurchaseOrders
SaleOrders
ShippingPackage
CourierReturnItemwise
ShelfwiseInventory
TallyGSTReport
TallyCancelGSTReport
TallyReturnGSTReport

Invoice

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.

FIELDS

Field Name	Data Type
OrderNo	STRING
InvoiceNo	STRING
ShippingPackageCode	STRING
ShippingPackageStatusCode	STRING
InvoiceCreatedDate	STRING
ChannelInvoiceCreatedDate	STRING
CustomerName	STRING
SKUCode	STRING
SKUName	STRING
Quantity	STRING
InvoiceTax	STRING
InvoiceTotal	STRING
InvoiceCancelled	STRING
HSNCode	STRING
GSTTaxTypeCode	STRING
CGST	STRING
IGST	STRING
SGST	STRING
UTGST	STRING
CGSTRate	STRING
IGSTRate	STRING
SGSTRate	STRING
UTGSTRate	STRING
CESSRate	STRING
ShippingCharge	STRING
CODCharge	STRING
TCSAmount	STRING
ChannelName	STRING
UniwareInvoiceCode	STRING
Facility	STRING
EWayBillDate	STRING
EWayBillNo	STRING
EWayBillValidTill	STRING
TaxTypeCode	STRING
VAT	STRING
CST	STRING
AdditionalTax	STRING
AdditionalTaxPercentage	STRING
TaxPercentage	STRING
CESS	STRING

ReturnInvoices

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.

FIELDS

Field Name	Data Type
DisplayOrderCode	STRING
InvoiceCode	STRING
ReturnInvoiceCode	STRING
ShippingPackageCode	STRING
ShippingPackageStatusCode	STRING
ReturnDate	STRING
CustomerName	STRING
ItemSKUCode	STRING
ItemTypeName	STRING
Quantity	STRING
UnitPrice	STRING
CGST	STRING
IGST	STRING
SGST	STRING
UTGST	STRING
CESS	STRING
CGSTRate	STRING
IGSTRate	STRING
SGSTRate	STRING
UTGSTRate	STRING
CESSRate	STRING
Facility	STRING

ReversePickup

The ReversePickup API enables the management of reverse pickups, ensuring efficient handling of returned goods.
For more information, see the Unicommerce API Documentation.

FIELDS

Field Name	Data Type
SaleOrderItemCode	STRING
SaleOrderReceived	STRING
OriginalSaleOrderCode	STRING
ItemName	STRING
ItemSkuCode	STRING
ReversePickupNo	STRING
TrackingNo	STRING
DispatchedDate	STRING
ReferenceCode	STRING
BulkReturnId	STRING
ReversePickupCreated	STRING
ReversePickupLastUpdated	STRING
ReversePickupStatus	STRING
ReversePickupAction	STRING
ReturnReason	STRING
ReplacementSaleOrderCode	STRING
ChannelName	STRING
TotalReceivedItems	STRING
QCComment	STRING
ReversePickupCreatedBy	STRING
PutawayCode	STRING
PutawayCreatedBy	STRING
PutawayStatus	STRING
PutawayLastUpdated	STRING
CourierProviderName	STRING
Facility	STRING

Putaway

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.

FIELDS

Field Name	Data Type
PutawayItemId	STRING
ShelfCode	STRING
PutawayCode	STRING
Created	STRING
CreatedBy	STRING
Type	STRING
ItemTypeskuCode	STRING
Name	STRING
Category	STRING
PutawayQuantity	STRING
StatusCode	STRING
Updated	STRING
InventoryType	STRING
BatchCode	STRING
Facility	STRING

Vendors

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.

FIELDS

Field Name	Data Type
VendorCode	STRING
VendorName	STRING
PAN	STRING
TIN	STRING
Created	STRING
CSTNumber	STRING
ServiceTaxNumber	STRING
GSTNumber	STRING
Website	STRING
PrimaryContactName	STRING
PrimaryContactEmail	STRING
PrimaryContactPhone	STRING
ShippingAddressLine1	STRING
ShippingAddressLine2	STRING
ShippingAddressCity	STRING
ShippingAddressState	STRING
ShippingAddressPincode	STRING
ShippingAddressPhone	STRING
BillingAddressLine1	STRING
BillingAddressLine2	STRING
BillingAddressCity	STRING
BillingAddressState	STRING
BillingAddressPincode	STRING
BillingAddressPhone	STRING
PurchaseExpiryPeriod	STRING
AgreementName	STRING
AgreementStartTime	STRING
AgreementEndTime	STRING
AgreementText	STRING
AcceptsCForm	STRING
TaxExempted	STRING
RegisteredDealer	STRING
Username	STRING
Enabled	STRING
Updated	STRING
Facility	STRING

InventorySnapshot

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.

FIELDS

Field Name	Data Type
Facility	STRING
ItemTypeName	STRING
ItemSkuCode	STRING
Ean	STRING
UPC	STRING
ISBN	STRING
Color	STRING
Size	STRING
Brand	STRING
CategoryName	STRING
MRP	STRING
OpenSale	STRING
Inventory	STRING
InventoryBlocked	STRING
BadInventory	STRING
PutawayPending	STRING
PendingInventoryAssessment	STRING
StockInTransfer	STRING
OpenPurchase	STRING
Enabled	STRING
Updated	STRING
CostPrice	STRING

VendorItemMaster

Use the VendorItemMaster API to manage and maintain vendor-specific item details for streamlined procurement processes.
For more information, see the Unicommerce API Documentation.

FIELDS

Field Name	Data Type
Facility	STRING
ProductCode	STRING
ProductName	STRING
UnitPrice	STRING
Inventory	STRING
VendorCode	STRING
VendorSkuCode	STRING
LeadTime_inHours_	STRING
Priority	STRING
Enabled	STRING
Updated	STRING

GRN

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.

FIELDS

Field Name	Data Type
GRNCode	STRING
GRNDate	STRING
GRNCreatedBy	STRING
ItemSkuCode	STRING
ItemTypeName	STRING
ItemTypeColor	STRING
ItemTypeSize	STRING
ItemTypeBrand	STRING
Facility	STRING
Category	STRING
BatchCode	STRING
AdditionalCost	STRING
VendorSkuCode	STRING
VendorName	STRING
VendorCode	STRING
GRNInvoiceNo	STRING
GRNInvoiceDate	STRING
POCode	STRING
PODate	DATETIME
QuantityReceived	STRING
QuantityRejected	STRING
PercentageRejection	STRING
ValuesofGoodsReceivedwithouttaxes	STRING
ValuesofGoodsReceivedwithtaxes	STRING
ValuesofGoodsRejectedwithouttaxes	STRING
ValuesofGoodsRejectedwithtaxes	STRING
RejectionReason	STRING
GrnitemStatus	STRING
Updated	DATETIME
ExpiryDate	STRING

Gatepass

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.

FIELDS

Field Name	Data Type
GatepassCode	STRING
GatepassCreatedBy	STRING
Type	STRING
GatepassStatus	STRING
GatepassCreatedAt	STRING
GatepassUpdatedAt	STRING
Purpose	STRING
Reference	STRING
ToParty	STRING
ItemName	STRING
ItemSkuCode	STRING
Color	STRING
Size	STRING
Brand	STRING
HSNCode	STRING
UnitPrice	STRING
Quantity	STRING
ReceivedQuantity	STRING
InventoryType	STRING
GatepassItemStatus	STRING
Shelf	STRING
Reason	STRING
GatepassItemCreated	STRING
GatepassItemUpdated	STRING
GatepassOrderCode	STRING
Facility	STRING

ItemMaster

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.

FIELDS

Field Name	Data Type
CategoryCode	STRING
ProductCode	STRING
Name	STRING
Description	STRING
ScanIdentifier	STRING
RequiresCustomization	STRING
Length_mm_	STRING
Width_mm_	STRING
Height_mm_	STRING
Weight_gms_	STRING
EAN	STRING
UPC	STRING
ISBN	STRING
Color	STRING
Size	STRING
Brand	STRING
ItemDetailFields	STRING
Tags	STRING
ImageUrl	STRING
ProductPageUrl	STRING
TaxTypeCode	STRING
GSTTaxTypeCode	STRING
BasePrice	STRING
CostPrice	STRING
TAT	STRING
MRP	STRING
Updated	STRING
CategoryName	STRING
Enabled	STRING
Type	STRING
ComponentProductCode	STRING
ComponentQuantity	STRING
ComponentPrice	STRING
HSNCODE	STRING
TaxCalculationType	STRING
BatchGroup	STRING
GRNexpirytolerance_inDays_	STRING
Dispatchexpirytolerance_inDays_	STRING
Returnexpirytolerance_inDays_	STRING
Expirable	STRING
DetermineExpiryFrom	STRING
ShelfLife	STRING
ExpiryDate	STRING
Facility	STRING

PurchaseOrders

Create, manage, and track purchase orders with the PurchaseOrders API, streamlining your procurement processes.
For more information, see the Unicommerce API Documentation.

FIELDS

Field Name	Data Type
POCode	STRING
Created	STRING
POCreatedBy	STRING
POApprovedDate	STRING
DeliveryDate	STRING
ItemTypeName	STRING
ItemSkuCode	STRING
Category	STRING
HSNCode	STRING
GSTTaxTypeCode	STRING
VendorName	STRING
VendorCode	STRING
VendorSkuCode	STRING
OrderQuantity	STRING
RecievedQuantity	STRING
RejectedQuantity	STRING
PendingQuantity	STRING
_Pending	STRING
_Rejection	STRING
Facility	STRING
SubTotal	STRING
CGST	STRING
IGST	STRING
SGST	STRING
UTGST	STRING
CESS	STRING
CGSTRate	STRING
IGSTRate	STRING
SGSTRate	STRING
UTGSTRate	STRING
CESSRate	STRING
Total	STRING
PurchaseOrderStatus	STRING
RejectionReason	STRING
Updated	STRING
Type	STRING
POAgeing_Days_	STRING
UnitPrice	STRING

SaleOrders

The SaleOrders API facilitates the creation, management, and tracking of sales orders for efficient order fulfillment.
For more information, see the Unicommerce API Documentation.

FIELDS

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

ShippingPackage

Manage shipping-related information and packaging details with the ShippingPackage API, ensuring accurate shipping processes.
For more information, see the Unicommerce API Documentation.

FIELDS

Field Name	Data Type
Facility	STRING
ShippingPackageNo	STRING
Status	STRING
InvoiceCode	STRING
EWayBillNo	STRING
EWayBillDate	STRING
EWayBillValidTill	STRING
ShippingProvider	STRING
ShippingCourier	STRING
ShippingMethod	STRING
CashOnDelivery	STRING
ShippingAddressName	STRING
ShippingAddressLine1	STRING
ShippingAddressLine2	STRING
ShippingAddressCity	STRING
ShippingAddressState	STRING
ShippingAddressPincode	STRING
ShippingAddressPhone	STRING
PicklistNumber	STRING
SaleOrderCode	STRING
Zone	STRING
TrackingNumber	STRING
ActualWeight	STRING
ShippingCharges	STRING
CODCharges	STRING
AdditionalInfo	STRING
TotalPrice	STRING
NoOfItems	STRING
NoOfBoxes	STRING
PackingCost	STRING
PackageCode	STRING
Length	STRING
Width	STRING
Height	STRING
Created	STRING
DispatchTime	STRING
ShippingManifestCode	STRING
ReturnTime	STRING
ShipmentTracking	STRING
ProviderShipmentStatus	STRING
DeliveryTime	STRING
Updated	STRING
Channel	STRING
CollectableAmount	STRING

CourierReturnItemwise

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.

FIELDS

Field Name	Data Type
Facility	STRING
SaleOrderNo	STRING
ShippingProvider	STRING
AWBNo	STRING
SaleOrderItem	STRING
SKUCode	STRING
ReturnDate	DATETIME
ReturnManifestCode	STRING
ReturnReason	STRING
ReturnStatus	STRING
InventoryType	STRING
PutawayComment	STRING
PutawayNo	STRING

ShelfwiseInventory

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.

FIELDS

Field Name	Data Type
Facility	STRING
ItemTypeSKUCode	STRING
ItemTypeName	STRING
InventoryType	STRING
Shelf	STRING
Quantity	STRING
QuantityBlocked	STRING
QuantityNotFound	STRING
QuantityDamaged	STRING
Priority	STRING
Section	STRING
BatchCode	STRING
Expiry	STRING

TallyGSTReport

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.

FIELDS

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

TallyCancelGSTReport

The TallyCancelGSTReport API allows you to generate reports specifically for canceled GST transactions.
For more information, see the Unicommerce API Documentation.

FIELDS

TallyReturnGSTReport

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.

FIELDS

Table of Contents

Tables/APIs Invoice

Schema Information

Saras Pulse

Saras Daton