Unicommerce

Explore the interactive ERD

Table & Field Reference

inflow_receipt_item

Column	Type	Keys
`id`	Unknown	PK
`grn_code`	Unknown	PKFK
`item_sku`	Unknown	FK
`purchase_order_item_id`	Unknown	FK
`additional_cost`	Unknown
`batch_code`	Unknown
`batch_dto`	Unknown
`detailed_quantity`	Unknown
`determine_expiry_from`	Unknown
`discount`	Unknown
`discount_percentage`	Unknown
`expirable`	Unknown
`expiry`	Unknown
`grn_expiry_tolerance`	Unknown
`item_type_image_url`	Unknown
`item_type_name`	Unknown
`item_type_page_url`	Unknown
`items_labelled`	Unknown
`manufacturing_date`	Unknown
`max_retail_price`	Unknown
`pending_quantity`	Unknown
`quantity`	Unknown
`rejected_quantity`	Unknown
`rejection_comment`	Unknown
`scan_identifier`	Unknown
`shelf_life`	Unknown
`status`	Unknown
`unit_price`	Unknown
`vendor_sku_code`	Unknown

grn_custom_field_value

Column	Type	Keys
`index`	Unknown	PK
`grn_code`	Unknown	PKFK
`display_name`	Unknown
`field_name`	Unknown
`field_value`	Json
`possible_value`	Json
`required`	Unknown
`value_type`	Unknown

grn

Column	Type	Keys
`code`	Unknown	PK
`purchase_order_code`	Unknown	FK
`asn_code`	Unknown
`created`	Unknown
`created_by`	Unknown
`facility`	Unknown
`purchase_order_approved`	Unknown
`purchase_order_vendor_code`	Unknown
`status_code`	Unknown
`total_quantity`	Unknown
`total_received_amount`	Unknown
`total_rejected_amount`	Unknown
`total_rejected_quantity`	Unknown
`vendor_invoice_date`	Unknown
`vendor_invoice_number`	Unknown

sale_order_custom_field_value

Column	Type	Keys
`index`	Unknown	PK
`sale_order_code`	Unknown	PKFK
`display_name`	Unknown
`field_name`	Unknown
`field_value`	Unknown
`possible_value`	Unknown
`required`	Unknown
`value_type`	Unknown

sale_order_return

Column	Type	Keys
`code`	Unknown	PK
`sale_order_code`	Unknown	PKFK
`action_code`	Unknown
`putaway_code`	Unknown
`return_invoice_code`	Unknown
`return_invoice_display_code`	Unknown
`shipping_provider`	Unknown
`status_code`	Unknown
`tracking_number`	Unknown
`type`	Unknown

sale_order_item

Column	Type	Keys
`id`	Unknown	PK
`sale_order_code`	Unknown	PKFK
`reverse_pickup_code`	Unknown	FK
`shipping_address_id`	Unknown	FK
`shipping_package_code`	Unknown	FK
`alternate_facility_code`	Unknown
`batch_dto`	Unknown
`brand`	Unknown
`bundle_sku_code`	Unknown
`cancellable`	Unknown
`cancellation_reason`	Unknown
`cancelled_by_seller`	Unknown
`cash_on_delivery_charge`	Unknown
`central_gst_percentage`	Unknown
`channel_expiry_date`	Unknown
`channel_mfd`	Unknown
`channel_mrp`	Unknown
`channel_sale_order_item_code`	Unknown
`channel_vendor_batch_number`	Unknown
`code`	Unknown
`color`	Unknown
`combination_description`	Unknown
`combination_identifier`	Unknown
`country_of_origin`	Unknown
`created`	Unknown
`custom_field_value`	Unknown
`discount`	Unknown
`edit_address`	Unknown
`effective_tolerance`	Unknown
`expected_delivery_date`	Unknown
`facility_code`	Unknown
`facility_name`	Unknown
`gift_message`	Unknown
`gift_wrap`	Unknown
`gift_wrap_charge`	Unknown
`hsn_code`	Unknown
`image_url`	Unknown
`integrated_gst_percentage`	Unknown
`item`	Unknown
`item_detail_field`	Unknown
`item_detail_field_dto_list`	Unknown
`item_name`	Unknown
`item_sku`	Unknown
`max_retail_price`	Unknown
`on_hold`	Unknown
`packet_configurable`	Unknown
`packet_number`	Unknown
`page_url`	Unknown
`prepaid_amount`	Unknown
`replacement_sale_order_code`	Unknown
`reverse_pickable`	Unknown
`sale_order_item_alternate_id`	Unknown
`selling_price`	Unknown
`selling_price_without_taxes_and_discount`	Unknown
`shelf_code`	Unknown
`shipping_charge`	Unknown
`shipping_charge_tax_percentage`	Unknown
`shipping_method_charge`	Unknown
`shipping_method_code`	Unknown
`shipping_package_status`	Unknown
`size`	Unknown
`state_gst_percentage`	Unknown
`status_code`	Unknown
`store_credit`	Unknown
`tax_percentage`	Unknown
`tcs`	Unknown
`total_central_gst`	Unknown
`total_integrated_gst`	Unknown
`total_price`	Unknown
`total_state_gst`	Unknown
`total_union_territory_gst`	Unknown
`type`	Unknown
`uc_batch_code`	Unknown
`union_territory_gst_percentage`	Unknown
`updated`	Unknown
`voucher_code`	Unknown
`voucher_value`	Unknown

shipping_package_item

Column	Type	Keys
`item_sku`	Unknown	PK
`sale_order_shipping_package_code`	Unknown	PKFK
`item_name`	Unknown
`quantity`	Unknown

sale_order_shipping_package

Column	Type	Keys
`code`	Unknown	PK
`sale_order_code`	Unknown	FK
`actual_weight`	Unknown
`channel`	Unknown
`channel_shipment_code`	Unknown
`city`	Unknown
`collectable_amount`	Unknown
`collected_amount`	Unknown
`courier_status`	Unknown
`created`	Unknown
`custom_field_value`	Unknown
`customer`	Unknown
`delivered`	Unknown
`dispatched`	Unknown
`estimated_weight`	Unknown
`invoice`	Unknown
`invoice_code`	Unknown
`invoice_date`	Unknown
`invoice_display_code`	Unknown
`irn`	Unknown
`no_of_item`	Unknown
`payment_reconciled`	Unknown
`pod_code`	Unknown
`shipping_courier`	Unknown
`shipping_label_link`	Unknown
`shipping_manifest_code`	Unknown
`shipping_method`	Unknown
`shipping_package_type`	Unknown
`shipping_provider`	Unknown
`status`	Unknown
`tracking_number`	Unknown
`tracking_status`	Unknown
`updated`	Unknown

sale_order_address

Column	Type	Keys
`id`	Unknown	PK
`sale_order_code`	Unknown	PKFK
`address_line_1`	Unknown
`address_line_2`	Unknown
`city`	Unknown
`country`	Unknown
`district`	Unknown
`email`	Unknown
`name`	Unknown
`phone`	Unknown
`pincode`	Unknown
`state`	Unknown
`type`	Unknown

sale_order

Column	Type	Keys
`code`	Unknown	PK
`additional_info`	Unknown
`amount_paid`	Unknown
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_district`	Unknown
`billing_address_email`	Unknown
`billing_address_id`	Unknown
`billing_address_line_1`	Unknown
`billing_address_line_2`	Unknown
`billing_address_name`	Unknown
`billing_address_phone`	Unknown
`billing_address_pincode`	Unknown
`billing_address_state`	Unknown
`billing_address_type`	Unknown
`c_form_provided`	Unknown
`cancellable`	Unknown
`channel`	Unknown
`channel_processing_time`	Unknown
`cod`	Unknown
`created`	Unknown
`currency_code`	Unknown
`customer_code`	Unknown
`customer_gstin`	Unknown
`display_order_code`	Unknown
`display_order_date_time`	Unknown
`fulfillment_tat`	Unknown
`notification_email`	Unknown
`notification_mobile`	Unknown
`packet_configurable`	Unknown
`payment_detail`	Unknown
`payment_instrument`	Unknown
`payment_mode`	Unknown
`priority`	Unknown
`reverse_pickable`	Unknown
`sale_order_metadata`	Json
`source`	Unknown
`status`	Unknown
`third_party_shipping`	Unknown
`total_discount`	Unknown
`total_shipping_charge`	Unknown
`transaction_id`	Unknown
`updated`	Unknown

gate_pass_item_dto

Column	Type	Keys
`item_type_sku`	Unknown	PK
`gate_pass_code`	Unknown	PKFK
`inflow_receipt_code`	Unknown	FK
`batch_dto`	Unknown
`central_gst_percentage`	Unknown
`compensation_cess_percentage`	Unknown
`gate_pass_item_id`	Unknown
`gate_pass_item_status`	Unknown
`hsn_code`	Unknown
`integrated_gst_percentage`	Unknown
`inventory_type`	Unknown
`item_code`	Unknown
`item_condition`	Unknown
`item_status`	Unknown
`item_type_image_url`	Unknown
`item_type_name`	Unknown
`item_type_page_url`	Unknown
`pending_quantity`	Unknown
`quantity`	Unknown
`reason`	Unknown
`received_quantity`	Unknown
`shelf_code`	Unknown
`state_gst_percentage`	Unknown
`tax_percentage`	Unknown
`total`	Unknown
`union_territory_gst_percentage`	Unknown
`unit_price`	Unknown

gate_pass

Column	Type	Keys
`code`	Unknown	PK
`created`	Unknown
`custom_field_value`	Json
`gate_pass_order_code`	Unknown
`id`	Unknown
`invoice_code`	Unknown
`invoice_display_code`	Unknown
`purpose`	Unknown
`reference`	Unknown
`return_invoice_code`	Unknown
`return_invoice_display_code`	Unknown
`status_code`	Unknown
`to_party_name`	Unknown
`type`	Unknown
`updated`	Unknown
`username`	Unknown

inventory_snapshot

Column	Type	Keys
`item_type_sku`	Unknown	PK
`inventory`	Unknown
`inventory_blocked`	Unknown
`open_purchase`	Unknown
`open_sale`	Unknown
`pending_inventory_assessment`	Unknown
`pending_stock_transfer`	Unknown
`putaway_pending`	Unknown
`vendor_inventory`	Unknown
`virtual_inventory`	Unknown

rto_sale_order_item

Column	Type	Keys
`sku_code`	Unknown	PK
`shipment_code`	Unknown	PKFK
`sale_order_code`	Unknown	FK
`channel_product_id`	Unknown
`courier_status`	Unknown
`inventory_type`	Unknown
`item_name`	Unknown
`marketplace_return_reason`	Unknown
`putaway_qc_comment`	Unknown
`sale_order_item_code`	Unknown
`tracking_status`	Unknown

purchase_order_custom_field_value

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`display_name`	Unknown
`field_name`	Unknown
`field_value`	Json
`possible_value`	Json
`required`	Unknown
`value_type`	Unknown

purchase_order_item

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`item_sku`	Unknown	FK
`asn_pending_quantity`	Unknown
`batch_group_code`	Unknown
`central_gst_percentage`	Unknown
`custom_field_value`	Json
`determine_expiry_from`	Unknown
`discount`	Unknown
`discount_percentage`	Unknown
`expirable`	Unknown
`grn_expiry_tolerance`	Unknown
`integrated_gst_percentage`	Unknown
`item_type_custom_field`	Json
`item_type_id`	Unknown
`logistic_charge`	Unknown
`max_retail_price`	Unknown
`pending_quantity`	Unknown
`quantity`	Unknown
`rejected_quantity`	Unknown
`shelf_life`	Unknown
`state_gst_percentage`	Unknown
`sub_total`	Unknown
`tax`	Unknown
`tax_percentage`	Unknown
`tax_type`	Unknown
`total`	Unknown
`total_central_gst`	Unknown
`total_integrated_gst`	Unknown
`total_state_gst`	Unknown
`total_union_territory_gst`	Unknown
`union_territory_gst_percentage`	Unknown
`unit_price`	Unknown

purchase_order

Column	Type	Keys
`id`	Unknown	PK
`amended_purchase_order_code`	Unknown
`amendment_purchase_order_code`	Unknown
`code`	Unknown
`created`	Unknown
`created_by`	Unknown
`delivery_date`	Unknown
`expiry_date`	Unknown
`from_party`	Unknown
`inflow_receipts_count`	Unknown
`logistic_charge`	Unknown
`logistic_charges_division_method`	Unknown
`name`	Unknown
`party_address_dto_address_line_1`	Unknown
`party_address_dto_address_line_2`	Unknown
`party_address_dto_address_type`	Unknown
`party_address_dto_address_type_name`	Unknown
`party_address_dto_city`	Unknown
`party_address_dto_country_code`	Unknown
`party_address_dto_email`	Unknown
`party_address_dto_enabled`	Unknown
`party_address_dto_phone`	Unknown
`party_address_dto_pincode`	Unknown
`party_address_dto_state_code`	Unknown
`party_address_dto_state_name`	Unknown
`price_summary_currency_code`	Unknown
`price_summary_discount`	Unknown
`price_summary_logistic_charge`	Unknown
`price_summary_sub_total_before_taxes_and_discount`	Unknown
`price_summary_tax_on_sale`	Unknown
`price_summary_tcs_amount`	Unknown
`price_summary_total_amount`	Unknown
`price_summary_total_item`	Unknown
`rejection_reason`	Unknown
`status_code`	Unknown
`tcs_addition_enabled`	Unknown
`tcs_amount`	Unknown
`type`	Unknown
`vendor_agreement_name`	Unknown
`vendor_code`	Unknown
`vendor_id`	Unknown
`vendor_name`	Unknown

cir_sale_order_item

Column	Type	Keys
`sku_code`	Unknown	PK
`reverse_pickup_code`	Unknown	PKFK
`sale_order_code`	Unknown	FK
`shipment_code`	Unknown	FK
`channel_product_id`	Unknown
`courier_status`	Unknown
`inventory_type`	Unknown
`item_name`	Unknown
`marketplace_return_reason`	Unknown
`putaway_qc_comment`	Unknown
`sale_order_item_code`	Unknown
`tracking_status`	Unknown