PurchaseAgreementImportRequestslines
Specifies goods or services from the imported agreement, listing line details without delivery schedules or discrete distributions.
Columns
| Name | Type | SupportedFinders | 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 | PrimaryKey | 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. |