Account Group

Account Group

Table Name AGP_CAG_Cust_Act_Grp

Table Comment Customer Account Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CAG_Created_OUInstance	decimal(10)	NOT NULL	Created Ou instance	No	No
CAG_Cust_Act_Grp_Code	varchar(18)	NOT NULL	Customer Account Group Code	No	No
CAG_Cust_Act_Grp_Desc	varchar(60)	NOT NULL	Customer Account Group Description	No	No
CAG_Cust_Act_Grp_Status	varchar(20)	NOT NULL	Customer Account Group status	No	No
CAG_Created_By	varchar(30)	NOT NULL	Created by	No	No
CAG_Created_Date	datetime	NOT NULL	Created Date	No	No
CAG_Modified_By	varchar(30)	NULL	Modified by	No	No
CAG_Modified_Date	datetime	NULL	Modified Date	No	No
CAG_TimeStamp	decimal(10)	NOT NULL	Time Stamp	No	No

Table Name AGP_CAM_Cust_ActGrp_Map

Table Comment Customer Account Group Map
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CAM_CREATED_OUINSTANCE	decimal(10)	NOT NULL	Account Group OUInstance	No	No
CAM_CUST_ACT_GRP_CODE	varchar(18)	NOT NULL	Account Group Code.	No	No
CAM_Customer_Code	varchar(18)	NOT NULL	Customer Code	No	No
CAM_Customer_OU	decimal(10)	NULL	Customer Ou	No	No
CAM_Created_By	varchar(30)	NOT NULL	Created By	No	No
CAM_Created_Date	datetime	NOT NULL	Created Date	No	No
CAM_Modified_By	varchar(30)	NOT NULL	Modified By	No	No
CAM_Modified_Date	datetime	NOT NULL	Modified Date	No	No
CAM_Timestamp	decimal(10)	NULL	TimeStamp	No	No

Table Name AGP_OS_Option_Settings

Table Comment Setting option
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
OS_OUInstance	decimal(10)	NOT NULL	Ou Instance	No	No
OS_ActGrp_Mast_Part_Flag	varchar(30)	NULL	Account Group Part Mast Flag	No	No
OS_ActGrp_ActivePart_Flag	varchar(30)	NULL	Account Group Active Part Flag	No	No
OS_ActGrp_Use_Supp_Flag	varchar(30)	NULL	Account Group Use Supplier Flag	No	No
OS_Wh_Fin_Book_Flag	varchar(30)	NULL	Ware house Finance book flag	No	No
OS_ActGrp_Mast_Cust_Flag	varchar(30)	NULL	Account Group Mast customer flag	No	No
OS_ActGrp_ActiveCust_Flag	varchar(30)	NULL	Account Group Active Customer flag	No	No
OS_Fin_Post_Skill_Flag	varchar(30)	NULL	Finance Post skill flag	No	No
OS_Fin_Post_Tool_Flag	varchar(30)	NULL	finance post tool flag	No	No
OS_Fin_Post_Eqp_Flag	varchar(30)	NULL	finance post eqp flag	No	No
OS_Fin_Post_Others_Flag	varchar(30)	NULL	finance posting others flag	No	No
OS_Fin_Post_MiscExp_Flag	varchar(30)	NULL	finance posting misc exp flag	No	No
OS_Fin_Post_Add_Parts_Flag	varchar(30)	NULL	finance posting Additional Parts	No	No
OS_Int_Hangar_Maint_Flag	varchar(30)	NULL	Int Hanger Maintenance Flag	No	No
OS_Int_Comp_Maint_Flag	varchar(30)	NULL	Int Component Maintenance flag	No	No
OS_Created_By	varchar(30)	NULL	created by	No	No
OS_Created_Date	datetime	NULL	Created Date	No	No
OS_Modified_By	varchar(30)	NULL	Modified by	No	No
OS_Modified_Date	datetime	NULL	Modified Date	No	No
OS_TimeStamp	decimal(10)	NULL	Time Stamp	No	No
OS_ACTGRP_MAST_SUPP_FLAG	varchar(30)	NULL	Account Group Mast Supplier flag	No	No
OS_RC_MainCore_Rtn_Flag	varchar(5)	NULL	Report Consumption after Main Core return Values are ’Y’ - ’Yes’ or ’N’ - ’No’	No	No
OS_AM_Aircraft_Flag	varchar(5)	NULL	Enforce Object to Asset Mapping For Aircraft Flag	No	No
OS_AM_Component_Flag	varchar(5)	NULL	Enforce Object to Asset Mapping For Component Flag	No	No
OS_AM_Facility_Flag	varchar(5)	NULL	Enforce Object to Asset Mapping For Facility Flag	No	No
OS_WC_COMP_MAINT_FLAG	varchar(5)	NULL	Component Maintenance Flag ( Yes/No )	No	No
OS_AnalAcc_AircExp_Flag	designparamcode	NULL	AircExp Flag	No	No

Table Name AGP_PAG_Part_Act_Grp

Table Comment Part Account Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PAG_Created_OUInstance	decimal(10)	NOT NULL	Created Ou Instance	No	No
PAG_Part_Act_Grp_Code	varchar(20)	NOT NULL	Part Account Group code	No	No
PAG_Part_Act_Grp_Desc	varchar(60)	NOT NULL	Part Account Group Description	No	No
PAG_Part_Act_Grp_Status	varchar(15)	NOT NULL	Part Account Group Status	No	No
PAG_Created_By	varchar(30)	NOT NULL	Created by	No	No
PAG_Created_Date	datetime	NOT NULL	Created Date	No	No
PAG_Modified_By	varchar(30)	NOT NULL	Modified By	No	No
PAG_Modified_Date	datetime	NOT NULL	Modified Date	No	No
PAG_TimeStamp	decimal(10)	NOT NULL	Time Stamp	No	No

Table Name AGP_PAM_Part_ActGrp_Map

Table Comment Part Account Group Map
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PAM_CREATED_OUINSTANCE	decimal(10)	NOT NULL	Account Group OUInstance	No	No
PAM_PART_ACT_GRP_CODE	varchar(18)	NOT NULL	Part Account Group Code.	No	No
PAM_PartNo	varchar(40)	NOT NULL	Customer Code	No	No
PAM_Part_OU	decimal(10)	NULL	Part Ou	No	No
PAM_Created_By	varchar(30)	NOT NULL	Created By	No	No
PAM_Created_Date	datetime	NOT NULL	Created Date	No	No
PAM_Modified_By	varchar(30)	NOT NULL	Modified by	No	No
PAM_Modified_Date	datetime	NOT NULL	Modified Date	No	No
PAM_Timestamp	decimal(10)	NOT NULL	Time Stamp	No	No

Table Name AGP_Parameter_Details

Table Comment Account Group Parameter details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ComponentName	varchar(20)	NOT NULL	Component Name	Yes	No
ParamCategory	varchar(20)	NOT NULL	Parameter Category	Yes	No
ParamType	varchar(20)	NOT NULL	Parameter Type	Yes	No
ParamCode	varchar(20)	NOT NULL	Parameter Code	Yes	No
ParamDesc	varchar(20)	NULL	Parameter Description	No	No
LangId	int	NULL	Language Id	No	No

Table Name AGP_PFB_Posting_Finance_Book

Table Comment Posting finance book Account Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PFB_OrgUnit	decimal(10)	NOT NULL	Ou Instance	No	No
PFB_Transaction_Event	varchar(40)	NOT NULL	Transaction Event	No	No
PFB_Created_OUInstance	decimal(10)	NULL	Created Ou Instance	No	No
PFB_Posting_Book	varchar(20)	NULL	Posting Book	No	No
PFB_Created_By	varchar(30)	NULL	Created by	No	No
PFB_Created_Date	datetime	NULL	Created Date	No	No
PFB_Modified_By	varchar(30)	NULL	Modified by	No	No
PFB_Modified_Date	datetime	NULL	Modified Date	No	No
PFB_TimeStamp	decimal(10)	NULL	TimesTamp	No	No

Table Name AGP_SAG_Supp_Act_Grp

Table Comment Supplier Account Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SAG_Created_OUInstance	decimal(10)	NOT NULL	Created Ou instance	No	No
SAG_Supp_Act_Grp_Code	varchar(20)	NOT NULL	Supplier Account Group Code	No	No
SAG_Supp_Act_Grp_Desc	varchar(60)	NOT NULL	Supplier Account Group Description	No	No
SAG_Supp_Act_Grp_Status	varchar(15)	NOT NULL	Supplier Account Group Status	No	No
SAG_Created_By	varchar(30)	NOT NULL	Created by	No	No
SAG_Created_Date	datetime	NOT NULL	Create Date	No	No
SAG_Modified_By	varchar(30)	NULL	Modified By	No	No
SAG_Modified_Date	datetime	NULL	Modified Date	No	No
SAG_TimeStamp	decimal(10)	NOT NULL	Time Stamp	No	No

Table Name AGP_SAM_Supp_ActGrp_Map

Table Comment Supplier Account Group Map
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SAM_CREATED_OUINSTANCE	decimal(10)	NOT NULL	Account Group OU Instance	No	No
SAM_SUPP_ACT_GRP_CODE	varchar(18)	NOT NULL	Supplier Account Group Code.	No	No
SAM_SupplierCode	varchar(45)	NOT NULL	Customer Code	No	No
SAM_Supplier_OU	decimal(10)	NULL	Supplier Ou	No	No
SAM_Created_By	varchar(30)	NOT NULL	Created By	No	No
SAM_Created_Date	datetime	NOT NULL	Created Date	No	No
SAM_Modified_By	varchar(30)	NOT NULL	Modified By	No	No
SAM_Modified_Date	datetime	NOT NULL	Modified Date	No	No
SAM_Timestamp	decimal(10)	NOT NULL	Time Stamp	No	No

Table Name agp_pfb_Entity_finance_book

Table Comment Posting Entity and Finance Book
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pefb_orgunit	fin_ctxt_ouinstance	NOT NULL	pefb_orgunit	No	No
pefb_transaction_event	fin_event	NOT NULL	pefb_transaction_event	No	No
pefb_created_ouinstance	fin_ctxt_ouinstance	NOT NULL	pefb_created_ouinstance	No	No
pefb_entity	fin_entity	NULL	pefb_entity	No	No
pefb_applicable	fin_designparamcode	NOT NULL	pefb_applicable	No	No
pefb_priority	fin_ctxt_user	NOT NULL	pefb_priority	No	No
pefb_created_by	fin_datetime	NOT NULL	pefb_created_by	No	No
pefb_created_date	fin_ctxt_user	NOT NULL	pefb_created_date	No	No
pefb_modified_by	fin_datetime	NOT NULL	pefb_modified_by	No	No
pefb_modified_date	fin_ctxt_user	NOT NULL	pefb_modified_date	No	No
pefb_modified_by	fin_datetime	NOT NULL	pefb_modified_by	No	No
pefb_timestamp	fin_timestamp	NOT NULL	pefb_timestamp	No	No

Table Name agp_pfb_Entity_finance_book_his

Table Comment Posting Entity and Finance Book History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pefbh_orgunit	fin_ctxt_ouinstance	NOT NULL	pefbh_orgunit	No	No
pefbh_transaction_event	fin_event	NOT NULL	pefbh_transaction_event	No	No
pefbh_created_ouinstance	fin_ctxt_ouinstance	NOT NULL	pefbh_created_ouinstance	No	No
pefbh_entity	fin_entity	NULL	pefbh_entity	No	No
pefbh_applicable	fin_designparamcode	NOT NULL	pefbh_applicable	No	No
pefbh_priority	fin_count	NOT NULL	pefbh_priority	No	No
pefbh_modified_by	fin_ctxt_user	NOT NULL	pefbh_modified_by	No	No
pefbh_modified_date	fin_datetime	NOT NULL	pefbh_modified_date	No	No

Table Name agp_eos_entity_option_settings

Table Comment Posting Entity and Option Setting
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eos_ouinstance	fin_ctxt_ouinstance	NOT NULL	eos_ouinstance	No	No
eos_entitybasedfb	fin_designparamcode	NOT NULL	eos_entitybasedfb	No	No
eos_created_by	fin_ctxt_user	NOT NULL	eos_created_by	No	No
eos_created_date	fin_datetime	NULL	eos_created_date	No	No
eos_modified_by	fin_ctxt_user	NOT NULL	eos_modified_by	No	No
eos_modified_date	fin_datetime	NOT NULL	eos_modified_date	No	No
eos_timestamp	fin_timestamp	NOT NULL	eos_timestamp	No	No

Table Name ag_fintrn_finance_trans_det

Table Comment Finance Transaction Detail
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fintrn_component_name	varchar(20)	NOT NULL	Component Name	No	No
fintrn_fb_id	varchar(20)	NOT NULL	Finance Book Id	No	No
fintrn_tran_ou	int	NOT NULL	Transaction OUInstance	No	No
fintrn_document_no	varchar(40)	NOT NULL	Document No	No	No
fintrn_account_code	varchar(32)	NOT NULL	Account Code	No	No
fintrn_company_code	varchar(10)	NOT NULL	Company Code	No	No
fintrn_line_no	char(18)	NOT NULL	Line no	No	No
fintrn_tran_type	varchar(40)	NULL	Transaction Type	No	No
fintrn_tran_date	datetime(8)	NULL	Transaction Date	No	No
fintrn_drcr_flag	varchar(6)	NULL	Debit & Credit flag	No	No
fintrn_currency_code	varchar(5)	NULL	Currency Code	No	No
fintrn_tran_amount	numeric(13)	NULL	Transaction Amount	No	No
fintrn_base_amount	numeric(13)	NULL	Base Amount	No	No
fintrn_par_base_amount	numeric(13)	NULL	Parrell Base Amount	No	No
fintrn_exchange_rate	numeric(9)	NULL	Exchange Rate	No	No
fintrn_par_exchange_rate	numeric(9)	NULL	Parrell Exchange Rate	No	No
fintrn_analysis_code	varchar(5)	NULL	Analysis Code	No	No
fintrn_subanalysis_code	varchar(5)	NULL	Sub Analysis Code	No	No
fintrn_cost_center	varchar(10)	NULL	Cost Center	No	No
fintrn_part_no	varchar(40)	NULL	Part No	No	No
fintrn_quantity	numeric(17)	NULL	Quantity	No	No
fintrn_uom	varchar(15)	NULL	UOM	No	No
fintrn_reftran_no	varchar(40)	NULL	Reference Transaction No	No	No
fintrn_reftran_ou	int	NULL	Reference Transaction OU	No	No
fintrn_ref_tran_type	varchar(40)	NULL	Reference Transaction Type	No	No
fintrn_createdby	varchar(15)	NULL	Created By	No	No
fintrn_created_date	datetime(8)	NULL	Created Date	No	No
FINTRN_GR_EXCHANGE_RATE	numeric(13)	NULL	Goods Receipt Exchange Rate	No	No
fintrn_Item_TCD_Flag	varchar(25)	NULL	Item or TCD Flag	No	No
fintrn_TagNo	int	NULL	Debit & Credit Tag No	No	No
fintrn_RowIdentity	int	NULL	Row Identity No	No	No
item_variant	varchar(70)	NULL	Item Variant	No	No
fintrn_capitalized_amount	int	NULL	Amount eligible for capitalization	No	No
fintrn_po_amend_amt	int	NULL	Amended Amount	No	No
fintrn_supplier_code	varchar(16)	NULL	Supplier Code	No	No
fintrn_proposal_no	varchar(18)	NULL	Proposal Number	No	No
fintrn_document_date	datetime(8)	NULL	Document Date	No	No

Table Name agp_pfb_posting_finance_book_his

Table Comment Posting finance book Account Group history
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PFB_ORGUNIT	decimal(5)	NULL	OU Instance	No	No
PFB_TRANSACTION_EVENT	varchar(40)	NULL	Transaction Event	No	No
PFB_CREATED_OUINSTANCE	decimal(5)	NULL	Created OU Instance	No	No
PFB_POSTING_BOOK	varchar(20)	NULL	Posting Finance Book	No	No
PFB_MODIFIED_BY	varchar(30)	NULL	Modified By	No	No
PFB_MODIFIED_DATE	datetime(8)	NULL	Modified Date	No	No

Table Name Cmn_PO_AcctPost_MetaData

Table Comment Purchase order account posting meta data
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
APM_Doc_Trn_Type	varchar(5)	NULL	Transaction Type	No	No
APM_Doc_Type	varchar(5)	NULL	Document Type	No	No
APM_Matching_Type	varchar(5)	NULL	Matching Type	No	No
APM_RecptRecordOpt	varchar(5)	NULL	Record Receipt Option	No	No
APM_Exp_Type	varchar(5)	NULL	Expense Type	No	No
APM_Part_ExpPolicy	varchar(5)	NULL	Part Expensing Policy	No	No
APM_WarrentyApp	varchar(1)	NULL	Warranty applicable flag	No	No
APM_RefDocType	varchar(5)	NULL	Reference document type	No	No
APM_RefDocExpPolicy	varchar(5)	NULL	Reference document expense policy	No	No
APM_RefDocExpType	varchar(5)	NULL	Reference document expense type	No	No
APM_BelowThreshold	varchar(5)	NULL	Below threshold limit	No	No
APM_Entity_Accounted	varchar(25)	NULL	Entity accounted	No	No
APM_DR_AccountType	varchar(20)	NULL	Debit account type	No	No
APM_CR_AccountType	varchar(20)	NULL	Credit account type	No	No
APM_DR_FBType	varchar(20)	NULL	Debit finance book	No	No
APM_CR_FBType	varchar(20)	NULL	Credit finance book	No	No
APM_DR_CCType	varchar(25)	NULL	Debit CC type	No	No
APM_CR_CCType	varchar(25)	NULL	Credit CC type	No	No
APM_DR_AnalType	varchar(25)	NULL	Debit analysis type	No	No
APM_CR_AnalType	varchar(25)	NULL	Credit analysis type	No	No
APM_DR_SubAnalType	varchar(25)	NULL	Debit subanalysis type	No	No
APM_CR_SubAnalType	varchar(25)	NULL	Credit Subanalysis type	No	No




Table Name Cmn_RO_AcctPost_MetaData

Table Comment Repair order account posting meta data
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
APM_Doc_Trn_Type	varchar(5)	NULL	Transaction Type	No	No
APM_Doc_Type	varchar(5)	NULL	Document Type	No	No
APM_Exp_Type	varchar(5)	NULL	Expense Type	No	No
APM_Part_ExpType	varchar(5)	NULL	Part Expense Type	No	No
APM_Part_ExpPolicy	varchar(5)	NULL	Part Expensing Policy	No	No
APM_Maint_ExpPolicy	varchar(5)	NULL	Maintenance Expensing policy	No	No
APM_RefDocType	varchar(5)	NULL	Reference document type	No	No
APM_RefDocExpPolicy	varchar(5)	NULL	Reference document expense policy	No	No
APM_Entity_Accounted	varchar(25)	NULL	Entity accounted	No	No
APM_DR_FBType	varchar(25)	NULL	Debit Finance Book Type	No	No
APM_DR_AccountType	varchar(25)	NULL	Debit Account Type	No	No
APM_DR_CCType	varchar(25)	NULL	Debit Cost Center Type	No	No
APM_DR_analType	varchar(25)	NULL	Debit Analysis Type	No	No
APM_CR_FBType	varchar(25)	NULL	Credit Finance Book Type	No	No
APM_CR_AccountType	varchar(25)	NULL	Credit Account Type	No	No
APM_CR_CCType	varchar(25)	NULL	Credit Cost Center Type	No	No
APM_CR_analType	varchar(25)	NULL	Credit Analysis Type	No	No

Table Name Cmn_Inv_AcctPost_MetaData

Table Comment Metadata for issue,receipt,return transactions
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
apm_doc_type	fin_flag	NULL	Document Type	No	No
apm_partexp_policy	fin_flag	NULL	Part expense Policy	No	No
apm_partissue_basis	fin_flag	NULL	Part Issue Detail	No	No
apm_entity_accounted	fin_flag	NULL	Entity detail	No	No
apm_dr_acctype	fin_flag	NULL	Debit Account	No	No
apm_dr_fbtype	fin_flag	NULL	Debit Finance Book Type	No	No
apm_dr_cctype	fin_flag	NULL	Debit Cost Center Type	No	No
apm_dr_analtype	fin_flag	NULL	Debit Analysis Type	No	No
apm_dr_subanaltype	fin_flag	NULL	Debit Sub Analysis Type	No	No
apm_cr_acctype	fin_flag	NULL	Credit Account Type	No	No
apm_cr_fbtype	fin_flag	NULL	Debit Account Type	No	No
apm_cr_cctype	fin_flag	NULL	Credit Cost Center Type	No	No
apm_cr_analtype	fin_flag	NULL	Credit Analysis Type	No	No
apm_cr_subanaltype	fin_flag	NULL	Credit Sub Analysis Type	No	No
apm_refdoc_type	fin_flag	NULL	Ref Doc Type	No	No
apm_belowthreshold	fin_flag	NULL	Below threshold	No	No
apm_expensetype	fin_flag	NULL	Expense type	No	No

Table Name Cmn_Inv_FinPost_Input_his

Table Comment History table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Inv_guid	fin_guid	NULL	Guid	No	No
Inv_Ouinstance	fin_ctxt_ouinstance	NULL	OuInstance	No	No
Inv_Tran_No	fin_documentno	NULL	Tran No	No	No
Inv_Trantype	fin_transactiontype	NULL	Tran Type	No	No
Inv_Trandate	fin_date	NULL	Transition Type	No	No
Inv_Doctype	fin_transactiontype	NULL	Document Type	No	No
Inv_Refdoctype	fin_transactiontype	NULL	Reference Document Type	No	No
Inv_Refdocou	fin_ctxt_ouinstance	NULL	Reference Ou	No	No
Inv_Refdocno	fin_documentno	NULL	Reference Document No	No	No
Inv_Refdoclineno	fin_seqno	NULL	Ref. Line no	No	No
Inv_Refdocdate	fin_date	NULL	Ref.Document Date	No	No
Inv_Issue_lineno	fin_seqno	NULL	Issue Line No	No	No
Inv_PartNo	fin_partno	NULL	Issue Part No	No	No
Inv_PartAccGrp	fin_accountgroup	NULL	Account Group	No	No
Inv_PartCat	fin_flag	NULL	Part Category	No	No
Inv_PartType	fin_parttype	NULL	Part Type	No	No
Inv_IssueCat	fin_flag	NULL	Issue Category	No	No
Inv_Issuebasis	fin_flag	NULL	Issue basis	No	No
inv_partou	fin_ctxt_ouinstance	NULL	Part Ou	No	No
inv_comp_type	fin_flag	NULL	Component Type	No	No
Inv_AC_Regno	fin_desc40	NULL	Aircraft Reg. No	No	No
Inv_DR_Warehouse	fin_warehouse	NULL	Debit warehouse	No	No
Inv_CR_Warehouse	fin_warehouse	NULL	Credit warehouse	No	No
Inv_Qty	fin_quantity	NULL	Quantity	No	No
Inv_Rcptqty	fin_quantity	NULL	Receipt Quantity	No	No
Inv_UOM	fin_uom	NULL	UOM	No	No
Inv_CCusage	fin_usageid	NULL	CostCenter	No	No
Inv_Accusage	fin_usageid	NULL	Account Usage	No	No
Inv_TranCost	fin_amount	NULL	Tran. Cost	No	No
Inv_Receiptcost	fin_amount	NULL	Receipt Cost	No	No
Inv_currency	fin_currencycode	NULL	Currency	No	No
Inv_DR_AccountType	fin_flag	NULL	Debit Account Type	No	No
Inv_CR_AccountType	fin_flag	NULL	Credit Account Type	No	No
Inv_DR_Accode	fin_accountcode	NULL	Debit Account Code	No	No
Inv_CR_Accode	fin_accountcode	NULL	Credit Account Code	No	No
Inv_DR_FBtype	fin_flag	NULL	Finance book Type- Debit	No	No
Inv_CR_FBtype	fin_flag	NULL	Finance book Type- Credit	No	No
Inv_DR_FB	fin_financebookid	NULL	Debit FinanceBook	No	No
Inv_CR_FB	fin_financebookid	NULL	Credit FinanceBook	No	No
Inv_DR_CCtype	fin_flag	NULL	DR-Costcenter Type	No	No
Inv_CR_CCtype	fin_flag	NULL	CR-CostCener Type	No	No
Inv_DR_CC	fin_costcentercode	NULL	Debit CostCenter	No	No
Inv_CR_CC	fin_costcentercode	NULL	Credit CostCenter	No	No
Inv_DR_analtype	fin_flag	NULL	Debit Analysis Type	No	No
Inv_CR_analtype	fin_flag	NULL	Credit Analysis Type	No	No
Inv_DR_analcode	fin_analysiscode	NULL	Debit Analysis Code	No	No
Inv_CR_analcode	fin_analysiscode	NULL	Credit Analysis Code	No	No
Inv_DR_subanaltype	fin_flag	NULL	Debit Sub Analysis type	No	No
Inv_CR_subanaltype	fin_flag	NULL	Credit Sub Analysis type	No	No
Inv_DR_subanalcode	fin_subanalysiscode	NULL	Debit Sub Analysis Code	No	No
Inv_CR_subanalcode	fin_subanalysiscode	NULL	Credit Sub Analysis Code	No	No
Inv_Entity_Accounted	fin_flag	NULL	Entity Account	No	No
Inv_TagNo	fin_seqno	NULL	Tag No	No	No
Inv_Interfb_appl	fin_flag	NULL	Interfb Applicable	No	No
Inv_Partexp_policy	fin_flag	NULL	Part Expense Policy	No	No
Inv_Part_CrtOU	fin_ctxt_ouinstance	NULL	Part Created Ou	No	No
Inv_Process_LineNo	fin_rowcount	NULL	Process Line No	No	No
Inv_interfb_line	fin_seqno	NULL	Interfb Line No	No	No
Inv_DocCategory	fin_visitcategory	NULL	Document Category	No	No
Inv_drupdflag	fin_flag	NULL	Debit flag	No	No
Inv_crupdflag	fin_flag	NULL	Credit flag	No	No

Table Name Cmn_GR_FinPost_Input_his

Table Comment History table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
GRF_Guid	fin_guid	NULL	Guid	No	No
GRF_TagNo	fin_seqno	NULL	Tag No	No	No
GRF_GR_OUInstance	fin_ctxt_ouinstance	NULL	OuInstance	No	No
GRF_GR_NO	fin_documentno	NULL	Goods Receipt No	No	No
GRF_GR_LineId	fin_rowcount	NULL	Goods Receipt Line Id	No	No
GRF_GR_RefDocType	fin_designparamcode	NULL	Goods Receipt Reference document Type	No	No
GRF_GR_RefDocOu	fin_ctxt_ouinstance	NULL	Goods Receipt Reference document OU	No	No
GRF_GR_RefDocNo	fin_documentno	NULL	Goods Receipt Reference document No	No	No
GRF_GR_RefDocDate	fin_datetime	NULL	Goods Receipt Reference document date	No	No
GRF_GRD_Gr_Line_No	fin_rowcount	NULL	Goods Receipt Line No	No	No
GRF_GRD_Part_Line_Id	fin_rowcount	NULL	Goods Receipt Part Line Id	No	No
GRF_GRD_Po_Rs_Line_No	fin_rowcount	NULL	Purchase Order Line No.	No	No
GRF_GRD_GR_Part_OU	fin_ctxt_ouinstance	NULL	Goods Receipt Part Ou	No	No
GRF_GRD_PartNo	fin_partno	NULL	Goods Receipt Part No	No	No
GRF_GRD_PartUOM	fin_uom	NULL	Goods Receipt Part UOM	No	No
GRF_GRD_MovedValue	fin_amount	NULL	Goods Receipt Moved Value	No	No
GRF_GRD_BasicValue	fin_amount	NULL	Goods Receipt Basic Value	No	No
GRF_GRD_ReceivedQty	fin_quantitry	NULL	Goods Receipt Received Quantity	No	No
GRF_GRD_RejectedQty	fin_quantitry	NULL	Goods Receipt Rejected Quantity	No	No
GRF_GRD_AcceptedQty	fin_quantitry	NULL	Goods Receipt Accepted Quantity	No	No
GRF_GRD_Line_status	fin_designparamcode	NULL	Goods Receipt Line Status	No	No
GRF_GRD_MovedQty	fin_quantitry	NULL	Goods Receipt Moved Quantity	No	No
GRF_GRD_TotReceivedQty	fin_quantitry	NULL	Goods Receipt Total received Quantity	No	No
GRF_GRD_ClaimAmount	fin_amount	NULL	Goods receipt Claim Amount	No	No
GRF_GRD_WareHouse_No	fin_warehouse	NULL	Goods receipt Ware House No	No	No
GRF_PO_Date	fin_datetime	NULL	Goods receipt Purchase Order date	No	No
GRF_PO_Type	fin_designparamcode	NULL	Goods receipt Purchase Order Type	No	No
GRF_PO_Currency	fin_currencytypeen	NULL	Goods receipt Purchase Order currency	No	No
GRF_PO_AC_Regn_No	fin_aircraftnumber	NULL	Aircraft Registration No	No	No
GRF_PO_Exp_Type	fin_designparamcode	NULL	Expense Type	No	No
GRF_PO_Issue_Doc_No	fin_documentno	NULL	Issue Document No.	No	No
GRF_PO_Issue_Doc_OU	fin_ctxt_ouinstance	NULL	Issue Document Ou	No	No
GRF_PO_Core_Status	fin_designparamcode	NULL	Goods receipt Core Status	No	No
GRF_PO_PUR_Unit	fin_financebookid	NULL	Purchase Order Unit	No	No
GRF_PO_WarrClaim_App	fin_designparamcode	NULL	Purchase Order warranty claim Applicable	No	No
GRF_PO_WarrClaim_No	fin_documentno	NULL	Purchase Order warranty claim No.	No	No
GRF_POD_Matching_Type	fin_designparamcode	NULL	Purchase Order Detail Matching Type	No	No
GRF_POD_Capex_Prop_No	fin_documentno	NULL	Purchase Order Detail Proposal No.	No	No
GRF_POD_Acc_Usg	fin_accountcode	NULL	Purchase Order Detail Account Usage	No	No
GRF_POD_Cstg_Usg	fin_accountcode	NULL	Purchase Order Detail Costing Usage	No	No
GRF_POD_Anal_Code	fin_analysiscode	NULL	Purchase Order Detail Analysis Code	No	No
GRF_POD_SubAnal_Code	fin_subanalysiscode	NULL	Purchase Order Detail Sub Analysis Code	No	No
GRF_POD_RCP_RCD_Opt	fin_designparamcode	NULL	Purchase Order Detail	No	No
GRF_POD_Cap_Thrshold_Amt	fin_amount	NULL	Threshold Amount	No	No
GRF_POD_Ref_Doc_OU	fin_ctxt_ouinstance	NULL	Reference Document Ou.	No	No
GRF_POD_Ref_Doc_No	fin_documentno	NULL	Reference Document No.	No	No
GRF_POD_Ref_Doc_Type	fin_designparamcode	NULL	Reference Document Type	No	No
GRF_POD_Proposal_FB	fin_financebookid	NULL	Proposal Finance Book	No	No
GRF_POD_RefDocExpPolicy	fin_designparamcode	NULL	Expense Policy	No	No
GRF_POD_RefDocExpType	fin_designparamcode	NULL	Expense Type	No	No
GRF_POTC_Fwd_Cvr_Rate	fin_amount	NULL	Forward Cover rate	No	No
GRF_POTC_Fwd_Cvr_Appl	fin_txt150	NULL	Forward cover Applicable	No	No
GRF_Part_ExpPolicy	fin_designparamcode	NULL	Expense Policy	No	No
GRF_Item_TCD_Flag	fin_flag	NULL	TCD Flag	No	No
GRF_TCD_OU	fin_ctxt_ouinstance	NULL	TCD Ouinstance	No	No
GRF_TCD_Acct_Rule	fin_designparamcode	NULL	Tcd account Rule	No	No
GRF_TCD_CODE	fin_tcdcodes	NULL	Tcd Code	No	No
GRF_TCD_VAR	fin_tcdchgstslevel	NULL	TCD Variant	No	No
GRF_DR_AccountType	fin_usageid	NULL	Debit Account Type	No	No
GRF_DR_AccountUsage	fin_usageid	NULL	Debit Account Usage	No	No
GRF_DR_CostingUsage	fin_usageid	NULL	Debit Costing Usage	No	No
GRF_DR_FB	fin_financebookid	NULL	Debit Finance Book	No	No
GRF_DR_Account	fin_accountcode	NULL	Debit Account	No	No
GRF_DR_CC	fin_costcentercode	NULL	Debit CostCenter	No	No
GRF_DR_Analysis	fin_analysiscode	NULL	Debit Analysis Code	No	No
GRF_DR_SubAnalysis	fin_subanalysiscode	NULL	Debit Sub Analysis Code	No	No
GRF_CR_AccountType	fin_usageid	NULL	Credit Account Type	No	No
GRF_CR_AccountUsage	fin_usageid	NULL	Credit Account Usage	No	No
GRF_CR_CostingUsage	fin_usageid	NULL	Credit Costing Usage	No	No
GRF_CR_FB	fin_financebookid	NULL	Credit Finance Book	No	No
GRF_CR_Account	fin_accountcode	NULL	Credit Account Code	No	No
GRF_CR_CC	fin_costcentercode	NULL	Credit Cost Center	No	No
GRF_CR_Analysis	fin_analysiscode	NULL	Credit Analysis Code	No	No
GRF_CR_SubAnalysis	fin_subanalysiscode	NULL	Credit Sub Analysis Code	No	No
GRF_Base_Exch_Rate	fin_amount	NULL	Base Exchange Rate	No	No
GRF_Tran_Amount	fin_amount	NULL	transaction Amount	No	No
GRF_Base_Amount	fin_amount	NULL	Base Amount	No	No
GRF_POD_BelowThreshold	fin_designparamcode	NULL	Purchase Order Detail Below Threshold Value	No	No
GRF_Entity_Accounted	fin_flag	NULL	Entity Accounted	No	No
GRF_ItemCode	fin_itemcode	NULL	Item code	No	No
GRF_ItemVariant	fin_itemvariantdes	NULL	Item variant	No	No
GRF_AccCurrency	fin_flag	NULL	Account Currency	No	No
GRF_InterFB_Line	fin_seqno	NULL	Interfinancebook Line	No	No
GRF_InterFB_Appl	fin_flag	NULL	Interfinancebook Applicable	No	No

Table Name Cmn_CWO_AcctPost_MetaData

Table Comment Metadata for CWO account postings

Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
apm_doc_type	fin_flag	NULL	Document type	No	No
apm_materialtype	fin_designparamcode	NULL	Material type	No	No
apm_partissue_basis	fin_designparamcode	NULL	Part issue basis	No	No
apm_ownership	fin_designparamcode	NULL	Owner ship	No	No
apm_jobtype	fin_designparamcode	NULL	Job type	No	No
apm_maint_policy	fin_designparamcode	NULL	maintenance policy	No	No
apm_RepExp_policy	fin_designparamcode	NULL	Expense policy	No	No
apm_ber_flag	fin_designparamcode	NULL	flag	No	No
apm_expense_type	fin_designparamcode	NULL	Expense type	No	No
apm_task_closed	fin_designparamcode	NULL	Task closed	No	No
apm_wo_closed	fin_designparamcode	NULL	Work order closed	No	No
apm_part_exppolicy	fin_designparamcode	NULL	part expense policy	No	No
apm_entity_accounted	fin_flag	NULL	Entity Accounted	No	No
apm_dr_fbtype	fin_flag	NULL	Debit fb type	No	No
apm_dr_acctype	fin_flag	NULL	Debit account type	No	No
apm_dr_cctype	fin_flag	NULL	Debit CC type	No	No
apm_dr_analtype	fin_flag	NULL	Debit analysis type	No	No
apm_dr_subanaltype	fin_flag	NULL	Debit subanalysis type	No	No
apm_cr_fbtype	fin_flag	NULL	Credit FB type	No	No
apm_cr_acctype	fin_flag	NULL	Credit Account type	No	No
apm_cr_cctype	fin_flag	NULL	Credit CC type	No	No
apm_cr_analtype	fin_flag	NULL	Credit analysis type	No	No
apm_cr_subanaltype	fin_flag	NULL	Credit subanalysis type	No	No

Table Name Cmn_AccountType_MetaData

Table Comment Account type metadata
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
atmd_account_group	fin_accountgroup	NULL	Account group	No	No
atmd_account_type	fin_accounttype	NULL	Account type	No	No
atmd_account_typedesc	fin_accountdesc	NULL	Account type description	No	No

Table Name Cmn_FLog_AcctPost_MetaData

Table Comment Metadata for Techlog account postings

Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
apm_doc_type	fin_designparamcode	NULL	Document type	No	No
apm_partissue_basis	fin_designparamcode	NULL	Part issue basis	No	No
apm_maint_policy	fin_designparamcode	NULL	Maintenance policy	No	No
apm_expense_type	fin_designparamcode	NULL	Expense type	No	No
apm_ownership	fin_designparamcode	NULL	Ownership	No	No
apm_task_closed	fin_designparamcode	NULL	Task closed	No	No
apm_entity_accounted	fin_flag	NULL	Entity Accounted	No	No
apm_dr_fbtype	fin_flag	NULL	Debit FB type	No	No
apm_dr_acctype	fin_flag	NULL	Debit Account type	No	No
apm_dr_cctype	fin_flag	NULL	Debit CC type	No	No
apm_dr_analtype	fin_flag	NULL	Debit analysis type	No	No
apm_dr_subanaltype	fin_flag	NULL	Debit subanalysis type	No	No
apm_cr_fbtype	fin_flag	NULL	Credit FB type	No	No
apm_cr_acctype	fin_flag	NULL	Credit account type	No	No
apm_cr_cctype	fin_flag	NULL	Credit CC type	No	No
apm_cr_analtype	fin_flag	NULL	Credit analysis type	No	No
apm_cr_subanaltype	fin_flag	NULL	Credit Subanalysis type	No	No

Table Name Cmn_ag_unconfirmed_return_dtl

Table Comment

Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ucr_documentou	fin_ctxt_ouinstance	NULL	Document ou	No	No
ucr_documenttype	fin_designparamcode	NULL	Document type	No	No
ucr_documentno	fin_documentno	NULL	Document no	No	No
ucr_taskkeyseqno	fin_taskseqno	NULL	Task seq no	No	No
ucr_taskno	fin_taskcode	NULL	task no	No	No
ucr_return_ou	fin_ctxt_ouinstance	NULL	return ou	No	No
ucr_return_no	fin_documentno	NULL	return no	No	No
ucr_rtn_sysline_no	fin_lineno	NULL	line no	No	No
ucr_rtn_cost	fin_amount	NULL	return cost	No	No
ucr_rtn_confirmed	fin_designparamcode	NULL	confirmed	No	No
ucr_rtn_confirmeddate	fin_datetime	NULL	confirmed date	No	No
ucr_modifieddate	fin_datetime	NULL	modified date	No	No
ucr_modifiedby	fin_user	NULL	modified by	No	No