ShoppingCatalogSmartFormDetails
Represents the smart form configuration for procuring items or services, capturing fields and validation logic for shopper input.
Columns
| Name | Type | Description |
| SmartFormId [KEY] | Long | The unique identifier for the smart form in the shopping catalog. Example: 1001 for SmartForm ID 1001. |
| ProcurementBUId | Long | The unique identifier for the business unit responsible for managing the procurement of items within the smart form. Example: 2001 for Procurement Business Unit A. |
| ProcurementBU | String | The name of the procurement business unit. Example: 'Procurement' for the department managing requisitions. |
| SmartFormName | String | The name of the smart form used in the shopping catalog. Example: 'Office Supplies Order Form' for a specific order form. |
| InstructionText | String | The instructional text provided for users filling out the smart form. Example: 'Please select the items you wish to purchase.' |
| LineTypeId | Long | The unique identifier for the type of line item in the smart form. Example: 3001 for a line item in the form. |
| LineType | String | The type of line item within the smart form. Example: 'Product' for items that represent individual products. |
| ProductType | String | The type of product associated with the smart form. Example: 'Electronics' for items that fall under electronics category. |
| PurchaseBasis | String | The basis on which the purchase is made. Example: 'Per Unit' for purchases made based on individual unit pricing. |
| ItemDescription | String | A description of the item in the smart form. Example: 'Laptop 15 inch with 16GB RAM' for a detailed description of the product. |
| DescriptionEditableFlag | Bool | Indicates whether the description field is editable by the user. Example: true if the description can be edited, false if it is fixed. |
| RestrictToBrowsingCategoryId | Long | The ID of the category that limits the browsing to certain items within the smart form. Example: 4001 for restricting the form to electronics only. |
| RestrictToBrowsingCategoryName | String | The name of the category that restricts browsing for items. Example: 'Office Supplies' for limiting item selection to office supplies. |
| CategoryId | Long | The unique identifier for the category under which the items in the smart form are listed. Example: 5001 for the category of 'Laptops'. |
| CategoryName | String | The name of the category for the items in the smart form. Example: 'Electronics' for the category name. |
| CategoryEditableFlag | Bool | Indicates whether the category name is editable. Example: true if users can modify the category, false if the category is fixed. |
| CurrencyCode | String | The currency code for pricing in the smart form. Example: 'USD' for U.S. Dollars. |
| Currency | String | The currency used for the pricing of the items in the smart form. Example: 'USD' for U.S. Dollars. |
| CurrencyEditableFlag | Bool | Indicates whether the currency field is editable. Example: true if users can select a different currency, false if it is locked. |
| Quantity | Decimal | The quantity of items being ordered in the smart form. Example: 5 for ordering five units of an item. |
| UOMCode | String | The unit of measure code for the items in the smart form. Example: 'EA' for 'Each' unit of measure. |
| UOM | String | The unit of measure for the item in the smart form. Example: 'Each' for individual units of the item. |
| UOMEditableFlag | Bool | Indicates whether the unit of measure is editable. Example: true if users can change the UOM, false if it is fixed. |
| UnitPrice | Decimal | The unit price of the item in the smart form. Example: 20.00 for the price of one unit of the item. |
| UnitPriceEditableFlag | Bool | Indicates whether the unit price is editable. Example: true if the price can be modified, false if it is fixed. |
| Amount | Decimal | The total amount for the item in the smart form, calculated based on quantity and unit price. Example: 100.00 for 5 units at 20.00 each. |
| AmountEditableFlag | Bool | Indicates whether the total amount is editable. Example: false if the amount is calculated automatically and cannot be changed. |
| NegotiationRequiredFlag | Bool | Indicates whether negotiation is required for the item. Example: true if the item requires a negotiation process before purchase. |
| NegotiationRequiredEditableFlag | Bool | Indicates whether the negotiation required flag is editable. Example: false if the flag is automatically set based on item characteristics. |
| NegotiatedByPreparerFlag | Bool | Indicates whether the item was negotiated by the preparer. Example: true if the preparer has negotiated the item pricing. |
| NegotiatedEditableFlag | Bool | Indicates whether the negotiated price is editable. Example: false if the negotiated price cannot be changed by the user. |
| SourceAgreementHeaderId | Long | The unique identifier for the source agreement header associated with the item. Example: 6001 for the agreement header ID. |
| AgreementEditableFlag | Bool | Indicates whether the agreement is editable. Example: false if the agreement terms are fixed and cannot be changed. |
| SourceAgreement | String | The source agreement associated with the item. Example: 'AGT-123' for a specific agreement that covers the item. |
| SupplierId | Long | The unique identifier for the supplier associated with the item in the smart form. Example: 7001 for Supplier ID 7001. |
| Supplier | String | The name of the supplier providing the item. Example: 'XYZ Supplies' for the company supplying the items. |
| SupplierEditableFlag | Bool | Indicates whether the supplier name is editable. Example: false if the supplier is pre-selected and cannot be changed. |
| SupplierSiteId | Long | The unique identifier for the supplier site associated with the item. Example: 8001 for Supplier Site ID 8001. |
| SupplierSite | String | The name of the supplier site from which the item will be shipped. Example: 'Main Warehouse' for the shipping site. |
| SupplierSiteEditableFlag | Bool | Indicates whether the supplier site is editable. Example: true if users can select a different site, false if it is fixed. |
| SupplierContactId | Long | The unique identifier for the supplier contact associated with the item. Example: 9001 for Supplier Contact ID 9001. |
| SupplierContact | String | The name of the supplier contact. Example: 'John Doe' for the contact person at the supplier. |
| SupplierContactEditableFlag | Bool | Indicates whether the supplier contact is editable. Example: true if users can change the contact person, false if it is fixed. |
| SupplierContactPhone | String | The phone number for the supplier contact. Example: '(123) 456-7890' for the contact’s phone number. |
| SupplierContactPhoneEditableFlag | Bool | Indicates whether the supplier contact phone number is editable. Example: true if users can modify the phone number. |
| SupplierContactFax | String | The fax number for the supplier contact. Example: '(123) 456-7891' for the contact’s fax number. |
| SupplierContactFaxEditableFlag | Bool | Indicates whether the supplier contact fax number is editable. Example: true if users can modify the fax number. |
| SupplierContactEmail | String | The email address for the supplier contact. Example: '[email protected]' for the contact’s email. |
| SupplierContactEmailEditableFlag | Bool | Indicates whether the supplier contact email is editable. Example: true if users can update the email address. |
| SupplierItemNumber | String | The supplier-specific part number for the item. Example: 'SUP12345' for the part number assigned by the supplier. |
| SupplierItemEditableFlag | Bool | Indicates whether the supplier item number is editable. Example: false if the item number is pre-populated and cannot be modified. |
| Manufacturer | String | The manufacturer of the item. Example: 'Logitech' for the manufacturer of a wireless mouse. |
| ManufacturerEditableFlag | Bool | Indicates whether the manufacturer field is editable. Example: true if users can select a different manufacturer. |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer. Example: 'LGT123' for the manufacturer’s part number. |
| PartNumberEditableFlag | Bool | Indicates whether the manufacturer part number is editable. Example: false if the part number is fixed and cannot be changed. |
| CreatedBy | String | The name of the user who created the smart form. Example: 'John Doe' for the creator of the form. |
| CreationDate | Datetime | The date and time when the smart form was created. Example: '2023-06-01 10:00:00' for the creation timestamp. |
| LastUpdateDate | Datetime | The date and time when the smart form was last updated. Example: '2023-06-05 14:00:00' for the last update timestamp. |
| LastUpdatedBy | String | The name of the user who last updated the smart form. Example: 'Jane Smith' for the person who last modified the form. |
| LineTypeOrderTypeLookupCode | String | The lookup code that defines the order type for the line item. Example: 'EXPENSE' for an expense-type order. |
| AllowOrderFromUnassignedSitesFlag | Bool | Indicates whether the smart form allows orders from unassigned sites. Example: true if orders can be placed from any site, false if restricted. |
| Finder | String | A reference or placeholder used for searching and locating specific shopping catalog smart form detail records. Example: 'Search by Supplier' or 'Search by Smart Form ID'. |
| SysEffectiveDate | String | The system-effective date used to filter resources based on their effective date. Example: '2023-06-01' for filtering by this date. |
| EffectiveDate | Date | This query parameter is used to fetch resources that are effective as of the specified start date. Example: '2023-06-01' for the resources effective from June 1st, 2023. |