| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7PIQSINGLEFEES | Define Attributes for Individual Fees | 12 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
2 | T7PIQ_NL_COBJ | Maintain Contract Object Types for Fee Calculation | 6 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
3 | TCMAC05A | Grant Types | 3 | PSOBTYP | Default Contract Object Type for Sponsor | nvarchar | 4 | 0 | | |
4 | TCMAC06D | Derivation of ISR Scenario Related Data | 13 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
5 | TCMACCOTYGRPASGN | Assign Contract Object Type to Contract Object Type Group | 4 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
6 | TCMACPSOB | Assign Contract Object Type to Fee Group | 2 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
7 | DFMCA_BRF570 | BRF: Parameters for Creating Contract Object | 10 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
8 | DFMCA_BRF690 | BRF: Read Contract Object | 7 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
9 | DFMCA_BRF760 | BRF: Read Location | 6 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
10 | DFMCA_BRF770 | BRF: Create Location | 7 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
11 | DFMCA_BRF850 | ##BRF: Derive inco type from form type | 8 | PSOBTYP | BRF: Expression | nvarchar | 20 | 0 | | |
12 | DPSOB | Contract Object in Collection and Disbursement | 10 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
13 | DPSOBTYP_CS | Attributes for Citizen Service Products | 2 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
14 | DPSOB_UPDOWNLOAD | Contract Object: Mapping Up and Download | 2 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
15 | TFMCA_BRF350 | BRF: Parameters for Facts | 7 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
16 | TFMCA_BRF351 | BRF: Parameters for Facts | 7 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
17 | TFMCA_INCORR_RL | Time-Dependent Definition of Enhanced Inbound Correspondence | 7 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
18 | TFMCA_INCORR_RVP | Assignment of Inbnd Corresp. Category to VKTYP and PSOBTYP | 3 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
19 | TFMCA_OI | Public Sector-Specific Trigger Filtering | 4 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
20 | TFMCA_REMINDER | Reminder Letter for Inbound Corresp. | 4 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
21 | TFMCA_REV2PSOB | Define Revenue Types for Contract Object Types | 4 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
22 | TPSOB001 | Definition: Type of Contract Object | 2 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
23 | TPSOB001T | Texts: Contract Object Types | 3 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
24 | TPSOB002 | Screen Sequence for Each Object Type and Hierarchy Level | 2 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |
25 | TPSOB_CMGRP | Zuordnung Vertragsgegenstandsart zu Stammdatengruppe | 3 | PSOBTYP | Art eines Vertragsgegenstandes | nvarchar | 4 | 0 | | |
26 | TPSOB_DEF | Samples for Contract Object Types | 2 | PSOBTYP | Contract Object Type | nvarchar | 4 | 0 | | |