Powered by InfoCaptor


Previous Page   Next Page

Inventory Locators
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_INVENTORY_LOCATORSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bin Inventory Locators.BinBINBIN273593
Created By Standard who columnInventory Locators.Created ByCREATED_BYCREATED_BY124776
Creation Date Standard who columnInventory Locators.Creation DateCREATION_DATECREATION_DATE126209
Creation Date DayDay in MonthInventory Locators.Creation Date CREATION_DATE_DAY172409
Creation Date MonthMonth in YearInventory Locators.Creation Date CREATION_DATE_MONTH172863
Creation Date QuarterQuarter in YearInventory Locators.Creation Date CREATION_DATE_QUARTER173317
Creation Date YearYearInventory Locators.Creation Date CREATION_DATE_YEAR173771
Description Locator descriptionInventory Locators.DescriptionDESCRIPTIONDESCRIPTION129633
Inactive Date Date after which locator becomes inactiveInventory Locators.Inactive DateINACTIVE_DATEINACTIVE_DATE136201
Inactive Date DayDay in MonthInventory Locators.Inactive Date INACTIVE_DATE_DAY181185
Inactive Date MonthMonth in YearInventory Locators.Inactive Date INACTIVE_DATE_MONTH181255
Inactive Date QuarterQuarter in YearInventory Locators.Inactive Date INACTIVE_DATE_QUARTER181325
Inactive Date YearYearInventory Locators.Inactive Date INACTIVE_DATE_YEAR181395
Inventory Location Name Inventory Locators.Inventory Location NameINVENTORY_LOCATION_NAMEINVENTORY_LOCATION_NAME273590
Inventory Locator Id Inventory locator identifierInventory Locators.Inventory Locator IdINVENTORY_LOCATOR_IDINVENTORY_LOCATOR_ID137310
Last Update Date Standard who columnInventory Locators.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140731
Last Update Date DayDay in MonthInventory Locators.Last Update Date LAST_UPDATE_DATE_DAY183786
Last Update Date MonthMonth in YearInventory Locators.Last Update Date LAST_UPDATE_DATE_MONTH184214
Last Update Date QuarterQuarter in YearInventory Locators.Last Update Date LAST_UPDATE_DATE_QUARTER184642
Last Update Date YearYearInventory Locators.Last Update Date LAST_UPDATE_DATE_YEAR185070
Last Updated By Standard who columnInventory Locators.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139371
Location Inventory Locators.LocationLOCATIONLOCATION273594
Maximum Capacity Maximum number of units that can be put in the locatorInventory Locators.Maximum CapacityMAXIMUM_CAPACITYMAXIMUM_CAPACITY146413
Maximum Volume Locator maximum cubic areaInventory Locators.Maximum VolumeMAXIMUM_VOLUMEMAXIMUM_VOLUME146444
Maximum Weight Locator maximum weightInventory Locators.Maximum WeightMAXIMUM_WEIGHTMAXIMUM_WEIGHT146445
Organization Code Organization codeInventory Locators.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150139
Organization Id Organization identifierInventory Locators.Organization IdORGANIZATION_IDORGANIZATION_ID150399
Organization Name Organization nameInventory Locators.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150698
Pallet Position Inventory Locators.Pallet PositionPALLET_POSITIONPALLET_POSITION273592
Picking Order Picking orderInventory Locators.Picking OrderPICKING_ORDERPICKING_ORDER154063
Row Inventory Locators.RowROWROW273591
Subinventory Name Subinventory to which locator belongsInventory Locators.Subinventory NameSUBINVENTORY_NAMESUBINVENTORY_NAME163772
Volume Uom Code Locator volume unit of measureInventory Locators.Volume Uom CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167564
Weight Uom Code Locator weight unit of measureInventory Locators.Weight Uom CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167755
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Inventory Locators -> Cycle Count AdjustmentsInventory Locators.Organization Id = Cycle Count Adjustments.Organization Id Inventory Locators.Inventory Locator Id = Cycle Count Adjustments.Locator IdAlways exist in master folderNoneNo
Inventory Locators -> Flow SchedulesInventory Locators.Organization Id = Flow Schedules.Organization Id Inventory Locators.Inventory Locator Id = Flow Schedules.Completion Locatior IdMight not exist in master folderOuter join on master No
Inventory Locators -> Inventory DemandsInventory Locators.Organization Id = Inventory Demands.Organization Id Inventory Locators.Inventory Locator Id = Inventory Demands.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Inventory ReservationsInventory Locators.Organization Id = Inventory Reservations.Organization Id Inventory Locators.Inventory Locator Id = Inventory Reservations.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Inventory SuppliesInventory Locators.Organization Id = Inventory Supplies.To Organization Id Inventory Locators.Inventory Locator Id = Inventory Supplies.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Kanban Card ActivitiesInventory Locators.Organization Id = Kanban Card Activities.Organization Id Inventory Locators.Inventory Locator Id = Kanban Card Activities.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Kanban Card Activities 1Inventory Locators.Organization Id = Kanban Card Activities.Source Organization Id Inventory Locators.Inventory Locator Id = Kanban Card Activities.Source Inventory Locator IdAlways exist in master folderNoneNo
Inventory Locators -> Kanban CardsInventory Locators.Organization Id = Kanban Cards.Organization Id Inventory Locators.Inventory Locator Id = Kanban Cards.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Kanban Cards 1Inventory Locators.Organization Id = Kanban Cards.Source Organization Id Inventory Locators.Inventory Locator Id = Kanban Cards.Source Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Kanban Location ItemsInventory Locators.Organization Id = Kanban Location Items.Organization Id Inventory Locators.Inventory Locator Id = Kanban Location Items.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Kanban Location Items 1Inventory Locators.Organization Id = Kanban Location Items.Source Organization Id Inventory Locators.Inventory Locator Id = Kanban Location Items.Source Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Material TransactionsInventory Locators.Organization Id = Material Transactions.Organization Id Inventory Locators.Inventory Locator Id = Material Transactions.Inventory Locator IdAlways exist in master folderNoneNo
Inventory Locators -> Move Order LinesInventory Locators.Inventory Locator Id = Move Order Lines.From Locator Id Inventory Locators.Organization Id = Move Order Lines.Organization IdMight not exist in master folderOuter join on master No
Inventory Locators -> Move Order Lines 1Inventory Locators.Inventory Locator Id = Move Order Lines.To Locator Id Inventory Locators.Organization Id = Move Order Lines.Organization IdMight not exist in master folderOuter join on master No
Inventory Locators -> Onhand BalancesInventory Locators.Organization Id = Onhand Balances.Organization Id Inventory Locators.Inventory Locator Id = Onhand Balances.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Organization ItemsInventory Locators.Inventory Locator Id = Organization Items.WIP Supply Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Physical Inventory CountsInventory Locators.Organization Id = Physical Inventory Counts.Organization Id Inventory Locators.Inventory Locator Id = Physical Inventory Counts.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Serial Number TransactionsInventory Locators.Organization Id = Serial Number Transactions.Organization Id Inventory Locators.Inventory Locator Id = Serial Number Transactions.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> Serial NumbersInventory Locators.Organization Id = Serial Numbers.Organization Id Inventory Locators.Inventory Locator Id = Serial Numbers.Inventory Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> WIP ComponentsInventory Locators.Organization Id = WIP Components.Organization Id Inventory Locators.Inventory Locator Id = WIP Components.Supply Locator IdMight not exist in master folderOuter join on master No
Inventory Locators -> WIP Repetitive ItemsInventory Locators.Organization Id = WIP Repetitive Items.Organization Id Inventory Locators.Inventory Locator Id = WIP Repetitive Items.Completion Locator IdMight not exist in master folderOuter join on master No