PurchaseRequisitionsDFF
Stores descriptive flexfields at the requisition header level, enabling custom data elements beyond standard fields.
Columns
| Name | Type | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the descriptive flexfield (DFF) data, linking the DFF data to the corresponding requisition. |
| RequisitionHeaderId [KEY] | Long | The unique identifier for the requisition, used to reference and track the specific requisition record in the system. |
| _FLEX_Context | String | The DFF context name for the purchase requisition distribution, providing additional context or categorization for the DFF data. |
| _FLEX_Context_DisplayValue | String | The display value of the descriptive flexfield context for the purchase requisition distribution, providing a user-friendly description of the context. |
| BindPreparerId | Long | The unique identifier used to bind the preparer's data during operations on the requisition DFF record, helping to track the user responsible for the requisition. |
| BindRequisitionHeaderId | Long | The unique identifier used to bind the requisition header data during operations on the DFF record, ensuring it is correctly associated with the requisition. |
| Finder | String | A placeholder or reference used for searching and locating requisition DFF data within the system, making it easier to access related records. |
| CUReferenceNumber | Int | The reference number used to map child aggregates with their parent tables, ensuring data consistency and integrity within the system. |
| EffectiveDate | Date | The date from which the DFF data is considered effective, used to filter records based on their validity and ensure they are relevant to the specified date. |