| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPActual Update and Commitment Update |
| 1 | GTRRULE_COND | Assignment Split IDs (Lines)--> Condition Block | 3 | SPLIT_ID | Unique ID for Distribution in Rule-Based Acct Asst Distbtn | nvarchar | 10 | 0 | | |
| TOPAdvanced Returns Management |
| 2 | MSR_D_APPROVAL | Multistep returns: Approval | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| 3 | MSR_D_EXECUTED | Advanced Returns Management # Tracking of Executed Steps | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| 4 | MSR_D_FIN_DETAIL | Advanced Returns Management - Next Financial Steps - Details | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| 5 | MSR_D_FIN_STATUS | Advanced Returns Management - Next Financial Steps | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| 6 | MSR_D_LOG_STATUS | Advanced Returns Management # Next Logistical Step | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| 7 | MSR_D_NEXTPLANTS | Multi-step returns - next plants | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| 8 | MSR_D_PLANNED | Advanced Returns Management - Next Sequences | 4 | SPLIT_ID | Split Identification Number | nvarchar | 3 | 0 | | |
| TOPFunds Management |
| 9 | FMSPLIT_SPLIT | Distributions for Rule-Based Account Distributions | 2 | SPLIT_ID | Unique ID for Distribution in Rule-Based Acct Asst Distbtn | nvarchar | 10 | 0 | | |
| 10 | FMSPLIT_VALUES | Assignment field values for Rule-Based Account Distribution | 2 | SPLIT_ID | Unique ID for Distribution in Rule-Based Acct Asst Distbtn | nvarchar | 10 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 11 | CACS42_DOCSHA | Commission Document: Complex Distribution Ratios | 8 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 12 | CACS42_PSSTAB01 | Definition of Distribution Ratios | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 13 | CACS_PS_PC | Characteristics of Distribution Rules for Partnerships | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 14 | CACS_PS_SP | Assignment of Distribution Rates to Partnership | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 15 | CACS_PS_SPL | Assignment of Distribution Ratio Method to Partnership | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 16 | TCACS_PS_PC | Characteristics of Distribution Rules for Participations | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 17 | TCACS_PS_SPC | Distribution Ratios for Participations | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 18 | TCACS_PS_SPL | Assignment of Split Rate Method to Participations | 4 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| 19 | YTEL05_DOCSHA | Commission Document: Complex Distribution Ratios | 8 | SPLIT_ID | Number of Distribution Ratio | nvarchar | 12 | 0 | | |
| TOPProduction Allocation |
| 20 | GHO_NODE_DS_SP | Node Down Stream Split (Obsolete) | 2 | SPLIT_ID | Down Stream Split ID | varbinary | 16 | 0 | | |
| 21 | GHO_NODE_DS_SP_H | Node Down Stream Split header table | 2 | SPLIT_ID | Down Stream Split ID | varbinary | 16 | 0 | | |
| 22 | GHO_NODE_DS_SP_I | Node Down Stream Split | 2 | SPLIT_ID | Down Stream Split ID | varbinary | 16 | 0 | | |
| 23 | GHO_SIMU_DS_SP_H | Simulation: Node Down Stream Split rules header | 2 | SPLIT_ID | Down Stream Split ID | varbinary | 16 | 0 | | |
| 24 | GHO_SIMU_DS_SP_I | Simulation: Node Down Stream Split rules Item | 2 | SPLIT_ID | Down Stream Split ID | varbinary | 16 | 0 | | |
