| 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 | 58 | REBZG | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 58 | REBZG | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 44 | REBZG | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 44 | REBZG | | nvarchar | 10 | 0 | | |
5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 50 | REBZG | | nvarchar | 10 | 0 | | |
6 | BBP_RBKP | Document Header: Invoice Receipt | 70 | REBZG | Invoice Reference: Document Number for Invoice Reference | nvarchar | 10 | 0 | | |
7 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 54 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
8 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 56 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
9 | BSEG | Accounting Document Segment | 131 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
10 | BSID_BAK | Accounting: Secondary Index for Customers | 54 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
11 | BSIK_BAK | Accounting: Secondary index for vendors | 56 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
12 | BSSEG | Accounting Document Segment | 120 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
13 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 77 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
14 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 77 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
15 | FIAPQAD_PREQ | Database table of Payment Request Qatar Public Sector | 7 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
16 | FIAPSAD_ORDR_LT | Line Item for Order Number KSA | 25 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
17 | FIEUD_FIDOC_I | SAFT: FI Transaction Document Item | 61 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
18 | FISKD_VATCNTRL | Document's information reported to SK authorities | 27 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
19 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 120 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
20 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 120 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
21 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 120 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
22 | GLPOS_C_CT | FI Document: Entry View | 207 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
23 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 207 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
24 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 207 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
25 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 207 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
26 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 212 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
27 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 212 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
28 | J_1UF_TP_BSEGCOR | Items of Corrective documents | 15 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
29 | J_1UF_TP_BSEGORI | Items of Original documents | 15 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
30 | J_3RF_TP_BSEGCOR | Items of Corrective documents | 15 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
31 | J_3RF_TP_BSEGORI | Items of Original documents | 15 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
32 | MHND | Dunning Data | 52 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
33 | REGUP | Processed items from payment program | 124 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
34 | VDSEPA_AUTODEB | Records for new auto debit (SEPA direct debit) | 4 | REBZG | Accounting Document Number | nvarchar | 10 | 0 | | |
35 | VDSEPA_AUTODEB_O | Records for new auto debit (SEPA direct debit) (up to 604) | 4 | REBZG | Accounting Document Number | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
36 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 113 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
37 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 113 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
38 | BBSID | Accounting: Secondary index for customers | 54 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
39 | TXW_S_BSEG | Retrieve BSEG from archive | 64 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
40 | ACCTIT | Compressed Data from FI/CO Document | 168 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
41 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 54 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
42 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 56 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
43 | BSE_CLR_ASGMT | Doc. Segment Add. Data: Clearing Info with Acct Assignment | 7 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
44 | BSID | Accounting: Secondary Index for Customers | 54 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
45 | BSIK | Accounting: Secondary Index for Vendors | 56 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
46 | VBSEGD | Document Segment for Customer Document Parking | 65 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
47 | VBSEGK | Document Segment for Vendor Document Parking | 71 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPFund Accounting |
48 | FMPPFUND | Items for Partial Payment by Fund Process | 9 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPFunds Management |
49 | FMPU_MIG_OPITEMS | Migration of Payment Update: Doc. Bundle to Be Closed | 12 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
50 | PSOSEGD | Document Segment: Recurring Request, Customer | 66 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
51 | PSOSEGK | Recurring Request Document Segment, Vendors | 72 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
52 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 95 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
53 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 77 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
54 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 77 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Reorganization |
55 | FAGL_R_APAR | Reorganization: Object List for Receivables and Payables | 27 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPInformation System |
56 | BWPOS | Valuations for Open Items | 37 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
57 | DKOKP | Open Item Account Balance Audit Trail | 71 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPInvoice Verification |
58 | RBKP | Document Header: Invoice Receipt | 70 | REBZG | Invoice Reference: Document Number for Invoice Reference | nvarchar | 10 | 0 | | |
TOPLoans Management |
59 | TDESRVDINVIP | CML Corr.: Invoice Positions | 12 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
60 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 220 | REBZG | Belegnummer der Rechnung, zu der der Vorgang gehört | nvarchar | 10 | 0 | | |
61 | VDBEPI | Posted line items for document header | 120 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
62 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 120 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
63 | VDBEPP | Flow Data - Planned Item | 146 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
64 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 146 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
65 | VDCFWAREHOUSE | Cash Flow Management | 80 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
66 | VDCHK_IOA | Results of Interest on Arrears Check | 5 | REBZG | Accounting Document Number | nvarchar | 10 | 0 | | |
67 | VDCHK_IOA_OI | Check Interest on Arrears - Open Items | 9 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
68 | VDZNB_USAGE | Payment Postprocessing: Usage of a Payment Postpr. Activity | 19 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
69 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 149 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPLocalization |
70 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 53 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
71 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 51 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
72 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 51 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
73 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 51 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
74 | FPRL_ITEM | Item Data | 62 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPReal Estate Management |
75 | VIAKBSEG | Document Line Item from SCS for Interface | 66 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
76 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 122 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | |