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