TradingPartnerItemRelationshipsDFF
Handles descriptive flexfields for trading partner item relationships to manage custom attributes.
Columns
| Name | Type | Description |
| TradingPartnerItemRelationshipsItemRelationshipId [KEY] | Long | Specifies the unique identifier for the trading partner item relationship within the TradingPartnerItemRelationshipsDFF module. This identifier links item relationship records to their associated descriptive flexfields (DFFs), allowing for additional custom attributes. |
| ItemRelationshipId [KEY] | Long | Defines the unique identifier for the item relationship between the organization and its trading partner. This identifier ensures that the association between internal and external items is correctly tracked and managed. |
| ItemRelationshipType | String | Represents the type of item relationship established with the trading partner. This relationship can indicate whether the item is a supplier item, customer item, competitor item, or any other business-specific relationship. |
| _FLEX_ValidationDate | Date | Specifies the date on which the DFF attributes for the trading partner item relationship were last validated. This date ensures data accuracy and compliance with predefined attribute rules. |
| _FLEX_Context | String | Defines the DFF context name assigned to the trading partner item relationship. This context name determines how additional custom attributes are structured and applied to the relationship. |
| _FLEX_NumOfSegments | Int | Indicates the total number of segments within the DFF for the trading partner item relationship. This value determines how many attributes can be customized for classification and reporting. |
| _FLEX_NumOfVisibleSegments | Int | Specifies the number of visible segments within the DFF for the trading partner item relationship. This value controls which attributes are displayed to users when managing item relationships. |
| EffectiveDate | Datetime | Indicates the date when the trading partner item relationship becomes effective. This date ensures proper activation timing for transactions, reporting, and supplier or customer interactions. |
| Finder | String | Defines the search mechanism or query criteria used to locate records in the TradingPartnerItemRelationshipsDFF module. This value enhances system usability by enabling efficient data retrieval for item relationships and associated DFFs. |
| ItemNumber | String | Represents the internal item number used by the organization. This item number ensures that internal records are accurately linked to external trading partner items for seamless integration and traceability. |