| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPActual Update and Commitment Update |
1 | GTRRULE_AGR | Assignment Split Rule -> Agreement (if no EFs are used) | 3 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
2 | GTRRULE_ASSIGN | GTR Multi-Funding Rules Assignment To CRM Objects | 2 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
3 | GTRRULE_COND | Assignment Split IDs (Lines)--> Condition Block | 2 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
4 | GTRRULE_COND_V | Assignment Condition Block --> Condition Values | 2 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
5 | GTR_TRANSLATOR | Grantor: Translator of CRM and ERP Integration Attributes | 11 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
TOPFunds Management |
6 | FMSPLIT_RULE | Distribution Rule for Rule-Based Account Distributions | 2 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
7 | FMSPLIT_RULET | Distribution Rule names for Rule-Based Account Distributions | 3 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
8 | FMSPLIT_SPLIT | Distributions for Rule-Based Account Distributions | 3 | SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | nvarchar | 12 | 0 | | |
TOPShipping |
9 | T186 | Delivery List Profile | 20 | SPLIT_RULE | Rule for creating one delivery item per schedule line | nvarchar | 4 | 0 | | |