PublicShoppingListLines
Represents items included in a publicly accessible shopping list, shared across multiple users or business units.
Columns
| Name | Type | Description |
| ProcurementBUId | Long | The unique identifier for the procurement business unit where the public shopping list is created, linking it to the respective business unit. |
| ProcurementBU | String | The name of the procurement business unit in which the public shopping list is created, indicating the specific business unit responsible for the list. |
| PublicShoppingListHeaderId | Long | The unique identifier for the public shopping list header, linking it to the overall shopping list. |
| PublicShoppingList | String | The name of the public shopping list, used to identify it in the procurement system. |
| PublicShoppingListDescription | String | A description of the public shopping list, providing additional details about its purpose or contents. |
| PublicShoppingListEndDate | Date | The end date when the public shopping list is no longer valid or accessible for new additions or updates. |
| PublicShoppingListStartDate | Date | The start date when the public shopping list becomes available or active for use. |
| PublicShoppingListLineId [KEY] | Long | The unique identifier for each line within the public shopping list, linking it to a specific item or service. |
| Sequence | Decimal | The order or position in which items appear on the public shopping list, determining how they are displayed to users. |
| LineType | String | The type of line, indicating whether the item on the public shopping list is a product or service. |
| ItemId | Long | The unique identifier for the item listed on the public shopping list line. |
| Item | String | The name or identifier of the item listed on the public shopping list line. |
| ItemRevision | String | The revision number or version of the item listed on the public shopping list line, showing any updates or changes. |
| ItemDescription | String | A description of the item listed on the public shopping list line, explaining what it is and its purpose. |
| CategoryName | String | The name of the category to which the item belongs on the public shopping list, organizing the list by item types. |
| CategoryId | String | The identifier for the category of the item on the public shopping list, used for organizational purposes. |
| SuggestedQuantity | Decimal | The quantity suggested by the catalog administrator for the item on the public shopping list, guiding the preparer or requester. |
| UOM | String | The unit of measure (for example, each, box, kg) used for the item quantity on the public shopping list. |
| Price | Decimal | The price of the item on the public shopping list line, typically in the currency of the buyer's organization. |
| CurrencyCode | String | The currency code representing the currency used for the item price on the public shopping list. |
| Amount | Decimal | The total amount for the item on the public shopping list line, calculated as price times quantity. |
| Supplier | String | The name of the supplier providing the item or service on the public shopping list. |
| SupplierItem | String | The item number or identifier assigned by the supplier for the item listed on the public shopping list. |
| AgreementLineId | Long | The unique identifier for the line of the source agreement associated with the public shopping list item. |
| Agreement | String | The number or code of the source agreement that the public shopping list item references. |
| AgreementLine | Decimal | The specific line number within the source agreement that corresponds to the item on the public shopping list. |
| Buyer | String | The name of the buyer responsible for procuring the item listed on the public shopping list. |
| NegotiatedFlag | Bool | Indicates whether the item price has been negotiated by the buyer (true) or is at standard pricing (false). |
| NegotiationRequiredFlag | Bool | Indicates whether negotiation is required before placing the item on a purchase order (true) or not (false). |
| CreatedBy | String | The name of the person or system that created the public shopping list line. |
| CreationDate | Datetime | The date and time when the public shopping list line was created. |
| LastUpdateDate | Datetime | The date and time when the public shopping list line was last updated. |
| LastUpdatedBy | String | The name of the person or system that last updated the public shopping list line. |
| InventoryOrganizationId | Long | The unique identifier for the inventory organization associated with the public shopping list line. |
| InventoryOrganization | String | The name of the inventory organization that is responsible for fulfilling the public shopping list item. |
| IndexSyncPendingFlag | Bool | Indicates whether the item on the public shopping list line is pending synchronization with the indexing system (true or false). |
| Finder | String | The function or mechanism used to search for or retrieve public shopping list lines, facilitating item discovery. |
| EffectiveDate | Date | The date parameter used to filter resources and fetch those that are effective as of this specified start date, ensuring accurate and timely data. |