Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9062

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.

Columns

Name Type Description
POHeaderId [KEY] Long POHeaderId of DraftPurchaseOrders
OrderNumber String Number that uniquely identifies the purchase order in the sold-to legal entity.
Description String Description of the purchase order.
DocumentStyleId Long Value that uniquely identifies the purchasing style of the document.
DocumentStyle String 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 Abbreviation that identifies the purchase order status in the order life cycle.
Status String Status of DraftPurchaseOrders
ProcurementBUId Long Value that uniquely identifies the business unit that manages and owns the purchase order.
ProcurementBU String Business unit that manages and owns the purchase order.
RequisitioningBUId Long Value that uniquely identifies the business unit that creates the requisition.
RequisitioningBU String Business unit that creates the requisition.
BuyerId Long Value that uniquely identifies the buyer.
Buyer String Person who is responsible for managing the purchase order.
BuyerEmail String Email address of the buyer.
CurrencyCode String Abbreviation that identifies the currency of the purchase order.
Currency String Currency of the purchase order.
ConversionRateTypeCode String Abbreviation that identifies the conversion rate type.
ConversionRateType String Type of rate that the application uses to determine the currency conversion rate for the purchase order.
ConversionRateDate Date 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 Conversion rate to use when converting the currency.
SupplierId Long Value that uniquely identifies the supplier.
Supplier String Name of the supplier who fulfills the item.
SupplierSiteId Long Value that uniquely identifies the supplier site.
SupplierSite String Location that the supplier uses to purchase the item.
SupplierCommunicationMethod String Method by which the purchase order is communicated to the supplier, such as email or fax.
SupplierFax String Fax number used to communicate the purchase order to the supplier.
SupplierOrder String SupplierOrder of DraftPurchaseOrders
SupplierEmailAddress String Email address of the supplier for communication.
SoldToLegalEntityId Long Value that uniquely identifies the legal entity that is financially responsible for purchases on the purchase order.
SoldToLegalEntity String Legal entity that is financially responsible for purchases on the purchase order.
BillToBUId Long Value that uniquely identifies the business unit that processes supplier invoices for the purchase order.
BillToBU String Value that identifies the business unit that processes supplier invoices for the purchase order.
BillToLocationId Long Value that uniquely identifies the bill-to location.
BillToLocation String Value that identifies the bill-to location where the supplier sends the invoice.
BillToLocationInternalCode String Abbreviation that internally identifies the location to which the supplier should send the invoice.
DefaultShipToLocationId Long Value that uniquely identifies the ship-to location.
DefaultShipToLocation String Name of the location where the supplier ships the item.
DefaultShipToLocationInternalCode String Abbreviation that internally identifies the default value of the ship-to location where the supplier should ship the goods.
MasterContractId Long 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 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 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 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 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 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 Date when the application requests the supplier to acknowledge the purchase order.
AcknowledgmentWithinDays Decimal Number of days for the supplier to decide to accept or reject the purchase order.
BuyerManagedTransportFlag Bool 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 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 PendingSignatureFlag of DraftPurchaseOrders
PaymentTermsId Long Value that uniquely identifies the payment terms.
PaymentTerms String 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 Abbreviation that identifies the type of term for freight on board for the item.
FOB String Freight on board. Location where ownership of the item transfers from the supplier to the buyer.
FreightTermsCode String Abbreviation that identifies the type of freight terms for the purchase order.
FreightTerms String Terms that describe who pays charges to transport the item.
SupplierContactId Long Value that uniquely identifies the supplier contact.
SupplierContact String Person who represents the supplier when communicating with the buyer.
NoteToSupplier String Note that the supplier can read to get details about how to process the purchase order.
NoteToReceiver String Note that the receiver can read to get details about how to process the purchase order.
CarrierId Long Value that uniquely identifies the company that transports the item by land, sea, or air.
Carrier String Company that transports the item by land, sea, or air.
ModeOfTransportCode String Abbreviation that identifies the mode of transport.
ModeOfTransport String Mode of transport that the shipper uses to transport the item, such as land, sea, or air.
ServiceLevelCode String Abbreviation that identifies the service level for the shipping method.
ServiceLevel String Priority that determines how quickly to transport the item.
ConfirmingOrderFlag Bool 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 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 Method by which the document was created, such as autocreate, enter PO, and so on.
ShippingMethod String Transportation method for the carrier or service level for the purchase order. For example, ABC Shipping - AIR - 2nd Day.
DefaultTaxationCountryCode String Abbreviation that identifies the country for taxation.
DefaultTaxationCountry String Country where the transaction takes place. This attribute is used for taxation.
FirstPartyRegistrationId Long Value that uniquely identifies the first party registration number.
FirstPartyRegistrationNumber String 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 Value that uniquely identifies the third party registration.
ThirdPartyRegistrationNumber String 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 Value that uniquely identifies the document fiscal classification.
DocumentFiscalClassificationCode String Abbreviation that identifies the document fiscal classification.
DocumentFiscalClassification String Tax classification used by a tax authority to categorize a document.
BudgetaryControlEnabledFlag Bool BudgetaryControlEnabledFlag of DraftPurchaseOrders
CancelFlag Bool CancelFlag of DraftPurchaseOrders
ChangeOrderNumber String ChangeOrderNumber of DraftPurchaseOrders
ChangeOrderInitiatingParty String Party where the purchase document change request originated. Valid values are requester, buyer, supplier, and catalog administrator.
ChangeOrderDescription String Text that describes the reason or purpose of the change order.
ChangeOrderStatusCode String ChangeOrderStatusCode of DraftPurchaseOrders
ChangeOrderStatus String ChangeOrderStatus of DraftPurchaseOrders
ChangeOrderTypeCode String ChangeOrderTypeCode of DraftPurchaseOrders
ChangeOrderType String ChangeOrderType of DraftPurchaseOrders
ChangeRequestedBy String ChangeRequestedBy of DraftPurchaseOrders
ContractTermsExistFlag Bool ContractTermsExistFlag of DraftPurchaseOrders
DuplicatedFromHeaderId Long DuplicatedFromHeaderId of DraftPurchaseOrders
FundsStatus String FundsStatus of DraftPurchaseOrders
FundsStatusCode String FundsStatusCode of DraftPurchaseOrders
ImportSourceCode String Value that indicates the source application from which the purchase order was imported.
ReferenceNumber String ReferenceNumber of DraftPurchaseOrders
LastUpdateDate Datetime LastUpdateDate of DraftPurchaseOrders
LastUpdatedBy String LastUpdatedBy of DraftPurchaseOrders
CreationDate Datetime CreationDate of DraftPurchaseOrders
CreatedBy String CreatedBy of DraftPurchaseOrders
SupplierCCEmailAddress String Email address to which a copy of the purchase order communication email is sent.
SupplierBCCEmailAddress String Email address to which a copy of the purchase order communication email is sent without letting other recipients know.
OverridingApproverId Long Value that uniquely identifies the user specified on the purchase order as the overriding approver for approval routing.
OverridingApprover String Overrides first approver identifier to route purchase orders for approval.
OverrideB2BCommunicationFlag Bool 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 HasPOlineswithMultipleDistributionsFlag of DraftPurchaseOrders
HasReceivedOrInvoicedSchedulesFlag Bool HasReceivedOrInvoicedSchedulesFlag of DraftPurchaseOrders
AdditionalContactEmail String Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process.
Finder String Finder of DraftPurchaseOrders
Intent String Intent of DraftPurchaseOrders
SysEffectiveDate String SysEffectiveDate of DraftPurchaseOrders

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