PurchaseAgreementImportRequests
Facilitates bulk import of procurement documents (for example, blanket purchase agreements), verifying and loading them into the system.
Columns
| Name | Type | Description |
| InterfaceHeaderId [KEY] | Long | The unique identifier for the interface header, linking the import request to the overall interface process. |
| InterfaceHeaderKey | String | The key that uniquely identifies the interface header, used for tracking and processing the request. |
| ActionCode | String | The code that identifies the action to be performed, such as create, update, or delete for the purchase agreement. |
| BatchId | Decimal | The unique identifier for the batch of import requests, used to group related transactions for processing. |
| ImportSource | String | The source application from which the purchase agreement document was imported, helping to trace the origin of the data. |
| ApprovalActionCode | String | Indicates whether the approval process should be bypassed during submission, affecting how the agreement is processed. |
| AgreementHeaderId | Long | The unique identifier for the purchase agreement header, linking the agreement to its details and related documents. |
| AgreementNumber | String | The number that uniquely identifies the purchase agreement within the sold-to legal entity, used for reference and tracking. |
| DocumentTypeCode | String | The code identifying the document type, typically associated with a change order template or other document types. |
| StyleId | Long | The identifier for the purchasing document style, allowing the organization to control the parameters and values displayed for purchasing documents. |
| Style | String | The name of the purchasing document style, which determines the layout and parameters used in the purchase agreement. |
| ProcurementBUId | Long | The unique identifier for the business unit responsible for managing and owning the purchasing document. |
| ProcurementBU | String | The name of the procurement business unit that owns and manages the purchase agreement. |
| BuyerId | Long | The unique identifier for the buyer responsible for managing the purchase agreement. |
| Buyer | String | The name of the person responsible for overseeing and managing the purchase agreement. |
| CurrencyCode | String | The code representing the currency used in the purchase agreement, ensuring proper financial transactions and conversions. |
| Description | String | A description for the line item in the purchase agreement, providing context or details for the items being purchased. |
| SupplierId | Long | The unique identifier for the supplier fulfilling the items or services on the purchase agreement. |
| Supplier | String | The name of the supplier who provides the goods or services specified in the purchase agreement. |
| SupplierSiteId | Long | The unique identifier for the location or site from which the supplier fulfills the purchase agreement. |
| SupplierSite | String | The name or identifier of the location from where the supplier provides the goods or services. |
| SupplierContactId | Long | The unique identifier for the contact person at the supplier organization. |
| SupplierContact | String | The name of the person representing the supplier for communication regarding the purchase agreement. |
| FOB | String | Freight On Board location, which indicates where ownership of the item transfers from the supplier to the buyer. |
| CarrierId | Long | The unique identifier for the carrier company responsible for transporting the item from the supplier to the buyer. |
| Carrier | String | The name of the company responsible for the transportation of the items specified in the purchase agreement. |
| FreightTerms | String | The terms that describe the responsibility for paying freight charges, determining who covers the cost of transportation. |
| PayOnReceiptFlag | Bool | Indicates whether payment for the purchase order is due upon receipt of the goods (true) or at a later time (false). |
| PaymentTermsId | Long | The unique identifier for the payment terms associated with the purchase agreement, specifying when payments are due. |
| PaymentTerms | String | The terms under which payments are scheduled, including due dates, discounts, and other relevant payment conditions. |
| ChangeOrderDescription | String | A description of any changes made to the purchase agreement, often used for modifications or amendments. |
| ChangeOrderInitiatingParty | String | The role of the user who initiated the change order, indicating who proposed or requested the modification. |
| RequiredAcknowledgmentCode | String | Indicates whether a supplier acknowledgment is required for the document, and if so, specifies the level of acknowledgment needed. |
| SupplierOrder | String | The supplier's order number, which may be referenced for cross-checking or communication purposes. |
| AcknowledgmentWithinDays | Decimal | The number of days within which the supplier must decide whether to accept or reject the purchase order or agreement. |
| SupplierCommunicationMethodCode | String | The code identifying the method of communication to be used with the supplier, such as email, fax, or phone. |
| SupplierFax | String | The fax number to which the purchase agreement will be communicated after approval, if applicable. |
| SupplierEmailAddress | String | The email address to which the purchase agreement will be communicated after approval, for faster processing. |
| ConfirmingOrderFlag | Bool | Indicates whether the document is confirming an order the supplier may already be aware of, providing clarity on the status of the order. |
| AgreementAmount | Decimal | The total amount agreed upon for a line in the purchase agreement, specifying the monetary value of the agreement. |
| AmountLimit | Decimal | The amount limit on the agreement, beyond which additional releases or orders cannot be created. |
| MinimumReleaseAmount | Decimal | The minimum amount that can be released for a blanket or planned purchase order under the terms of the agreement. |
| StartDate | Date | The date when the purchase agreement becomes effective, marking the beginning of its validity. |
| EndDate | Date | The expiration date after which the purchase agreement is no longer valid for new orders or releases. |
| NoteToSupplier | String | A note or instruction to the supplier, providing additional context or details for the supplier's action. |
| NoteToReceiver | String | Special instructions for the receiver, typically used for guidance during the receipt and inspection process. |
| AutomaticallyGenerateOrdersFlag | Bool | Indicates whether purchase orders should be automatically created for requisition lines referencing the agreement. |
| AutomaticallySubmitForApprovalFlag | Bool | Indicates whether the document should be automatically submitted for approval upon creation. |
| GroupRequisitionsFlag | Bool | Indicates whether requisition lines from different requisitions referencing the same agreement line should be grouped together when creating an order. |
| GroupRequisitionLinesFlag | Bool | Indicates whether requisition lines referencing the same agreement line should be grouped together when creating an order. |
| UseShipToOrganizationAndLocationFlag | Bool | Indicates whether item descriptions can be updated on document lines, allowing changes to item details as necessary. |
| UseNeedByDateFlag | Bool | Indicates whether the 'need by' date specified on requisition lines should be used when grouping requisitions for order creation. |
| CatalogAdministratorAuthoringFlag | Bool | Indicates whether the catalog administrator has authorization to author or make changes to the purchase agreement. |
| ApplyPriceUpdatesToExistingOrdersFlag | Bool | Indicates whether retroactive price updates should only affect open, unfulfilled orders that reference the agreement. |
| CommunicatePriceUpdatesFlag | Bool | Indicates whether repriced orders due to price changes on the agreement should be communicated to the supplier. |
| BuyerEmailAddress | String | The email address of the buyer, used for communication and correspondence related to the purchase agreement. |
| ModeOfTransportCode | String | The code representing the mode of transportation used to ship the goods, such as air, sea, or land. |
| ModeOfTransport | String | The specific mode of transport, such as truck, air, or boat, used to deliver the item from supplier to buyer. |
| ServiceLevelCode | String | The code identifying the priority level of transportation, determining how quickly the goods are shipped. |
| ServiceLevel | String | The service level indicating how quickly goods need to be transported, such as standard or expedited. |
| AgingOnsetPointCode | String | The code that identifies the agreed-upon point when consigned materials begin to age, such as upon receipt or shipment. |
| AgingPeriodDays | Int | The maximum number of days that consigned material may be kept before it is considered aged and may require action. |
| ConsumptionAdviceFrequencyCode | String | The frequency with which consumption advice for consigned inventory will be generated, such as daily, weekly, or monthly. |
| ConsumptionAdviceSummaryCode | String | The summary level for consumption advice frequency, helping determine how often consumption data is communicated to the supplier. |
| DefaultConsignmentLinesFlag | Bool | Indicates whether consignment lines are included in the blanket purchase agreement and related purchase orders. Default is false. |
| PayOnUseFlag | Bool | Indicates whether invoices should be generated automatically when supplier-owned material stocked in the buyer's location is consumed. |
| BillingCycleClosingDate | Date | The date that marks the end of the current billing period for the purchase agreement. |
| ConfigurationOrderingEnabledFlag | Bool | Indicates whether the agreement supports ordering configurations, allowing the purchase of model items and their options. |
| UseCustomerSalesOrderFlag | Bool | Indicates whether requisition lines should be grouped by sales order number to create distinct purchase orders. |
| BuyerManagedTransportFlag | Bool | Indicates whether the buyer is responsible for arranging transportation, from pickup to delivery. |
| AllowOrderingFromUnassignedSitesFlag | Bool | Indicates whether the agreement allows orders from supplier sites that are not listed as approved purchasing sites. |
| OutsideProcessEnabledFlag | Bool | Indicates whether the document style allows for outside processing, such as external work or services not performed by the supplier. |
| MasterContractNumber | String | The number that identifies the associated enterprise contract for the purchase agreement. |
| MasterContractId | Long | The unique identifier for the master contract associated with the purchase agreement. |
| MasterContractTypeId | Long | The unique identifier for the type of master contract associated with the purchase agreement. |
| MasterContractType | String | The classification of the master contract that determines contract functionality, including terms and conditions. |
| UseOrderDateForOrderPricingFlag | Bool | Indicates whether the order date should be used for pricing when creating orders referencing the agreement. |
| AttributeCategory | String | The category segment for the purchase agreement header's descriptive flexfield, allowing additional data customization. |
| Attribute1 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute2 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute3 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute4 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute5 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute6 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute7 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute8 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute9 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute10 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute11 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute12 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute13 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute14 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute15 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute16 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute17 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute18 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute19 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| Attribute20 | String | Custom segment for additional information within the purchase agreement header's descriptive flexfield. |
| AttributeDate1 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate2 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate3 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate4 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate5 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate6 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate7 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate8 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate9 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeDate10 | Date | Custom date segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber1 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber2 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber3 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber4 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber5 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber6 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber7 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber8 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber9 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeNumber10 | Decimal | Custom number segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp1 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp2 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp3 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp4 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp5 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp6 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp7 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp8 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp9 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| AttributeTimestamp10 | Datetime | Custom timestamp segment for the purchase agreement header's descriptive flexfield. |
| CreatedBy | String | The name of the person or system that created the purchase agreement import request. |
| CreationDate | Datetime | The date and time when the purchase agreement import request was created. |
| LastUpdatedBy | String | The name of the person or system that last updated the purchase agreement import request. |
| LastUpdateDate | Datetime | The date and time when the purchase agreement import request was last updated. |
| ProcessCode | String | The code identifying the processing method for the import request, indicating how the request should be handled. |
| RequestId | Long | The unique identifier for the purchase agreement import request, used for tracking and processing. |
| Finder | String | The function or mechanism used to search for or retrieve purchase agreement import requests. |