Powered by InfoCaptor


Previous Page   Next Page

Current Inventory
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.PMIFG_CURRENTINVENTORY_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Capacity UOMUnit of measure in which capacity is expressed.Current Inventory.Capacity UOMCAPACITY_UOMCAPACITY_UOM121550
Company CodeCompany code of the organization.Current Inventory.Company CodeCO_CODECO_CODE123976
Created By Current Inventory.Created ByCREATED_BYCREATED_BY125187
Creation Date Current Inventory.Creation DateCREATION_DATECREATION_DATE126614
Item DescriptionShort description of the item that is displayed during the item look up.Current Inventory.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137738
Item IDSurrogate key for the item for which results are recorded.Current Inventory.Item IDITEM_IDITEM_ID137776
Item NumberName of the item.Current Inventory.Item NumberITEM_NUMBERITEM_NUMBER137845
Item Secondary UOMSecond UOM for in which inventory balances are maintained, for dual UOM items.Current Inventory.Item Secondary UOMITEM_UOM2ITEM_UOM2137946
Item UOMUom of the item by which the inventory balances are maintained.Current Inventory.Item UOMITEM_UOMITEM_UOM137932
Last Update Date Current Inventory.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE141141
Last Updated By Current Inventory.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139767
LocationA shorthand way to refer to a customer address.Current Inventory.LocationLOCATIONLOCATION145011
Location CapacityCapacity of the location.Current Inventory.Location CapacityLOCATION_CAPACITYLOCATION_CAPACITY145028
Location DescriptionDescription of the location.Current Inventory.Location DescriptionLOCATION_DESCRIPTIONLOCATION_DESCRIPTION145043
Lot Creation Date Current Inventory.Lot Creation DateLOT_CREATION_DATELOT_CREATION_DATE145853
Lot Expire DateLot expiration date.Current Inventory.Lot Expire DateLOT_EXPIRE_DATELOT_EXPIRE_DATE145862
Lot IDSurrogate key for the lot or sublot for which results are recorded.Current Inventory.Lot IDLOT_IDLOT_ID145866
Lot NumberCode for the lot.Current Inventory.Lot NumberLOT_NUMBERLOT_NUMBER145906
Lot StatusStatus of the lot.Current Inventory.Lot StatusLOT_STATUSLOT_STATUS145919
Lot Status DescriptionDescription of status.Current Inventory.Lot Status DescriptionLOT_STATUS_DESCLOT_STATUS_DESC145926
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Current Inventory.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150187
Qantity Onhand in Secondary UOMCurrent onhand quantity of the item, lot ,sublot in the warehouse and (or) location, expressed in the secondary unit of measure for the item, for dual UOM items.Current Inventory.Qantity Onhand in Secondary UOMQTY_ONHAND_IN_UOM2QTY_ONHAND_IN_UOM2157182
Quality Control Gradegrade of the lot.Current Inventory.Quality Control GradeQC_GRADEQC_GRADE157148
Quality Control Hold Reason CodeReason code associated with the lot status.Current Inventory.Quality Control Hold Reason CodeQC_HOLD_REASON_CODEQC_HOLD_REASON_CODE157160
Quality Control Hold Reason DesciptionDescription of the Quality Control hold reason.Current Inventory.Quality Control Hold Reason DesciptionQCHOLD_REASON_DESCQCHOLD_REASON_DESC157144
Quantity OnhandPeriod ending balance of item / lot in Primary UOM of an item.Current Inventory.Quantity OnhandQTY_ONHANDQTY_ONHAND157179
Sublot NumberCode for the sublot.Current Inventory.Sublot NumberSUBLOT_NUMBERSUBLOT_NUMBER163827
Vendor Lot Number Current Inventory.Vendor Lot NumberVENDOR_LOT_NUMBERVENDOR_LOT_NUMBER167445
Warehouse CodeWarehouse which contains the item balances.Current Inventory.Warehouse CodeWAREHOUSE_CODEWAREHOUSE_CODE167690
Warehouse NameName of the warehouse.Current Inventory.Warehouse NameWAREHOUSE_NAMEWAREHOUSE_NAME167707
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto