Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

DraftPurchaseOrders

The Draft Purchase Orders resource manages draft purchase orders. A draft purchase order is a document that controls the purchase of an item or a service, which is created but is not yet communicated to the supplier. You must have the necessary roles and privileges to use this REST resource. For additional details, refer to the Job Roles and Privileges and Status Codes topics.

Table Specific Information

Select

The 本製品 uses the Oracle Fusion Cloud Financials API to process some of the filters having queryable=true in metadata. The 本製品 processes other filters within the 本製品.

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. Please 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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

POHeaderId of DraftPurchaseOrders

POHeaderUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of POHeaderId

OrderNumber String False

Number that uniquely identifies the purchase order in the sold-to legal entity.

Description String False

Description of the purchase order.

DocumentStyleId Long False

Value that uniquely identifies the purchasing style of the document.

DocumentStyle String False

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.

StatusCode String False

Abbreviation that identifies the purchase order status in the order life cycle.

Status String True

Status of DraftPurchaseOrders

ProcurementBUId Long False

Value that uniquely identifies the business unit that manages and owns the purchase order.

ProcurementBU String False

Business unit that manages and owns the purchase order.

RequisitioningBUId Long False

Value that uniquely identifies the business unit that creates the requisition.

RequisitioningBU String False

Business unit that creates the requisition.

BuyerId Long False

Value that uniquely identifies the buyer.

Buyer String False

Person who is responsible for managing the purchase order.

BuyerEmail String False

Email address of the buyer.

CurrencyCode String False

Abbreviation that identifies the currency of the purchase order.

Currency String False

Currency of the purchase order.

ConversionRateTypeCode String False

Abbreviation that identifies the conversion rate type.

ConversionRateType String False

Type of rate that the application uses to determine the currency conversion rate for the purchase order.

ConversionRateDate Date False

Date to use for the conversion rate when converting an ordered amount into another currency. The conversion rate varies depending on the date.

ConversionRate Decimal False

Conversion rate to use when converting the currency.

SupplierId Long False

Value that uniquely identifies the supplier.

Supplier String False

Name of the supplier who fulfills the item.

SupplierSiteId Long False

Value that uniquely identifies the supplier site.

SupplierSite String False

Location that the supplier uses to purchase the item.

SupplierCommunicationMethod String False

Method by which the purchase order is communicated to the supplier, such as email or fax.

SupplierFax String False

Fax number used to communicate the purchase order to the supplier.

SupplierOrder String True

SupplierOrder of DraftPurchaseOrders

SupplierEmailAddress String False

Email address of the supplier for communication.

SoldToLegalEntityId Long False

Value that uniquely identifies the legal entity that is financially responsible for purchases on the purchase order.

SoldToLegalEntity String False

Legal entity that is financially responsible for purchases on the purchase order.

BillToBUId Long False

Value that uniquely identifies the business unit that processes supplier invoices for the purchase order.

BillToBU String False

Value that identifies the business unit that processes supplier invoices for the purchase order.

BillToLocationId Long False

Value that uniquely identifies the bill-to location.

BillToLocation String False

Value that identifies the bill-to location where the supplier sends the invoice.

BillToLocationInternalCode String False

Abbreviation that internally identifies the location to which the supplier should send the invoice.

DefaultShipToLocationId Long False

Value that uniquely identifies the ship-to location.

DefaultShipToLocation String False

Name of the location where the supplier ships the item.

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 when supplier must acknowledge the header and schedule of the purchase order, document when supplier must acknowledge the header of the purchase order, or none when 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

PendingSignatureFlag of DraftPurchaseOrders

PaymentTermsId Long False

Value that uniquely identifies the payment terms.

PaymentTerms String False

Terms that the application uses to schedule payments and calculate due dates, discount dates, and discount amounts for each invoice against the purchase order.

FOBCode String False

Abbreviation that identifies the type of term for freight on board for the item.

FOB String False

Freight on board. Location where ownership of the item transfers from the supplier to the buyer.

FreightTermsCode String False

Abbreviation that identifies the type of freight terms for the purchase order.

FreightTerms String False

Terms that describe who pays charges to transport the item.

SupplierContactId Long False

Value that uniquely identifies the supplier contact.

SupplierContact String False

Person who represents the supplier when communicating with the buyer.

NoteToSupplier String False

Note that the supplier can read to get details about how to process the purchase order.

NoteToReceiver String False

Note that the receiver can read to get details about how to process the purchase order.

CarrierId Long False

Value that uniquely identifies the company that transports the item by land, sea, or air.

Carrier String False

Company that transports the item by land, sea, or air.

ModeOfTransportCode String False

Abbreviation that identifies the mode of transport.

ModeOfTransport String False

Mode of transport that the shipper uses to transport the item, such as land, sea, or air.

ServiceLevelCode String False

Abbreviation that identifies the service level for the shipping method.

ServiceLevel String False

Priority that determines how quickly to transport the item.

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

Method by which the document was created, such as autocreate, enter PO, and so on.

ShippingMethod String False

Transportation method for the carrier or service level for the purchase order. For example, ABC Shipping - AIR - 2nd Day.

DefaultTaxationCountryCode String False

Abbreviation that identifies the country for taxation.

DefaultTaxationCountry String False

Country where the transaction takes place. This attribute is used for taxation.

FirstPartyRegistrationId Long False

Value that uniquely identifies the first party registration number.

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

Value that uniquely identifies the document fiscal classification.

DocumentFiscalClassificationCode String False

Abbreviation that identifies the document fiscal classification.

DocumentFiscalClassification String False

Tax classification used by a tax authority to categorize a document.

BudgetaryControlEnabledFlag Bool True

BudgetaryControlEnabledFlag of DraftPurchaseOrders

CancelFlag Bool True

CancelFlag of DraftPurchaseOrders

ChangeOrderNumber String True

ChangeOrderNumber of DraftPurchaseOrders

ChangeOrderInitiatingParty String False

Party where the purchase document change request originated. Valid values are requester, buyer, supplier, and catalog administrator.

ChangeOrderDescription String False

Text that describes the reason or purpose of the change order.

ChangeOrderStatusCode String True

ChangeOrderStatusCode of DraftPurchaseOrders

ChangeOrderStatus String True

ChangeOrderStatus of DraftPurchaseOrders

ChangeOrderTypeCode String True

ChangeOrderTypeCode of DraftPurchaseOrders

ChangeOrderType String True

ChangeOrderType of DraftPurchaseOrders

ChangeRequestedBy String True

ChangeRequestedBy of DraftPurchaseOrders

ContractTermsExistFlag Bool True

ContractTermsExistFlag of DraftPurchaseOrders

DuplicatedFromHeaderId Long True

DuplicatedFromHeaderId of DraftPurchaseOrders

FundsStatus String True

FundsStatus of DraftPurchaseOrders

FundsStatusCode String True

FundsStatusCode of DraftPurchaseOrders

ImportSourceCode String False

Value that indicates the source application from which the purchase order was imported.

ReferenceNumber String True

ReferenceNumber of DraftPurchaseOrders

LastUpdateDate Datetime True

LastUpdateDate of DraftPurchaseOrders

LastUpdatedBy String True

LastUpdatedBy of DraftPurchaseOrders

CreationDate Datetime True

CreationDate of DraftPurchaseOrders

CreatedBy String True

CreatedBy of DraftPurchaseOrders

SupplierCCEmailAddress String False

Email address to which a copy of the purchase order communication email is sent.

SupplierBCCEmailAddress String False

Email address to which a copy of the purchase order communication email is sent without letting other recipients know.

OverridingApproverId Long False

Value that uniquely identifies the user specified on the purchase order as the overriding approver for approval routing.

OverridingApprover String False

Overrides first approver identifier to route purchase orders for approval.

OverrideB2BCommunicationFlag Bool False

Contains one of the following values: true or false. If true, the purchase order can't be communicated using B2B communication, and you can communicate it using an alternate communication method such as email. If false, the purchase order must be communicated using B2B communication when the supplier site is configured to receive B2B messages. The default value is false.

HasPOlineswithMultipleDistributionsFlag Bool True

HasPOlineswithMultipleDistributionsFlag of DraftPurchaseOrders

HasReceivedOrInvoicedSchedulesFlag Bool True

HasReceivedOrInvoicedSchedulesFlag of DraftPurchaseOrders

AdditionalContactEmail String False

Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process.

SpecialHandlingType String False

SpecialHandlingType of DraftPurchaseOrders

SpecialHandlingTypeCode String False

SpecialHandlingTypeCode of DraftPurchaseOrders

specialHandlingDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

summaryAttributes String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

DFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

lines String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

globalDFFs String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

Finder String True

finder

Intent String True

intent

SysEffectiveDate String True

syseffectivedate

EffectiveDate Date True

This query parameter is used to fetch resources which are effective dated as of the specified start date.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111