| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_20100_T8G17 | Backup copy - T8G17 | 6 | LINETYPE | | nvarchar | 5 | 0 | | |
2 | FITDKWC_FSCLINES | Form Structure: Lines | 7 | LINETYPE | Line Type in Form | nvarchar | 1 | 0 | | |
3 | FITDKW_FSCLINES2 | Form Structure: Lines 2 (extended for new Zakat) | 7 | LINETYPE | Line Type in Form 2 (extended for new Zakat) | nvarchar | 1 | 0 | | |
4 | FITDOMC_FSCLINES | Form Structure: Lines (Oman) | 7 | LINETYPE | Line Type in Form | nvarchar | 1 | 0 | | |
5 | FITDQAC_FSCLINES | Form Structure: Lines | 7 | LINETYPE | Line Type in Form | nvarchar | 1 | 0 | | |
6 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 164 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
7 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 164 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
8 | IDSAU_FSCLINES | Form Structure: Lines | 7 | LINETYPE | Line Type in Form | nvarchar | 1 | 0 | | |
9 | MRP_REQ_LINE | Date and Quantity Values for Change Requests | 9 | LINETYPE | Line Type of Change Request Line Record | nvarchar | 2 | 0 | | |
10 | REP_EAPS_DCOLN_C | Data Connector: Layout Customizing/Line Definition | 5 | LINETYPE | Line Type | nvarchar | 1 | 0 | | |
11 | ZSPLITA | Isteinzelposten-Tabelle | 50 | LINETYPE | Positionstyp | nvarchar | 5 | 0 | | |
TOPAccounting Interface |
12 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 99 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
13 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 99 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPActivity-Based Costing |
14 | COTPLDEFCELL | Template Cell Control | 2 | LINETYPE | Template Row Types | nvarchar | 1 | 0 | | |
15 | COTPLDEFLINETYP | Template line types per application | 2 | LINETYPE | Template Row Types | nvarchar | 1 | 0 | | |
16 | COTPLLINETYPE | Template linetypes | 1 | LINETYPE | Template Row Types | nvarchar | 1 | 0 | | |
17 | COTPLLINETYPET | Template line type texts | 2 | LINETYPE | Template Row Types | nvarchar | 1 | 0 | | |
TOPBusiness Consolidation |
18 | UCF7000 | Flexible Upload: Method Categories | 2 | LINETYPE | Upload: Row Type Indicator | nvarchar | 1 | 0 | | |
TOPBusiness Object Builder |
19 | SBMIGTTYPE | Mapping: Reference Type -> Table Type | 6 | LINETYPE | Name of Dictionary Type | nvarchar | 30 | 0 | | |
TOPFund Accounting |
20 | FMCCAVCA | Actual line item table | 46 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
21 | FMGLFLEXA | General Ledger: Actual Line Items | 43 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
22 | PSGLFLEXA | General Ledger: Actual Line Items | 47 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPFunds Management |
23 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 50 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
24 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 54 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
25 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 75 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
26 | FMSPLITA | Actual line item table | 53 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
27 | FMUSFGA | Actual line item table for US Federal Government. | 75 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
28 | FMUSFGFACTS1A | 4Actual line item table | 50 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
29 | FMUSFGFACTS2A | Actual line item table | 54 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPGeneral Ledger Accounting |
30 | FAGLFLEXA | General Ledger: Actual Line Items | 45 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
31 | FAGL_MIG_LINETYP | Document-Specific Item Category Assignment | 6 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
32 | GLFLEXA | Flexible general ledger: Actual line items | 54 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
33 | T8G02 | Item categories | 1 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
34 | T8G02T | Item categories | 2 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
35 | T8G16 | Allocation: internal key - item category (SAP) | 4 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
36 | T8G17 | Allocation: acct number - item type | 5 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
37 | T8G20 | Splitting Rule: Header Data | 5 | LINETYPE | Item category of leading item | nvarchar | 5 | 0 | | |
38 | T8G21 | Splitting rule: Item categories to be processed | 5 | LINETYPE | Item category to be processed | nvarchar | 5 | 0 | | |
39 | T8G21A | Splitting rule: Base item categories | 5 | LINETYPE | Item category to be processed | nvarchar | 5 | 0 | | |
40 | T8G22 | Splitting rule: Additional items | 5 | LINETYPE | Item category from which the additional item pair is created | nvarchar | 5 | 0 | | |
41 | T8G28 | Item categories permitted per accounting transaction variant | 4 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
42 | T8G29 | Item categories permitted for each business transaction | 2 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
43 | T8G30A | Acct determination key for doc splitting | 2 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
44 | T8G30AT | Account determination key description for doc splitting | 3 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
45 | T8G30B | Acct determination for document splitting - accounts | 3 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPGrantee Management |
46 | GMIA | Actual Line Item Table | 68 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPInvoicing |
47 | TE552 | Classification Indicator for Billing Line | 4 | LINETYPE | Intended Purpose of Classification Line | nvarchar | 2 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
48 | JVGLFLEXA | General Ledger: Actual Line Items | 47 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPLocalization |
49 | IDCN_FSCLINES | Form Structure: Lines | 7 | LINETYPE | Line Type in Form | nvarchar | 1 | 0 | | |
TOPSAP Business Workflow |
50 | SWF_TRC_HFILT | Trace: Hierarchy Filter | 4 | LINETYPE | Condition Editor: Type of Line in Internal Display | nvarchar | 1 | 0 | | |
TOPSpecial Purpose Ledger |
51 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 55 | LINETYPE | Item category | nvarchar | 5 | 0 | | |
TOPTraders and Schedulers Workbench |
52 | OIJ_EL_LAYT_EV | Laytime start and end events | 7 | LINETYPE | Type of line | nvarchar | 1 | 0 | | |
TOPTravel Expenses |
53 | PTRV_CCC | Error Receipts for Credit Card Clearing | 3 | LINETYPE | Line Type in Credit Card File | nvarchar | 1 | 0 | | |