| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEG | Accounting Document Segment | 78 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
2 | BSSEG | Accounting Document Segment | 67 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
3 | FILUD_AA_ITEMS | SAFT: FI Asset line item details | 11 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
4 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 67 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
5 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 67 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
6 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 67 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
7 | GLPOS_C_CT | FI Document: Entry View | 76 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
8 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 76 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
9 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 76 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
10 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 76 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
11 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 76 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
12 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 76 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
13 | TRAS | Interval for Days in Arrears | 3 | BZDAT | Reference Date for Interval | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
14 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 149 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
15 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 149 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
16 | ANEK | Document Header Asset Posting | 42 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
17 | ANEP | Asset Line Items | 13 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
18 | T012C | Terms for bank transactions | 6 | BZDAT | Reference date for determining the value date | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | DFKKOPKX | Items for Contract Accounting Document (Enhancement) | 9 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
20 | DFKKORDERPOS | Requests: Items | 83 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
21 | DFKKORDERPOS_S | Request Templates: Items | 60 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
22 | TXW_S_ANEK | Retrieve ANEP from archive | 20 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
23 | TXW_S_ANEP | Retrieve ANEP from archive | 21 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPElectronic Bank Statement |
24 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 36 | BZDAT | Reference Date | nvarchar | 8 | 0 | | |
25 | FEB_ACT | Acct Assignment Templates | 36 | BZDAT | Reference Date | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
26 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 43 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
27 | KMZEI | FI: Account Assignment Model Item Information | 28 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
28 | KOMU | Account Assignment Templates for G/L Account Items | 28 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
29 | VBSEGA | Document Segment for Document Parking - Asset Database | 26 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
30 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 137 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
31 | FMBGACORRS | History for Input Tax Adjustments PCOs | 12 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
32 | FMBGADCTAX | Data from Backdated Tax Calculation for PCOs | 12 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
33 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 119 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
34 | PSOSEGA | Document Segment for Assets Document Parking | 27 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
35 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 131 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
36 | FAGL_SPLINFO | Splittling Information of Open Items | 38 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPGL Account Posting |
37 | TCJ_POSITIONS | Cash Journal Document Items | 43 | BZDAT | Reference Date | nvarchar | 8 | 0 | | |
TOPInvoice Verification |
38 | RBCO | Document Item, Incoming Invoice, Account Assignment | 54 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPLease Accounting |
39 | FILA_GF_ITEMDATA | Process Data | 30 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPOverhead Cost Orders |
40 | AUAK | Document Header for Settlement | 5 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
41 | COBRA | Settlement Rule for Order Settlement | 17 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
42 | VIAKBSEG | Document Line Item from SCS for Interface | 40 | BZDAT | Date | nvarchar | 8 | 0 | | |
43 | VIBEAG | Outflows for correction items | 8 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
44 | VITAXR | Outflows for correction items | 8 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
45 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 69 | BZDAT | Asset value date | nvarchar | 8 | 0 | | |