DraftPurchaseOrders
Maintains partially completed purchase orders not yet communicated to suppliers, tracking preliminary details for further updates.
Table-Specific Information
Select
The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.
For example, the following query is processed server-side:
SELECT * FROM [Cdata].[Procurement].[DraftPurchaseOrders] WHERE POHeaderId = 10003
Insert
Create an DraftPurchaseOrder.
INSERT INTO DraftPurchaseOrders(Currency,ProcurementBU,RequisitioningBUId,Buyer,Supplier,SupplierSite,BillToLocation,PayOnReceiptFlag,BuyerManagedTransportFlag,RequiredAcknowledgment,SupplierCommunicationMethod) VALUES ('US Dollar','US1 Business Unit',300000046987012,'Roth, Calvin','EIP Inc','EIP Inc','Seattle',false,true,'None','NONE')
You can also add aggregates with the parent table, using TEMP table and aggregates. Refer to Invoices.
Update
The Oracle Fusion Cloud Financials API uses POHeaderUniqId instead of POHeaderId as a path parameter in the URL to update the record.
If you want to update a record directly using the Id (without any other filter), you can update the record in the following way:
Update [Cdata].[Procurement].[DraftPurchaseOrders] set Description='abcd' WHERE POHeaderUniqId=454545454;
Note: This does not require an extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter, use POHeaderId instead of POHeaderUniqId. You can update the record in the following way:
Update [Cdata].[Procurement].[DraftPurchaseOrders] set Description='abcd' WHERE POHeaderUniqId=454545454 and BuyerId=445128;
Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.
Delete
The Oracle Fusion Cloud Financials API uses POHeaderUniqId instead of POHeaderId as a path parameter in the URL to delete the record.
If you want to delete a record directly using the Id (without any other filter), you can delete the record in the following way:
DELETE FROM [Cdata].[Procurement].[DraftPurchaseOrders] WHERE POHeaderUniqId=454545454;
Note: This does not require an extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter, use POHeaderId instead of POHeaderUniqId. You can delete the record in the following way:
DELETE FROM [Cdata].[Procurement].[DraftPurchaseOrders] WHERE POHeaderId=454545454 and BuyerId=445128;
Columns
| Name | Type | ReadOnly | Description |
| POHeaderId [KEY] | Long | True |
The unique identifier for the header of a draft purchase order, used to reference the overall purchase order document. |
| POHeaderUniqId [KEY] | String | True |
A unique identifier for the draft purchase order header that should be used for insert, update, and delete operations, instead of using the POHeaderId. |
| OrderNumber | String | False |
The number that uniquely identifies a purchase order within the sold-to legal entity, typically used for tracking and referencing the order. |
| Description | String | False |
A text description of the purchase order, providing more context about the order's purpose or content. |
| DocumentStyleId | Long | False |
The unique identifier for the style of the purchasing document, helping to distinguish between different document formats or layouts. |
| DocumentStyle | String | False |
The name of the purchasing document style, used to control the parameters and values displayed on the application to match the document’s intended use. |
| StatusCode | String | False |
An abbreviation identifying the status of the purchase order within its lifecycle, which helps categorize its current state. |
| Status | String | True |
The current status of the draft purchase order, indicating whether it is in a draft, pending, or finalized state. |
| ProcurementBUId | Long | False |
The unique identifier for the business unit responsible for managing and owning the purchase order. |
| ProcurementBU | String | False |
The name of the business unit that is responsible for managing and owning the purchase order. |
| RequisitioningBUId | Long | False |
The unique identifier for the business unit that is responsible for creating the requisition linked to the purchase order. |
| RequisitioningBU | String | False |
The name of the business unit that is responsible for creating the requisition from which the purchase order is derived. |
| BuyerId | Long | False |
The unique identifier for the buyer who is responsible for managing the purchase order. |
| Buyer | String | False |
The name of the person who is responsible for managing the purchase order, typically overseeing its creation and processing. |
| BuyerEmail | String | False |
The email address of the buyer, allowing communication and notifications regarding the purchase order. |
| CurrencyCode | String | False |
The abbreviation for the currency used in the purchase order, typically using ISO 4217 codes. |
| Currency | String | False |
The currency used for the purchase order, which determines how amounts are calculated and paid. |
| ConversionRateTypeCode | String | False |
An abbreviation identifying the type of conversion rate applied when converting currencies in the purchase order. |
| ConversionRateType | String | False |
The type of conversion rate used by the application to determine the exchange rate for converting one currency into another. |
| ConversionRateDate | Date | False |
The specific date used for determining the conversion rate, as exchange rates may vary by date. |
| ConversionRate | Decimal | False |
The actual conversion rate used to convert between currencies for the purchase order. |
| SupplierId | Long | False |
The unique identifier for the supplier fulfilling the items or services listed on the purchase order. |
| Supplier | String | False |
The name of the supplier responsible for delivering the items or services listed on the purchase order. |
| SupplierSiteId | Long | False |
The unique identifier for the supplier's site, which represents the location from where the supplier will fulfill the order. |
| SupplierSite | String | False |
The name of the supplier's site, indicating the location from where the supplier will ship the goods. |
| SupplierCommunicationMethod | String | False |
The method used to communicate the purchase order to the supplier, such as email, fax, or other communication channels. |
| SupplierFax | String | False |
The fax number used to communicate the purchase order to the supplier, in case fax is the preferred communication method. |
| SupplierOrder | String | True |
The supplier-specific order number, which links to the purchase order for tracking or reference purposes. |
| SupplierEmailAddress | String | False |
The email address of the supplier for communication related to the purchase order. |
| SoldToLegalEntityId | Long | False |
The unique identifier for the legal entity that is financially responsible for the purchase order, used for invoicing and legal purposes. |
| SoldToLegalEntity | String | False |
The name of the legal entity that is financially responsible for the purchase order, typically the entity making the purchase. |
| BillToBUId | Long | False |
The unique identifier for the business unit responsible for processing supplier invoices related to the purchase order. |
| BillToBU | String | False |
The name of the business unit responsible for processing supplier invoices for the purchase order. |
| BillToLocationId | Long | False |
The unique identifier for the location where the supplier sends the invoice, which can be different from the physical shipping address. |
| BillToLocation | String | False |
The location where the supplier is instructed to send invoices for payment. |
| BillToLocationInternalCode | String | False |
An internal abbreviation or code used to identify the bill-to location, typically for internal reference. |
| DefaultShipToLocationId | Long | False |
The unique identifier for the default location where goods should be shipped. |
| DefaultShipToLocation | String | False |
The name of the location where the supplier is expected to ship the items or goods. |
| DefaultShipToLocationInternalCode | String | False |
Abbreviation that internally identifies the default value of the ship-to location where the supplier should ship the goods. |
| MasterContractId | Long | False |
Value that uniquely identifies the contract from enterprise contracts. This attribute allows a direct connection between execution documents in Oracle Purchasing Cloud and high-level contracts in Oracle Enterprise Contracts Cloud. |
| MasterContractNumber | String | False |
Number that identifies the contract from enterprise contracts. This attribute allows a direct connection between execution documents in Oracle Purchasing Cloud and high-level contracts in Oracle Enterprise Contracts Cloud. |
| MasterContractTypeId | Long | False |
Value that uniquely identifies the contract type. This attribute specifies the nature of the enterprise contract. The contract type specifies what kind of information you can enter, including the presence of lines and contract terms. |
| MasterContractType | String | False |
Type of contract. This attribute specifies the nature of the enterprise contract. The contract type specifies what kind of information you can enter, including the presence of lines and contract terms. |
| RequiredAcknowledgmentCode | String | False |
Abbreviation that identifies the acknowledgment that the purchase order requires from the supplier. Values include Y for document and schedule, D for document, or N for none. |
| RequiredAcknowledgment | String | False |
Acknowledgment that the application requires from the supplier. Values include 'Document and Schedule' (supplier must acknowledge the header and schedule of the purchase order), 'Document' (supplier must acknowledge the header of the purchase order), or 'None' (the purchase order does not require acknowledgment). |
| AcknowledgmentDueDate | Date | False |
Date when the application requests the supplier to acknowledge the purchase order. |
| AcknowledgmentWithinDays | Decimal | False |
Number of days for the supplier to decide to accept or reject the purchase order. |
| BuyerManagedTransportFlag | Bool | False |
Contains one of the following values: true or false. If true, then the buyer or an agent that the buyer designates must arrange transportation from picking up the requested item to delivering it to the ship-to location that the purchase order specifies. If false, then the supplier must arrange transportation. This attribute does not have a default value. |
| RequiresSignatureFlag | Bool | False |
Contains one of the following values: true or false. If true, then the purchase order requires signatures to meet legal requirements. If false, then the purchase order does not require signatures. This attribute does not have a default value. |
| PendingSignatureFlag | Bool | True |
Indicates whether the purchase order is awaiting a signature, used for tracking purposes. |
| PaymentTermsId | Long | False |
The unique identifier for the payment terms that define when and how the supplier will be paid. |
| PaymentTerms | String | False |
The payment terms for the purchase order, which govern when payments are made, including discount dates and due dates. |
| FOBCode | String | False |
An abbreviation identifying the type of freight on board term applied to the order, such as 'CIF' or 'FOB'. |
| FOB | String | False |
The location where the ownership of goods transfers from the supplier to the buyer during shipping. |
| FreightTermsCode | String | False |
An abbreviation identifying the freight terms for the purchase order, which determine who bears the cost of shipping. |
| FreightTerms | String | False |
The terms that define who is responsible for paying the freight charges associated with the shipment. |
| SupplierContactId | Long | False |
The unique identifier for the supplier contact, who is responsible for managing communications regarding the purchase order. |
| SupplierContact | String | False |
The name of the contact person representing the supplier, who communicates with the buyer. |
| NoteToSupplier | String | False |
A note directed to the supplier providing instructions or additional details on how to process the purchase order. |
| NoteToReceiver | String | False |
A note directed to the receiver providing instructions or additional details on how to process the items upon arrival. |
| CarrierId | Long | False |
The unique identifier for the carrier company that transports the items by land, sea, or air. |
| Carrier | String | False |
The name of the carrier company responsible for transporting the items. |
| ModeOfTransportCode | String | False |
An abbreviation identifying the mode of transport used by the carrier, such as 'Air' or 'Sea'. |
| ModeOfTransport | String | False |
The mode of transport used by the carrier, such as air, sea, or land. |
| ServiceLevelCode | String | False |
An abbreviation identifying the service level for the shipping method, such as 'Overnight' or 'Standard'. |
| ServiceLevel | String | False |
The service level describing how quickly the items need to be shipped, such as 'Express' or 'Economy'. |
| ConfirmingOrderFlag | Bool | False |
Contains one of the following values: true or false. If true, then the purchase order is communicated verbally before the supplier receives the purchase order. If false, then there is no verbal communication before sending the purchase order. This attribute does not have a default value. |
| PayOnReceiptFlag | Bool | False |
Contains one of the following values: true or false. If true, then the application creates an invoice that requests payment for the item according to the receipt transaction. If false, then the application does not require the supplier to create this invoice and instead requests payment according to the receipt of the shipped item. This attribute does not have a default value. |
| DocumentCreationMethod | String | False |
The method by which the purchase order document was created, such as manually, automatically, or by using a template. |
| ShippingMethod | String | False |
The method of transportation chosen for the order, detailing the carrier and service level, such as 'Air - Express'. |
| DefaultTaxationCountryCode | String | False |
The abbreviation identifying the country used for taxation purposes for the purchase order. |
| DefaultTaxationCountry | String | False |
The country in which the transaction is subject to tax, used for calculating tax liabilities. |
| FirstPartyRegistrationId | Long | False |
The unique identifier for the first party registration number, used for tax reporting. |
| FirstPartyRegistrationNumber | String | False |
Value that is a unique sequence of letters or numbers assigned to a first party by a tax authority when it is registered. This attribute is used to identify the first party registration. |
| ThirdPartyRegistrationId | Long | False |
Value that uniquely identifies the third party registration. |
| ThirdPartyRegistrationNumber | String | False |
Value that is a unique sequence of letters or numbers assigned to a third party or third-party site by a tax authority. This attribute is used to identify the party or party-site level tax registration. |
| DocumentFiscalClassificationId | Long | False |
The unique identifier for the fiscal classification of the document, which affects tax categorization. |
| DocumentFiscalClassificationCode | String | False |
An abbreviation identifying the fiscal classification applied to the document for tax purposes. |
| DocumentFiscalClassification | String | False |
The classification of the document as per the tax authority's rules, affecting its taxation. |
| BudgetaryControlEnabledFlag | Bool | True |
Indicates whether budgetary control is enabled for the purchase order, helping manage expenditures within budget. |
| CancelFlag | Bool | True |
Indicates whether the purchase order is marked for cancellation. |
| ChangeOrderNumber | String | True |
The unique number associated with a change order to track modifications made to the original purchase order. |
| ChangeOrderInitiatingParty | String | False |
The party who initiated the change order request, such as the buyer, supplier, or requester. |
| ChangeOrderDescription | String | False |
A textual description detailing the reason or purpose of the change order, providing clarity on why changes were made. |
| ChangeOrderStatusCode | String | True |
An abbreviation indicating the current status of the change order in its lifecycle. |
| ChangeOrderStatus | String | True |
The current status of the change order, indicating whether it's in draft, pending approval, or finalized. |
| ChangeOrderTypeCode | String | True |
An abbreviation identifying the type of change order being processed. |
| ChangeOrderType | String | True |
The type of change order, specifying whether it's a revision, cancellation, or other types of change. |
| ChangeRequestedBy | String | True |
The individual or entity who requested the change to the purchase order. |
| ContractTermsExistFlag | Bool | True |
Indicates whether contract terms exist for the purchase order, helping determine if additional contractual obligations apply. |
| DuplicatedFromHeaderId | Long | True |
The header ID of the original purchase order from which this one was duplicated. |
| FundsStatus | String | True |
The status of funds for the purchase order, indicating if the funds are approved, pending, or unavailable. |
| FundsStatusCode | String | True |
An abbreviation identifying the funds status of the purchase order, helping to categorize the financial approval stage. |
| ImportSourceCode | String | False |
The source application from which the purchase order was imported, such as an external ERP system. |
| ReferenceNumber | String | True |
A reference number used to link the purchase order to other related documents or transactions. |
| LastUpdateDate | Datetime | True |
The date and time when the purchase order was last updated. |
| LastUpdatedBy | String | True |
The individual who last updated the purchase order, helping to track changes. |
| CreationDate | Datetime | True |
The date and time when the purchase order was originally created. |
| CreatedBy | String | True |
The individual who originally created the purchase order. |
| SupplierCCEmailAddress | String | False |
An email address to which a copy of the purchase order communication is sent for CC purposes. |
| SupplierBCCEmailAddress | String | False |
An email address to which a copy of the purchase order communication is sent for BCC purposes, hidden from other recipients. |
| OverridingApproverId | Long | False |
The unique identifier for the user designated as the overriding approver for approval routing, allowing a change in the approval process. |
| OverridingApprover | String | False |
The name of the person who overrides the first approver to route the purchase order for approval. |
| OverrideB2BCommunicationFlag | Bool | False |
Indicates whether the purchase order can be communicated using an alternative communication method other than B2B, with true meaning it can't be sent through B2B. |
| HasPOlineswithMultipleDistributionsFlag | Bool | True |
A flag indicating whether the purchase order lines are distributed across multiple accounts or locations. |
| HasReceivedOrInvoicedSchedulesFlag | Bool | True |
Indicates whether there are any received or invoiced schedules related to the purchase order. |
| AdditionalContactEmail | String | False |
Email addresses for additional supplier contacts who may need to receive notifications regarding the purchase order. |
| SpecialHandlingType | String | False |
The special handling type applied to the purchase order, detailing any specific handling instructions. |
| SpecialHandlingTypeCode | String | False |
An abbreviation identifying the special handling type for the purchase order, such as expedited processing or custom packaging. |
| specialHandlingDFF | String | False |
A special handling DFF (descriptive flexfield) used only for insert operations; for updates and deletes, use child table operations. |
| summaryAttributes | String | False |
Summary attributes used for insert operations; for updates or deletes, refer to child table operations. |
| DFF | String | False |
A DFF (descriptive flexfield) used for inserts only; for updates and deletes, refer to child table operations. |
| lines | String | False |
Used for insert operations to add lines to the purchase order; for updates and deletes, use child table operations. |
| globalDFFs | String | False |
Global descriptive flexfields used only for insert operations; for updates and deletes, use child table operations. |
| Finder | String | True |
The finder used for searching and referencing related purchase order records. |
| Intent | String | True |
The intent or purpose for which the purchase order was created. |
| SysEffectiveDate | String | True |
The system-effective date, used for tracking the period when the purchase order data is valid. |
| EffectiveDate | Date | True |
The effective date used to determine the resources valid as of the specified start date. |