Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Loans Management | ||||||||||
1 | TDPR_ATTRFIELD | Attribute: Field Description | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
2 | TDPR_ATTRIBUTE | Attribute | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
3 | TDPR_ATTRIBUTET | Description Attribute | 2 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
4 | TDPR_ATTRTREE | Attribute Hierarchy | 2 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
5 | TDPR_VA | Version Attribute | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
6 | TDPR_VA_FLD | Version Attribute Category Field | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
7 | TDPR_VA_FLDM | Version Attribute Category Field: Multiple Value Fields | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
Product definition | ||||||||||
8 | FIPR_VA | Version Attribute | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
9 | FIPR_VA_FLD | Version Attribute Category Field | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
10 | FIPR_VA_FLDM | Version Attribute Category Field: Multiple Value Fields | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
11 | FIPR_VA_FLDVAL | Version Attribute Category Field: Value Restriction | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
12 | FIPR_VA_VALUE | Version Attribute Category List | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
13 | FIPR_VA_VALUE2 | Version Attribute Category Matrix | 5 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
14 | TFIPR_ATTRFIELD | Attribute: Field | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
15 | TFIPR_ATTRFUNCT | Attribute: Feature | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
16 | TFIPR_ATTRIBUTE | Attribute | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
17 | TFIPR_ATTRIBUTET | Description Attribute | 2 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
18 | TFIPR_ATTRTREE | Attribute Hierarchy | 2 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
19 | TFIPR_ATTRVALUE | Attribute: List | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | ||
20 | TFIPR_ATTRVALUE2 | Attribute: Matrix | 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 |