Data Dictionary -- Account Group

Srl. No.	Table Name	Comment
1	AGP_CAG_Cust_Act_Grp	Customer Account Group
2	AGP_CAM_Cust_ActGrp_Map	Customer Account Group Map
3	AGP_EOS_ENTITY_OPTION_SETTINGS	Option settings regarding Entiry based Finance Book
4	agp_mlt_option_settings	Option Settings related to Work In Progress policy and cost and revenue
5	AGP_OS_OPTION_SETTINGS	Setting option
6	AGP_PAG_PART_ACT_GRP	Part Account Group
7	AGP_PAM_PART_ACTGRP_MAP	Part Account Group Map
8	AGP_PFB_ENTITY_FINANCE_BOOK	Finance Book used for posting
9	AGP_PFB_POSTING_FINANCE_BOOK	Posting finance book Account Group
10	AGP_SAG_SUPP_ACT_GRP	Supplier Account Group
11	AGP_SAM_SUPP_ACTGRP_MAP	Supplier Account Group Map
12	ag_fintrn_finance_trans_det	To stored internal posted transaction
13	Cmn_Ccrd_process_his	Cost Center retrieval history table
14	cmn_custexch_acctpost_metadata	Metadata table for exchange related cost booking
15	cmn_exofc_finpost_input_his	History table for exchange related input
16	Cmn_FLog_AcctPost_MetaData	AME related cost booking metadata
17	cmn_gi_acctpost_metadata	Metada for goods inward related cost booking
18	Cmn_GR_FinPost_Input_his	History for Goods receipt transaction Input temp
19	Cmn_Inv_AcctPost_MetaData	Metadata for Inventory cost booking
20	cmn_inv_finpost_input_his	History of Inventory accounting inputs
21	cmn_mnt_finpost_input_his	History for finance posting input details
22	Cmn_PO_AcctPost_MetaData	Metadata for Purchase order cost booking
23	cmn_ro_acctpost_metadata	Metadata for repair order cost booking
24	cmn_rr_finpost_input_his	History details for Account posting input information
25	cmn_swo_acctpost_metadata	Metadata for swo related cost booking
26	co_cocst_cost_summary	Exchange cost for repair order and advance exchange
27	ro_rocst_cost_summary	Cost details for repair order related

Table Name :	AGP_CAG_Cust_Act_Grp
Comment :	Customer Account Group

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CAG_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	This Column stores the Ouinstance in which the Customer Account Group has been created	No
CAG_Cust_Act_Grp_Code	udd_customer_id	varchar(18)	No	This Column stores the Customer Account Group Code .	No
CAG_Cust_Act_Grp_Desc	udd_accountdesc	varchar(60)	No	This Column stores the Customer Account Group Description	No
CAG_Cust_Act_Grp_Status	udd_docstatus	varchar(15)	No	This Column stores the Customer Account Group status	No
CAG_Created_By	udd_ctxt_user	varchar(30)	No	This Column stores the Customer Account Group Created by person	No
CAG_Created_Date	udd_datetime1	datetime(8)	No	This Column stores the Customer Account Group Created Date	No
CAG_Modified_By	udd_ctxt_user	varchar(30)	Yes	This Column stores the Customer Account Group Modified by Person	No
CAG_Modified_Date	udd_datetime1	datetime(8)	Yes	This Column stores the Customer Account Group Modified Date	No
CAG_TimeStamp	udd_timestamp	int(4)	No	This Column stores the Customer Account Group Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_CAM_Cust_ActGrp_Map
Comment :	Customer Account Group Map

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CAM_Created_OUInstance	udd_ctxt_ouinstance	int(4)	No	This Column stores the Ouinstance in which the Customer Account Group Map has been created	No
CAM_Cust_Act_Grp_Code	udd_customer_id	varchar(18)	No	This Column stores the Accout Group Code.	No
CAM_Customer_Code	udd_customer_id	varchar(18)	No	This Column stores the Customer Code	No
CAM_Customer_OU	udd_ctxt_ouinstance	int(4)	Yes	This Column stores the Ouinstance in which the Customer id# has been created	No
CAM_Created_By	udd_ctxt_user	varchar(30)	No	This Column stores the Created By in which the Customer Account Group Map has been created	No
CAM_Created_Date	udd_datetime1	datetime(8)	No	This Column stores the Created Date in which the Customer Account Group Map has been created	No
CAM_Modified_By	udd_ctxt_user	varchar(30)	No	This Column stores the Modified By in which the Customer Account Group Map has been Modified	No
CAM_Modified_Date	udd_datetime1	datetime(8)	No	This Column stores the Modified Date in which the Customer Account Group Map has been Modified	No
CAM_Timestamp	udd_timestamp	int(4)	Yes	This Column stores the Customer Account Group Map Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_EOS_ENTITY_OPTION_SETTINGS
Comment :	Option settings regarding Entiry based Finance Book

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
eos_ouinstance	fin_ctxt_ouinstance	int(4)	No	This Column stores the Ouinstance in which the Option settings regarding Entiry based Finance Book has been created	Yes
eos_entitybasedfb	fin_designparamcode	varchar(5)	Yes	This Column stores the entity based Finance book in which the Option settings regarding Entiry based Finance Book has been created	No
eos_created_by	fin_ctxt_user	varchar(30)	Yes	This Column stores the Created By in which the Option settings regarding Entiry based Finance Book has been created	No
eos_created_date	fin_datetime	datetime(8)	Yes	This Column stores the Created Date in which the Option settings regarding Entiry based Finance Book has been created	No
eos_modified_by	fin_ctxt_user	varchar(30)	Yes	This Column stores the Modified By in which the Option settings regarding Entiry based Finance Book has been Modified	No
eos_modified_date	fin_datetime	datetime(8)	Yes	This Column stores the Modified Date in which the Option settings regarding Entiry based Finance Book has been Modified	No
eos_timestamp	fin_timestamp	int(4)	Yes	This Column stores the Option settings regarding Entiry based Finance Book Modification Sequence number	No

Table Name :	agp_mlt_option_settings
Comment :	Option Settings related to Work In Progress policy and cost and revenue

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
os_seqno	fin_int	int(4)	Yes	This Column stores the Sequence No of each record in which the Option Settings related to Work In Progress policy and cost and revenue has been created	No
os_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	This Column stores the Ouinstance in which the Option Settings related to Work In Progress policy and cost and revenue has been created	No
os_timestamp	fin_timestamp	int(4)	Yes	This Column stores the Option Settings related to Work In Progress policy and cost and revenue Modification Sequence number	No
os_process_code	fin_param_code	varchar(6)	Yes	This Column stores the Process code Option Settings related to Work In Progress policy and cost and revenue	No
os_process_parameter	fin_param_text	varchar(255)	Yes	This Column stores the Process parameter Option Settings related to Work In Progress policy and cost and revenue	No
os_permitted_value	fin_param_text	varchar(255)	Yes	This Column stores the Permitted value Option Settings related to Work In Progress policy and cost and revenue	No
os_values	fin_param_code	varchar(6)	Yes	This Column shows the selected value code Option Settings	No
os_values_int	fin_int	int(4)	Yes	This Column shows the selected value in Option Settings	No
os_status	fin_status	varchar(25)	Yes	This Column shows the Status of Setting	No
os_created_by	fin_createdby	Varchar(40)	Yes	This Column stores the Created By in which the Option Settings related to Work In Progress policy and cost and revenue has been created	No
os_created_date	fin_datetime	datetime(8)	Yes	This Column stores the Created Date in which the Option Settings related to Work In Progress policy and cost and revenue has been created	No
os_modified_by	fin_modifiedby	Varchar(40)	Yes	This Column stores the Modified By in which the Option Settings related to Work In Progress policy and cost and revenue has been Modified	No
os_modified_date	fin_datetime	datetime(8)	Yes	This Column stores the Modified Date in which the Option Settings related to Work In Progress policy and cost and revenue has been Modified	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_OS_OPTION_SETTINGS
Comment :	Setting option

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
OS_OUINSTANCE	_decimal_10_0	decimal(10)	No	This Column stores the Ouinstance in which the Setting option has been created	No
OS_ACTGRP_MAST_PART_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the flag value for the Master part	No
OS_ACTGRP_ACTIVEPART_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the flag value for the Active part	No
OS_ACTGRP_USE_SUPP_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the flag value for the Supplier	No
OS_WH_FIN_BOOK_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Warehouse Finance book flag	No
OS_ACTGRP_MAST_CUST_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Account Group Mast customer flag	No
OS_ACTGRP_ACTIVECUST_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Account Group Active Customer flag	No
OS_FIN_POST_SKILL_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Finance Post skill flag	No
OS_FIN_POST_TOOL_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the finance post tool flag	No
OS_FIN_POST_EQP_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the finance post eqp flag	No
OS_FIN_POST_OTHERS_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the finance posting others flag	No
OS_FIN_POST_MISCEXP_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the finance posting misc exp flag	No
OS_Fin_Post_Add_Parts_Flag	_varchar_30	varchar(30)	Yes	This Column stores the finance posting Additional Parts	No
OS_INT_HANGAR_MAINT_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Int Hanger Maint Flag	No
OS_INT_COMP_MAINT_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Int Component Maintanence flag	No
OS_CREATED_BY	_varchar_30	varchar(30)	Yes	This Column stores the Created By in which the Setting option has been created	No
OS_CREATED_DATE	_datetime_8	datetime(8)	Yes	This Column stores the Created Date in which the Setting option has been created	No
OS_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This Column stores the Modified By in which the Setting option has been Modified	No
OS_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This Column stores the Modified Date which the Setting option has been Modified	No
OS_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This Column stores the Setting option Modification Sequence number	No
OS_ACTGRP_MAST_SUPP_FLAG	_varchar_30	varchar(30)	Yes	This Column stores the Account Group Mast Supplier flag	No
OS_RC_MainCore_Rtn_Flag	_varchar_5	varchar(5)	Yes	This Column stores the Report Consumption after Main Core return Values are Y - Yes or N - No	No
OS_AM_Aircraft_Flag	_varchar_5	varchar(5)	Yes	This Column stores the Enforce Object to Asset Mapping For Aircraft Flag	No
OS_AM_Component_Flag	_varchar_5	varchar(5)	Yes	This Column stores the Enforce Object to Asset Mapping For ComponentFlag	No
OS_AM_Facility_Flag	_varchar_5	varchar(5)	Yes	This Column stores the Enforce Object to Asset Mapping For Facility Flag	No
OS_AnalAcc_AircExp_Flag	designparamcode	varchar(5)	Yes	This Column stores the Aircraft Flag	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_PAG_PART_ACT_GRP
Comment :	Part Account Group

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PAG_CREATED_OUINSTANCE	_Int_0	int(4)	No	This Column stores the Ouinstance in which the Part Account Group has been created	No
PAG_PART_ACT_GRP_CODE	_varchar_20	varchar(20)	Yes	This Column stores the Part Account Group code in which the Part Account Group has been created	No
PAG_PART_ACT_GRP_DESC	_varchar_60	varchar(60)	No	This Column stores the Part Account Group Description in which the Part Account Group has been created	No
PAG_PART_ACT_GRP_STATUS	_varchar_15	varchar(15)	No	This Column stores the Part Acccount Group Status in which the Part Account Group has been created	No
PAG_CREATED_BY	_varchar_30	varchar(30)	No	This Column stores the Created By in which the Part Account Group has been created	No
PAG_CREATED_DATE	_datetime_8	datetime(8)	No	This Column stores the Created Date in which the Part Account Group has been created	No
PAG_MODIFIED_BY	_varchar_30	varchar(30)	No	This Column stores the Modified By in which the Part Account Group has been Modified	No
PAG_MODIFIED_DATE	_datetime_8	datetime(8)	No	This Column stores the Modified Date in which the Part Account Group has been Modified	No
PAG_TIMESTAMP	_decimal_10_0	decimal(10)	No	This Column stores the Part Account Group Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_PAM_PART_ACTGRP_MAP
Comment :	Part Account Group Map

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PAM_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This Column stores the Ouinstance in which the Part Account Group Map has been created	No
PAM_PART_ACT_GRP_CODE	_varchar_18	varchar(18)	No	This Column stores the Part Account Group Code in which the Part Account Group Map has been created	No
PAM_PARTNO	_varchar_40	varchar(40)	No	This Column stores the Part Number in which the Part Account Group Map has been created	No
PAM_PART_OU	_decimal_10_0	decimal(10)	Yes	This Column stores the Ouinstance in which the Part# has been created	No
PAM_CREATED_BY	_varchar_30	varchar(30)	No	This Column stores the Created By in which the Part Account Group Map has been created	No
PAM_CREATED_DATE	_datetime_8	datetime(8)	No	This Column stores the Created Date in which the Part Account Group Map has been created	No
PAM_MODIFIED_BY	_varchar_30	varchar(30)	No	This Column stores the Modified By in which the Part Account Group Map has been Modified	No
PAM_MODIFIED_DATE	_datetime_8	datetime(8)	No	This Column stores the Modified Date in which thePart Account Group Map has been Modified	No
PAM_TIMESTAMP	_decimal_10_0	decimal(10)	No	This Column stores the Part Account Group Map Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_PFB_ENTITY_FINANCE_BOOK
Comment :	Finance Book used for posting

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
pefb_orgunit	fin_ctxt_ouinstance	int(4)	No	This Column stores the Organisation Ouinstance in which the Finance Book used for posting has been created	Yes
pefb_transaction_event	fin_event	varchar(40)	No	This Column stores the transaction event in which the Finance Book used for posting has been created	Yes
pefb_created_ouinstance	fin_ctxt_ouinstance	int(4)	No	This Column stores the Ouinstance in which the Finance Book used for posting has been created	Yes
pefb_entity	fin_entity	varchar(40)	No	This Column stores the Entity in which the Finance Book used for posting has been created	Yes
pefb_applicable	fin_designparamcode	varchar(5)	Yes	This Column stores the applicable (Y/N)	No
pefb_priority	fin_count	int(4)	Yes	This Column stores the Priority value in which the Finance Book used for posting has been created	No
pefb_created_by	fin_ctxt_user	varchar(30)	Yes	This Column stores the Created By in which the Finance Book used for posting has been created	No
pefb_created_date	fin_datetime	datetime(8)	Yes	This Column stores the Created Date in which the Finance Book used for posting has been created	No
pefb_modified_by	fin_ctxt_user	varchar(30)	Yes	This Column stores the Modified By in which the Finance Book used for posting has been Modified	No
pefb_modified_date	fin_datetime	datetime(8)	Yes	This Column stores the Modified Date in which the Finance Book used for posting has been Modified	No
pefb_timestamp	fin_timestamp	int(4)	Yes	This Column stores the Finance Book used for posting Modification Sequence number	No

Table Name :	AGP_PFB_POSTING_FINANCE_BOOK
Comment :	Posting finance book Account Group

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PFB_ORGUNIT	_decimal_10_0	decimal(10)	No	This Column stores the Organisation Ouinstance in which the Posting finance book Account Group has been created	No
PFB_TRANSACTION_EVENT	_varchar_40	varchar(40)	No	This Column stores the Transaction Event	No
PFB_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	This Column stores the Ouinstance in which the Posting finance book Account Group has been created	No
PFB_POSTING_BOOK	_varchar_20	varchar(20)	Yes	This Column stores the Posting Book	No
PFB_CREATED_BY	_varchar_30	varchar(30)	Yes	This Column stores the Created by in which the Posting finance book Account Group has been created	No
PFB_CREATED_DATE	_datetime_8	datetime(8)	Yes	This Column stores the Created Date in which the Posting finance book Account Group has been created	No
PFB_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This Column stores the Modified by in which the Posting finance book Account Group has been Modified	No
PFB_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This Column stores the Modified Date in which the Posting finance book Account Group has been Modified	No
PFB_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This Column stores the Posting finance book Account Group Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_SAG_SUPP_ACT_GRP
Comment :	Supplier Account Group

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SAG_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This Column stores the Ouinstance in which the Supplier Account Group has been created	No
SAG_SUPP_ACT_GRP_CODE	_varchar_20	varchar(20)	Yes	This Column stores the Supplier Account Group Code	No
SAG_SUPP_ACT_GRP_DESC	_varchar_60	varchar(60)	No	This Column stores the Supplier Account Group Description	No
SAG_SUPP_ACT_GRP_STATUS	_varchar_15	varchar(15)	No	This Column stores the Supplier Account Group Status	No
SAG_CREATED_BY	_varchar_30	varchar(30)	No	This Column stores the Created by in which the Supplier Account Group has been created	No
SAG_CREATED_DATE	_datetime_8	datetime(8)	No	This Column stores the Create Date in which the Supplier Account Group has been created	No
SAG_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This Column stores the Modified By in which the Supplier Account Group has been modified	No
SAG_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This Column stores the Modified Date in which the Supplier Account Group has been modified	No
SAG_TIMESTAMP	_decimal_10_0	decimal(10)	No	This Column stores the Supplier Account Group Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	AGP_SAM_SUPP_ACTGRP_MAP
Comment :	Supplier Account Group Map

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SAM_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This Column stores the Ouinstance in which the Supplier Account Group Map has been created	No
SAM_SUPP_ACT_GRP_CODE	_varchar_20	varchar(20)	No	This Column stores the Supplier Account Group Code.	No
SAM_SUPPLIERCODE	_varchar_45	varchar(45)	No	This Column stores the Customer Code in which the Customer id has been created	No
SAM_SUPPLIER_OU	_decimal_10_0	decimal(10)	Yes	This Column stores the Supplier Ou Which Supplier id has been Created	No
SAM_CREATED_BY	_varchar_30	varchar(30)	No	This Column stores the Created By in which the Supplier Account Group Map has been created	No
SAM_CREATED_DATE	_datetime_8	datetime(8)	No	This Column stores the Created Date in which the Supplier Account Group Map has been created	No
SAM_MODIFIED_BY	_varchar_30	varchar(30)	No	This Column stores the Modified By in which the Supplier Account Group Map has been Modified	No
SAM_MODIFIED_DATE	_datetime_8	datetime(8)	No	This Column stores the Modified Date in which the Supplier Account Group Map has been modified	No
SAM_TIMESTAMP	_decimal_10_0	decimal(10)	No	This Column stores the Supplier Account Group Map Modification Sequence number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Key	Yes

Table Name :	ag_fintrn_finance_trans_det
Comment :	To stored internal posted transaction

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fintrn_component_name	fin_componentshortid	varchar(20)	No	Component name	No
fintrn_fb_id	fin_financebookid	varchar(20)	No	Finance book	No
fintrn_tran_ou	udd_ctxt_ouinstance	int(4)	No	Tansaction ouinstance	No
fintrn_document_no	fin_documentno	varchar(40)	No	Document number	No
fintrn_account_code	fin_accountcode	varchar(32)	No	Account Code	No
fintrn_company_code	fin_companycode	varchar(10)	No	Company code	No
fintrn_line_no	_char_18	char(18)	No	Line Number	No
fintrn_tran_type	fin_transactiontype	varchar(40)	Yes	Transaction Type	No
fintrn_tran_date	_datetime_8	datetime(8)	Yes	Transaction date	No
fintrn_drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit/credit flag	No
fintrn_currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
fintrn_tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
fintrn_base_amount	fin_amount	numeric(13)	Yes	Base amount	No
fintrn_par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
fintrn_exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
fintrn_par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
fintrn_analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
fintrn_subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis Code	No
fintrn_cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
fintrn_part_no	fin_itemcode	varchar(40)	Yes	Part number	No
fintrn_quantity	fin_quantity	numeric(17)	Yes	Quantity	No
fintrn_uom	fin_uom	varchar(15)	Yes	UOM	No
fintrn_reftran_no	fin_documentno	varchar(40)	Yes	Reference transaction number	No
fintrn_reftran_ou	udd_ctxt_ouinstance	int(4)	Yes	Reference transaction ouinstance	No
fintrn_ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
fintrn_createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
fintrn_created_date	_datetime_8	datetime(8)	Yes	Created date	No
FINTRN_GR_EXCHANGE_RATE	udd_amount	numeric(13)	Yes	Goods receipt Exchange rate	No
fintrn_Item_TCD_Flag	fin_flag	varchar(25)	Yes	Item TCD flag	No
fintrn_TagNo	fin_seqno	int(4)	Yes	Tag Number	No
fintrn_RowIdentity	fin_seqno	int(4)	Yes	Row Identity	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
fintrn_capitalized_amount	fin_amount	numeric(13)	Yes	Capitalized amount	No
fintrn_po_amend_amt	fin_amount	numeric(13)	Yes	Purchase order amend amount	No
fintrn_supplier_code	fin_vendorcode	varchar(45)	Yes	Supplier code	No
fintrn_proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal Number	No
fintrn_document_date	fin_date	datetime(8)	Yes	Ducument date	No
fintrn_inv_amt	fin_amount	numeric(13)	Yes	Invoice amount	No
fintrn_taskseqno	fin_taskseqno	int(4)	Yes	Task Sequence number	No
fintrn_refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
fintrn_refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
fintrn_custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
fintrn_ame_no	fin_documentno	varchar(40)	Yes	AME Number	No
fintrn_swo_no	fin_documentno	varchar(40)	Yes	Shop work order number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes
fintrn_customer_id	fin_customer_id	varchar(18)	Yes	Customer Id	No
fintrn_supplier_id	fin_vendorcode	varchar(45)	Yes	Supplier Id	No
fintrn_postingmet_id	fin_param_text	varchar(255)	Yes	Posting Id	No
fintrn_exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No
fintrn_reftran_lineno	fin_lineno	int(4)	Yes	Reference Tran line number	No
fintrn_revflag	fin_lineno	int(4)	Yes	Reversal Flag	No
fintrn_revinstance	fin_seqno	int(4)	Yes	Reversal Instance	No
fintrn_src_ou	fin_ctxt_ouinstance	int(4)	Yes	source ou	No

Table Name :	Cmn_Ccrd_process_his
Comment :	Cost Center retrieval history table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Crd_Guid	fin_guid	varchar(40)	Yes	guid	No
Crd_Process_LineNo	fin_seqno	int(4)	Yes	line numer	No
Crd_Ouinstance	fin_ctxt_ouinstance	int(4)	Yes	ou id	No
Crd_Companycode	fin_companycode	varchar(10)	Yes	company code	No
Crd_Tran_No	fin_documentno	varchar(40)	Yes	transaction no	No
Crd_TranType	fin_transactiontype	varchar(40)	Yes	transaction type	No
Crd_TranDate	fin_date	datetime(8)	Yes	transaction date	No
Crd_TranLineNo	fin_seqno	int(4)	Yes	transaction line no	No
Crd_RefTranOu	fin_ctxt_ouinstance	int(4)	Yes	reference transaction ouinstance	No
Crd_Reftranno	fin_documentno	varchar(40)	Yes	reference transaction number	No
Crd_ReftranType	fin_transactiontype	varchar(40)	Yes	reference transaction type	No
Crd_RefTranLineNo	fin_seqno	int(4)	Yes	reference transaction line number	No
Crd_Doctype	fin_transactiontype	varchar(40)	Yes	document type	No
Crd_Event	fin_event	varchar(40)	Yes	event	No
Crd_DRCRFlag	fin_flag	varchar(25)	Yes	debit credit flag	No
Crd_Expensetype	fin_contype	Varchar(25)	Yes	expense type	No
Crd_FinanceBook	fin_financebookid	varchar(20)	Yes	finance book	No
Crd_AccountType	fin_flag	varchar(25)	Yes	account type	No
Crd_CCType	fin_flag	varchar(25)	Yes	cost center type	No
Crd_AccountCode	fin_accountcode	varchar(32)	Yes	account code	No
Crd_aircraftmodel	fin_txt80	Varchar(80)	Yes	aircraft model	No
Crd_aircraftregno	fin_checknumber	Varchar(25)	Yes	aircraft registration number	No
Crd_planningbase	fin_ouinstdesc	Varchar(256)	Yes	planning base	No
Crd_maintainbase	fin_oucode	Varchar(32)	Yes	maintenance base	No
Crd_workcenter	fin_txt80	Varchar(80)	Yes	work center	No
Crd_repstation	fin_oucode	Varchar(32)	Yes	report station	No
Crd_partclass	fin_itemtype	Varchar(25)	Yes	part class	No
Crd_componentou	fin_ctxt_ouinstance	int(4)	Yes	component ou	No
Crd_componentid	fin_componentid	Varchar(90)	Yes	component id	No
Crd_comptype	fin_itemtype	Varchar(25)	Yes	comp type	No
Crd_compfamily	fin_checknumber	Varchar(25)	Yes	component family	No
crd_ordertype	fin_contype	Varchar(25)	Yes	order type	No
Crd_Orderclass	fin_designparamcode	varchar(5)	Yes	order class	No
Crd_ordercategory	fin_checknumber	Varchar(25)	Yes	order category	No
Crd_primaryworkcenter	fin_checknumber	Varchar(25)	Yes	primary work center	No
Crd_compownership	fin_status	varchar(25)	Yes	company ownership	No
Crd_aircraftown	fin_status	varchar(25)	Yes	aircraft town	No
Crd_fieldbase	fin_workcenter	varchar(80)	Yes	fieldbase	No
Crd_warehouse	fin_warehouse	varchar(10)	Yes	warehouse	No
Crd_numtype	fin_notypeno	Varchar(10)	Yes	numbering type	No
Crd_mrtype	fin_mrtype	Varchar(25)	Yes	mr type	No
Crd_partno	fin_partno	varchar(40)	Yes	part number	No
Crd_partaccgrp	fin_iag	Varchar(20)	Yes	part account group	No
Crd_partcategory	fin_partcategory2	Varchar(20)	Yes	part category	No
Crd_parttype	fin_flag	varchar(25)	Yes	part type	No
Crd_part_condition	fin_flag	varchar(25)	Yes	part condition	No
Crd_componenttype	fin_componentypeactual	Varchar(24)	Yes	component type	No
Crd_usage	fin_ccusage	Varchar(20)	Yes	usage	No
Crd_orderingloc	fin_location	Varchar(16)	Yes	ordering logic	No
Crd_receivingloc	fin_location	Varchar(16)	Yes	receiving logic	No
Crd_customer_group	fin_customeraccountgroup	Varchar(20)	Yes	customer group	No
Crd_packslip_category	fin_quickcodes	varchar(25)	Yes	packslip category	No
Crd_order_loc	fin_location	Varchar(16)	Yes	order location	No
Crd_execnfacility	fin_flag2	Varchar(25)	Yes	execution facility	No
Crd_execnloc	fin_oucode	Varchar(32)	Yes	execution location	No
Crd_Ship_loc	fin_location	Varchar(16)	Yes	shipping location	No
Crd_Issue_loc	fin_location	Varchar(16)	Yes	issue location	No
Crd_return_loc	fin_location	Varchar(16)	Yes	return location	No
Crd_stock_status	fin_partstatus	varchar(40)	Yes	stock location	No
Crd_rental_category	fin_quickcodes	varchar(25)	Yes	rental cetegory	No
Crd_costcenter	fin_costcentercode	varchar(10)	Yes	cost center	No
replication_key	fin_bigint	Int(8)	No	replication key	Yes
created_area_code	fin_bigint	Int(8)	Yes	created area code	No
Crd_BaseCC	fin_documentno	varchar(40)	Yes	base cost center	No

Table Name :	cmn_custexch_acctpost_metadata
Comment :	Metadata table for exchange related cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_doc_type	fin_flag	varchar(25)	Yes	Document type	No
apm_cost_booking_tp	fin_designparamcode	varchar(5)	Yes	Cost booking event	No
apm_parexchtask_closed	fin_designparamcode	varchar(5)	Yes	Parent Exchange Task Status	No
apm_parexchroot_closed	fin_designparamcode	varchar(5)	Yes	Parent Exchange root status	No
apm_dr_fbtype	fin_flag	varchar(25)	Yes	Debit finance book type	No
apm_dr_acctype	fin_flag	varchar(25)	Yes	Debit Account type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Debit cost center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Debit Analysis type	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit subanalyis type	No
apm_cr_fbtype	fin_flag	varchar(25)	Yes	Credit finance book type	No
apm_cr_acctype	fin_flag	varchar(25)	Yes	Credit Account type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Credit Cost center type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Credit analysis type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit subanalysis type	No
apm_line_no	fin_seqno	int(4)	Yes	Line no	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting id	No
replication_key	_bigint_8	Bigint(8)	No	Replication id	Yes
apm_Ref_DocType	fin_flag	varchar(25)	Yes	Reference document type	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	Entity accounted	No

Table Name :	cmn_exofc_finpost_input_his
Comment :	History table for exchange related input

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
exofc_guid	fin_guid	varchar(40)	Yes	GUID	No
exofc_tran_ou	fin_ctxt_ouinstance	int(4)	Yes	Transaction ouinstance	No
exofc_doctype	fin_transactiontype	varchar(40)	Yes	Document type	No
exofc_tran_no	fin_documentno	varchar(40)	Yes	Transaction number	No
exofc_tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
exofc_tran_date	fin_date	datetime(8)	Yes	Transaction date	No
exofc_tran_lineno	fin_seqno	int(4)	Yes	Transaction line number	No
exofc_drcurrency	fin_currencycode	varchar(5)	Yes	Debit currency	No
exofc_crcurrency	fin_currencycode	varchar(5)	Yes	Credit currency	No
exofc_trancost	fin_amount	numeric(13)	Yes	Transaction cost	No
exofc_exchrate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
exofc_refdoctype	fin_transactiontype	varchar(40)	Yes	Reference document type	No
exofc_refdocou	fin_ctxt_ouinstance	int(4)	Yes	Reference document Ouinstance	No
exofc_refdocno	fin_documentno	varchar(40)	Yes	Reference document number	No
exofc_refdoclineno	fin_seqno	int(4)	Yes	Reference document line number	No
exofc_refdocdate	fin_date	datetime(8)	Yes	reference document date	No
exofc_custorderref	fin_designparamcode	varchar(5)	Yes	Ownership	No
exofc_dr_fbtype	fin_flag	varchar(25)	Yes	Debit Finance book type	No
exofc_cr_fbtype	fin_flag	varchar(25)	Yes	Credit Finance book type	No
exofc_dr_account_type	fin_flag	varchar(25)	Yes	Debit account type	No
exofc_cr_account_type	fin_flag	varchar(25)	Yes	credit account type	No
exofc_dr_analtype	fin_flag	varchar(25)	Yes	Debit analysis type	No
exofc_cr_analtype	fin_flag	varchar(25)	Yes	credit analysis type	No
exofc_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit subanalysis type	No
exofc_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit subanalysis type	No
exofc_dr_cctype	fin_flag	varchar(25)	Yes	Debit Cost center type	No
exofc_cr_cctype	fin_flag	varchar(25)	Yes	Credit Cost center type	No
exofc_dr_warehouse	fin_warehouse	varchar(10)	Yes	Debit warehouse	No
exofc_cr_warehouse	fin_warehouse	varchar(10)	Yes	Credit warehouse	No
exofc_dr_accountusage	fin_usageid	varchar(20)	Yes	Debit Account usage	No
exofc_cr_accountusage	fin_usageid	varchar(20)	Yes	Credit Account usage	No
exofc_dr_account	fin_accountcode	varchar(32)	Yes	Debit account code	No
exofc_cr_account	fin_accountcode	varchar(32)	Yes	Credit account code	No
exofc_dr_fb	fin_financebookid	varchar(20)	Yes	Debit Finance book	No
exofc_cr_fb	fin_financebookid	varchar(20)	Yes	Credit Finance book	No
exofc_dr_cc	fin_costcentercode	varchar(10)	Yes	Debit Cost center code	No
exofc_cr_cc	fin_costcentercode	varchar(10)	Yes	Credit cost center code	No
exofc_dr_analysis	fin_analysiscode	varchar(5)	Yes	Debit analysis code	No
exofc_cr_analysis	fin_analysiscode	varchar(5)	Yes	Credit analysis code	No
exofc_dr_subanalysis	fin_subanalysiscode	varchar(5)	Yes	Debit Subanalysis code	No
exofc_cr_subanalysis	fin_subanalysiscode	varchar(5)	Yes	Credit Subanalysis code	No
exofc_postingid	fin_param_text	varchar(255)	Yes	Posting Id	No
exofc_tagno	fin_seqno	int(4)	Yes	Tag number	No
exofc_item_tcd_flag	fin_flag	varchar(25)	Yes	Item tcd flag	No
exofc_entacc	fin_flag	varchar(25)	Yes	Entity accounted	No
exofc_process_lineno	fin_seqno	int(4)	Yes	Process line number	No
exofc_itemou	fin_ctxt_ouinstance	int(4)	Yes	Item ouinstance	No
exofc_itemcode	fin_partno	varchar(40)	Yes	Item Code	No
exofc_interfb_line	fin_seqno	int(4)	Yes	Inter finnace book Line	No
exofc_interfb_appl	fin_flag	varchar(25)	Yes	Inter finnace book applicable	No
exofc_aircraftregno	fin_aircraftnumber	varchar(30)	Yes	Aircraft register number	No
exofc_taskclosed	fin_designparamcode	varchar(5)	Yes	Task status	No
exofc_woclosed	fin_designparamcode	varchar(5)	Yes	Work order status	No
exofc_saltype	fin_quickcodes	varchar(25)	Yes	Sale type	No
exofc_refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
exofc_refdoc_no	fin_documentno	varchar(40)	Yes	Reference document no	No
exofc_custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
exofc_ame_no	fin_documentno	varchar(40)	Yes	AME number	No
exofc_swo_no	fin_documentno	varchar(40)	Yes	Shop work order number	No
exofc_exord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No
exofc_supplier_id	fin_vendorcode	varchar(45)	Yes	Supplier ID	No
exofc_customer_id	fin_customer_id	varchar(18)	Yes	Customer Id	No
replication_key	_bigint_8	Bigint(8)	No	Replication key	Yes

Table Name :	Cmn_FLog_AcctPost_MetaData
Comment :	AME related cost booking metadata

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_doc_type	fin_event	varchar(40)	Yes	Document type	No
apm_partissue_basis	fin_designparamcode	varchar(5)	Yes	Part issue basis	No
apm_maint_policy	fin_designparamcode	varchar(5)	Yes	Maintainence policy	No
apm_expense_type	fin_designparamcode	varchar(5)	Yes	Expense type	No
apm_ownership	fin_designparamcode	varchar(5)	Yes	ownership	No
apm_task_closed	fin_designparamcode	varchar(5)	Yes	Task status	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	Entity accounted	No
apm_dr_fbtype	fin_flag	varchar(25)	Yes	Debit finance book type	No
apm_dr_acctype	fin_flag	varchar(25)	Yes	Debit account type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Debit cost center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Debit analysis type	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit subanalysis type	No
apm_cr_fbtype	fin_flag	varchar(25)	Yes	Credit finance book type	No
apm_cr_acctype	fin_flag	varchar(25)	Yes	Credit account type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Credit Cost center type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Credit analysis type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit subanalysis type	No
apm_line_no	fin_seqno	int(4)	Yes	Line number	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting Id	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes
apm_cost_booking	fin_param_code	varchar(6)	Yes	Cost booking	No

Table Name :	cmn_gi_acctpost_metadata
Comment :	Metada for goods inward related cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_event_id	fin_event	varchar(40)	Yes	Event ID	No
apm_doc_trn_type	fin_designparamcode	varchar(5)	Yes	Document tran type	No
apm_doc_type	fin_flag	varchar(25)	Yes	Document type	No
apm_matching_type	fin_designparamcode	varchar(5)	Yes	Matching type	No
apm_recptrecordopt	fin_designparamcode	varchar(5)	Yes	Receip record option	No
apm_exp_type	fin_designparamcode	varchar(5)	Yes	Expense type	No
apm_part_exppolicy	fin_designparamcode	varchar(5)	Yes	Part expense policy	No
apm_warrentyapp	fin_designparamcode	varchar(5)	Yes	Warrenty applicable	No
apm_refdoctype	fin_designparamcode	varchar(5)	Yes	Refernce document type	No
apm_refdocexppolicy	fin_designparamcode	varchar(5)	Yes	Reference document expense policy	No
apm_refdocexptype	fin_designparamcode	varchar(5)	Yes	Reference document expense type	No
apm_belowthreshold	fin_designparamcode	varchar(5)	Yes	Below threshold	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	Entity Accounted	No
apm_dr_accounttype	fin_usageid	varchar(20)	Yes	Debit Account type	No
apm_cr_accounttype	fin_usageid	varchar(20)	Yes	Credit Account type	No
apm_dr_fbtype	fin_financebookid	varchar(20)	Yes	Debit finance book type	No
apm_cr_fbtype	fin_financebookid	varchar(20)	Yes	Credit finance book type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Debit Cost center type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Credit Cost Center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Debit Analysis type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Credit Analysis Type	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit Sub Analysis Type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit Sub Analysis type	No
apm_line_no	fin_seqno	int(4)	Yes	Line Number	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting Id	No
apm_prtexp_type	fin_designparamcode	varchar(5)	Yes	Part expense type	No
apm_ownership	fin_designparamcode	varchar(5)	Yes	Ownership	No
apm_setoption	fin_designparamcode	varchar(5)	Yes	Set Option	No
apm_wo_status	fin_status	varchar(25)	Yes	Work order closed status	No
apm_tsk_status	fin_status	varchar(25)	Yes	Task closed status	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes
apm_exch_flag	fin_designparamcode	varchar(5)	Yes	Exchange flag	No
apm_exch_type	fin_designparamcode	varchar(5)	Yes	Exchange type	No
apm_refcost_flag	fin_flag	varchar(25)	Yes	Reference Cost flag	No

Table Name :	Cmn_GR_FinPost_Input_his
Comment :	History for Goods receipt transaction Input temp

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GRF_Guid	fin_guid	varchar(40)	No	GUID	No
GRF_TagNo	fin_seqno	int(4)	Yes	Tag number	No
GRF_GR_OUInstance	fin_ctxt_ouinstance	int(4)	No	OU instance	No
GRF_GR_NO	fin_documentno	varchar(40)	No	Goods receipt number	No
GRF_GR_LineId	fin_rowcount	numeric(9)	Yes	Goods receipt Line Id	No
GRF_GR_RefDocType	fin_designparamcode	varchar(5)	Yes	Goods receipt reference document type	No
GRF_GR_RefDocOu	fin_ctxt_ouinstance	int(4)	Yes	Goods receipt reference document ouinstance	No
GRF_GR_RefDocNo	fin_documentno	varchar(40)	Yes	Goods receipt Reference document Number	No
GRF_GR_RefDocDate	fin_datetime	datetime(8)	Yes	Goods receipt Reference document date	No
GRF_GRD_Gr_Line_No	fin_rowcount	numeric(9)	Yes	Goods receipt Line number	No
GRF_GRD_Part_Line_Id	fin_rowcount	numeric(9)	Yes	Goods receipt Part line id	No
GRF_GRD_Po_Rs_Line_No	fin_rowcount	numeric(9)	Yes	Goods receipt Purchase order line order	No
GRF_GRD_GR_Part_OU	fin_ctxt_ouinstance	int(4)	Yes	Goods receipt Part ou instance	No
GRF_GRD_PartNo	fin_partno	varchar(40)	Yes	Goods receipt Part number	No
GRF_GRD_PartUOM	fin_uom	varchar(15)	Yes	Goods receipt Part UOM	No
GRF_GRD_MovedValue	fin_amount	numeric(13)	Yes	Goods receipt Moved Value	No
GRF_GRD_BasicValue	fin_amount	numeric(13)	Yes	Goods receipt Basic value	No
GRF_GRD_ReceivedQty	fin_quantitry	numeric(13)	Yes	Goods receipt Received Quantity	No
GRF_GRD_RejectedQty	fin_quantitry	numeric(13)	Yes	Goods receipt Rejected Quantity	No
GRF_GRD_AcceptedQty	fin_quantitry	numeric(13)	Yes	Goods receipt Accepted Quantity	No
GRF_GRD_Line_status	fin_designparamcode	varchar(5)	Yes	Goods receipt Line Status	No
GRF_GRD_MovedQty	fin_quantitry	numeric(13)	Yes	Goods receipt Moved Quantity	No
GRF_GRD_TotReceivedQty	fin_quantitry	numeric(13)	Yes	Goods receipt Total Received Quantity	No
GRF_GRD_ClaimAmount	fin_amount	numeric(13)	Yes	Goods receipt Claim Amount	No
GRF_GRD_WareHouse_No	fin_warehouse	varchar(10)	Yes	Goods receipt Warehouse number	No
GRF_PO_Date	fin_datetime	datetime(8)	Yes	Purchase order Date	No
GRF_PO_Type	fin_designparamcode	varchar(5)	Yes	Purchase order type	No
GRF_PO_Currency	fin_currencytypeen	varchar(20)	Yes	Purchase order currency	No
GRF_PO_AC_Regn_No	fin_aircraftnumber	varchar(30)	Yes	Purchase order Aircraft Register number	No
GRF_PO_Exp_Type	fin_designparamcode	varchar(5)	Yes	Purchase order Expense type	No
GRF_PO_Issue_Doc_No	fin_documentno	varchar(40)	Yes	Purchase order Issue Document number	No
GRF_PO_Issue_Doc_OU	fin_ctxt_ouinstance	int(4)	Yes	Purchase order Issue Document ouinstance	No
GRF_PO_Core_Status	fin_designparamcode	varchar(5)	Yes	Purchase order Core status	No
GRF_PO_PUR_Unit	fin_financebookid	varchar(20)	Yes	Purchase order purchase unit	No
GRF_PO_WarrClaim_App	fin_designparamcode	varchar(5)	Yes	Purchase order Warrenty Claim Applicable	No
GRF_PO_WarrClaim_No	fin_documentno	varchar(40)	Yes	Purchase order Warrenty Claim Number	No
GRF_POD_Matching_Type	fin_designparamcode	varchar(5)	Yes	Purchase order Matching Type	No
GRF_POD_Capex_Prop_No	fin_documentno	varchar(40)	Yes	Purchase order Capital Proposal number	No
GRF_POD_Acc_Usg	fin_accountcode	varchar(32)	Yes	Purchase order Account usage	No
GRF_POD_Cstg_Usg	fin_accountcode	varchar(32)	Yes	Purchase order Costing Usage	No
GRF_POD_Anal_Code	fin_analysiscode	varchar(5)	Yes	Purchase order Analysis code	No
GRF_POD_SubAnal_Code	fin_subanalysiscode	varchar(5)	Yes	Purchase order sub analysis code	No
GRF_POD_RCP_RCD_Opt	fin_designparamcode	varchar(5)	Yes	Purchase order receipt record option	No
GRF_POD_Cap_Thrshold_Amt	fin_amount	numeric(13)	Yes	Purchase order capital Threshold Amount	No
GRF_POD_Ref_Doc_OU	fin_ctxt_ouinstance	int(4)	Yes	Purchase order Reference document ouinstance	No
GRF_POD_Ref_Doc_No	fin_documentno	varchar(40)	Yes	Purchase order Reference document number	No
GRF_POD_Ref_Doc_Type	fin_designparamcode	varchar(5)	Yes	Purchase order Reference document type	No
GRF_POD_Proposal_FB	fin_financebookid	varchar(20)	Yes	Purchase order Proposal Finance book	No
GRF_POD_RefDocExpPolicy	fin_designparamcode	varchar(5)	Yes	Purchase order Reference document expense policy	No
GRF_POD_RefDocExpType	fin_designparamcode	varchar(5)	Yes	Purchase order Reference document expense type	No
GRF_POTC_Fwd_Cvr_Rate	fin_amount	numeric(13)	Yes	Fixed/Agreed Exchange Rate for future date	No
GRF_POTC_Fwd_Cvr_Appl	fin_txt150	varchar(150)	Yes	Fixed/Agreed Exchange Rate for future Applicable	No
GRF_Part_ExpPolicy	fin_designparamcode	varchar(5)	Yes	Part expense policy	No
GRF_Item_TCD_Flag	fin_flag	varchar(25)	Yes	Item TCD flag	No
GRF_TCD_OU	fin_ctxt_ouinstance	int(4)	Yes	TCD ouinstance	No
GRF_TCD_Acct_Rule	fin_designparamcode	varchar(5)	Yes	TCD Account rule	No
GRF_TCD_CODE	fin_tcdcodes	varchar(25)	Yes	TCD code	No
GRF_TCD_VAR	fin_tcdchgstslevel	varchar(25)	Yes	TCD varience	No
GRF_DR_AccountType	fin_usageid	varchar(20)	Yes	Debit account type	No
GRF_DR_AccountUsage	fin_usageid	varchar(20)	Yes	Debit account usage	No
GRF_DR_CostingUsage	fin_usageid	varchar(20)	Yes	Debit Costing usage	No
GRF_DR_FB	fin_financebookid	varchar(20)	Yes	Debit Finance book	No
GRF_DR_Account	fin_accountcode	varchar(32)	Yes	Debit Account code	No
GRF_DR_CC	fin_costcentercode	varchar(10)	Yes	Debit Cost center	No
GRF_DR_Analysis	fin_analysiscode	varchar(5)	Yes	Debit Analysis code	No
GRF_DR_SubAnalysis	fin_subanalysiscode	varchar(5)	Yes	Debit sub analysis code	No
GRF_CR_AccountType	fin_usageid	varchar(20)	Yes	Crdeit account type	No
GRF_CR_AccountUsage	fin_usageid	varchar(20)	Yes	Credit account usage	No
GRF_CR_CostingUsage	fin_usageid	varchar(20)	Yes	Credit Costing usage	No
GRF_CR_FB	fin_financebookid	varchar(20)	Yes	Credit Finance book	No
GRF_CR_Account	fin_accountcode	varchar(32)	Yes	Credit Account code	No
GRF_CR_CC	fin_costcentercode	varchar(10)	Yes	Credit Cost center	No
GRF_CR_Analysis	fin_analysiscode	varchar(5)	Yes	Credit Analysis code	No
GRF_CR_SubAnalysis	fin_subanalysiscode	varchar(5)	Yes	Credit sub analysis code	No
GRF_Base_Exch_Rate	fin_amount	numeric(13)	Yes	Base exchage rate	No
GRF_Tran_Amount	fin_amount	numeric(13)	Yes	Tran amount	No
GRF_Base_Amount	fin_amount	numeric(13)	Yes	Base amount	No
GRF_POD_BelowThreshold	fin_designparamcode	varchar(5)	Yes	Purchase order Below Threshold	No
GRF_Entity_Accounted	fin_flag	varchar(25)	Yes	Entity Accounted	No
GRF_ItemCode	fin_itemcode	varchar(40)	Yes	Item code	No
GRF_ItemVariant	fin_itemvariantdes	varchar(70)	Yes	Item Variant	No
GRF_AccCurrency	fin_flag	varchar(25)	Yes	Account currency	No
GRF_InterFB_Line	fin_seqno	int(4)	Yes	Inter Finance book Line	No
GRF_InterFB_Appl	fin_flag	varchar(25)	Yes	Inter finance book applicable	No
GRF_DR_CCType	fin_flag	varchar(25)	Yes	Debit Cost center type	No
GRF_CR_CCType	fin_flag	varchar(25)	Yes	Credit Cost center type	No
GRF_DR_AnalType	fin_flag	varchar(25)	Yes	Debit Analysis type	No
GRF_CR_AnalType	fin_flag	varchar(25)	Yes	Credit Analysis type	No
GRF_DR_SubAnalType	fin_flag	varchar(25)	Yes	Debit Sub analysis Type	No
GRF_CR_SubAnalType	fin_flag	varchar(25)	Yes	Credit Sub analysis Type	No
GRF_DR_FBType	fin_flag	varchar(25)	Yes	Debit finance Type	No
GRF_CR_FBType	fin_flag	varchar(25)	Yes	Credit finance type	No
GRF_Posting_Id	fin_param_text	varchar(255)	Yes	Posting Id	No
GRF_DR_Currency	fin_currencytypeen	varchar(20)	Yes	Debit Currency	No
GRF_CR_Currency	fin_currencytypeen	varchar(20)	Yes	Credit Currency	No
GRF_DR_Amount	fin_amount	numeric(13)	Yes	Debit Amount	No
GRF_CR_Amount	fin_amount	numeric(13)	Yes	Credit Amount	No
GRF_DR_Exch_Rate	fin_amount	numeric(13)	Yes	Debit Exchange Rate	No
GRF_CR_Exch_Rate	fin_amount	numeric(13)	Yes	Credit Exchange Rate	No
GRF_document_date	fin_date	datetime(8)	Yes	Document rate	No
GRF_supplier_code	fin_vendorcode	varchar(45)	Yes	Supplier Code	No
grf_gr_refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
grf_gr_refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
grf_gr_custorder_no	fin_documentno	varchar(40)	Yes	Customer Order Number	No
grf_gr_ame_no	fin_documentno	varchar(40)	Yes	Ame Number	No
grf_gr_swo_no	fin_documentno	varchar(40)	Yes	Shop work order number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes
grf_exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No
grf_gr_reftask_trackid	fin_unique_id	Int(8)	Yes	reference task track id	No
grf_block_id	fin_station	Char(40)	Yes	block id	No

Table Name :	Cmn_Inv_AcctPost_MetaData
Comment :	Metadata for Inventory cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_doc_type	fin_flag	varchar(25)	Yes	Document type	No
apm_partexp_policy	fin_flag	varchar(25)	Yes	Part Expense policy	No
apm_partissue_basis	fin_flag	varchar(25)	Yes	Part issue basis	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	Entity accounted	No
apm_dr_acctype	fin_flag	varchar(25)	Yes	Debit account type	No
apm_dr_fbtype	fin_flag	varchar(25)	Yes	Debit Finance book type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Debit Cost center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Debit analysis type	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit subanalysis type	No
apm_cr_acctype	fin_flag	varchar(25)	Yes	Credit Account type	No
apm_cr_fbtype	fin_flag	varchar(25)	Yes	Credit Finance book type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Credit cost center type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Credit analysis type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit suanalysis type	No
apm_refdoc_type	fin_flag	varchar(25)	Yes	Reference document type	No
apm_belowthreshold	fin_flag	varchar(25)	Yes	Below threshold	No
apm_expensetype	fin_flag	varchar(25)	Yes	Expense type	No
apm_fromstkstatus	fin_partstatus	varchar(40)	Yes	From Stock status	No
apm_tostkstatus	fin_partstatus	varchar(40)	Yes	To stock status	No
apm_line_no	fin_seqno	int(4)	Yes	Line number	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting id	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes
apm_exch_flag	fin_designparamcode	varchar(5)	Yes	Exchange flag	No
apm_ag_opt	fin_option	varchar(20)	Yes	Account group set option	No
apm_refexpensetype	fin_flag	varchar(25)	Yes	Ref expense type	No

Table Name :	cmn_inv_finpost_input_his
Comment :	History of Inventory accounting inputs

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Inv_guid	fin_guid	varchar(40)	Yes	Guid	No
Inv_Ouinstance	fin_ctxt_ouinstance	int(4)	Yes	OUInstance	No
Inv_Tran_No	fin_documentno	varchar(40)	Yes	Transaction number	No
Inv_Trantype	fin_transactiontype	varchar(40)	Yes	Transaction type	No
Inv_Trandate	fin_date	datetime(8)	Yes	Transaction date	No
Inv_Doctype	fin_transactiontype	varchar(40)	Yes	Document type	No
Inv_Refdoctype	fin_transactiontype	varchar(40)	Yes	Reference document type	No
Inv_Refdocou	fin_ctxt_ouinstance	int(4)	Yes	Reference document Ouinstance	No
Inv_Refdocno	fin_documentno	varchar(40)	Yes	Reference document number	No
Inv_Refdoclineno	fin_seqno	int(4)	Yes	Reference document line number	No
Inv_Refdocdate	fin_date	datetime(8)	Yes	Reference document date	No
Inv_Issue_lineno	fin_seqno	int(4)	Yes	Issue line number	No
Inv_PartNo	fin_partno	varchar(40)	Yes	Part number	No
Inv_PartAccGrp	fin_accountgroup	varchar(15)	Yes	Part account group	No
Inv_PartCat	fin_flag	varchar(25)	Yes	Part Category	No
Inv_PartType	fin_parttype	varchar(25)	Yes	Part type	No
Inv_IssueCat	fin_flag	varchar(25)	Yes	Issue category	No
Inv_Issuebasis	fin_flag	varchar(25)	Yes	Issue basis	No
inv_partou	fin_ctxt_ouinstance	int(4)	Yes	Part ouinstance	No
inv_comp_type	fin_flag	varchar(25)	Yes	Component type	No
Inv_AC_Regno	fin_desc40	varchar(40)	Yes	Aircraft register number	No
Inv_DR_Warehouse	fin_warehouse	varchar(10)	Yes	Debit warehouse	No
Inv_CR_Warehouse	fin_warehouse	varchar(10)	Yes	Credit warehouse	No
Inv_Qty	fin_quantity	numeric(17)	Yes	Quantity	No
Inv_Rcptqty	fin_quantity	numeric(17)	Yes	Receipt Quantity	No
Inv_UOM	fin_uom	varchar(15)	Yes	UOM	No
Inv_CCusage	fin_usageid	varchar(20)	Yes	Costing Usage	No
Inv_Accusage	fin_usageid	varchar(20)	Yes	Accounting Usage	No
Inv_TranCost	fin_amount	numeric(13)	Yes	Transaction cost	No
Inv_Receiptcost	fin_amount	numeric(13)	Yes	Receipt cost	No
Inv_currency	fin_currencycode	varchar(5)	Yes	Currency	No
Inv_DR_AccountType	fin_flag	varchar(25)	Yes	Debit Account type	No
Inv_CR_AccountType	fin_flag	varchar(25)	Yes	Credit Account type	No
Inv_DR_Accode	fin_accountcode	varchar(32)	Yes	Debit Account code	No
Inv_CR_Accode	fin_accountcode	varchar(32)	Yes	Credit Account code	No
Inv_DR_FBtype	fin_flag	varchar(25)	Yes	Debit Finance book type	No
Inv_CR_FBtype	fin_flag	varchar(25)	Yes	Credit finance book type	No
Inv_DR_FB	fin_financebookid	varchar(20)	Yes	Debit Finance book	No
Inv_CR_FB	fin_financebookid	varchar(20)	Yes	Credit finance book	No
Inv_DR_CCtype	fin_flag	varchar(25)	Yes	Debit Cost center type	No
Inv_CR_CCtype	fin_flag	varchar(25)	Yes	Credit Cost center type	No
Inv_DR_CC	fin_costcentercode	varchar(10)	Yes	Debit cost center	No
Inv_CR_CC	fin_costcentercode	varchar(10)	Yes	Credit Cost center	No
Inv_DR_analtype	fin_flag	varchar(25)	Yes	Debit analysis type	No
Inv_CR_analtype	fin_flag	varchar(25)	Yes	Credit analysis type	No
Inv_DR_analcode	fin_analysiscode	varchar(5)	Yes	Debit analysis code	No
Inv_CR_analcode	fin_analysiscode	varchar(5)	Yes	Credit analysis code	No
Inv_DR_subanaltype	fin_flag	varchar(25)	Yes	Debit subanalysis type	No
Inv_CR_subanaltype	fin_flag	varchar(25)	Yes	Credit Subanalysis type	No
Inv_DR_subanalcode	fin_subanalysiscode	varchar(5)	Yes	Debit Subanalysis code	No
Inv_CR_subanalcode	fin_subanalysiscode	varchar(5)	Yes	Credit Subanalysis code	No
Inv_Entity_Accounted	fin_flag	varchar(25)	Yes	Entity accounted	No
Inv_TagNo	fin_seqno	int(4)	Yes	Tag Number	No
Inv_Interfb_appl	fin_flag	varchar(25)	Yes	Inter finance book applicable	No
Inv_Partexp_policy	fin_flag	varchar(25)	Yes	part expense policy	No
Inv_Part_CrtOU	fin_ctxt_ouinstance	int(4)	Yes	Part created Ouinstance	No
Inv_Process_LineNo	fin_rowcount	numeric(9)	Yes	Process Line number	No
Inv_interfb_line	fin_seqno	int(4)	Yes	Inter finance book line	No
Inv_DocCategory	fin_visitcategory	varchar(25)	Yes	Document category	No
Inv_drupdflag	fin_flag	varchar(25)	Yes	Debit updation flag	No
Inv_crupdflag	fin_flag	varchar(25)	Yes	Credit updation flag	No
Inv_TCD_OU	fin_ctxt_ouinstance	int(4)	Yes	TCD ouinstance	No
Inv_TCD_Code	fin_tcdcodes	varchar(25)	Yes	TCD Code	No
Inv_TCD_Var	fin_tcdchgstslevel	varchar(25)	Yes	TCD variant	No
Inv_expense_type	fin_flag	varchar(25)	Yes	Expense type	No
Inv_event	fin_event	varchar(40)	Yes	Event	No
Inv_Exch_rate	fin_exchangerate	numeric(9)	Yes	Exchage rate	No
Inv_Acccur_type	fin_flag	varchar(25)	Yes	Account currency type	No
Inv_From_StkStatus	fin_partstatus	varchar(40)	Yes	From stock status	No
Inv_To_StkStatus	fin_partstatus	varchar(40)	Yes	To Stock status	No
Inv_Posting_Id	fin_param_text	varchar(255)	Yes	Posting Id	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes
inv_refdoctype_code	fin_trantype	varchar(40)	Yes	Reference document type code	No
inv_refdoc_no	fin_documentno	varchar(40)	Yes	Reference document type number	No
inv_custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
inv_ame_no	fin_documentno	varchar(40)	Yes	AME number	No
inv_swo_no	fin_documentno	varchar(40)	Yes	Shop work order number	No
inv_customer_id	fin_customer_id	varchar(18)	Yes	Customer ID	No
inv_supplier_id	fin_vendorcode	varchar(45)	Yes	Supplier Id	No
inv_reftran_type	fin_trantype	varchar(40)	Yes	Reference Transaction Type	No
inv_exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No
Inv_ref_exp_type	fin_flag	varchar(25)	Yes	referemce expense type	No
inv_capthresh_flag	fin_flag	varchar(25)	Yes	capital threshhold flag	No
inv_capex_proposalno	fin_documentno	varchar(40)	Yes	capital expenditure proposal number	No

Table Name :	cmn_mnt_finpost_input_his
Comment :	History for finance posting input details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Mnt_Guid	fin_guid	varchar(40)	Yes	GUID	No
Mnt_Ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
Mnt_Tran_No	fin_documentno	varchar(40)	Yes	Transaction Number	No
Mnt_TranType	fin_transactiontype	varchar(40)	Yes	Transaction type	No
Mnt_TranDate	fin_date	datetime(8)	Yes	Transaction date	No
Mnt_TranLineNo	fin_seqno	int(4)	Yes	Transaction line number	No
Mnt_TaskClosed	fin_designparamcode	varchar(5)	Yes	Task closed status	No
Mnt_WOClosed	fin_designparamcode	varchar(5)	Yes	work order closed status	No
Mnt_Doctype	fin_transactiontype	varchar(40)	Yes	Document type	No
Mnt_Event	fin_event	varchar(40)	Yes	Event	No
Mnt_ExpenseType	fin_designparamcode	varchar(5)	Yes	Expense type	No
Mnt_CustOrderRef	fin_designparamcode	varchar(5)	Yes	Ownership	No
Mnt_MatType	fin_designparamcode	varchar(5)	Yes	Material type	No
Mnt_JobType	fin_designparamcode	varchar(5)	Yes	Job type	No
Mnt_RepExpPolicy	fin_designparamcode	varchar(5)	Yes	Repair expense policy	No
Mnt_ber_flag	fin_designparamcode	varchar(5)	Yes	Ber flag	No
Mnt_PrimaryWC	fin_workcenter	varchar(80)	Yes	Primary work center	No
Mnt_Refdocou	fin_ctxt_ouinstance	int(4)	Yes	Reference Document ou instance	No
Mnt_Refdoctype	fin_transactiontype	varchar(40)	Yes	Reference Document Type	No
Mnt_Refdocno	fin_documentno	varchar(40)	Yes	Reference Document Number	No
Mnt_Refdocdate	fin_date	datetime(8)	Yes	Reference Document Date	No
Mnt_Refdoclineno	fin_seqno	int(4)	Yes	Reference document Line No	No
Mnt_AircraftOu	fin_ctxt_ouinstance	int(4)	Yes	Aircraft OuInstance	No
Mnt_AircraftRegNo	fin_aircraftnumber	varchar(30)	Yes	Aircraft Register number	No
Mnt_Part_CrtOU	fin_ctxt_ouinstance	int(4)	Yes	Part OUInstance	No
Mnt_PartNo	fin_partno	varchar(40)	Yes	Part Number	No
Mnt_Qty	fin_quantity	numeric(17)	Yes	Quantity	No
Mnt_UOM	fin_uom	varchar(15)	Yes	UOM	No
Mnt_Issuebasis	fin_flag	varchar(25)	Yes	Issue Basis	No
Mnt_CapexProposalno	fin_documentno	varchar(40)	Yes	Capital expenditure proposal number	No
Mnt_DR_Warehouse	fin_warehouse	varchar(10)	Yes	Debit Warehouse	No
Mnt_CR_Warehouse	fin_warehouse	varchar(10)	Yes	Credit Warehouse	No
Mnt_CCusage	fin_usageid	varchar(20)	Yes	Cost center Usage	No
Mnt_Accusage	fin_usageid	varchar(20)	Yes	Account Usage	No
Mnt_TranCost	fin_amount	numeric(13)	Yes	Tran cost	No
Mnt_BaseCost	fin_amount	numeric(13)	Yes	Base Cost	No
Mnt_AccCurrency	fin_flag	varchar(25)	Yes	Account currency	No
Mnt_MaterialCost	fin_amount	numeric(13)	Yes	Material cost	No
Mnt_LabourCost	fin_amount	numeric(13)	Yes	Labour cost	No
Mnt_ToolsCost	fin_amount	numeric(13)	Yes	Toolcost	No
Mnt_EquipmentCost	fin_amount	numeric(13)	Yes	Equipment cost	No
Mnt_OthersCost	fin_amount	numeric(13)	Yes	Other cost	No
Mnt_SkillCost	fin_amount	numeric(13)	Yes	Skill Cost	No
Mnt_MiscCost	fin_amount	numeric(13)	Yes	Miscelleneros Cost	No
Mnt_PartCost	fin_amount	numeric(13)	Yes	Part cost	No
Mnt_currency	fin_currencycode	varchar(5)	Yes	Currency	No
Mnt_DR_AccountType	fin_flag	varchar(25)	Yes	Debit Account Type	No
Mnt_CR_AccountType	fin_flag	varchar(25)	Yes	Credit Account type	No
Mnt_DR_Accode	fin_accountcode	varchar(32)	Yes	Debit account code	No
Mnt_CR_Accode	fin_accountcode	varchar(32)	Yes	credit account code	No
Mnt_DR_FBtype	fin_flag	varchar(25)	Yes	Debit Finance Book type	No
Mnt_CR_FBtype	fin_flag	varchar(25)	Yes	credit finance book type	No
Mnt_DR_FB	fin_financebookid	varchar(20)	Yes	Debit Finance Book	No
Mnt_CR_FB	fin_financebookid	varchar(20)	Yes	Credit finance book	No
Mnt_DR_CCtype	fin_flag	varchar(25)	Yes	Debit Cost center type	No
Mnt_CR_CCtype	fin_flag	varchar(25)	Yes	Credit Cost center type	No
Mnt_DR_CC	fin_costcentercode	varchar(10)	Yes	Debit Cost center	No
Mnt_CR_CC	fin_costcentercode	varchar(10)	Yes	Credit Cost center	No
Mnt_DR_AnalType	fin_flag	varchar(25)	Yes	Debit Analysis Type	No
Mnt_CR_AnalType	fin_flag	varchar(25)	Yes	Credit Analysis type	No
Mnt_DR_AnalCode	fin_analysiscode	varchar(5)	Yes	Debit Analysis Code	No
Mnt_CR_AnalCode	fin_analysiscode	varchar(5)	Yes	Credit Analysis Code	No
Mnt_DR_SubAnalType	fin_flag	varchar(25)	Yes	Debit Sub analysis Type	No
Mnt_CR_SubAnalType	fin_flag	varchar(25)	Yes	Credit sub analysis type	No
Mnt_DR_SubAnalCode	fin_subanalysiscode	varchar(5)	Yes	Debit Sub analysis code	No
Mnt_CR_SubAnalCode	fin_subanalysiscode	varchar(5)	Yes	Credit sub analysis code	No
Mnt_Entity_Accounted	fin_flag	varchar(25)	Yes	Entity Accounted	No
Mnt_TagNo	fin_seqno	int(4)	Yes	Tag Number	No
Mnt_Interfb_appl	fin_flag	varchar(25)	Yes	Inter Finance book applicable	No
Mnt_Partexp_policy	fin_flag	varchar(25)	Yes	Part expense policy	No
Mnt_Process_LineNo	fin_rowcount	numeric(9)	Yes	Process line number	No
Mnt_interfb_line	fin_seqno	int(4)	Yes	Inter finance book Line	No
Mnt_Posting_id	fin_param_text	varchar(255)	Yes	Posting Id	No
Mnt_document_date	fin_date	datetime(8)	Yes	Document date	No
Mnt_refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
Mnt_refdoc_no	fin_documentno	varchar(40)	Yes	Reference document no	No
Mnt_custorder_no	fin_documentno	varchar(40)	Yes	customer order number	No
Mnt_ame_no	fin_documentno	varchar(40)	Yes	AME number	No
Mnt_swo_no	fin_documentno	varchar(40)	Yes	Shop work order Number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes
mnt_customer_id	fin_customer_id	varchar(18)	Yes	Customer Id	No
mnt_supplier_id	fin_vendorcode	varchar(45)	Yes	Supplier Id	No
mnt_exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No
created_area_code	fin_documentno	varchar(40)	Yes	creted area code	No
Mnt_track_id	fin_bigint	Int(8)	Yes	track id	No
Mnt_PartAcctGrp	fin_itemgroup	Varchar(25)	Yes	part account group	No

Table Name :	Cmn_PO_AcctPost_MetaData
Comment :	Metadata for Purchase order cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APM_Doc_Trn_Type	fin_designparamcode	varchar(5)	Yes	Document Transaction type	No
APM_Doc_Type	fin_flag	varchar(25)	Yes	Document Type	No
APM_Matching_Type	fin_designparamcode	varchar(5)	Yes	Matching Type	No
APM_RecptRecordOpt	fin_designparamcode	varchar(5)	Yes	Receipt record option	No
APM_Exp_Type	fin_designparamcode	varchar(5)	Yes	Expense type	No
APM_Part_ExpPolicy	fin_designparamcode	varchar(5)	Yes	Part expense policy	No
APM_WarrentyApp	fin_designparamcode	varchar(5)	Yes	Warrenty Applicable	No
APM_RefDocType	fin_designparamcode	varchar(5)	Yes	Reference Document type	No
APM_RefDocExpPolicy	fin_designparamcode	varchar(5)	Yes	Reference Document expense policy	No
APM_RefDocExpType	fin_designparamcode	varchar(5)	Yes	Reference Document Expense type	No
APM_BelowThreshold	fin_designparamcode	varchar(5)	Yes	Below threshold	No
APM_Entity_Accounted	fin_flag	varchar(25)	Yes	Entity Accounted	No
APM_DR_AccountType	fin_usageid	varchar(20)	Yes	Debit Account type	No
APM_CR_AccountType	fin_usageid	varchar(20)	Yes	Credit account type	No
APM_DR_FBType	fin_financebookid	varchar(20)	Yes	Debit Finance book type	No
APM_CR_FBType	fin_financebookid	varchar(20)	Yes	Credit finance book type	No
APM_DR_CCType	fin_flag	varchar(25)	Yes	Debit Cost center type	No
APM_CR_CCType	fin_flag	varchar(25)	Yes	Credit Cost center type	No
APM_DR_AnalType	fin_flag	varchar(25)	Yes	Debit analysis type	No
APM_CR_AnalType	fin_flag	varchar(25)	Yes	Credit Analysis type	No
APM_DR_SubAnalType	fin_flag	varchar(25)	Yes	Debit Sub analysis type	No
APM_CR_SubAnalType	fin_flag	varchar(25)	Yes	Credit Sub analysis type	No
apm_line_no	fin_seqno	int(4)	Yes	Line no	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting Id	No
APM_PrtExp_Type	fin_designparamcode	varchar(5)	Yes	Part expense type	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes

Table Name :	cmn_ro_acctpost_metadata
Comment :	Metadata for repair order cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_doc_trn_type	fin_designparamcode	varchar(5)	Yes	Document tran type	No
apm_doc_type	fin_designparamcode	varchar(5)	Yes	Document type	No
apm_exp_type	fin_designparamcode	varchar(5)	Yes	Expense type	No
apm_part_exptype	fin_designparamcode	varchar(5)	Yes	Part expense type	No
apm_part_exppolicy	fin_designparamcode	varchar(5)	Yes	Part expense policy	No
apm_maint_exppolicy	fin_designparamcode	varchar(5)	Yes	Maintenance Expense policy	No
apm_refdoctype	fin_designparamcode	varchar(5)	Yes	Reference document type	No
apm_refdocexppolicy	fin_designparamcode	varchar(5)	Yes	Reference document expense policy	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	Entity Accounted	No
apm_dr_fbtype	fin_flag	varchar(25)	Yes	Debit Finance book type	No
apm_dr_accounttype	fin_flag	varchar(25)	Yes	Debit account type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Debit cost center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Debit analysis type	No
apm_cr_fbtype	fin_flag	varchar(25)	Yes	credit finance book type	No
apm_cr_accounttype	fin_flag	varchar(25)	Yes	Credit Account type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Credit cost center type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Credit analysis type	No
apm_line_no	fin_seqno	int(4)	Yes	Line No	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting ID	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit Sub analysis type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit sub analysis type	No
apm_refdocavlbl	fin_designparamcode	varchar(5)	Yes	Reference document Available	No
apm_refdocmntpolicy	fin_designparamcode	varchar(5)	Yes	Reference document policy	No
apm_setoption	fin_designparamcode	varchar(5)	Yes	Set option	No
apm_wo_status	fin_status	varchar(25)	Yes	Work order status	No
apm_tsk_status	fin_status	varchar(25)	Yes	Task status	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes
apm_ownership	fin_flag	varchar(25)	Yes	Owner ship	No
apm_exch_flag	fin_flag	varchar(25)	Yes	Exchange flag	No
apm_refcost_flag	fin_flag	varchar(25)	Yes	Reference cost flag	No

Table Name :	cmn_rr_finpost_input_his
Comment :	History details for Account posting input information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
grf_guid	fin_guid	varchar(40)	Yes	GUID	No
grf_gr_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	OU instance	No
grf_gr_no	fin_documentno	varchar(40)	Yes	Goods receipt number	No
grf_gr_type	fin_designparamcode	varchar(5)	Yes	Goods receipt type	No
grf_gr_trantype	fin_flag	varchar(25)	Yes	Goods receipt tran type	No
grf_gr_trandate	fin_datetime	datetime(8)	Yes	Goods receipt tram date	No
grf_gr_doctype	fin_designparamcode	varchar(5)	Yes	Goods receipt document type	No
grf_gr_rotype	fin_designparamcode	varchar(5)	Yes	Goods receipt repair order type	No
grf_gr_roexchgtype	fin_designparamcode	varchar(5)	Yes	Repair order exchange type	No
grf_gr_refdocou	fin_ctxt_ouinstance	int(4)	Yes	Goods receipt reference document ou instance	No
grf_gr_refdocno	fin_documentno	varchar(40)	Yes	Goods receipt reference document number	No
grf_gr_status	fin_designparamcode	varchar(5)	Yes	Goods receipt satus	No
grf_gr_refdoccurr	fin_currencycode	varchar(5)	Yes	Goods receipt reference document currency	No
grf_gr_shopjobtype	fin_designparamcode	varchar(5)	Yes	Goods receiptShop joj type	No
grf_gr_exptype	fin_designparamcode	varchar(5)	Yes	Goods receipt Expense type	No
grf_gr_rocateg	fin_flag	varchar(25)	Yes	Repair order category	No
grf_rod_ref_doc_ou	fin_ctxt_ouinstance	int(4)	Yes	Repair order Reference document ouinstance	No
grf_rod_ref_doc_no	fin_documentno	varchar(40)	Yes	Repair order Reference document number	No
grf_rod_ref_doc_type	fin_flag	varchar(25)	Yes	Repair order Reference document type	No
grf_refdocexppolicy	fin_flag	varchar(25)	Yes	Repair order expense policy	No
grf_gr_ropartno	fin_partno	varchar(40)	Yes	Repair order part number	No
grf_gr_ropartou	fin_ctxt_ouinstance	int(4)	Yes	Repair order part ou instance	No
grf_gr_partexptype	fin_flag	varchar(25)	Yes	Part expense type	No
grf_gr_partexppolicy	fin_flag	varchar(25)	Yes	part expense policy	No
grf_gr_partmainttype	fin_flag	varchar(25)	Yes	Part maintainance type	No
grf_aircraftou	fin_ctxt_ouinstance	int(4)	Yes	Aircraft register ou instance	No
grf_aircraftregno	fin_aircraftnumber	varchar(30)	Yes	Aircraft register number	No
grf_gr_whno	fin_flag	varchar(25)	Yes	Warehouse number	No
grf_gr_capexpropno	fin_flag	varchar(25)	Yes	Capital expense proposal number	No
grf_gr_berqty	fin_quantity	numeric(17)	Yes	BER quantity	No
grf_gr_bercost	fin_amount	numeric(13)	Yes	BER Cost	No
grf_gr_trancost	fin_amount	numeric(13)	Yes	Tran cost	No
grf_gr_lineno	fin_lineno	int(4)	Yes	Line number	No
grf_gr_rcvdqty	fin_quantity	numeric(17)	Yes	Received quantity	No
grf_gr_rejqty	fin_quantity	numeric(17)	Yes	Rejected quantity	No
grf_gr_accqty	fin_quantity	numeric(17)	Yes	Accept quantity	No
grf_gr_movqty	fin_quantity	numeric(17)	Yes	Moved quantity	No
grf_gr_partno	fin_partno	varchar(40)	Yes	Part number	No
grf_gr_partou	fin_ctxt_ouinstance	int(4)	Yes	Part ouinstance	No
grf_gr_corespare	fin_flag	varchar(25)	Yes	Core spare	No
grf_gr_uom	fin_uom	varchar(15)	Yes	UOM	No
grf_gr_entacc	fin_flag	varchar(25)	Yes	entity accounted	No
grf_item_tcd_flag	fin_flag	varchar(25)	Yes	item tcd flag	No
grf_tcd_ou	fin_ctxt_ouinstance	int(4)	Yes	TCD ouinstance	No
grf_tcd_acct_rule	fin_designparamcode	varchar(5)	Yes	TCD Account rule	No
grf_tcd_code	fin_tcdcodes	varchar(25)	Yes	TCD code	No
grf_tcd_var	fin_tcdchgstslevel	varchar(25)	Yes	TCD varience	No
grf_dr_accounttype	fin_flag	varchar(25)	Yes	Debit account type	No
grf_cr_accounttype	fin_flag	varchar(25)	Yes	credit account type	No
grf_dr_fbtype	fin_flag	varchar(25)	Yes	Debit Finance book Type	No
grf_cr_fbtype	fin_flag	varchar(25)	Yes	Credit finance book type	No
grf_dr_cctype	fin_flag	varchar(25)	Yes	Debit cost center type	No
grf_cr_cctype	fin_flag	varchar(25)	Yes	Credit cost center type	No
grf_dr_analtype	fin_flag	varchar(25)	Yes	Debit analysis type	No
grf_cr_analtype	fin_flag	varchar(25)	Yes	Credit Analysis type	No
grf_dr_account	fin_accountcode	varchar(32)	Yes	Debit account code	No
grf_cr_account	fin_accountcode	varchar(32)	Yes	Credit account code	No
grf_dr_fb	fin_financebookid	varchar(20)	Yes	Debit Finance book	No
grf_cr_fb	fin_financebookid	varchar(20)	Yes	Credit Finance book	No
grf_dr_cc	fin_costcentercode	varchar(10)	Yes	Debit Cost center	No
grf_cr_cc	fin_costcentercode	varchar(10)	Yes	Credit Cost center	No
grf_dr_analysis	fin_analysiscode	varchar(5)	Yes	Debit analysis code	No
grf_cr_analysis	fin_analysiscode	varchar(5)	Yes	Credit analysis code	No
grf_drtran_currency	fin_currencycode	varchar(5)	Yes	Debit tran Currency	No
grf_crtran_currency	fin_currencycode	varchar(5)	Yes	Credit tran currency	No
grf_base_exch_rate	fin_amount	numeric(13)	Yes	Base exchange rate	No
grf_dr_subanalysis	fin_subanalysiscode	varchar(5)	Yes	Debit Sub analysis code	No
grf_cr_subanalysis	fin_subanalysiscode	varchar(5)	Yes	Credit Sub analysis code	No
grf_gr_lineid	fin_rowcount	numeric(9)	Yes	Line id	No
grf_dr_costingusage	fin_usageid	varchar(20)	Yes	Debit costing usage	No
grf_cr_costingusage	fin_usageid	varchar(20)	Yes	Credit Costing usage	No
grf_dr_accountusage	fin_usageid	varchar(20)	Yes	Debit account usage	No
grf_cr_accountusage	fin_usageid	varchar(20)	Yes	Credit account usage	No
grf_itemcode	fin_partno	varchar(40)	Yes	Item code	No
grf_itemvariant	fin_tcdchgstslevel	varchar(25)	Yes	Item Variant	No
grf_issuewhid	fin_flag	varchar(25)	Yes	Issue warehouse id	No
grf_tagno	fin_seqno	int(4)	Yes	Tag no	No
grf_process_lineno	fin_seqno	int(4)	Yes	Process Line no	No
grf_interfb_line	fin_seqno	int(4)	Yes	Interfb line	No
grf_interfb_appl	fin_flag	varchar(25)	Yes	Interfb Applicable	No
grf_posting_id	fin_param_text	varchar(255)	Yes	posting id	No
grf_gr_refdoclineno	fin_lineno	int(4)	Yes	Reference document line number	No
grf_gr_refdocmntpolicy	fin_flag	varchar(25)	Yes	Reference document maintainence policy	No
grf_gr_refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
grf_gr_refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
grf_gr_custorder_no	fin_documentno	varchar(40)	Yes	Customer Order Number	No
grf_gr_ame_no	fin_documentno	varchar(40)	Yes	Ame Number	No
grf_gr_swo_no	fin_documentno	varchar(40)	Yes	Shop work order number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes
grf_gr_customer_id	fin_customer_id	varchar(18)	Yes	Customer Id	No
grf_gr_supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier Code	No
grf_gr_task_track_id	fin_unique_id	Int(8)	Yes	task track id	No

Table Name :	cmn_swo_acctpost_metadata
Comment :	Metadata for swo related cost booking

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
apm_doc_type	fin_flag	varchar(25)	Yes	Documet type	No
apm_materialtype	fin_designparamcode	varchar(5)	Yes	Material type	No
apm_partissue_basis	fin_designparamcode	varchar(5)	Yes	Part Issue Basis	No
apm_ownership	fin_designparamcode	varchar(5)	Yes	Ownership	No
apm_jobtype	fin_designparamcode	varchar(5)	Yes	Job type	No
apm_maint_policy	fin_designparamcode	varchar(5)	Yes	Maintence Policy	No
apm_RepExp_policy	fin_designparamcode	varchar(5)	Yes	Repair Expense Policy	No
apm_ber_flag	fin_designparamcode	varchar(5)	Yes	BER flag	No
apm_expense_type	fin_designparamcode	varchar(5)	Yes	Expense type	No
apm_task_closed	fin_designparamcode	varchar(5)	Yes	Task closed status	No
apm_wo_closed	fin_designparamcode	varchar(5)	Yes	Work order closed status	No
apm_part_exppolicy	fin_designparamcode	varchar(5)	Yes	Part Expense policy	No
apm_entity_accounted	fin_flag	varchar(25)	Yes	Entity Accounted	No
apm_dr_fbtype	fin_flag	varchar(25)	Yes	Debit Finance book type	No
apm_dr_acctype	fin_flag	varchar(25)	Yes	Debit Account type	No
apm_dr_cctype	fin_flag	varchar(25)	Yes	Debit Cost center type	No
apm_dr_analtype	fin_flag	varchar(25)	Yes	Debit Analysis Type	No
apm_dr_subanaltype	fin_flag	varchar(25)	Yes	Debit sub analysis type	No
apm_cr_fbtype	fin_flag	varchar(25)	Yes	Credit Finance book type	No
apm_cr_acctype	fin_flag	varchar(25)	Yes	Credit Account type	No
apm_cr_cctype	fin_flag	varchar(25)	Yes	Credit Cost center type	No
apm_cr_analtype	fin_flag	varchar(25)	Yes	Credit Analysis type	No
apm_cr_subanaltype	fin_flag	varchar(25)	Yes	Credit sub analysis type	No
apm_line_no	fin_seqno	int(4)	Yes	Line Number	No
apm_posting_id	fin_param_text	varchar(255)	Yes	Posting Id	No
apm_maincore_exptype	fin_designparamcode	varchar(5)	Yes	Main core expense type	No
apm_cost_booking_tp	fin_param_code	varchar(6)	Yes	Cost booking	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes
apm_exch_flag	fin_designparamcode	varchar(5)	Yes	Exchange flag	No
apm_refcost_flag	fin_flag	varchar(25)	Yes	Reference cost flag	No

Table Name :	co_cocst_cost_summary
Comment :	Exchange cost for repair order and advance exchange

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cocst_ord_no	fin_documentno	varchar(40)	Yes	Customer order number	No
cocst_ord_ou	fin_ctxt_ouinstance	int(4)	Yes	Customer order ouinstance	No
cocst_cost_flag	fin_flag	varchar(25)	Yes	Cost flag	No
cocst_ref_doc_type	fin_quickcodes	varchar(25)	Yes	Reference document type	No
cocst_ref_doc_no	fin_documentno	varchar(40)	Yes	reference document number	No
cocst_ref_doc_curr	fin_currencycode	varchar(5)	Yes	Reference document currency	No
cocst_cost	fin_amount	numeric(13)	Yes	Exchange cost	No
cocst_erate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
cocst_cost_base	fin_amount	numeric(13)	Yes	Base amount for Exchage cost	No
cocst_posted_flag	fin_flag	varchar(25)	Yes	Posted flag	No
cocst_comments	fin_txt2000	varchar(2000)	Yes	Comments	No
cocst_created_date	fin_datetime	datetime(8)	Yes	Created date	No
cocst_created_by	fin_ctxt_user	varchar(30)	Yes	Created by	No
cocst_modified_date	fin_datetime	datetime(8)	Yes	Modified date	No
cocst_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified by	No
cosct_service	fin_ctxt_service	varchar(32)	Yes	Service	No
cocst_unique_id	fin_seqno	int(4)	Yes	Unique Id	No
replication_key	_bigint_8	Bigint(8)	No	Replication key	Yes

Table Name :	ro_rocst_cost_summary
Comment :	Cost details for repair order related

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance Id	No
ro_no	fin_documentnumber	varchar(18)	Yes	Repair order number	No
extrep_cost	fin_amount	numeric(13)	Yes	External Repair cost	No
ref_doc_type	fin_trantype	varchar(40)	Yes	Reference document type	No
ref_doc_no	fin_documentnumber	varchar(18)	Yes	Reference document number	No
contract_no	fin_documentno	varchar(40)	Yes	Contract Number	No
custorder_no	fin_documentnumber	varchar(18)	Yes	Customer order number	No
co_rev_no	fin_documentnumber	varchar(18)	Yes	Customer order revision number	No
comments	udd_txt2000	varchar(2000)	Yes	Ro cost Comments	No
created_date	fin_date	datetime(8)	Yes	Created date	No
created_by	fin_ctxt_user	varchar(30)	Yes	Created by	No
modified_date	fin_date	datetime(8)	Yes	Modified date	No
modified_by	fin_ctxt_user	varchar(30)	Yes	Modified by	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes