fulfillmentrequest
Stores customer fulfillment requests and tracks order processing status.
Columns
| Name | Type | References | Description |
| assignee | String | The user or department assigned to handle this fulfillment request. | |
| createdfrom | String | The source transaction or record from which this fulfillment request was created. | |
| customform | String | The custom form identifier associated with this fulfillment request. | |
| entity | String | The customer, vendor, or entity associated with this fulfillment request. | |
| expirationdate | Date | The date when this fulfillment request expires if not processed. | |
| fulfillmenttype | String | The type of fulfillment, such as shipping or in-store pickup. | |
| ispickupemailnotificationsent | Boolean | Indicates whether an email notification has been sent for pickup fulfillment. | |
| location | String | The location or warehouse where this fulfillment request is being processed. | |
| memo | String | Additional notes or comments related to this fulfillment request. | |
| pickuphold | String | Indicates whether this fulfillment request is on hold for pickup. | |
| prevdate | Date | The previous scheduled date for this fulfillment request, if rescheduled. | |
| status | String | The current status of the fulfillment request (such as Pending, Completed, Canceled). | |
| subsidiary | String | The subsidiary associated with this fulfillment request, defining its organizational scope. | |
| trandate | Date | The transaction date for this fulfillment request. | |
| tranid | String | The transaction identifier assigned to this fulfillment request. | |
| transtatus | String | The transaction status, providing further details on fulfillment progress. |