| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FIAPSAD_ADP_LT | Advance Payment Request Line Items Details | 6 | ITEMNR | Commitment Item | nvarchar | 14 | 0 | | |
2 | MEV_D_AD_ITEM | Period-End Valuation: Accruals Document Item | 4 | ITEMNR | Period-End Valuation: Document Item | nvarchar | 6 | 0 | | |
3 | CMACDB_FEEFICA | Fee Calculation Document: FI-CA Documents | 3 | ITEMNR | Item Number | nvarchar | 4 | 0 | | |
4 | CMACDB_FEESC | Fee Calculation Document Items (Program) | 3 | ITEMNR | Item Number | nvarchar | 4 | 0 | | |
5 | CMACDB_FEESM | Fee Calculation Document Items (Module) | 3 | ITEMNR | Item Number | nvarchar | 4 | 0 | | |
6 | CMACDB_ITEMRES | Fee Calculation Line Results | 3 | ITEMNR | Item Number | nvarchar | 4 | 0 | | |
TOPBasic Functions |
7 | ETXDCI | External tax document: line item info | 3 | ITEMNR | External-tax document item number | nvarchar | 6 | 0 | | |
8 | ETXDCJ | Ext. tax document: tax rates and amounts by Jurisdict. level | 3 | ITEMNR | External-tax document item number | nvarchar | 6 | 0 | | |
TOPContract Accounts Receivable and Payable |
9 | DFKKFMBGAINFO | Tax Information for Public-Owned Commercial Operations | 3 | ITEMNR | 5 Character Numeric NUMC | nvarchar | 5 | 0 | | |
TOPDownloadUpload |
10 | /DSD/HH_RACOCICI | DSD Route Settlement: Check-Out/Check-In - Money Item | 4 | ITEMNR | DSD - RA: Check-Out / Check-In - Item Number | nvarchar | 6 | 0 | | |
11 | /DSD/HH_RACOCIMI | DSD Route Settlement: Check-Out Check-In - Items | 4 | ITEMNR | DSD - RA: Check-Out / Check-In - Item Number | nvarchar | 6 | 0 | | |
TOPKnowledge Base |
12 | ISMIT | SDB: Symptom Trigger | 4 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
13 | ISMITCA | SDB: Symptom Trigger Cause | 5 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
14 | ISMITOP | SDB: Symptom Trigger Object Part | 5 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
15 | ISMITPR | SDB: Symptom Trigger Problem | 5 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
16 | ISMITXT | SDB: Symptom Trigger Short Text | 4 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
17 | ISMOB | SDB: Symptom Object table | 4 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
18 | ISMSL | SDB: Symptom Solution Link table | 4 | ITEMNR | SDB: Trigger Number | nvarchar | 4 | 0 | | |
TOPStock Visibility |
19 | /DSD/SV_RACOCICI | DSD SV: Check-Out / Check-In - Money Item | 4 | ITEMNR | DSD - RA: Check-Out / Check-In - Item Number | nvarchar | 6 | 0 | | |
20 | /DSD/SV_RACOCIMI | DSD SV: Check-Out / Check-In - Items | 4 | ITEMNR | DSD - RA: Check-Out / Check-In - Item Number | nvarchar | 6 | 0 | | |