Purchase Order and Purchase Agreement Attributes

The tables list all the attributes within the three purchase order and purchase agreement dimensions that are available for you to create approval routing rules for the purchase order and purchase agreement attributes.

This table contains purchase order and purchase agreement header level attributes.

Attribute	Notes
Agreement Amount	Amount agreed on an agreement line between the buying and selling organization.
Agreement Amount Change	Change in agreement amount on a change order.
Agreement Amount Change Percent	Percentage by which the agreement amount has changed on a change order.
All Lines have Backing Requisition	Indicates whether all purchase order lines have backing requisition or not.
All Lines Negotiated	Indicates that prices on all the lines on the document are negotiated.
Checklist exists	Indicates that a checklist exists for the purchase order.
Checklist status	Indicates the status of the checklist for the purchase order.
Descriptive Flexfield Attribute 1-20	A character attribute available to customers to extend attributes captured on a purchase order.
Descriptive Flexfield Attribute Category	Category of the descriptive flexfield.
Descriptive Flexfield Attribute Number 1-10	A number attribute available to customers to extend attributes captured on a purchase order.
Backing Requisition Exists	Indicates whether a requisition reference exists on any distribution on the purchase order.
Bill-to Location	The location to which the supplier should send the invoice.
Buyer Managed Transportation	Indicates that the buying company is responsible for arranging the transportation.
Buyer Managed Transportation Modified	Indicates that the Buyer Managed Transportation selection has been updated.
Buyer Department	The department of the buyer specified on the purchasing document.
Buyer Grade	The job grade of the buyer specified on the purchasing document.
Buyer Job Level	The job level of the buyer specified on the purchasing document.
Buyer Job Name	The job name of the buyer specified on the purchasing document.
Buyer Position	The position of the buyer specified on the purchasing document.
Buyer	The user name of the buyer specified on the purchase order.
Carrier	A company that transports goods from one point to another by land, sea, or air.
Change in Document Ordered Amount	Change in ordered amount in document currency.
Change in Document Total Amount	Change in the total amount in document currency. The total amount is the sum of ordered amount and total exclusive tax amount.
Change in Functional Ordered Amount	Change in ordered amount in functional currency.
Change in Functional Total Amount	Change in the total amount in functional currency. The total amount is the sum of ordered amount and total exclusive tax amount.
Change Order Creation Method	The method or program by which the change order was created. Such as PDOI or Reassign Purchasing Document and so forth.
Change Order Initiating Party	The party that initiated the change order such as buyer or supplier.
Change Order Initiator User name	The user name of the change order initiator.
Change Order Type	Indicator to show whether the change order is an internal change order or an external change order. External changes are exposed to supplier and internal aren't.
Clauses Changed From Contract Template	Indicates whether any clause has changed on the document compared to the contract template in the terms library or not.
Contract Template Expired	Indicates whether the contract template on the document has expired or not.
Contract Terms Changed	Indicates whether the contract terms are changed as part of the change order.
Contract Terms Exist	Indicates whether the document has contract terms and conditions associated with it or not.
Contract Terms Template	The name of the contract terms template applied on the document.
Contractual Deliverable Exists	Indicates whether a contractual deliverable exists on the document. Contractual deliverables are commitments that must be fulfilled as part of negotiations and contractual agreements.
Contractual Deliverable Modified	Indicates whether any contractual deliverable is modified on the change order or not.
Document Cancellation Request	Indicates whether the change order is a document cancellation request or not.
Document Creation Method	The method or program by which the document was created. Such as PDOI or Online.
Document Currency	The three-letter ISO code associated with the document currency.
Document Fiscal Classification	A classification used by a tax authority to categorize a document associated with a transaction for a tax.
Document Ordered Amount	Ordered amount in document currency.
Document Style	The name of the document style, enabled for the purchasing document type, as displayed to the user.
Document Total Amount	The sum of ordered amount and total exclusive tax amount for the document in document currency.
Document Total Change Percent	Percentage by which the purchase order total amount has changed.
Document Type	The document type associated with a change order template.
End Date Modified	Indicates whether the agreement end date is modified on the change order or not.
FOB	Freight on board. The point or location where the ownership title of goods is transferred from the seller to the buyer.
FOB Modified	Indicates whether the FOB is modified on the change order or not.
Freight Terms	Indicates who pays the charge for transporting the goods by common carrier.
Freight Terms Modified	Indicates whether the freight terms are modified on the change order or not.
Functional Currency	Currency of the primary ledger of the sold-to legal entity.
Functional Ordered Amount	Ordered amount in functional currency.
Functional Total Amount	The sum of ordered amount and total exclusive tax amount for the document in functional currency.
Funds Override Approver	User who can approve the request for funds override.
Includes Outside Processing Items	Indicates whether any lines have outside processing items.
Interface Source Code	Code that indicates the outside source that the data was imported from.
Internal Purchasing Deliverable Modified	Indicates whether any internal deliverable is modified on the change order or not.
Is Change Order	Indicates if approval is being requested for a new document or a change to an existing document.
Line Status	Indicates the current status of the line.
Master Contract Exists	Indicates whether a master contract exists on the document.
Mode of Transport	Mode of Transport distinguishes substantially different ways to perform transport. For example, air, ground.
Negotiation Exists	Indicates whether a negotiation reference exists on the purchasing document line.
Nonstandard Clause Exists	Indicates whether any nonstandard clause exists on the document or not.
Nonstandard Clause Modified	Indicates whether any nonstandard clause is modified on the change order or not.
Payment Terms	Terms used to schedule payments and to calculate due dates, discount dates, and discount amounts for invoices matched against the purchase order.
Payment Terms Modified	Indicates whether the payment terms are modified on the change order or not.
PO Overriding Approver	Approver specified to override the application generated approver.
Primary Ledger of Requisitioning BU	The primary ledger associated with the requisitioning business unit.
Primary Ledger of Sold-to LE	The primary ledger associated with the sold-to legal entity.
Procurement BU	The business unit that manages and owns the purchasing document.
Requisitioning BU	The business unit that's requesting the goods or services being purchased.
Schedule Status	Indicates the current status of the schedule.
Service Level	Priority of transportation that affects how quickly the goods are transported.
Sold-to Legal Entity	The legal entity procuring goods or service in a country. The sold-to legal entity specified in the purchasing document.
Sourced to Blanket Agreement	Indicates whether a blanket purchase agreement reference exists on the purchase order line.
Sourced to Contract Agreement	Indicates whether a contract purchase agreement reference exists on the purchase order line.
Standard Clause Exists	Indicates whether any standard clause exists on the document or not.
Standard Clause Modified	Indicates whether any standard clause is modified on the change order or not.
Start Date Modified	Indicates whether the agreement start date is modified on the change order or not.
Submitter Department	The department of the submitter of the purchasing document.
Submitter Grade	The job grade of the submitter of the purchasing document.
Submitter Job Level	Job level of the submitter of the document.
Submitter Job Name	Job name of the submitter of the document.
Submitter Position	Position of the submitter of the document.
Submitter	The user name of the submitter.
Supplier	Organization or individual that provides goods or services to the buying organization for payment, bound by a contractual obligation.
Supplier Type	Type of the supplier on the purchasing document.
Supplier Site	The entity that models how the buying organization conducts business with the supplier.
Supplier Site Modified	Indicates whether the supplier site is modified on the change order or not.
Taxation Country	The country where the transaction is deemed to have taken place for taxation purposes.

This table contains purchase order and purchase agreement line level attributes.

Attributes	Notes
Agreed Price Change Percent	Percentage by which the price has changed on a purchase order line compared to the price agreed on a blanket purchase agreement.
Descriptive Flexfield Attribute 1 - 20	A character attribute available to customers to extend attributes captured on a purchase order.
Descriptive Flexfield Attribute Category	Category of the descriptive flexfield
Descriptive Flexfield Attribute Number 1 - 10	A number attribute available to customers to extend attributes captured on a purchase order.
Backing Requisition Exists	Indicates whether a requisition reference exists on any distribution associated with the purchase order line.
Catalog Name	Name of the punch out catalog.
Category Name	The name of a code used to group items with similar characteristics.
Change in Document Line Ordered Amount	Change in line ordered amount in document currency.
Change in Document Line Total Amount	Change in the line total amount in document currency. The line total amount is the sum of ordered amount and total exclusive tax amount for the line.
Change in Functional Line Ordered Amount	Change in line ordered amount in functional currency.
Change in Functional Line Total Amount	Change in the line total amount in functional currency. The line total amount is the sum of ordered amount and total exclusive tax amount for the line.
Consignment Line	Indicates whether the item on line will be purchased under consignment arrangement from a supplier.
Document Line Ordered Amount	Line ordered amount in document currency.
Document Line Total Amount	The sum of ordered amount and total exclusive tax amount for the line in document currency.
Entity Change Type	Type of change made to the line, schedule or distribution. Whether it was added, changed or canceled.
Functional Line Ordered Amount	Line ordered amount in functional currency.
Functional Line Total Amount	The sum of ordered amount and total exclusive tax amount for the line in functional currency.
Hazard Class	Name to identify and classify hazardous materials, to facilitate safety regulations compliance.
Item	Anything you make purchase or sell including components finished products or supplies.
Item Revision	The revision of the item specified on the purchase order line.
Line Agreement Amount	Amount agreed on an agreement line between the buying and selling organization.
Line Agreement Amount Change	Change in the amount agreed on an agreement line between the buying and selling organization.
Line Agreement Amount Change Percent	Percentage by which line agreement amount has changed.
Line Description Modified	Indicates whether the line description is modified on the change order or not.
Line Total Amount Change Percent	Percentage by which the line total amount has changed.
Line Type	A type to indicate whether a purchasing document line is for goods or services, as well as some default attributes associated with the line.
Negotiated	Indicates that the price on the document line is a value agreed on in advance during discussions between the buyer and the supplier.
Parent Item	The buying organization s identification number or code for the immediate parent item associated with the option or sub model.
Price	Price of the item on the document line.
Price Change Percent	Percentage by which the price has changed on a line on a change order.
Procurement Category Hierarchy Level (1 - 10)	Category hierarchy used to classify products that the organization purchases
Quantity	The ordered quantity on the purchase order line, schedule, or distribution.
Top Model	The buying organization s identification number or code for the top model item associated with the option or sub model. The top model is the item from which the configuration was built
UN Number	The United Nations identification number for the hazardous material.
UOM	A division of quantity defined as a standard of measurement or exchange.

This table includes purchase order schedule and purchase agreement price break level attributes.

Attributes	Notes
Assessable Value	The deemed price at which a product is valued, by a tax authority, for tax calculation. The same product can have more than one assessable value, as given by different tax authorities.
Back to Back Indicator	Indicates that the material to be received is being specifically purchased to fulfill a sales order from a customer
Descriptive Flexfield Attribute 1 - 20	A character attribute available to customers to extend attributes captured on a purchase order.
Descriptive Flexfield Attribute Category	Category of the descriptive flexfield
Descriptive Flexfield Attribute Number 1 - 10	A number attribute available to customers to extend attributes captured on a purchase order.
Backing Requisition Exists	Indicates whether a requisition reference exists on any distribution associated with the purchase order schedule.
Carrier	A company that transports goods from one point to another by land, sea, or air.
Change in Document Schedule Ordered Amount	Change in schedule ordered amount in document currency.
Change in Document Schedule Total Amount	Change in schedule total amount in document currency. The schedule total amount is the sum of ordered amount and total exclusive tax amount for the schedule.
Change in Functional Schedule Ordered Amount	Change in schedule ordered amount in functional currency.
Change in Functional Schedule Total Amount	Change in schedule total amount in functional currency. The schedule total amount is the sum of ordered amount and total exclusive tax amount for the schedule.
Country of Origin	The country from which goods are exported.
Destination Type	Indicator to show whether the item should be charged to an inventory or should be expensed.
Document Schedule Ordered Amount	Schedule ordered amount in document currency.
Document Schedule Total Amount	The sum of ordered amount and total exclusive tax amount for the schedule in document currency.
Entity Change Type	Type of change made to the line, schedule or distribution. Whether it was added, changed or canceled.
Functional Schedule Ordered Amount	Schedule ordered amount in functional currency.
Functional Schedule Total Amount	The sum of ordered amount and total exclusive tax amount for the schedule in functional currency.
Import Source	Indicates the source application from which the transaction was imported
Intended Use	A tax classification based on the purpose for which a product is used.
Invoice Match Option	The option that determines whether invoices for the purchase order schedule should match to the purchase order or the receipt.
Match Approval Level	The level determines how purchase order, receipt, inspection, and invoice quantities should match before the corresponding invoice can be paid.
Mode of Transport	Mode of Transport distinguishes substantially different ways to perform transport. For example. Air, Ground.
Price Change	Change in the price on a document line.
Product Category	A type of product fiscal classification used to classify products.
Product Fiscal Classification	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.
Product Type	The nature or the product involved in a taxable transaction. For example, goods or services.
Promised Delivery Date Change in Days	Days by which the promised delivery date has changed.
Promised Ship Date Change in Days	Days by which the promised ship date has changed.
Requested Delivery Date Change in Days	Days by which the requested delivery date has changed.
Requested Ship Date Change in Days	Days by which the requested ship date has changed.
Service Level	Priority of transportation that affects how quickly the goods are transported.
Schedule Total Amount Change Percent	Percentage by which the schedule total amount has changed.
Ship-to Location	The name of the location where the supplier should ship the goods.
Ship-to Location Modified	Indicates whether the ship-to location is modified on the change order or not.
Ship-to Organization	The name of the inventory organization where the supplier should ship the goods.
Shipping Method Modified	Indicates if any component of the shipping method (Carrier, Mode of Transport, and Service Level have been modified.)
Tax Classification	A grouping of taxes for reporting and processing purposes.
Transaction Business Category	A business classification used to identify and categorize an external transaction for tax purposes.
User Defined Fiscal Classification	A classification for any tax requirement that you can't define using the existing fiscal classification types.
Accrue at Receipt	Indicates whether or not the purchase order schedule will be accrued at receipt.

This table contains distribution level attributes.

Attributes	Notes
Award Contract	The display name of the award contract.
Award Owning Business Unit	The business unit that manages and owns the grant award.
Award Purpose	Description of an activity that the award is funding. For example, research or clinical trial.
Award Type	Classification of an award, for example, federal grant or private grant.
Descriptive Flexfield Attribute 1-20	A character attribute available to customers to extend attributes captured on a purchase order.
Descriptive Flexfield Attribute Category	Category of the descriptive flexfield.
Descriptive Flexfield Attribute Number 1-10	A number attribute available to customers to extend attributes captured on a purchase order.
Backing Requisition Exists	Indicates whether a requisition reference exists on the distribution.
Change in Document Distribution Ordered Amount	Change in distribution ordered amount in document currency.
Change in Document Distribution Total Amount	Change in distribution total amount in document currency. The distribution total amount is the sum of ordered amount and total exclusive tax amount for the distribution.
Change in Functional Distribution Ordered Amount	Change in distribution ordered amount in functional currency.
Change in Functional Distribution Total Amount	Change in distribution total amount in functional currency. The distribution total amount is the sum of ordered amount and total exclusive tax amount for the distribution.
Cost Center	An organizational element of a chart of accounts typically used for assigning revenues and expenses.
Cost Center Manager	The manager of a unit within an organization to which costs may be charged for accounting purposes.
Cost Center Manager User Name	The user name of the manager of a unit within an organization to which costs may be charged for accounting purposes.
Deliver-to Location	The final location where you deliver goods previously received from a supplier.
Destination Charge Account Modified	Indicates whether the destination charge account is modified on the change order or not.
Distribution Total Amount Change Percent	Percentage by which the distribution total amount has changed.
Document Distribution Ordered Amount	Distribution ordered amount in document currency.
Document Distribution Total Amount	The sum of ordered amount and total exclusive tax amount for the distribution in document currency.
Entity Change Type	Type of change made to the line, schedule or distribution. Whether it was added, changed or canceled.
Expenditure Organization	The organization that incurred the cost on the expenditure item.
Expenditure Type	A classification of cost that you assign to each expenditure item. Expenditure types are grouped into cost groups and revenue groups.
Functional Distribution Ordered Amount	Distribution ordered amount in functional currency.
Functional Distribution Total Amount	The sum of ordered amount and total exclusive tax amount for the distribution in functional currency.
Funding Source	Display name of the source of the funding that's associated to the award.
Funds Status	Status of funds check or funds reservation validation result.
Management Segment	A segment in the chart of accounts that represents an entity with management responsibility, such as the department, cost center, or line of business. Used for management reporting.
Natural Account	The segment that determines whether an account is an asset, liability, owners' equity, revenue, or expense account.
PO Charge Account	Concatenated segments of the PO charge account.
PO Charge Account Modified	Indicates whether the PO charge account is modified on the change order or not.
Primary Balancing Segment Value	An accounting flexfield segment used to automatically balance all journal entries for each value of this segment.
Primary Ledger	The primary ledger associated with the purchasing business unit.
Principal Investigator	Person responsible for the performance of the award.
Project	A finite endeavor, with specific start and finish dates, undertaken to create a product or provide a service.
Project Attributes Modified	Indicates whether project information is modified on the change order or not.
Project Manager	Owner of the project specified on the purchase order distribution.
Project Owning Business Unit	Display name of the business unit that owns the project.
Project Type	An implementation entity that defines basic project options.
Projects Billable	Indicates whether the project is billable or not.
Projects Capitalizable	Indicates whether the project is capitalizable or not.
Projects Reserved Attribute 1-10	Attribute used by Oracle Fusion Projects to extend purchase order distribution.
Projects User Defined Attribute 1-10	Reserved for user-definable project information.
Requester Department	The department of the requester specified on the purchase order distribution.
Requester Grade	The job grade of the requester specified on the purchase order distribution.
Requester Job Level	The job level of the requester specified on the purchase order distribution.
Requester Job Name	The job of the requester specified on the purchase order distribution.
Requester Level 1 -10 Supervisor	Supervisor in the supervisory hierarchy chain of the requester. Requester Level 1 Supervisor being the topmost worker on the supervisory chain.
Requester Level 1 -10 Supervisor User Name	User name of the top 10 worker in the supervisory hierarchy of the requester. Requester Level 1 Supervisor User Name being the user name of the topmost worker.
Requester Modified	Indicates whether the requester is modified on the change order or not.
Requester Position	The position of the requester specified on the purchase order.
Requester user name	The user name of the requester.
Subinventory	Subdivision of an organization, representing either a physical area or a logical grouping of items, such as a storeroom or receiving dock.
Task	The name assigned to a task. A task is subdivision of project work. Each project can have a set of top tasks and a hierarchy of subtasks below each top task.
Work Type	The name of a classification of the work associated with a task

This table contains requisition level attributes.

Attributes	Notes
Amount Exceeded Percent	Percentage by which the amount has changed on a purchase order line compared to the requisition line amount.
Negotiation Required	Indicates whether negotiation is required for the requested item or not.
Order Functional Currency	The three-letter ISO code associated with the functional currency of the document.
PO Deliver-to Person Username	The user name of the requester specified on the purchase order distribution associated with the requisition line.
PO Ordered Amount in Document Currency	The purchase order amount associated with the requisition line in document currency.
PO Ordered Amount in Functional Currency	The purchase order amount associated with the requisition line in functional currency.
PO Tax Exclusive Amount in Document Currency	Ordered amount exclusive of all the transaction taxes involved in document currency.
PO Total Amount in Document Currency	The purchase order total amount associated with the requisition line in document currency. The total amount is the sum of ordered amount and total exclusive tax amount for the document.
PO Total Amount in Functional Currency	The purchase order total amount associated with the requisition line in functional currency. The total amount is the sum of ordered amount and total exclusive tax amount for the document.
Preparer Department	The department of the preparer specified on the requisition line
Preparer Grade	The job grade of the preparer specified on the requisition line
Preparer Job Level	The job level of the preparer specified on the requisition line
Preparer Job Name	The job name of the preparer specified on the requisition line
Preparer Position	Position of the preparer of the requisition associated with the purchase order.
Preparer Username	The user name of the preparer of the requisition line.
Requisition Deliver-to Person Username	The user name of the requester of the requisition line.
Requisition Functional Currency	Functional currency of the requisition line.
Requisition Line Amount in Document Currency	Requisition line amount without tax in document currency of the requisition line.
Requisition Line Amount in Functional Currency	Requisition line amount without tax in functional currency of the requisition line.
Requisition Line Amount with Tax in Document Currency	Requisition line amount with tax in document currency of the requisition line.
Requisition Line Amount with Tax in Functional Currency	Requisition line amount with tax in functional currency of the requisition line.
Requisition Line Amount without Tax in Document Currency	Requisition line amount without tax in document currency of the requisition line.
Requisition Line Amount without Tax in Functional Currency	Requisition line amount without tax in functional currency of the requisition line.
Requisition Overriding Approver	The overriding approver of the requisition.
Smart Form	Name of a special request form.

How You Configure Purchasing Document Notification Titles

You can include additional contextual information such as supplier name, document totals, and document descriptions in your purchasing document approval notification titles.

This table contains attributes that you can include in approval notification titles.

Attributes	Notes
AddAttachmentStatus	Indicates the status of the attachment.
CODescription	Description of the change order.
CONumber	Number that identifies the change order. It is unique per change order per document. This starts with 0 and increments by 1 for each new change order created for the document.
COSequence	Sequence number for each change order. This is internally generated.
DocumentCurrencyApprovalTotal	Value that indicates calculated total amount including tax in document currency and is formatted based on the currency specification provided in the user preferences setup.
DocumentCurrencyApprovalTotalUnformatted	Value that indicates the total amount including tax in document currency without formatting.
DocumentCurrencyCode	Abbreviation that identifies the document currency of the purchasing document.
DocumentCurrencyOrdered	The ordered amount in document currency and is formatted based on the currency specification provided in the user preferences setup.
DocumentCurrencyOrderedUnformatted	The ordered amount in document currency without formatting.
DocumentID	Value that uniquely identifies the purchase order or an agreement.
DocumentNumber	Number that identifies the purchase order or an agreement.
DocumentStyle	Name of the purchasing document style. This attribute allows organizations to control the parameters and values displayed on the application to match the usage of the purchasing document.
DocumentType	Indicates if the document is a purchase order, blanket purchase agreement, or contract purchase agreement.
DraftOrChangeOrder	Indicates if the purchasing document is a draft or a change to an existing document.
FunctionalCurrencyApprovalTotal	The total amount including tax in the currency of the primary ledger of the sold-to legal entity and is formatted based on the currency specification provided in the user preferences setup.
FunctionalCurrencyApprovalTotalUnformatted	The total amount including tax without formatting in the currency of the primary ledger of the sold-to legal entity.
FunctionalCurrencyCode	Abbreviation that identifies the functional currency of the purchasing document
FunctionalCurrencyOrdered	The ordered amount in the currency of the primary ledger of the sold-to legal entity and is formatted based on the currency specification provided in the user preferences setup.
FunctionalCurrencyOrderedUnformatted	The ordered amount in the currency of the primary ledger of the sold-to legal entity without formatting.
FundsOverrideApprover	User who can approve the request for funds override.
PODescription	Description of the purchase order.
SupplierName	Name of the supplier who fulfils the item.
TitleKey	Indicates the notification title.
TaskName	The name assigned to a task. A task is subdivision of project work. Each project can have a set of top tasks and a hierarchy of subtasks below each top task.