| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancials Basis |
1 | UBC_TB_BIL | Biller for each Organizational Unit | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
2 | UBC_TB_BILDVAL | Account Assignment Default Values on Level of Biller | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
3 | UBC_TB_INVH | Bill (Header) | 4 | BIL | Biller | nvarchar | 10 | 0 | | |
4 | UBC_TB_RA | Permitted Bill Types for each Biller | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
5 | UBC_TB_RADVAL | Account Assignment Default Values on Level of Bill Type | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
6 | UBC_TB_REJ | Rejection Control | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
7 | UBC_TB_RPA | Permitted Bill Item Types for each Biller | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
8 | UBC_TB_RPADVAL | Account Assignment Default Values on Level of Bill Item Type | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
9 | UBC_TT_RA | Bill Types (Texts) | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
10 | UBC_TT_RPA | Bill Item Types (Texts) | 3 | BIL | Biller | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
11 | TKECHACOADP | Conversion of Prof. Segments in Sender Table: Administration | 8 | BIL | Single-Character Indicator | nvarchar | 1 | 0 | | |
12 | TKECHACOADP_1 | Conversion of Prof. Segments in Sender Table: Administration | 8 | BIL | Single-Character Indicator | nvarchar | 1 | 0 | | |