LicensePurchase Table

LicensePurchase records details of purchases of licenses for a specified SoftwareProduct.

Table 1. Database columns for LicensePurchase table

Database Column

Details

SoftwareProductID

Type: integer. Key

The SoftwareProduct purchased.

ResellerID

Type: integer. Key

The Reseller from which the software product was purchased.

OrganizationID

Type: integer. Key

The organizational unit that owns the license for the product.

Purchased

Type: datetime. Key

When the purchase was made.

Expires

Type: datetime. Nullable

When the license expires.

Price

Type: integer. Nullable

The price paid for the license.

Quantity

Type: integer

Number of units licensed.

OrderNumber

Type: text (max 32 characters). Key

Cross-reference to customer’s purchase order number.