Powered by InfoCaptor


Previous Page   Next Page

GL Account Aliases
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_GL_ACCOUNT_ALIASESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created ByStandard Who column.GL Account Aliases.Created ByCREATED_BYCREATED_BY124772
Creation Date GL Account Aliases.Creation DateCREATION_DATECREATION_DATE126205
Creation Date - Day GL Account Aliases.Creation Date CREATION_DATE_DAY172401
Creation Date - Month GL Account Aliases.Creation Date CREATION_DATE_MONTH172855
Creation Date - Quarter GL Account Aliases.Creation Date CREATION_DATE_QUARTER173309
Creation Date - Year GL Account Aliases.Creation Date CREATION_DATE_YEAR173763
DescriptionThe accounting period description.GL Account Aliases.DescriptionDESCRIPTIONDESCRIPTION129632
Disable DateAccount alias disable dateGL Account Aliases.Disable DateDISABLE_DATEDISABLE_DATE130129
Disable Date - Day GL Account Aliases.Disable Date DISABLE_DATE_DAY176177
Disable Date - Month GL Account Aliases.Disable Date DISABLE_DATE_MONTH176199
Disable Date - Quarter GL Account Aliases.Disable Date DISABLE_DATE_QUARTER176221
Disable Date - Year GL Account Aliases.Disable Date DISABLE_DATE_YEAR176243
Disposition IdAccount alias identifierGL Account Aliases.Disposition IdDISPOSITION_IDDISPOSITION_ID130206
Disposition Num GL Account Aliases.Disposition NumDISPOSITION_NUMDISPOSITION_NUM273570
Dist Acc Num GL Account Aliases.Dist Acc NumDIST_ACC_NUMDIST_ACC_NUM273571
Distribution AccountDistribution account identifierGL Account Aliases.Distribution AccountDISTRIBUTION_ACCOUNTDISTRIBUTION_ACCOUNT130225
Effective DateThe journal entry effective date.GL Account Aliases.Effective DateEFFECTIVE_DATEEFFECTIVE_DATE130765
Effective Date - Day GL Account Aliases.Effective Date EFFECTIVE_DATE_DAY176517
Effective Date - Month GL Account Aliases.Effective Date EFFECTIVE_DATE_MONTH176521
Effective Date - Quarter GL Account Aliases.Effective Date EFFECTIVE_DATE_QUARTER176525
Effective Date - Year GL Account Aliases.Effective Date EFFECTIVE_DATE_YEAR176529
Last Update Date GL Account Aliases.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140727
Last Update Date - Day GL Account Aliases.Last Update Date LAST_UPDATE_DATE_DAY183778
Last Update Date - Month GL Account Aliases.Last Update Date LAST_UPDATE_DATE_MONTH184206
Last Update Date - Quarter GL Account Aliases.Last Update Date LAST_UPDATE_DATE_QUARTER184634
Last Update Date - Year GL Account Aliases.Last Update Date LAST_UPDATE_DATE_YEAR185062
Last Updated By GL Account Aliases.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139367
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.GL Account Aliases.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150137
Organization Id GL Account Aliases.Organization IdORGANIZATION_IDORGANIZATION_ID150397
Organization Name GL Account Aliases.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150696
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
GL Account Aliases -> Inventory DemandsGL Account Aliases.Disposition Id = Inventory Demands.Account Alias Id GL Account Aliases.Organization Id = Inventory Demands.Organization IdMight not exist in master folderOuter join on master No
GL Account Aliases -> Inventory ReservationsGL Account Aliases.Disposition Id = Inventory Reservations.Account Alias Id GL Account Aliases.Organization Id = Inventory Reservations.Organization IdMight not exist in master folderOuter join on master No
GL Account Aliases -> Material TransactionsGL Account Aliases.Disposition Id = Material Transactions.Account Alias Id GL Account Aliases.Organization Id = Material Transactions.Organization IdMight not exist in master folderOuter join on master No