Schema Information

Need help with something?

Talk to data expert

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.
descriptor data structure

Related Articles

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