Powered by InfoCaptor


Previous Page   Next Page

Lots
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_LOTSUnknown
NoneNone.INVFG_LOTSUnknown
NoneNone.INVFG_LOTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Created ByStandard Who column.Lots.Created ByCREATED_BYCREATED_BY124785
Creation Date Lots.Creation DateCREATION_DATECREATION_DATE126218
Creation Date - Day Lots.Creation Date CREATION_DATE_DAY172427
Creation Date - Month Lots.Creation Date CREATION_DATE_MONTH172881
Creation Date - Quarter Lots.Creation Date CREATION_DATE_QUARTER173335
Creation Date - Year Lots.Creation Date CREATION_DATE_YEAR173789
Expiration DateThe date on which the agreement expires.Lots.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134091
Expiration Date - Day Lots.Expiration Date EXPIRATION_DATE_DAY179307
Expiration Date - Month Lots.Expiration Date EXPIRATION_DATE_MONTH179325
Expiration Date - Quarter Lots.Expiration Date EXPIRATION_DATE_QUARTER179343
Expiration Date - Year Lots.Expiration Date EXPIRATION_DATE_YEAR179361
Inactive Flag Lots.Inactive FlagINACTIVE_FLAGINACTIVE_FLAG273690
Inventory Item IdInventory item identifierLots.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137261
Inventory Item Name Lots.Inventory Item NameINVENTORY_ITEM_NAMEINVENTORY_ITEM_NAME273688
Item Lots.ItemITEMITEM273689
Last Update Date Lots.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140740
Last Update Date - Day Lots.Last Update Date LAST_UPDATE_DATE_DAY183804
Last Update Date - Month Lots.Last Update Date LAST_UPDATE_DATE_MONTH184232
Last Update Date - Quarter Lots.Last Update Date LAST_UPDATE_DATE_QUARTER184660
Last Update Date - Year Lots.Last Update Date LAST_UPDATE_DATE_YEAR185088
Last Updated By Lots.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139380
Lot NumberCode for the lot.Lots.Lot NumberLOT_NUMBERLOT_NUMBER145896
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Lots.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150147
Organization Id Lots.Organization IdORGANIZATION_IDORGANIZATION_ID150409
Organization Name Lots.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150707
Created ByStandard Who column.Lots.Created ByCREATED_BYCREATED_BY124785
Creation Date Lots.Creation DateCREATION_DATECREATION_DATE126218
Creation Date - Day Lots.Creation Date CREATION_DATE_DAY172427
Creation Date - Month Lots.Creation Date CREATION_DATE_MONTH172881
Creation Date - Quarter Lots.Creation Date CREATION_DATE_QUARTER173335
Creation Date - Year Lots.Creation Date CREATION_DATE_YEAR173789
Expiration DateThe date on which the agreement expires.Lots.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134091
Expiration Date - Day Lots.Expiration Date EXPIRATION_DATE_DAY179307
Expiration Date - Month Lots.Expiration Date EXPIRATION_DATE_MONTH179325
Expiration Date - Quarter Lots.Expiration Date EXPIRATION_DATE_QUARTER179343
Expiration Date - Year Lots.Expiration Date EXPIRATION_DATE_YEAR179361
Inactive Flag Lots.Inactive FlagINACTIVE_FLAGINACTIVE_FLAG273690
Inventory Item IdInventory item identifierLots.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137261
Inventory Item Name Lots.Inventory Item NameINVENTORY_ITEM_NAMEINVENTORY_ITEM_NAME273688
Item Lots.ItemITEMITEM273689
Last Update Date Lots.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140740
Last Update Date - Day Lots.Last Update Date LAST_UPDATE_DATE_DAY183804
Last Update Date - Month Lots.Last Update Date LAST_UPDATE_DATE_MONTH184232
Last Update Date - Quarter Lots.Last Update Date LAST_UPDATE_DATE_QUARTER184660
Last Update Date - Year Lots.Last Update Date LAST_UPDATE_DATE_YEAR185088
Last Updated By Lots.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139380
Lot NumberCode for the lot.Lots.Lot NumberLOT_NUMBERLOT_NUMBER145896
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Lots.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150147
Organization Id Lots.Organization IdORGANIZATION_IDORGANIZATION_ID150409
Organization Name Lots.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150707
Created ByStandard Who column.Lots.Created ByCREATED_BYCREATED_BY124785
Creation Date Lots.Creation DateCREATION_DATECREATION_DATE126218
Creation Date - Day Lots.Creation Date CREATION_DATE_DAY172427
Creation Date - Month Lots.Creation Date CREATION_DATE_MONTH172881
Creation Date - Quarter Lots.Creation Date CREATION_DATE_QUARTER173335
Creation Date - Year Lots.Creation Date CREATION_DATE_YEAR173789
Expiration DateThe date on which the agreement expires.Lots.Expiration DateEXPIRATION_DATEEXPIRATION_DATE134091
Expiration Date - Day Lots.Expiration Date EXPIRATION_DATE_DAY179307
Expiration Date - Month Lots.Expiration Date EXPIRATION_DATE_MONTH179325
Expiration Date - Quarter Lots.Expiration Date EXPIRATION_DATE_QUARTER179343
Expiration Date - Year Lots.Expiration Date EXPIRATION_DATE_YEAR179361
Inactive Flag Lots.Inactive FlagINACTIVE_FLAGINACTIVE_FLAG273690
Inventory Item IdInventory item identifierLots.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137261
Inventory Item Name Lots.Inventory Item NameINVENTORY_ITEM_NAMEINVENTORY_ITEM_NAME273688
Item Lots.ItemITEMITEM273689
Last Update Date Lots.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140740
Last Update Date - Day Lots.Last Update Date LAST_UPDATE_DATE_DAY183804
Last Update Date - Month Lots.Last Update Date LAST_UPDATE_DATE_MONTH184232
Last Update Date - Quarter Lots.Last Update Date LAST_UPDATE_DATE_QUARTER184660
Last Update Date - Year Lots.Last Update Date LAST_UPDATE_DATE_YEAR185088
Last Updated By Lots.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139380
Lot NumberCode for the lot.Lots.Lot NumberLOT_NUMBERLOT_NUMBER145896
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Lots.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150147
Organization Id Lots.Organization IdORGANIZATION_IDORGANIZATION_ID150409
Organization Name Lots.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150707
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Lots -> Inventory DemandsLots.Inventory Item Id = Inventory Demands.Inventory Item Id Lots.Organization Id = Inventory Demands.Organization Id Lots.Lot Number = Inventory Demands.Lot NumberMight not exist in master folderOuter join on master No
Lots -> Inventory ReservationsLots.Inventory Item Id = Inventory Reservations.Inventory Item Id Lots.Organization Id = Inventory Reservations.Organization Id Lots.Lot Number = Inventory Reservations.Lot NumberMight not exist in master folderOuter join on master No
Lots -> Onhand BalancesLots.Inventory Item Id = Onhand Balances.Inventory Item Id Lots.Organization Id = Onhand Balances.Organization Id Lots.Lot Number = Onhand Balances.Lot NumberAlways exist in master folderNoneNo
Lots -> Physical AdjustmentsLots.Inventory Item Id = Physical Adjustments.Inventory Item Id Lots.Organization Id = Physical Adjustments.Organization Id Lots.Lot Number = Physical Adjustments.Lot NumberMight not exist in master folderOuter join on master No
Lots -> Serial NumbersLots.Inventory Item Id = Serial Numbers.Inventory Item Id Lots.Organization Id = Serial Numbers.Organization Id Lots.Lot Number = Serial Numbers.Lot NumberMight not exist in master folderOuter join on master No