Data Dictionary -- Customer Payment

Srl. No.	Table Name	Comment
1	cp_acct_info	To store account information
2	Cp_cpd_cap_plan_det	To store information of capital plan detail
3	Cp_cph_cap_plan_hdr	To store information of capital plan header
4	cp_notes_dtl	To store information of notes detail
5	cp_voucher_hdr	To store information of voucher header

Table Name :	cp_acct_info
Comment :	To store account information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit	Yes
tran_no	fin_transactionnumber	varchar(18)	No	Transaction number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
acc_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transcation type	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	No	Timestamp	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fin_post_date	fin_datetime	datetime(8)	Yes	Finance post date	No
currency	fin_currency	varchar(5)	Yes	Currency	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
tran_amt	fin_amount	numeric(13)	Yes	Transaction amount	No
business_unit	fin_buid	varchar(20)	Yes	Business unit	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
sub_analysis_code	fin_subanalysiscode	varchar(5)	Yes	Sub analysis code	No
base_cur_exrate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amt	fin_amount	numeric(13)	Yes	Base amount	No
par_base_cur_exrate	fin_exchangerate	numeric(9)	Yes	Parallel base currency exchange rate	No
par_base_amt	fin_amount	numeric(13)	Yes	Parallel base amount	No
status	fin_status	varchar(25)	Yes	Status	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Component code	No
component_name	fin_component_id	varchar(40)	Yes	Component name	No
acct_type	fin_accounttype	varchar(15)	Yes	Account type	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Bank cash code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	Cp_cpd_cap_plan_det
Comment :	To store information of capital plan detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cpd_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cpd_line_no	udd_seqno	int(4)	Yes	Line number	No
cpd_cust_order_no	udd_documentno	varchar(40)	Yes	Customer order number	No
cpd_workunit_code	udd_workunitcode	varchar(30)	Yes	Work unit code	No
cpd_task_code	udd_taskcode	varchar(30)	Yes	Task code	No
cpd_acreg_no	udd_aircraftnumber	varchar(30)	Yes	Account register number	No
cpd_component_id	udd_componentid	varchar(90)	Yes	Component id	No
cpd_workunit_lineno	udd_seqno	int(4)	Yes	Work unit line number	No
cpd_maint_type	udd_documenttype	varchar(40)	Yes	Maintain type	No
cpd_workunit_type	udd_documenttype	varchar(40)	Yes	Work unit type	No
cpd_work_center	udd_wccode	varchar(30)	Yes	Work center	No
cpd_plan_start_dt	udd_datetime	varchar(30)	Yes	Plan start date	No
cpd_plan_end_dt	udd_datetime	varchar(30)	Yes	Plan end date	No
cpd_task_revno	udd_revisionno	varchar(40)	Yes	Task reversal number	No
cpd_std_procno	udd_documentno	varchar(40)	Yes	Standard proc number	No
cpd_workunit_status	udd_status	varchar(25)	Yes	Work unit status	No
cpd_execution_docno	udd_documentno	varchar(40)	Yes	Execution document number	No
cpd_exec_doctype	udd_documenttype	varchar(40)	Yes	Execution document type	No
cpd_exec_type	udd_flag	varchar(25)	Yes	Execution type	No
CPD_TASK_LINENO	udd_seqno	int(4)	Yes	Task line number	No
REPLICATION_KEY	udd_bigint	bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	Cp_cph_cap_plan_hdr
Comment :	To store information of capital plan header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cph_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cph_line_no	udd_seqno	int(4)	Yes	Line number	No
cph_document_no	udd_documentno	varchar(40)	Yes	Document number	No
cph_document_type	udd_documenttype	varchar(40)	Yes	Document type	No
cph_plan_start_dt	udd_datetime	varchar(30)	Yes	Plan start date	No
cph_plan_end_dt	udd_datetime	varchar(30)	Yes	Plan end date	No
cph_work_center	udd_wccode	varchar(30)	Yes	Work center	No
cph_cap_flag	udd_flag2	varchar(25)	Yes	Capital flag	No
cph_part_flag	udd_flag2	varchar(25)	Yes	Part flag	No
cph_resource_flag	udd_flag2	varchar(25)	Yes	Resource flag	No
cph_fh_flag	udd_flag2	varchar(25)	Yes	cph_fh_flag	No
cph_mel_flag	udd_flag2	varchar(25)	Yes	cph_mel_flag	No
cph_eo_flag	udd_flag2	varchar(25)	Yes	cph_eo_flag	No
cph_comments	udd_txt255	varchar(255)	Yes	Comments	No
CPH_PART_NO	udd_partno	varchar(40)	Yes	Part number	No
CPH_SERIAL_NO	UDD_SERIALNO	varchar(40)	Yes	Serial number	No
CPH_WORK_UNIT_NO	UDD_DocWorkUnitCode	varchar(40)	Yes	Work unit number	No
CPH_MAINT_OBJ_NO	udd_varchar	Varchar(8000)	Yes	Maintain obj number	No
CAP_HOLD_FLAG	udd_flag	varchar(25)	Yes	Hold flag	No
REPLICATION_KEY	udd_bigint	bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	cp_notes_dtl
Comment :	To store information of notes detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ou	varchar(256)	No	Organization unit id	Yes
voucher_no	fin_documentno	varchar(40)	No	Voucher number	Yes
notes_for	fin_paramcode	varchar(30)	No	Notes for	Yes
timestamp	fin_int	int(4)	No	Timestamp	No
note_level	fin_paramcode	varchar(30)	Yes	Note level	No
std_notesid	fin_documentno	varchar(40)	Yes	Standard notes id	No
std_notesid_desc	fin_description	varchar(100)	Yes	Standard notes id description	No
notes	fin_notes	varchar(2000)	Yes	Notes	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No

Table Name :	cp_voucher_hdr
Comment :	To store information of voucher header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_no	fin_voucher	varchar(20)	No	Voucher number	Yes
tran_type	fin_trantype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	No	Timestamp	No
pay_cat	fin_paycategory	varchar(40)	Yes	Payment category	No
req_date	fin_datetime	datetime(8)	Yes	Registration date	No
business_unit	fin_buid	varchar(20)	Yes	Business unit	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
cus_reg_at	fin_ouinstid	int(4)	Yes	Cusomer registered at	No
cus_code	fin_customercode	varchar(16)	Yes	Customer code	No
pay_date	fin_datetime	datetime(8)	Yes	Payment date	No
pay_method	fin_paymode	varchar(25)	Yes	Payment method	No
pay_mode	fin_paramdesc	varchar(30)	Yes	Payment mode	No
pay_route	fin_paytype	varchar(30)	Yes	Payment route	No
pay_cur	fin_currency	varchar(5)	Yes	Payment currecy	No
exch_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
pay_amount	fin_amount	numeric(13)	Yes	Payment amount	No
bank_cash_code	fin_bankcashcode	varchar(32)	Yes	Bank cash code	No
bank_charges	fin_bankchargescpen	varchar(20)	Yes	Bank charges	No
doc_ref	fin_documentnumber	varchar(18)	Yes	Document reference	No
priority	fin_priority	varchar(12)	Yes	Priority	No
billing_pt	fin_ouinstid	int(4)	Yes	Billing point	No
relpay_pt	fin_ouinstid	int(4)	Yes	relpay_pt	No
reason_code	fin_reasoncode	varchar(10)	Yes	Reason code	No
el_pay	fin_flag	varchar(25)	Yes	Electronic pay	No
elec_pay_applied	fin_flag	varchar(25)	Yes	Electronic pay applied	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
hldreason_code	fin_reasoncode	varchar(10)	Yes	Hold reason code	No
revreason_code	fin_reasoncode	varchar(10)	Yes	Reversal reason code	No
rev_date	fin_datetime	datetime(8)	Yes	Reversal date	No
esr_partid	fin_participationid	varchar(30)	Yes	esr partid	No
esr_ref	fin_reference	varchar(18)	Yes	esr reference	No
esr_codingline	fin_code	varchar(6)	Yes	esr coding line	No
lsv_contid	fin_id	varchar(6)	Yes	lsv_contid	No
lsv_ref	fin_reference	varchar(18)	Yes	lsv reference	No
cust_acct_in	fin_paytype	varchar(30)	Yes	Customer account in	No
cust_account	fin_accountcode	varchar(32)	Yes	Customer account	No
el_bank_pttcode	fin_bankcode	varchar(32)	Yes	Electronic bank ptt code	No
el_bank_id	fin_bankid	varchar(20)	Yes	Electronic bank id	No
cust_bank_acct	fin_accountcode	varchar(32)	Yes	Customer bank account	No
status	fin_status	varchar(25)	Yes	Status	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
pay_amt_bef_round	fin_amount	numeric(13)	Yes	Payment amount before round	No
roundoff_amt	fin_amount	numeric(13)	Yes	Round off amount	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
hldrev_remarks	fin_remarks	varchar(100)	Yes	Hold reversal remarks	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No