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