Account Rule Definition

Data Dictionary -Account Rule Definition

Table Name ard_addn_account_mst

Table Comment Gives the additional accounts mapped to usage
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
usage_id	varchar(20)	NOT NULL	Usage Id	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
drcr_flag	varchar(4)	NOT NULL	Debit Credit Flag	Yes	No
dest_fbid	varchar(20)	NOT NULL	Destination Finance Book Id	Yes	No
child_company	varchar(10)	NOT NULL	Child Company	Yes	No
dest_company	varchar(10)	NOT NULL	Destination Company	Yes	No
sequence_no	varchar(4)	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	No	No
resou_id	int	NULL	Resource Id	No	No
usage_type	varchar(4)	NULL	Usage Type	No	No
ard_type	varchar(20)	NULL	Account Rule Definition Type	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 ard_airconsump_account_mst

Table Comment Gives the aircraft consumption account
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
event	varchar(40)	NOT NULL	Event	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
wo_ordertype	varchar(40)	NOT NULL	Work Order Type	Yes	No
wo_ordercategory	varchar(40)	NOT NULL	Work Order Category	Yes	No
plan_base	varchar(255)	NOT NULL	Planning Base	Yes	No
maint_location	varchar(256)	NOT NULL	Maintenance Location	Yes	No
work_center	varchar(255)	NOT NULL	Work Center	Yes	No
usg_typ	varchar(28)	NOT NULL	Usage Type	Yes	No
vst_cat	varchar(28)	NOT NULL	Visit Package Category.Values CUSTOMER JOB,FRESH,OTHER,SCHEDULED WORK,VCCAT1	Yes	No
air_model	varchar(20)	NOT NULL	Aircraft Model	Yes	No
air_own	varchar(28)	NOT NULL	Aircraft Ownership	Yes	No
job_type	varchar(28)	NOT NULL	Job type	Yes	No
wo_class	varchar(28)	NOT NULL	Work Order Class	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
Expclass	varchar(28)	NOT NULL	Expense Class	Yes	No
sequence_no	int	NOT NULL	Sequence Number	No	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	No	No
resou_id	varchar(4)	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 ard_airconsump_param_mst

Table Comment Gives the parameters set for aircraft consumption account
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	No	No
event	varchar(40)	NOT NULL	Event	No	No
timestamp	int	NULL	Time Stamp	No	No
work_ordertype	varchar(4)	NULL	Work Order Type	No	No
work_ordercategory	varchar(4)	NULL	Work Order Category	No	No
plan_base	varchar(4)	NULL	Planning Base	No	No
maint_location	varchar(4)	NULL	Maintenance Location	No	No
work_center	varchar(4)	NULL	Work Center	No	No
usg_typ	varchar(4)	NULL	Usage Type	No	No
vst_cat	varchar(4)	NULL	Visit Package Category.Values CUSTOMER JOB,FRESH,OTHER,SCHEDULED WORK,VCCAT1	No	No
air_model	varchar(4)	NULL	Aircraft Model	No	No
air_own	varchar(4)	NULL	Aircraft Ownership	No	No
job_typ	varchar(4)	NULL	Job Type	No	No
resou_id	int	NULL	Resource Id	No	No
set_flag	varchar(4)	NULL	Set Flag	No	No
wo_class	varchar(4)	NULL	Work Order Class	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 ard_asset_account_mst

Table Comment Gives the asset accounts
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
asset_class	varchar(20)	NOT NULL	Asset Class	Yes	No
asset_usage	varchar(20)	NOT NULL	Asset Usage	Yes	No
effective_from	varchar(8)	NOT NULL	Effective From	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
effective_to	datetime	NULL	Effective To	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 ard_bnkcsh_account_mst

Table Comment Gives the bank cash accounts
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
bank_ptt_code	varchar(32)	NOT NULL	Bank / PTT Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
bankptt_account	varchar(32)	NULL	Bank / PTT Account	No	No
bankcharge_account	varchar(32)	NULL	Bank Charge Account	No	No
effective_to	datetime	NULL	Effective To	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 ard_consump_account_mst

Table Comment Gives the component/non-component consumptino accounts
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	No	No
event	varchar(40)	NOT NULL	Event	No	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	No	No
wo_ordertype	varchar(40)	NOT NULL	Work Order Type	No	No
wo_ordercategory	varchar(40)	NOT NULL	Work Order Category	No	No
plan_base	varchar(255)	NOT NULL	Planning Base	No	No
maint_location	varchar(256)	NOT NULL	Maintenance Location	No	No
work_center	varchar(255)	NOT NULL	Work Center	No	No
part_class	varchar(28)	NOT NULL	Part Class	No	No
comp_type	varchar(28)	NOT NULL	Component Type	No	No
comp_fam	varchar(28)	NOT NULL	Component Family	No	No
comp_own	varchar(16)	NOT NULL	Component Owner	No	No
effective_from	datetime	NOT NULL	Effective From	No	No
sequence_no	int	NOT NULL	Sequence Number	No	No
poss_stat	varchar(40)	NOT NULL	Possession Status .Values Y- Yes, N- No	No	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	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
cost_type	varchar(40)	NULL	Cost Type	No	No
wo_plantype	varchar(40)	NULL	Work Order Planing Type	No	No
wo_plancategory	varchar(40)	NULL	Work Order Planning Category	No	No
shop_type	varchar(28)	NOT NULL	Shop Type	No	No
Expclass	varchar(28)	NOT NULL	Expense Class	No	No

Table Name ard_consump_param_mst

Table Comment Gives the parameters set for component/non-component consumption account
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
event	varchar(40)	NOT NULL	Event	Yes	No
timestamp	int	NULL	Time Stamp	No	No
work_ordertype	varchar(4)	NULL	Work Order Type	No	No
work_ordercategory	varchar(4)	NULL	Work Order Category	No	No
maint_location	varchar(4)	NULL	Maintenance Location	No	No
cost_type	varchar(4)	NULL	Cost Type	No	No
plan_type	varchar(4)	NULL	Planning Type	No	No
plan_category	varchar(4)	NULL	Planning Category	No	No
resou_id	int	NULL	Resource Id	No	No
set_flag	varchar(4)	NULL	Set 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
plan_base	varchar(4)	NULL	Planning Base	No	No
work_center	varchar(4)	NULL	Work Center	No	No
part_class	varchar(4)	NULL	Part Class	No	No
comp_type	varchar(4)	NULL	Component Type	No	No
comp_fam	varchar(4)	NULL	Component Familty	No	No
comp_own	varchar(4)	NULL	Component Owner	No	No
poss_stat	varchar(4)	NULL	Possession Status .Values Y- Yes, N- No	No	No
shop_type	varchar(28)	NULL	Shop type	No	No

Table Name ard_customer_account_mst

Table Comment Gives the customer accounts
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
customer_group	varchar(18)	NOT NULL	Customer Group	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
custctrl_account	varchar(32)	NULL	Customer Control Account	No	No
custprepay_account	varchar(32)	NULL	Customer Prepay Account	No	No
custnonar_account	varchar(32)	NULL	Customer Deposit Account	No	No
effective_to	datetime	NULL	Effective To	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 ard_del_account_count
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
guid	varchar(40)	NOT NULL	Guid	No	No
timestamp	int	NULL	Time Stamp	No	No
record_no	int	NULL	Record Number	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 ard_intcustomer_account_mst
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
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
source_buid	varchar(20)	NOT NULL	Source Business Unit Id	Yes	No
dest_company	varchar(10)	NOT NULL	Destination Company	Yes	No
dest_buid	varchar(20)	NOT NULL	Destination Business Unit Id	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
custctrl_account	varchar(32)	NULL	Customer Control Account	No	No
custprepay_account	varchar(32)	NULL	Customer Prepay Account	No	No
custnonar_account	varchar(32)	NULL	Customer Deposit Account	No	No
effective_to	datetime	NULL	Effective To	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 ard_intsupplier_account_mst
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
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
source_buid	varchar(20)	NOT NULL	Source Business Unit Id	Yes	No
dest_company	varchar(10)	NOT NULL	Destination Company	Yes	No
dest_buid	varchar(20)	NOT NULL	Destination Business Unit Id	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
supppay_account	varchar(32)	NULL	Supplier Pay Account	No	No
suppprepay_account	varchar(32)	NULL	Supplier Prepay Account	No	No
suppdeposit_account	varchar(32)	NULL	Supplier Deposit Account	No	No
effective_to	datetime	NULL	Effective To	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 ard_item_account_mst

Table Comment Gives the item accounts
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
item_acctgrp	varchar(25)	NOT NULL	Item Account Group	Yes	No
item_code	varchar(40)	NOT NULL	Item Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
account_type	varchar(40)	NOT NULL	Account Type	Yes	No
sequence_no	varchar(4)	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	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 ard_item_event_met
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
event_code	varchar(10)	NOT NULL	Event Code	Yes	No
entry	int	NOT NULL	Entry	Yes	No
drcr_flag	varchar(4)	NOT NULL	Debit Credit Flag	Yes	No
timestamp	int	NULL	Time Stamp	No	No
event_desc	varchar(255)	NULL	Event Description	No	No
account_type	varchar(40)	NULL	Account Type	No	No
account_type_code	varchar(20)	NULL	Account Type Code	No	No
component	varchar(4)	NULL	Component	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 ard_sale_account_mst

Table Comment Gives the sales account
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
event	varchar(40)	NOT NULL	Event	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
item_acctgrp	varchar(25)	NULL	Item Account Group	No	No
item_code	varchar(40)	NULL	Item Code	No	No
sale_ordertype	varchar(40)	NULL	Sale Order Type	No	No
sale_type	varchar(40)	NULL	Sale Type	No	No
sale_channel	varchar(40)	NULL	Sale Channel	No	No
delivery_area	varchar(40)	NULL	Delivery Area	No	No
customer_group	varchar(40)	NULL	Customer Group	No	No
sale_purpose	varchar(40)	NULL	Sale Purpose	No	No
promotion_id	varchar(40)	NULL	Promotion Id	No	No
receipt_type	varchar(40)	NULL	Receipt Type	No	No
processing_action	varchar(40)	NULL	Processing Action	No	No
reason_code	varchar(25)	NULL	Reason Code	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	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 ard_sale_param_mst

Table Comment Gives the parameters set for sales account
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
timestamp	int	NULL	Time Stamp	No	No
sale_ordertype	varchar(4)	NULL	Sale Order Type	No	No
sale_type	varchar(4)	NULL	Sale Type	No	No
sale_channel	varchar(4)	NULL	Sale Channel	No	No
delivery_area	varchar(4)	NULL	Delivery Area	No	No
customer_group	varchar(18)	NULL	Customer Group	No	No
sale_purpose	varchar(4)	NULL	Sale Purpose	No	No
promotion_id	varchar(4)	NULL	Promotion Id	No	No
reciept_type	varchar(4)	NULL	Reciept Type	No	No
processing_action	varchar(4)	NULL	Processing Action	No	No
reason_code	varchar(4)	NULL	Reason Code	No	No
sale_flag	varchar(4)	NULL	Sale Flag	No	No
resou_id	varchar(4)	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 ard_ser_account_mst

Table Comment Gives the service accounts
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
fbid	varchar(20)	NOT NULL	Financial Book Id	Yes	No
cust_grp	varchar(40)	NOT NULL	Customer Group	Yes	No
mainbase	varchar(256)	NOT NULL	Maintenance Base	Yes	No
wrkctr	varchar(256)	NOT NULL	Work Center	Yes	No
ordcate	varchar(28)	NOT NULL	Order Category	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
ordcurr	int	NOT NULL	Order Currency	Yes	No
Expclass	varchar(32)	NOT NULL	Expense Class	Yes	No
timestamp	varchar(32)	NULL	Time Stamp	No	No
seraccount	datetime	NULL	Service Account	No	No
cosaccount	varchar(15)	NULL	Cost of Service Account	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(5)	NULL	Modified By	No	No
modifieddate	varchar(28)	NULL	Modified Date	No	No

Table Name ard_ser_param_mst

Table Comment Gives the parameters set for service account
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
timestamp	int	NULL	Time Stamp	No	No
custgroup	varchar(4)	NULL	Customer Group	No	No
mainbase	varchar(4)	NULL	Maintenance Base	No	No
wrkctr	varchar(4)	NULL	Work Center	No	No
ordcat	varchar(4)	NULL	Order Category	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
ordcurr	varchar(5)	NULL	Order Currency	No	No

Table Name ard_supplier_account_mst

Table Comment Gives the supplier accounts
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
supplier_group	varchar(20)	NOT NULL	Supplier Group	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
supppay_account	varchar(32)	NULL	Supplier Pay Account	No	No
suppprepay_account	varchar(32)	NULL	Supplier Prepay Account	No	No
suppdeposit_account	varchar(32)	NULL	Supplier Deposit Account	No	No
effective_to	datetime	NULL	Effective To	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 ard_tcdpurchase_account_mst

Table Comment Gives the tcd code/variant mapped to purchase accounts
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
tcd_code	varchar(25)	NOT NULL	Tax Charge Discount Code	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
tcd_vrnt	varchar(25)	NOT NULL	Tax Charge Discount Variant	Yes	No
drcr_flag	varchar(4)	NOT NULL	Debit Credit Flag	Yes	No
supplier_group	varchar(20)	NOT NULL	Supplier Group	Yes	No
gr_ouid	int	NOT NULL	Goods Receipt Organization Unit Id	Yes	No
gr_type	varchar(25)	NOT NULL	Goods Receipt Type	Yes	No
gr_folder	varchar(40)	NOT NULL	Goods Receipt Folder	Yes	No
trans_mode	varchar(25)	NOT NULL	Transaction Mode	Yes	No
num_series	varchar(10)	NOT NULL	Number Series	Yes	No
tcd_class	varchar(20)	NOT NULL	Tax Charge Discount Class	Yes	No
event	varchar(4)	NOT NULL	Event	Yes	No
tcd_type	varchar(4)	NOT NULL	Tax Charge Discount Type	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
effective_to	datetime	NULL	Effective To	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 ard_tcdpurchase_param_mst

Table Comment Gives the parameters set for purchase account - tcd code/variant mapping
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
tcd_type	varchar(4)	NOT NULL	Tax Charge Discount Type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
supplier_group	varchar(4)	NULL	Supplier Group	No	No
gr_ouid	varchar(4)	NULL	Goods Receipt Organization Unit Id	No	No
gr_type	varchar(4)	NULL	Goods Receipt Type	No	No
gr_folder	varchar(4)	NULL	Goods Receipt Folder	No	No
trans_mode	varchar(4)	NULL	Transaction Mode	No	No
num_series	varchar(4)	NULL	Number Series	No	No
tcd_class	varchar(4)	NULL	Tax Charge Discount Class	No	No
set_flag	varchar(4)	NULL	Set Flag	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 ard_tcdsale_account_mst

Table Comment Gives the tcd code/variant mapped to sales account
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
tcd_code	varchar(25)	NOT NULL	Tax Charge Discount Code	Yes	No
tcd_vrnt	varchar(25)	NOT NULL	Tax Charge Discount Variant	Yes	No
drcr_flag	varchar(4)	NOT NULL	Debit Credit Flag	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
delivery_area	varchar(40)	NOT NULL	Delivery Area	Yes	No
customer_group	varchar(18)	NOT NULL	Customer Group	Yes	No
sale_channel	varchar(6)	NOT NULL	Sale Channel	Yes	No
processing_action	varchar(20)	NOT NULL	Processing Action	Yes	No
sale_purpose	varchar(40)	NOT NULL	Sale Purpose	Yes	No
sale_type	varchar(40)	NOT NULL	Sale Type	Yes	No
promotion_id	varchar(25)	NOT NULL	Promotion Id	Yes	No
tcd_type	varchar(40)	NOT NULL	Tax Charge Discount Type	Yes	No
sequence_no	int	NOT NULL	Sequence Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
taxacctgin_salecycle	varchar(4)	NULL	Tax Accounting Sale Cycle	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	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 ard_tcdsale_param_mst

Table Comment Gives the parameters set for sales account - tcd code/variant mapping
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
tcd_type	varchar(4)	NOT NULL	Tax Charge Discount Type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
tcd_deliveryarea	varchar(4)	NULL	Tax Charge Discount Delivery Area	No	No
tcd_custgroup	varchar(4)	NULL	Tax Charge Discount Customer Group	No	No
tcd_salechannel	varchar(4)	NULL	Tax Charge Discount Sale Channel	No	No
tcd_processaction	varchar(4)	NULL	Tax Charge Discount Processing Action	No	No
tcd_salepurpose	varchar(4)	NULL	Tax Charge Discount Sale Purpose	No	No
tcd_promotionid	varchar(4)	NULL	Tax Charge Discount Promotion Id	No	No
tcd_saletype	varchar(4)	NULL	Tax Charge Discount Sale Type	No	No
tcd_flag	varchar(4)	NULL	Tax Charge Discount Flag	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 ard_usage_event_map

Table Comment Gives the usage and event mapping
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
usage_id	varchar(20)	NOT NULL	Usage Id	Yes	No
tran_type	varchar(40)	NOT NULL	Transaction Type	Yes	No
timestamp	int	NULL	Time Stamp	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 ard_usage_met

Table Comment Gives the usages and account type mapping -- meta data
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
usage_id	varchar(20)	NOT NULL	Usage Id	Yes	No
timestamp	int	NULL	Time Stamp	No	No
usage_type	varchar(4)	NULL	Usage Type	No	No
usage_shortdesc	varchar(40)	NULL	Usage Short Description	No	No
usage_desc	varchar(255)	NULL	Usage Description	No	No
ard_type	varchar(20)	NULL	Account Rule Definition &nbspType	No	No
account_group	varchar(15)	NULL	Account Group	No	No
account_currency	varchar(5)	NULL	Account Currency	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 ard_usage_mst

Table Comment Gives the usages and account type mapping
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
usage_id	varchar(20)	NOT NULL	Usage Id	Yes	No
timestamp	int	NULL	Time Stamp	No	No
usage_type	varchar(4)	NULL	Usage Type	No	No
usage_shortdesc	varchar(40)	NULL	Usage Short Description	No	No
usage_desc	varchar(255)	NULL	Usage Description	No	No
account_desc	varchar(40)	NULL	Account Description	No	No
ard_type	varchar(20)	NULL	Account Rule Definition Type	No	No
account_group	varchar(15)	NULL	Account Group	No	No
account_currency	varchar(5)	NULL	Account Currency	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 ard_vat_account_mst

Table Comment Gives the vat accounts
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
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
vat_category	varchar(40)	NOT NULL	Value Added Tax Category	Yes	No
vat_account_type	varchar(40)	NOT NULL	Value Added Tax Account Type	Yes	No
vat_group	varchar(25)	NOT NULL	Value Added Tax Group	Yes	No
item_type	varchar(4)	NOT NULL	Item Type	Yes	No
itemtc_code	varchar(40)	NOT NULL	Item Tax Charge Code	Yes	No
itemtc_variant	varchar(40)	NOT NULL	Item Tax Charge Variant	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
sequence_no	int	NOT NULL	Sequence No	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
cost_center	varchar(10)	NULL	Cost Center	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
effective_to	datetime	NULL	Effective To	No	No
applicable_on	varchar(4)	NULL	Applicable On	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 ARD_flogconsump_account_mst

Table Comment Gives the aircraft techlog consumption account
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
event	varchar(40)	NOT NULL	Event	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
doc_class	varchar(40)	NOT NULL	doc_class	Yes	No
doc_type	varchar(40)	NOT NULL	doc_type	Yes	No
doc_category	varchar(40)	NOT NULL	doc_category	Yes	No
plan_base	varchar(255)	NOT NULL	Planning Base	Yes	No
maint_base	varchar(256)	NOT NULL	Maintenance Location	Yes	No
work_center	varchar(255)	NOT NULL	Work Center	Yes	No
usg_type	varchar(28)	NOT NULL	Usage Type	Yes	No
rep_station	varchar(28)	NOT NULL	rep_station	Yes	No
aircraft_model	varchar(20)	NOT NULL	Aircraft Model	Yes	No
aircraft_own	varchar(28)	NOT NULL	Aircraft Ownership	Yes	No
job_type	varchar(28)	NOT NULL	Job type	Yes	No
field_base	varchar(28)	NOT NULL	field_base	Yes	No
effective_from	datetime	NOT NULL	Effective From	Yes	No
task_type	varchar(40)	NOT NULL	task_type	Yes	No
Expclass	varchar(28)	NOT NULL	Expense Class	Yes	No
sequence_no	int	NOT NULL	Sequence Number	No	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NULL	Account Code	No	No
effective_to	datetime	NULL	Effective To	No	No
resou_id	varchar(4)	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 ard_flogconsump_param_mst

Table Comment Gives the parameters set for Techlog consumption account
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
event	varchar(40)	NOT NULL	Event	Yes	No
doc_class	varchar(40)	NOT NULL	doc_class	Yes	No
doc_type	varchar(40)	NOT NULL	doc_type	Yes	No
doc_category	varchar(40)	NOT NULL	doc_category	Yes	No
plan_base	varchar(255)	NOT NULL	Planning Base	Yes	No
maint_base	varchar(256)	NOT NULL	Maintenance Location	Yes	No
work_center	varchar(255)	NOT NULL	Work Center	Yes	No
usg_type	varchar(28)	NOT NULL	Usage Type	Yes	No
rep_station	varchar(28)	NOT NULL	rep_station	Yes	No
aircraft_model	varchar(20)	NOT NULL	Aircraft Model	Yes	No
aircraft_own	varchar(28)	NOT NULL	Aircraft Ownership	Yes	No
job_type	varchar(28)	NOT NULL	Job type	Yes	No
field_base	varchar(28)	NOT NULL	field_base	Yes	No
task_type	varchar(40)	NOT NULL	task_type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
resou_id	varchar(4)	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

Data Dictionary -Account Rule Definition