MIXERP-Table transactions.customer_receipts

#	Column Name	Nullable	Data Type	Max Length	Description
1	receipt_id		bigint	0	The primary key of this table, which is also a bigserial field.
2	transaction_master_id		bigint	0	Foreign key to the table transactions.transaction_master.
3	party_id		bigint	0	Foreign key to the table core.parties.
4	currency_code		character varying	12	Foreign key to the table core.currencies.
5	amount		money_strict	0	Amount received from the customer.
6	er_debit		decimal_strict	0
7	er_credit		decimal_strict	0
8	cash_repository_id		integer	0	The id of the cash repository used.
9	posted_date		date	0	The date on which the transaction was posted.
10	bank_account_id		bigint	0	Foreign key to the table core.bank_accounts.
11	bank_instrument_code		character varying	128	Code of the cheque received.
12	bank_tran_code		character varying	128	The transaction code while the cheque is received.

Foreign Keys

#	Column Name	Key Name	References
2	transaction_master_id	customer_receipts_transaction_master_id_fkey	transactions.transaction_master.transaction_master_id
3	party_id	customer_receipts_party_id_fkey	core.parties.party_id
4	currency_code	customer_receipts_currency_code_fkey	core.currencies.currency_code
8	cash_repository_id	customer_receipts_cash_repository_id_fkey	office.cash_repositories.cash_repository_id
10	bank_account_id	customer_receipts_bank_account_id_fkey	core.bank_accounts.account_id

Indices

Index Name	Owner	Access Method	Definition	Description
customer_receipts_pkey	postgres	btree	receipt_id
customer_receipts_posted_date_inx	postgres	btree	posted_date
customer_receipts_cash_repository_id_inx	postgres	btree	cash_repository_id
customer_receipts_bank_account_id_inx	postgres	btree	bank_account_id
customer_receipts_party_id_inx	postgres	btree	party_id
customer_receipts_transaction_master_id_inx	postgres	btree	transaction_master_id
customer_receipts_currency_code_inx	postgres	btree	currency_code

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	receipt_id	nextval('transactions.customer_receipts_receipt_id_seq'::regclass)
11	bank_instrument_code	''::character varying
12	bank_tran_code	''::character varying

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description