| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID | Guid for application objects | varbinary | 16 | 0 | | | | |
| 3 | EXTERNAL_ID | Business Object ID | nvarchar | 24 | 0 | | | | Allow NULL? |
| 4 | PORTFOLIO_GUID | Guid for application objects | varbinary | 16 | 0 | | | | |
| 5 | PARENT_GUID | Guid for application objects | varbinary | 16 | 0 | | | | |
| 6 | CURRENCY | Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | PERIOD_TYPE | Financial Period Breakdown | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | UNIT | Capacity Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | CHANGED_BY | Changed by user | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | CHANGED_ON | TimeStamp | decimal | 15 | 0 | | | | |
| 11 | RELEASE_STATUS | Release Status | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | BEGDA_DEM | Capacity Planning Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ENDDA_DEM | Capacity Planning Finish Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | BEGDA_FIN | Financial Planning Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | ENDDA_FIN | Financial Planning Finish Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | CAP_PERIOD_TYPE | Capacity Period Breakdown | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | LOCATION | Project Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | BEGDA_CO | Start Date for Transfer to SAP ERP | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ENDDA_CO | Finish Date for Transfer to SAP ERP | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | char | 1 | 0 | | | | Allow NULL? |
| 21 | ZZROI | Cumulative ROI | int | 10 | 0 | | | | Allow NULL? |