| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7PIQATCALCRULE | Calculation Rule | 1 | CALCRULE | Calculation Rule | nvarchar | 3 | 0 | | |
2 | T7PIQATCALCRULET | Calculation Rule Text | 1 | CALCRULE | Calculation Rule | nvarchar | 3 | 0 | | |
3 | T7PIQCALCRULE | Possible Calculation Rule for Composite Test Results | 2 | CALCRULE | Calculation Rule | nvarchar | 3 | 0 | | |
4 | T7PIQCALCRULET | Text Table for Possible Calculation Rules | 3 | CALCRULE | Calculation Rule | nvarchar | 3 | 0 | | |
5 | T7PIQTRTESTTYPE | External Test Types | 8 | CALCRULE | Calculation Rule | nvarchar | 3 | 0 | | |
TOPBudgeting |
6 | BURBCALCRULES | Calculation Formulas for Revenues Increasing the Budget | 3 | CALCRULE | Calculation Formula for Revenues Increasing the Budget | nvarchar | 4 | 0 | | |
7 | BURBCALCRULEST | Texts on Calculation Rules for Revenues Increasing the Bud. | 3 | CALCRULE | Calculation Formula for Revenues Increasing the Budget | nvarchar | 4 | 0 | | |
8 | FMRBBOBJECTS | Master Data For Revenue Increasing the Budget: RIB Objects | 15 | CALCRULE | Calculation Formula for Revenues Increasing the Budget | nvarchar | 4 | 0 | | |
TOPBudgeting and Availability Control |
9 | GMRBBOBJECTS | Master Data For Revenue Increasing the Budget: RIB Objects | 11 | CALCRULE | Calculation Formula for Revenues Increasing the Budget | nvarchar | 4 | 0 | | |
TOPCommodity Pricing Engine |
10 | CPEC_CALCRULE | CPE Term - Calculation Rule | 3 | CALCRULE | CPE Term - Calculation Rule | nvarchar | 5 | 0 | | |
11 | CPEC_CALCRULE_T | CPE Term - Description of Calculation Rule | 4 | CALCRULE | CPE Term - Calculation Rule | nvarchar | 5 | 0 | | |
12 | CPEC_TERMRULE | CPE Term - Term Rule | 5 | CALCRULE | CPE Term - Calculation Rule | nvarchar | 5 | 0 | | |
13 | CPED_TERMINPUT | CPE Term - Changed Input for General Data | 38 | CALCRULE | CPE Term - Calculation Rule | nvarchar | 5 | 0 | | |
TOPCountry-Specific Objects |
14 | TAXNUMCHKPOS | Rules for Checking Tax Numbers - Positions | 10 | CALCRULE | Tax Number Checks: Rule for calculating check digit | nvarchar | 2 | 0 | | |
TOPIncentive and Commission Management ICM |
15 | TCACS_TGA | Tgt Agrmts: Assign Elementary to Complex Target Types | 9 | CALCRULE | Target Agreements: Calculation Rules | nvarchar | 4 | 0 | | |
16 | TCACS_TGPR | Target Agreements: Calculation Rules | 3 | CALCRULE | Target Agreements: Calculation Rules | nvarchar | 4 | 0 | | |
17 | TCACS_TGPRT | Target Agreement: Calculation Rule Texts | 3 | CALCRULE | Target Agreements: Calculation Rules | nvarchar | 4 | 0 | | |
TOPMedia Product Sales and Distribution |
18 | TJKSDORDERPRO | Calculation Rule for Evaluation of Log Status | 2 | CALCRULE | Calculation Rule | nvarchar | 4 | 0 | | |
19 | TJKSDORDERPROT | Text Table for TJKSDORDERPRO | 2 | CALCRULE | Calculation Rule | nvarchar | 4 | 0 | | |
20 | TJKSDSBRPHASES | Calculation Rules of Phases for Replenishment Planning | 5 | CALCRULE | Calculation Rule for Replenishment Quantities | nvarchar | 2 | 0 | | |
21 | TJKSDSBRRULECALC | Calculation Rule for Replenishment Quantities | 2 | CALCRULE | Calculation Rule for Replenishment Quantities | nvarchar | 2 | 0 | | |
22 | TJKSDSBRRULECALT | Calc. Rule for Replenishment Planning Quantities - Texts | 2 | CALCRULE | Calculation Rule for Replenishment Quantities | nvarchar | 2 | 0 | | |
TOPReal Estate Contract |
23 | TIVCDCONDDEF | Default Condition | 10 | CALCRULE | Calculation Formula | nvarchar | 4 | 0 | | |
24 | VICDCOND | Condition | 39 | CALCRULE | Calculation Formula | nvarchar | 4 | 0 | | |
TOPRent Adjustment |
25 | TIVAJEPCRTD | Time-Dependent Calculation Formula for Expense Item | 4 | CALCRULE | Calculation Formula | nvarchar | 4 | 0 | | |
26 | TIVAJEXPPOS | Expense Item | 5 | CALCRULE | Calculation Formula | nvarchar | 4 | 0 | | |
27 | VIAJEXPENSE | Current Expenses | 18 | CALCRULE | Calculation Formula | nvarchar | 4 | 0 | | |