Powered by InfoCaptor


Previous Page   Next Page

Inbound Shipment Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_INBOUND_SHIPMENT_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Asn Line Flag Inbound Shipment Lines.Asn Line FlagASN_LINE_FLAGASN_LINE_FLAG275895
Bar Code Label Inbound Shipment Lines.Bar Code LabelBAR_CODE_LABELBAR_CODE_LABEL119102
Category Inbound Shipment Lines.CategoryCATEGORYCATEGORY275901
Category IDUnique identifier for CategoryInbound Shipment Lines.Category IDCATEGORY_IDCATEGORY_ID121702
Charge Account IDUnique identifier for Charge AccountInbound Shipment Lines.Charge Account IDCHARGE_ACCOUNT_IDCHARGE_ACCOUNT_ID121914
Charge Account Num Inbound Shipment Lines.Charge Account NumCHARGE_ACCOUNT_NUMCHARGE_ACCOUNT_NUM275904
CommentsFree form text/comments.Inbound Shipment Lines.CommentsCOMMENTSCOMMENTS122594
Container Number Inbound Shipment Lines.Container NumberCONTAINER_NUMBERCONTAINER_NUMBER123255
Context Value Inbound Shipment Lines.Context ValueCONTEXT_VALUECONTEXT_VALUE275898
Created By Inbound Shipment Lines.Created ByCREATED_BYCREATED_BY125221
Created Date Inbound Shipment Lines.Created DateCREATED_DATECREATED_DATE125396
Created Date - Day Inbound Shipment Lines.Created Date CREATED_DATE_DAY171215
Created Date - Month Inbound Shipment Lines.Created Date CREATED_DATE_MONTH171369
Created Date - Quarter Inbound Shipment Lines.Created Date CREATED_DATE_QUARTER171523
Created Date - Year Inbound Shipment Lines.Created Date CREATED_DATE_YEAR171677
Deliver To Location Inbound Shipment Lines.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128994
Deliver To Location IDUnique identifier for Deliver To LocationInbound Shipment Lines.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129004
Deliver To Person Inbound Shipment Lines.Deliver To PersonDELIVER_TO_PERSONDELIVER_TO_PERSON129015
Deliver To Person IDUnique identifier for Deliver To PersonInbound Shipment Lines.Deliver To Person IDDELIVER_TO_PERSON_IDDELIVER_TO_PERSON_ID129023
Destination Organization Code Inbound Shipment Lines.Destination Organization CodeDESTINATION_ORGANIZATION_CODEDESTINATION_ORGANIZATION_CODE129885
Destination Organization IDUnique identifier for Destination OrganizationInbound Shipment Lines.Destination Organization IDDESTINATION_ORGANIZATION_IDDESTINATION_ORGANIZATION_ID129894
Destination Organization Name Inbound Shipment Lines.Destination Organization NameDESTINATION_ORGANIZATION_NAMEDESTINATION_ORGANIZATION_NAME129903
Destination Subinventory Inbound Shipment Lines.Destination SubinventoryDESTINATION_SUBINVENTORYDESTINATION_SUBINVENTORY129912
Destination Type Inbound Shipment Lines.Destination TypeDESTINATION_TYPEDESTINATION_TYPE275896
Drop Ship Flag Inbound Shipment Lines.Drop Ship FlagDROP_SHIP_FLAGDROP_SHIP_FLAG275910
EMEA RMA RCV Status Inbound Shipment Lines.EMEA RMA RCV StatusEMEA_RMA_RCV_STATUSEMEA_RMA_RCV_STATUS275899
Electronic Data Interchange Unit PriceElectronic Data Interchange (EDI) transaction 857 unit priceInbound Shipment Lines.Electronic Data Interchange Unit PriceEDI_UNIT_PRICEEDI_UNIT_PRICE130740
Item DescriptionShort description of the item that is displayed during the item look up.Inbound Shipment Lines.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137758
Item IDSurrogate key for the item for which results are recorded.Inbound Shipment Lines.Item IDITEM_IDITEM_ID137804
Item Number Inbound Shipment Lines.Item NumberITEM_NUMBERITEM_NUMBER275900
Item Revision Inbound Shipment Lines.Item RevisionITEM_REVISIONITEM_REVISION137899
Last Updated By Inbound Shipment Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139801
Last Updated Date Inbound Shipment Lines.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139975
Last Updated Date - Day Inbound Shipment Lines.Last Updated Date LAST_UPDATED_DATE_DAY182898
Last Updated Date - Month Inbound Shipment Lines.Last Updated Date LAST_UPDATED_DATE_MONTH183060
Last Updated Date - Quarter Inbound Shipment Lines.Last Updated Date LAST_UPDATED_DATE_QUARTER183222
Last Updated Date - Year Inbound Shipment Lines.Last Updated Date LAST_UPDATED_DATE_YEAR183384
Line NumberUser-assigned bank statement line number to uniquely identifyindividual transactions.Inbound Shipment Lines.Line NumberLINE_NUMBERLINE_NUMBER144739
Operating Unit IDUnique identifier for Operating UnitInbound Shipment Lines.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149536
Operating Unit Name Inbound Shipment Lines.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149584
Packing Slip Number Inbound Shipment Lines.Packing Slip NumberPACKING_SLIP_NUMBERPACKING_SLIP_NUMBER151795
Po Shipment Type Inbound Shipment Lines.Po Shipment TypePO_SHIPMENT_TYPEPO_SHIPMENT_TYPE275903
Primary UOM ClassPrimary Unit of measure ClassInbound Shipment Lines.Primary UOM ClassPRIMARY_UOM_CLASSPRIMARY_UOM_CLASS155600
Primary UOM DescriptionPrimary Unit of measure DescriptionInbound Shipment Lines.Primary UOM DescriptionPRIMARY_UOM_DESCRIPTIONPRIMARY_UOM_DESCRIPTION155606
Primary Unit Of Measure Inbound Shipment Lines.Primary Unit Of MeasurePRIMARY_UNIT_OF_MEASUREPRIMARY_UNIT_OF_MEASURE155590
Purchase Order Distribution IDUnique identifier for Purchase Order DistributionInbound Shipment Lines.Purchase Order Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155014
Purchase Order Distribution Number Inbound Shipment Lines.Purchase Order Distribution NumberPO_DISTRIBUTION_NUMBERPO_DISTRIBUTION_NUMBER155022
Purchase Order IDUnique identifier for Purchase OrderInbound Shipment Lines.Purchase Order IDPURCHASE_ORDER_IDPURCHASE_ORDER_ID157050
Purchase Order Line IDUnique identifier for Purchase Order LineInbound Shipment Lines.Purchase Order Line IDPO_LINE_IDPO_LINE_ID155051
Purchase Order Line Number Inbound Shipment Lines.Purchase Order Line NumberPO_LINE_NUMBERPO_LINE_NUMBER155075
Purchase Order Number Inbound Shipment Lines.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157069
Purchase Order Release IDUnique identifier for Purchase Order ReleaseInbound Shipment Lines.Purchase Order Release IDPO_RELEASE_IDPO_RELEASE_ID155091
Purchase Order Release Number Inbound Shipment Lines.Purchase Order Release NumberPO_RELEASE_NUMBERPO_RELEASE_NUMBER155095
Purchase Order Shipment IDUnique identifier for Purchase Order ShipmentInbound Shipment Lines.Purchase Order Shipment IDPO_SHIPMENT_IDPO_SHIPMENT_ID155099
Purchase Order Shipment Number Inbound Shipment Lines.Purchase Order Shipment NumberPO_SHIPMENT_NUMBERPO_SHIPMENT_NUMBER155112
Purchase Order Type Inbound Shipment Lines.Purchase Order TypePURCHASE_ORDER_TYPEPURCHASE_ORDER_TYPE275902
Qc Grade Inbound Shipment Lines.Qc GradeQC_GRADEQC_GRADE275909
Received Quantity Inbound Shipment Lines.Received QuantityRECEIVED_QUANTITYRECEIVED_QUANTITY158044
Receiving Routing IDUnique identifier for Receiving RoutingInbound Shipment Lines.Receiving Routing IDRECEIVING_ROUTING_IDRECEIVING_ROUTING_ID158079
Receiving Routing Name Inbound Shipment Lines.Receiving Routing NameRECEIVING_ROUTING_NAMERECEIVING_ROUTING_NAME158088
Requisition Distribution IDUnique identifier for Requisition DistributionInbound Shipment Lines.Requisition Distribution IDREQ_DISTRIBUTION_IDREQ_DISTRIBUTION_ID158856
Requisition Distribution Number Inbound Shipment Lines.Requisition Distribution NumberREQ_DISTRIBUTION_NUMBERREQ_DISTRIBUTION_NUMBER158859
Requisition Document Number Inbound Shipment Lines.Requisition Document NumberREQUISITION_DOCUMENT_NUMBERREQUISITION_DOCUMENT_NUMBER158820
Requisition Line IDUnique identifier for Requisition LineInbound Shipment Lines.Requisition Line IDREQUISITION_LINE_IDREQUISITION_LINE_ID158843
Requisition Line Number Inbound Shipment Lines.Requisition Line NumberREQUISITION_LINE_NUMBERREQUISITION_LINE_NUMBER158849
Sales Order Update Date Inbound Shipment Lines.Sales Order Update DateSALES_ORDER_UPDATE_DATESALES_ORDER_UPDATE_DATE275911
Secondary Quantity Received Inbound Shipment Lines.Secondary Quantity ReceivedSECONDARY_QUANTITY_RECEIVEDSECONDARY_QUANTITY_RECEIVED275907
Secondary Quantity Shipped Inbound Shipment Lines.Secondary Quantity ShippedSECONDARY_QUANTITY_SHIPPEDSECONDARY_QUANTITY_SHIPPED275906
Secondary Unit Of Measure Inbound Shipment Lines.Secondary Unit Of MeasureSECONDARY_UNIT_OF_MEASURESECONDARY_UNIT_OF_MEASURE275908
Ship To Location Inbound Shipment Lines.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161919
Ship To Location IDUnique identifier for Ship To LocationInbound Shipment Lines.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161946
Shipment IDUnique identifier for ShipmentInbound Shipment Lines.Shipment IDSHIPMENT_IDSHIPMENT_ID161662
Shipment Line IDUnique identifier for Shipment LineInbound Shipment Lines.Shipment Line IDSHIPMENT_LINE_IDSHIPMENT_LINE_ID161670
Shipment Line StatusIndicates if the shipment line is expected, canceled, fully received, or partially receivedInbound Shipment Lines.Shipment Line StatusSHIPMENT_LINE_STATUSSHIPMENT_LINE_STATUS161674
Shipment UOM ClassShipment Unit of measure ClassInbound Shipment Lines.Shipment UOM ClassSHIPMENT_UOM_CLASSSHIPMENT_UOM_CLASS161707
Shipment UOM DescriptionShipment Unit of measure DescriptionInbound Shipment Lines.Shipment UOM DescriptionSHIPMENT_UOM_DESCRIPTIONSHIPMENT_UOM_DESCRIPTION161708
Shipment Unit Of Measure Inbound Shipment Lines.Shipment Unit Of MeasureSHIPMENT_UNIT_OF_MEASURESHIPMENT_UNIT_OF_MEASURE161705
Shipment Unit Price Inbound Shipment Lines.Shipment Unit PriceSHIPMENT_UNIT_PRICESHIPMENT_UNIT_PRICE161706
Shipped Quantity Inbound Shipment Lines.Shipped QuantitySHIPPED_QUANTITYSHIPPED_QUANTITY161719
Source Document Type Inbound Shipment Lines.Source Document TypeSOURCE_DOCUMENT_TYPESOURCE_DOCUMENT_TYPE275897
Source Organization Code Inbound Shipment Lines.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162481
Source Organization IDUnique identifier for Source OrganizationInbound Shipment Lines.Source Organization IDSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162500
Source Organization Name Inbound Shipment Lines.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162517
Supplier IDUnique identifier for SupplierInbound Shipment Lines.Supplier IDSUPPLIER_IDSUPPLIER_ID164211
Supplier Item Number Inbound Shipment Lines.Supplier Item NumberSUPPLIER_ITEM_NUMBERSUPPLIER_ITEM_NUMBER164224
Supplier Lot Number Inbound Shipment Lines.Supplier Lot NumberSUPPLIER_LOT_NUMBERSUPPLIER_LOT_NUMBER164231
Supplier Name Inbound Shipment Lines.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164255
Supplier Shipped Quantity Inbound Shipment Lines.Supplier Shipped QuantitySUPPLIER_SHIPPED_QUANTITYSUPPLIER_SHIPPED_QUANTITY164296
Trans Account Num Inbound Shipment Lines.Trans Account NumTRANS_ACCOUNT_NUMTRANS_ACCOUNT_NUM275905
Transaction Reason Name Inbound Shipment Lines.Transaction Reason NameTRANSACTION_REASON_NAMETRANSACTION_REASON_NAME165802
Transfer CostCost associated with the inter-organization transferInbound Shipment Lines.Transfer CostTRANSFER_COSTTRANSFER_COST165921
Transfer PercentageTransfer percentage for costingInbound Shipment Lines.Transfer PercentageTRANSFER_PERCENTAGETRANSFER_PERCENTAGE165940
Transportation Account IDUnique identifier for Transportation AccountInbound Shipment Lines.Transportation Account IDTRANSPORTATION_ACCOUNT_IDTRANSPORTATION_ACCOUNT_ID165966
Truck Number Inbound Shipment Lines.Truck NumberTRUCK_NUMBERTRUCK_NUMBER166054
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Inbound Shipment Lines.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167054
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Inbound Shipment Lines -> Multiple Currency Receiving SubledgersInbound Shipment Lines.Shipment Line ID = Multiple Currency Receiving Subledgers.Receiving Shipment Line IDMight not exist in master folderOuter join on master No
Inbound Shipment Lines -> Receiving SubledgersInbound Shipment Lines.Shipment Line ID = Receiving Subledgers.Receiving Shipment Line IDAlways exist in master folderNoneNo
Inbound Shipment Lines -> Receiving TransactionsInbound Shipment Lines.Shipment Line ID = Receiving Transactions.Shipment Line IDAlways exist in master folderNoneNo