| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 21 | SCNTR | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 22 | SCNTR | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 24 | SCNTR | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 24 | SCNTR | | nvarchar | 10 | 0 | | |
5 | FAGLFLEXC | EMU: Sum of Open Items of Table FAGLFLEXT | 31 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
6 | FAGLFLEXD | EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT | 33 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
7 | FAGLFLEXT_BAK | General Ledger: Totals | 33 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
8 | FAGLFLEXT_DIF | Delta Table: G/L Totals | 33 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
9 | ZSAWA | Actual line item table | 23 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
10 | ZSAWP | Plan line items table | 23 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
11 | ZSAWT | Summary table | 22 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
12 | ZZ001A | Actual Line Item Table | 30 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
13 | ZZ001P | Plan Line Items Table | 30 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
14 | ZZ001T | Summary Table | 29 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
15 | ZZSL01A | Actual line item table | 27 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
16 | ZZSL01P | Plan line items table | 27 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
17 | ZZSL01T | Summary table | 26 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
TOPBasic Functions |
18 | GGREFA | Example for Global FI-SL Line Items (Actual) | 25 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
19 | GGREFP | Example for Global FI-SL Line Items (Plan) | 25 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
20 | GGREFT | Example for Global FI-SL Summary Table | 24 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
21 | GLPO1 | Plan Line Items for Object Table | 32 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
22 | GLPO2 | Plan Line Items for Object Table Global | 36 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
23 | GLPO3 | Plan Line Items for Object Table | 32 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
24 | GLREFA | Example for Local FI-SL Line Items (Actual) | 23 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
25 | GLREFP | Example for Local FI-SL Line Items (Plan) | 23 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
26 | GLREFT | Example for Local FI-SL Summary Table | 22 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
27 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 24 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
28 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 24 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
29 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 32 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
30 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 36 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
31 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 32 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
32 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 29 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
33 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 33 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
34 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 29 | SCNTR | Cost Center | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
35 | GLISDEA | Actual Line Item Tables for Insurance (DE) | 37 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
36 | GLISDEP | Plan Line Item Table for Insurance (DE) | 37 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
37 | GLISDET | Summary Table for Insurance (DE) | 36 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
38 | GRISDEA | Actual Line Item Table for Insurance (DE) - Rollup | 37 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
39 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 37 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
40 | GRISDET | Summary Table for Insurance (DE) - Rollup | 36 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
TOPFinancial Services Localization |
41 | /CEEIS/RUA | Actual line item table | 31 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
42 | /CEEIS/RUP | Plan line items table | 31 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
43 | /CEEIS/RUT | Totals Table | 30 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
TOPFunds Management |
44 | FMSPLITA | Actual line item table | 28 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
45 | FMSPLITP | Plan line items table | 28 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
46 | FMSPLITT | Summary table | 29 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
47 | FAGLFLEX06 | General ledger: Sender SAP additional account assignment | 2 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
48 | FAGLFLEXA | General Ledger: Actual Line Items | 24 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
49 | FAGLFLEXP | General Ledger: Plan Line Items | 26 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
50 | FAGLFLEXT | General Ledger: Totals | 33 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
51 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 25 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
52 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 23 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
53 | GLFLEX06 | General ledger: Sender SAP additional account assignment | 2 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
54 | GLFLEXA | Flexible general ledger: Actual line items | 19 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
55 | GLFLEXP | Flexible G/L: Plan line items | 19 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
56 | GLFLEXT | Flexible G/L: Totals | 25 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
57 | JVGLFLEX06 | General ledger: Sender SAP additional account assignment | 2 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
58 | JVGLFLEXA | General Ledger: Actual Line Items | 23 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
59 | JVGLFLEXP | General Ledger: Plan Line Items | 25 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
60 | JVGLFLEXT | General Ledger: Totals | 32 | SCNTR | Sender cost center | nvarchar | 10 | 0 | | |
TOPTariffs, Duties and Permits |
61 | OIHEDA | Actual line item table, IS-OIL Excise Duty Special Ledger | 37 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
62 | OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger | 37 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |
63 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 36 | SCNTR | Partner cost center | nvarchar | 10 | 0 | | |