| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/KAGR_KPI1 | KPI1 Target Table - Number of processed invoices | 6 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
2 | /OPT/KAGR_KPI2 | KPI2 Target Table - Amount of processed invoices | 7 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
3 | /OPT/KAGR_KPI3_4 | KPI 3+4 Target Table - Exceptions | 7 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
4 | /OPT/KAGR_KPI5_6 | KPI5+6 Target Table - Time based Classification | 8 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
5 | /OPT/KAGR_KPI7 | KPI7 Target Table - Percent of processed invoices with delay | 6 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
6 | /OPT/KAGR_KPI8 | KPI8 Target Table - Percent of approved invoices with delay | 6 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
7 | /OPT/VT_DOC_H | Reporting table: Document header | 22 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
8 | /OPT/VT_DOC_HEA1 | Document Header - copy of /opt/vt_doc_head | 35 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
9 | /OPT/VT_DOC_HEAD | Document Header | 35 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
10 | /OPT/VT_KPI_SRC | Source Table for the Aggregations of the KPI Dashboard | 8 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
11 | /OPT/VIM_1HEAD | Document Header | 60 | CREDIT_MEMO | Credit Memo Indicator | nvarchar | 1 | 0 | | |