RPTDW_CONTRACT Table
This section lists the database columns in the RPTDW_CONTRACT table.
|
Database Column |
Details |
|
ID |
Type: Decimal |
|
CONTRACT_NAME |
Type: text. Unique. |
|
FIXED_COST |
Type: Integer. Unique. |
|
VARIABLE_COST |
Type: Integer. Unique. |
|
NOTES |
Type: text (max length 1000). Unique. |
|
START_DATE |
Type: TimeStamp. Unique. |
|
END_DATE |
Type: TimeStamp. Unique. |
|
CONTRACT_VALUE |
Type: Integer. Unique. |
|
NEXT_MAINTENANCE_DATE |
Type: TimeStamp. Unique. |
|
PAYMENT_AMOUNT |
Type: Integer. Unique. |
|
PAYMENT_START_DATE |
Type: TimeStamp. Unique. |
|
PAYMENT_END_DATE |
Type: TimeStamp. Unique. |
|
PAYMENT_INTERVAL |
Type: Integer. Unique. |
|
LAST_MODIFIED_TIME |
Type: TimeStamp. Unique. |
|
vendor |
Type: Decimal. References Table: RPTDW_SOFTWARE_VENDOR Table |
|
currency |
Type: Decimal. References Table: RPTDW_CURRENCY Table |