MIXERP-Table transactions.non_gl_stock_master

#	Column Name	Nullable	Data Type	Max Length	Description
1	non_gl_stock_master_id		bigint	0	The primary key of this table, which is also a serial field.
2	value_date		date	0
3	book		character varying	48
4	party_id		bigint	0
5	price_type_id		integer	0
6	transaction_ts		timestamp with time zone	0
7	login_id		bigint	0	Foreign key to the table audit.logins.
8	user_id		integer	0	Foreign key to the table office.users.
9	office_id		integer	0	Foreign key to the table office.offices.
10	reference_number		character varying	24
11	statement_reference		text	0
12	non_taxable		boolean	0
13	salesperson_id		integer	0	Foreign key to the table core.salespersons.
14	shipper_id		integer	0	Foreign key to the table core.shippers.
15	shipping_address_id		bigint	0	Foreign key to the table core.shipping_addresses.
16	shipping_charge		money_strict2	0
17	store_id		integer	0	Foreign key to the table office.stores.
18	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
19	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
4	party_id	non_gl_stock_master_party_id_fkey	core.parties.party_id
5	price_type_id	non_gl_stock_master_price_type_id_fkey	core.price_types.price_type_id
7	login_id	non_gl_stock_master_login_id_fkey	audit.logins.login_id
8	user_id	non_gl_stock_master_user_id_fkey	office.users.user_id
9	office_id	non_gl_stock_master_office_id_fkey	office.offices.office_id
13	salesperson_id	non_gl_stock_master_salesperson_id_fkey	core.salespersons.salesperson_id
14	shipper_id	non_gl_stock_master_shipper_id_fkey	core.shippers.shipper_id
15	shipping_address_id	non_gl_stock_master_shipping_address_id_fkey	core.shipping_addresses.shipping_address_id
17	store_id	non_gl_stock_master_store_id_fkey	office.stores.store_id
18	audit_user_id	non_gl_stock_master_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
non_gl_stock_master_pkey	postgres	btree	non_gl_stock_master_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	non_gl_stock_master_id	nextval('transactions.non_gl_stock_master_non_gl_stock_master_id_seq'::regclass)
6	transaction_ts	now()
12	non_taxable	false
16	shipping_charge	0
19	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description