PurchaseAgreementImportRequestslines
Specifies goods or services from the imported agreement, listing line details without delivery schedules or discrete distributions.
Columns
| Name | Type | Description |
| PurchaseAgreementImportRequestsInterfaceHeaderId [KEY] | Long | The unique identifier for the interface header related to the purchase agreement import request lines. |
| InterfaceLineId [KEY] | Long | The unique identifier for the interface line, used to distinguish individual line items within the purchase agreement import request. |
| InterfaceHeaderKey | String | A key that uniquely identifies the header record, providing a reference for the load request to track the import. |
| InterfaceLineKey | String | A key that uniquely identifies the interface line, enabling precise tracking and management of individual line items. |
| ActionCode | String | Indicates the action to be performed on the record, such as create or update, based on the provided data. |
| LineNumber | Decimal | The unique identifier for the purchase order or agreement line, typically used to reference and order line items within the agreement. |
| LineType | String | The type of line on the purchasing document, distinguishing between product, service, or other categories. |
| LineTypeId | Long | The unique identifier for the line type, enabling specific classification of line items within the purchase agreement. |
| Item | String | The abbreviation or code that uniquely identifies the item listed on the purchase order or agreement line. |
| ItemId | Long | The unique identifier for the item on the purchase agreement, linking the line item to its catalog or database entry. |
| ItemRevision | String | The revision number or version of the item, identifying the specific iteration or update of the product listed on the agreement line. |
| Category | String | The category to which the item belongs, helping to organize and classify items within the purchase agreement. |
| CategoryId | Long | The unique identifier for the purchasing category associated with the line item, facilitating item classification and tracking. |
| ItemDescription | String | A detailed description of the item on the agreement line, providing additional context or specifications for the purchase. |
| AgreementAmount | Decimal | The agreed-upon amount for the line item in the purchase agreement, specifying the monetary value of the purchase. |
| UOM | String | The abbreviation for the unit of measure used on the agreement line, such as 'each,' 'box,' or 'kg.' |
| UOMCode | String | The code representing the unit of measure, used for consistency in the purchase order and agreement lines. |
| Price | Decimal | The unit price for the line item, indicating how much each item costs based on the purchase agreement terms. |
| Amount | Decimal | The total value of the line item on the agreement, typically calculated as price multiplied by quantity. |
| AllowPriceOverrideFlag | Bool | Indicates whether the price on release shipments can be overridden by the buyer. 'True' allows overrides, while 'False' prevents them. |
| NotToExceedPrice | Decimal | The maximum price allowed for the line item, ensuring that the price for a release shipment doesn't exceed this limit. |
| SupplierItem | String | The supplier's unique item number, used to cross-reference the item in the supplier's catalog or inventory. |
| NegotiatedFlag | Bool | Indicates whether the price was negotiated between the buyer and supplier before the purchase. 'True' means negotiated, 'False' means not negotiated. |
| NoteToReceiver | String | Special instructions provided to the receiver of the items, offering guidance on how to handle the goods during receipt. |
| NoteToSupplier | String | A note directed to the supplier, often providing instructions or additional details about the order or requirements. |
| MinimumReleaseAmount | Decimal | The minimum amount that can be released for a blanket or planned purchase order, ensuring that minimum purchase thresholds are met. |
| SupplierPartAuxiliaryId | String | An identifier used to cross-reference the item with additional supplier-specific data, such as auxiliary parts or components. |
| SupplierReferenceNumber | String | A reference number used by the supplier to identify related models, options, or submodels associated with the item. |
| AgingPeriodDays | Int | The maximum number of days the material can remain on consignment before it is considered aged, requiring action from the buyer or supplier. |
| ConsignmentLineFlag | Bool | Indicates whether the agreement includes consignment lines. 'True' means consignment lines are included in the blanket purchase agreement and the purchase order. 'False' (the default) means they are not. |
| UnitWeight | Decimal | The weight of one unit of the item, used for shipping and inventory management. |
| WeightUOMCode | String | The code representing the unit of measure for the weight, such as 'kg' or 'lbs.' |
| WeightUOMName | String | The name of the unit of measure for the weight, providing a readable format for understanding the weight of items. |
| UnitVolume | Decimal | The volume of one unit of the item, often used for shipping and storage calculations. |
| VolumeUOMCode | String | The code that identifies the unit of measure for the volume, such as 'm3' or 'liters.' |
| VolumeUOMName | String | The name of the unit of measure for volume, providing a human-readable format for understanding the item’s volume. |
| ParentItem | String | The identifier for the parent item or option class associated with the line item, often used for configurable products or product families. |
| ParentItemId | Long | The unique identifier for the parent item or model, linking the line item to its parent product in the catalog. |
| TopModel | String | The identifier for the top model associated with the option class or submodel, often used for high-level product categorization. |
| TopModelId | Long | The unique identifier for the top model, used to connect the item to its broader product family or model grouping. |
| SupplierParentItem | String | The supplier’s identification number for the option class or model associated with the item. |
| SupplierTopModel | String | The supplier’s identifier for the top model related to the option class or submodel of the item. |
| PriceBreakType | String | The type of pricing scheme applied to the price breaks for this line item, specifying how discounts or price tiers are structured. |
| AllowDescriptionUpdateFlag | Bool | Indicates whether the description of the item can be updated on document lines. 'True' allows updates, 'False' prevents them. |
| AttributeCategory | String | The category segment for the purchase agreement line's descriptive flexfield, allowing for custom data fields to be added. |
| LineAttribute1 | String | Custom data field for the purchase agreement line's descriptive flexfield, allowing for additional line-specific details. |
| LineAttribute2 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute3 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute4 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute5 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute6 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute7 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute8 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute9 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute10 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute11 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute12 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute13 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute14 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| LineAttribute15 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| Attribute16 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| Attribute17 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| Attribute18 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| Attribute19 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| Attribute20 | String | Custom data field for the purchase agreement line's descriptive flexfield. |
| AttributeDate1 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate2 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate3 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate4 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate5 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate6 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate7 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate8 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate9 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeDate10 | Date | Date segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber1 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber2 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber3 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber4 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber5 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber6 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber7 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber8 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber9 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeNumber10 | Decimal | Number segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp1 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp2 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp3 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp4 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp5 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp6 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp7 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp8 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp9 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| AttributeTimestamp10 | Datetime | Timestamp segment for the purchase agreement line's descriptive flexfield. |
| InterfaceHeaderId | Long | The unique identifier for the interface header linked to the purchase agreement import request lines. |
| CreatedBy | String | The name of the person or system that created the purchase agreement import request line. |
| CreationDate | Datetime | The date and time when the purchase agreement import request line was created. |
| LastUpdatedBy | String | The name of the person or system that last updated the purchase agreement import request line. |
| LastUpdateDate | Datetime | The date and time when the purchase agreement import request line was last updated. |
| ProcessCode | String | The code identifying the process or action being performed on the purchase agreement import request line. |
| ExpirationDate | Date | The date after which the item on this line can no longer be ordered, marking the expiration of the agreement for that item. |
| AgreementQuantity | Decimal | The total quantity agreed upon for the item or line in the purchase agreement. |
| Finder | String | The search function used to retrieve or filter purchase agreement import request lines based on specific criteria. |