PersonalShoppingListslines
Breaks down a personal shopping list into individual items or services, enabling faster selection during requisitioning.
Columns
| Name | Type | 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 | 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 | The name or identifier of the personal shopping list to which the shopping list line belongs. |