| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFMCA_OBT_HIS | Storage of Lean Trace history for object based tax | 10 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
2 | T5DPBS3F | Absence Categories for Pay Scale Level Increase | 2 | ABTYP | Absence Category for Pay Scale Level Increase | nvarchar | 20 | 0 | | |
3 | T5DPBS3FT | Absence Categories for Pay Scale Level Increase (Texts) | 3 | ABTYP | Absence Category for Pay Scale Level Increase | nvarchar | 20 | 0 | | |
4 | T5DPBS3G | Assignment of Absence to Absence Category | 6 | ABTYP | Absence Category for Pay Scale Level Increase | nvarchar | 20 | 0 | | |
5 | T672 | Conditions: View Sequence | 4 | ABTYP | Category of the rebate agreement | nvarchar | 1 | 0 | | |
6 | TFMCA_BRFP_OBT | BRFplus Function for Object-Based Revenue Types | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
7 | TKKVBAKT | Banks for Payment | 3 | ABTYP | Origin Area of a Payment Form | nvarchar | 2 | 0 | | |
8 | TKKVSLART | Selection Type for Clearing | 3 | ABTYP | Origin Area of a Payment Form | nvarchar | 2 | 0 | | |
9 | VVKKFAPOS | Invoicing Items in FS-CD | 7 | ABTYP | Origin Area of a Payment Form | nvarchar | 2 | 0 | | |
TOPCommunication |
10 | TN21Y_SE_MAP | IS-H: Mapping table for Billing Categories for Indiv. Contro | 3 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
TOPConditions |
11 | KONA | Agreements | 9 | ABTYP | Category of the rebate agreement | nvarchar | 1 | 0 | | |
12 | T6B1 | Rebate : Rebate Agreement Types | 4 | ABTYP | Category of the rebate agreement | nvarchar | 1 | 0 | | |
TOPJust-In-Time Processing |
13 | JITHD | Call header | 11 | ABTYP | Call Type | nvarchar | 1 | 0 | | |
14 | JITQU | Number of Calls | 3 | ABTYP | Call Type | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
15 | NVBRP | IS-H: Billing document item data | 79 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
16 | TN21X | IS-H: Text For Individual Billing Categories | 4 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
17 | TN21Y | IS-H: Billing Categories for Indiv. Control of Billing | 3 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
TOPPatient Management |
18 | NLEI | IS-H: Services Performed | 74 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
TOPPersonnel Administration |
19 | T503 | Employee Group/Subgroup | 5 | ABTYP | Employee subgroup grouping for primary wage tpyes | nvarchar | 1 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
20 | DFMCA_BRF850 | ##BRF: Derive inco type from form type | 10 | ABTYP | BRF: Expression | nvarchar | 20 | 0 | | |
21 | DFMCA_BUPR_TA | Data Table for Tax Advisor Relationships | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
22 | DPSOB_BILLTRIG | Trigger for TRM Billing | 6 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
23 | TFMCA_BRFEVENT | Assign Revenue Types to BRF Events | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
24 | TFMCA_FORMTYPE | Customizing Table for Form Types | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
25 | TFMCA_FORMTYPET | Customizing Table for Language-Dependent Texts Form Types | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
26 | TFMCA_INCORR_RL | Time-Dependent Definition of Enhanced Inbound Correspondence | 5 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
27 | TFMCA_LINKS | Customizing Table for Links | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
28 | TFMCA_LINKST | Customizing Table for Language-Dependent Texts for Services | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
29 | TFMCA_PREPAY | Main and Subtransaction for Open Items | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
30 | TFMCA_RC2REV | Reason Code Link <--> Revenue Types | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
31 | TFMCA_REFUND | Main/Subtransaction for Refund Items | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
32 | TFMCA_REMINDER | Reminder Letter for Inbound Corresp. | 5 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
33 | TFMCA_REV2FPF | FPF: relationship between revenue type and form bundle type | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
34 | TFMCA_REV2PER | Define Tax Periods for Revenue Types | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
35 | TFMCA_REV2PSOB | Define Revenue Types for Contract Object Types | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
36 | TFMCA_REVTYPE | Revenue Types | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
37 | TFMCA_REVTYPET | Texts Revenue Types | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
38 | TFMCA_SERVICES | Customizing Table for Services | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
39 | TFMCA_SERVICEST | Customizing Table for Language-Dependent Text for Services | 3 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
40 | TFMCA_STATLIM | Statute of Limitation | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
41 | TFMCA_TRANSTYPES | Transaction Type for Tax Processing | 2 | ABTYP | Revenue Type | nvarchar | 4 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
42 | NCH10 | IS-H CH: Service Breakdown | 5 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
43 | NCH10T | IS-H CH: Service Breakdown Text | 6 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
44 | NCH41 | IS-H CH: Service Rules Service Breakdown | 12 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
45 | NCH42 | IS-H CH: Service Rules Service Maximum Values | 13 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
46 | NTPKCH_MAX | IS-H CH: Zuordng Leistamm Schweiz (TARMED) => Maximumregel | 5 | ABTYP | IS-H: categoria fattur. per controllo indiv. fatturazione | nvarchar | 4 | 0 | | |
47 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 65 | ABTYP | IS-H: categoria fattur. per controllo indiv. fatturazione | nvarchar | 4 | 0 | | |
48 | TNWCH108 | Charge Factor Value Determination for Fee Billing | 8 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
49 | TNWCH80 | IS-H CH: Charge Factor Value Determination | 15 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |
50 | TNWCH91 | Items for Fee Relevance | 11 | ABTYP | IS-H: Billing Category for Individual Billing Control | nvarchar | 4 | 0 | | |