Powered by InfoCaptor


Previous Page   Next Page

Collection Plans
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.QAFG_COLLECTION_PLANSUnknown
NoneNone.QAFG_COLLECTION_PLANSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Collection Plan Name Collection Plans.Collection Plan NameCOLLECTION_PLAN_NAMECOLLECTION_PLAN_NAME122460
Created ByStandard Who column.Collection Plans.Created ByCREATED_BYCREATED_BY124806
Creation Date Collection Plans.Creation DateCREATION_DATECREATION_DATE126239
Creation Date - Day Collection Plans.Creation Date CREATION_DATE_DAY172469
Creation Date - Month Collection Plans.Creation Date CREATION_DATE_MONTH172923
Creation Date - Quarter Collection Plans.Creation Date CREATION_DATE_QUARTER173377
Creation Date - Year Collection Plans.Creation Date CREATION_DATE_YEAR173831
DescriptionThe accounting period description.Collection Plans.DescriptionDESCRIPTIONDESCRIPTION129642
End Effective DateThe date after which an account becomes inactive.Collection Plans.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133121
End Effective Date - Day Collection Plans.End Effective Date END_EFFECTIVE_DATE_DAY178621
End Effective Date - Month Collection Plans.End Effective Date END_EFFECTIVE_DATE_MONTH178717
End Effective Date - Quarter Collection Plans.End Effective Date END_EFFECTIVE_DATE_QUARTER178813
End Effective Date - Year Collection Plans.End Effective Date END_EFFECTIVE_DATE_YEAR178909
Last Update Date Collection Plans.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140761
Last Update Date - Day Collection Plans.Last Update Date LAST_UPDATE_DATE_DAY183846
Last Update Date - Month Collection Plans.Last Update Date LAST_UPDATE_DATE_MONTH184274
Last Update Date - Quarter Collection Plans.Last Update Date LAST_UPDATE_DATE_QUARTER184702
Last Update Date - Year Collection Plans.Last Update Date LAST_UPDATE_DATE_YEAR185130
Last Updated By Collection Plans.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139401
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Collection Plans.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150157
Organization Id Collection Plans.Organization IdORGANIZATION_IDORGANIZATION_ID150423
Organization Name Collection Plans.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150720
Plan Id Collection Plans.Plan IdPLAN_IDPLAN_ID154295
Plan Type Code Collection Plans.Plan Type CodePLAN_TYPE_CODEPLAN_TYPE_CODE154347
Specification Assignment TypeType of specification used for validating data in this planCollection Plans.Specification Assignment TypeSPECIFICATION_ASSIGNMENT_TYPESPECIFICATION_ASSIGNMENT_TYPE162640
Start Effective DateThe date on which an account becomes active.Collection Plans.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163278
Start Effective Date - Day Collection Plans.Start Effective Date START_EFFECTIVE_DATE_DAY191145
Start Effective Date - Month Collection Plans.Start Effective Date START_EFFECTIVE_DATE_MONTH191231
Start Effective Date - Quarter Collection Plans.Start Effective Date START_EFFECTIVE_DATE_QUARTER191317
Start Effective Date - Year Collection Plans.Start Effective Date START_EFFECTIVE_DATE_YEAR191403
Collection Plan Name Collection Plans.Collection Plan NameCOLLECTION_PLAN_NAMECOLLECTION_PLAN_NAME122460
Created ByStandard Who column.Collection Plans.Created ByCREATED_BYCREATED_BY124806
Creation Date Collection Plans.Creation DateCREATION_DATECREATION_DATE126239
Creation Date - Day Collection Plans.Creation Date CREATION_DATE_DAY172469
Creation Date - Month Collection Plans.Creation Date CREATION_DATE_MONTH172923
Creation Date - Quarter Collection Plans.Creation Date CREATION_DATE_QUARTER173377
Creation Date - Year Collection Plans.Creation Date CREATION_DATE_YEAR173831
DescriptionThe accounting period description.Collection Plans.DescriptionDESCRIPTIONDESCRIPTION129642
End Effective DateThe date after which an account becomes inactive.Collection Plans.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133121
End Effective Date - Day Collection Plans.End Effective Date END_EFFECTIVE_DATE_DAY178621
End Effective Date - Month Collection Plans.End Effective Date END_EFFECTIVE_DATE_MONTH178717
End Effective Date - Quarter Collection Plans.End Effective Date END_EFFECTIVE_DATE_QUARTER178813
End Effective Date - Year Collection Plans.End Effective Date END_EFFECTIVE_DATE_YEAR178909
Last Update Date Collection Plans.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140761
Last Update Date - Day Collection Plans.Last Update Date LAST_UPDATE_DATE_DAY183846
Last Update Date - Month Collection Plans.Last Update Date LAST_UPDATE_DATE_MONTH184274
Last Update Date - Quarter Collection Plans.Last Update Date LAST_UPDATE_DATE_QUARTER184702
Last Update Date - Year Collection Plans.Last Update Date LAST_UPDATE_DATE_YEAR185130
Last Updated By Collection Plans.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139401
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Collection Plans.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150157
Organization Id Collection Plans.Organization IdORGANIZATION_IDORGANIZATION_ID150423
Organization Name Collection Plans.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150720
Plan Id Collection Plans.Plan IdPLAN_IDPLAN_ID154295
Plan Type Code Collection Plans.Plan Type CodePLAN_TYPE_CODEPLAN_TYPE_CODE154347
Specification Assignment TypeType of specification used for validating data in this planCollection Plans.Specification Assignment TypeSPECIFICATION_ASSIGNMENT_TYPESPECIFICATION_ASSIGNMENT_TYPE162640
Start Effective DateThe date on which an account becomes active.Collection Plans.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163278
Start Effective Date - Day Collection Plans.Start Effective Date START_EFFECTIVE_DATE_DAY191145
Start Effective Date - Month Collection Plans.Start Effective Date START_EFFECTIVE_DATE_MONTH191231
Start Effective Date - Quarter Collection Plans.Start Effective Date START_EFFECTIVE_DATE_QUARTER191317
Start Effective Date - Year Collection Plans.Start Effective Date START_EFFECTIVE_DATE_YEAR191403
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Collection Plans -> Collection Plan Element Action TriggersCollection Plans.Plan Id = Collection Plan Element Action Triggers.Collection Plan IdAlways exist in master folderNoneNo
Collection Plans -> Collection Plan ElementsCollection Plans.Plan Id = Collection Plan Elements.Collection Plan IdAlways exist in master folderNoneNo
Collection Plans -> Collection Plan Transaction TypesCollection Plans.Plan Id = Collection Plan Transaction Types.Collection Plan IdAlways exist in master folderNoneNo