Purchase Request Create Requisition Line Version 1
Version 1 of an object, representing the set of requisition line attributes that are being used to initiate the creation of a purchase request.
QName: {http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService/}PurchaseRequestInputReqLineInterface
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 |
|---|---|
|
Contains |
Purchase Request Create Requisition Distribution Service Data Object Version 1 |
|
Contains |
Purchase Request Create Requisition Configuration Details Version 1 |
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
Amount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total amount according to the quantities and prices of the goods and service items specified on the requisition 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. |
|
AttachmentCategoryItem |
string |
Attachments of this category provide additional information about the item being ordered and will be copied over from the source object to the purchase order line. |
|
AttachmentCategoryShip |
string |
Attachments of this category provide additional information about the shipment being scheduled, like shipping or packing instructions, and will be copied over from the source object to the purchase order schedule. |
|
AttachmentEntityName |
string |
A code indicating the object from which the attachments should be copied. |
|
AttachmentPrimaryKey1 |
string |
The unique identifier of an object from which attachments should be copied. |
|
AttachmentPrimaryKey2 |
string |
The unique identifier of an object from which attachments should be copied. |
|
AttachmentPrimaryKey3 |
string |
The unique identifier of an object from which attachments should be copied. |
|
AttachmentPrimaryKey4 |
string |
The unique identifier of an object from which attachments should be copied. |
|
AttachmentPrimaryKey5 |
string |
The unique identifier of an object from which attachments should be copied. |
|
Attribute1 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute10 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute11 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute12 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute13 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute14 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute15 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute16 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute17 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute18 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute19 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute2 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute20 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute3 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute4 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute5 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute6 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute7 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute8 |
string |
The user descriptive flexfield segment of text data type. |
|
Attribute9 |
string |
The user descriptive flexfield segment of text data type. |
|
AttributeCategory |
string |
The user descriptive flexfield structure. |
|
AttributeDate1 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate10 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate2 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate3 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate4 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate5 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate6 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate7 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate8 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeDate9 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The user descriptive flexfield attribute of date data type. |
|
AttributeNumber1 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber10 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber2 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber3 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber4 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber5 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber6 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber7 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber8 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeNumber9 |
decimal |
The user descriptive flexfield attribute of number data type. |
|
AttributeTimestamp1 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp10 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp2 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp3 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp4 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp5 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp6 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp7 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp8 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AttributeTimestamp9 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The user descriptive flexfield attribute of timestamp data type. |
|
AutosourceFlag |
boolean |
Indicates whether supplier and price information is derived from source purchase agreements. |
|
BackToBackFlag |
boolean |
Indicates whether the purchase order schedule has a backing sales order that is fulfilled using a back to back 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. |
|
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. |
|
ConfiguredItemFlag |
boolean |
Indicates whether the requisition line is for a configured item and configuration details might exist. |
|
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. |
|
DeliverToCustomerContactEmail |
string |
The email for a customer contact to which materials, being procured in a drop ship arrangement, need to be delivered. |
|
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 a 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. |
|
DestinationTypeCode |
string |
A code indicating if the item should be charged to an inventory or should be expensed. |
|
FirmFlag |
boolean |
Indicates whether or not planning can reschedule or cancel the purchase order schedule. |
|
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. |
|
GroupCode |
string |
A code indicating the option by which the requisition lines are grouped when they are being processed by the import program. Requisition lines that are grouped together will be put on the same requisition header. Valid values include none, buyer, category, item, location, and supplier. |
|
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. |
|
InterfaceLineKey |
string |
The cloud interface alternate line key code, for integrating applications to be able to identify the requisition line data loaded in the interface table. |
|
ItemDescription |
string |
A text description capturing details about the item being purchased. |
|
ItemId |
long |
The unique identifier of an item. |
|
ItemNumber |
string |
The display name of an item representing anything you make, purchase, or sell, including components, subassemblies, finished products, or supplies. |
|
ItemRevision |
string |
Identifier that indicates version of inventory item being referenced on the order line. |
|
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. |
|
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. |
|
ModeOfTransportCode |
string |
The display name of a mode of transportation used to describe the movement of goods. |
|
NegotiatedByPreparerFlag |
boolean |
Indicates whether or not the requested item is negotiated with the supplier. |
|
NegotiationRequiredFlag |
boolean |
Indicates whether or not a negotiation is required for the requested item. |
|
NewSupplierFlag |
boolean |
Indicates whether or not the supplier is new. |
|
NoteToBuyer |
string |
A text description capturing the instructions to the buyer when processing the requisition line. |
|
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 synchronizing changes between their application and Oracle Fusion Procurement. Example values include DOO_TRACKED and SCO_TRACKED. |
|
OverReceiptTolerancePercent |
decimal |
The tolerance that allows a purchase order schedule to receive more than ordered quantity or amount without triggering the over-receipt action. |
|
Price |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The price of the item on the requisition line. |
|
ProcurementBUId |
long |
The unique identifier of a procurement business unit. |
|
ProcurementBUName |
string |
The display name of a procurement business unit. |
|
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 code indicating the 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. |
|
PurchaseRequestInputReqConfigInterface |
Purchase Request Create Requisition Configuration Details Version 1 |
The purchase request input requisition configuration information. |
|
PurchaseRequestInputReqDistInterface |
The purchase request input requisition distribution information. |
|
|
Quantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity for the item to be added to the requisition. |
|
Rate |
decimal |
The ratio at which the principal unit of one currency can be converted into another currency. |
|
RateDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date as of which a conversion rate is used to convert an amount into another currency. |
|
RateType |
string |
The source of a currency conversion rate, such as user defined, spot, or corporate. For user-defined rate, provide 'USER' in the rate type. |
|
ReceiptCloseTolerancePercent |
decimal |
The percentage that the application uses to determine whether to automatically close a purchase order schedule when the receiver receives only part of the item. |
|
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. |
|
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. |
|
RequesterEmail |
string |
The email address for a requester. |
|
RequesterId |
long |
The unique identifier of a requester. |
|
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. |
|
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 |
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. |
|
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. |
|
ShipToCustomerContactEmail |
string |
The email address of a customer contact to whom materials, being procured in a drop ship arrangement, need to be shipped. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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 |
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. |
|
UrgentRequisitionLineFlag |
boolean |
Indicates whether the requisition is urgent or not. |
|
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 sequence. |
|
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. |