| 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 | | |
