Data Dictionary -- Accounting Setup

Srl. No.	Table Name	Comment
1	as_attach_notes	Gives the details of the notes attached
2	as_attach_notes_his	Gives the history of the notes attached
3	as_controlrule_met	Gives the autoposting account details
4	as_finperiod_dtl	Gives the financial period details
5	as_finperiod_his	Gives the financial period history
6	as_finyear_hdr	Gives financial year and period frequency
7	as_finyear_map	Gives the mapping status of the financial year to the company
8	as_layoutrule_met	Gives the layout for the accounts
9	as_opaccountcomp_map	Gives the company/account code mapping
10	as_opaccountfb_map	Gives the account code/finance book mapping
11	as_opaccount_dtl	Gives the details of the account codes mapped to operative chart of accounts
12	as_opaccount_his	Gives the history details of the account codes mapped to operative chart of accounts
13	as_opcoaid_hdr	Gives the operative chart of accounts header information
14	as_opcoaid_map	Gives the mapping status of the operative chart of accounts to the company
15	as_postingrule_dtl	Gives the posting rule details
16	as_postingrule_hdr	Stores the header information of posting rule
17	as_rptaccount_dtl	Gives the details of the account codes mapped to reporting chart of accounts
18	as_rptaccount_his	Gives the history details of the account codes mapped to reporting chart of accounts
19	as_rptcoaid_hdr	Gives the reporting chart of accounts header information
20	as_rptcoaid_map	Gives the mapping status of the reporting chart of accounts to the company
21	as_rptopaccount_map	Gives the operative chart of accounts ids mapped to reporting chart of accounts ids
22	as_taxperiod_dtl	Gives the tax period details
23	as_taxperiod_his	Gives the history of the tax periods
24	as_taxyear_hdr	Gives the tax year details
25	as_taxyear_map	Gives the tax year - company mapping

Table Name :	as_attach_notes
Comment :	Gives the details of the notes attached

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
code	fin_accountcode	varchar(32)	No	Code	Yes
type_flag	fin_cmbflag	varchar(4)	No	Type Flag	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
st_notes_id	fin_id	varchar(6)	Yes	Standard Notes Id	No
st_notes_desc	fin_notes	varchar(2000)	Yes	Standard Notes Description	No
notes	fin_text255	varchar(255)	Yes	Notes	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_attach_notes_his
Comment :	Gives the history of the notes attached

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
code	fin_accountcode	varchar(32)	No	Code	Yes
type_flag	fin_cmbflag	varchar(4)	No	Type Flag	Yes
action_time	datetime	Datetime(8)	No	Action Time	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
st_notes_id	fin_id	varchar(6)	Yes	Standard Notes Id	No
st_notes_desc	fin_notes	varchar(2000)	Yes	Standard Notes Description	No
notes	fin_text255	varchar(255)	Yes	Notes	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_controlrule_met
Comment :	Gives the autoposting account details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_group	fin_accountgroupallen	varchar(20)	Yes	Account Group	No
ctrl_acctype	fin_controlaccounttype	varchar(40)	Yes	Control Account Type	No
account_class	fin_accountclass	varchar(20)	Yes	Account Class	No
autopost_acctype	fin_autopostingaccounttype	varchar(40)	Yes	Auto Post Account Type	No
language_id	fin_lang_id	int(4)	Yes	Language Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_finperiod_dtl
Comment :	Gives the financial period details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
finyr_code	fin_calendarcode	varchar(10)	No	Finance Year Code	Yes
finprd_code	fin_financeperiod	varchar(15)	No	Finance Period Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
finprd_desc	fin_calendardescription	varchar(40)	Yes	Finance Period Description	No
finprd_startdt	datetime	Datetime(8)	Yes	Finance Period Start Date	No
finprd_enddt	datetime	Datetime(8)	Yes	Finance Period End Date	No
finprd_status	fin_statuscode	varchar(2)	Yes	Finance Period Status.Values A-Active, I-Inactive	No
sequence_no	fin_integer8	int(4)	Yes	Sequence Number	No
legacy_date	fin_desc20	varchar(20)	Yes	Legacy Date	No
active_from	datetime	Datetime(8)	Yes	Active From	No
active_to	datetime	Datetime(8)	Yes	Active To	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_finperiod_his
Comment :	Gives the financial period history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
finyr_code	fin_calendarcode	varchar(10)	No	Finance Year Code	Yes
finprd_code	fin_financeperiod	varchar(15)	No	Finance Period Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
action_time	datetime	Datetime(8)	No	Action Time	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
status	fin_statuscode	varchar(2)	Yes	Status.Values A-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_finyear_hdr
Comment :	Gives financial year and period frequency

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
finyr_code	fin_calendarcode	varchar(10)	No	Finance Year Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
finyr_desc	fin_calendardescription	varchar(40)	Yes	Finance Year Description	No
finyr_startdt	datetime	Datetime(8)	Yes	Finance Year Start Date	No
finyr_enddt	datetime	Datetime(8)	Yes	Finance Year End Date	No
frequency	fin_desc20	varchar(20)	Yes	Frequency	No
finyr_status	fin_statuscode	varchar(2)	Yes	Finance Year Status.Values A-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
rescomp_code	fin_companycode	varchar(10)	Yes	Resource Company Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_finyear_map
Comment :	Gives the mapping status of the financial year to the company

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
finyr_code	fin_calendarcode	varchar(10)	No	Finance Year Code	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
map_status	fin_statuscode	varchar(2)	Yes	Map Status.Values A-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
flag	fin_cmbflag	varchar(4)	Yes	Flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_layoutrule_met
Comment :	Gives the layout for the accounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_group	fin_accountgroupallen	varchar(20)	Yes	Account Group	No
account_class	fin_accountclass	varchar(20)	Yes	Account Class	No
layout_desc	fin_accountdescription	varchar(40)	Yes	Layout Description	No
language_id	fin_lang_id	int(4)	Yes	Language Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_opaccountcomp_map
Comment :	Gives the company/account code mapping

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
account_code	fin_accountcode	varchar(32)	No	account_code	Yes
company_code	fin_companycode	varchar(10)	No	company_code	Yes
timestamp	int	int(4)	Yes	timestamp	No
map_status	fin_statuscode	varchar(2)	Yes	map_status	No
resou_id	fin_ouinstid	int(4)	Yes	resou_id	No
createdby	fin_ctxt_user	varchar(30)	Yes	createdby	No
createddate	datetime	Datetime(8)	Yes	createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modifiedby	No
modifieddate	datetime	Datetime(8)	Yes	modifieddate	No

Table Name :	as_opaccountfb_map
Comment :	Gives the account code/finance book mapping

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
account_code	fin_accountcode	varchar(32)	No	Account Type	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
map_status	fin_statuscode	varchar(2)	Yes	Map Status.Values A- Attach,D- Detach	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_opaccount_dtl
Comment :	Gives the details of the account codes mapped to operative chart of accounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
account_code	fin_accountcode	varchar(32)	No	Account Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_desc	fin_accountdescription	varchar(40)	Yes	Account Description	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency Code	No
account_group	fin_accountgroupallen	varchar(20)	Yes	Account Group	No
account_class	fin_accountclass	varchar(20)	Yes	Account Class	No
ctrl_acctype	fin_controlaccounttype	varchar(40)	Yes	Control Account Type	No
autopost_acctype	fin_autopostingaccounttype	varchar(40)	Yes	Auto Post Account Type	No
effective_from	datetime	Datetime(8)	Yes	Effective From	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
consol_account	fin_accountcode	varchar(32)	Yes	Consolidated Account	No
layout_code	fin_accountdescription	varchar(40)	Yes	Layout Code	No
account_status	fin_statuscode	varchar(2)	Yes	Account Status.Values A-Active, I-Inactive	No
active_from	datetime	Datetime(8)	Yes	Active From	No
active_to	datetime	Datetime(8)	Yes	Active To	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_opaccount_his
Comment :	Gives the history details of the account codes mapped to operative chart of accounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
account_code	fin_accountcode	varchar(32)	No	Account Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
action_time	datetime	Datetime(8)	No	Action Time	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
status	fin_statuscode	varchar(2)	Yes	Status.Values A-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_opcoaid_hdr
Comment :	Gives the operative chart of accounts header information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
opcoaid_desc	fin_accountdescription	varchar(40)	Yes	Operative Chart Of Account Id Description	No
opcoaid_status	fin_statuscode	varchar(2)	Yes	Operative Chart Of Account Id Status..Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
rescomp_code	fin_companycode	varchar(10)	Yes	Resource Company Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_opcoaid_map
Comment :	Gives the mapping status of the operative chart of accounts to the company

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
map_status	fin_statuscode	varchar(2)	Yes	Map Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
srccoa_id	fin_coaid	varchar(10)	Yes	Source Chart Of Account Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_postingrule_dtl
Comment :	Gives the posting rule details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
jv_type	fin_type	varchar(25)	No	Journal Voucher Type	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
autopost_acctype	fin_autopostingaccounttype	varchar(40)	No	Autopost Account Type	Yes
ctrl_acctype	fin_controlaccounttype	varchar(40)	No	Control Account Type	Yes
account_class	fin_accountclass	varchar(20)	No	Account Class	Yes
account_group	fin_accountgroupallen	varchar(20)	No	Account Group	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
status	fin_status	varchar(25)	Yes	Status.Values EXCL- Excluded,INCL- Included	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_postingrule_hdr
Comment :	Stores the header information of posting rule

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
jv_type	fin_type	varchar(25)	No	Journal Voucher Type	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_rptaccount_dtl
Comment :	Gives the details of the account codes mapped to reporting chart of accounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rptcoa_id	fin_coaid	varchar(10)	No	Reporting Chart Of Account Id	Yes
account_code	fin_accountcode	varchar(32)	No	Account Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_desc	fin_accountdescription	varchar(40)	Yes	Account Description	No
account_level	fin_accountlevel	int(4)	Yes	Account Level	No
parent_acccode	fin_accountcode	varchar(32)	Yes	Parent Account Code	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency Code	No
account_group	fin_accountgroupallen	varchar(20)	Yes	Account Group	No
account_class	fin_accountclass	varchar(20)	Yes	Account Class	No
account_type	fin_cmbflag	varchar(4)	Yes	Account Type	No
account_status	fin_statuscode	varchar(2)	Yes	Account Status.Values a-Active, I-Inactive	No
active_from	datetime	Datetime(8)	Yes	Active From	No
active_to	datetime	Datetime(8)	Yes	Active To	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_rptaccount_his
Comment :	Gives the history details of the account codes mapped to reporting chart of accounts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rptcoa_id	fin_coaid	varchar(10)	No	Reporting Chart Of Account Id	Yes
account_code	fin_accountcode	varchar(32)	No	Account Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
action_time	datetime	Datetime(8)	No	Action Time	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
status	fin_statuscode	varchar(2)	Yes	Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified	No

Table Name :	as_rptcoaid_hdr
Comment :	Gives the reporting chart of accounts header information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rptcoa_id	fin_coaid	varchar(10)	No	Reporting Chart Of Account Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
rptcoaid_desc	fin_accountdescription	varchar(40)	Yes	Reporting Chart Of Account Id Description	No
coaid_type	fin_coatype	varchar(40)	Yes	Chart Of Account Id Type	No
country	fin_country	varchar(40)	Yes	Country	No
rptcoaid_status	fin_statuscode	varchar(2)	Yes	Reporting Chart Of Account Id Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
rescomp_code	fin_companycode	varchar(10)	Yes	Resource Company Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_rptcoaid_map
Comment :	Gives the mapping status of the reporting chart of accounts to the company

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rptcoa_id	fin_coaid	varchar(10)	No	Reporting Char Of Accounting Id	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
map_status	fin_statuscode	varchar(2)	Yes	Map Status..Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
srccoa_id	fin_accountcode	varchar(32)	Yes	Source Chart Of Account Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_rptopaccount_map
Comment :	Gives the operative chart of accounts ids mapped to reporting chart of accounts ids

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rptcoa_id	fin_coaid	varchar(10)	No	Reporting Chart Of Account Id	Yes
rptaccount_code	fin_accountcode	varchar(32)	No	Reporting  Account Code	Yes
opcoa_id	fin_coaid	varchar(10)	No	Operative Chart Of Account Id	Yes
opaccount_code	fin_accountcode	varchar(32)	No	Operative Account Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_level	fin_accountlevel	int(4)	Yes	Account Level	No
map_status	fin_statuscode	varchar(2)	Yes	Map Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_taxperiod_dtl
Comment :	Gives the tax period details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
taxyr_code	fin_calendarcode	varchar(10)	No	Tax Year Code	Yes
taxprd_code	fin_financeperiod	varchar(15)	No	Tax Period Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
taxprd_desc	fin_calendardescription	varchar(40)	Yes	Tax Period Description	No
taxprd_startdt	datetime	Datetime(8)	Yes	Tax Period Start Date	No
taxprd_enddt	datetime	Datetime(8)	Yes	Tax Period End Date	No
taxprd_status	fin_statuscode	varchar(2)	Yes	Tax Period Status.Values a-Active, I-Inactive	No
sequence_no	fin_integer8	int(4)	Yes	Sequence Number	No
legacy_date	fin_desc20	varchar(20)	Yes	Legacy Date	No
active_from	datetime	Datetime(8)	Yes	Active From	No
active_to	datetime	Datetime(8)	Yes	Active To	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_taxperiod_his
Comment :	Gives the history of the tax periods

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
taxyr_code	fin_calendarcode	varchar(10)	No	Tax Year Code	Yes
taxprd_code	fin_financeperiod	varchar(15)	No	Tax Period Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
action_time	datetime	Datetime(8)	No	Action Time	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
status	fin_statuscode	varchar(2)	Yes	Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_taxyear_hdr
Comment :	Gives the tax year details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
taxyr_code	fin_calendarcode	varchar(10)	No	Tax Year Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
taxyr_desc	fin_calendardescription	varchar(40)	Yes	Tax Year Description	No
taxyr_startdt	datetime	Datetime(8)	Yes	Tax Year Start Date	No
taxyr_enddt	datetime	Datetime(8)	Yes	Tax Year End Date	No
frequency	fin_desc20	varchar(20)	Yes	Frequency	No
taxyr_status	fin_statuscode	varchar(2)	Yes	Tax Year Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
rescomp_code	fin_companycode	varchar(10)	Yes	Resource Company Code	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No

Table Name :	as_taxyear_map
Comment :	Gives the tax year - company mapping

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
taxyr_code	fin_calendarcode	varchar(10)	No	Tax Year Code	Yes
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
map_status	fin_statuscode	varchar(2)	Yes	Map Status.Values a-Active, I-Inactive	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
flag	fin_cmbflag	varchar(4)	Yes	Flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created By	No
createddate	datetime	Datetime(8)	Yes	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified By	No
modifieddate	datetime	Datetime(8)	Yes	Modified Date	No