Powered by InfoCaptor


Previous Page   Next Page

Manufacturing Department Resources
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.BOMFG_MFG_DEPARTMENT_RESOURCESUnknown
NoneNone.BOMFG_MFG_DEPARTMENT_RESOURCESUnknown
NoneNone.BOMFG_MFG_DEPARTMENT_RESOURCESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
ATP Rule IdAvailable to promise (ATP) rule identifierManufacturing Department Resources.ATP Rule IdATP_RULE_IDATP_RULE_ID116986
Available 24 Hours Flag Manufacturing Department Resources.Available 24 Hours FlagAVAILABLE_24_HOURS_FLAGAVAILABLE_24_HOURS_FLAG265776
Capacity UnitsResource capacity unitManufacturing Department Resources.Capacity UnitsCAPACITY_UNITSCAPACITY_UNITS121548
Cost Code Type Manufacturing Department Resources.Cost Code TypeCOST_CODE_TYPECOST_CODE_TYPE123660
Created ByStandard Who column.Manufacturing Department Resources.Created ByCREATED_BYCREATED_BY124309
Created On Manufacturing Department Resources.Created OnCREATED_ONCREATED_ON125456
Created On - Day Manufacturing Department Resources.Created On CREATED_ON_DAY171785
Created On - Month Manufacturing Department Resources.Created On CREATED_ON_MONTH171861
Created On - Quarter Manufacturing Department Resources.Created On CREATED_ON_QUARTER171937
Created On - Year Manufacturing Department Resources.Created On CREATED_ON_YEAR172013
Ctp Flag Manufacturing Department Resources.Ctp FlagCTP_FLAGCTP_FLAG265778
Department Code Manufacturing Department Resources.Department CodeDEPARTMENT_CODEDEPARTMENT_CODE129142
Department IdDepartment unique identifierManufacturing Department Resources.Department IdDEPARTMENT_IDDEPARTMENT_ID129162
Exception Set Name Manufacturing Department Resources.Exception Set NameEXCEPTION_SET_NAMEEXCEPTION_SET_NAME133768
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Manufacturing Department Resources.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150037
Organization Name Manufacturing Department Resources.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150530
Resource Code Manufacturing Department Resources.Resource CodeRESOURCE_CODERESOURCE_CODE158949
Resource Group NameResource use categoryManufacturing Department Resources.Resource Group NameRESOURCE_GROUP_NAMERESOURCE_GROUP_NAME158994
Resource IdThe unique identifier of the resource.Manufacturing Department Resources.Resource IdRESOURCE_IDRESOURCE_ID159006
Rule NameName for ATP ruleManufacturing Department Resources.Rule NameRULE_NAMERULE_NAME160418
Share Capacity Flag Manufacturing Department Resources.Share Capacity FlagSHARE_CAPACITY_FLAGSHARE_CAPACITY_FLAG265777
Share From Dept IdDepartment identifier which share capacity fromManufacturing Department Resources.Share From Dept IdSHARE_FROM_DEPT_IDSHARE_FROM_DEPT_ID161651
Shared Department CodeDepartment code which share capacity fromManufacturing Department Resources.Shared Department CodeSHARED_DEPARTMENT_CODESHARED_DEPARTMENT_CODE161619
Updated By Manufacturing Department Resources.Updated ByUPDATED_BYUPDATED_BY166463
Updated On Manufacturing Department Resources.Updated OnUPDATED_ONUPDATED_ON166552
Updated On - Day Manufacturing Department Resources.Updated On UPDATED_ON_DAY192779
Updated On - Month Manufacturing Department Resources.Updated On UPDATED_ON_MONTH192855
Updated On - Quarter Manufacturing Department Resources.Updated On UPDATED_ON_QUARTER192931
Updated On - Year Manufacturing Department Resources.Updated On UPDATED_ON_YEAR193007
ATP Rule IdAvailable to promise (ATP) rule identifierManufacturing Department Resources.ATP Rule IdATP_RULE_IDATP_RULE_ID116986
Available 24 Hours Flag Manufacturing Department Resources.Available 24 Hours FlagAVAILABLE_24_HOURS_FLAGAVAILABLE_24_HOURS_FLAG265776
Capacity UnitsResource capacity unitManufacturing Department Resources.Capacity UnitsCAPACITY_UNITSCAPACITY_UNITS121548
Cost Code Type Manufacturing Department Resources.Cost Code TypeCOST_CODE_TYPECOST_CODE_TYPE123660
Created ByStandard Who column.Manufacturing Department Resources.Created ByCREATED_BYCREATED_BY124309
Created On Manufacturing Department Resources.Created OnCREATED_ONCREATED_ON125456
Created On - Day Manufacturing Department Resources.Created On CREATED_ON_DAY171785
Created On - Month Manufacturing Department Resources.Created On CREATED_ON_MONTH171861
Created On - Quarter Manufacturing Department Resources.Created On CREATED_ON_QUARTER171937
Created On - Year Manufacturing Department Resources.Created On CREATED_ON_YEAR172013
Ctp Flag Manufacturing Department Resources.Ctp FlagCTP_FLAGCTP_FLAG265778
Department Code Manufacturing Department Resources.Department CodeDEPARTMENT_CODEDEPARTMENT_CODE129142
Department IdDepartment unique identifierManufacturing Department Resources.Department IdDEPARTMENT_IDDEPARTMENT_ID129162
Exception Set Name Manufacturing Department Resources.Exception Set NameEXCEPTION_SET_NAMEEXCEPTION_SET_NAME133768
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Manufacturing Department Resources.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150037
Organization Name Manufacturing Department Resources.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150530
Resource Code Manufacturing Department Resources.Resource CodeRESOURCE_CODERESOURCE_CODE158949
Resource Group NameResource use categoryManufacturing Department Resources.Resource Group NameRESOURCE_GROUP_NAMERESOURCE_GROUP_NAME158994
Resource IdThe unique identifier of the resource.Manufacturing Department Resources.Resource IdRESOURCE_IDRESOURCE_ID159006
Rule NameName for ATP ruleManufacturing Department Resources.Rule NameRULE_NAMERULE_NAME160418
Share Capacity Flag Manufacturing Department Resources.Share Capacity FlagSHARE_CAPACITY_FLAGSHARE_CAPACITY_FLAG265777
Share From Dept IdDepartment identifier which share capacity fromManufacturing Department Resources.Share From Dept IdSHARE_FROM_DEPT_IDSHARE_FROM_DEPT_ID161651
Shared Department CodeDepartment code which share capacity fromManufacturing Department Resources.Shared Department CodeSHARED_DEPARTMENT_CODESHARED_DEPARTMENT_CODE161619
Updated By Manufacturing Department Resources.Updated ByUPDATED_BYUPDATED_BY166463
Updated On Manufacturing Department Resources.Updated OnUPDATED_ONUPDATED_ON166552
Updated On - Day Manufacturing Department Resources.Updated On UPDATED_ON_DAY192779
Updated On - Month Manufacturing Department Resources.Updated On UPDATED_ON_MONTH192855
Updated On - Quarter Manufacturing Department Resources.Updated On UPDATED_ON_QUARTER192931
Updated On - Year Manufacturing Department Resources.Updated On UPDATED_ON_YEAR193007
ATP Rule IdAvailable to promise (ATP) rule identifierManufacturing Department Resources.ATP Rule IdATP_RULE_IDATP_RULE_ID116986
Available 24 Hours Flag Manufacturing Department Resources.Available 24 Hours FlagAVAILABLE_24_HOURS_FLAGAVAILABLE_24_HOURS_FLAG265776
Capacity UnitsResource capacity unitManufacturing Department Resources.Capacity UnitsCAPACITY_UNITSCAPACITY_UNITS121548
Cost Code Type Manufacturing Department Resources.Cost Code TypeCOST_CODE_TYPECOST_CODE_TYPE123660
Created ByStandard Who column.Manufacturing Department Resources.Created ByCREATED_BYCREATED_BY124309
Created On Manufacturing Department Resources.Created OnCREATED_ONCREATED_ON125456
Created On - Day Manufacturing Department Resources.Created On CREATED_ON_DAY171785
Created On - Month Manufacturing Department Resources.Created On CREATED_ON_MONTH171861
Created On - Quarter Manufacturing Department Resources.Created On CREATED_ON_QUARTER171937
Created On - Year Manufacturing Department Resources.Created On CREATED_ON_YEAR172013
Ctp Flag Manufacturing Department Resources.Ctp FlagCTP_FLAGCTP_FLAG265778
Department Code Manufacturing Department Resources.Department CodeDEPARTMENT_CODEDEPARTMENT_CODE129142
Department IdDepartment unique identifierManufacturing Department Resources.Department IdDEPARTMENT_IDDEPARTMENT_ID129162
Exception Set Name Manufacturing Department Resources.Exception Set NameEXCEPTION_SET_NAMEEXCEPTION_SET_NAME133768
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Manufacturing Department Resources.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150037
Organization Name Manufacturing Department Resources.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150530
Resource Code Manufacturing Department Resources.Resource CodeRESOURCE_CODERESOURCE_CODE158949
Resource Group NameResource use categoryManufacturing Department Resources.Resource Group NameRESOURCE_GROUP_NAMERESOURCE_GROUP_NAME158994
Resource IdThe unique identifier of the resource.Manufacturing Department Resources.Resource IdRESOURCE_IDRESOURCE_ID159006
Rule NameName for ATP ruleManufacturing Department Resources.Rule NameRULE_NAMERULE_NAME160418
Share Capacity Flag Manufacturing Department Resources.Share Capacity FlagSHARE_CAPACITY_FLAGSHARE_CAPACITY_FLAG265777
Share From Dept IdDepartment identifier which share capacity fromManufacturing Department Resources.Share From Dept IdSHARE_FROM_DEPT_IDSHARE_FROM_DEPT_ID161651
Shared Department CodeDepartment code which share capacity fromManufacturing Department Resources.Shared Department CodeSHARED_DEPARTMENT_CODESHARED_DEPARTMENT_CODE161619
Updated By Manufacturing Department Resources.Updated ByUPDATED_BYUPDATED_BY166463
Updated On Manufacturing Department Resources.Updated OnUPDATED_ONUPDATED_ON166552
Updated On - Day Manufacturing Department Resources.Updated On UPDATED_ON_DAY192779
Updated On - Month Manufacturing Department Resources.Updated On UPDATED_ON_MONTH192855
Updated On - Quarter Manufacturing Department Resources.Updated On UPDATED_ON_QUARTER192931
Updated On - Year Manufacturing Department Resources.Updated On UPDATED_ON_YEAR193007
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Manufacturing Department Resources -> Manufacturing DepartmentsManufacturing Department Resources.Share From Dept Id = Manufacturing Departments.Department idAlways exist in master folderNoneNo
Manufacturing Department Resources -> Manufacturing Departments 1Manufacturing Department Resources.Share From Dept Id = Manufacturing Departments.Department idAlways exist in master folderOuter join on detail No
Manufacturing Department Resources -> Plan Department ResourcesManufacturing Department Resources.Department Id = Plan Department Resources.Department Id Manufacturing Department Resources.Resource Id = Plan Department Resources.Resource IdAlways exist in master folderNoneNo