PurchaseAgreementslines
Details of the goods or services to be purchased from the supplier. The line doesn't contain delivery dates or individual delivery quantities or amounts. For example, an agreement line can be service-based for installing a television or a goods item to negotiate the price for 50 laptops.
Columns
Name | Type | Description |
PurchaseAgreementsAgreementHeaderId [KEY] | Long | Value that uniquely identifies the purchase agreement. |
AgreementLineId [KEY] | Long | Value that indicates the status of the line. |
LineNumber | Decimal | Value that uniquely identifies the purchase order or agreement line. |
AgreementHeaderId | Long | Value that uniquely identifies the purchase agreement. |
AgreementNumber | String | Number that uniquely identifies the purchase agreement in the sold-to legal entity. |
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. |
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. |
LineTypeId | Long | Value that uniquely identifies the line type on your documents. |
LineType | String | Line type on purchasing documents. |
ItemId | Long | Value that uniquely identifies the item on the purchase agreement. |
Item | String | Abbreviation that uniquely identifies the item on the purchase order. |
ItemRevision | String | Value that identifies the revision number of the item. |
Description | String | Description for the line item. |
SupplierItem | String | Value that identifies the supplier item number. |
CategoryId | Long | Value that uniquely identifies the purchasing category. |
CategoryCode | String | Abbreviation that identifies the purchasing category. |
Category | String | Value that uniquely identifies the purchasing category. |
StatusCode | String | Code that identifies the agreement line status. |
Status | String | Status of an agreement line. |
UOMCode | String | Code that identifies the unit of measure. |
UOM | String | Abbreviation that identifies the unit of measure on the agreement line |
Price | Decimal | Unit price for the line. |
Amount | Decimal | Value that identifies the amount agreed on an agreement line between the buying and selling organization. |
CurrencyCode | String | Code that identifies the purchase order currency. |
Currency | String | Currency on the purchase agreement line. |
ConsignmentLineFlag | 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. |
NoteToSupplier | String | Value that uniquely identifies a note to supplier. |
AllowItemDescriptionUpdateFlag | Bool | Value that identifies whether item descriptions can be updated on document lines. |
PriceLimit | Decimal | Value that identifies the price limit that you can't exceed on a release shipment. |
AllowPriceOverrideFlag | Bool | Value that identifies if you can change the price on release shipments. Possible values are Y and N. This attribute doesn't have a default value. |
NegotiatedFlag | Bool | Contains one of the following values: true or false. If true, then the buyer and the supplier negotiated and agreed on the price before the purchase. If false, then the buyer and the supplier didn't negotiate the price before the purchase. This attribute doesn't have a default value. |
ExpirationDate | Date | Value that identifies the expiration date of the document. |
MinimumReleaseAmount | Decimal | Value that identifies the minimum amount that can be released against a blanket or planned purchase order. |
AgreementAmount | Decimal | Value that identifies the amount agreed for an agreement line. |
AgreementQuantity | Decimal | Quantity agreed for an agreement line. |
ReleasedAmount | Decimal | Value that identifies the amount released against this agreement. It's the sum of all the approved standard PO amounts. |
PriceBreakTypeCode | String | Value that identifies the pricing scheme for the price breaks of this line. |
SupplierItemAuxiliaryIdentifier | String | Value that uniquely identifies the item information. |
ParentItemId | Long | Value that uniquely identifies the parent option class or model for the item. |
SupplierParentItem | String | Value that identifies the supplier's identification number for the option class or model associated with item. |
TopModelId | Long | Value that uniquely identifies the top model associated with the option, option class, or submodel. |
SupplierTopModel | String | Value that identifies the top model associated with the option or option class, or submodel. |
UnNumberId | Long | Value that uniquely identifies the number that the United Nations uses to identify hazardous material. |
UnNumber | String | Value that identifies the United Nations identification number for the hazardous material. |
UNNumberDescription | String | Value that uniquely identifies the number that the United Nations uses to identify hazardous material. |
HazardClassId | Long | Value that uniquely identifies the hazard class. |
HazardClassCode | String | Code that identifies the hazard class. |
HazardClass | String | Name of the hazard class. |
AgingPeriodDays | Int | Value that identifies the maximum number of days the material may be on consignment. |
CreatedBy | String | User who created the purchase agreement line. |
CreationDate | Datetime | Date and time when the buyer or application created the purchase agreement line. |
LastUpdatedBy | String | User who last updated the purchase agreement line. |
LastUpdateDate | Datetime | Date and time when the buyer or application last updated the purchase agreement line |
Finder | String | finder |
EffectiveDate | Date | This query parameter is used to fetch resources which are effective dated as of the specified start date. |