| 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 | 45 | SKNTO | | decimal | 13 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 45 | SKNTO | | decimal | 13 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 48 | SKNTO | | decimal | 15 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 48 | SKNTO | | decimal | 15 | 0 | | |
5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 56 | SKNTO | | decimal | 15 | 0 | | |
6 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
7 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 49 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
8 | BSEG | Accounting Document Segment | 114 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
9 | BSID_BAK | Accounting: Secondary Index for Customers | 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
10 | BSIK_BAK | Accounting: Secondary index for vendors | 49 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
11 | BSSEG | Accounting Document Segment | 103 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
12 | FUDT_VDOCBSECLRH | Additional Data for Document Segment: Clearing Information | 23 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
13 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 103 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
14 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 103 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
15 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 103 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
16 | FUDT_VDOCBSE_CLR | Additional Data for Document Segment: Clearing Information | 23 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
17 | GLPOS_C_CT | FI Document: Entry View | 330 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
18 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 389 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
19 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 389 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
20 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 339 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
21 | REGUP | Processed items from payment program | 57 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPAccounting Interface |
22 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 459 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
23 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 459 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPCross-Application Components |
24 | BBSID | Accounting: Secondary index for customers | 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPData Retention Tool |
25 | TXW_S_BSEG | Retrieve BSEG from archive | 25 | SKNTO | Cash discount amount in local currency | nvarchar | 16 | 0 | | |
TOPFinancial Accounting |
26 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
27 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 49 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
28 | BSE_CLR | Additional Data for Document Segment: Clearing Information | 23 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
29 | BSID | Accounting: Secondary Index for Customers | 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
30 | BSIK | Accounting: Secondary Index for Vendors | 49 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
31 | VBSEGD | Document Segment for Customer Document Parking | 58 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
32 | VBSEGK | Document Segment for Vendor Document Parking | 64 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPFunds Management |
33 | FMIFIIT | FI Line Item Table in Funds Management | 58 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPFunds Management-Specific Postings |
34 | PSOSEGD | Document Segment: Recurring Request, Customer | 59 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
35 | PSOSEGK | Recurring Request Document Segment, Vendors | 65 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPInformation System |
36 | DKKOP | Balance Audit Trail | 51 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
37 | DKOKP | Open Item Account Balance Audit Trail | 47 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPJoint Venture und Production Sharing Accounting |
38 | T8J_POST_ERROR_C | Documents with errors in JV posting (Open Items) | 30 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
TOPLocalization |
39 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 58 | SKNTO | Cash Discount Amount (+/-) in Local Currency | decimal | 13 | 2 | | |
40 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 57 | SKNTO | Cash Discount Amount in Local Currency | decimal | 15 | 2 | | |
41 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 57 | SKNTO | Cash Discount Amount in Local Currency | decimal | 15 | 2 | | |
42 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 57 | SKNTO | Cash Discount Amount in Local Currency | decimal | 15 | 2 | | |
TOPPayment Transactions |
43 | REGUPO | Line item status before the 'n'th change | 11 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |
44 | REGUP_CORE | Processed Items from Payment Program | 18 | SKNTO | Cash discount amount in local currency | decimal | 23 | 2 | | |
TOPRemaining Beverage - Obsolete Objects |
45 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 105 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | | |