PurchaseAgreementLinesitemAttributes
Agreement item attribute captures additional information about the item on the agreement line such as supplier item auxiliary identifier, supplier URL, manufacturer name, manufacturer URL, manufacturer part number, United Nations Standard Products and Services Code, UNSPSC, and image URL. For example, Big Computers could be the manufacturer of a laptop whereas B004521 could be the manufacturer part number for a television.
Columns
Name | Type | Description |
PurchaseAgreementLinesAgreementLineId [KEY] | Long | PurchaseAgreementLinesAgreementLineId of PurchaseAgreementLinesitemAttributes |
AttributeValuesId [KEY] | Long | AttributeValuesId of PurchaseAgreementLinesitemAttributes |
AttributeValuesTlpId | Long | AttributeValuesTlpId of PurchaseAgreementLinesitemAttributes |
LongDescription | String | LongDescription of PurchaseAgreementLinesitemAttributes |
SupplierURL | String | SupplierURL of PurchaseAgreementLinesitemAttributes |
Manufacturer | String | Manufacturer of PurchaseAgreementLinesitemAttributes |
ManufacturerURL | String | ManufacturerURL of PurchaseAgreementLinesitemAttributes |
ManufacturerPartNumber | String | ManufacturerPartNumber of PurchaseAgreementLinesitemAttributes |
AttachmentURL | String | AttachmentURL of PurchaseAgreementLinesitemAttributes |
Alias | String | Alias of PurchaseAgreementLinesitemAttributes |
LeadTimeDays | Decimal | LeadTimeDays of PurchaseAgreementLinesitemAttributes |
UNSPSC | String | UNSPSC of PurchaseAgreementLinesitemAttributes |
ImageURL | String | ImageURL of PurchaseAgreementLinesitemAttributes |
ThumbnailImageURL | String | ThumbnailImageURL of PurchaseAgreementLinesitemAttributes |
Availability | String | Availability of PurchaseAgreementLinesitemAttributes |
RoundingFactor | Double | RoundingFactor of PurchaseAgreementLinesitemAttributes |
PackagingString | String | PackagingString of PurchaseAgreementLinesitemAttributes |
CreatedBy | String | CreatedBy of PurchaseAgreementLinesitemAttributes |
CreationDate | Datetime | CreationDate of PurchaseAgreementLinesitemAttributes |
LastUpdateDate | Datetime | LastUpdateDate of PurchaseAgreementLinesitemAttributes |
LastUpdatedBy | String | LastUpdatedBy of PurchaseAgreementLinesitemAttributes |
AgreementLineId | Long | AgreementLineId of PurchaseAgreementLinesitemAttributes |
Finder | String | Finder of PurchaseAgreementLinesitemAttributes |