PurchaseOrderDetailPropertyValue Table
For each purchase order line, PurchaseOrderDetailPropertyValue
stores the values for the custom properties defined in PurchaseOrderDetailProperty
.
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
PurchaseOrderDetail PropertyValueID
|
Type: integer. Key. Generated ID A unique identifier for a property value. |
PurchaseOrderDetailID
|
Type: integer. Key The purchase order line associated with the property. Foreign key to the |
PurchaseOrderDetail PropertyID
|
Type: integer. Key the property whose value is being stored. Foreign key to the |
PropertyValue
|
Type: text (max 4000 characters) The property value. |
CreationUser
|
Type: text (max 128 characters). Nullable The operator who created the record. |
CreationDate
|
Type: datetime The date the record was created. |
UpdatedUser
|
Type: text (max 128 characters). Nullable The operator who last updated the record. |
UpdatedDate
|
Type: datetime. Nullable The date the record was last updated. |
FlexNet Manager Suite (On-Premises)
2020 R1