Accounting Setup

Data_Dictionary - Accounting Setup

Table Name as_attach_notes

Table Comment Gives the details of the notes attached
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
code	varchar(32)	NOT NULL	Code	Yes	No
type_flag	varchar(4)	NOT NULL	Type Flag	Yes	No
timestamp	int	NULL	Time Stamp	No	No
st_notes_id	varchar(6)	NULL	Standard Notes Id	No	No
st_notes_desc	varchar(2000)	NULL	Standard Notes Description	No	No
notes	varchar(255)	NULL	Notes	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_attach_notes_his

Table Comment Gives the history of the notes attached
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
code	varchar(32)	NOT NULL	Code	Yes	No
type_flag	varchar(4)	NOT NULL	Type Flag	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
st_notes_id	varchar(6)	NULL	Standard Notes Id	No	No
st_notes_desc	varchar(2000)	NULL	Standard Notes Description	No	No
notes	varchar(255)	NULL	Notes	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_controlrule_met

Table Comment Gives the autoposting account details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_group	varchar(20)	NULL	Account Group	No	No
ctrl_acctype	varchar(40)	NULL	Control Account Type	No	No
account_class	varchar(20)	NULL	Account Class	No	No
autopost_acctype	varchar(40)	NULL	Auto Post Account Type	No	No
language_id	int	NULL	Language Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_finperiod_dtl

Table Comment Gives the financial period details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
finyr_code	varchar(10)	NOT NULL	Finance Year Code	Yes	No
finprd_code	varchar(15)	NOT NULL	Finance Period Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
finprd_desc	varchar(40)	NULL	Finance Period Description	No	No
finprd_startdt	datetime	NULL	Finance Period Start Date	No	No
finprd_enddt	datetime	NULL	Finance Period End Date	No	No
finprd_status	varchar(2)	NULL	Finance Period Status.Values A-Active, I-Inactive	No	No
sequence_no	int	NULL	Sequence Number	No	No
legacy_date	varchar(20)	NULL	Legacy Date	No	No
active_from	datetime	NULL	Active From	No	No
active_to	datetime	NULL	Active To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_finperiod_his

Table Comment Gives the financial period history
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
finyr_code	varchar(10)	NOT NULL	Finance Year Code	Yes	No
finprd_code	varchar(15)	NOT NULL	Finance Period Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
effective_to	datetime	NULL	Effective To	No	No
status	varchar(2)	NULL	Status.Values A-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_finyear_hdr

Table Comment Gives financial year and period frequency
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
finyr_code	varchar(10)	NOT NULL	Finance Year Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
finyr_desc	varchar(40)	NULL	Finance Year Description	No	No
finyr_startdt	datetime	NULL	Finance Year Start Date	No	No
finyr_enddt	datetime	NULL	Finance Year End Date	No	No
frequency	varchar(20)	NULL	Frequency	No	No
finyr_status	varchar(2)	NULL	Finance Year Status.Values A-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
rescomp_code	varchar(10)	NULL	Resource Company Code	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_finyear_map

Table Comment Gives the mapping status of the financial year to the company
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
finyr_code	varchar(10)	NOT NULL	Finance Year Code	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
map_status	varchar(2)	NULL	Map Status.Values A-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
flag	varchar(4)	NULL	Flag	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_layoutrule_met

Table Comment Gives the layout for the accounts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_group	varchar(20)	NULL	Account Group	No	No
account_class	varchar(20)	NULL	Account Class	No	No
layout_desc	varchar(40)	NULL	Layout Description	No	No
language_id	int	NULL	Language Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_opaccount_dtl

Table Comment Gives the details of the account codes mapped to operative chart of accounts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
opcoa_id	varchar(10)	NOT NULL	Operative Chart Of Account Id	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_desc	varchar(40)	NULL	Account Description	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No
account_group	varchar(20)	NULL	Account Group	No	No
account_class	varchar(20)	NULL	Account Class	No	No
ctrl_acctype	varchar(40)	NULL	Control Account Type	No	No
autopost_acctype	varchar(40)	NULL	Auto Post Account Type	No	No
effective_from	datetime	NULL	Effective From	No	No
effective_to	datetime	NULL	Effective To	No	No
consol_account	varchar(32)	NULL	Consolidated Account	No	No
layout_code	varchar(40)	NULL	Layout Code	No	No
account_status	varchar(2)	NULL	Account Status.Values A-Active, I-Inactive	No	No
active_from	datetime	NULL	Active From	No	No
active_to	datetime	NULL	Active To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_opaccount_his

Table Comment Gives the history details of the account codes mapped to operative chart of accounts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
opcoa_id	varchar(10)	NOT NULL	Operative Chart Of Account Id	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
effective_to	datetime	NULL	Effective To	No	No
status	varchar(2)	NULL	Status.Values A-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_opaccountfb_map

Table Comment Gives the company/account code/finance book mapping
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
opcoa_id	varchar(10)	NOT NULL	Operative Chart Of Account Id	Yes	No
account_code	varchar(32)	NOT NULL	Account Type	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
timestamp	int	NULL	Time Stamp	No	No
map_status	varchar(2)	NULL	Map Status.Values A- Attach,D- Detach	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_opcoaid_hdr

Table Comment Gives the operative chart of accounts header information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
opcoa_id	varchar(10)	NOT NULL	Operative Chart Of Account Id	Yes	No
timestamp	int	NULL	Time Stamp	No	No
opcoaid_desc	varchar(40)	NULL	Operative Chart Of Account Id Description	No	No
opcoaid_status	varchar(2)	NULL	Operative Chart Of Account Id Status..Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
rescomp_code	varchar(10)	NULL	Resource Company Code	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_opcoaid_map

Table Comment Gives the mapping status of the operative chart of accounts to the company
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
opcoa_id	varchar(10)	NOT NULL	Operative Chart Of Account Id	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
map_status	varchar(2)	NULL	Map Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
srccoa_id	varchar(10)	NULL	Source Chart Of Account Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_postingrule_dtl

Table Comment Gives the posting rule details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
jv_type	varchar(25)	NOT NULL	Journal Voucher Type	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
autopost_acctype	varchar(40)	NOT NULL	Autopost Account Type	Yes	No
ctrl_acctype	varchar(40)	NOT NULL	Control Account Type	Yes	No
account_class	varchar(20)	NOT NULL	Account Class	Yes	No
account_group	varchar(20)	NOT NULL	Account Group	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
status	varchar(25)	NULL	Status.Values EXCL- Excluded,INCL- Included	No	No
effective_to	datetime	NULL	Effective To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_postingrule_hdr

Table Comment Stores the header information of posting rule
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
jv_type	varchar(25)	NOT NULL	Journal Voucher Type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_rptaccount_dtl

Table Comment Gives the details of the account codes mapped to reporting chart of accounts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rptcoa_id	varchar(10)	NOT NULL	Reporting Chart Of Account Id	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_desc	varchar(40)	NULL	Account Description	No	No
account_level	varchar(4)	NULL	Account Level	No	No
parent_acccode	varchar(32)	NULL	Parent Account Code	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No
account_group	varchar(20)	NULL	Account Group	No	No
account_class	varchar(20)	NULL	Account Class	No	No
account_type	varchar(4)	NULL	Account Type	No	No
account_status	varchar(2)	NULL	Account Status.Values a-Active, I-Inactive	No	No
active_from	datetime	NULL	Active From	No	No
active_to	datetime	NULL	Active To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_rptaccount_his

Table Comment Gives the history details of the account codes mapped to reporting chart of accounts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rptcoa_id	varchar(10)	NOT NULL	Reporting Chart Of Account Id	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
effective_to	datetime	NULL	Effective To	No	No
status	varchar(2)	NULL	Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified	No	No

Table Name as_rptcoaid_hdr

Table Comment Gives the reporting chart of accounts header information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rptcoa_id	varchar(10)	NOT NULL	Reporting Chart Of Account Id	Yes	No
timestamp	int	NULL	Time Stamp	No	No
rptcoaid_desc	varchar(40)	NULL	Reporting Chart Of Account Id Description	No	No
coaid_type	varchar(40)	NULL	Chart Of Account Id Type	No	No
country	varchar(40)	NULL	Country	No	No
rptcoaid_status	varchar(2)	NULL	Reporting Chart Of Account Id Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
rescomp_code	varchar(10)	NULL	Resource Company Code	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_rptcoaid_map

Table Comment Gives the mapping status of the reporting chart of accounts to the company
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rptcoa_id	varchar(10)	NOT NULL	Reporting Char Of Accounting Id	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
map_status	varchar(2)	NULL	Map Status..Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
srccoa_id	varchar(10)	NULL	Source Chart Of Account Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_rptopaccount_map

Table Comment Gives the operative chart of accounts ids mapped to reporting chart of accounts ids
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rptcoa_id	varchar(10)	NOT NULL	Reporting Chart Of Account Id	Yes	No
rptaccount_code	varchar(32)	NOT NULL	Reporting &nbspAccount Code	Yes	No
opcoa_id	varchar(10)	NOT NULL	Operative Chart Of Account Id	Yes	No
opaccount_code	varchar(32)	NOT NULL	Operative Account Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_level	varchar(4)	NULL	Account Level	No	No
map_status	varchar(2)	NULL	Map Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_taxperiod_dtl

Table Comment Gives the tax period details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
taxyr_code	varchar(10)	NOT NULL	Tax Year Code	Yes	No
taxprd_code	varchar(15)	NOT NULL	Tax Period Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
taxprd_desc	varchar(40)	NULL	Tax Period Description	No	No
taxprd_startdt	datetime	NULL	Tax Period Start Date	No	No
taxprd_enddt	datetime	NULL	Tax Period End Date	No	No
taxprd_status	varchar(2)	NULL	Tax Period Status.Values a-Active, I-Inactive	No	No
sequence_no	int	NULL	Sequence Number	No	No
legacy_date	varchar(20)	NULL	Legacy Date	No	No
active_from	datetime	NULL	Active From	No	No
active_to	datetime	NULL	Active To	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_taxperiod_his

Table Comment Gives the history of the tax periods
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
taxyr_code	varchar(10)	NOT NULL	Tax Year Code	Yes	No
taxprd_code	varchar(15)	NOT NULL	Tax Period Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
action_time	datetime	NOT NULL	Action Time	Yes	No
timestamp	int	NULL	Time Stamp	No	No
effective_to	datetime	NULL	Effective To	No	No
status	varchar(2)	NULL	Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_taxyear_hdr

Table Comment Gives the tax year details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
taxyr_code	varchar(10)	NOT NULL	Tax Year Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
taxyr_desc	varchar(40)	NULL	Tax Year Description	No	No
taxyr_startdt	datetime	NULL	Tax Year Start Date	No	No
taxyr_enddt	datetime	NULL	Tax Year End Date	No	No
frequency	varchar(20)	NULL	Frequency	No	No
taxyr_status	varchar(2)	NULL	Tax Year Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
rescomp_code	varchar(10)	NULL	Resource Company Code	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name as_taxyear_map

Table Comment Gives the tax year - company mapping
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
taxyr_code	varchar(10)	NOT NULL	Tax Year Code	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
map_status	varchar(2)	NULL	Map Status.Values a-Active, I-Inactive	No	No
resou_id	int	NULL	Resource Id	No	No
flag	varchar(4)	NULL	Flag	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Data_Dictionary - Accounting Setup