Powered by InfoCaptor


Previous Page   Next Page

Customer Items
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_CUSTOMER_ITEMSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Active Flag Customer Items.Active FlagACTIVE_FLAGACTIVE_FLAG265882
Address Category Customer Items.Address CategoryADDRESS_CATEGORYADDRESS_CATEGORY115045
Address IdAddress identifierCustomer Items.Address IdADDRESS_IDADDRESS_ID115048
Address Line 1First line of customer's addressCustomer Items.Address Line 1ADDRESS1ADDRESS1115010
Address Line 2Second line of customer's addressCustomer Items.Address Line 2ADDRESS2ADDRESS2115020
Address Line 3Third line of customer's addressCustomer Items.Address Line 3ADDRESS3ADDRESS3115030
Address Line 4Fourth line of customer's addressCustomer Items.Address Line 4ADDRESS4ADDRESS4115040
City Customer Items.CityCITYCITY122034
Commodity CodeCustomer item commodity codeCustomer Items.Commodity CodeCOMMODITY_CODECOMMODITY_CODE122675
Commodity Code IdCustomer item commodity code identifierCustomer Items.Commodity Code IdCOMMODITY_CODE_IDCOMMODITY_CODE_ID122680
Container Item Org IdItem master organization identifier for the master and detail container itemsCustomer Items.Container Item Org IdCONTAINER_ITEM_ORG_IDCONTAINER_ITEM_ORG_ID123249
Container Organization CodeItem master organization code for the master and detail container itemsCustomer Items.Container Organization CodeCONTAINER_ORGANIZATION_CODECONTAINER_ORGANIZATION_CODE123256
Container Organization NameItem master organization name for the master and detail container itemsCustomer Items.Container Organization NameCONTAINER_ORGANIZATION_NAMECONTAINER_ORGANIZATION_NAME123257
Country Customer Items.CountryCOUNTRYCOUNTRY123813
County Customer Items.CountyCOUNTYCOUNTY123883
Created By Customer Items.Created ByCREATED_BYCREATED_BY124334
Created Date Customer Items.Created DateCREATED_DATECREATED_DATE125347
Created Date - Day Customer Items.Created Date CREATED_DATE_DAY171141
Created Date - Month Customer Items.Created Date CREATED_DATE_MONTH171295
Created Date - Quarter Customer Items.Created Date CREATED_DATE_QUARTER171449
Created Date - Year Customer Items.Created Date CREATED_DATE_YEAR171603
Customer Category CodeAddress category codeCustomer Items.Customer Category CodeCUSTOMER_CATEGORY_CODECUSTOMER_CATEGORY_CODE127554
Customer IdUnique identifier for this customer.Customer Items.Customer IdCUSTOMER_IDCUSTOMER_ID127579
Customer Item DescriptionDescription of customer itemCustomer Items.Customer Item DescriptionCUSTOMER_ITEM_DESCRIPTIONCUSTOMER_ITEM_DESCRIPTION127639
Customer Item IdCustomer item identifierCustomer Items.Customer Item IdCUSTOMER_ITEM_IDCUSTOMER_ITEM_ID127640
Customer Item NameCustomer's part numberCustomer Items.Customer Item NameCUSTOMER_ITEM_NAMECUSTOMER_ITEM_NAME127643
Customer Name Customer Items.Customer NameCUSTOMER_NAMECUSTOMER_NAME127655
Definition Level Customer Items.Definition LevelDEFINITION_LEVELDEFINITION_LEVEL265875
Departure Plan Rqd Flag Customer Items.Departure Plan Rqd FlagDEPARTURE_PLAN_RQD_FLAGDEPARTURE_PLAN_RQD_FLAG265880
Detail Container Item Customer Items.Detail Container ItemDETAIL_CONTAINER_ITEMDETAIL_CONTAINER_ITEM265878
Detail Container Item IdDetail container item identifierCustomer Items.Detail Container Item IdDETAIL_CONTAINER_ITEM_IDDETAIL_CONTAINER_ITEM_ID129927
Item Customer Items.ItemITEMITEM265877
Item 1 Customer Items.Item 1ITEM_1ITEM_1265879
Last Updated By Customer Items.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY138958
Last Updated Date Customer Items.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139924
Last Updated Date - Day Customer Items.Last Updated Date LAST_UPDATED_DATE_DAY182814
Last Updated Date - Month Customer Items.Last Updated Date LAST_UPDATED_DATE_MONTH182976
Last Updated Date - Quarter Customer Items.Last Updated Date LAST_UPDATED_DATE_QUARTER183138
Last Updated Date - Year Customer Items.Last Updated Date LAST_UPDATED_DATE_YEAR183300
Master Container Item Customer Items.Master Container ItemMASTER_CONTAINER_ITEMMASTER_CONTAINER_ITEM265876
Master Container Item IdMaster container item identifierCustomer Items.Master Container Item IdMASTER_CONTAINER_ITEM_IDMASTER_CONTAINER_ITEM_ID146247
Minimum Fill PercentMinimum fill percentage at which this container type should beCustomer Items.Minimum Fill PercentMINIMUM_FILL_PERCENTMINIMUM_FILL_PERCENT147139
Model Customer Item IdDefault parent model customer item identifierCustomer Items.Model Customer Item IdMODEL_CUSTOMER_ITEM_IDMODEL_CUSTOMER_ITEM_ID147349
Model Customer Item NameName of the default parent model customer itemCustomer Items.Model Customer Item NameMODEL_CUSTOMER_ITEM_NAMEMODEL_CUSTOMER_ITEM_NAME147350
Negative Tolerance PercentNegative tolerance (low end) for Customer Item demandCustomer Items.Negative Tolerance PercentNEGATIVE_TOLERANCE_PERCENTNEGATIVE_TOLERANCE_PERCENT147885
Plan Before Build Flag Customer Items.Plan Before Build FlagPLAN_BEFORE_BUILD_FLAGPLAN_BEFORE_BUILD_FLAG265881
Positive Tolerance PercentPositive tolerance (high end) for Customer Item demandCustomer Items.Positive Tolerance PercentPOSITIVE_TOLERANCE_PERCENTPOSITIVE_TOLERANCE_PERCENT154921
Postal CodePostal code of customer's addressCustomer Items.Postal CodePOSTAL_CODEPOSTAL_CODE154926
ProvinceProvince of customer's addressCustomer Items.ProvincePROVINCEPROVINCE156808
State Customer Items.StateSTATESTATE163356
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Customer Items -> Customer Item Cross ReferencesCustomer Items.Customer Item Id = Customer Item Cross References.Customer Item IdAlways exist in master folderNoneNo