| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKSAFTINV_SBC | SAF-T source document extraction rule for Self-Billing | 9 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
TOPAllocation |
2 | AUFI | Allocation Table, Document Sub-item, Stores | 30 | VKTYP | Date type (day, week, month, interval) | nvarchar | 1 | 0 | | |
TOPCollectionsDisbursements |
3 | TIMA_CRT_ACC | IO: Creation Variants for Account Creation | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
4 | TIMA_VKTYP_DEF | IO: Ctr. Acct Category Default Vals for Contr. Acct Creation | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
5 | TKKVFAART | Invoicing Types | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
6 | TKKVFAARTT | Invoicing Type Texts | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
7 | TKKVFAART_PYMET | Additional Payment Methods also for Invoice | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
8 | TKKVKONTO | Account Control | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
9 | TKKVMZAHL | Validation Table for Automatic Payment | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
10 | TKKVSLART | Selection Type for Clearing | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
11 | VVKKFAPOS | Invoicing Items in FS-CD | 8 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
TOPContract account |
12 | TE002A | IS-U Specific Attribute for Contract Account Categories | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | DFKKAGRID_NO | Paper Agreement Table | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
14 | FKKVK | Contract Account Header | 9 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
15 | TFK002A | Contract Account Categories | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
16 | TFK002AT | Texts on account categories | 4 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
17 | TFK041C | Assignment of Account Categories to Master Data Groups | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
TOPInvoicing |
18 | TE635 | Control Table: Yearly Advance Payment | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
19 | TFKVKP | Technical Master Data for Billing & Invoicing in FI-CA | 5 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
20 | DFMCA_BRF660 | BRF: Contract Account Reading | 7 | VKTYP | BRF: Expression | nvarchar | 20 | 0 | | |
21 | DFMCA_BRF850 | ##BRF: Derive inco type from form type | 7 | VKTYP | BRF: Expression | nvarchar | 20 | 0 | | |
22 | TFICA_DEF | Samples for Contract Account Types | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
23 | TFMCA_INCORR_RL | Time-Dependent Definition of Enhanced Inbound Correspondence | 6 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
24 | TFMCA_INCORR_RVP | Assignment of Inbnd Corresp. Category to VKTYP and PSOBTYP | 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
25 | TFMCA_OI | Public Sector-Specific Trigger Filtering | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
26 | TFMCA_REMINDER | Reminder Letter for Inbound Corresp. | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |
27 | TFMCA_REVTYPE | Revenue Types | 3 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | |