| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 87 | XRAGL | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 87 | XRAGL | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 122 | XRAGL | | nvarchar | 1 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 110 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 118 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
6 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
7 | BSEG | Accounting Document Segment | 254 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
8 | BSID_BAK | Accounting: Secondary Index for Customers | 110 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
9 | BSIK_BAK | Accounting: Secondary index for vendors | 118 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
10 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
11 | BSSEG | Accounting Document Segment | 243 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
12 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
13 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
14 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 243 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
15 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 243 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
16 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 243 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
17 | GLPOS_C_CT | FI Document: Entry View | 288 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
18 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 288 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
19 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 288 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
20 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 288 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
21 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 297 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
22 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 297 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
23 | DFKKMOP | Items in contract account document | 100 | XRAGL | Clearing posting reversed | nvarchar | 1 | 0 | | |
24 | DFKKMOPW | Items in contract account document | 23 | XRAGL | Clearing posting reversed | nvarchar | 1 | 0 | | |
25 | DFKKOP | Items in contract account document | 100 | XRAGL | Clearing posting reversed | nvarchar | 1 | 0 | | |
26 | DFKKOPW | Items in contract account document | 23 | XRAGL | Clearing posting reversed | nvarchar | 1 | 0 | | |
27 | DFKKOP_REP | Open Items from FPO4 | 104 | XRAGL | Clearing posting reversed | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
28 | BBSID | Accounting: Secondary index for customers | 110 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
29 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 110 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
30 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 118 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
31 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
32 | BSID | Accounting: Secondary Index for Customers | 110 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
33 | BSIK | Accounting: Secondary Index for Vendors | 118 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
34 | BSIS | Accounting: Secondary Index for G/L Accounts | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
35 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 108 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
36 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
37 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 45 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
TOPInvoicing |
38 | DEABPS | Customer change table: Logical view of BB amounts | 92 | XRAGL | Clearing posting reversed | nvarchar | 1 | 0 | | |
TOPLocalization |
39 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 129 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
40 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 128 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
41 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 128 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
42 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 128 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
TOPPayment Transactions |
43 | PAYR | Payment Medium File | 53 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
44 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 10 | XRAGL | Indicator: Clearing was Reversed | nvarchar | 1 | 0 | | |