| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_TAXDTL | Tax 2.0 - New Mexico Tax Details | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
2 | GLE_ECS_BAL_ITEM | GL open items that are not in ECS | 6 | POS_NO | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
3 | GLE_ECS_ITEM | ECS: Error Correction Items | 9 | POS_NO | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | |
TOPBack Office |
4 | TRET_PROTOCOL | Transactions Generated for Endowments | 4 | POS_NO | Item Number | nvarchar | 8 | 0 | | |
5 | TRET_TRANSACTION | Transactions to Be Created for Endowments | 4 | POS_NO | Item Number | nvarchar | 8 | 0 | | |
TOPBasic Functions |
6 | ETXDCI | External tax document: line item info | 7 | POS_NO | Tax document item number | nvarchar | 6 | 0 | | |
7 | TTXY | External tax interface: tax information | 13 | POS_NO | Sales Document Item | nvarchar | 6 | 0 | | |
TOPDepreciation Simulation |
8 | IMCEPPT | IM Summarization: Texts for program positions | 6 | POS_NO | IM Summarization: Position number of program position | nvarchar | 8 | 0 | | |
9 | IMCHIE | IM Summarization: Buffer for investment program hierarchy | 6 | POS_NO | IM Summarization: Position number of program position | nvarchar | 8 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
10 | BCA_DIM_CALCDET | Calculation details for billing items | 4 | POS_NO | Position Number | nvarchar | 3 | 0 | | |
TOPInformation System |
11 | CMS_LIQ_CFL | CMS Liquidation Cash Flows (Tempoaray Solution for Rel 3.0) | 5 | POS_NO | CMS Liquidation: Cash Flow Position Number | nvarchar | 4 | 0 | | |
TOPOLAP Technology |
12 | RSR_TRACE_POS | OLAP Trace | 2 | POS_NO | | int | 10 | 0 | | |
TOPProduction and Revenue Accounting |
13 | OIU_PAR | Obsolete | 3 | POS_NO | Document Line Number | nvarchar | 5 | 0 | | |
14 | OIU_QUAN | Additional quantities for PRA transactions in valuation | 3 | POS_NO | Document Line Number | nvarchar | 5 | 0 | | |
15 | OIU_RV_VLTXNS | Valuation Transactions | 17 | POS_NO | Last used (highest) position number | nvarchar | 3 | 0 | | |
TOPRevenue |
16 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 18 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
17 | OIURV03_FRMHDR | Valuation Transaction Level 3 - Formula | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
18 | OIURV03_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
19 | OIURV03_TAXDTL | Valuation Tax Master Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
20 | OIURV03_TAXEMP | Valuation Tax Exempt Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
21 | OIURV03_TAXHDR | Valuation Tax Header | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
22 | OIURV03_TAXMKT | Valuation Tax Marketing Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
23 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
TOPSecurities |
24 | CMS_SEC_ACC_POS | Securities position details | 4 | POS_NO | Sequence Number of a Position in a Securities Account | nvarchar | 4 | 0 | | |
TOPTransaction Tax Engine |
25 | TTEPD3_USITEM | Persistency TTE Document UsItem | 8 | POS_NO | Tax document item number | nvarchar | 6 | 0 | | |
26 | TTEPDT_USITEM | Persistency TTE Document UsItem | 8 | POS_NO | Tax document item number | nvarchar | 6 | 0 | | |
27 | TTESDT_USITEM | Output Exemptions | 8 | POS_NO | Tax document item number | nvarchar | 6 | 0 | | |
TOPValuation |
28 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 18 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
29 | OIURV_DOC_FRMHDR | Valuation Transaction Level 3 - Formula | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
30 | OIURV_DOC_FRMMKT | Valuation Transactions Level 3 - Marketing Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
31 | OIURV_DOC_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
32 | OIURV_DOC_RUNTKT | Valuation Transaction - Run Ticket | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
33 | OIURV_DOC_TAXDTL | Valuation Tax Master Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
34 | OIURV_DOC_TAXEMP | Valuation Tax Exempt Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
35 | OIURV_DOC_TAXHDR | Valuation Tax Header | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
36 | OIURV_DOC_TAXMKT | Valuation Tax Marketing Detail | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
37 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |
38 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 5 | POS_NO | Position Number for | nvarchar | 10 | 0 | | |