RPTDW_PRODUCT_LICENSE Table
This section lists the database columns in the RPTDW_PRODUCT_LICENSE table.
|
Database Column |
Details |
|
ID |
Type: Decimal |
|
CURRENT_QUANTITY |
Type: Integer. Unique. |
|
EFFECTIVE_DATE |
Type: TimeStamp. Unique. |
|
EXPIRE_DATE |
Type: TimeStamp. Unique. |
|
NET_PRICE |
Type: Integer. Unique. |
|
ANNUAL_FEE_PERCENT |
Type: Decimal. Unique. |
|
PO_NUMBER |
Type: text. Unique. |
|
PURCHASE_REQ_NUMBER |
Type: text. Unique. |
|
NOTES |
Type: text (max length 1000). Unique. |
|
LAST_MODIFIED_TIME |
Type: TimeStamp. Unique. |
|
pool |
Type: Decimal. References Table: RPTDW_POOL Table |
|
product |
Type: Decimal. References Table: RPTDW_PRODUCT Table |