Data Dictionary -- Currency Revaluation

Srl. No.	Table Name	Comment
1	crev_attach_notes	Gives the detail of attachment Notes
2	crev_attach_notes_hist	Stores the History of Attachment Notes
3	crev_fb_is_tran_post	Gives the Information of Finance Book Transaction post
4	crev_voucher_trn_dtl	Stores the Detail of Voucher Transaction
5	crev_voucher_trn_hdr	Stores the Voucher Transaction Header

Table Name :	crev_attach_notes
Comment :	Gives the detail of attachment Notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_companycode	varchar(10)	No	Organization unit id	Yes
voucher_no	fin_financebookid	varchar(20)	No	Voucher number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach notes description	No
voucher_status	fin_status	varchar(25)	Yes	Voucher status	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 :	crev_attach_notes_hist
Comment :	Stores the History of Attachment Notes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_companycode	varchar(10)	No	Organization unit id	Yes
voucher_no	fin_financebookid	varchar(20)	No	Voucher number	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach notes description	No
voucher_status	fin_status	varchar(25)	Yes	Voucher status	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 :	crev_fb_is_tran_post
Comment :	Gives the Information of Finance Book Transaction post

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
voucher_no	fin_documentnumber	varchar(18)	Yes	Voucher number	No
voucher_serial_no	fin_int	int(4)	Yes	Voucher serial number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
voucher_type	fin_vouchertype	varchar(20)	Yes	Voucher type	No
voucher_date	fin_datetime	datetime(8)	Yes	Voucher date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
tran_currency	fin_currencycode	varchar(5)	Yes	Transaction curency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
exchange_rate	fin_amount	numeric(13)	Yes	Exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
costcenter_code	fin_costcentercode	varchar(10)	Yes	Cost center code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanal_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
component_name	fin_component	varchar(16)	Yes	Component name	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
mac_flag	fin_flag	varchar(25)	Yes	Mac flag	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	crev_voucher_trn_dtl
Comment :	Stores the Detail of Voucher Transaction

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
voucher_no	fin_documentnumber	varchar(18)	No	Voucher number	Yes
voucher_serial_no	fin_int	int(4)	No	Voucher serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
exchange_rate	fin_amount	numeric(13)	Yes	Exchange rate	No
base_balance	fin_amount	numeric(13)	Yes	Base balance	No
rev_base_balance	fin_amount	numeric(13)	Yes	Reversal base balance	No
exchgl_base	fin_amount	numeric(13)	Yes	Exchangeable base	No
exchgl_baseper	fin_amount	numeric(13)	Yes	Exchangeable base percent	No
base_drcr	fin_drcridentifier	varchar(6)	Yes	Base debit credit	No
pbase_balance	fin_amount	numeric(13)	Yes	Parallel base balance	No
rev_pbase_balance	fin_amount	numeric(13)	Yes	Reversal parallel base balance	No
exchgl_pbase	fin_amount	numeric(13)	Yes	Exchangeable parallel base	No
exchgl_pbaseper	fin_amount	numeric(13)	Yes	Exchangeable parallel base percent	No
pbase_drcr	fin_drcridentifier	varchar(6)	Yes	Parallel base debit credit	No
account_balance	fin_amount	numeric(13)	Yes	Account balance	No
costcenter_code	fin_costcentercode	varchar(10)	Yes	Cost center code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanal_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
remarks	fin_text255	varchar(255)	Yes	Remarks	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	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 :	crev_voucher_trn_hdr
Comment :	Stores the Voucher Transaction 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_documentnumber	varchar(18)	No	Voucher number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
year_code	fin_calendarcode	varchar(10)	Yes	Year code	No
period_code	fin_calendarcode	varchar(10)	Yes	Period code	No
run_flag	fin_status	varchar(25)	Yes	Run flag	No
voucher_status	fin_status	varchar(25)	Yes	Voucher status	No
voucher_date	fin_datetime	datetime(8)	Yes	Voucher date	No
numbering_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
rev_voucher_no	fin_documentnumber	varchar(18)	Yes	Reversal voucher number	No
rev_voucher_date	fin_datetime	datetime(8)	Yes	Reversal voucher date	No
rev_numbering_type	fin_notypeno	varchar(10)	Yes	Reversal numbering type	No
rev_year	fin_calendarcode	varchar(10)	Yes	Reversal year	No
rev_period	fin_calendarcode	varchar(10)	Yes	Reversal period	No
remarks	fin_comments	varchar(256)	Yes	Remarks	No
ref_voucher_no	fin_documentnumber	varchar(18)	Yes	Reference voucher number	No
simul_no	fin_documentnumber	varchar(18)	Yes	Simulation number	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