JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseAgreementImportRequests

Purchase agreement import requests lets user import the procurement documents. It receives the data, verifies and processes the data, and imports the data into the application as purchase agreements.

Columns

Name Type Description
InterfaceHeaderId [KEY] Long Value that uniquely identifies the interface header.
InterfaceHeaderKey String Value that uniquely identifies the interface header.
ActionCode String Value that uniquely identifies the action.
BatchId Decimal Value that uniquely identifies the batch.
ImportSource String Value that identifies the source application from which the document was imported.
ApprovalActionCode String Indicates whether the approval process needs to be bypassed on submission.
AgreementHeaderId Long Value that uniquely identifies the purchase agreement.
AgreementNumber String Number that uniquely identifies the purchase agreement in the sold-to legal entity.
DocumentTypeCode String Value that identifies the document type associated with a change order template.
StyleId Long 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 header.
Style 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.
ProcurementBUId Long Value that uniquely identifies the business unit that manages and owns the purchasing document.
ProcurementBU String Business unit that manages and owns the purchase agreement.
BuyerId Long Value that uniquely identifies the buyer.
Buyer String Person who's responsible for managing the purchase agreement.
CurrencyCode String Code that identifies the purchase agreement currency.
Description String Description for the line item.
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.
SupplierContactId Long Value that uniquely identifies the supplier contact.
SupplierContact String Person who represents the supplier when communicating with the buyer.
FOB String Freight on board. Location where ownership of the item transfers from the supplier to the buyer.
CarrierId Long Value that uniquely identifies the company that transports the item.
Carrier String Company that transports the item.
FreightTerms String Terms that describe who pays charges to transport the item.
PayOnReceiptFlag Bool Value that indicates if the purchase order will be paid upon receipt.
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.
ChangeOrderDescription String Description of the changes made.
ChangeOrderInitiatingParty String Value that uniquely identifies the role of the user who initiated the change order.
RequiredAcknowledgmentCode String Indicates whether a supplier acknowledgment is required on the document and if required, what level it's required.
SupplierOrder String Value that indicates the supplier document number.
AcknowledgmentWithinDays Decimal Number of days that the supplier can decide to accept or reject the document.
SupplierCommunicationMethodCode String Code that identifies the supplier communication method.
SupplierFax String Value that identifies the fax number specified on the document to which the document after approval will be communicated.
SupplierEmailAddress String Value that identifies the email address specified on the document to which the document after approval will be communicated.
ConfirmingOrderFlag Bool Value that identifies whether the document is a confirmation of an order the supplier may already be aware of.
AgreementAmount Decimal Value that identifies the amount agreed for an agreement line.
AmountLimit Decimal Value that identifies the amount limit on an agreement beyond which releases can't be created against the agreement.
MinimumReleaseAmount Decimal Value that identifies the minimum amount that can be released against a blanket or planned purchase order.
StartDate Date Date on which the agreement becomes effective.
EndDate Date Date after which the purchase agreement is no longer valid.
NoteToSupplier String Value that uniquely identifies a note to supplier.
NoteToReceiver String Special text instructions to the receiver in the docking area to be reviewed while performing the receipt.
AutomaticallyGenerateOrdersFlag Bool Value that identifies whether an order should be automatically created for a requisition line referencing the agreement or not.
AutomaticallySubmitForApprovalFlag Bool Value that identifies whether the document can be automatically submitted for approval.
GroupRequisitionsFlag Bool Value that identifies whether or not requisition lines of different requisitions referencing the same agreement line should be grouped when creating an order.
GroupRequisitionLinesFlag Bool Value that identifies whether or not requisition lines referencing the same agreement line should be grouped when creating an order.
UseShipToOrganizationAndLocationFlag Bool Value that identifies whether item descriptions can be updated on document lines.
UseNeedByDateFlag Bool Value that identifies whether to use the date on requisition lines that the buying company requests the supplier to deliver the goods when trying to group requisitions while creating an order.
CatalogAdministratorAuthoringFlag Bool Value that indicates if catalog administrator is allowed to author the document. Valid values are true or false.
ApplyPriceUpdatesToExistingOrdersFlag Bool Value that identifies whether or not the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement.
CommunicatePriceUpdatesFlag Bool Value that identifies whether or not orders that were repriced because of a price change on the referenced agreement should be communicated to the supplier.
BuyerEmailAddress String Value that uniquely identifies the email address of the buyer.
ModeOfTransportCode String Mode of transport that the shipper uses to transport the item such as land, sea, and air.
ModeOfTransport String Mode of transport to ship the item, such as truck, air, or boat.
ServiceLevelCode String Value that identifies the priority of transportation that affects how quickly goods are transported.
ServiceLevel String Priority that determines how quickly to transport the item.
AgingOnsetPointCode String Value that identifies the mutually agreed event point at which consigned material begins to age. The possible values for aging onset point are None, Receipt, and Shipment.
AgingPeriodDays Int Value that identifies the maximum number of days the material may be on consignment.
ConsumptionAdviceFrequencyCode String Value that identifies the default value of the frequency at which the consumption advice will be generated for all consumption transactions for consigned inventory purchased under this agreement. The possible values for consumption advice frequency are Daily, Weekly, and Monthly.
ConsumptionAdviceSummaryCode String Value that identifies the default value of the frequency at which the consumption advice will be generated for all consumption transactions for consigned inventory purchased under this agreement. The possible values for consumption advice frequency are Daily, Weekly, and Monthly.
DefaultConsignmentLinesFlag Bool Contains one of the following values: true or false. If true, then the blanket purchase agreement and the purchase order include consignment lines. If false, then the blanket purchase agreement and the purchase order don't include consignment lines. The default value is false.
PayOnUseFlag Bool Value that identifies whether to generate invoices automatically on behalf of the supplier when supplier owned material stocked in buying organization's premise is consumed by the buying organization.
BillingCycleClosingDate Date Value that indicates when the current billing period ends for an agreement.
ConfigurationOrderingEnabledFlag Bool Value that indicates whether the document should support the ordering of configurations involving model items and options. Configurations are single shippable units comprised of a base model and optional additions.
UseCustomerSalesOrderFlag Bool Value that identifies whether requisition lines should be grouped by sales order number to create distinct purchase order.
BuyerManagedTransportFlag Bool Value that identifies that the buying company is responsible for arranging the transportation, from picking up the requested goods to delivering to ship-to locations specified on the order.
AllowOrderingFromUnassignedSitesFlag Bool Value that identifies whether the agreement can be used to order from supplier sites not listed as a purchasing site in the agreement's business unit assignments.
OutsideProcessEnabledFlag Bool Contains one of the following values: true or false. If true, then the document style definitions allows users to indicate if the blanket purchase agreement and the purchase order are for outside processing. If false, then the document style definition doesn't allow users to indicate if the blanket purchase agreement and the purchase order are for outside processing. The default value is false.
MasterContractNumber String Number that identifies the contract from enterprise contracts.
MasterContractId Long Value that uniquely identifies the associated contract.
MasterContractTypeId Long Value that uniquely identifies the master contract type.
MasterContractType String Administrator-created classification for enterprise contracts that determines contract functionality, including the presence of lines and contract terms.
UseOrderDateForOrderPricingFlag Bool Contains one of the following values: true or false. If true, then the order date should be used to derive price on the orders referencing the agreement. If false, then the requested delivery date should be used to derive price on the orders referencing the agreement. This attribute doesn't have a default value.
AttributeCategory String Category segment for the purchase agreement header descriptive flexfield.
Attribute1 String Segment for the purchase agreement header descriptive flexfield.
Attribute2 String Segment for the purchase agreement header descriptive flexfield.
Attribute3 String Segment for the purchase agreement header descriptive flexfield.
Attribute4 String Segment for the purchase agreement header descriptive flexfield.
Attribute5 String Segment for the purchase agreement header descriptive flexfield.
Attribute6 String Segment for the purchase agreement header descriptive flexfield.
Attribute7 String Segment for the purchase agreement header descriptive flexfield.
Attribute8 String Segment for the purchase agreement header descriptive flexfield.
Attribute9 String Segment for the purchase agreement header descriptive flexfield.
Attribute10 String Segment for the purchase agreement header descriptive flexfield.
Attribute11 String Segment for the purchase agreement header descriptive flexfield.
Attribute12 String Segment for the purchase agreement header descriptive flexfield.
Attribute13 String Segment for the purchase agreement header descriptive flexfield.
Attribute14 String Segment for the purchase agreement header descriptive flexfield.
Attribute15 String Segment for the purchase agreement header descriptive flexfield.
Attribute16 String Segment for the purchase agreement header descriptive flexfield.
Attribute17 String Segment for the purchase agreement header descriptive flexfield.
Attribute18 String Segment for the purchase agreement header descriptive flexfield.
Attribute19 String Segment for the purchase agreement header descriptive flexfield.
Attribute20 String Segment for the purchase agreement header descriptive flexfield.
AttributeDate1 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate2 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate3 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate4 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate5 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate6 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate7 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate8 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate9 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeDate10 Date Date segment for the purchase agreement header descriptive flexfield.
AttributeNumber1 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber2 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber3 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber4 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber5 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber6 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber7 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber8 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber9 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeNumber10 Decimal Number segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp1 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp2 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp3 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp4 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp5 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp6 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp7 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp8 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp9 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
AttributeTimestamp10 Datetime Date and time segment for the purchase agreement header descriptive flexfield.
CreatedBy String CreatedBy of PurchaseAgreementImportRequests
CreationDate Datetime CreationDate of PurchaseAgreementImportRequests
LastUpdatedBy String LastUpdatedBy of PurchaseAgreementImportRequests
LastUpdateDate Datetime LastUpdateDate of PurchaseAgreementImportRequests
ProcessCode String ProcessCode of PurchaseAgreementImportRequests
RequestId Long RequestId of PurchaseAgreementImportRequests
Finder String Finder of PurchaseAgreementImportRequests

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