Database Schema for

Data Dictionary -- Account Rule Definition

Srl. No.	Table Name	Comment
1	ard_addn_account_mst	Gives the additional accounts mapped to usage
2	ard_airconsump_account_mst	Gives the aircraft consumption account
3	ard_airconsump_param_mst	Gives the parameters set for aircraft consumption account
4	ard_asset_account_mst	Gives the asset accounts
5	ard_bnkcsh_account_mst	Gives the bank cash accounts
6	ard_consump_account_mst	Gives the component/non-component consumptino accounts
7	ard_consump_param_mst	Gives the parameters set for component/non-component consumption account
8	ard_customer_account_mst	Gives the customer accounts
9	ARD_flogconsump_account_mst	Gives the aircraft techlog consumption account
10	ard_flogconsump_param_mst	Gives the parameters set for Techlog consumption account
11	ard_fltcontract_account_mst	Flight Contract Account Parameters Definition
12	ard_fltcontract_param_mst	Set Flight Contract Parameters Details
13	ard_intcustomer_account_mst	Customer account master
14	ard_intsupplier_account_mst	Supplier account master
15	ard_item_account_mst	Gives the item accounts
16	ard_item_event_met	Gives the item events-- metadata
17	ard_sale_account_mst	Gives the sales account
18	ard_sale_param_mst	Gives the parameters set for sales account
19	ard_ser_account_mst	Gives the service accounts
20	ard_ser_param_mst	Gives the parameters set for service account
21	ard_supplier_account_mst	Gives the supplier accounts
22	ard_tcdpurchase_account_mst	Gives the tcd code/variant mapped to purchase accounts
23	ard_tcdpurchase_param_mst	Gives the parameters set for purchase account - tcd code/variant mapping
24	ard_tcdsale_account_mst	Gives the tcd code/variant mapped to sales account
25	ard_tcdsale_param_mst	Gives the parameters set for sales account - tcd code/variant mapping
26	ard_usage_event_map	Gives the usage and event mapping
27	ard_usage_met	Gives the usages and account type mapping -- meta data
28	ard_usage_mst	Gives the usages and account type mapping
29	ard_vat_account_mst	Gives the vat accounts


Table Name :	ard_addn_account_mst
Comment :	Gives the additional accounts mapped to usage


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
usage_id	fin_usageid	varchar(20)	No	Usage Id	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
drcr_flag	fin_cmbflag	varchar(4)	No	Debit Credit Flag	Yes
dest_fbid	fin_financebookid	varchar(20)	No	Destination Finance Book Id	Yes
child_company	fin_companycode	varchar(10)	No	Child Company	Yes
dest_company	fin_companycode	varchar(10)	No	Destination Company	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
effective_to	datetime	Datetime(8)	Yes	Effective To	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
usage_type	fin_cmbflag	varchar(4)	Yes	Usage Type	No
ard_type	fin_desc20	varchar(20)	Yes	Account Rule Definition Type	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 :	ard_airconsump_account_mst
Comment :	Gives the aircraft consumption account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
wo_ordertype	fin_desc40	varchar(40)	No	Work Order Type	Yes
wo_ordercategory	fin_desc40	varchar(40)	No	Work Order Category	Yes
plan_base	fin_text255	varchar(255)	No	Planning Base	Yes
maint_location	fin_ouinstdesc	varchar(256)	No	Maintenance Location	Yes
work_center	fin_text255	varchar(255)	No	Work Center	Yes
usg_typ	fin_desc28	varchar(28)	No	Usage Type	Yes
vst_cat	fin_desc28	varchar(28)	No	Visit Package Category.Values CUSTOMER JOB,FRESH,OTHER,SCHEDULED WORK,VCCAT1	Yes
air_model	fin_desc20	varchar(20)	No	Aircraft Model	Yes
air_own	fin_desc28	varchar(28)	No	Aircraft Ownership	Yes
job_type	fin_desc28	varchar(28)	No	Job type	Yes
wo_class	fin_desc28	varchar(28)	No	Work Order Class	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
Expclass	fin_desc28	varchar(28)	No	Expense Class	Yes
sequence_no	fin_sequence	int(4)	Yes	Sequence Number	No
timestamp	int	int(4)	Yes	Time Stamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_airconsump_param_mst
Comment :	Gives the parameters set for aircraft consumption account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
work_ordertype	fin_cmbflag	varchar(4)	Yes	Work Order Type	No
work_ordercategory	fin_cmbflag	varchar(4)	Yes	Work Order Category	No
plan_base	fin_cmbflag	varchar(4)	Yes	Planning Base	No
maint_location	fin_cmbflag	varchar(4)	Yes	Maintenance Location	No
work_center	fin_cmbflag	varchar(4)	Yes	Work Center	No
usg_typ	fin_cmbflag	varchar(4)	Yes	Usage Type	No
vst_cat	fin_cmbflag	varchar(4)	Yes	Visit Package Category.Values CUSTOMER JOB,FRESH,OTHER,SCHEDULED WORK,VCCAT1	No
air_model	fin_cmbflag	varchar(4)	Yes	Aircraft Model	No
air_own	fin_cmbflag	varchar(4)	Yes	Aircraft Ownership	No
job_typ	fin_cmbflag	varchar(4)	Yes	Job Type	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
set_flag	fin_cmbflag	varchar(4)	Yes	Set Flag	No
wo_class	fin_cmbflag	varchar(4)	Yes	Work Order Class	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 :	ard_asset_account_mst
Comment :	Gives the asset accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
asset_class	fin_assetclass	varchar(20)	No	Asset Class	Yes
asset_usage	fin_usageid	varchar(20)	No	Asset Usage	Yes
effective_from	datetime	Datetime(8)	No	Effective From	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
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_bnkcsh_account_mst
Comment :	Gives the bank cash accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
bank_ptt_code	fin_bankcashcode	varchar(32)	No	Bank / PTT Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
bankptt_account	fin_accountcode	varchar(32)	Yes	Bank / PTT Account	No
bankcharge_account	fin_accountcode	varchar(32)	Yes	Bank Charge Account	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_consump_account_mst
Comment :	Gives the component/non-component consumptino accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
wo_ordertype	fin_desc40	varchar(40)	No	Work Order Type	Yes
wo_ordercategory	fin_desc40	varchar(40)	No	Work Order Category	Yes
plan_base	fin_text255	varchar(255)	No	Planning Base	Yes
maint_location	fin_ouinstdesc	varchar(256)	No	Maintenance Location	Yes
work_center	fin_text255	varchar(255)	No	Work Center	Yes
part_class	fin_desc28	varchar(28)	No	Part Class	Yes
comp_type	fin_desc28	varchar(28)	No	Component Type	Yes
comp_fam	fin_desc28	varchar(28)	No	Component Family	Yes
comp_own	fin_desc16	varchar(16)	No	Component Owner	No
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	No
poss_stat	fin_desc40	varchar(40)	No	Possession Status .Values Y- Yes, N- No	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_code	fin_accountcode	varchar(32)	No	Account Code	Yes
effective_to	datetime	Datetime(8)	Yes	Effective To	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
cost_type	fin_desc40	varchar(40)	Yes	Cost Type	No
wo_plantype	fin_desc40	varchar(40)	Yes	Work Order Planing Type	No
wo_plancategory	fin_desc40	varchar(40)	Yes	Work Order Planning Category	No
shop_type	fin_desc28	varchar(28)	No	Shop Type	Yes
Expclass	fin_desc28	varchar(28)	No	Expense Class	Yes


Table Name :	ard_consump_param_mst
Comment :	Gives the parameters set for component/non-component consumption account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
work_ordertype	fin_cmbflag	varchar(4)	Yes	Work Order Type	No
work_ordercategory	fin_cmbflag	varchar(4)	Yes	Work Order Category	No
maint_location	fin_cmbflag	varchar(4)	Yes	Maintenance Location	No
cost_type	fin_cmbflag	varchar(4)	Yes	Cost Type	No
plan_type	fin_cmbflag	varchar(4)	Yes	Planning Type	No
plan_category	fin_cmbflag	varchar(4)	Yes	Planning Category	No
resou_id	fin_ouinstid	int(4)	Yes	Resource Id	No
set_flag	fin_cmbflag	varchar(4)	Yes	Set 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
plan_base	fin_cmbflag	varchar(4)	Yes	Planning Base	No
work_center	fin_cmbflag	varchar(4)	Yes	Work Center	No
part_class	fin_cmbflag	varchar(4)	Yes	Part Class	No
comp_type	fin_cmbflag	varchar(4)	Yes	Component Type	No
comp_fam	fin_cmbflag	varchar(4)	Yes	Component Familty	No
comp_own	fin_cmbflag	varchar(4)	Yes	Component Owner	No
poss_stat	fin_cmbflag	varchar(4)	Yes	Possession Status .Values Y- Yes, N- No	No
shop_type	fin_desc28	varchar(28)	Yes	Shop type	No


Table Name :	ard_customer_account_mst
Comment :	Gives the customer accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
customer_group	udd_customer_id	varchar(18)	No	Customer Group	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
custctrl_account	fin_accountcode	varchar(32)	Yes	Customer Control Account	No
custprepay_account	fin_accountcode	varchar(32)	Yes	Customer Prepay Account	No
custnonar_account	fin_accountcode	varchar(32)	Yes	Customer Deposit Account	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ARD_flogconsump_account_mst
Comment :	Gives the aircraft techlog consumption account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
doc_class	fin_desc40	varchar(40)	No	doc_class	Yes
doc_type	fin_desc40	varchar(40)	No	doc_type	Yes
doc_category	fin_desc40	varchar(40)	No	doc_category	Yes
plan_base	fin_text255	varchar(255)	No	Planning Base	Yes
maint_base	fin_text255	varchar(255)	No	Maintenance Location	Yes
work_center	fin_text255	varchar(255)	No	Work Center	Yes
usg_type	fin_desc28	varchar(28)	No	Usage Type	Yes
rep_station	fin_text255	varchar(255)	No	rep_station	Yes
aircraft_model	fin_desc20	varchar(20)	No	Aircraft Model	Yes
aircraft_own	fin_desc28	varchar(28)	No	Aircraft Ownership	Yes
job_type	fin_desc28	varchar(28)	No	Job type	Yes
field_base	fin_text255	varchar(255)	No	field_base	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
task_type	fin_desc40	varchar(40)	No	task_type	Yes
Expclass	fin_desc28	varchar(28)	No	Expense Class	Yes
sequence_no	fin_sequence	int(4)	Yes	Sequence Number	No
timestamp	fin_int	int(4)	Yes	Time Stamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes


Table Name :	ard_flogconsump_param_mst
Comment :	Gives the parameters set for Techlog consumption account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
doc_class	fin_cmbflag	varchar(4)	No	doc_class	Yes
doc_type	fin_cmbflag	varchar(4)	No	doc_type	Yes
doc_category	fin_cmbflag	varchar(4)	No	doc_category	Yes
plan_base	fin_cmbflag	varchar(4)	No	Planning Base	Yes
maint_base	fin_cmbflag	varchar(4)	No	Maintenance Location	Yes
work_center	fin_cmbflag	varchar(4)	No	Work Center	Yes
usg_type	fin_cmbflag	varchar(4)	No	Usage Type	Yes
rep_station	fin_cmbflag	varchar(4)	No	rep_station	Yes
aircraft_model	fin_cmbflag	varchar(4)	No	Aircraft Model	Yes
aircraft_own	fin_cmbflag	varchar(4)	No	Aircraft Ownership	Yes
job_type	fin_cmbflag	varchar(4)	No	Job type	Yes
field_base	fin_cmbflag	varchar(4)	No	field_base	Yes
task_type	fin_cmbflag	varchar(4)	No	task_type	Yes
timestamp	fin_int	int(4)	Yes	Time Stamp	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
REPLICATION_KEY	bigint	Bigint(8)	No	REPLICATION KEY	Yes


Table Name :	ard_fltcontract_account_mst
Comment :	Flight Contract Account Parameters Definition


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	OU Instance	No
company_code	fin_companycode	varchar(10)	Yes	Company Code	No
fbid	fin_financebookid	varchar(20)	Yes	Financial Book Id	No
cust_grp	fin_ardparameter	varchar(40)	Yes	Customer Group	No
ordercur	fin_currency	varchar(5)	Yes	Order Currency	No
charttyp	fin_desc40	varchar(40)	Yes	Charter Type	No
chartcat	fin_desc40	varchar(40)	Yes	Charter Category	No
billinghead	fin_desc40	varchar(40)	Yes	Billing Head	No
Revenuacc	fin_accountcode	varchar(32)	Yes	Revenue Account	No
effective_from	fin_datetime	datetime(8)	Yes	Effective From Date	No
effective_to	fin_datetime	datetime(8)	Yes	Effective To Date	No
sequence_no	fin_int	int(4)	Yes	Sequence No	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	bigint	Bigint(8)	No	Replication Key	Yes


Table Name :	ard_fltcontract_param_mst
Comment :	Set Flight Contract Parameters Details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	Yes	Company Code	No
custgrp	fin_cmbflag	varchar(4)	Yes	Customer Group	No
ordcur	fin_cmbflag	varchar(4)	Yes	Order Currency	No
charttype	fin_cmbflag	varchar(4)	Yes	charter Type	No
chartcat	fin_cmbflag	varchar(4)	Yes	Charter Category	No
billinghead	fin_cmbflag	varchar(4)	Yes	Billing Head	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	bigint	Bigint(8)	No	Replication key	Yes


Table Name :	ard_intcustomer_account_mst
Comment :	Customer account master


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
source_buid	fin_buid	varchar(20)	No	Source Business Unit Id	Yes
dest_company	fin_companycode	varchar(10)	No	Destination Company	Yes
dest_buid	fin_financebookid	varchar(20)	No	Destination Business Unit Id	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
custctrl_account	fin_accountcode	varchar(32)	Yes	Customer Control Account	No
custprepay_account	fin_accountcode	varchar(32)	Yes	Customer Prepay Account	No
custnonar_account	fin_accountcode	varchar(32)	Yes	Customer Deposit Account	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_intsupplier_account_mst
Comment :	Supplier account master


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
source_buid	fin_financebookid	varchar(20)	No	Source Business Unit Id	Yes
dest_company	fin_companycode	varchar(10)	No	Destination Company	Yes
dest_buid	fin_financebookid	varchar(20)	No	Destination Business Unit Id	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
supppay_account	fin_accountcode	varchar(32)	Yes	Supplier Pay Account	No
suppprepay_account	fin_accountcode	varchar(32)	Yes	Supplier Prepay Account	No
suppdeposit_account	fin_accountcode	varchar(32)	Yes	Supplier Deposit Account	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_item_account_mst
Comment :	Gives the item accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
item_acctgrp	fin_itemgroup	varchar(25)	No	Item Account Group	Yes
item_code	fin_itemcode	varchar(40)	No	Item Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
account_type	fin_desc40	varchar(40)	No	Account Type	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
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_item_event_met
Comment :	Gives the item events-- metadata


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
event_code	fin_cmbflag	varchar(4)	No	Event Code	Yes
entry	fin_sequence	int(4)	No	Entry	Yes
drcr_flag	fin_cmbflag	varchar(4)	No	Debit Credit Flag	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
event_desc	fin_desc255	varchar(255)	Yes	Event Description	No
account_type	fin_desc40	varchar(40)	Yes	Account Type	No
account_type_code	fin_desc20	varchar(20)	Yes	Account Type Code	No
component	fin_cmbflag	varchar(4)	Yes	Component	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 :	ard_sale_account_mst
Comment :	Gives the sales account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
event	fin_desc40	varchar(40)	No	Event	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
item_acctgrp	fin_itemgroup	varchar(25)	Yes	Item Account Group	No
item_code	fin_itemcode	varchar(40)	Yes	Item Code	No
sale_ordertype	fin_desc40	varchar(40)	Yes	Sale Order Type	No
sale_type	fin_desc40	varchar(40)	Yes	Sale Type	No
sale_channel	fin_desc40	varchar(40)	Yes	Sale Channel	No
delivery_area	fin_desc40	varchar(40)	Yes	Delivery Area	No
customer_group	fin_desc40	varchar(40)	Yes	Customer Group	No
sale_purpose	fin_desc40	varchar(40)	Yes	Sale Purpose	No
promotion_id	fin_desc40	varchar(40)	Yes	Promotion Id	No
receipt_type	fin_desc40	varchar(40)	Yes	Receipt Type	No
processing_action	fin_desc40	varchar(40)	Yes	Processing Action	No
reason_code	fin_quickcodes	varchar(25)	Yes	Reason Code	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_sale_param_mst
Comment :	Gives the parameters set for sales account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
sale_ordertype	fin_cmbflag	varchar(4)	Yes	Sale Order Type	No
sale_type	fin_cmbflag	varchar(4)	Yes	Sale Type	No
sale_channel	fin_cmbflag	varchar(4)	Yes	Sale Channel	No
delivery_area	fin_cmbflag	varchar(4)	Yes	Delivery Area	No
customer_group	fin_cmbflag	varchar(4)	Yes	Customer Group	No
sale_purpose	fin_cmbflag	varchar(4)	Yes	Sale Purpose	No
promotion_id	fin_cmbflag	varchar(4)	Yes	Promotion Id	No
reciept_type	fin_cmbflag	varchar(4)	Yes	Reciept Type	No
processing_action	fin_cmbflag	varchar(4)	Yes	Processing Action	No
reason_code	fin_cmbflag	varchar(4)	Yes	Reason Code	No
sale_flag	fin_cmbflag	varchar(4)	Yes	Sale Flag	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 :	ard_ser_account_mst
Comment :	Gives the service accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fbid	fin_financebookid	varchar(20)	No	Financial Book Id	Yes
cust_grp	fin_ardparameter	varchar(40)	No	Customer Group	Yes
mainbase	fin_ouinstdesc	varchar(256)	No	Maintenance Base	Yes
wrkctr	fin_text	varchar(256)	No	Work Center	Yes
ordcate	fin_desc28	varchar(28)	No	Order Category	Yes
effective_from	fin_datetime	datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
ordcurr	fin_currency	varchar(5)	No	Order Currency	Yes
Expclass	fin_desc28	varchar(28)	No	Expense Class	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
seraccount	fin_accountcode	varchar(32)	Yes	Service Account	No
cosaccount	fin_accountcode	varchar(32)	Yes	Cost of Service Account	No
effective_to	fin_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
saletype	fin_quickcodes	varchar(25)	Yes	Sale Type	No
execat	fin_quickcodes	varchar(25)	Yes	execat	No


Table Name :	ard_ser_param_mst
Comment :	Gives the parameters set for service account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
custgroup	fin_cmbflag	varchar(4)	Yes	Customer Group	No
mainbase	fin_cmbflag	varchar(4)	Yes	Maintenance Base	No
wrkctr	fin_cmbflag	varchar(4)	Yes	Work Center	No
ordcat	fin_cmbflag	varchar(4)	Yes	Order Category	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
ordcurr	fin_currency	varchar(5)	Yes	Order Currency	No
sltype	fin_cmbflag	varchar(4)	Yes	Sale type	No
execat	fin_cmbflag	varchar(4)	Yes	execat	No


Table Name :	ard_supplier_account_mst
Comment :	Gives the supplier accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
supplier_group	fin_suppliergroup	varchar(20)	No	Supplier Group	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	No	Time Stamp	No
supppay_account	fin_accountcode	varchar(32)	No	Supplier Pay Account	No
suppprepay_account	fin_accountcode	varchar(32)	No	Supplier Prepay Account	No
suppdeposit_account	fin_accountcode	varchar(32)	No	Supplier Deposit Account	No
effective_to	datetime	Datetime(8)	No	Effective To	No
resou_id	fin_ouinstid	int(4)	No	Resource Id	No
createdby	fin_ctxt_user	varchar(30)	No	Created By	No
createddate	datetime	Datetime(8)	No	Created Date	No
modifiedby	fin_ctxt_user	varchar(30)	No	Modified By	No
modifieddate	datetime	Datetime(8)	No	Modified Date	No


Table Name :	ard_tcdpurchase_account_mst
Comment :	Gives the tcd code/variant mapped to purchase accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
tcd_code	fin_quickcodes	varchar(25)	No	Tax Charge Discount Code	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
tcd_vrnt	fin_quickcodes	varchar(25)	No	Tax Charge Discount Variant	Yes
drcr_flag	fin_cmbflag	varchar(4)	No	Debit Credit Flag	Yes
supplier_group	fin_suppliergroup	varchar(20)	No	Supplier Group	Yes
gr_ouid	fin_ouinstid	int(4)	No	Goods Receipt Organization Unit Id	Yes
gr_type	fin_flag	varchar(25)	No	Goods Receipt Type	Yes
gr_folder	fin_folder	varchar(40)	No	Goods Receipt Folder	Yes
trans_mode	fin_transportationmode	varchar(25)	No	Transaction Mode	Yes
num_series	fin_notypeno	varchar(10)	No	Number Series	Yes
tcd_class	fin_classification	varchar(20)	No	Tax Charge Discount Class	Yes
event	fin_cmbflag	varchar(4)	No	Event	Yes
tcd_type	fin_cmbflag	varchar(4)	No	Tax Charge Discount Type	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
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_tcdpurchase_param_mst
Comment :	Gives the parameters set for purchase account - tcd code/variant mapping


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
tcd_type	fin_cmbflag	varchar(4)	No	Tax Charge Discount Type	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
supplier_group	fin_cmbflag	varchar(4)	Yes	Supplier Group	No
gr_ouid	fin_cmbflag	varchar(4)	Yes	Goods Receipt Organization Unit Id	No
gr_type	fin_cmbflag	varchar(4)	Yes	Goods Receipt Type	No
gr_folder	fin_cmbflag	varchar(4)	Yes	Goods Receipt Folder	No
trans_mode	fin_cmbflag	varchar(4)	Yes	Transaction Mode	No
num_series	fin_cmbflag	varchar(4)	Yes	Number Series	No
tcd_class	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Class	No
set_flag	fin_cmbflag	varchar(4)	Yes	Set Flag	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 :	ard_tcdsale_account_mst
Comment :	Gives the tcd code/variant mapped to sales account


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
tcd_code	fin_quickcodes	varchar(25)	No	Tax Charge Discount Code	Yes
tcd_vrnt	fin_quickcodes	varchar(25)	No	Tax Charge Discount Variant	Yes
drcr_flag	fin_cmbflag	varchar(4)	No	Debit Credit Flag	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
delivery_area	fin_desc40	varchar(40)	No	Delivery Area	Yes
customer_group	fin_customer_id	varchar(18)	No	Customer Group	Yes
sale_channel	fin_saleschannel	varchar(6)	No	Sale Channel	Yes
processing_action	fin_actionprocess	varchar(20)	No	Processing Action	Yes
sale_purpose	fin_desc40	varchar(40)	No	Sale Purpose	Yes
sale_type	fin_desc40	varchar(40)	No	Sale Type	Yes
promotion_id	fin_promotion	varchar(25)	No	Promotion Id	Yes
tcd_type	fin_desc40	varchar(40)	No	Tax Charge Discount Type	Yes
sequence_no	fin_sequence	int(4)	No	Sequence Number	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
taxacctgin_salecycle	fin_cmbflag	varchar(4)	Yes	Tax Accounting Sale Cycle	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
effective_to	datetime	Datetime(8)	Yes	Effective To	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 :	ard_tcdsale_param_mst
Comment :	Gives the parameters set for sales account - tcd code/variant mapping


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
tcd_type	fin_cmbflag	varchar(4)	No	Tax Charge Discount Type	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
tcd_deliveryarea	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Delivery Area	No
tcd_custgroup	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Customer Group	No
tcd_salechannel	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Sale Channel	No
tcd_processaction	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Processing Action	No
tcd_salepurpose	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Sale Purpose	No
tcd_promotionid	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Promotion Id	No
tcd_saletype	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Sale Type	No
tcd_flag	fin_cmbflag	varchar(4)	Yes	Tax Charge Discount Flag	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 :	ard_usage_event_map
Comment :	Gives the usage and event mapping


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
usage_id	fin_usageid	varchar(20)	No	Usage Id	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction Type	Yes
timestamp	int	int(4)	Yes	Time Stamp	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 :	ard_usage_met
Comment :	Gives the usages and account type mapping -- meta data


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
usage_id	fin_usageid	varchar(20)	No	Usage Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
usage_type	fin_cmbflag	varchar(4)	Yes	Usage Type	No
usage_shortdesc	fin_desc40	varchar(40)	Yes	Usage Short Description	No
usage_desc	fin_desc255	varchar(255)	Yes	Usage Description	No
ard_type	fin_desc20	varchar(20)	Yes	Account Rule Definition Type	No
account_group	fin_accountgroup	varchar(15)	Yes	Account Group	No
account_currency	fin_currencycode	varchar(5)	Yes	Account Currency	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 :	ard_usage_mst
Comment :	Gives the usages and account type mapping


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
usage_id	fin_usageid	varchar(20)	No	Usage Id	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
usage_type	fin_cmbflag	varchar(4)	Yes	Usage Type	No
usage_shortdesc	fin_desc40	varchar(40)	Yes	Usage Short Description	No
usage_desc	fin_desc255	varchar(255)	Yes	Usage Description	No
account_desc	fin_accountdescription	varchar(40)	Yes	Account Description	No
ard_type	fin_desc20	varchar(20)	Yes	Account Rule Definition Type	No
account_group	fin_accountgroup	varchar(15)	Yes	Account Group	No
account_currency	fin_currencycode	varchar(5)	Yes	Account Currency	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 :	ard_vat_account_mst
Comment :	Gives the vat accounts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company Code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance Book Id	Yes
vat_category	fin_vatcategory	varchar(40)	No	Value Added Tax Category	Yes
vat_account_type	fin_vataccounttype	varchar(40)	No	Value Added Tax Account Type	Yes
vat_group	fin_quickcodes	varchar(25)	No	Value Added Tax Group	Yes
item_type	fin_cmbflag	varchar(4)	No	Item Type	Yes
itemtc_code	fin_itemcode	varchar(40)	No	Item Tax Charge Code	Yes
itemtc_variant	fin_itemcode	varchar(40)	No	Item Tax Charge Variant	Yes
effective_from	datetime	Datetime(8)	No	Effective From	Yes
sequence_no	fin_sequence	int(4)	No	Sequence No	Yes
timestamp	int	int(4)	Yes	Time Stamp	No
account_code	fin_accountcode	varchar(32)	Yes	Account Code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost Center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis Code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis Code	No
effective_to	datetime	Datetime(8)	Yes	Effective To	No
applicable_on	fin_cmbflag	varchar(4)	Yes	Applicable On	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