| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/APPR_COA | Approval COA | 8 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
2 | /OPT/APPR_LIMIT | Approval Limit/Level | 3 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
3 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 109 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
4 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 110 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
5 | /OPT/LIAP_MATX | Line Item Approval Matrix Table | 26 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
6 | /OPT/X155 | Expense type description | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
7 | /OPT/X156 | Expense Type | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
8 | /OPT/Y155 | Expense type description | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
9 | /OPT/Y156 | Expense Type | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
10 | /OPT/Z155 | Expense type description | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
11 | /OPT/Z156 | Expense Type | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
12 | /ORS/APPRLIMIT | Approval Limit based on Grade Range, Expense Type and CC | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
13 | /ORS/EXPENSE_DEC | Expense type description | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
14 | /ORS/EXPENSE_TYP | Expense Type | 2 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
15 | /ORS/INV_DATA | Additional Invoice Data Storage | 4 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
TOPActual Update and Commitment Update |
16 | GTR_TRSLR_SUBKEY | Grantor Translator - Subkey | 4 | EXPENSE_TYPE | Expense Type for Grantor | nvarchar | 4 | 0 | | |
TOPBilling |
17 | CRMC_FM_CO_EXP | customizing table cost element to expense type for marketing | 4 | EXPENSE_TYPE | Expense Type | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
18 | /OPT/BL_APPCOA | Approval COA | 7 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
19 | /OPT/VIM_1HEAD | Document Header | 93 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | | |
TOPGrantor Management |
20 | GTRFIBILL_I | Grantor Billing Document Items | 15 | EXPENSE_TYPE | Expense Type for Grantor | nvarchar | 4 | 0 | | |
TOPTrading Contract |
21 | TWGTA | Global Trade Management: Control Table | 17 | EXPENSE_TYPE | GT: Expense Type | nvarchar | 1 | 0 | | |