| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 102 | CCBTC | | nvarchar | 10 | 0 | | |
2 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 148 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
3 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
4 | BSEG | Accounting Document Segment | 272 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
5 | BSID_BAK | Accounting: Secondary Index for Customers | 148 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
6 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
7 | BSSEG | Accounting Document Segment | 261 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
8 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
9 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
10 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 261 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
11 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 261 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
12 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 261 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
13 | GLPOS_C_CT | FI Document: Entry View | 77 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
14 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 77 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
15 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 77 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
16 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 77 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
17 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 77 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
18 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 77 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
19 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 310 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
20 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 310 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPBank Accounting |
21 | BSEGC | Document: Data on Payment Card Payments | 23 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
22 | TCCLG | Payment Cards: Settlement Run Log | 2 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
23 | TCCLGT | Payment cards: Settlement run log (texts) | 3 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
24 | BBSID | Accounting: Secondary index for customers | 148 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
25 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 148 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
26 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
27 | BSID | Accounting: Secondary Index for Customers | 148 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
28 | BSIS | Accounting: Secondary Index for G/L Accounts | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
29 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 110 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
30 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 109 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
31 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 109 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
32 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
33 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 53 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPLocalization |
34 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 105 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
35 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 104 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
36 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 104 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
37 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 104 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPPayment Cards |
38 | FPLTC | Payment cards: Transaction data - SD | 21 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
39 | JFRKCC | IS-M/SD: Billing - Payment Card Data | 21 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
40 | JKAPCC | Sales Order: Payment Card Data | 22 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
41 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 28 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | |