| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Functions |
1 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 32 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
2 | FILCP | FI-LC: Plan line items for object table | 32 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
3 | FILCT | FI-LC: Global totals table with 2 object tables | 31 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
4 | GLPO1 | Plan Line Items for Object Table | 30 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
5 | GLPO2 | Plan Line Items for Object Table Global | 38 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
6 | GLPO3 | Plan Line Items for Object Table | 30 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
7 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 30 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
8 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 38 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
9 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 30 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
10 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 27 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
11 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 35 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |
12 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 27 | SASSC | Company ID of trading partner | nvarchar | 6 | 0 | | |