PurchaseRequisitionsspecialHandlingDFF
Enables descriptive flexfields for special handling instructions at the requisition header, ensuring compliance or safety measures.
Columns
| Name | Type | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the special handling descriptive flexfield (DFF) data, linking the DFF data to a specific requisition. Example: 1001 for Requisition Header 1001. |
| RequisitionHeaderId [KEY] | Long | The identifier for the requisition header, linking the special handling DFF data to the parent requisition. Example: 2001 for 'Requisition Header 2001'. |
| _FLEX_Context | String | The DFF context name, used to categorize or provide additional details for the special handling requirements in the requisition. Example: 'ShippingInstructions' or 'PriorityHandling'. |
| _FLEX_Context_DisplayValue | String | The display value for the descriptive flexfield context, offering a human-readable version of the context. Example: 'Shipping Instructions' or 'Priority Handling Required'. |
| BindPreparerId | Long | The unique identifier for the preparer who created the requisition, linking the special handling DFF data to the preparer's information. Example: 123 for 'John Doe'. |
| BindRequisitionHeaderId | Long | The unique identifier for the requisition header, linking the special handling DFF data to the parent requisition. Example: 2001 for 'Requisition Header 2001'. |
| Finder | String | A reference or placeholder used for searching and locating specific special handling DFF data within the system. Example: 'Search by Special Handling Code' or 'Search by Requisition ID'. |
| CUReferenceNumber | Int | The reference number used to map child aggregates (such as special handling DFF data) to their parent requisition, ensuring data integrity. Example: 2001 for 'Requisition Line 1'. |
| EffectiveDate | Date | The date from which the special handling DFF data is considered effective. This date is used to filter records by their validity. Example: '2023-01-01' for data valid from the start of the year. |