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 |