| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCADVPAY | Advance Payments | 4 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
2 | VIYCCE2POOL | Cost Elements in Pool | 3 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
3 | VIYCCNPOOL | CAM Pool in CAM Recovery | 2 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
4 | VIYCCOST2DC | Application of Distribution / Denominator Method | 7 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
5 | VIYCCOST2MC | Application of Mark-up and Capping After Distribution | 7 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
6 | VIYCCOST2OBJ | Determined Costs for Objects in CAM recovery | 4 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
7 | VIYCCOST2POOL | Determined Costs for Lease in CAM Recovery | 6 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
8 | VIYCOBJ2POOL | Objects in CAM Pool | 3 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
9 | VIYCRECEIVABLE | Receivables from Settlement | 4 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
10 | VIYCREFFACTOR | Reference Factors | 4 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |
11 | VIYCRENT | Rental period | 5 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | |