| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/PWSC_MPTYP | CPD: Master Project Type Table | 20 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
2 | /CPD/PWS_RCB_CTL | Rate Card Control table | 3 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
3 | /CPD/PWS_RCB_MPS | Rate Card Control table | 3 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
4 | /CPD/PWS_RCB_PRF | Rate Card Control Data Profile | 2 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
5 | /CPD/PWS_RCB_PRT | Rate Card Control Data Profile Text | 2 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
6 | /CPD/PWS_RCB_RCL | Rate Class | 4 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
7 | /CPD/PWS_RCB_RCM | Rate Class Profile Mapping | 2 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
8 | /CPD/PWS_RCM_CTL | Rate Maintenance Condition type for Master Project | 3 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
9 | /CPD/PWS_RCM_PRF | Rate Maintenance Profile for Master Project | 2 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
10 | /CPD/PWS_RCM_PRT | Rate Maintenance Profile Text for Master Project | 2 | PRFID | Rate Profile ID | nvarchar | 8 | 0 | | |
11 | T5G_PRFID | Proof of Identity Type GB | 2 | PRFID | Proof of Identity Type | nvarchar | 3 | 0 | | |
TOPConfiguration Profile |
12 | CUVCPR_ID_INT | Conversion: internal ID for configuration profile | 6 | PRFID | Configuration Profile Name | nvarchar | 30 | 0 | | |
TOPMaintenance Orders |
13 | /CUM/CUDESIGN | CU: Design Header Data | 7 | PRFID | CU: Profile for Order Generation | nvarchar | 10 | 0 | | |
14 | /CUM/PRF_ORD | CU: Profile for Order Generation | 2 | PRFID | CU: Profile for Order Generation | nvarchar | 10 | 0 | | |
15 | /CUM/PRF_ORDT | CU: Description of Profile for Order Generation | 2 | PRFID | CU: Profile for Order Generation | nvarchar | 10 | 0 | | |
TOPReuse Services for Country Development |
16 | PA0048 | HR Master Record: Infotype 0048 (Residence Status - CH) | 34 | PRFID | Proof of Identity Type | nvarchar | 3 | 0 | | |
17 | T5F99R_PRFID | Proof of Identity Type | 3 | PRFID | Proof of Identity Type | nvarchar | 3 | 0 | | |
TOPVariant Configuration |
18 | CUCO | Additional Data for Configurable Objects | 37 | PRFID | Configuration Profile Name | nvarchar | 30 | 0 | | |