Home Daton Documentation Blog

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

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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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 NameData 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

PreviousHow to Integrate Unicommerce with DatonNextRelease Notes

Last updated