| 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 | 109 | PPRCT | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 109 | PPRCT | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 31 | PPRCT | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 153 | PPRCT | | nvarchar | 10 | 0 | | |
5 | /OPT/VIM_1ITEM_S | Document Item | 43 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
6 | /OPT/VIM_TITEM | Document Item | 43 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
7 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 165 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
8 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 170 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
9 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
10 | BSEG | Accounting Document Segment | 262 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
11 | BSID_BAK | Accounting: Secondary Index for Customers | 165 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
12 | BSIK_BAK | Accounting: Secondary index for vendors | 170 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
13 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
14 | BSSEG | Accounting Document Segment | 251 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
15 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
16 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
17 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 251 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
18 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 251 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
19 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 251 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
20 | GLPOS_C_CT | FI Document: Entry View | 197 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
21 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 197 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
22 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 197 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
23 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 197 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
24 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 202 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
25 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 202 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
26 | REGUP | Processed items from payment program | 175 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
27 | YVIM_1ITEM | Document Item | 43 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPBasic Functions |
28 | BSIX | Index table for customer bills of exchange used | 39 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPData Collection |
29 | CF715 | IDES:PCA-Integration | 13 | PPRCT | Partner Profitcenter | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
30 | /OPT/VIM_1ITEM | Document Item | 43 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
31 | BFIT_A | FI Subsequent BA/PC Adjustment: G/L Account Items | 21 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
32 | BFOD_A | FI Subsequent BA/PC Adjustment: Customer Items | 24 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
33 | BFOK_A | FI subsequent BA/PC adjustment: Vendor items | 24 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
34 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 165 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
35 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 170 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
36 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
37 | BSID | Accounting: Secondary Index for Customers | 165 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
38 | BSIK | Accounting: Secondary Index for Vendors | 170 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
39 | BSIS | Accounting: Secondary Index for G/L Accounts | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
40 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 43 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
41 | KMZEI | FI: Account Assignment Model Item Information | 59 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
42 | KOMU | Account Assignment Templates for G/L Account Items | 59 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
43 | RF048 | Subseq.BA/PC Adjustmnt: Index/Distributn Vector (Calculate) | 9 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
44 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 56 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
45 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
46 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 68 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
47 | FPRL_ITEM | Item Data | 78 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
48 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 18 | PPRCT | Partner Profit Center | nvarchar | 10 | 0 | | |