Purchase Request Get Confirmation Version 1

Version 1 of an object, representing the attributes that are returned when the purchase request get operation is completed.

QName: {http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService/}PurchaseRequestGetResult

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handled by

Purchase Request Service Version 1

Attributes

The following table describes attributes in the service data object.

Name Type Description

AllowSubstituteReceiptsFlag

boolean

Indicates whether the purchase order schedule can receive substitute item in place of an ordered item.

Amount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The total amount of the order according to the quantities and prices of the goods and service items specified on the order line.

AssessableAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities.

BackToBackFlag

boolean

Indicates whether the purchase order schedule has a backing sales order that is fulfilled using a back to back order.

BaseLineChangeOrderNumber

string

The display number used to identify a purchase order change order.

BaseLineChangeOrderSequence

long

The unique identifier of a purchase order change order.

BaseModelId

long

The unique identifier of a model from which an ATO configuration was created.

BaseModelNumber

string

The display name of a model from which an ATO configuration was created.

BaseModelPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The model price from which an ATO configuration was created.

BuyerEmail

string

The email address of the buyer specified on the document. A buyer is a person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.

BuyerId

long

The unique identifier of the buyer specified on the document. A buyer is a person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.

BuyerName

string

The display name of a buyer specified on the document. A buyer is a person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.

CancelReason

string

A text description capturing user entered comments provided during a cancellation request.

Carrier

string

The display name of the company that transports goods from one point to another by land, sea, or air.

CarrierId

long

The unique identifier of the company that transports goods from one point to another by land, sea, or air.

CategoryId

long

The unique identifier of the code used to group items with similar characteristics.

CategoryName

string

The display name of a category used to group items with similar characteristics.

ChangeOrderDescription

string

A text description capturing the reason or purpose of the change order.

ChangeOrderInitiatingParty

string

A code indicating the party who originated the purchase document change request. Valid values include requester, buyer, and supplier.

ChangeReason

string

A text description capturing the reason for changing the entity.

ChangeTypeCode

string

A code indicating the type of change completed. Valid values include split, order canceled, request canceled, or changed. Order canceled indicates that the purchase order schedule is canceled and the backing requisition line is reinstated. Request canceled indicates that the both the purchase order schedule and backing requisition line are canceled.

ConsignmentLineFlag

boolean

Indicates whether the item will be purchased under consignment arrangement from supplier. A consignment arrangement is a business process wherein material that is in the possession of one party (for example, customers, dealers, agents), remains the property of another party (for example, the manufacturer), by agreement with those in possession until the material is consumed.

CountryOfOrigin

string

The display name of a country from which goods are exported.

CountryOfOriginCode

string

A code indicating the country from which goods are exported.

CurrencyCode

string

A code indicating the three-letter ISO code associated with a currency.

CustomerItemDescription

string

A text description capturing a customer's identification number or code for the goods ordered on your order line.

CustomerItemNumber

string

The display name of a customer's identification number or code for the goods ordered on your order line.

CustomerPOLineNumber

string

The display number used to identify a purchase order line from the customer that originated the sales order, which is being fulfilled by the material being procured in a drop ship arrangement.

CustomerPONumber

string

The display number used to identify a purchase order from the customer that originated the sales order, which is being fulfilled by the material being procured in a drop ship arrangement.

CustomerPOScheduleNumber

string

The display number used to identify a purchase order schedule from the customer that originated the sales order, which is being fulfilled by the material being procured in a drop ship arrangement.

DaysEarlyReceiptAllowed

decimal

The maximum acceptable number of days early for receipts.

DaysLateReceiptAllowed

decimal

The maximum acceptable number of days late for receipts.

DeliverToCustomerContactId

long

The unique identifier of a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.

DeliverToCustomerContactName

string

The display name of a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.

DeliverToCustomerContactNumber

string

The display number used to identify a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered.

DeliverToCustomerId

long

The unique identifier of a customer to which materials, being procured in a drop ship or back to back arrangement, need to be delivered.

DeliverToCustomerLocationCLLICode

string

The CLLI code for the customer location to which materials, being procured in a drop ship arrangement, need to be delivered.

DeliverToCustomerLocationId

long

The unique identifier of a customer location to which materials, being procured in a drop ship arrangement, need to be delivered.

DeliverToCustomerLocationOriginalSystemReference

string

The original system reference for the customer location to which materials, being procured in a drop ship arrangement, need to be delivered.

DeliverToCustomerName

string

The display name of a customer to which materials, being procured in a drop ship or back to back arrangement, need to be delivered.

DeliverToCustomerNumber

string

The display number used to identify a customer to which materials, being procured in a drop ship or a back to back arrangement, need to be delivered.

DeliverToLocationCode

string

A code indicating the final delivery location for goods previously received from a supplier.

DeliverToLocationId

long

The unique identifier of a final delivery location for goods previously received from a supplier.

DeliverToOrganizationCode

string

A code indicating the organization to which the requested item should be delivered.

DeliverToOrganizationId

long

The unique identifier of an organization to which the requested item should be delivered.

DestinationSubinventory

string

The display name of a subinventory to which the requested item should be delivered.

DestinationType

string

The display name indicating if the item should be charged to an inventory or should be expensed.

DestinationTypeCode

string

A code indicating if the item should be charged to an inventory or should be expensed.

DocumentFiscalClassification

string

A classification used by a tax authority to categorize a document associated with a transaction for a tax.

DocumentFiscalClassificationCode

string

A classification used by a tax authority to categorize a document associated with a transaction for a tax.

DocumentStatus

string

The display name of a purchase order state relative to the entire document lifecycle.

DocumentStatusCode

string

A code indicating the state that the purchase order is in relative to the entire document lifecycle.

EarliestDeliveryDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The first day that the buying company will accept the delivery of the ordered goods.

EarliestShipDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The first day that the buying company will accept the requested goods to be shipped.

FirstPartyTaxRegistrationId

long

The unique identifier of the tax registration record corresponding to the sold-to legal entity on the purchase order.

FirstPartyTaxRegistrationNumber

string

The unique display number assigned to the sold-to legal entity by a tax authority in order to manage tax liabilities.

FrozenFlag

boolean

Indicates whether or not a user is allowed to create a change order on the document.

HazardClass

string

The display name of a classification of hazardous materials, to facilitate safety regulations compliance.

HazardClassId

long

The unique identifier of a classification of hazardous materials, to facilitate safety regulations compliance.

InterfaceSourceCode

string

A code indicating the outside source that the data was imported from. Reserved values for internal use include ORA_FUSION_DOO, ORA_FUSION_SCO, ORA_FUSION_INV.

ItemDescription

string

A text description capturing details about the item being purchased.

ItemId

long

The unique identifier of an item.

ItemNumber

string

The display number of an item representing anything you make, purchase, or sell, including components, subassemblies, finished products, or supplies.

ItemRevision

string

Identifier that indicates the version of inventory item being referenced on the order line.

LatestDeliveryDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The last day by when the buying company will accept the delivery of the ordered goods.

LatestShipDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The last day by when the buying company will accept the delivery of the ordered goods.

LineIntendedUse

string

A code indicating the type of the tax classification that is based on the purpose for which a product is used.

LineIntendedUseId

long

The unique identifier of a tax classification that is based on the purpose for which a product is used.

LineIntendedUseName

string

The display name of a tax classification that is based on the purpose for which a product is used.

LineLocationId

long

The unique identifier of a purchase order schedule.

LineNumber

decimal

The display number used to identify a purchase order line.

LineType

string

The display name of a line type that indicates whether a purchase is for goods or services.

LineTypeId

long

The unique identifier of a type to indicate whether a purchasing document line is for goods or services, as well as to default some attributes associated with the line.

LocationOfFinalDischargeCode

string

A code indicating the final destination location for the purchases made by the customer. The location of the final customer, or where the goods would be used, is not necessarily the same as the initial ship-to location.

LocationOfFinalDischargeId

long

The unique identifier of a final destination location for the purchases made by the customer. The location of the final customer, or where the goods would be used, is not necessarily the same as the initial ship-to location.

ModeOfTransport

string

The display name of a mode of transportation used to describe the movement of goods.

ModeOfTransportCode

string

A code indicating the various modes of transportation used for the movement of goods.

MultipleDistributionsOnPOFlag

boolean

Indicates whether or not there are multiple distributions associated with the purchase order schedule.

NoteToReceiver

string

A text description capturing the instructions to the receiver in the docking area, to be reviewed while performing the receipt.

NoteToSupplier

string

A text description capturing the instructions to the supplier.

OrchestrationCode

string

A code indicating if the integrating application is orchestrating changes between their application and Oracle Fusion Procurement. Example values include DOO_TRACKED and SCO_TRACKED.

OrderDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The day when the purchase order was first communicated, acknowledged, or implemented.

OrderNumber

string

The unique identifier of an order in a sold-to BU.

OrderRevision

decimal

The display number used to identify a purchase order revision.

OriginalPromisedDeliveryDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The first promised delivery day that is recorded for a purchase order schedule.

OriginalPromisedShipDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The first promised ship day that is recorded for a purchase order schedule.

OverReceiptAction

string

The display name of how to handle receipts that exceed the received quantity tolerance.

OverReceiptActionCode

string

A code indicating how to handle receipts that exceed the received quantity tolerance.

OverReceiptTolerancePercent

decimal

The tolerance that allows a purchase order schedule to receive more than ordered quantity or amount without triggering the over-receipt action.

POHeaderId

long

The unique identifier of a purchasing document.

POLineId

long

The unique identifier of a purchasing document line.

ParentLineLocationId

long

The unique identifier of a schedule that has been split to create a new schedule.

Price

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The price of the item on the document line.

ProductCategory

string

A code indicating the type of product fiscal classification used to classify products.

ProductCategoryName

string

The display name of a product fiscal classification type used to classify products.

ProductFiscalClassification

string

A classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required.

ProductFiscalClassificationId

long

The unique identifier of a classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required.

ProductFiscalClassificationName

string

The display name of a classification used by a tax authority to categorize a product for a tax. There could be more than one by tax. For example, for Brazil two classifications are required.

ProductType

string

A code indicating the type of product fiscal classification used to classify products. Related term(s): product fiscal classification.

ProductTypeName

string

The display name of a product fiscal classification type used to classify products.

PromisedDeliveryDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

A date that the supplier has promised to deliver the ordered item or service.

PromisedDeliveryDateUTC

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

A date in UTC by when the supplier has promised to deliver the ordered item or service.

PromisedShipDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

A date by when the supplier has promised to ship the item ordered by the buying company.

PromisedShipDateUTC

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

A date in UTC by when the supplier has promised to ship the item ordered by the buying company.

Quantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The ordered quantity for the purchase order schedule.

ReceiptDateExceptionAction

string

The display name of an action that is triggered when the ordered quantity or amount is not yet received before the late receipt tolerance days.

ReceiptDateExceptionActionCode

string

A code indicating the action that is triggered when the ordered quantity or amount is not yet received before the late receipt tolerance days.

ReceiptRouting

string

The display name of a method used to simplify transaction entry by specifying routing steps for receipts.

ReceiptRoutingId

long

The unique identifier of a method of simplifying transaction entry by specifying routing steps for receipts.

ReferenceNumber

string

The display number used to identify an imported purchase order from a legacy system.

ReinstatedRequisitionLine

decimal

The display number used to identify a requisition line that was created to hold the unfulfilled quantity of a canceled order schedule, before processing it in a new order.

ReinstatedRequisitionLineId

long

The unique identifier of the requisition line that was created to hold the unfulfilled quantity of a canceled order schedule, before processing it in a new order.

ReinstatedRequisitionLineQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The quantity of a requisition line that was created to hold the unfulfilled quantity of a canceled order schedule, before processing it in a new order.

RequestedDeliveryDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the buying company has requested the ordered item or service to be delivered.

RequestedDeliveryDateUTC

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

A date in UTC when the buying company requests the ordered item or service to be delivered.

RequestedShipDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the buying company has requested the ordered item is ready to be shipped.

RequestedShipDateUTC

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date in UTC when the buying company has requested the ordered item is ready to be shipped.

RequesterEmail

string

The email address for a requester.

RequesterId

long

The unique identifier of a requester.

RequesterName

string

The display name of a requester.

RequisitionHeaderId

long

The unique identifier of a requisition.

RequisitionLine

decimal

The display number used to identify a requisition line.

RequisitionLineId

long

The unique identifier of a requisition line.

RequisitionNumber

string

The display number used to identify a requisition.

RequisitioningBUId

long

The unique identifier of a requisitioning business unit.

RequisitioningBUName

string

The display name of a requisitioning business unit.

SalesOrderLineNumber

string

The display number used to identify a backing customer sales order line number.

SalesOrderNumber

string

The display number used to identify a backing customer sales order number.

SalesOrderScheduleNumber

string

The display number used to identify a backing customer sales order schedule number.

ScheduleNumber

decimal

The display number used to identify a purchase order schedule associated with a line.

ScheduleStatus

string

The display name of a purchase order schedule state relative to the entire schedule lifecycle.

ScheduleStatusCode

string

A code indicating the state that the purchase order schedule is in relative to the entire schedule lifecycle.

SecondaryQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The quantity converted in the secondary unit of measure of a dual UOM controlled item.

SecondaryUOM

string

The display name of an alternative unit of measure that is allowed to quantify a dual UOM controlled item.

SecondaryUOMCode

string

A code indicating the alternative unit of measure that is allowed to quantify a dual UOM controlled item.

SelectedOptionsPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The price of the option. An option is a configurable add-on that is part of a larger configuration.

ServiceLevel

string

The display name of a transportation priority that affects how quickly goods are transported. Applicable values are all meanings of the lookup Carrier Service Levels.

ServiceLevelCode

string

A code indicating the priority of transportation that affects how quickly goods are transported. Applicable values are all codes of the lookup Carrier Service Levels.

ShipToCustomerContactId

long

The unique identifier of a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.

ShipToCustomerContactName

string

The display name of a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.

ShipToCustomerContactNumber

string

The display number used to identify a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped.

ShipToCustomerId

long

The unique identifier of a customer to whom materials, being procured in a drop ship or a back to back arrangement need to be shipped.

ShipToCustomerLocationCLLICode

string

The CLLI Code for the customer location where materials, being procured in a drop ship arrangement, need to be shipped.

ShipToCustomerLocationId

long

The unique identifier of a customer location where materials, being procured in a drop ship arrangement, need to be shipped.

ShipToCustomerLocationOriginalSystemReference

string

The original system reference for the customer location where materials, being procured in a drop ship arrangement, need to be shipped.

ShipToCustomerName

string

The display name of a customer to whom materials, being procured in a drop ship or a back to back arrangement, need to be shipped.

ShipToCustomerNumber

string

The display number used to identify a customer to whom materials, being procured in a drop ship or a back to back arrangement, need to be shipped.

ShipToExceptionAction

string

The display name of how to handle receipts when the receiving location differs from the ship-to location.

ShipToExceptionActionCode

string

A code indicating how to handle receipts when the receiving location differs from the ship-to location.

ShipToLocationCode

string

A code indicating the location where the supplier should ship the goods.

ShipToLocationId

long

The unique identifier of a location where the supplier should ship the goods.

ShipToOrganizationCode

string

A code indicating the inventory organization where the supplier should ship the goods.

ShipToOrganizationId

long

The unique identifier of an inventory organization where the supplier should ship the goods.

ShipToOrganizationName

string

The display name of an inventory organization where the supplier should ship the goods.

SoldToLegalEntityId

long

The unique identifier of a legal entity that is liable for the purchase order amount.

SoldToLegalEntityName

string

The display name of a legal entity that is liable for the purchase order amount.

SourceAgreementId

long

The unique identifier of a purchase agreement against which this purchase order line is released.

SourceAgreementLineId

long

The unique identifier of a purchase agreement line against which this purchase order line is released.

SourceAgreementLineNumber

decimal

The display number used to identify a purchase agreement line against which this purchase order line is released.

SourceAgreementNumber

string

The display number used to identify a purchase agreement against which this purchase order line is released.

SupplierContactEmail

string

The email address for a supplier employee who represents the supplier in communications with the buying organization.

SupplierContactFax

string

The fax number for a supplier employee who represents the supplier in communications with the buying organization.

SupplierContactId

long

The unique identifier of a supplier employee who represents the supplier in communications with the buying organization.

SupplierContactName

string

The display name of a supplier employee who represents the supplier in communications with the buying organization.

SupplierContactPhone

string

The phone number for a supplier employee who represents the supplier in communications with the buying organization.

SupplierId

long

The unique identifier of an organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.

SupplierItemNumber

string

The display name of a supplier's identification number or code for the goods ordered on your order line.

SupplierName

string

The display name of an organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.

SupplierNumber

string

The display number used to identify an organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.

SupplierOrderLineNumber

string

The display number of the document line that the supplier has created in its system against a purchase order schedule.

SupplierOrderNumber

string

The display number of the document that the supplier has created in its system against the purchase order.

SupplierSiteId

long

The unique identifier of an entity that models how the buying organization conducts business with the supplier.

SupplierSiteName

string

The display name of an entity that models how the buying organization conducts business with the supplier.

TaxClassificationCode

string

A code indicating the group of taxes for reporting and processing purposes.

TaxClassificationName

string

The display name of a group of taxes for reporting and processing purposes.

TaxationCountry

string

The display name of a country where the transaction is deemed to have taken place for taxation purposes.

TaxationCountryCode

string

A code indicating the country where the transaction is deemed to have taken place for taxation purposes.

ThirdPartyTaxRegistrationId

long

A unique identifier of the registration number assigned to the supplier or supplier site, when it is registered by a tax authority, and by which the party or party site registration will be identified.

ThirdPartyTaxRegistrationNumber

string

A unique sequence of letters and/or numbers assigned to the supplier or supplier site, when it is registered by a tax authority, and by which the party or party site registration will be identified.

TotalAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The sum of the ordered amount and the total tax amount.

TotalTaxAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The sum of the recoverable and non-recoverable tax amounts.

TransactionBusinessCategory

string

A code indicating the business classification used by Oracle Fusion Tax to identify and categorize an external transaction into an Oracle Fusion Tax transaction.

TransactionBusinessCategoryName

string

The display name of a business classification used by Oracle Fusion Tax to identify and categorize an external transaction into an Oracle Fusion Tax transaction.

UNNumber

string

The display name of a United Nations identification number for the hazardous material.

UNNumberId

long

The unique identifier of a United Nations identification number for the hazardous material.

UnitOfMeasure

string

The display name of a division of quantity defined as a standard of measurement or exchange.

UnitOfMeasureCode

string

A code indicating the division of quantity defined as a standard of measurement or exchange.

UserDefinedFiscalClassification

string

A coding indicating the classification for any tax requirement that you cannot define using the existing fiscal classification types.

UserDefinedFiscalClassificationName

string

The display name of a classification for any tax requirement that you cannot define using the existing fiscal classification types.

WorkOrderId

long

The unique identifier of a contract manufacturing work order.

WorkOrderNumber

string

The display number used to identify the finished goods product of a contract manufacturing work order.

WorkOrderOperationId

long

The unique identifier of a work order operation.

WorkOrderOperationSequence

decimal

The display number used to identify the work order operation sequence.

WorkOrderProduct

string

The display name of the finished goods product of the contract manufacturing work order.

WorkOrderSubTypeCode

string

A code indicating the work order operation subtype.