PurchaseStatus_CODE Table

PurchaseStatus CODE is a dimension table storing purchase status information.

Table 1. Database columns for PurchaseStatus_CODE table

Database Column

Details

PurchaseStatusID

Type: integer. Key

A unique identifier for Purchase status. Possible values and the corresponding default strings are:

  • 1 = New
  • 2 = Pending
  • 3 = Completed
  • 4 = Cancelled
PurchaseStatus_en

Type: text (max 1000 characters)

Purchase status of the license in English.

PurchaseStatus_de

Type: text (max 1000 characters)

Purchase status of the license in German.

PurchaseStatus_fr

Type: text (max 1000 characters)

Purchase status of the license in French.

PurchaseStatus_ja

Type: text (max 1000 characters)

Purchase status of the license in Japanese.

PurchaseStatus_es

Type: text (max 1000 characters)

Purchase status of the license in Spanish.