| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7BREFD_NRESIPAY | Payment to non-resident or resident abroad | 6 | REVENUE_TYPE | Income type | nvarchar | 4 | 0 | | |
2 | ZPPMC_DPR_COSTPL | Bewegungsdaten für die Sachkostenplanung in cProjects | 17 | REVENUE_TYPE | Character Field Length = 10 | nvarchar | 10 | 0 | | |
3 | ZPPMC_DPR_PLANLV | Customizing Planungsebene für cProjects Kostenplanung | 10 | REVENUE_TYPE | Revenue Element | nvarchar | 10 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
4 | DFMCA_BRF510 | BRF: Parameters for Creating Tax Obligation | 9 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
5 | DFMCA_BRF520 | BRF: Parameters for Deregistration of Tax Obligation | 9 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
6 | DFMCA_BRF700 | BRF: Check Registration Status | 9 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
7 | DFMCA_BRF720 | BRF: Statute of Limitations | 6 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
8 | DFMCA_BRF730 | BRF: Read Tax Liabilities | 9 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
9 | DFMCA_BRF840 | BRF: Business Partner Relationship | 16 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
10 | DFMCA_BRF860 | BRF: Check Relationship | 16 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
11 | DFMCA_BRF870 | BRF: Create/Update Relationship | 16 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
12 | DFMCA_BRF901 | BRF: Form Bundle Accounting Data Update | 11 | REVENUE_TYPE | BRF: Expression | nvarchar | 20 | 0 | | |
13 | DFMCA_RETURN | Data Table for Tax Returns | 4 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |
14 | DFMCA_RETURN_M | Data Table for Additional Accounting Data in Return | 8 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |
15 | DFMCA_RETURN_O | Data Table for Tax Returns | 7 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |
16 | DFMCA_RISK_PROF | Data Table for Risk Profiles | 6 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |
17 | DFMCA_TC_PERS | Data Table for Periods of Tax Case | 4 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |
18 | TFACT_SET_ABTYP | Revenue Types assigned to Fact Set Parts | 4 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |
19 | TFMCA_AR_FB | Archiving Residence Time for Form Bundle | 2 | REVENUE_TYPE | Revenue Type | nvarchar | 4 | 0 | | |