| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PIQDBCORRREQUEST | Transcript Requests | 6 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
2 | T7PIQCORRACT | Correspondence: Activity Assignment | 5 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
3 | T7PIQCORRAPFORM | Application Forms for Ad-Hoc Correspondence | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
4 | T7PIQCORRFEE | Define Behaviour of Student Correspondence Requests | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
5 | T7PIQCORRSENDCON | Table for sendcontrol | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
6 | T7PIQCORRSM | Type of module correspondence and data related | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPClaims Management |
7 | ICLDOC | Document to be Sent in Claim | 19 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
8 | ICSDOC | Document in Claim | 19 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
9 | TICL031 | Claim Document | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPCollectionsDisbursements |
10 | TKKVFAART | Invoicing Types | 12 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
11 | DPAYCHKSET | Check: Settings for Check Creation for House Banks | 7 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
12 | TE045EF | IS-U Returns Correspondence Form | 7 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
13 | TFK042E | Payment program: company code payment method specifications | 16 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
14 | TFK045A | Returns table | 7 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
15 | TFK_REPT1 | Reasons for (Repeat) Print | 4 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPCorrespondence Tool |
16 | DFKKCOH | Correspondence - Correspondence Header | 26 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
17 | DFKKCOHI | Correspondence - Correspondence History | 36 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
18 | TFK070F | Correspondence Types - Client-Specific Customizing | 4 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPCustomer Contact |
19 | BCONTFORM | Determination of Contact Class, Activity and Configuration | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPIncentive and Commission Management ICM |
20 | TCACS_070F | Correspondence Types - Client-Specific Customizing | 5 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPInternet Self-Services |
21 | EIAC_WEBAPPLFORM | ISS bill display: define forms | 2 | FORMKEY | Application form for printout | nvarchar | 30 | 0 | | |
TOPInvoicing |
22 | EITERDK | Temporary Data Selection: Invoicing -> Bill Printout | 7 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
23 | ERDK | Print Document/Header Data | 29 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
24 | TE531 | Payment Method for Cash Payer | 4 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
25 | DFKKINVDOC_H | Invoicing Document Header | 39 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
26 | TFK2680 | Invoicing: Determination of Application Form | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPLoans Management |
27 | TDCO_OPT_TEXT | Correspondence Tool: Optional Text Modules | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
28 | TDCO_USER_TEXT | Definition of Custom Text for Correspondence Tool | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPMarketing, Accounting and Pricing |
29 | OIC_CPE_FO_LINK | Relationship Between F&A Formula and CPE Formula | 3 | FORMKEY | Formula Key | nvarchar | 10 | 0 | | |
30 | OIC_FORM_ATTRIB | Attributes of Business Context for F&A Formula | 3 | FORMKEY | Formula Key | nvarchar | 10 | 0 | | |
TOPMeter Reading |
31 | TE584 | Form Group of Note to Field Service | 5 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPPrint Workbench |
32 | EFGH_EFRM | Help Table for Search Help | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
33 | EFGH_EFRM2 | Help Table for Search Help | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
34 | EFG_COLLECTION | Entries in Collection | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
35 | EFG_COLLECTIONT | Entries in Collection | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
36 | EFG_FORMLOG | Logs for Generating Application Forms | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
37 | EFG_FORMX | X String Data for Application Form | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
38 | EFG_FORM_CC | Aux. Table for Client Copy | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
39 | EFRM | Print Workbench: Application Forms | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
40 | EFRMGENETAB | Log Table for Generations | 4 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
41 | EFRMGENTRDIR | Print Workbench: TRDIR Entry in Form Class Library in Gener. | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
42 | EFRMLAN | Language for Application Form | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
43 | EFRMSTR | Application Form Structure | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
44 | EFRMSTRTE | Text Table for Texts in Application Form Hierarchy | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
45 | EFRMTE | Text Table for EFRM | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
46 | EFRMTRLSTSTR | Lines of a Translation List | 6 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
47 | EFRMX | Form Structure: 1:1 Levels | 2 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
48 | TFMCA003 | Invoice Types | 8 | FORMKEY | Application form | nvarchar | 30 | 0 | | |
49 | TFMCA_INCORR_PR | Preprints for Inbound Correspondence | 3 | FORMKEY | Application form | nvarchar | 30 | 0 | | |