| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 126 | PEB | Indicator: billing line item relates to period-end billing | nvarchar | 1 | 0 | | |
2 | DBERCHZ1 | Individual line items | 80 | PEB | Indicator: billing line item relates to period-end billing | nvarchar | 1 | 0 | | |
3 | DBERCHZ5 | Individual line items (unimportant rows) | 80 | PEB | Indicator: billing line item relates to period-end billing | nvarchar | 1 | 0 | | |
4 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 39 | PEB | Indicator: billing line item relates to period-end billing | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
5 | FMPEB_ASSIGN | Assign Org. Units to Partially Exempt Organizations | 7 | PEB | Partially Tax-Exempt Institution | nvarchar | 8 | 0 | | |
6 | FMPEB_DEF | Define Partly Exempt Organization | 2 | PEB | Partially Tax-Exempt Institution | nvarchar | 8 | 0 | | |
7 | FMPEB_DEFT | PEO Name | 3 | PEB | Partially Tax-Exempt Institution | nvarchar | 8 | 0 | | |
8 | FMPEB_RATE_DEF | Assign Input Tax Deduction Rates | 5 | PEB | Partially Tax-Exempt Institution | nvarchar | 8 | 0 | | |
9 | FMPEB_TAXIND | Assign Tax Codes to Exempt Organizations | 5 | PEB | Partially Tax-Exempt Institution | nvarchar | 8 | 0 | | |
TOPInvoicing |
10 | DBERDZ | DB Table: Individ. Lines - Print Document | 152 | PEB | Indicator: billing line item relates to period-end billing | nvarchar | 1 | 0 | | |