#	Column Name	Nullable	Data Type	Max Length	Description
1	stock_master_id		bigint	0
2	transaction_master_id		bigint	0
3	value_date		date	0
4	party_id		bigint	0
5	salesperson_id		integer	0
6	price_type_id		integer	0
7	is_credit		boolean	0
8	payment_term_id		integer	0
9	shipper_id		integer	0
10	shipping_address_id		bigint	0
11	shipping_charge		money_strict2	0
12	store_id		integer	0
13	non_taxable		boolean	0
14	cash_repository_id		integer	0
15	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
16	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
2	transaction_master_id	stock_master_transaction_master_id_fkey	transactions.transaction_master.transaction_master_id
4	party_id	stock_master_party_id_fkey	core.parties.party_id
5	salesperson_id	stock_master_salesperson_id_fkey	core.salespersons.salesperson_id
6	price_type_id	stock_master_price_type_id_fkey	core.price_types.price_type_id
8	payment_term_id	stock_master_payment_term_id_fkey	core.payment_terms.payment_term_id
9	shipper_id	stock_master_shipper_id_fkey	core.shippers.shipper_id
10	shipping_address_id	stock_master_shipping_address_id_fkey	core.shipping_addresses.shipping_address_id
12	store_id	stock_master_store_id_fkey	office.stores.store_id
14	cash_repository_id	stock_master_cash_repository_id_fkey	office.cash_repositories.cash_repository_id
15	audit_user_id	stock_master_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
stock_master_pkey	postgres	btree	stock_master_id
stock_master_transaction_master_id_uix	postgres	btree	transaction_master_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	stock_master_id	nextval('transactions.stock_master_stock_master_id_seq'::regclass)
7	is_credit	false
11	shipping_charge	0
13	non_taxable	false
16	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
transactions.verify_stock_master_integrity_trigger_after_update	transactions.verify_stock_master_integrity_trigger	UPDATE	AFTER		0	ROW
transactions.verify_stock_master_integrity_trigger_after_insert	transactions.verify_stock_master_integrity_trigger	INSERT	AFTER		0	ROW
transactions.restrict_delete_trigger	transactions.restrict_delete_trigger	DELETE	BEFORE		0	ROW