Feature #390
openCorporate Receipt
60%
Subtasks
Related issues
Updated by Arathy PS 4 months ago
GUI CHANGE
--------------------------------
1. Add a new label Approval status (blue star): empty, approved --- > at original receipt no: place (move it to right)
2. Add title 'approval done from agency side'
3.Status:- [Use same value same as document approval]
Need Agency Approve
Agency Approved
Rejected
Db Implimentation:
1. Create new flat table for temporary storage.
Updated by Anil KV 3 months ago
Tables:-
CREATE TABLE corporate.tbl_corporate_receipt (
pk_corporate_receipt_id BIGSERIAL PRIMARY KEY,
fk_documents_id BIGINT NOT NULL REFERENCES document.tbl_documents(pk_documents_id),
--Master
vhr_payee_name VARCHAR(200) DEFAULT '',
vhr_payee_contact VARCHAR(200) DEFAULT '',
--Mode
fk_dr_account_id BIGINT NOT NULL REFERENCES accounts.tbl_account(pk_account_id),
sin_mod_of_receipt_type SMALLINT NOT NULL,-- check receipt.tbl_mod_of_receipt
vhr_reference VARCHAR(100),
jsn_mode_details JSON, --*2 Cheque, Card, etc data -> all keys enter below
vhr_ledg_dr_currency VARCHAR(3) NOT NULL,
dbl_ledg_dr_cur_roe DOUBLE PRECISION DEFAULT 1.00,
dbl_ledg_dr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
dbl_ledg_dr_cur_bank_charge DOUBLE PRECISION DEFAULT 0.0,
vhr_base_dr_currency VARCHAR(3) NOT NULL,
dbl_base_dr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
dbl_base_dr_cur_bank_charge DOUBLE PRECISION DEFAULT 0.0,
--Party
fk_cr_main_ledger_id BIGINT NOT NULL REFERENCES accounts.tbl_chart_of_ac(pk_chart_of_ac_id),
fk_cr_customer_id BIGINT NOT NULL REFERENCES accounts.tbl_account(pk_account_id),
fk_cr_sub_customer_id BIGINT NULL,
fk_sub_ledger_id BIGINT REFERENCES accounts.tbl_sub_ledger(pk_sub_ledger_id),
fk_actual_customer_ac_id BIGINT NULL REFERENCES accounts.tbl_account(pk_account_id),--*4
vhr_ledg_cr_currency VARCHAR(3) NOT NULL,
dbl_ledg_cr_cur_roe DOUBLE PRECISION DEFAULT 1.00,
dbl_ledg_cr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
vhr_base_cr_currency VARCHAR(3) NOT NULL,
dbl_base_cr_cur_amount DOUBLE PRECISION DEFAULT 0.0,
-- Receipt Approve
vhr_original_receipt_no VARCHAR(30) NOT NULL,
fk_approve_user_id BIGINT NULL REFERENCES authentication.tbl_user(pk_user_id),
dtm_approval TIMESTAMP WITH TIME ZONE,
txt_approval_remarks TEXT DEFAULT '',
sin_approval_status SMALLINT DEFAULT 1--*1
);
receipt.tbl_receipt_master->vhr_corporate_receipt_no
--Note: Approve Mandatory via corporate_receipt_approve
-- Approve then create a Receipt
-- Approve the kep the table last section and document.tbl_doc_approve_log
-- Approved then donot delete the Doc
Updated by Shilpa Pavithran 3 months ago
- Status changed from Ready for Coding to Coding Started
- % Done changed from 20 to 30
Updated by Shilpa Pavithran 3 months ago
- Status changed from Coding Started to Coding Done
- % Done changed from 30 to 60