PurchaseRequisitionslinesinformationTemplates
Associates custom information templates (for example, extra fields or questionnaires) with requisition lines for specialized scenarios.
Columns
| Name | Type | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | The unique identifier for the requisition header associated with the information template data, linking the template 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 information template to a specific line item. Example: 2001 for Line 1. |
| RequisitionLineId | Long | The unique identifier for the requisition line, used to track a specific line item in the requisition. Example: 3001 for Requisition Line ID 3001. |
| InformationTemplateValuesId [KEY] | Long | The unique identifier for the information template values associated with the requisition line, helping to track the specific values in the template. Example: 4001 for Template Value ID 4001. |
| InformationTemplateId | Long | The identifier for the information template, used to link the requisition line to a specific template. Example: 5001 for 'Purchase Order Template'. |
| InformationTemplateDisplayName | String | The display name of the information template, offering a human-readable description of the template used for the requisition line. Example: 'Purchase Order Template'. |
| InformationTemplate | String | The name of the information template, which could refer to a predefined form or format used for the requisition line. Example: 'Invoice Details' or 'Purchase Order'. |
| BindPreparerId | Long | The unique identifier for the preparer who created the requisition line, linking the information template data to the preparer. Example: 123 for 'John Doe'. |
| BindRequisitionHeaderId | Long | The unique identifier for the requisition header, linking the information template data to the parent requisition. Example: 2001 for 'Requisition Header 2001'. |
| Finder | String | A reference or placeholder used for searching and locating specific information template data in the system. Example: 'Search by Template Name' or 'Search by Template ID'. |
| RequisitionHeaderId | Long | The identifier for the requisition header, linking the information template data to the parent requisition record. Example: 1001 for 'Requisition Header 1001'. |
| CUReferenceNumber | Int | The reference number that maps child aggregates, such as information templates, to their parent requisition or requisition line, ensuring data integrity. Example: 2001 for 'Requisition Line 1'. |
| EffectiveDate | Date | The date from which the information template data is considered effective. This date is typically used to filter records by their validity. Example: '2023-01-01' for data valid from the start of the year. |