| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Accounting |
1 | CRMC_BEAVALTYACC | IPM: Assignment of Value Types for Accounts in Company Code | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPFinancials Basis |
2 | ACCSYS04 | Customizing for Accounting System | 3 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
3 | FMSGLCLASS | Classification for SGL accounts | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPFunds Management |
4 | FMBLCLASS | Classification for BL accounts | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
5 | FMBLEXCLACCWSHOT | Exclude Accounts from Automatic Offset/Deletion Procedure | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
6 | FMBUDACT | Classification for BL accounts | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPGL transfer |
7 | TBKKC_BUKRS | BCA Locally Duplicated Values for Corresponding FI | 8 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPGrantee Management |
8 | GMCOUPD | CO Settings for Grants Management Update | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
9 | GMFIUPD | FI Settings for Grants Management Update | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPMaster Data |
10 | GMCOA | Special GL accounts in chart of accounts for grants mgmt | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
11 | GMGAAP | Special GL accounts in chart of accounts for GM GAAP | 2 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPPosition Budgeting and Control |
12 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 34 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
TOPSAP Retail Store |
13 | TWIC0403A | SAP Retail Store II: Accounts for Cash Payment | 4 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
14 | TWIC0403B | SAP Retail Store II: Accounts for Cash Payment | 5 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
15 | TWIC1010A | SRSII: Define Grouping Schema and Assign Chart of Accounts | 4 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
16 | TWIC1010B | SAP Retail Store II: Assignn Permitted G/L Accounts | 5 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
17 | WOSCR_EXI_001 | SRS Conv. Retailing - Groups for Expense Invoice Accounts | 4 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
18 | WOSCR_EXI_002 | G/L Accounts for Expense Invoice | 5 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
19 | WOSCR_GRP_001 | SRS Convenience Retailing - Grouping of Accounts | 6 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |
20 | WOSCR_GRP_003 | SRS Convenience Retailing - Account Lines | 6 | CHRT_ACCTS | Chart of Accounts | nvarchar | 4 | 0 | | |