RequisitionPreferences
Stores user-defined requisition defaults—like favorite charge accounts, default delivery locations, or preference settings.
Columns
| Name | Type | Description |
| UserPreferenceId [KEY] | Long | The unique identifier for the user's requisition preferences. Example: 1001 for the preferences record associated with User ID 1001. |
| RequisitioningBUId | Long | The unique identifier for the business unit where the requisition preferences are applicable. Example: 2001 for Business Unit A. |
| RequisitioningBU | String | The name of the business unit where the requisition preferences are applicable. Example: 'Procurement' for the Procurement business unit. |
| PersonId | Long | The unique identifier for the user to whom the requisition preferences apply. Example: 3001 for the user 'John Doe'. |
| UserDisplayName | String | The display name of the user for whom the requisition preferences are set. Example: 'John Doe' for the user's name. |
| UserEmail | String | The email address of the user for whom the requisition preferences are applicable. Example: '[email protected]'. |
| RequesterId | Long | The unique identifier for the person making the requisition request. Example: 4001 for Requester ID 4001. |
| Requester | String | The name of the person making the requisition request. Example: 'Jane Smith' for the requester. |
| RequesterEmail | String | The email address of the person making the requisition request. Example: '[email protected]' for the requester's email. |
| DeliverToLocationId | Long | The unique identifier for the location to which the requisitioned goods should be delivered. Example: 5001 for the destination location. |
| DeliverToLocationCode | String | An abbreviation or code used to identify the location where goods should be delivered. Example: 'DLR1' for Delivery Location 1. |
| DeliverToLocationName | String | The name of the delivery location where requisitioned goods should be delivered. Example: 'Warehouse A'. |
| DeliverToAddress | String | The address to which goods should be delivered. Example: '1234 Elm St, Springfield'. |
| FormattedDeliverToAddress | String | A fully formatted version of the delivery address, combining all address components. Example: '1234 Elm St, Springfield, IL 62701'. |
| DestinationOrganizationId | Long | The unique identifier for the organization receiving the requisitioned goods. Example: 6001 for Receiving Organization A. |
| DestinationOrganization | String | The name of the organization receiving the requisitioned goods. Example: 'Sales Department'. |
| DestinationOrganizationCode | String | The code representing the organization receiving the requisitioned goods. Example: 'SALES' for the Sales organization. |
| DestinationTypeCode | String | A code representing the type of destination, such as INVENTORY, EXPENSE, or MANUFACTURING. Example: 'INVENTORY' for goods delivered to inventory. |
| DestinationType | String | The full description of the destination type, determining how goods should be charged. Example: 'Inventory' for goods delivered to inventory. |
| DestinationSubinventory | String | The subinventory or area within the destination organization where goods should be stored. Example: 'Main Warehouse'. |
| WorkOrderId | Long | The unique identifier for the work order associated with the requisition preferences. Example: 7001 for Work Order ID 7001. |
| WorkOrder | String | The name or reference of the work order associated with the requisition. Example: 'Repair Work Order #123'. |
| WorkOrderOperationId | Long | The identifier for the specific operation within the work order. Example: 8001 for Work Order Operation ID 8001. |
| WorkOrderOperationSequence | Decimal | The sequence number indicating the order of operations within the work order. Example: 1.1 for the first operation in sequence. |
| PreferenceType | String | The type of requisition preference to determine where the preferences are applied. Example: 'SSP' for Self-Service Procurement or 'WORK_ORDER' for work order related preferences. |
| OneTimeLocationFlag | Bool | Indicates whether the location is a one-time delivery address. Example: True if the location is for one-time use. |
| InvOrgEnabledForProjectTracking | String | Indicates if the inventory organization is enabled for project tracking. Example: 'Yes' if enabled for tracking requisitions related to projects. |
| ActivePreferenceFlag | Bool | Indicates whether the requisition preferences are active for the user. Example: True if the preferences are currently active, False if inactive. |
| WorkOrderInventoryOrganizationId | Long | The identifier for the inventory organization associated with the work order. Example: 9001 for the inventory organization used in the work order. |
| WorkOrderInventoryOrganizationCode | String | The code for the inventory organization associated with the work order. Example: 'WO_INV' for the work order inventory organization. |
| WorkOrderInventoryOrganization | String | The name of the inventory organization associated with the work order. Example: 'Work Order Inventory'. |
| CreatedBy | String | The username or identifier of the person who created the requisition preferences record. Example: 'admin' for the administrator who created the record. |
| CreationDate | Datetime | The date and time when the requisition preferences record was created. Example: '2023-06-01 09:00:00'. |
| LastUpdatedBy | String | The username or identifier of the person who last updated the requisition preferences record. Example: 'jdoe' for 'John Doe'. |
| LastUpdateDate | Datetime | The date and time when the requisition preferences record was last updated. Example: '2023-06-10 15:00:00'. |
| SetId | Long | The unique identifier for the set of requisition preferences, used to group preferences together. Example: 1001 for Set ID 1001. |
| DeliverToCustomerLocationId | Long | The unique identifier for the customer location to which materials should be delivered. Example: 1101 for Customer Location ID 1101. |
| DeliverToOneTimeAddress | String | A one-time delivery address for requisitioned goods or services. Example: '4567 Oak St, Springfield'. |
| RequisitionBUOptionsOrganizationId | Long | The unique identifier for the business unit options associated with requisitions. Example: 1201 for the Business Unit Options ID. |
| Finder | String | A reference or placeholder used for searching and locating specific requisition preference records. Example: 'Search by User ID' or 'Search by Business Unit'. |
| SysEffectiveDate | Date | The date from which the requisition preferences are effective. Example: '2023-06-01' to specify when the preferences are applicable. |
| EffectiveDate | Date | This query parameter is used to fetch resources which are effective as of the specified start date. Example: '2023-06-01' for fetching records effective from this date. |