Receiving Receipt Transactions
The Receiving Receipt Transactions view object contains information to inspect, put away, correct, and return received goods and services.
Data Store Key : FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO
Primary Keys : RcvngRcptTrnsctnExtrctPEOTransactionId
Initial Extract Date : RcvngRcptTrnsctnExtrctPEOCreationDate
Incremental Extract Date : RcvngRcptTrnsctnExtrctPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
RcvngRcptTrnsctnExtrctPEOAmount | Transaction amount in the purchase order currency. This attribute is applicable for fixed price lines. |
RcvngRcptTrnsctnExtrctPEOAmountBilled | Amount invoiced by Oracle Payables Cloud for the transaction in terms of the purchase order currency. |
RcvngRcptTrnsctnExtrctPEOAssessableValue | Price at which a product is valued by a tax authority for tax. |
RcvngRcptTrnsctnExtrctPEOAttributeCategory | Context name for the Receipt Transaction descriptive flexfield. |
RcvngRcptTrnsctnExtrctPEOBillingUomCode | Identifies the billing UOM of the source document. |
RcvngRcptTrnsctnExtrctPEOComments | Comments entered by the user. |
RcvngRcptTrnsctnExtrctPEOConsignedFlag | Contains one of the following values: true or false. If true, then the receipt line is created for consigned material. If false, then the receipt line isn't created for consigned material. This attribute doesn't have a default value, but a value of null translates to false. |
RcvngRcptTrnsctnExtrctPEOConsignedFlag1 | Contains one of the following values: true or false. If true, then the receiving transaction is created for consigned material. If false, then the receiving transaction isn't created. This attribute doesn't have a default value, but a value of null translates to false. |
RcvngRcptTrnsctnExtrctPEOConsumedQuantity | Quantity consumed by the supplier consigned inventory. |
RcvngRcptTrnsctnExtrctPEOCountryOfOriginCode | Code that identifies the country of manufacture of this item. |
RcvngRcptTrnsctnExtrctPEOCreatedBy | User who created the receiving receipt transaction record. |
RcvngRcptTrnsctnExtrctPEOCreationDate | Date and time when the receiving receipt transaction record was created. |
RcvngRcptTrnsctnExtrctPEOCurrencyCode | Code that identifies the currency that the receiving transaction uses. |
RcvngRcptTrnsctnExtrctPEOCurrencyConversionDate | Date when the currency conversion occurred. This value is used to derive the rates for calculating the currency conversion. |
RcvngRcptTrnsctnExtrctPEOCurrencyConversionRate | Rate used for currency conversion for the receipt. This value is used only for purchase order shipments. |
RcvngRcptTrnsctnExtrctPEOCurrencyConversionType | Type of conversion rate. This value is a fixed charge for each currency unit that's used to perform foreign currency conversions. |
RcvngRcptTrnsctnExtrctPEOCustomerId | Value that uniquely identifies the customer. This attribute is used for return material authorization (RMA) transactions. |
RcvngRcptTrnsctnExtrctPEOCustomerSiteId | Value that uniquely identifies the customer site. This attribute is used for return material authorization (RMA) transactions. |
RcvngRcptTrnsctnExtrctPEODefaultTaxationCountry | Code that identifies the default taxation country for the shipment line. |
RcvngRcptTrnsctnExtrctPEODeliverToLocationId | Value that uniquely identifies the deliver-to location. |
RcvngRcptTrnsctnExtrctPEODestinationContext | Context name for the Destination descriptive flexfield. |
RcvngRcptTrnsctnExtrctPEODestinationTypeCode | Code that identifies the destination type of the receiving transaction. A list of accepted values is defined in the lookup type RCV_DESTINATION_TYPE. |
RcvngRcptTrnsctnExtrctPEODocumentFiscalClassification | Value that identifies the document fiscal classification. This value is also known as Tax Document Subtype. |
RcvngRcptTrnsctnExtrctPEOEmployeeId | Value that uniquely identifies the person who created the receiving transaction. |
RcvngRcptTrnsctnExtrctPEOExternalSysTxnReference | Value that stores the link to the transaction references passed by external warehouse management system (WMS) or third-party logistics system. |
RcvngRcptTrnsctnExtrctPEOExtractDeliverToPersonId | Value that uniquely identifies the deliver-to person. |
RcvngRcptTrnsctnExtrctPEOFinalDischargeLocationId | Value that uniquely identifies the final destination for the purchase, if it's different from the ship-to location. |
RcvngRcptTrnsctnExtrctPEOFirstPtyRegId | Value that uniquely identifies the first party tax registration for the shipment line. |
RcvngRcptTrnsctnExtrctPEOFromLocatorId | Value that uniquely identifies the source locator for the receiving transaction. |
RcvngRcptTrnsctnExtrctPEOFromSubinventory | Name of the source subinventory for the receiving transaction. |
RcvngRcptTrnsctnExtrctPEOGroupId | Value that uniquely identifies the interface group for set processing. All the interface records for a given value of the group identifier will be processed together. |
RcvngRcptTrnsctnExtrctPEOInspectionQualityCode | Code that identifies the inspection quality. This attribute references FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup type is RCV_QUALITY_CODE. |
RcvngRcptTrnsctnExtrctPEOInspectionStatusCode | Code that identifies the inspection status. Valid values are NOT INSPECTED, ACCEPTED, and REJECTED. |
RcvngRcptTrnsctnExtrctPEOIntendedUseClassifId | Value that uniquely identifies the intended use of the transaction line. This attribute identifies the purpose for which the product is used. |
RcvngRcptTrnsctnExtrctPEOInterfaceGroupId | Value that uniquely identifies the original interface transaction group. |
RcvngRcptTrnsctnExtrctPEOInterfaceSourceCode | Code that identifies the source for the interface row. |
RcvngRcptTrnsctnExtrctPEOInterfaceSourceLineId | Value that uniquely identifies the source line of the interface row. |
RcvngRcptTrnsctnExtrctPEOInterfaceTransactionId | Value that uniquely identifies the transaction interface record. |
RcvngRcptTrnsctnExtrctPEOInvTransactionId | Value that uniquely identifies the inventory transaction that created the in transit shipment interface transaction row. This attribute maps to INV_MATERIAL_TXNS.TRANSACTION_ID. |
RcvngRcptTrnsctnExtrctPEOInvoiceId | Value that uniquely identifies the transaction 857 invoice. |
RcvngRcptTrnsctnExtrctPEOInvoiceStatusCode | Code that identifies the advance shipment notice (ASN) with billing information (ASBN) only. This attribute indicates when the line items were rejected. |
RcvngRcptTrnsctnExtrctPEOJobDefinitionName | Name of the scheduled process that created or last updated the record. |
RcvngRcptTrnsctnExtrctPEOJobDefinitionPackage | Package name of the scheduled process that created or most recently updated the record. |
RcvngRcptTrnsctnExtrctPEOLastUpdateDate | Date and time when the user most recently updated the receiving receipt transaction record. |
RcvngRcptTrnsctnExtrctPEOLastUpdateLogin | Session login associated with the user who most recently updated the receiving receipt transaction record. |
RcvngRcptTrnsctnExtrctPEOLastUpdatedBy | User who most recently updated the receiving receipt transaction record. |
RcvngRcptTrnsctnExtrctPEOLocationId | Value that uniquely identifies the receiving location. |
RcvngRcptTrnsctnExtrctPEOLocatorId | Value that uniquely identifies the locator. |
RcvngRcptTrnsctnExtrctPEOLpnGroupId | Value that uniquely identifies the group where the transactions associated to a license plate number (LPN) are processed automatically. |
RcvngRcptTrnsctnExtrctPEOLpnId | Value that uniquely identifies the source packing unit of the receiving transaction. |
RcvngRcptTrnsctnExtrctPEOMatchFlag | Indicates whether the purchase order or receipt must be matched to an invoice. |
RcvngRcptTrnsctnExtrctPEOMatchOption | Indicates whether the invoice for this transaction should be matched to the purchase order or the receipt. |
RcvngRcptTrnsctnExtrctPEOMovementId | Value that uniquely identifies the movement. |
RcvngRcptTrnsctnExtrctPEOMvtStatStatus | Status that indicates whether the transaction has been processed by the movement statistics concurrent program. |
RcvngRcptTrnsctnExtrctPEOObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
RcvngRcptTrnsctnExtrctPEOOrganizationId | Value that uniquely identifies the receiving organization where the receiving transaction is created. |
RcvngRcptTrnsctnExtrctPEOPEOAccrualStatusCode | Code that indicates the interface status of the receiving transaction from receiving to costing and is calculated by the application. |
RcvngRcptTrnsctnExtrctPEOPaAdditionFlag | Contains one of the following values: true or false. If true, then the project related receipts have been transferred to Oracle Projects. If false, then project related receipts haven't been transferred. This attribute doesn't have a default value, but a value of null translates to false. |
RcvngRcptTrnsctnExtrctPEOParentSpGroupId | Value that uniquely identifies the standard pack grouping for the parent transaction. |
RcvngRcptTrnsctnExtrctPEOParentTransactionId | Value that uniquely identifies the parent receiving transaction. |
RcvngRcptTrnsctnExtrctPEOPoDistributionId | Value that uniquely identifies the purchase order distribution. |
RcvngRcptTrnsctnExtrctPEOPoHeaderId | Value that uniquely identifies the purchase order header. |
RcvngRcptTrnsctnExtrctPEOPoLineId | Value that uniquely identifies the purchase order line. |
RcvngRcptTrnsctnExtrctPEOPoLineLocationId | Value that uniquely identifies the purchase order schedule. |
RcvngRcptTrnsctnExtrctPEOPoRevisionNum | Number of times the purchase order has been revised. |
RcvngRcptTrnsctnExtrctPEOPoUnitPrice | Unit price from the purchase order line. |
RcvngRcptTrnsctnExtrctPEOPricingQuantity | Identifies the transaction quantity in the pricing UOM of the source document. |
RcvngRcptTrnsctnExtrctPEOPricingUomCode | Identifies the pricing UOM of the source document. |
RcvngRcptTrnsctnExtrctPEOPrimaryQuantity | Receiving transaction quantity in terms of the item's primary unit of measure (UOM). |
RcvngRcptTrnsctnExtrctPEOPrimaryUomCode | Code that identifies the primary unit of measure of the item in the receiving organization. |
RcvngRcptTrnsctnExtrctPEOProductCategory | Category of the product in the shipment line. |
RcvngRcptTrnsctnExtrctPEOProductFiscClassId | Value that uniquely identifies the product fiscal classification for the inventory item. |
RcvngRcptTrnsctnExtrctPEOProductType | Code that identifies the product type of the inventory item. Valid values are GOODS and SERVICES. |
RcvngRcptTrnsctnExtrctPEOProjectId | Value that uniquely identifies the project. |
RcvngRcptTrnsctnExtrctPEOQuantity | Receiving transaction quantity stored in the receiving transaction unit of measure (UOM). |
RcvngRcptTrnsctnExtrctPEOQuantityBilled | Quantity invoiced by Oracle Payables Cloud for the current receiving transaction. |
RcvngRcptTrnsctnExtrctPEORcptConfMessageNumber | Number that identifies the message that groups the receiving transactions communicated through a receipt confirmation. |
RcvngRcptTrnsctnExtrctPEORcptConfStatus | Status code that identifies the receipt confirmation sent from Oracle Receiving Cloud to the source application. Valid values include PENDING or SENT. |
RcvngRcptTrnsctnExtrctPEOReasonId | Value that uniquely identifies the reason. |
RcvngRcptTrnsctnExtrctPEOReceiptAdviceHeaderId | Value that uniquely identifies the receipt advice header. |
RcvngRcptTrnsctnExtrctPEOReceiptAdviceLineId | Value that uniquely identifies the receipt advice line. |
RcvngRcptTrnsctnExtrctPEOReceiptExceptionFlag | Contains one of the following values: Y or N. If Y, then an exception was found when creating the receiving transaction. If N, then no exception was found when creating the receiving transaction. This attribute doesn't have a default value, but a value of null translates to false. To create an exception, set the value to Y. |
RcvngRcptTrnsctnExtrctPEOReplenishOrderLineId | Value that uniquely identifies the replenishment sales order line for chargeable subcontracting component. |
RcvngRcptTrnsctnExtrctPEOReqDistributionId | Value that uniquely identifies the requisition distribution. |
RcvngRcptTrnsctnExtrctPEORequestId | Value that uniquely identifies the request of the scheduled process that created or most recently updated the row. |
RcvngRcptTrnsctnExtrctPEORequisitionLineId | Value that uniquely identifies the requisition line. |
RcvngRcptTrnsctnExtrctPEORmaReference | Number that identifies the supplier's return material authorization (RMA) reference when returning goods to supplier. |
RcvngRcptTrnsctnExtrctPEORoutingHeaderId | Value that uniquely identifies the receipt routing. Values include 1, 2, and 3. A list of accepted values is defined in the lookup type RCV_ROUTING_HEADERS. |
RcvngRcptTrnsctnExtrctPEORoutingStepId | Value that uniquely identifies the receiving routing step. |
RcvngRcptTrnsctnExtrctPEOSecondaryQuantity | Receiving transaction quantity in the item's secondary unit of measure (UOM). |
RcvngRcptTrnsctnExtrctPEOSecondaryUomCode | Code that identifies the unit of measure for the secondary quantity. |
RcvngRcptTrnsctnExtrctPEOShipFromLocationId | Value that uniquely identifies the ship from location of the supplier site. |
RcvngRcptTrnsctnExtrctPEOShipmentHeaderId | Value that uniquely identifies the shipment header. |
RcvngRcptTrnsctnExtrctPEOShipmentLineId | Value that uniquely identifies the shipment line. |
RcvngRcptTrnsctnExtrctPEOSourceDocQuantity | Transaction quantity in terms of the source document's unit of measure. |
RcvngRcptTrnsctnExtrctPEOSourceDocUomCode | Code that identifies the source document's unit of measure. |
RcvngRcptTrnsctnExtrctPEOSourceDocumentCode | Code that identifies the document classification based on the originating source such as purchase order or transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. |
RcvngRcptTrnsctnExtrctPEOSourceTransactionNum | Number that identifies the source transaction and can be used to store the unique transaction identifier in the source application. This value must be unique across all records in rcv_transactions and rcv_transactions_interface which are the main receipt transaction and interface tables respectively. |
RcvngRcptTrnsctnExtrctPEOSpGroupId | Value that uniquely identifies the grouping standard pack receipts. |
RcvngRcptTrnsctnExtrctPEOSpQuantity | Transaction quantity represented in terms of standard pack unit of measure. |
RcvngRcptTrnsctnExtrctPEOSpUomCode | Code that identifies the standard pack unit of measure. |
RcvngRcptTrnsctnExtrctPEOSubinventory | Name of the destination subinventory for the receiving transaction. |
RcvngRcptTrnsctnExtrctPEOSubstituteUnorderedCode | Code that identifies the substitute or unordered receipt. This attribute's value is SUBSTITUTE when a substitute item is received. |
RcvngRcptTrnsctnExtrctPEOTaskId | Value that uniquely identifies the task. |
RcvngRcptTrnsctnExtrctPEOTaxClassificationCode | Code that identifies the tax classification for the shipment line. |
RcvngRcptTrnsctnExtrctPEOTaxInvoiceDate | Date when the user generated the fiscal document. |
RcvngRcptTrnsctnExtrctPEOTaxInvoiceNumber | Number that identifies the fiscal document. |
RcvngRcptTrnsctnExtrctPEOThirdPtyRegId | Value that uniquely identifies the third party tax registration for the shipment line. |
RcvngRcptTrnsctnExtrctPEOTransactionDate | Date when the transaction for the receiving transactions occurred. |
RcvngRcptTrnsctnExtrctPEOTransactionId | Value that uniquely identifies the current receiving transaction row. |
RcvngRcptTrnsctnExtrctPEOTransactionType | Type of receiving transaction. This attribute references FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup type is RCV_TRANSACTION_TYPE. |
RcvngRcptTrnsctnExtrctPEOTransferLpnId | Value that uniquely identifies the transfer packing unit of the receiving transaction. |
RcvngRcptTrnsctnExtrctPEOTransferOrderLineId | Value that uniquely identifies the transfer order line. |
RcvngRcptTrnsctnExtrctPEOTrxBusinessCategory | Business category of the transaction for the shipment line. |
RcvngRcptTrnsctnExtrctPEOUomCode | Code that identifies the unit of measure in which the lot was shipped. |
RcvngRcptTrnsctnExtrctPEOUserDefinedFiscClass | User defined fiscal classification code for the shipment line. |
RcvngRcptTrnsctnExtrctPEOUserEnteredFlag | Contains one of the following values: true or false. If true, then the current receiving transaction row is user entered. If false, then the current receiving transaction row is automatically generated. This attribute doesn't have a default value, but a value of null translates to false. |
RcvngRcptTrnsctnExtrctPEOVendorId | Value that uniquely identifies the supplier. |
RcvngRcptTrnsctnExtrctPEOVendorLotNum | Number that identifies the lot given by the supplier for the purchase order receipts. |
RcvngRcptTrnsctnExtrctPEOVendorSiteId | Value that uniquely identifies the supplier site. |
RcvngShpmntReceiptHdrPEOAsnType | Type of document that specifies how to use the transaction for in-transit shipments and transfer order shipments. It can have three possible values: ASN, ASBN, and STD. ASN indicates an advance shipment notice. ASBN indicates an advance shipment billing notice. STD indicates a transfer order shipment or in-transit shipment. |
RcvngShpmntReceiptHdrPEOAttributeCategory | Context name for the Receipt Transaction descriptive flexfield. |
RcvngShpmntReceiptHdrPEOBillOfLading | Carrier's contract and receipt for the goods that the carrier agrees to transport from a specific origin address to a specific destination address. |
RcvngShpmntReceiptHdrPEOCarrierEquipment | Description of the equipment used by the carrier. |
RcvngShpmntReceiptHdrPEOCarrierMethod | Method of transportation used by the carrier. |
RcvngShpmntReceiptHdrPEOComments | Comments entered by the user. |
RcvngShpmntReceiptHdrPEOConversionDate | Date when the currency conversion occurred. This value is used to derive the rates for calculating the currency conversion. |
RcvngShpmntReceiptHdrPEOConversionRate | Rate used for currency conversion for the receipt. This value is used only for purchase order shipments. |
RcvngShpmntReceiptHdrPEOConversionRateType | Type of conversion rate. This value is a fixed charge for each currency unit that's used to perform foreign currency conversions. |
RcvngShpmntReceiptHdrPEOCreatedBy | User who created the receiving receipt transaction record. |
RcvngShpmntReceiptHdrPEOCreationDate | Date and time when the receiving receipt transaction record was created. |
RcvngShpmntReceiptHdrPEOCurrencyCode | Code that identifies the currency that the receiving transaction uses. |
RcvngShpmntReceiptHdrPEOCustomerId | Value that uniquely identifies the customer. This attribute is used for return material authorization (RMA) transactions. |
RcvngShpmntReceiptHdrPEOCustomerSiteId | Value that uniquely identifies the customer site. This attribute is used for return material authorization (RMA) transactions. |
RcvngShpmntReceiptHdrPEOEdiControlNum | Control number that identifies the electronic data interchange (EDI) transaction if data is imported using EDI. |
RcvngShpmntReceiptHdrPEOEmployeeId | Value that uniquely identifies the person who created the receiving transaction. |
RcvngShpmntReceiptHdrPEOExpectedReceiptDate | Date when the item is expected to arrive at the warehouse. |
RcvngShpmntReceiptHdrPEOFreightAmount | Base transportation cost that's incurred by a merchant in moving goods, by whatever means, from one place to another under the terms of the contract of carriage. |
RcvngShpmntReceiptHdrPEOFreightBillNumber | Number that identifies the freight bill. |
RcvngShpmntReceiptHdrPEOFreightCarrierId | Value that uniquely identifies the carrier. |
RcvngShpmntReceiptHdrPEOFreightTerms | Agreement that indicates who (the buyer or the seller) pays the freight costs of an order and when they're to pay. |
RcvngShpmntReceiptHdrPEOGovernmentContext | Context name for United States Standard General Ledger (USSGL). |
RcvngShpmntReceiptHdrPEOGrossWeight | Weight of the fully loaded vehicle, container, or item, including the packed items and packaging material. |
RcvngShpmntReceiptHdrPEOGrossWeightUomCode | Code that identifies the unit of measure for the gross weight of the shipment. |
RcvngShpmntReceiptHdrPEOHazardClass | Value that encodes the United Nations (UN) number to determine the general hazard classification of the explosive materials and explosive components. |
RcvngShpmntReceiptHdrPEOHazardCode | Code that identifies the hazardous material. Each identification number has a description. The identification numbers aren't unique. For instance, the same United Nations (UN) number may correspond to two closely related but different types of materials. |
RcvngShpmntReceiptHdrPEOHazardDescription | Description of the hazardous material. |
RcvngShpmntReceiptHdrPEOInvoiceAmount | Amount on the invoice associated with the shipment or billing notice, such as, an advanced shipment notice with billing information. |
RcvngShpmntReceiptHdrPEOInvoiceDate | Date when the invoice associated with the shipment or billing notice, such as, an advanced shipment notice with billing information, is due. |
RcvngShpmntReceiptHdrPEOInvoiceNum | Number that identifies the invoice associated with the shipment or billing notice such as, advanced shipment notice with billing information. |
RcvngShpmntReceiptHdrPEOInvoiceStatusCode | Code that identifies the advance shipment notice (ASN) with billing information (ASBN) only. This attribute indicates when the line items were rejected. |
RcvngShpmntReceiptHdrPEOJobDefinitionName | Name of the scheduled process that created or last updated the record. |
RcvngShpmntReceiptHdrPEOJobDefinitionPackage | Package name of the scheduled process that created or most recently updated the record. |
RcvngShpmntReceiptHdrPEOLastUpdateDate | Date and time when the user most recently updated the receiving receipt transaction record. |
RcvngShpmntReceiptHdrPEOLastUpdateLogin | Session login associated with the user who most recently updated the receiving receipt transaction record. |
RcvngShpmntReceiptHdrPEOLastUpdatedBy | User who most recently updated the receiving receipt transaction record. |
RcvngShpmntReceiptHdrPEOLspFlag | Contains one of the following values: true or false. If true, then the shipment is created for a logistics service provider organization. If false, then the receipt isn't created for a logistics service provider organization. This attribute doesn't have a default value, but a value of null translates to false. |
RcvngShpmntReceiptHdrPEONetWeight | Weight of the products being shipped without considering the packaging. |
RcvngShpmntReceiptHdrPEONetWeightUomCode | Code that identifies the unit of measure for the net weight of the items. |
RcvngShpmntReceiptHdrPEONoticeCreationDate | Date when the user created the electronic data interchange (EDI) transaction at source if data is imported using EDI. |
RcvngShpmntReceiptHdrPEONumOfContainers | Number of packing units with the shipment. |
RcvngShpmntReceiptHdrPEOObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
RcvngShpmntReceiptHdrPEOOrganizationId | Value that uniquely identifies the receiving organization. |
RcvngShpmntReceiptHdrPEOPackagingCode | Code that identifies the material being transported. This attribute is a unique packaging code based on the United Nations Committee of Experts on the Transportation of Dangerous Goods, which has established a uniform international system for identifying and packaging class 3, 4, 5, 6.1, 8 and 9 dangerous goods for transport. |
RcvngShpmntReceiptHdrPEOPackingSlip | Document that itemizes in detail the contents of a particular package, carton, pallet, or container for shipment to a customer. |
RcvngShpmntReceiptHdrPEOPaymentTermsId | Value that uniquely identifies the payment terms. |
RcvngShpmntReceiptHdrPEORaDocCreationDate | Date when the user created the source document for receipt advice. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaDocLastUpdateDate | Date when the user most recently updated the source document for receipt advice. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaDocRevisionDate | Date when the user revised the source document for receipt advice. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaDocRevisionNumber | Number of times the source document has been revised for the receipt advice. This attribute is used for flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaDocumentCode | Code that identifies the source document created as part of the receipt advice. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaDocumentNumber | Number that identifies the source document of the receipt advice. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaDooSourceSystemId | Value that uniquely identifies the receiving shipment receipt header interface record that created this shipment or receipt. |
RcvngShpmntReceiptHdrPEORaNoteToReceiver | Note to receiver specified in the receipt advice. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaOutsourcerContactId | Value that uniquely identifies the logistic outsourcer contact party. This attribute is used for flexible supply source documents. |
RcvngShpmntReceiptHdrPEORaOutsourcerPartyId | Value that uniquely identifies the logistics service provider customer party. |
RcvngShpmntReceiptHdrPEOReceiptAdviceNumber | Number that identifies the receipt advice of the shipment. |
RcvngShpmntReceiptHdrPEOReceiptNum | Number that identifies the acknowledgment that a shipment was received in the warehouse. |
RcvngShpmntReceiptHdrPEOReceiptSourceCode | Code that identifies the source type of the shipment. |
RcvngShpmntReceiptHdrPEORemitToSiteId | Value that uniquely identifies the remit to site. |
RcvngShpmntReceiptHdrPEORequestId | Value that uniquely identifies the schedule process that created or last updated the row. |
RcvngShpmntReceiptHdrPEORmaBuId | Value that uniquely identifies the business unit in which the return material authorization (RMA) was created. |
RcvngShpmntReceiptHdrPEOShipFromLocationId | Value that uniquely identifies the supplier site. |
RcvngShpmntReceiptHdrPEOShipToLocationId | Value that uniquely identifies the receiving location. |
RcvngShpmntReceiptHdrPEOShipToOrgId | Value that uniquely identifies the receiving organization. |
RcvngShpmntReceiptHdrPEOShipmentHeaderId | Value that uniquely identifies the shipment header. |
RcvngShpmntReceiptHdrPEOShipmentNum | Number that identifies the shipment for the items associated with the receipt. |
RcvngShpmntReceiptHdrPEOShippedDate | Date when goods or services were shipped by the supplier. |
RcvngShpmntReceiptHdrPEOSpecialHandlingCode | Code that identifies the handling instructions for the transported material. |
RcvngShpmntReceiptHdrPEOTarWeight | Weight difference between the gross weight and the net weight. |
RcvngShpmntReceiptHdrPEOTarWeightUomCode | Code that identifies the unit of measure for the tare weight of the shipment. |
RcvngShpmntReceiptHdrPEOTaxAmount | Value of a tax for a given tax jurisdiction for a given tax event. Each tax amount that's calculated for a tax may also have a tax recovery amount and nontax recoverable amount. For purposes of reconciliation to general ledger, these amounts will each have their own tax line. The tax amount is represented in three currencies: transactional currency, functional currency, and tax currency. |
RcvngShpmntReceiptHdrPEOTaxName | Tax name associated with the shipment or billing notice (advanced shipment notice (ASN) with billing information). |
RcvngShpmntReceiptHdrPEOVendorId | Value that uniquely identifies the supplier. |
RcvngShpmntReceiptHdrPEOVendorSiteId | Value that uniquely identifies the supplier site. |
RcvngShpmntReceiptHdrPEOWaybillAirbillNum | Number that identifies the nonnegotiable document that describes the contract for transporting cargo. |
RcvngShpmntReceiptLinePEOAmount | Transaction amount in purchase order currency. This attribute is used for fixed price lines. |
RcvngShpmntReceiptLinePEOAmountReceived | Amount received for a fixed price service receipt line in purchase order currency. |
RcvngShpmntReceiptLinePEOAsnLpnId | Value that uniquely identifies the license plate number used for this advanced shipment notice line. |
RcvngShpmntReceiptLinePEOAssessableValue | Price at which a product is valued by a tax authority for tax. |
RcvngShpmntReceiptLinePEOAttributeCategory | Context name for the Receipt Transaction descriptive flexfield. |
RcvngShpmntReceiptLinePEOBarCodeLabel | Bar code label for the material on the shipment line. |
RcvngShpmntReceiptLinePEOCategoryId | Value that uniquely identifies the item category. |
RcvngShpmntReceiptLinePEOComments | Comments entered by the user. |
RcvngShpmntReceiptLinePEOConsignedFlag | Contains one of the following values: true or false. If true, then the receipt line is created for consigned material. If false, then the receipt line isn't created for consigned material. This attribute doesn't have a default value, but a value of null translates to false. |
RcvngShpmntReceiptLinePEOConsumedQuantity | Quantity consumed by the supplier consigned inventory. |
RcvngShpmntReceiptLinePEOContainerNum | Reference number assigned to the freight container. This attribute is used for documentation purposes. |
RcvngShpmntReceiptLinePEOCountryOfOriginCode | Code that identifies the country of manufacture of this item. |
RcvngShpmntReceiptLinePEOCreatedBy | User who created the receiving receipt transaction record. |
RcvngShpmntReceiptLinePEOCreationDate | Date and time when the receiving receipt transaction record was created. |
RcvngShpmntReceiptLinePEOCustomerId | Value that uniquely identifies the customer. This attribute is used for return material authorization (RMA) transactions. |
RcvngShpmntReceiptLinePEOCustomerItemNum | Number that identifies the customer's item. |
RcvngShpmntReceiptLinePEOCustomerSiteId | Value that uniquely identifies the customer site. This attribute is used for return material authorization (RMA) transactions. |
RcvngShpmntReceiptLinePEODefaultTaxationCountry | Code that identifies the default taxation country for the shipment line. |
RcvngShpmntReceiptLinePEODeliverToLocationId | Value that uniquely identifies the deliver-to location. |
RcvngShpmntReceiptLinePEODeliverToPersonId | Value that uniquely identifies the deliver-to person. |
RcvngShpmntReceiptLinePEODestinationContext | Context name for the Destination descriptive flexfield. |
RcvngShpmntReceiptLinePEODestinationTypeCode | Code that identifies the destination type of the receiving transaction. A list of accepted values is defined in the lookup type RCV_DESTINATION_TYPE. |
RcvngShpmntReceiptLinePEODocumentFiscalClassification | Value that identifies the document fiscal classification. This value is also known as Tax Document Subtype. |
RcvngShpmntReceiptLinePEOEmployeeId | Value that uniquely identifies the person who created the receiving transaction. |
RcvngShpmntReceiptLinePEOExcessTransportReason | Reason for the excess transportation. |
RcvngShpmntReceiptLinePEOFinalDischargeLocationId | Value that uniquely identifies the final destination for the purchase, if it's different from the ship-to location. |
RcvngShpmntReceiptLinePEOFirstPtyRegId | Value that uniquely identifies the first party tax registration for the shipment line. |
RcvngShpmntReceiptLinePEOFromOrganizationId | Value that uniquely identifies the originating organization of the in-transit shipment or transfer order shipment. |
RcvngShpmntReceiptLinePEOGovernmentContext | Context name for United States Standard General Ledger (USSGL). |
RcvngShpmntReceiptLinePEOInvoiceStatusCode | Code that identifies the advance shipment notice (ASN) with billing information (ASBN) only. This attribute indicates when the line items were rejected. |
RcvngShpmntReceiptLinePEOItemDescription | Description of the item being shipped. |
RcvngShpmntReceiptLinePEOItemId | Value that uniquely identifies the item. |
RcvngShpmntReceiptLinePEOItemRevision | Value that identifies an incremental change to the item. |
RcvngShpmntReceiptLinePEOJobDefinitionName | Name of the scheduled process that created or last updated the record. |
RcvngShpmntReceiptLinePEOJobDefinitionPackage | Package name of the scheduled process that created or most recently updated the record. |
RcvngShpmntReceiptLinePEOLastUpdateDate | Date and time when the user most recently updated the receiving receipt transaction record. |
RcvngShpmntReceiptLinePEOLastUpdateLogin | Session login associated with the user who most recently updated the receiving receipt transaction record. |
RcvngShpmntReceiptLinePEOLastUpdatedBy | User who most recently updated the receiving receipt transaction record. |
RcvngShpmntReceiptLinePEOLineNum | Number that identifies the line in a document. |
RcvngShpmntReceiptLinePEOLocatorId | Value that uniquely identifies the locator. |
RcvngShpmntReceiptLinePEOMmtTransactionId | Value that uniquely identifies the inventory transaction that created the in-transit shipment line. This attribute maps to INV_MATERIAL_TXNS.TRANSACTION_ID. |
RcvngShpmntReceiptLinePEONoticeUnitPrice | Electronic data interchange (EDI) transaction 857 unit price for the item in the shipment line. |
RcvngShpmntReceiptLinePEOObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
RcvngShpmntReceiptLinePEOPackingSlip | Document that itemizes in detail the contents of a particular package, carton, pallet, or container for shipment to a customer. |
RcvngShpmntReceiptLinePEOPoDistributionId | Value that uniquely identifies the purchase order distribution. |
RcvngShpmntReceiptLinePEOPoHeaderId | Value that uniquely identifies the purchase order header. |
RcvngShpmntReceiptLinePEOPoLineId | Value that uniquely identifies the purchase order line. |
RcvngShpmntReceiptLinePEOPoLineLocationId | Value that uniquely identifies the purchase order schedule. |
RcvngShpmntReceiptLinePEOPrimaryUomCode | Code that identifies the primary unit of measure of the item in the receiving organization. |
RcvngShpmntReceiptLinePEOProductCategory | Category of the product in the shipment line. |
RcvngShpmntReceiptLinePEOProductType | Value that uniquely identifies the product fiscal classification for the inventory item. |
RcvngShpmntReceiptLinePEOQuantityAccepted | Net accepted quantity for this receiving shipment receipt line. |
RcvngShpmntReceiptLinePEOQuantityDelivered | Net quantity delivered for this receiving shipment receipt line. |
RcvngShpmntReceiptLinePEOQuantityReceived | Net quantity received for the receiving shipment receipt line. |
RcvngShpmntReceiptLinePEOQuantityRejected | Net quantity rejected for this receiving shipment receipt line. |
RcvngShpmntReceiptLinePEOQuantityReturned | Net quantity returned for this receiving shipment receipt line. |
RcvngShpmntReceiptLinePEOQuantityShipped | Total quantity of goods shipped for this receiving shipment receipt line. |
RcvngShpmntReceiptLinePEORaAllowSubstituteReceipt | Value that indicates whether to allow receipt of substitute items control for receipt advice line. This attribute is used for flexible supply source documents |
RcvngShpmntReceiptLinePEORaDaysEarlyReceiptAllowed | Number of days allowed for an early receipt against receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaDaysLateReceiptAllowed | Number of days allowed for a late receipt against receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaDocLineCreationDate | Date when the user created the source document line for receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaDocLineLastUpdateDate | Date when the user most recently updated the source document line for receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaDocScheduleNumber | Number that identifies source document schedule for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaDocumentLineNumber | Number that identifies the source document line for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaDooFulfillmentLineNumber | Number that identifies the fulfillment line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaDooHeaderNumber | Number that identifies the header reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaDooLineNumber | Number that identifies the line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaEnforceShipToLocCode | Code that identifies the ship-to location exception control for receipt advice line. This attribute is used for flexible supply source documents. |
RcvngShpmntReceiptLinePEORaExpectedReceiptDate | Date when the receipt advice line is expected to arrive. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaLastActionCode | Code that identifies the last action performed on the receipt advice line. Valid values include CREATE, UPDATE, and CANCEL. |
RcvngShpmntReceiptLinePEORaNoteToReceiver1 | Note to receiver specified in the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaOrigDooFulfilLineNum | Number that identifies the original fulfillment line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaOrigDooHeaderNumber | Number that identifies the original order reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaOrigDooLineNumber | Number that identifies the original order line reference in distributed order orchestration corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaOrigOcHeaderNumber | Number that identifies the original sales order reference corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaOrigOcLineNumber | Number that identifies the original sales order line reference corresponding to the return material authorization (RMA). |
RcvngShpmntReceiptLinePEORaQtyRcvExceptionCode | Code that identifies the overreceipt quantity tolerance exception level for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaQtyRcvTolerance | Overreceipt quantity tolerance for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaQuantityExpected | Expected quantity to be received for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaReceiptDaysExceptionCode | Code that identifies the receipt days exception level for the receipt advice line. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaSecondaryQuantityExpected | Expected quantity to be received for the receipt advice line in item's secondary UOM. This attribute is used for return material authorization (RMA) and flexible supply source documents. |
RcvngShpmntReceiptLinePEORaUnitPrice | Unit price of the inventory item for the receipt advice line. This attribute is used for flexible supply source documents. |
RcvngShpmntReceiptLinePEOReasonId | Value that uniquely identifies the reason. |
RcvngShpmntReceiptLinePEOReceiptAdviceHeaderId | Value that uniquely identifies the receipt advice header. |
RcvngShpmntReceiptLinePEOReceiptAdviceLineId | Value that uniquely identifies the receipt advice line. |
RcvngShpmntReceiptLinePEOReceiptAdviceLineNumber | Number that identifies the line for the receipt advice. |
RcvngShpmntReceiptLinePEOReqDistributionId | Value that uniquely identifies the requisition distribution. |
RcvngShpmntReceiptLinePEORequestId1 | Value that uniquely identifies the request of the scheduled process that created or most recently updated the row. |
RcvngShpmntReceiptLinePEORequisitionLineId | Value that uniquely identifies the requisition line. |
RcvngShpmntReceiptLinePEORoutingHeaderId | Value that uniquely identifies the receipt routing. Values include 1, 2, and 3. A list of accepted values is defined in the lookup type RCV_ROUTING_HEADERS. |
RcvngShpmntReceiptLinePEOSecondaryQuantityReceived | Quantity received in the secondary unit of measure. |
RcvngShpmntReceiptLinePEOSecondaryQuantityShipped | Quantity shipped in the secondary unit of measure. |
RcvngShpmntReceiptLinePEOSecondaryUomCode | Code that identifies the unit of measure for the secondary quantity. |
RcvngShpmntReceiptLinePEOShipFromLocationId | Value that uniquely identifies the ship from location of the supplier site. |
RcvngShpmntReceiptLinePEOShipToLocationId | Value that uniquely identifies the receiving location. |
RcvngShpmntReceiptLinePEOShipmentHeaderId | Value that uniquely identifies the shipment header. |
RcvngShpmntReceiptLinePEOShipmentLineId | Value that uniquely identifies the shipment line. |
RcvngShpmntReceiptLinePEOShipmentLineStatusCode | Code that identifies the state of the inbound shipment line. Valid values include EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, and CANCELED. |
RcvngShpmntReceiptLinePEOShipmentUnitPrice | Unit price for shipping the item. |
RcvngShpmntReceiptLinePEOSourceDocumentCode | Code that identifies the document classification based on the originating source such as purchase order or transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. |
RcvngShpmntReceiptLinePEOSpGroupId | Value that uniquely identifies the grouping standard pack receipts. |
RcvngShpmntReceiptLinePEOSpQuantity | Transaction quantity represented in terms of standard pack unit of measure. |
RcvngShpmntReceiptLinePEOSpUomCode | Code that identifies the standard pack unit of measure. |
RcvngShpmntReceiptLinePEOTaxAmount | Value of a tax for a given tax jurisdiction for a given tax event. Each tax amount that's calculated for a tax may also have a tax recovery amount and nontax recoverable amount. For purposes of reconciliation to general ledger, these amounts will each have their own tax line. The tax amount is represented in three currencies: transactional currency, functional currency, and tax currency. |
RcvngShpmntReceiptLinePEOTaxClassificationCode | Code that identifies the tax classification for the shipment line. |
RcvngShpmntReceiptLinePEOTaxName | Name of the tax associated with the shipment or billing notice (advanced shipment notice (ASN) with billing information). |
RcvngShpmntReceiptLinePEOThirdPtyRegId | Value that uniquely identifies the third party tax registration for the shipment line. |
RcvngShpmntReceiptLinePEOToOrganizationId | Value that uniquely identifies the receiving organization. |
RcvngShpmntReceiptLinePEOToSubinventory | Default destination subinventory in the receiving organization. |
RcvngShpmntReceiptLinePEOTransferCost | Cost of transfer for the interorganizational shipments. |
RcvngShpmntReceiptLinePEOTransferOrderLineId | Value that uniquely identifies the transfer order line. |
RcvngShpmntReceiptLinePEOTransferPercentage | Percent of transfer for costing. |
RcvngShpmntReceiptLinePEOTransportationCost | Base cost of transportation that's incurred by a merchant in moving goods, by whatever means, from one place to another under the terms of the contract of carriage. |
RcvngShpmntReceiptLinePEOTruckNum | Number of the truck used for shipment. |
RcvngShpmntReceiptLinePEOTrxBusinessCategory | Business category of the transaction for the shipment line. |
RcvngShpmntReceiptLinePEOUomCode | Code that identifies the unit of measure in which the lot was shipped. |
RcvngShpmntReceiptLinePEOUserDefinedFiscClass | User defined fiscal classification code for the shipment line. |
RcvngShpmntReceiptLinePEOVendorCumShippedQuantity | Quantity shipped by the supplier specified on the advanced shipment notice (ASN). This attribute is populated for parent lines only. |
RcvngShpmntReceiptLinePEOVendorItemNum | Number that identifies the supplier's item. This attribute maps to PO_LINES_ALL.VENDOR_PRODUCT_NUM. |
RcvngShpmntReceiptLinePEOVendorLotNum | Number that identifies the lot given by the supplier for the purchase order receipts. |
ReceivingTransactionPARPEOAccrualStatusCode | Code that identifies the interface status of the receiving transaction from receiving to costing and is calculated by the application. |
ReceivingTransactionPARPEOAmount | Transaction amount in purchase order currency. This attribute is applicable for fixed price lines. |
ReceivingTransactionPARPEOAmountBilled | Amount invoiced by Oracle Payables Cloud for the transaction in terms of the purchase order currency. |
ReceivingTransactionPARPEOAssessableValue | Price at which a product is valued by a tax authority for tax. |
ReceivingTransactionPARPEOAttribute | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute10 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute11 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute12 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute14 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute15 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute2 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute3 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute4 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute5 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute6 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute7 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute8 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttribute9 | Segment for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOAttributeCategory | Context name for the Receipt Transaction descriptive flexfield. |
ReceivingTransactionPARPEOBillingUomCode | Identifies the billing UOM of the source document. |
ReceivingTransactionPARPEOComments | Comments entered by the user. |
ReceivingTransactionPARPEOConsignedFlag | Contains one of the following values: true or false. If true, then the receipt line is created for consigned material. If false, then the receipt line isn't created for consigned material. This attribute doesn't have a default value, but a value of null translates to false. |
ReceivingTransactionPARPEOConsumedQuantity | Quantity consumed by the supplier consigned inventory. |
ReceivingTransactionPARPEOCountryOfOriginCode | Code that identifies the country of manufacture of this item. |
ReceivingTransactionPARPEOCreatedBy | User who created the receiving transaction record. |
ReceivingTransactionPARPEOCreationDate | Date and time when the receiving transaction record was created. |
ReceivingTransactionPARPEOCurrencyCode | Code that identifies the currency that the receiving transaction uses. |
ReceivingTransactionPARPEOCurrencyConversionDate | Date when the currency conversion occurred. This value is used to derive the rates for calculating the currency conversion. |
ReceivingTransactionPARPEOCurrencyConversionRate | Rate used for currency conversion for the receipt. This value is used only for purchase order shipments. |
ReceivingTransactionPARPEOCurrencyConversionType | Type of conversion rate. This value is a fixed charge for each currency unit that's used to perform foreign currency conversions. |
ReceivingTransactionPARPEOCustomerId | Value that uniquely identifies the customer. This attribute is used for return material authorization (RMA) transactions. |
ReceivingTransactionPARPEOCustomerSiteId | Value that uniquely identifies the customer site. This attribute is used for return material authorization (RMA) transactions. |
ReceivingTransactionPARPEODefaultTaxationCountry | Code that identifies the default taxation country for the shipment line. |
ReceivingTransactionPARPEODeliverToLocationId | Value that uniquely identifies the deliver-to location. |
ReceivingTransactionPARPEODeliverToPersonId | Value that uniquely identifies the deliver-to person. |
ReceivingTransactionPARPEODestinationContext | Context name for the Destination descriptive flexfield. |
ReceivingTransactionPARPEODestinationTypeCode | Code that identifies the destination type of the receiving transaction. A list of accepted values is defined in the lookup type RCV_DESTINATION_TYPE. |
ReceivingTransactionPARPEODocumentFiscalClassification | Value that identifies the document fiscal classification. This value is also known as Tax Document Subtype. |
ReceivingTransactionPARPEOEmployeeId | Value that uniquely identifies the person who created the receiving transaction. |
ReceivingTransactionPARPEOFinalDischargeLocationId | Value that uniquely identifies the final destination for the purchase, if it's different from the ship-to location. |
ReceivingTransactionPARPEOFirstPtyRegId | Value that uniquely identifies the first party tax registration for the shipment line. |
ReceivingTransactionPARPEOFiscalDocAccessKnum | Number that identifies the access key corresponding to the fiscal document. |
ReceivingTransactionPARPEOFiscalDocHeaderId | Value that uniquely identifies the fiscal document header. |
ReceivingTransactionPARPEOFiscalDocLineId | Value that uniquely identifies the fiscal document line. |
ReceivingTransactionPARPEOFiscalDocScheduleId | Value that uniquely identifies the fiscal document schedule. |
ReceivingTransactionPARPEOFromLocatorId | Value that uniquely identifies the source locator for the receiving transaction |
ReceivingTransactionPARPEOFromSubinventory | Name of the source subinventory for the receiving transaction. |
ReceivingTransactionPARPEOGroupId | Value that uniquely identifies the interface group for set processing. All the interface records for a given value of the group identifier will be processed together. |
ReceivingTransactionPARPEOInspectionQualityCode | Code that identifies the inspection quality. This attribute references FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup type is RCV_QUALITY_CODE. |
ReceivingTransactionPARPEOInspectionStatusCode | Code that identifies the inspection status. Valid values are NOT INSPECTED, ACCEPTED, and REJECTED. |
ReceivingTransactionPARPEOIntendedUseClassifId | Value that uniquely identifies the intended use of the transaction line. This attribute identifies the purpose for which the product is used. |
ReceivingTransactionPARPEOInterfaceGroupId | Value that uniquely identifies the original interface transaction group. |
ReceivingTransactionPARPEOInterfaceSourceCode | Code that identifies the source for the interface row. |
ReceivingTransactionPARPEOInterfaceSourceLineId | Value that uniquely identifies the source line of the interface row. |
ReceivingTransactionPARPEOInterfaceTransactionId | Value that uniquely identifies the transaction interface record. |
ReceivingTransactionPARPEOInvTransactionId | Value that uniquely identifies the inventory transaction that created the in transit shipment interface transaction row. This attribute maps to INV_MATERIAL_TXNS.TRANSACTION_ID. |
ReceivingTransactionPARPEOInvoiceId | Value that uniquely identifies the transaction 857 invoice. |
ReceivingTransactionPARPEOInvoiceStatusCode | Code that identifies the advance shipment notice (ASN) with billing information (ASBN) only. This attribute indicates when the line items were rejected. |
ReceivingTransactionPARPEOJobDefinitionName | Name of the scheduled process that created or last updated the record. |
ReceivingTransactionPARPEOJobDefinitionPackage | Package name of the scheduled process that created or most recently updated the record. |
ReceivingTransactionPARPEOLastUpdateDate | Date and time when the user most recently updated the receiving receipt transaction record. |
ReceivingTransactionPARPEOLastUpdateLogin | Session login associated with the user who most recently updated the receiving receipt transaction record. |
ReceivingTransactionPARPEOLastUpdatedBy | User who most recently updated the receiving receipt transaction record. |
ReceivingTransactionPARPEOLocationId | Value that uniquely identifies the receiving location. |
ReceivingTransactionPARPEOLocatorId | Value that uniquely identifies the locator. |
ReceivingTransactionPARPEOLpnGroupId | Value that uniquely identifies the group where the transactions associated to a given license plate number (LPN) are processed automatically. |
ReceivingTransactionPARPEOLpnId | Value that uniquely identifies the source packing unit of the receiving transaction. |
ReceivingTransactionPARPEOMatchFlag | Contains one of the following values: true or false. If true, then the purchase order must be matched to an invoice. If false, then the receipt must be matched to an invoice. This attribute doesn't have a default value, but a value of null translates to false. |
ReceivingTransactionPARPEOMatchOption | Indicates whether the invoice for this transaction should be matched to the purchase order or the receipt. |
ReceivingTransactionPARPEOMovementId | Value that uniquely identifies the movement. |
ReceivingTransactionPARPEOMvtStatStatus | Status that indicates whether the transaction has been processed by the movement statistics concurrent program. |
ReceivingTransactionPARPEOObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
ReceivingTransactionPARPEOOrganizationId | Value that uniquely identifies the receiving organization where the receiving transaction is created. |
ReceivingTransactionPARPEOPaAdditionFlag | Contains one of the following values: true or false. If true, then the project related receipts have been transferred to Oracle Projects. If false, then the project related receipts haven't been transferred to Oracle Projects. This attribute doesn't have a default value, but a value of null translates to false. |
ReceivingTransactionPARPEOParentSpGroupId | Value that uniquely identifies the standard pack grouping for the parent transaction. |
ReceivingTransactionPARPEOParentTransactionId | Value that uniquely identifies the parent receiving transaction. |
ReceivingTransactionPARPEOPoDistributionId | Value that uniquely identifies the purchase order distribution. |
ReceivingTransactionPARPEOPoHeaderId | Value that uniquely identifies the purchase order header. |
ReceivingTransactionPARPEOPoLineId | Value that uniquely identifies the purchase order line. |
ReceivingTransactionPARPEOPoLineLocationId | Value that uniquely identifies the purchase order schedule. |
ReceivingTransactionPARPEOPoRevisionNum | Number of times the Purchase order has been revised. |
ReceivingTransactionPARPEOPoUnitPrice | Unit price from the purchase order line. |
ReceivingTransactionPARPEOPricingQuantity | Identifies the transaction quantity in the pricing UOM of the source document. |
ReceivingTransactionPARPEOPricingUomCode | Identifies the pricing UOM of the source document. |
ReceivingTransactionPARPEOPrimaryQuantity | Receiving transaction quantity in terms of the item's primary unit of measure (UOM). |
ReceivingTransactionPARPEOPrimaryUomCode | Code that identifies the primary unit of measure of the item in the receiving organization. |
ReceivingTransactionPARPEOProductCategory | Category of the product in the shipment line. |
ReceivingTransactionPARPEOProductFiscClassId | Value that uniquely identifies the product fiscal classification for the inventory item. |
ReceivingTransactionPARPEOProductType | Code that identifies the product type of the inventory item. Valid values are GOODS and SERVICES. |
ReceivingTransactionPARPEOProjectId | Value that uniquely identifies the project. |
ReceivingTransactionPARPEOQuantity | Receiving transaction quantity stored in the receiving transaction unit of measure (UOM). |
ReceivingTransactionPARPEOQuantityBilled | Quantity invoiced by Oracle Payables Cloud for the current receiving transaction. |
ReceivingTransactionPARPEORcptConfMessageNumber | Number that identifies the message that groups the receiving transactions communicated through a receipt confirmation. |
ReceivingTransactionPARPEORcptConfStatus | Status code that identifies the receipt confirmation sent from Oracle Receiving Cloud to the source application. Valid values include PENDING or SENT. |
ReceivingTransactionPARPEOReasonId | Value that uniquely identifies the reason. |
ReceivingTransactionPARPEOReceiptAdviceHeaderId | Value that uniquely identifies the receipt advice header. |
ReceivingTransactionPARPEOReceiptAdviceLineId | Value that uniquely identifies the receipt advice line. |
ReceivingTransactionPARPEOReceiptExceptionFlag | Contains one of the following values: Y or N. If Y, then an exception was found when creating the receiving transaction. If N, then no exception was found when creating the receiving transaction. This attribute doesn't have a default value, but a value of null translates to false. To create an exception, set the value to Y. |
ReceivingTransactionPARPEORefFiscalDocAccessKnum | Number that identifies the access key corresponding to the reference fiscal document. |
ReceivingTransactionPARPEORefFiscalDocHeaderId | Value that uniquely identifies the reference fiscal document header. |
ReceivingTransactionPARPEORefFiscalDocLineId | Value that uniquely identifies the reference fiscal document line. |
ReceivingTransactionPARPEORefFiscalDocScheduleId | Value that uniquely identifies the reference fiscal document schedule. |
ReceivingTransactionPARPEOReplenishOrderLineId | Value that uniquely identifies the replenishment sales order line for the chargeable subcontracting component. |
ReceivingTransactionPARPEOReqDistributionId | Value that uniquely identifies the requisition distribution. |
ReceivingTransactionPARPEORequestId | Value that uniquely identifies the request of the scheduled process that created or most recently updated the row. |
ReceivingTransactionPARPEORequisitionLineId | Value that uniquely identifies the requisition line. |
ReceivingTransactionPARPEORmaReference | Number that identifies the supplier's return material authorization (RMA) reference when returning goods to supplier. |
ReceivingTransactionPARPEORoutingHeaderId | Value that uniquely identifies the receipt routing. Values include 1, 2, and 3. A list of accepted values is defined in the lookup type RCV_ROUTING_HEADERS. |
ReceivingTransactionPARPEORoutingStepId | Value that uniquely identifies the receiving routing step. |
ReceivingTransactionPARPEOSecondaryQuantity | Receiving transaction quantity in the item's secondary unit of measure (UOM). |
ReceivingTransactionPARPEOSecondaryUomCode | Code that identifies the unit of measure for the secondary quantity. |
ReceivingTransactionPARPEOShipFromLocationId | Value that uniquely identifies the ship from location of the supplier site. |
ReceivingTransactionPARPEOShipmentHeaderId | Value that uniquely identifies the shipment header. |
ReceivingTransactionPARPEOShipmentLineId | Value that uniquely identifies the shipment line. |
ReceivingTransactionPARPEOSourceDocQuantity | Transaction quantity in terms of the source document's unit of measure. |
ReceivingTransactionPARPEOSourceDocUomCode | Code that identifies the source document's unit of measure. |
ReceivingTransactionPARPEOSourceDocumentCode | Code that identifies the document classification based on the originating source such as purchase order or transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. |
ReceivingTransactionPARPEOSourceTransactionNum | Number that identifies the parent source transaction. This attribute maps to SOURCE_TRANSACTION_NUM of the parent transaction and is used to derive parent_transaction_id or parent_interface_txn_id. |
ReceivingTransactionPARPEOSpGroupId | Value that uniquely identifies the grouping standard pack receipts. |
ReceivingTransactionPARPEOSpQuantity | Transaction quantity represented in terms of standard pack unit of measure. |
ReceivingTransactionPARPEOSpUomCode | Code that identifies the standard pack unit of measure. |
ReceivingTransactionPARPEOSubinventory | Name of the destination subinventory for the receiving transaction. |
ReceivingTransactionPARPEOSubstituteUnorderedCode | Code that identifies the substitute or unordered receipt. This attribute's value is SUBSTITUTE when a substitute item is received. |
ReceivingTransactionPARPEOTaskId | Value that uniquely identifies the task. |
ReceivingTransactionPARPEOTaxClassificationCode | Code that identifies the tax classification for the shipment line. |
ReceivingTransactionPARPEOTaxInvoiceDate | Date when the user generated the fiscal document. |
ReceivingTransactionPARPEOTaxInvoiceNumber | Number that identifies the fiscal document. |
ReceivingTransactionPARPEOThirdPtyRegId | Value that uniquely identifies the third party tax registration for the shipment line. |
ReceivingTransactionPARPEOTransactionDate | Date when the transaction for the receiving transactions occurred. |
ReceivingTransactionPARPEOTransactionId | Value that uniquely identifies the current receiving transaction row. |
ReceivingTransactionPARPEOTransactionId1 | Value that uniquely identifies the current receiving transaction row. |
ReceivingTransactionPARPEOTransactionType | Type of receiving transaction. This attribute references FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup type is RCV_TRANSACTION_TYPE. |
ReceivingTransactionPARPEOTransferLpnId | Value that uniquely identifies the transfer packing unit of the receiving transaction. |
ReceivingTransactionPARPEOTransferOrderHeaderId | Value that uniquely identifies the transfer order header. This attributes references INV_TRANSFER_ORDER_HEADERS.HEADER_ID. |
ReceivingTransactionPARPEOTrxBusinessCategory | Business category of the transaction for the shipment line. |
ReceivingTransactionPARPEOUomCode | Code that identifies the unit of measure in which the lot was shipped. |
ReceivingTransactionPARPEOUserDefinedFiscClass | User defined fiscal classification code for the shipment line. |
ReceivingTransactionPARPEOUserEnteredFlag | Contains one of the following values: true or false. If true, then the current receiving transaction row is user entered. If false, then the current receiving transaction row is automatically generated. This attribute doesn't have a default value, but a value of null translates to false. |
ReceivingTransactionPARPEOVendorId | Value that uniquely identifies the supplier. |
ReceivingTransactionPARPEOVendorLotNum | Number that identifies the lot given by the supplier for the purchase order receipts. |
ReceivingTransactionPARPEOVendorSiteId | Value that uniquely identifies the supplier site. |