PersonalShoppingListslines
Breaks down a personal shopping list into individual items or services, enabling faster selection during requisitioning.
Columns
| Name | Type | SupportedFinders | Description |
| PersonalShoppingListsPersonalShoppingListHeaderId [KEY] | Long | The unique identifier for the personal shopping list header associated with the shopping list line. | |
| PersonalShoppingListLineId [KEY] | Long | The unique identifier for each individual line in the personal shopping list. | |
| PersonalShoppingListHeaderId | Long | PrimaryKey | The unique identifier for the personal shopping list that the line belongs to. |
| PunchoutCatalogId | Long | The identifier for the punchout catalog referenced by the shopping list line, linking to an external catalog. | |
| PunchoutCatalog | String | The name or identifier of the punchout catalog linked to the shopping list line. | |
| ItemSource | String | Indicates the source of the item, such as a catalog or manual entry. | |
| RequisitioningBUId | Long | The unique identifier for the requisitioning business unit related to the shopping list line. | |
| RequisitioningBU | String | The name of the requisitioning business unit that created the shopping list line. | |
| SourceAgreementHeaderId | Long | The identifier for the source agreement associated with the shopping list line, which contains terms for the purchase. | |
| SourceAgreement | String | The number or code of the source agreement associated with the shopping list line. | |
| SourceAgreementLineId | Long | The identifier for the line within the source agreement referenced by the shopping list line. | |
| SourceAgreementLineNumber | Decimal | The specific line number within the source agreement that corresponds to the shopping list line. | |
| ItemId | Long | The unique identifier for the item listed on the shopping list line. | |
| Item | String | The name or abbreviation of the item listed on the shopping list line. | |
| PublicShoppingListHeaderId | Long | The identifier for the public shopping list associated with the shopping list line. | |
| SmartFormId | Long | The identifier for the smart form used for the shopping list line. | |
| SmartFormName | String | The name of the smart form referenced for the shopping list line, often used for customized data entry. | |
| ItemDescription | String | A detailed description of the item or service on the shopping list line. | |
| LineTypeId | Long | The identifier for the type of line, indicating whether the item is a good or a service. | |
| LineType | String | The type of item listed in the shopping list line, such as 'goods' or 'services'. | |
| ItemRevision | String | The revision number or version identifier for the item listed on the shopping list line. | |
| CategoryId | Long | The identifier for the purchasing category of the item on the shopping list line. | |
| CategoryName | String | The name of the purchasing category of the item listed on the shopping list line. | |
| UOMCode | String | The abbreviation for the unit of measure used for the item quantity on the shopping list line. | |
| UOM | String | The unit of measure (for example, each, box, kg) for the quantity of the item. | |
| UnitPrice | Decimal | The price per unit of the item on the shopping list line, in the currency of the buying company. | |
| Amount | Decimal | The total amount for the shopping list line item, calculated as unit price multiplied by quantity, in the currency of the buying company. | |
| SupplierId | Long | The unique identifier for the supplier providing the item or service on the shopping list line. | |
| Supplier | String | The name of the supplier responsible for fulfilling the goods or services on the shopping list line. | |
| SupplierSiteId | Long | The identifier for the supplier site from where the item or service is provided. | |
| SupplierSite | String | The name or identifier of the supplier location from which the item or service is sourced. | |
| SupplierContactId | Long | The unique identifier for the supplier contact person for the shopping list line. | |
| SupplierContact | String | The name of the person representing the supplier for communication regarding the shopping list line. | |
| SupplierContactEmail | String | The email address of the supplier contact for communication regarding the shopping list line. | |
| SupplierContactPhone | String | The phone number of the supplier contact for communication regarding the shopping list line. | |
| SupplierContactFax | String | The fax number of the supplier contact for communication regarding the shopping list line. | |
| SuggestedSupplier | String | The name of a suggested new supplier for fulfilling the goods or services on the shopping list line. | |
| SuggestedSupplierSite | String | The identifier or name of the suggested supplier site for fulfilling the goods or services. | |
| SuggestedSupplierContact | String | The name of the person representing the suggested new supplier for the shopping list line. | |
| SuggestedSupplierContactPhone | String | The phone number of the contact person at the suggested new supplier. | |
| SuggestedSupplierContactFax | String | The fax number of the contact person at the suggested new supplier. | |
| SuggestedSupplierContactEmail | String | The email address of the contact person at the suggested new supplier. | |
| SuggestedSupplierItemNumber | String | The item number assigned by the suggested supplier for the item on the shopping list line. | |
| ManufacturerId | Decimal | The unique identifier for the manufacturer of the item on the shopping list line. | |
| ManufacturerName | String | The name of the manufacturer for the item on the shopping list line. | |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer for the item on the shopping list line. | |
| NegotiationRequiredFlag | Bool | Indicates whether a request for quotation (RFQ) is required before placing the requisition on a purchase order (true or false). | |
| NewSupplierFlag | Bool | Indicates whether the supplier on the shopping list line is a new supplier (true) or an existing supplier (false). | |
| CurrencyCode | String | The abbreviation for the currency used in the shopping list line. | |
| Currency | String | The name of the currency used for the shopping list line. | |
| ConversionRateType | String | The type of exchange rate used for converting currencies in the purchase requisition. | |
| ConversionRate | Decimal | The rate used to convert one currency to another for the shopping list line. | |
| ConversionRateDate | Date | The date from which the specified conversion rate is valid. | |
| NegotiatedByPreparerFlag | Bool | Indicates whether the price of the item was agreed upon in advance by the preparer (true or false). | |
| BPAPriceUserOverrideFlag | Bool | Indicates whether the blanket purchase agreement (BPA) price has been manually overridden by the user (true or false). | |
| CreatedBy | String | The identifier for the user who created the personal shopping list line. | |
| CreationDate | Datetime | The date and time when the personal shopping list line was created. | |
| LastUpdatedBy | String | The identifier for the user who last updated the personal shopping list line. | |
| LastUpdateDate | Datetime | The date and time when the personal shopping list line was last updated. | |
| InventoryOrganizationId | Long | The unique identifier for the inventory organization where the item for the shopping list line is stored. | |
| InventoryOrganization | String | The name of the inventory organization that provides the item for the shopping list line. | |
| InventoryOrganizationCode | String | The abbreviation or code that identifies the inventory organization for the shopping list line item. | |
| LineImageURL | String | The URL for the image representing the specific shopping list line. | |
| SuggestedQuantity | Decimal | The suggested default quantity for the personal shopping list line. | |
| Finder | String | The finder function used to retrieve or search for personal shopping list lines. | |
| PersonalShoppingList | String | FindByPersonalShoppingList | The name or identifier of the personal shopping list to which the shopping list line belongs. |