| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 64 | XREF3 | | nvarchar | 20 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 64 | XREF3 | | nvarchar | 20 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 83 | XREF3 | | nvarchar | 20 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 83 | XREF3 | | nvarchar | 20 | 0 | | |
5 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 53 | XREF3 | | nvarchar | 20 | 0 | | |
6 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 104 | XREF3 | | nvarchar | 20 | 0 | | |
7 | /CCEE/SIFIPOBOTI | ePoboti: Obligatory manysided reconciliation - XML output | 43 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
8 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
9 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
10 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
11 | BSEG | Accounting Document Segment | 275 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
12 | BSID_BAK | Accounting: Secondary Index for Customers | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
13 | BSIK_BAK | Accounting: Secondary index for vendors | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
14 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
15 | BSSEG | Accounting Document Segment | 264 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
16 | DFKKCFKWL | KWL: KPI Cockpit Worklist | 20 | XREF3 | Third Reference | nvarchar | 32 | 0 | | |
17 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
18 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
19 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 264 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
20 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 264 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
21 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 264 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
22 | GLPOS_C_CT | FI Document: Entry View | 293 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
23 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 293 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
24 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 293 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
25 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 293 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
26 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 302 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
27 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 302 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
28 | REGUP | Processed items from payment program | 142 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPAccounting Interface |
29 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 56 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
30 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 56 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPCross-Application Components |
31 | BBSID | Accounting: Secondary index for customers | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPElectronic Bank Statement |
32 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 91 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
33 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 8 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
34 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 15 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPFinancial Accounting |
35 | ACCTIT | Compressed Data from FI/CO Document | 179 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
36 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
37 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
38 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
39 | BSID | Accounting: Secondary Index for Customers | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
40 | BSIK | Accounting: Secondary Index for Vendors | 138 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
41 | BSIS | Accounting: Secondary Index for G/L Accounts | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
42 | VBSEGA | Document Segment for Document Parking - Asset Database | 68 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
43 | VBSEGD | Document Segment for Customer Document Parking | 103 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
44 | VBSEGK | Document Segment for Vendor Document Parking | 114 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
45 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 109 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPFunds Management |
46 | FMIFIIT | FI Line Item Table in Funds Management | 65 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPFunds Management-Specific Postings |
47 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 108 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
48 | PSOSEGD | Document Segment: Recurring Request, Customer | 104 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
49 | PSOSEGK | Recurring Request Document Segment, Vendors | 112 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
50 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 108 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPGeneral Ledger Accounting |
51 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 63 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
52 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
53 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 54 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPInvoice Verification |
54 | RBKP | Document Header: Invoice Receipt | 143 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPLocalization |
55 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 107 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
56 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 106 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
57 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 106 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
58 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 106 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPPayment Transactions |
59 | FPRL_ITEM | Item Data | 71 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
60 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 31 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | | |