MIXERP Database Documentation Database Schemas Tables Sequences Triggers Views MatViews Functions Types
Table transactions.stock_master_non_gl_relations
This table stores information of Non GL Stock Transactions such as orders and quotations which were upgraded to deliveries or invoices.
# Column Name Nullable Data Type Max Length Description
1stock_master_non_gl_relation_idbigint0
2stock_master_idbigint0
3non_gl_stock_master_idbigint0

Foreign Keys

# Column Name Key Name References
2 stock_master_id stock_master_non_gl_relations_stock_master_id_fkey transactions.stock_master.stock_master_id
3 non_gl_stock_master_id stock_master_non_gl_relations_non_gl_stock_master_id_fkey transactions.non_gl_stock_master.non_gl_stock_master_id

Indices

Index Name Owner Access Method Definition Description
stock_master_non_gl_relations_pkey postgres btree stock_master_non_gl_relation_id

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
1 stock_master_non_gl_relation_id nextval('transactions.stock_master_non_gl_relations_stock_master_non_gl_relation__seq'::regclass)

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description