| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FMTABADR | Characteristic Derivation: Strategies | 3 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPAccounting Engine |
2 | /EACC/TDR_STEPS | Derivation Steps | 9 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPBasic Functions |
3 | WITH_EXCL_STR_HD | Derivation Strategies for Exclusion of Lines in Withhold.Tax | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
4 | WITH_EXCL_STR_T | Derivation Strategies for Exclusion (Texts) | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
5 | WITH_EXCL_WITHT | Assignment to Withholding Tax Type | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
6 | TKKVABADRENV | Derivation Strategy | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
7 | TKKVABADRENVT | Text Table for Derivation Strategies | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
8 | FMFG_ABP_HDR_DEF | ABP Budget Entry Document default attributes | 19 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPFund Accounting |
9 | FMCCAVCKEDRENVT | Text for Strategy Environment | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPFunds Management |
10 | FMDERIVEENVID | Assignment Company Code to Derivation Tool Strategy | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
11 | FMDERIVE_SETS | Sets for different Strategies | 3 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
12 | FMREAS_STRATS | Maintain Assignment Strategy for FM Area and Fiscal Year | 7 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
13 | FMSPLIT_CATSDERI | FMSPLIT_CATSDERI | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
14 | FMTABADRH | Characteristic Derivation: Header | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
15 | FMTABADRHFUNDTYP | Assign FM Fund Category to Strategy Environment | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
16 | FMTABADRHT | Characteristic Derivation: Header - Texts | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPGeneral Application Functions |
17 | TABADR | Characteristic Derivation: Strategies | 3 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
18 | TABADRH | Characteristic Derivation: Header | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
19 | TABADRS | Characteristic Derivation: Steps | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
20 | TABADRSF | Characteristic Derivation: Steps, Fields | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
21 | TABADRST | Characteristic Derivation: Steps, Texts | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
22 | TABADRT | Characteristic Derivation: Strategies, Texts | 3 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
23 | FAGL_VAL_COCODE | Allocation to company code | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
24 | FAGL_VAL_GRP | Sets for the Validation of Account Assignment Combinations | 3 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
25 | FAGL_VAL_HDR | Validation Strategy | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
26 | FAGL_VAL_HDRT | Validation Strategy (Texts) | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |
27 | FAGL_VAL_LEDGR | Assignment to Ledger Group | 4 | ABADRSTRATID | Strategy ID | nvarchar | 4 | 0 | | |