PurchaseAgreementslinesitemAttributes
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 |
PurchaseAgreementsAgreementHeaderId [KEY] | Long | PurchaseAgreementsAgreementHeaderId of PurchaseAgreementslinesitemAttributes |
LinesAgreementLineId [KEY] | Long | LinesAgreementLineId of PurchaseAgreementslinesitemAttributes |
AttributeValuesId [KEY] | Long | AttributeValuesId of PurchaseAgreementslinesitemAttributes |
AttributeValuesTlpId | Long | AttributeValuesTlpId of PurchaseAgreementslinesitemAttributes |
LongDescription | String | LongDescription of PurchaseAgreementslinesitemAttributes |
SupplierURL | String | SupplierURL of PurchaseAgreementslinesitemAttributes |
Manufacturer | String | Manufacturer of PurchaseAgreementslinesitemAttributes |
ManufacturerURL | String | ManufacturerURL of PurchaseAgreementslinesitemAttributes |
ManufacturerPartNumber | String | ManufacturerPartNumber of PurchaseAgreementslinesitemAttributes |
AttachmentURL | String | AttachmentURL of PurchaseAgreementslinesitemAttributes |
Alias | String | Alias of PurchaseAgreementslinesitemAttributes |
LeadTimeDays | Decimal | LeadTimeDays of PurchaseAgreementslinesitemAttributes |
UNSPSC | String | UNSPSC of PurchaseAgreementslinesitemAttributes |
ImageURL | String | ImageURL of PurchaseAgreementslinesitemAttributes |
ThumbnailImageURL | String | ThumbnailImageURL of PurchaseAgreementslinesitemAttributes |
Availability | String | Availability of PurchaseAgreementslinesitemAttributes |
RoundingFactor | Double | RoundingFactor of PurchaseAgreementslinesitemAttributes |
PackagingString | String | PackagingString of PurchaseAgreementslinesitemAttributes |
CreatedBy | String | CreatedBy of PurchaseAgreementslinesitemAttributes |
CreationDate | Datetime | CreationDate of PurchaseAgreementslinesitemAttributes |
LastUpdateDate | Datetime | LastUpdateDate of PurchaseAgreementslinesitemAttributes |
LastUpdatedBy | String | LastUpdatedBy of PurchaseAgreementslinesitemAttributes |
AgreementHeaderId | Long | AgreementHeaderId of PurchaseAgreementslinesitemAttributes |
Finder | String | Finder of PurchaseAgreementslinesitemAttributes |