| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEG | Accounting Document Segment | 330 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
2 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 318 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
3 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 318 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
4 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 318 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
5 | GLPOS_C_CT | FI Document: Entry View | 367 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
6 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 361 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
7 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 361 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
8 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 361 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
9 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 376 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
10 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 370 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
TOPFund Accounting |
11 | FAGL_CFR_ASGMT | Cash Flow Reporting: Assignment to E/R Account | 5 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
12 | FAGL_CLHCM_ASGMT | Cash-Basis Accounting - HCM Integration: Default RE_ACCOUNT | 3 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
13 | FAGL_CLMIG_ASGMT | Cash Ledger Migration: Profit and Loss Acct for Opening Bal. | 3 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
14 | FAGL_CL_ASGMT | Cash Ledger: Assignment of Income Statemt Accts to B/S Accts | 5 | RE_ACCOUNT | P&L Account | nvarchar | 10 | 0 | | |
15 | FAGL_CL_CONST | Cash Ledger: Constants for Unassigned Processes | 4 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
16 | PSGLFLEX02 | General ledger: Main account assignment | 5 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
17 | PSGLFLEXA | General Ledger: Actual Line Items | 18 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
18 | PSGLFLEXP | General Ledger: Plan Line Items | 20 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
19 | PSGLFLEXT | General Ledger Public Sector: Total | 26 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
20 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 114 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
21 | FAGL_CASHACC_TAX | Cash Account from Tax on Sales/Purchases Indicator | 5 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
22 | FAGL_SPLINFO | Splittling Information of Open Items | 68 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |
TOPInvoice Verification |
23 | RSEG | Document Item: Incoming Invoice | 79 | RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | nvarchar | 10 | 0 | | |