PublicShoppingListLines
The Public Shopping List Lines resource manages the public shopping list lines. Public shopping list lines are a collection of items that are available to preparers or requesters to create a requisition. You must have the necessary roles and privileges to use this REST resource. For additional details, refer to the Job Roles and Privileges and Status Codes topics. You can use Oracle Visual Builder Add-in for Excel to integrate web applications via REST resources to retrieve, analyze, and edit data. For more information, refer to Use Visual Builder Add-in for Excel to Manage Web Applications Data in the Learn More section of this guide.
Columns
| Name | Type | Description |
| ProcurementBUId | Long | Value that uniquely identifies the procurement business unit in which the public shopping list is created. |
| ProcurementBU | String | Name of the procurement business unit in which the public shopping list is created. |
| PublicShoppingListHeaderId | Long | Value that uniquely identifies the public shopping list. |
| PublicShoppingList | String | Name of the public shopping list. |
| PublicShoppingListDescription | String | PublicShoppingListDescription of PublicShoppingListLines |
| PublicShoppingListEndDate | Date | PublicShoppingListEndDate of PublicShoppingListLines |
| PublicShoppingListStartDate | Date | PublicShoppingListStartDate of PublicShoppingListLines |
| PublicShoppingListLineId [KEY] | Long | PublicShoppingListLineId of PublicShoppingListLines |
| Sequence | Decimal | Order in which the items are displayed to the preparer or requester. |
| LineType | String | LineType of PublicShoppingListLines |
| ItemId | Long | Value that uniquely identifies the item. |
| Item | String | Name of the item of the public shopping list line. |
| ItemRevision | String | ItemRevision of PublicShoppingListLines |
| ItemDescription | String | ItemDescription of PublicShoppingListLines |
| CategoryName | String | CategoryName of PublicShoppingListLines |
| CategoryId | String | CategoryId of PublicShoppingListLines |
| SuggestedQuantity | Decimal | Quantity suggested by the catalog administrator to the preparer or requester. |
| UOM | String | UOM of PublicShoppingListLines |
| Price | Decimal | Price of PublicShoppingListLines |
| CurrencyCode | String | CurrencyCode of PublicShoppingListLines |
| Amount | Decimal | Amount of PublicShoppingListLines |
| Supplier | String | Supplier of PublicShoppingListLines |
| SupplierItem | String | SupplierItem of PublicShoppingListLines |
| AgreementLineId | Long | Value that uniquely identifies the line of the source agreement referenced by the public shopping list line. |
| Agreement | String | Number that identifies the source agreement referenced by the public shopping list line. |
| AgreementLine | Decimal | Number that identifies the line of the source agreement referenced by the public shopping list line. |
| Buyer | String | Buyer of PublicShoppingListLines |
| NegotiatedFlag | Bool | NegotiatedFlag of PublicShoppingListLines |
| NegotiationRequiredFlag | Bool | NegotiationRequiredFlag of PublicShoppingListLines |
| CreatedBy | String | CreatedBy of PublicShoppingListLines |
| CreationDate | Datetime | CreationDate of PublicShoppingListLines |
| LastUpdateDate | Datetime | LastUpdateDate of PublicShoppingListLines |
| LastUpdatedBy | String | LastUpdatedBy of PublicShoppingListLines |
| InventoryOrganizationId | Long | InventoryOrganizationId of PublicShoppingListLines |
| InventoryOrganization | String | InventoryOrganization of PublicShoppingListLines |
| IndexSyncPendingFlag | Bool | IndexSyncPendingFlag of PublicShoppingListLines |
| Finder | String | Finder of PublicShoppingListLines |