Powered by InfoCaptor


Previous Page   Next Page

Item Status Codes
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_ITEM_STATUS_CODESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created By Item Status Codes.Created ByCREATED_BYCREATED_BY124348
Created Date Item Status Codes.Created DateCREATED_DATECREATED_DATE125361
Created Date - Day Item Status Codes.Created Date CREATED_DATE_DAY171169
Created Date - Month Item Status Codes.Created Date CREATED_DATE_MONTH171323
Created Date - Quarter Item Status Codes.Created Date CREATED_DATE_QUARTER171477
Created Date - Year Item Status Codes.Created Date CREATED_DATE_YEAR171631
DescriptionThe accounting period description.Item Status Codes.DescriptionDESCRIPTIONDESCRIPTION129384
End Effective DateThe date after which an account becomes inactive.Item Status Codes.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133090
End Effective Date - Day Item Status Codes.End Effective Date END_EFFECTIVE_DATE_DAY178567
End Effective Date - Month Item Status Codes.End Effective Date END_EFFECTIVE_DATE_MONTH178663
End Effective Date - Quarter Item Status Codes.End Effective Date END_EFFECTIVE_DATE_QUARTER178759
End Effective Date - Year Item Status Codes.End Effective Date END_EFFECTIVE_DATE_YEAR178855
Item Status CodeStatus codeItem Status Codes.Item Status CodeITEM_STATUS_CODEITEM_STATUS_CODE137911
Last Updated By Item Status Codes.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY138972
Last Updated Date Item Status Codes.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139938
Last Updated Date - Day Item Status Codes.Last Updated Date LAST_UPDATED_DATE_DAY182840
Last Updated Date - Month Item Status Codes.Last Updated Date LAST_UPDATED_DATE_MONTH183002
Last Updated Date - Quarter Item Status Codes.Last Updated Date LAST_UPDATED_DATE_QUARTER183164
Last Updated Date - Year Item Status Codes.Last Updated Date LAST_UPDATED_DATE_YEAR183326
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Item Status Codes -> Future Effective Item StatusesItem Status Codes.Item Status Code = Future Effective Item Statuses.Item Status CodeAlways exist in master folderNoneNo
Item Status Codes -> Item Status Attribute ValuesItem Status Codes.Item Status Code = Item Status Attribute Values.Item Status CodeAlways exist in master folderNoneNo
Item Status Codes -> Organization ItemsItem Status Codes.Item Status Code = Organization Items.Inventory Item Status CodeMight not exist in master folderOuter join on master No