Powered by InfoCaptor


Previous Page   Next Page

Inventory Supplies
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.INVFG_INVENTORY_SUPPLIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Bin Inventory Supplies.BinBINBIN273642
Created ByStandard Who column.Inventory Supplies.Created ByCREATED_BYCREATED_BY124779
Creation Date Inventory Supplies.Creation DateCREATION_DATECREATION_DATE126212
Creation Date - Day Inventory Supplies.Creation Date CREATION_DATE_DAY172415
Creation Date - Month Inventory Supplies.Creation Date CREATION_DATE_MONTH172869
Creation Date - Quarter Inventory Supplies.Creation Date CREATION_DATE_QUARTER173323
Creation Date - Year Inventory Supplies.Creation Date CREATION_DATE_YEAR173777
Destination Type Inventory Supplies.Destination TypeDESTINATION_TYPEDESTINATION_TYPE273638
Expected Delivery Date Inventory Supplies.Expected Delivery DateEXPECTED_DELIVERY_DATEEXPECTED_DELIVERY_DATE133965
Expected Delivery Date - Day Inventory Supplies.Expected Delivery Date EXPECTED_DELIVERY_DATE_DAY179153
Expected Delivery Date - Month Inventory Supplies.Expected Delivery Date EXPECTED_DELIVERY_DATE_MONTH179155
Expected Delivery Date - Quarter Inventory Supplies.Expected Delivery Date EXPECTED_DELIVERY_DATE_QUARTER179157
Expected Delivery Date - Year Inventory Supplies.Expected Delivery Date EXPECTED_DELIVERY_DATE_YEAR179159
From Organization CodeSource Organization CodeInventory Supplies.From Organization CodeFROM_ORGANIZATION_CODEFROM_ORGANIZATION_CODE134763
From Organization IdSource Organization IdentfierInventory Supplies.From Organization IdFROM_ORGANIZATION_IDFROM_ORGANIZATION_ID134768
From Organization NameSource Organization NameInventory Supplies.From Organization NameFROM_ORGANIZATION_NAMEFROM_ORGANIZATION_NAME134774
From Subinventory NameSource Subinventory NameInventory Supplies.From Subinventory NameFROM_SUBINVENTORY_NAMEFROM_SUBINVENTORY_NAME134790
Intransit Owning Org Code Inventory Supplies.Intransit Owning Org CodeINTRANSIT_OWNING_ORG_CODEINTRANSIT_OWNING_ORG_CODE137135
Intransit Owning Org IdIntransit Owning Org IdentifierInventory Supplies.Intransit Owning Org IdINTRANSIT_OWNING_ORG_IDINTRANSIT_OWNING_ORG_ID137136
Intransit Owning Org Name Inventory Supplies.Intransit Owning Org NameINTRANSIT_OWNING_ORG_NAMEINTRANSIT_OWNING_ORG_NAME137137
Inventory Item IdInventory Item IdentifierInventory Supplies.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137253
Inventory Item Name Inventory Supplies.Inventory Item NameINVENTORY_ITEM_NAMEINVENTORY_ITEM_NAME273636
Inventory Location Name Inventory Supplies.Inventory Location NameINVENTORY_LOCATION_NAMEINVENTORY_LOCATION_NAME273639
Inventory Locator IdInventory Locator IdentifierInventory Supplies.Inventory Locator IdINVENTORY_LOCATOR_IDINVENTORY_LOCATOR_ID137312
Item Inventory Supplies.ItemITEMITEM273637
Last Update Date Inventory Supplies.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140734
Last Update Date - Day Inventory Supplies.Last Update Date LAST_UPDATE_DATE_DAY183792
Last Update Date - Month Inventory Supplies.Last Update Date LAST_UPDATE_DATE_MONTH184220
Last Update Date - Quarter Inventory Supplies.Last Update Date LAST_UPDATE_DATE_QUARTER184648
Last Update Date - Year Inventory Supplies.Last Update Date LAST_UPDATE_DATE_YEAR185076
Last Updated By Inventory Supplies.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139374
Need By Date Inventory Supplies.Need By DateNEED_BY_DATENEED_BY_DATE147861
Need By Date - Day Inventory Supplies.Need By Date NEED_BY_DATE_DAY186418
Need By Date - Month Inventory Supplies.Need By Date NEED_BY_DATE_MONTH186436
Need By Date - Quarter Inventory Supplies.Need By Date NEED_BY_DATE_QUARTER186454
Need By Date - Year Inventory Supplies.Need By Date NEED_BY_DATE_YEAR186472
PO Distribution IdPo Distribution IdentifierInventory Supplies.PO Distribution IdPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155012
PO Distribution Number Inventory Supplies.PO Distribution NumberPO_DISTRIBUTION_NUMBERPO_DISTRIBUTION_NUMBER155021
PO Header IdPo Header IdentifierInventory Supplies.PO Header IdPO_HEADER_IDPO_HEADER_ID155030
PO Line IdPO Line IdentifierInventory Supplies.PO Line IdPO_LINE_IDPO_LINE_ID155041
PO Line Location IdPo Line Location IdentifierInventory Supplies.PO Line Location IdPO_LINE_LOCATION_IDPO_LINE_LOCATION_ID155068
PO Line Number Inventory Supplies.PO Line NumberPO_LINE_NUMBERPO_LINE_NUMBER155072
PO Number Inventory Supplies.PO NumberPO_NUMBERPO_NUMBER155083
PO Release IdPo Release IdentifierInventory Supplies.PO Release IdPO_RELEASE_IDPO_RELEASE_ID155090
PO Release Number Inventory Supplies.PO Release NumberPO_RELEASE_NUMBERPO_RELEASE_NUMBER155093
PO Shipment Number Inventory Supplies.PO Shipment NumberPO_SHIPMENT_NUMBERPO_SHIPMENT_NUMBER155110
Pallet Position Inventory Supplies.Pallet PositionPALLET_POSITIONPALLET_POSITION273641
Quantity Inventory Supplies.QuantityQUANTITYQUANTITY157277
Receipt Date Inventory Supplies.Receipt DateRECEIPT_DATERECEIPT_DATE157981
Receipt Date - Day Inventory Supplies.Receipt Date RECEIPT_DATE_DAY189407
Receipt Date - Month Inventory Supplies.Receipt Date RECEIPT_DATE_MONTH189413
Receipt Date - Quarter Inventory Supplies.Receipt Date RECEIPT_DATE_QUARTER189419
Receipt Date - Year Inventory Supplies.Receipt Date RECEIPT_DATE_YEAR189425
Receiving Shipment Header IdRcv Shipment Header IdentifierInventory Supplies.Receiving Shipment Header IdRCV_SHIPMENT_HEADER_IDRCV_SHIPMENT_HEADER_ID157748
Receiving Shipment NumberRcv Shipment NumberInventory Supplies.Receiving Shipment NumberRCV_SHIPMENT_NUMBERRCV_SHIPMENT_NUMBER157751
Receiving Shipment Line IdRcv Shipment Line IdentifierInventory Supplies.Receiving Shipment Line IdRCV_SHIPMENT_LINE_IDRCV_SHIPMENT_LINE_ID157749
Receiving Shipment Line NumberRcv Shipment Line NumberInventory Supplies.Receiving Shipment Line NumberRCV_SHIPMENT_LINE_NUMBERRCV_SHIPMENT_LINE_NUMBER157750
Receiving Transaction IdRcv Transaction IdentifierInventory Supplies.Receiving Transaction IdRCV_TRANSACTION_IDRCV_TRANSACTION_ID157754
Requisition Header IdRequisition Header IdentifierInventory Supplies.Requisition Header IdREQUISITION_HEADER_IDREQUISITION_HEADER_ID158827
Requisition Line IdRequisition Line IdentifierInventory Supplies.Requisition Line IdREQUISITION_LINE_IDREQUISITION_LINE_ID158841
Requisition Line Number Inventory Supplies.Requisition Line NumberREQUISITION_LINE_NUMBERREQUISITION_LINE_NUMBER158847
Requisition Number Inventory Supplies.Requisition NumberREQUISITION_NUMBERREQUISITION_NUMBER158853
Revision Inventory Supplies.RevisionREVISIONREVISION159520
Row Inventory Supplies.RowROWROW273640
Supply Source IdSupply Source IdentifierInventory Supplies.Supply Source IdSUPPLY_SOURCE_IDSUPPLY_SOURCE_ID164351
Supply Type Code Inventory Supplies.Supply Type CodeSUPPLY_TYPE_CODESUPPLY_TYPE_CODE164357
To Org Primary QuantityDestination Org Primary QuantityInventory Supplies.To Org Primary QuantityTO_ORG_PRIMARY_QUANTITYTO_ORG_PRIMARY_QUANTITY165486
To Org Primary UOMDestination Org Primary UomInventory Supplies.To Org Primary UOMTO_ORG_PRIMARY_UOMTO_ORG_PRIMARY_UOM165487
To Organization CodeDestination Organization CodeInventory Supplies.To Organization CodeTO_ORGANIZATION_CODETO_ORGANIZATION_CODE165471
To Organization IdDestination Organization IdentifierInventory Supplies.To Organization IdTO_ORGANIZATION_IDTO_ORGANIZATION_ID165476
To Organization NameDestination Organization NameInventory Supplies.To Organization NameTO_ORGANIZATION_NAMETO_ORGANIZATION_NAME165482
To Subinventory NameDestination Subinventory NameInventory Supplies.To Subinventory NameTO_SUBINVENTORY_NAMETO_SUBINVENTORY_NAME165500
Unit Of Measure Inventory Supplies.Unit Of MeasureUNIT_OF_MEASUREUNIT_OF_MEASURE166276
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Inventory Supplies -> Onhand BalancesInventory Supplies.To Organization Id = Onhand Balances.Organization Id Inventory Supplies.Inventory Item Id = Onhand Balances.Inventory Item IdMight not exist in master folderOuter join on master One to one joinNo