Purchase_DIM Table

FlexNet Manager Suite (Cloud)

Purchase_DIM is a dimension table storing all purchase information.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database 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.
Table 1. Database columns for Purchase_DIM table

Database Column

Details

PurchaseOrderDetailID

Type: integer. Key

Foreign key of the purchaseorder.

PurchaseNo

Type: text (max 50 characters). Nullable

Purchase No of the purchase.

PurchaseDescription

Type: text (max 250 characters)

Purchase Description of the purchase.

EffectiveQuantity

Type: integer. Nullable

Effective Quantity of the purchase.

PurchaseDate

Type: datetime

Purchase date of the purchase.

CreationDate

Type: datetime

Creation date of the purchase.

PublisherName

Type: text (max 64 characters). Nullable

Publisher name of the purchase.

VendorName

Type: text (max 64 characters). Nullable

Vendor name of the purchase.

FlexNet Manager Suite (Cloud)

Current