| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/GL1T | Index master Description | 5 | TXT50 | Text, 70 characters | nvarchar | 70 | 0 | | |
2 | /ATL/GL2T | Calculation Method Descriptions | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
3 | CNV_20100_SKAT | CNV backup copy for implementation of country-spec. CoA - ID | 7 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
4 | CNV_40305_ANKT | CNV backup table for Asset classes: Description | 7 | TXT50 | Description 50 characters | nvarchar | 50 | 0 | | |
5 | FIKZD_TRTAX | Transport tax Kazakstan | 24 | TXT50 | Asset description | nvarchar | 50 | 0 | | |
6 | FILUD_AA_MASTER | SAFT: FI Asset master data and values | 16 | TXT50 | Asset description | nvarchar | 50 | 0 | | |
7 | T083S | Leasing types-Description | 4 | TXT50 | Name of leasing type | nvarchar | 50 | 0 | | |
8 | T087J | Text | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
9 | TSAKR | Create G/L account with reference | 5 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
10 | TEBPPCATT | Text Table for Log Entries | 3 | TXT50 | Meaningful Name for the Log Category | nvarchar | 50 | 0 | | |
11 | TEBPP_COMMEVENTT | Texts for Communication Events in Biller Direct | 3 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
TOPAccrual Engine |
12 | TACECOMPT | Application Components of Accrual Function | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
13 | TACEPSRULET | ACE Account Determination: Account Determination Rule | 5 | TXT50 | Text | nvarchar | 50 | 0 | | |
14 | TACE_ACRTYPET | Text for Accrual Types | 5 | TXT50 | Text | nvarchar | 50 | 0 | | |
TOPAppropriation Requests |
15 | IMAKT | Appropriation request text | 4 | TXT50 | Description of appropriation request | nvarchar | 50 | 0 | | |
16 | TAIF9T | Value table for user fields | 5 | TXT50 | Description for the use assigned to user fields 3 and 4 | nvarchar | 50 | 0 | | |
TOPBasic Functions |
17 | ANKT | Asset classes: Description | 6 | TXT50 | Asset description | nvarchar | 50 | 0 | | |
18 | ANLA | Asset Master Record Segment | 76 | TXT50 | Asset description | nvarchar | 50 | 0 | | |
19 | ANLT | Asset Texts | 6 | TXT50 | Asset description | nvarchar | 50 | 0 | | |
20 | GLACCREFI | G/L Account Master Record: Create with Reference | 7 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
21 | T011B | FI financial calendar - job text table | 4 | TXT50 | Name of task | nvarchar | 50 | 0 | | |
22 | T011F | FI fin.calendar - person responsible for unit text table | 4 | TXT50 | Name of schedule | nvarchar | 50 | 0 | | |
23 | T087L | Text table for reasons for environmental investments | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
24 | T091S | Text for translation methods | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
25 | T093GT | Texts for Cross-System Depreciation Areas | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
26 | TA1MT | Text Table for Line Item Schema | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
27 | TA1TVT | Asset Transfer Variant | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter |
28 | TBE22T | Complementary Software Partner Product Description | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
29 | TBE24T | Language-Specific Customer Product Descriptions | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
30 | TBESTT | Descriptions for Table TBEST | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
TOPContract Accounts Receivable and Payable |
31 | CFC_APPLCTS_TXT | CFC: Applications: Texts | 5 | TXT50 | Description | nvarchar | 50 | 0 | | |
32 | CFC_APPLOBJ_TXT | CFC: Application objects: Texts | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
33 | CFC_CTRLOBJ_TXT | CFC: Control objects: Texts | 3 | TXT50 | Description | nvarchar | 50 | 0 | | |
34 | CFC_EVENT_TXT | CFC: Events: Texts | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
35 | CFC_ITEM_STATE_T | CFC: Status of the application table entries (texts) | 5 | TXT50 | Name of Status | nvarchar | 30 | 0 | | |
36 | CFC_WORKSTATE_T | Clarification Case Processing State (Texts) | 5 | TXT50 | Name of Processing Status | nvarchar | 30 | 0 | | |
37 | TFK001AT | Clearing reasons (text table) | 3 | TXT50 | Text | nvarchar | 50 | 0 | | |
38 | TFK001PT | Period key | 4 | TXT50 | Text for Period Key | nvarchar | 50 | 0 | | |
39 | TFK006XT | Exception Accounts for Clarification Proposal | 6 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
40 | TFK006YT | Exception Accounts for Clarification Proposal | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
41 | TFK007KT | Tax Item Categories for Other Tax Codes | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
42 | TFK042HT | Own Bank Details | 5 | TXT50 | Text | nvarchar | 50 | 0 | | |
43 | TFK058T | Rules for Additional Receivables (Description) | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
44 | TFK068FT | Names of Communication Channels | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
45 | TFK068T | Name of Document Categories | 3 | TXT50 | Text 50 Characters | nvarchar | 50 | 0 | | |
46 | TFKCALLIDT | BAPI Caller (Text Table) | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
47 | TFKEXTSYSTT | Text Table for TFKEXTSYST | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
48 | TFKP2PCT | Categories of Promises to Pay | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
49 | TFKP2PRCT | Reasons for Activating Promise to Pay | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
50 | TFKP2PRWT | Reasons for Withdrawal of Promise to Pay | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
51 | TFKRDI_DISGRPT | Distribution group | 4 | TXT50 | Name of Distribution Group | nvarchar | 50 | 0 | | |
52 | TFKRFCT | Reasons Prepaid Refills | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
53 | TFKRFLT | External Point of Sale for Prepaid Refills | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
54 | TFKRFMT | Names for Refill Methods | 4 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
TOPData Retention Tool |
55 | TXW_S_BSEG | Retrieve BSEG from archive | 122 | TXT50 | Text | nvarchar | 50 | 0 | | |
TOPFinancial Accounting |
56 | /CEECV/ROFIMASK | Descript mask account | 5 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
57 | F107_TPROVH_T | Provisions Content | 4 | TXT50 | Text | nvarchar | 50 | 0 | | |
58 | J_1GGL | Level accounts of Greek chart of accounts | 5 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
59 | SKAT | G/L Account Master Record (Chart of Accounts: Description) | 6 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
60 | SKMT | Sample Account Names | 5 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
TOPFunds Management |
61 | FMUP00T | Update Profiles | 3 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
TOPGeneral Application Functions |
62 | TFISCATT | Text Table for Log Categories | 3 | TXT50 | Name of Log Category | nvarchar | 50 | 0 | | |
63 | TFIS_COMMEVENTT | Texte for Communication Events in Biller Direct | 3 | TXT50 | Text Field | nvarchar | 50 | 0 | | |
TOPGL transfer |
64 | TBKKC_GLACC_TEXT | GL-ACCOUNT-TEXT | 6 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
TOPInformation Retention Manager |
65 | IWP_REPOS_FT | Retention Warehouse: Repository Field Description | 6 | TXT50 | Description | nvarchar | 50 | 0 | | |
66 | IWP_REPOS_ST | Retention Warehouse: Repository Structure Description | 5 | TXT50 | Description | nvarchar | 50 | 0 | | |
TOPInvoicing |
67 | TE530T | Long Text for Sort Criterion: Bill Printout | 4 | TXT50 | Comment | nvarchar | 50 | 0 | | |
TOPLease Accounting |
68 | TFILA_GF_008GT | Name of Grouping Key | 5 | TXT50 | Text | nvarchar | 50 | 0 | | |
69 | TFIOTP_001T | Document Group Characteristic Name | 5 | TXT50 | Text | nvarchar | 50 | 0 | | |
70 | TFIOTP_002T | Document Group Characteristic Name | 5 | TXT50 | Text | nvarchar | 50 | 0 | | |
TOPLocalization |
71 | IDCN_GLACCATTRT | G/L account time-depen.attributes-texts(CN) | 7 | TXT50 | G/L Account Long Text | nvarchar | 50 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
72 | TFMCA_FPF_RLGRT | FPF: Processing Variant for a Form Bundle Type | 5 | TXT50 | Text 50 Characters | nvarchar | 50 | 0 | | |
TOPRetention Warehouse |
73 | IWP_DB_AREAT | Description of audit areas | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
74 | IWP_DB_AREA_NDT | Description of a folder in the hierachy | 5 | TXT50 | Description | nvarchar | 50 | 0 | | |
75 | IWP_DB_REPOST | Retention Warehouse: Repository Description | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
76 | IWP_DB_REPOS_FT | Retention Warehouse: Repository field description | 6 | TXT50 | Description | nvarchar | 50 | 0 | | |
77 | IWP_DB_REPOS_ST | Retention Warehouse: Repository structure description | 5 | TXT50 | Description | nvarchar | 50 | 0 | | |
78 | IWP_DB_SETT | Set description | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
79 | IWP_WPPT | Audit Package Template | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
TOPSAP Business Partner |
80 | TBZ1B | BDT Events: Texts | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |
81 | TBZ3M | BDT-Screen Sequence Categories: Texts | 5 | TXT50 | Description | nvarchar | 50 | 0 | | |
82 | TBZ3T | BDT Screen Sequence Variants: Texts | 5 | TXT50 | Description | nvarchar | 50 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
83 | TNLZR4T | IS-H NL: LAZR Integriteitscheck Teksten | 5 | TXT50 | Tekst | nvarchar | 50 | 0 | | |
TOPUse AP-MD-BP Components |
84 | TB036T | Authorization Group Objects: Texts | 4 | TXT50 | Description | nvarchar | 50 | 0 | | |