PurchaseRequisitionslinesdistributionsDFF
Enables descriptive flexfields for requisition line distributions, adding specialized data for cost allocations.
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 a specific requisition. Example: 1001 for Requisition Header 1001. |
| LinesRequisitionLineId [KEY] | Long | The identifier for the requisition line within the requisition header, linking the DFF data to a specific line item. Example: 2001 for Line 1. |
| DistributionsRequisitionDistributionId [KEY] | Long | The unique identifier for the distribution associated with the requisition line, helping to track the allocation of costs and resources. Example: 3001 for Distribution ID 3001. |
| DistributionId [KEY] | Long | The unique identifier for the requisition distribution, used to track the distribution of costs or items within the requisition. Example: 4001 for Distribution 4001. |
| _FLEX_Context | String | The DFF context name, used to categorize or provide additional details for the requisition distribution. Example: 'PurchaseOrder' or 'MaterialRequest'. |
| _FLEX_Context_DisplayValue | String | The display value for the DFF context, providing a human-readable description of the context. Example: 'Purchase Order Distribution' or 'Material Request Distribution'. |
| BindPreparerId | Long | The unique identifier for the preparer who created the requisition line, helping to link the DFF data to the preparer's record. Example: 123 for 'John Doe'. |
| BindRequisitionHeaderId | Long | The unique identifier for the requisition header, linking the DFF data to the parent requisition. Example: 2001 for 'Requisition Header 2001'. |
| Finder | String | A placeholder or reference used for searching and locating the DFF data associated with requisition distributions. Example: 'Search by Distribution ID'. |
| RequisitionHeaderId | Long | The identifier for the requisition header, linking the DFF data to the specific requisition. Example: 1001 for Requisition Header 1001. |
| CUReferenceNumber | Int | The reference number used to map the child aggregates (such as DFF data) to their parent requisition or requisition line, ensuring data integrity. Example: 2001 for 'Requisition Line 1'. |
| EffectiveDate | Date | The date from which the DFF data is considered effective. This is typically used to filter records based on the validity of the data. Example: '2023-01-01' for data valid from the start of the year. |