| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DIAN_A_1001_08 | Cached Data of DIAN Format 1001 version 08 | 10 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
2 | DIAN_A_1003_07 | Cached Data of DIAN Format 1003 version 07 | 10 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
3 | DIAN_A_1005_07 | Cached Data of DIAN Format 1005 version 07 | 9 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
4 | DIAN_A_1006_07 | Cached Data of DIAN Format 1006 version 07 | 9 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
5 | DIAN_A_1007_08 | Cached Data of DIAN Format 1007 version 08 | 10 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
6 | DIAN_A_1008_07 | Cached Data of DIAN Format 1003 version 07 | 9 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
7 | DIAN_A_1009_07 | Cached Data of DIAN Format 1009 version 07 | 9 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
8 | DIAN_A_TFORMAT | Testing table for Cached Data of DIAN Formats | 11 | MIDDLE_NAME | DIAN Middle Name | nvarchar | 40 | 0 | | |
TOPLoans Management |
9 | VDCBR_RES_DATA | Table of Data Reported to Credit Bureau (Per Loan) | 39 | MIDDLE_NAME | Middle Name (Metro2 Format) | nvarchar | 20 | 0 | | |
10 | VDCBR_RES_PART | Partner Data Reported to Credit Bureau (Pro Loan) | 13 | MIDDLE_NAME | Middle Name (Metro2 Format) | nvarchar | 20 | 0 | | |
TOPNetWeaver Demonstration |
11 | SNWD_BPA_CONTACT | EPM: Business Partner Contacts | 6 | MIDDLE_NAME | EPM: Middle Name | nvarchar | 40 | 0 | | |
12 | SNWD_CONTACT | Obsolete - Do Not Use | 6 | MIDDLE_NAME | EPM: Middle Name | nvarchar | 40 | 0 | | |
13 | SNWD_EMPLOYEE | Obsolete - Do Not Use | 6 | MIDDLE_NAME | EPM: Middle Name | nvarchar | 40 | 0 | | |
14 | SNWD_EMPLOYEES | EPM: Employee Data | 6 | MIDDLE_NAME | EPM: Middle Name | nvarchar | 40 | 0 | | |