| 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 | 39 | MSCHL | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 39 | MSCHL | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 37 | MSCHL | | nvarchar | 1 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 37 | MSCHL | | nvarchar | 1 | 0 | | |
5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 43 | MSCHL | | nvarchar | 1 | 0 | | |
6 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 63 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
7 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 66 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
8 | BSEG | Accounting Document Segment | 155 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
9 | BSID_BAK | Accounting: Secondary Index for Customers | 63 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
10 | BSIK_BAK | Accounting: Secondary index for vendors | 66 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
11 | BSSEG | Accounting Document Segment | 144 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
12 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 144 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
13 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 144 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
14 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 144 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
15 | GLPOS_C_CT | FI Document: Entry View | 175 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
16 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 175 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
17 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 175 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
18 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 175 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
19 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 178 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
20 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 178 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
21 | MHND | Dunning Data | 26 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
22 | T040 | Dunning keys | 2 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
23 | T040A | Dunning key names | 3 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 119 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 119 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPAdvertising Management |
26 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 41 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPBilling |
27 | VBRK | Billing Document: Header Data | 64 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPConstruction Industry |
28 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 17 | MSCHL | Notification Key for Data Record ANMEL | nvarchar | 4 | 0 | | |
29 | PDBKNW | Construction Industry Social Fund Proced: Employee Statement | 33 | MSCHL | Notification Key for Data Record ANMEL | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
30 | BBSID | Accounting: Secondary index for customers | 63 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
31 | VVBKD | Sales Document: Business Data | 27 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
32 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 63 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
33 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 66 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
34 | BSID | Accounting: Secondary Index for Customers | 63 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
35 | BSIK | Accounting: Secondary Index for Vendors | 66 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
36 | VBSEGD | Document Segment for Customer Document Parking | 77 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
37 | VBSEGK | Document Segment for Vendor Document Parking | 85 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
38 | PSOSEGD | Document Segment: Recurring Request, Customer | 78 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
39 | PSOSEGK | Recurring Request Document Segment, Vendors | 86 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPInformation System |
40 | BWPOS | Valuations for Open Items | 27 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
41 | DKKOP | Balance Audit Trail | 44 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
42 | DKKOS | Balance Audit Trail | 80 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
43 | DKOKP | Open Item Account Balance Audit Trail | 62 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
44 | DKOKS | Open Item Account Balance Audit Trail Master Record | 81 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPLocalization |
45 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 46 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
46 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 44 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
47 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 44 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
48 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 44 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
49 | NVBRK | IS-H: Billing document header data | 46 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
50 | TN22Q | IS-H: Control Parameters FI Posting Copayment Request | 6 | MSCHL | Dunning Key | nvarchar | 1 | 0 | | |
51 | TN22S | IS-H: Control Parameters FI Posting Down Payment Request | 6 | MSCHL | Dunning Key | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
52 | VIAKBSEG | Document Line Item from SCS for Interface | 48 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
53 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 146 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
54 | /BEV3/CHABRSTZ_P | CH Settlement Items - With Translations | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
55 | /BEV3/CHBDMDHST | History of Condit. Modifications from Temp. Settlement Items | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
56 | /BEV3/CHERGSTZ_P | CH Settlement Items - With Translations | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
57 | /BEV3/CHERGSTZ_S | CH Settlement Statistics | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
58 | /BEV3/CHEXCSTZ_P | CH Settlement Items/Non-Posted Docs w/o Date Statistics | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
59 | /BEV3/CHRESSTZ_P | CH Settlement Items - Reset Documents (2/Transaction) | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
60 | /BEV3/CHSHTSTZ_P | CH Settlement Item | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
61 | /BEV3/CHSIMBDMDH | CH simulation history of modifications caused by conditions | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
62 | /BEV3/CHSIMSTZ_P | CH Simulation Items | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
63 | /BEV3/CHSIMSTZ_S | CH Simulation Statistics | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
64 | /BEV3/CHTMPMDHST | Temp. history of cond. modifications from temp. settle. item | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
65 | /BEV3/CHTRMSTZ_P | CH Date Item | 60 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
66 | /BEV3/CHTRMSTZ_S | CH Date Statistics | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
67 | /BEV3/CHVABRSTZS | CH Settlement Statistics | 61 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPSales |
68 | VBKD | Sales Document: Business Data | 27 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |
TOPSimulation |
69 | VSVBKD_CN | Version: Sales document - commercial data | 28 | MSCHL | Dunning key | nvarchar | 1 | 0 | | |