Create
Query
branch.sqlite
—
local_inventory_docum...
__EFMigrationsHistory
__EFMigrationsLock
local_audit_log
local_branch_info
local_cash_movements
local_cash_register_s...
local_cash_registers
local_categories
local_check_adjustments
local_check_lines
local_check_status_history
local_checks
local_discount_reasons
local_inventory_docum...
local_inventory_documents
local_payment_lines
local_pos_devices
local_pos_shifts
local_products
local_recipe_lines
local_recipes
local_service_areas
local_service_tables
local_stock
local_stock_movements
local_terminal_transa...
local_units_of_measure
local_users
local_warehouses
sync_inbox
sync_log
sync_outbox
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into local_inventory_document_lines
Id
Primary key.
TEXT NOT NULL
DocumentId
TEXT NOT NULL
LocalProductId
TEXT NOT NULL
UnitId
TEXT NOT NULL
Quantity
DECIMAL(18,4) NOT NULL
ActualQuantity
DECIMAL(18,4)
UnitCostMinor
INTEGER
Notes
TEXT
CreatedAt
TEXT NOT NULL
UpdatedAt
TEXT NOT NULL
IsDeleted
INTEGER NOT NULL
DeletedAt
TEXT
Insert
Cancel