| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 18 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 46 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 18 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 46 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
5 | FIKZD_PROPTAX | Property tax Kazakstan | 52 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
6 | FIKZD_TRTAX | Transport tax Kazakstan | 42 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
7 | T084A | Restart information for legacy asset data transfer | 6 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
TOPBasic Functions |
8 | ANLA | Asset Master Record Segment | 73 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
TOPEquipment |
9 | EQUI | Equipment master data | 12 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
TOPFunctional Locations |
10 | IFLOT | Functional Location (Table) | 40 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
11 | IFLOT_VS | Functional Location (Version Table) | 41 | INVNR | Inventory number | nvarchar | 25 | 0 | | |
TOPGlobal Trade Services |
12 | /SAPSLL/CUIV | SLL: Customs Document: Bill | 5 | INVNR | Invoice Number | nvarchar | 40 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
13 | DFMCAINV | Invoice in IS-PS-CA: Header Data | 2 | INVNR | Invoice Number | nvarchar | 12 | 0 | | |
14 | DFMCAINVPOS | Invoice in IS-PS-CA: Items | 2 | INVNR | Invoice Number | nvarchar | 12 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
15 | /BEV3/CHBSALEI | Payment in Kind Agreement | 9 | INVNR | Inventory Number | nvarchar | 25 | 0 | | |
TOPReporting |
16 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 9 | INVNR | Inventory number | nvarchar | 25 | 0 | | |