PurchaseAgreementLines
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 |
AgreementLineId [KEY] | Long | AgreementLineId of PurchaseAgreementLines |
LineNumber | Decimal | LineNumber of PurchaseAgreementLines |
AgreementHeaderId | Long | AgreementHeaderId of PurchaseAgreementLines |
AgreementNumber | String | AgreementNumber of PurchaseAgreementLines |
ProcurementBUId | Long | ProcurementBUId of PurchaseAgreementLines |
ProcurementBU | String | ProcurementBU of PurchaseAgreementLines |
SupplierId | Long | SupplierId of PurchaseAgreementLines |
Supplier | String | Supplier of PurchaseAgreementLines |
SupplierSiteId | Long | SupplierSiteId of PurchaseAgreementLines |
SupplierSite | String | SupplierSite of PurchaseAgreementLines |
LineTypeId | Long | LineTypeId of PurchaseAgreementLines |
LineType | String | LineType of PurchaseAgreementLines |
ItemId | Long | ItemId of PurchaseAgreementLines |
Item | String | Item of PurchaseAgreementLines |
ItemRevision | String | ItemRevision of PurchaseAgreementLines |
Description | String | Description of PurchaseAgreementLines |
SupplierItem | String | SupplierItem of PurchaseAgreementLines |
CategoryId | Long | CategoryId of PurchaseAgreementLines |
CategoryCode | String | CategoryCode of PurchaseAgreementLines |
Category | String | Category of PurchaseAgreementLines |
StatusCode | String | StatusCode of PurchaseAgreementLines |
Status | String | Status of PurchaseAgreementLines |
UOMCode | String | UOMCode of PurchaseAgreementLines |
UOM | String | UOM of PurchaseAgreementLines |
Price | Decimal | Price of PurchaseAgreementLines |
Amount | Decimal | Amount of PurchaseAgreementLines |
CurrencyCode | String | CurrencyCode of PurchaseAgreementLines |
Currency | String | Currency of PurchaseAgreementLines |
ConsignmentLineFlag | Bool | ConsignmentLineFlag of PurchaseAgreementLines |
NoteToSupplier | String | NoteToSupplier of PurchaseAgreementLines |
AllowItemDescriptionUpdateFlag | Bool | AllowItemDescriptionUpdateFlag of PurchaseAgreementLines |
PriceLimit | Decimal | PriceLimit of PurchaseAgreementLines |
AllowPriceOverrideFlag | Bool | AllowPriceOverrideFlag of PurchaseAgreementLines |
NegotiatedFlag | Bool | NegotiatedFlag of PurchaseAgreementLines |
ExpirationDate | Date | ExpirationDate of PurchaseAgreementLines |
MinimumReleaseAmount | Decimal | MinimumReleaseAmount of PurchaseAgreementLines |
AgreementAmount | Decimal | AgreementAmount of PurchaseAgreementLines |
AgreementQuantity | Decimal | AgreementQuantity of PurchaseAgreementLines |
ReleasedAmount | Decimal | ReleasedAmount of PurchaseAgreementLines |
PriceBreakTypeCode | String | PriceBreakTypeCode of PurchaseAgreementLines |
SupplierItemAuxiliaryIdentifier | String | SupplierItemAuxiliaryIdentifier of PurchaseAgreementLines |
ParentItemId | Long | ParentItemId of PurchaseAgreementLines |
SupplierParentItem | String | SupplierParentItem of PurchaseAgreementLines |
TopModelId | Long | TopModelId of PurchaseAgreementLines |
SupplierTopModel | String | SupplierTopModel of PurchaseAgreementLines |
UnNumberId | Long | UnNumberId of PurchaseAgreementLines |
UnNumber | String | UnNumber of PurchaseAgreementLines |
UNNumberDescription | String | UNNumberDescription of PurchaseAgreementLines |
HazardClassId | Long | HazardClassId of PurchaseAgreementLines |
HazardClassCode | String | HazardClassCode of PurchaseAgreementLines |
HazardClass | String | HazardClass of PurchaseAgreementLines |
AgingPeriodDays | Int | AgingPeriodDays of PurchaseAgreementLines |
CreatedBy | String | CreatedBy of PurchaseAgreementLines |
CreationDate | Datetime | CreationDate of PurchaseAgreementLines |
LastUpdatedBy | String | LastUpdatedBy of PurchaseAgreementLines |
LastUpdateDate | Datetime | LastUpdateDate of PurchaseAgreementLines |
Finder | String | Finder of PurchaseAgreementLines |