| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_COKEY | TDMS Fill Header table for COKEY | 3 | COKEY | Char 36 for TDMS Fill Header | nvarchar | 36 | 0 | | |
2 | CNVTDMS_05_DFKC | FI-CA correspondence Header TDMS for ISU | 4 | COKEY | Char 36 for TDMS Fill Header | nvarchar | 36 | 0 | | |
3 | CNVTDMS_05_DFKKH | Fill Header table for DFKK* | 4 | COKEY | Char 36 for TDMS Fill Header | nvarchar | 36 | 0 | | |
4 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 20 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
5 | HRPAD530 | Additional Data for PAD530 | 19 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
6 | PIQPROC_ADM_DT | Activity Document: Admission Detailed Data | 22 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
TOPClaims Management |
7 | ICLDOC | Document to be Sent in Claim | 16 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
8 | ICSDOC | Document in Claim | 16 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
TOPContract Accounts Receivable and Payable |
9 | DFKKCFDUNTEL | Telephone List for Dunning | 26 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
10 | DFKKCOMA | Correspondence Dunning | 4 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
11 | DFKKCOMAKT | Correspondence Dunning Activities | 4 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
12 | DFKKCRDELESCHA | Check Register: Escheatment Data: Correspondence | 7 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
13 | DFKKCRESCHA | Check Register: Escheatment Data: Correspondence | 4 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
14 | DFKKDDA | Debit Memo Notification | 15 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
15 | DFKKDOC_CON | FKKDMS: Links Between Application Objects and Documents | 7 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
16 | DFKKWLI_CORR | Correspondence - Not Used - Attachm. Stored in DFKKDOC_CON | 10 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
17 | DFKKWRTOFF_WF | FI-CA Data for Write-Off in Workflow | 23 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
18 | FKKMAKO | Dunning History Header | 62 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
19 | TE761_COKEY | Control CO-PA Posting Acc. to Consumption Months per COKEY | 2 | COKEY | CO account assignment key, IS-U contract | nvarchar | 10 | 0 | | |
20 | TECOD | IS-U: CO account assignment key / allocation | 2 | COKEY | CO account assignment key, IS-U contract | nvarchar | 10 | 0 | | |
21 | TECOK | CO account assignment key IS-U contract | 2 | COKEY | CO account assignment key, IS-U contract | nvarchar | 10 | 0 | | |
22 | TECOKT | IS-U: CO account assignment key (name) | 3 | COKEY | CO account assignment key, IS-U contract | nvarchar | 10 | 0 | | |
23 | TFK020B | Short Account Assignments for Transfer Postings to Cash Desk | 7 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
24 | TFK020C | Short Acct Assignments for Write-Offs from Clarif. Worklist | 6 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
25 | TFK020K | Short Account Assignments for Transfer Postings | 7 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
26 | TFKCOD | FI-CA: CO Account Assignment Key/Allocation | 2 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
27 | TFKCOK | FI-CA: CO Account Assignment Key | 2 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
28 | TFKCOT | FI-CA: CO Account Assignment Key (Name) | 3 | COKEY | CO Account Assignment Key | nvarchar | 10 | 0 | | |
TOPCorrespondence Tool |
29 | DFKKCOD | Correspondence - Correspondence Data | 3 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
30 | DFKKCODCLUST | Correspondence - Correspondence Cluster Data | 3 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
31 | DFKKCOH | Correspondence - Correspondence Header | 3 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
32 | DFKKCOHARC | SAP ArchiveLink - Object Identifiers | 2 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
33 | DFKKCOHI | Correspondence - Correspondence History | 5 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
34 | DFKKCOHINCORR | Correspondence - Data for Inbound Correspondence | 2 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
35 | DFKKCOH_ARC | FI-CA Correspondence - Correspondence Header | 3 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
36 | DFKKCOP | Correspondence - Document Part List | 2 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
TOPIncentive and Commission Management ICM |
37 | CACS_DFKKCOH_REF | Reference Table Between ICM Corresp.Container and Corr.Cont. | 3 | COKEY | Correspondence Key in Correspondence Container | nvarchar | 36 | 0 | | |
TOPInvoicing |
38 | EABPJVL_CORR | Correspondence Print: Bud. Bill. Plan Header and YAP Info. | 2 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
39 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 2 | COKEY | Correspondence key | nvarchar | 36 | 0 | | |
TOPMaster Data |
40 | EVER | IS-U Cont. | 65 | COKEY | CO account assignment key, IS-U contract | nvarchar | 10 | 0 | | |
TOPRepetitive Manufacturing |
41 | T437X | Cost Collector Strategy | 4 | COKEY | Search logic for cost collector | nvarchar | 2 | 0 | | |