| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKEPRT | Log for Inconsistent FI-CA Documents | 37 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
2 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 12 | HERKF | Origin of Account Assignment | nvarchar | 1 | 0 | | |
3 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 12 | HERKF | Origin of Account Assignment | nvarchar | 1 | 0 | | |
4 | TFK007USTPD | Allowed Origins for External Tax Interface per Document | 1 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
5 | TFK_DOCCLS_DET | Assign Document Classes to Document Type sand Origin Keys | 4 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
6 | TFK_EXT_PROCTYP | Assign customer extension Modules/Classes to Process Types | 4 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
7 | TFK_INT_PROCTYP | Assign Countries to Process Types (internal only) | 3 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
8 | DFKKCMK | Manually Issued Checks Lot: Header Data | 6 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
9 | DFKKCMP | Manually Issued Checks Lot: Item Data | 11 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
10 | DFKKCR | Repository For Checks | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
11 | DFKKCR2P | Check Repository: Additional Payees | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
12 | DFKKCRADD | CR: Additional Information for Payment Medium | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
13 | DFKKCRCASH | CR: Cashed Checks Not Yet Entered in Register | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
14 | DFKKCRCL | Table for Checks To Be Clarified | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
15 | DFKKCRCL_DOCS | Table for Checks To Be Clarified | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
16 | DFKKCRDEL | CR: Deleted Payment Medium / Basic Data | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
17 | DFKKCRDEL2P | CR: Deleted Payment Medium / Payee Data | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
18 | DFKKCRDELADD | CR: Deleted Payment Medium / Additional Data | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
19 | DFKKCRDELD2 | Check Register: Deleted Payment Media/Partial Encashments | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
20 | DFKKCRDELESCH | Check Register: Escheatment Data | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
21 | DFKKCRDOC2 | Check Management: Partial Encashments | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
22 | DFKKCRESCH | Check Register: Escheatment Data | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
23 | DFKKCRESCHC | Clarification Cases for Manual Escheatment Process | 2 | HERKF | Origin of Payment Information | nvarchar | 1 | 0 | | |
24 | DFKKCRF | Record of Creditworthiness: Fixed Interest Periods, Releases | 7 | HERKF | Origin of entry related to creditworthiness | nvarchar | 2 | 0 | | |
25 | DFKKEXTTAX | Control Table for Update of External Tax Systems | 10 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
26 | DFKKIP_GRP | Payment Specification: Header Data | 42 | HERKF | Origin of Payment Specification | nvarchar | 2 | 0 | | |
27 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 44 | HERKF | Origin of Payment Specification | nvarchar | 2 | 0 | | |
28 | DFKKKO | Header Data in Open Item Accounting Document | 6 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
29 | DFKKMKO | Header data for sample contract accounting document | 6 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
30 | DFKKRK | Returns lot: Header data | 5 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
31 | DFKKTHI | Transfer Records for Invoice Issue by Third Party | 21 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
32 | DFKKTHP | Transfer Records for Billing on Behalf of 3rd Party | 24 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
33 | DFKKWOH | Write-Off History | 15 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
34 | DFKKWOHTMP | Temporary Write-Off History | 15 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
35 | DFKKZK | Payment lot: Header data | 5 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
36 | IST_BTACT | IS-T Disconnection Number: Disconnection Activity | 5 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
37 | IST_FILE_TELNR | File History of Payments/Dunning: Reconn./Disconn. Tel. No. | 4 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
38 | TEIISVOR | Assignment of Internal Transactions to Collective Bill Trans | 2 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
39 | TFK001 | Origin key | 1 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
40 | TFK001C | Use of User-Specific Reconciliation Keys | 2 | HERKF | Origin key with reconciliation key for each user | nvarchar | 2 | 0 | | |
41 | TFK001F | Reconciliation key per user | 3 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
42 | TFK001T | Origin key code | 2 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
43 | TFK005_MDOC | Resid.Time for Sample Documents Dependent on Document Origin | 2 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
44 | TFK005_MDOC_H | Registered Origins for Sample Document Archiving | 2 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
45 | TFK046B | Origin of an Entry Relating to Creditworthiness | 1 | HERKF | Origin of entry related to creditworthiness | nvarchar | 2 | 0 | | |
46 | TFK046BT | Origin of an Entry Relating to Creditworthiness | 2 | HERKF | Origin of entry related to creditworthiness | nvarchar | 2 | 0 | | |
47 | TFK090A | Mass Activity Types | 11 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
48 | TFK_EXTDOC_AR4 | Default Values for Branches in Argentina | 2 | HERKF | Document Origin Key | nvarchar | 2 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
49 | PS4SC_STATUS_RUL | Social Services: Status - Message Document Rules | 5 | HERKF | Social Services: Origin Key | nvarchar | 2 | 0 | | |
50 | PS4SD_STATUS_DOC | Social Services: Status - Trigger Table for Document Status | 6 | HERKF | Social Services: Origin Key | nvarchar | 2 | 0 | | |
TOPSAP Credit Management |
51 | DFKKCRP | Creditworthiness Record: Generating Actions | 6 | HERKF | Origin of entry related to creditworthiness | nvarchar | 2 | 0 | | |