Schema Information

Structured details and metadata about the UniCommerce connector and its corresponding tables and fields.

Bundle_SB_Tally_Return_GST_Report

Field Name	Data Type	Description
SaleOrderID	int	Unique identifier for the sale order
ReturnDate	datetime	Date when the return was processed
GSTAmount	decimal	GST amount applicable on the returned items
TaxType	string	Type of tax applied (e.g., CGST, SGST)
CreatedAt	datetime	Timestamp when the record was created
UpdatedAt	datetime	Timestamp when the record was last updated

Table Description: Captures GST return details for sales orders including return-specific tax data.

Purchase_orders

Field Name	Data Type	Description
PurchaseOrderID	int	Unique identifier for the purchase order
VendorID	int	Reference to the vendor
OrderDate	datetime	Date when the purchase order was created
TotalAmount	decimal	Total monetary value of the purchase order
Status	string	Current status of the order (e.g., Pending)
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Contains data on procurement transactions between business and vendors.

Sale_Orders_Report

Field Name	Data Type	Description
SaleOrderID	int	Unique identifier for the sale order
OrderDate	datetime	Date the sale order was placed
CustomerID	int	Identifier for the customer
TotalAmount	decimal	Total value of the sale order
PaymentStatus	string	Status of the payment (e.g., Paid, Unpaid)
ShippingStatus	string	Delivery/shipping progress
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Tracks customer sale orders, including payment and delivery information.

Shipping_Package

Field Name	Data Type	Description
PackageID	int	Unique identifier for the package
SaleOrderID	int	Associated sale order
ShippedDate	datetime	Date the package was shipped
CourierName	string	Name of the courier handling the delivery
TrackingNumber	string	Tracking number assigned by the courier
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Contains information on shipping packages, including courier and tracking details.

Invoice

Field Name	Data Type	Description
InvoiceID	int	Unique identifier for the invoice
SaleOrderID	int	Linked sale order identifier
InvoiceDate	datetime	Date of invoice issuance
TotalAmount	decimal	Total invoice amount
GSTAmount	decimal	GST included in the invoice
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Holds details of generated invoices related to sales orders, including tax data.

Return_Invoice

Field Name	Data Type	Description
ReturnInvoiceID	int	Unique ID for the return invoice
SaleOrderID	int	Linked sale order
ReturnDate	datetime	Date the return was processed
ReturnAmount	decimal	Monetary value of the returned items
GSTAmount	decimal	Tax refund component of the return
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Documents invoice adjustments for returned sales items.

Reverse_pickup

Field Name	Data Type	Description
PickupID	int	Unique identifier for the reverse pickup
SaleOrderID	int	Related sale order
PickupDate	datetime	Date when pickup was initiated
PickupStatus	string	Status of the reverse pickup
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Logs the reverse logistics process for returned customer shipments.

Putaway

Field Name	Data Type	Description
PutawayID	int	Unique identifier for the putaway action
ItemID	int	Item being placed in storage
PutawayDate	datetime	Date the item was shelved
ShelfLocation	string	Storage location within the warehouse
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Captures warehouse storage events for received or returned products.

Vendor_Item_Master

Field Name	Data Type	Description
VendorItemID	int	Unique ID for vendor's product record
VendorID	int	Linked vendor identifier
ProductID	int	Related item in the master catalog
VendorSKU	string	SKU as assigned by the vendor
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Tracks vendor-specific SKUs linked to catalog products.

Gatepass

Field Name	Data Type	Description
GatepassID	int	Unique ID for the gatepass
SaleOrderID	int	Linked sale order
GatepassDate	datetime	Date the gatepass was issued
Destination	string	Final destination of the goods
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Manages permissions for goods leaving the warehouse or premises.

Courier_Return_Itemwise

Field Name	Data Type	Description
ReturnID	int	Unique return identifier
SaleOrderID	int	Associated sale order
ItemID	int	Item being returned
ReturnDate	datetime	Date the return was initiated
CourierName	string	Name of the courier handling the return
TrackingNumber	string	Courier-provided tracking number
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Logs item-level returns managed through couriers, including tracking details.

Shelfwise_Inventory

Field Name	Data Type	Description
ShelfID	int	Unique identifier for the shelf
ProductID	int	Product stored on the shelf
Quantity	int	Quantity available on the shelf
ShelfLocation	string	Physical location code of the shelf
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Tracks real-time inventory distribution across storage shelves in a warehouse.

Tally_Cancel_GST_Report

Field Name	Data Type	Description
SaleOrderID	int	Sale order related to the cancelled GST entry
CancelDate	datetime	Date when the GST was cancelled
GSTAmount	decimal	GST value that was reversed
TaxType	string	Type of GST (CGST, SGST, etc.)
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Records cancelled GST entries from sale transactions.

Picklist_Export

Field Name	Data Type	Description
PicklistID	int	Unique identifier for the picklist
SaleOrderID	int	Sale order linked to the picklist
PicklistDate	datetime	Date when the picklist was generated
Status	string	Current status of the picklist
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Used for tracking items that need to be picked for order fulfillment.

Tally_GST_Report

Field Name	Data Type	Description
SaleOrderID	int	Sale order involved in the transaction
InvoiceDate	datetime	Date of the invoice
GSTAmount	decimal	GST charged on the transaction
TaxType	string	Type of tax applied
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Contains GST reporting data for Tally integration from invoiced sales.

Tally_Return_GST_Report

Field Name	Data Type	Description
SaleOrderID	int	Returned sale order linked to GST report
ReturnDate	datetime	Date of the return
GSTAmount	decimal	Refunded GST amount
TaxType	string	GST category for the return
CreatedAt	datetime	Record creation timestamp
UpdatedAt	datetime	Record update timestamp

Table Description: Compiles GST-related information for product returns for accounting and Tally.

Table of Contents

Bundle_SB_Tally_Return_GST_Report Purchase_orders Sale_Orders_Report Shipping_Package Invoice Return_Invoice Reverse_pickup Putaway Vendor_Item_Master Gatepass Courier_Return_Itemwise Shelfwise_Inventory Tally_Cancel_GST_Report Picklist_Export Tally_GST_Report Tally_Return_GST_Report

Schema Information

Saras Pulse

Saras Daton