Powered by InfoCaptor


Previous Page   Next Page

Receiving Transactions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_RECEIVING_TRANSACTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Amount Billed Receiving Transactions.Amount BilledAMOUNT_BILLEDAMOUNT_BILLED276308
Bill Of Material Resource Receiving Transactions.Bill Of Material ResourceBILL_OF_MATERIAL_RESOURCEBILL_OF_MATERIAL_RESOURCE119841
Bill Of Material Resource IDUnique identifier for Bill Of Material ResourceReceiving Transactions.Bill Of Material Resource IDBILL_OF_MATERIAL_RESOURCE_IDBILL_OF_MATERIAL_RESOURCE_ID119848
CommentsFreeform text/comments.Receiving Transactions.CommentsCOMMENTSCOMMENTS122595
Consigned Flag Receiving Transactions.Consigned FlagCONSIGNED_FLAGCONSIGNED_FLAG276318
Created By Receiving Transactions.Created ByCREATED_BYCREATED_BY125241
Created Date Receiving Transactions.Created DateCREATED_DATECREATED_DATE125416
Created Date - Day Receiving Transactions.Created Date CREATED_DATE_DAY171255
Created Date - Month Receiving Transactions.Created Date CREATED_DATE_MONTH171409
Created Date - Quarter Receiving Transactions.Created Date CREATED_DATE_QUARTER171563
Created Date - Year Receiving Transactions.Created Date CREATED_DATE_YEAR171717
CurrencyThe currency for an account balance.Receiving Transactions.CurrencyCURRENCYCURRENCY126955
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Receiving Transactions.Currency CodeCURRENCY_CODECURRENCY_CODE127056
Currency Conversion RateThe currency exchange rate.Receiving Transactions.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127128
Currency Conversion Rate Date Receiving Transactions.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127149
Currency Conversion Rate Date - Day Receiving Transactions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174040
Currency Conversion Rate Date - Month Receiving Transactions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174080
Currency Conversion Rate Date - Quarter Receiving Transactions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174120
Currency Conversion Rate Date - Year Receiving Transactions.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174160
Currency Conversion Rate Type Receiving Transactions.Currency Conversion Rate TypeCURRENCY_CONVERSION_RATE_TYPECURRENCY_CONVERSION_RATE_TYPE127165
Damaged Comments Receiving Transactions.Damaged CommentsDAMAGED_COMMENTS_2DAMAGED_COMMENTS_2276296
Deliver To Location Receiving Transactions.Deliver To LocationDELIVER_TO_LOCATIONDELIVER_TO_LOCATION128998
Deliver To Location IDUnique identifier for Deliver To LocationReceiving Transactions.Deliver To Location IDDELIVER_TO_LOCATION_IDDELIVER_TO_LOCATION_ID129008
Deliver To Person Receiving Transactions.Deliver To PersonDELIVER_TO_PERSONDELIVER_TO_PERSON129019
Deliver To Person IDUnique identifier for Deliver To PersonReceiving Transactions.Deliver To Person IDDELIVER_TO_PERSON_IDDELIVER_TO_PERSON_ID129027
Destination Locator Receiving Transactions.Destination LocatorDESTINATION_LOCATORDESTINATION_LOCATOR129881
Destination Locator IDUnique identifier for Destination LocatorReceiving Transactions.Destination Locator IDDESTINATION_LOCATOR_IDDESTINATION_LOCATOR_ID129882
Destination Organization Code Receiving Transactions.Destination Organization CodeDESTINATION_ORGANIZATION_CODEDESTINATION_ORGANIZATION_CODE129889
Destination Organization IDUnique identifier for Destination OrganizationReceiving Transactions.Destination Organization IDDESTINATION_ORGANIZATION_IDDESTINATION_ORGANIZATION_ID129898
Destination Organization Name Receiving Transactions.Destination Organization NameDESTINATION_ORGANIZATION_NAMEDESTINATION_ORGANIZATION_NAME129907
Destination Subinventory Receiving Transactions.Destination SubinventoryDESTINATION_SUBINVENTORYDESTINATION_SUBINVENTORY129916
Destination Type Receiving Transactions.Destination TypeDESTINATION_TYPEDESTINATION_TYPE276284
Drop Ship Flag Receiving Transactions.Drop Ship FlagDROP_SHIP_FLAGDROP_SHIP_FLAG276315
General Comments Receiving Transactions.General CommentsGENERAL_COMMENTS_2GENERAL_COMMENTS_2276302
Incomplete Comments Receiving Transactions.Incomplete CommentsINCOMPLETE_COMMENTS_2INCOMPLETE_COMMENTS_2276294
Inspection QualityQuality inspection codeReceiving Transactions.Inspection QualityINSPECTION_QUALITYINSPECTION_QUALITY136959
Inspection Status Receiving Transactions.Inspection StatusINSPECTION_STATUSINSPECTION_STATUS276285
Inventory Transaction IDUnique identifier for Inventory TransactionReceiving Transactions.Inventory Transaction IDINVENTORY_TRANSACTION_IDINVENTORY_TRANSACTION_ID137338
Invoice IDInvoice unique identifier.Receiving Transactions.Invoice IDINVOICE_IDINVOICE_ID137444
Invoice NumberInvoice number that may be used for identifying the matchingtransaction.Receiving Transactions.Invoice NumberINVOICE_NUMBERINVOICE_NUMBER137471
Invoice StatusEligibility status for automated Oracle Payables invoice creationReceiving Transactions.Invoice StatusINVOICE_STATUSINVOICE_STATUS137485
Last Updated By Receiving Transactions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139821
Last Updated Date Receiving Transactions.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139995
Last Updated Date - Day Receiving Transactions.Last Updated Date LAST_UPDATED_DATE_DAY182938
Last Updated Date - Month Receiving Transactions.Last Updated Date LAST_UPDATED_DATE_MONTH183100
Last Updated Date - Quarter Receiving Transactions.Last Updated Date LAST_UPDATED_DATE_QUARTER183262
Last Updated Date - Year Receiving Transactions.Last Updated Date LAST_UPDATED_DATE_YEAR183424
Match Flag Receiving Transactions.Match FlagMATCH_FLAGMATCH_FLAG276309
Match Option Receiving Transactions.Match OptionMATCH_OPTIONMATCH_OPTION276310
Mvt Stat Status Receiving Transactions.Mvt Stat StatusMVT_STAT_STATUSMVT_STAT_STATUS276306
Non Linksys Comments Receiving Transactions.Non Linksys CommentsNON_LINKSYS_COMMENTS_2NON_LINKSYS_COMMENTS_2276299
Operating Unit IDUnique identifier for Operating UnitReceiving Transactions.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149555
Operating Unit Name Receiving Transactions.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149603
Pa Addition Flag Receiving Transactions.Pa Addition FlagPA_ADDITION_FLAGPA_ADDITION_FLAG276317
Parent Transaction IDUnique identifier for Parent TransactionReceiving Transactions.Parent Transaction IDPARENT_TRANSACTION_IDPARENT_TRANSACTION_ID151934
Parent Transaction Type Receiving Transactions.Parent Transaction TypePARENT_TRANSACTION_TYPEPARENT_TRANSACTION_TYPE276303
Po Shipment Type Receiving Transactions.Po Shipment TypePO_SHIPMENT_TYPEPO_SHIPMENT_TYPE276305
Primary QuantityTransaction quantity using the item's primary unit of measureReceiving Transactions.Primary QuantityPRIMARY_QUANTITYPRIMARY_QUANTITY155566
Primary UOM ClassPrimary Unit of measure ClassReceiving Transactions.Primary UOM ClassPRIMARY_UOM_CLASSPRIMARY_UOM_CLASS155601
Primary UOM DescriptionPrimary Unit of measure DescriptionReceiving Transactions.Primary UOM DescriptionPRIMARY_UOM_DESCRIPTIONPRIMARY_UOM_DESCRIPTION155607
Primary Unit Of Measure Receiving Transactions.Primary Unit Of MeasurePRIMARY_UNIT_OF_MEASUREPRIMARY_UNIT_OF_MEASURE155591
Purchase Order Distribution IDUnique identifier for Purchase Order DistributionReceiving Transactions.Purchase Order Distribution IDPO_DISTRIBUTION_IDPO_DISTRIBUTION_ID155019
Purchase Order Distribution Number Receiving Transactions.Purchase Order Distribution NumberPO_DISTRIBUTION_NUMBERPO_DISTRIBUTION_NUMBER155023
Purchase Order IDUnique identifier for Purchase OrderReceiving Transactions.Purchase Order IDPURCHASE_ORDER_IDPURCHASE_ORDER_ID157057
Purchase Order Line IDUnique identifier for Purchase Order LineReceiving Transactions.Purchase Order Line IDPO_LINE_IDPO_LINE_ID155061
Purchase Order Line Number Receiving Transactions.Purchase Order Line NumberPO_LINE_NUMBERPO_LINE_NUMBER155076
Purchase Order Number Receiving Transactions.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157070
Purchase Order Release IDUnique identifier for Purchase Order ReleaseReceiving Transactions.Purchase Order Release IDPO_RELEASE_IDPO_RELEASE_ID155092
Purchase Order Release Number Receiving Transactions.Purchase Order Release NumberPO_RELEASE_NUMBERPO_RELEASE_NUMBER155096
Purchase Order Shipment IDUnique identifier for Purchase Order ShipmentReceiving Transactions.Purchase Order Shipment IDPO_SHIPMENT_IDPO_SHIPMENT_ID155107
Purchase Order Shipment Number Receiving Transactions.Purchase Order Shipment NumberPO_SHIPMENT_NUMBERPO_SHIPMENT_NUMBER155113
Purchase Order Type Receiving Transactions.Purchase Order TypePURCHASE_ORDER_TYPEPURCHASE_ORDER_TYPE276304
Purchase Order Unit Price Receiving Transactions.Purchase Order Unit PricePURCHASE_ORDER_UNIT_PRICEPURCHASE_ORDER_UNIT_PRICE157078
Qc Grade Receiving Transactions.Qc GradeQC_GRADEQC_GRADE276314
Qty Damaged Receiving Transactions.Qty DamagedQTY_DAMAGED_2QTY_DAMAGED_2276295
Qty Empty Box Receiving Transactions.Qty Empty BoxQTY_EMPTY_BOX_2QTY_EMPTY_BOX_2276297
Qty Incomplete Receiving Transactions.Qty IncompleteQTY_INCOMPLETE_2QTY_INCOMPLETE_2276293
Qty No Serial Number Receiving Transactions.Qty No Serial NumberQTY_NO_SERIAL_NUMBER_2QTY_NO_SERIAL_NUMBER_2276301
Qty No Sleeve No Bar Code Receiving Transactions.Qty No Sleeve No Bar CodeQTY_NO_SLEEVE_NO_BAR_CODE_2QTY_NO_SLEEVE_NO_BAR_CODE_2276300
Qty Non Linksys Product Receiving Transactions.Qty Non Linksys ProductQTY_NON_LINKSYS_PRODUCT_2QTY_NON_LINKSYS_PRODUCT_2276298
Qty Over Receiving Transactions.Qty OverQTY_OVER_2QTY_OVER_2276291
Qty Short Receiving Transactions.Qty ShortQTY_SHORT_2QTY_SHORT_2276292
Quantity Billed Receiving Transactions.Quantity BilledQUANTITY_BILLEDQUANTITY_BILLED276307
Rate Type Description Receiving Transactions.Rate Type DescriptionRATE_TYPE_DESCRIPTIONRATE_TYPE_DESCRIPTION157650
Rate Type Name Receiving Transactions.Rate Type NameRATE_TYPE_NAMERATE_TYPE_NAME157665
Receipt Exception Flag Receiving Transactions.Receipt Exception FlagRECEIPT_EXCEPTION_FLAGRECEIPT_EXCEPTION_FLAG276286
Receipt Source Type Receiving Transactions.Receipt Source TypeRECEIPT_SOURCE_TYPERECEIPT_SOURCE_TYPE276289
Receiver Employee Number Receiving Transactions.Receiver Employee NumberRECEIVER_EMPLOYEE_NUMBERRECEIVER_EMPLOYEE_NUMBER158052
Receiver IDUnique identifier for ReceiverReceiving Transactions.Receiver IDRECEIVER_IDRECEIVER_ID158054
Receiver Name Receiving Transactions.Receiver NameRECEIVER_NAMERECEIVER_NAME158056
Receiving Routing IDUnique identifier for Receiving RoutingReceiving Transactions.Receiving Routing IDRECEIVING_ROUTING_IDRECEIVING_ROUTING_ID158084
Receiving Routing Name Receiving Transactions.Receiving Routing NameRECEIVING_ROUTING_NAMERECEIVING_ROUTING_NAME158093
Requisition Distribution IDUnique identifier for Requisition DistributionReceiving Transactions.Requisition Distribution IDREQ_DISTRIBUTION_IDREQ_DISTRIBUTION_ID158857
Requisition Distribution Number Receiving Transactions.Requisition Distribution NumberREQ_DISTRIBUTION_NUMBERREQ_DISTRIBUTION_NUMBER158863
Requisition Document Number Receiving Transactions.Requisition Document NumberREQUISITION_DOCUMENT_NUMBERREQUISITION_DOCUMENT_NUMBER158821
Requisition Line IDUnique identifier for Requisition LineReceiving Transactions.Requisition Line IDREQUISITION_LINE_IDREQUISITION_LINE_ID158844
Requisition Line Number Receiving Transactions.Requisition Line NumberREQUISITION_LINE_NUMBERREQUISITION_LINE_NUMBER158850
Return Store Reference Receiving Transactions.Return Store ReferenceRETURN_STORE_REFERENCE_1RETURN_STORE_REFERENCE_1276290
Rma Reference NumberReturn Material Authorization reference numberReceiving Transactions.Rma Reference NumberRMA_REFERENCE_NUMBERRMA_REFERENCE_NUMBER159619
Sales Order Update Date Receiving Transactions.Sales Order Update DateSALES_ORDER_UPDATE_DATESALES_ORDER_UPDATE_DATE276316
Secondary Quantity Receiving Transactions.Secondary QuantitySECONDARY_QUANTITYSECONDARY_QUANTITY276311
Secondary Unit Of Measure Receiving Transactions.Secondary Unit Of MeasureSECONDARY_UNIT_OF_MEASURESECONDARY_UNIT_OF_MEASURE276312
Secondary Uom Code Receiving Transactions.Secondary Uom CodeSECONDARY_UOM_CODESECONDARY_UOM_CODE276313
Shipment IDUnique identifier for ShipmentReceiving Transactions.Shipment IDSHIPMENT_IDSHIPMENT_ID161665
Shipment Line IDUnique identifier for Shipment LineReceiving Transactions.Shipment Line IDSHIPMENT_LINE_IDSHIPMENT_LINE_ID161671
Shipment Line Number Receiving Transactions.Shipment Line NumberSHIPMENT_LINE_NUMBERSHIPMENT_LINE_NUMBER161672
Shipment Number Receiving Transactions.Shipment NumberSHIPMENT_NUMBERSHIPMENT_NUMBER161692
Source Document Quantity Receiving Transactions.Source Document QuantitySOURCE_DOCUMENT_QUANTITYSOURCE_DOCUMENT_QUANTITY162392
Source Document Type Receiving Transactions.Source Document TypeSOURCE_DOCUMENT_TYPESOURCE_DOCUMENT_TYPE276287
Source Document UOM ClassSource Document Unit of measure ClassReceiving Transactions.Source Document UOM ClassSOURCE_DOC_UOM_CLASSSOURCE_DOC_UOM_CLASS162401
Source Document UOM DescriptionSource Document Unit of measure DescriptionReceiving Transactions.Source Document UOM DescriptionSOURCE_DOC_UOM_DESCRIPTIONSOURCE_DOC_UOM_DESCRIPTION162402
Source Document Unit Of Measure Receiving Transactions.Source Document Unit Of MeasureSOURCE_DOC_UNIT_OF_MEASURESOURCE_DOC_UNIT_OF_MEASURE162400
Substitute Unordered IndicatorIndicates whether this is a substitute or unordered receiptReceiving Transactions.Substitute Unordered IndicatorSUBSTITUTE_UNORDERED_INDICATORSUBSTITUTE_UNORDERED_INDICATOR163878
Supplier IDUnique identifier for SupplierReceiving Transactions.Supplier IDSUPPLIER_IDSUPPLIER_ID164217
Supplier Lot Number Receiving Transactions.Supplier Lot NumberSUPPLIER_LOT_NUMBERSUPPLIER_LOT_NUMBER164232
Supplier Name Receiving Transactions.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164261
Supplier Site Receiving Transactions.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164308
Supplier Site IDUnique identifier for Supplier SiteReceiving Transactions.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164332
Transaction Date Receiving Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165668
Transaction Date - Day Receiving Transactions.Transaction Date TRANSACTION_DATE_DAY192359
Transaction Date - Month Receiving Transactions.Transaction Date TRANSACTION_DATE_MONTH192413
Transaction Date - Quarter Receiving Transactions.Transaction Date TRANSACTION_DATE_QUARTER192467
Transaction Date - Year Receiving Transactions.Transaction Date TRANSACTION_DATE_YEAR192521
Transaction IDExternal payment/receipt identifier.Receiving Transactions.Transaction IDTRANSACTION_IDTRANSACTION_ID165710
Transaction Quantity Receiving Transactions.Transaction QuantityTRANSACTION_QUANTITYTRANSACTION_QUANTITY165784
Transaction Reason Name Receiving Transactions.Transaction Reason NameTRANSACTION_REASON_NAMETRANSACTION_REASON_NAME165803
Transaction Type Receiving Transactions.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE276283
Transaction UOM ClassTransaction Unit of measure ClassReceiving Transactions.Transaction UOM ClassTRANSACTION_UOM_CLASSTRANSACTION_UOM_CLASS165888
Transaction UOM DescriptionTransaction Unit of measure DescriptionReceiving Transactions.Transaction UOM DescriptionTRANSACTION_UOM_DESCRIPTIONTRANSACTION_UOM_DESCRIPTION165891
Transaction Unit Of Measure Receiving Transactions.Transaction Unit Of MeasureTRANSACTION_UNIT_OF_MEASURETRANSACTION_UNIT_OF_MEASURE165879
User Entered Flag Receiving Transactions.User Entered FlagUSER_ENTERED_FLAGUSER_ENTERED_FLAG276288
WIP Department CodeWork in Process Department CodeReceiving Transactions.WIP Department CodeWIP_DEPARTMENT_CODEWIP_DEPARTMENT_CODE167803
WIP Department NameWork in Process Department NameReceiving Transactions.WIP Department NameWIP_DEPARTMENT_NAMEWIP_DEPARTMENT_NAME167804
WIP Entity IDUnique identifier for Work in Process EntityReceiving Transactions.WIP Entity IDWIP_ENTITY_IDWIP_ENTITY_ID167823
WIP Job NameWork in Process Job NameReceiving Transactions.WIP Job NameWIP_JOB_NAMEWIP_JOB_NAME167833
WIP Line CodeWork in Process Line CodeReceiving Transactions.WIP Line CodeWIP_LINE_CODEWIP_LINE_CODE167843
WIP Line IDUnique identifier for Work in Process LineReceiving Transactions.WIP Line IDWIP_LINE_IDWIP_LINE_ID167853
WIP Operation Sequence NumberWork in Process Operation Sequence NumberReceiving Transactions.WIP Operation Sequence NumberWIP_OPERATION_SEQUENCE_NUMBERWIP_OPERATION_SEQUENCE_NUMBER167864
WIP Repetitive Schedule IDUnique identifier for Work in Process Repetitive ScheduleReceiving Transactions.WIP Repetitive Schedule IDWIP_REPETITIVE_SCHEDULE_IDWIP_REPETITIVE_SCHEDULE_ID167877
WIP Resource Sequence NumberWork in Process Resource Sequence NumberReceiving Transactions.WIP Resource Sequence NumberWIP_RESOURCE_SEQUENCE_NUMBERWIP_RESOURCE_SEQUENCE_NUMBER167886
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Receiving Transactions -> Multiple Currency Receiving SubledgersReceiving Transactions.Transaction ID = Multiple Currency Receiving Subledgers.Receiving Transaction IDAlways exist in master folderNoneNo
Receiving Transactions -> Multiple Currency Receiving TransactionsReceiving Transactions.Transaction ID = Multiple Currency Receiving Transactions.Transaction IDAlways exist in master folderNoneNo
Receiving Transactions -> Receiving SubledgersReceiving Transactions.Transaction ID = Receiving Subledgers.Receiving Transaction IDAlways exist in master folderNoneNo