| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_CD2_C | CD Posting: GL item settings | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
2 | /GSINS/INH_CD3_C | CD Posting: BP item settings | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
3 | DFKKSAFTINV_3PC | SAF-T source document extraction rules for Third Party | 11 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
4 | DFKKSAFTINV_3PV | SAF-T Third Party Business Partner Assignment | 11 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
5 | DFKK_BIT_TEST | Test Data for BITs | 17 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
6 | FKKID_EXP_HDR_A | Cr.Mem.&Exp.Conf.: Export Confirmation Header | 10 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
7 | TFK036V | Different Planning Levels By Transactions | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
8 | T7PIQSINGLEFEES | Define Attributes for Individual Fees | 11 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
9 | T7PIQ_NL_COBJ | Maintain Contract Object Types for Fee Calculation | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
10 | TCMAC06D | Derivation of ISR Scenario Related Data | 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
11 | TCMACFAINT04 | Financial Aid Relevant Main and Sub-transaction | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPBilling in Contract Accounts Receivable and Payable |
12 | TFK8008A | Transaction Determination for Billing Rate Item | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
13 | BROK_SALD_CUST | Balance Key Assignment - Transactions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
14 | ITAGCYCOMMPLAN | Agency Coll.: Main/Sub-Transactns f.Commission in PlndPrincp | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
15 | ITAGCYSUBCOMM | Commission to Subagencies (Main and Subtransactions) | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
16 | TIBRCLARREAS | Clarification Codes for Broker Report | 10 | TVORG | Subtrans. for New Created Open Items from Broker Report | nvarchar | 4 | 0 | | |
17 | TIBRDEFAULTS | Broker Collections - Default Values for Broker Report | 11 | TVORG | Subtrans. for New Created Open Items from Broker Report | nvarchar | 4 | 0 | | |
18 | TKKVHVTV | FS-CD Transactions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
19 | TKKVHVTVT | FS-CD Transactions: Texts | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
20 | TKKVIVV | Assign Internal Sub-Transactions to External Transactions | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
21 | VVKKCFREC | Cash Receipts to be Transferred to Claims System | 15 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
22 | VVKKFOP | Single Doc in Posting Data Interface | 8 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
23 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 8 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
24 | VVKK_COINS_PLPR | Coinsurance Reporting: Transactions for Debt Procedure | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
25 | VVSCITEM | Bill Scheduling: Scheduling Document | 33 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
26 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 33 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
27 | VVSCLOCKAMT | Scheduling: Premium Lock Period Share Already Transferred | 9 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
28 | VVSCPOS | Payment Plan Item | 55 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
29 | DFKCRPO | Clarification Worklist Credit | 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
30 | DFKK1099 | 1099 Statutory Reporting Data | 20 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
31 | DFKKDOUBTD_W | Buffer: Create Printout for Receivables Adjustment | 26 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
32 | DFKKIPBW_ORIG | Installment Plan Original Items for Business Warehouse | 14 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
33 | DFKKMOP | Items in contract account document | 22 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
34 | DFKKOP | Items in contract account document | 22 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
35 | DFKKOPCOLL | Collection: Log of Receivables Submitted | 17 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
36 | DFKKOP_REP | Open Items from FPO4 | 26 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
37 | DFKKOP_SHORT | Partner Items for FI-CA Document - Extracts | 18 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
38 | DFKKORDERPOS | Requests: Items | 10 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
39 | DFKKORDERPOS_S | Request Templates: Items | 10 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
40 | DFKKRDI | Revenue Distribution | 19 | TVORG | Subtransaction for Distribution Document Item | nvarchar | 4 | 0 | | |
41 | DFKKRDI_AGGRF_C | Auxiliary Table for Aggregated Distribution Information | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
42 | DFKKTHI | Transfer Records for Invoice Issue by Third Party | 24 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
43 | DFKKTHI_SUM | Aggregated Transfer Records for Invoicing | 15 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
44 | DFKKTHP | Transfer Records for Billing on Behalf of 3rd Party | 27 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
45 | DFKKTRANSKEY_TR | Turkey: Transaction Key -Combination of Main and Sub Trans. | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
46 | TE305 | Transactions for Company Code and Division | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
47 | TE305T | Transactions for Company Code and Division (Texts) | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
48 | TE514 | Invoicing: Item Selection for Account Maintenance | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
49 | TECOD | IS-U: CO account assignment key / allocation | 8 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
50 | TEIVV | (DON'T FILL/RE AD!!!Alloc. of Intern. Transacts to Trans. | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
51 | TEK060A | Loan Categories | 8 | TVORG | Sub-transaction for items due in return payment plan | nvarchar | 4 | 0 | | |
52 | TFK047K | Charge Categories Per Schedule | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
53 | TFK056A | Interest Key Table for FI-CA | 11 | TVORG | Not Used (Subtransaction for Interest Keys) | nvarchar | 4 | 0 | | |
54 | TFK059QV | Transaction-Specific Withholding Tax Code | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
55 | TFK060A | Install.Plan Proposal Cats | 13 | TVORG | Alternative Sub-Transaction For Installment Plan | nvarchar | 4 | 0 | | |
56 | TFK063A | Charge Categories for Installment Plan Surcharges | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
57 | TFK113F | Clearing: Due Date Intervals for OI Selection | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
58 | TFK113G | Clearing: Write-Off Statistical Items | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
59 | TFKBA_TRANS | Assignment of Transactions to Balances Categories | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
60 | TFKIVV | Assignment of Internal Transactions to External Transactions | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
61 | TFKRDI_DISGRP_RL | Transactions Summarized for Distribution Group | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
62 | TFKTVO | Sub-transactions in Contract Accounts Receivable and Payable | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
63 | TFKTVOT | Sub-transactions in Contract Accounts Receivable and Payable | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
64 | TFKZWEX | Exceptiions for Doubtful Entries/Individual Value Adjustment | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
65 | TFK_CRPO | Credit Processing: Customizing ID Credit | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
66 | TFK_EXTDOC_AR3 | Determination of Report Classification | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
67 | TFK_EXTDOC_OP | Transactions for Official Document Number | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
68 | TFK_PAYMENTREL_N | FICA: Customizing Payment Release Disbursements - New | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPContract Billing |
69 | DBERCHZ | Individual Line Items | 17 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
70 | DBERCHZ1 | Individual line items | 16 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
71 | DBERCHZ5 | Individual line items (unimportant rows) | 16 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
72 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 15 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
73 | TEPREPAY | Customizing Settings for Prepayment Meter | 17 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
74 | /GSINS/REU_TSBTR | Insurance ETL Customizing Table | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
75 | /GSINS/UPR_DEFRE | UPR - Calculation of unearned insurance premium reserve | 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPGeneral Application Functions |
76 | TFIS010 | FSCM: Bill Transactions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
77 | TFSCHVTV | Transactions for Company Code and Division | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
78 | TFSCHVTVT | Transactions for Company Code and Division (Texts) | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPIncentive and Commission Management ICM |
79 | CACSCD_ACRCD | Account Assignments of Remun.Types for FS-CD Stt.System | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
80 | CACSCD_DOCCD_PD | Settlement to FS-CD: Reference Document Line Items | 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPIntercompany Data Exchange |
81 | EDEREG_SIDPROINT | Interpretation of Internal ID | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
82 | EINLITYPETRANS | Allocation of Document Line Items | 9 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
83 | TEFKTVOS | Tax Table: Relevant Transactions in Convergent Billing | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
84 | TEFKTVOSBILL | Contract A/R and A/P items to be transfered for IDoc bill | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
85 | TEFKTVOSBILLT | Text for contract A/R and A/P items in IDoc bill | 3 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
86 | TINV_INV_TRANSF | Transfer Table for Bill Data to FI-CA | 40 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
87 | TINV_TRNSF_SHORT | Extract of Bill Receipt (Eval. System): FI-CA Transfer Data | 24 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPInvoicing |
88 | DBERDL | Print Document Line Items | 30 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
89 | DBERDZ | DB Table: Individ. Lines - Print Document | 43 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
90 | DEABPS | Customer change table: Logical view of BB amounts | 17 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
91 | EABPL | Sample Lines for Budget Billing Plan | 10 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
92 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 8 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
93 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 26 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
94 | TE306 | Budget Billing Procedures: Debit/Credit Indicators | 2 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
95 | TE529 | Item Selection for Bill Display | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
96 | TEABSTVOR | Define Debit/Credit ID for BB Amount Subtransactions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPInvoicing in Contract Accounts Receivable and Payable |
97 | DFKKINVBILL_I | Billing Document Items | 25 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
98 | DFKKINVDOC_I | Items of Invoicing Document | 14 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
99 | TFK2617 | Charges/Discounts | 7 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPLease Accounting |
100 | /LSIERP/COND_MAP | Assign FI-CA Transactions to CRM Conditions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
101 | /LSIERP/EXCL_NA | Transactions Not Assigned a Non-Accrual Status | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
102 | DFMCA_BRF150 | Text Parameters for Billing Line | 14 | TVORG | BRF: Expression | nvarchar | 20 | 0 | | |
103 | DFMCA_BRF152 | BRF: Parameters for Calculation Line Items | 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
104 | DFMCA_BRF730 | BRF: Read Tax Liabilities | 12 | TVORG | BRF: Expression | nvarchar | 20 | 0 | | |
105 | PS4SC_STATUS_RUL | Social Services: Status - Message Document Rules | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
106 | TFMCA004 | Parameters for Main/Sub-Transactions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
107 | TFMCA008 | Company Code-Dependent Indicator for Subtransactions | 4 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
108 | TFMCA_BRF221 | BRF: Parameters for Calculation Line Items | 13 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
109 | TFMCA_PREPAY | Main and Subtransaction for Open Items | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
110 | TFMCA_REFUND | Main/Subtransaction for Refund Items | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
111 | TFMCA_REVTYPE | Revenue Types | 5 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
TOPSAP Utilities |
112 | TE014_COMP_IND | Components for LPC, PPI, Interest | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |
113 | TE872_COMP_IND | Security Deposit Revisions : Relevant Billing Components | 6 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | | |