| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CMS_ARC_CAG | CAG Archiving table | 10 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
2 | CMS_ARC_INS | Insurance Archiving table | 11 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
3 | CMS_ARC_MOVABLES | Movables Archiving Table | 11 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
4 | CMS_ARC_RBL | Receivables Archiving Table | 10 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
5 | CMS_ARC_RE_OBJ | Real Estate Archiving Table | 10 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
6 | CMS_ARC_RIG | RightsArchiving table: Includes claims and patents also | 11 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
7 | CMS_ARC_SEC_ACC | Securities Account Archiving Table | 10 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
8 | CMS_ARC_SHP | Ship Archiving Table | 10 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
9 | REQHEADS | Temporary Header Data: Requirement Coverage Request (Limit) | 57 | BLOCK_IND | Block release of entry sheet | nvarchar | 1 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
10 | /LIME/HU_I003 | LIME - HU Key SSCC | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
11 | /LIME/HU_S003 | Shadow Table for LIME - SSCC | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
12 | /LIME/LOC_I001 | LIME - Location Key Plant, Storage Location (R/3) | 8 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
13 | /LIME/LOC_I002 | LIME - Location Key Plant (R/3) | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
14 | /LIME/LOC_I003 | LIME - Location Key GLN | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
15 | /LIME/LOC_I004 | LIME - Location Key DUNS+4 | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
16 | /LIME/LOC_I005 | LIME - Location Key APO Location (F&R) | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
17 | /LIME/LOC_I006 | LIME - Location Key Location GUID (ICH) | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
18 | /LIME/LOC_I007 | LIME - Location Key Partner (incl. R/3) | 8 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
19 | /LIME/LOC_I008 | LIME - Location Key Means of Transport, Code (incl. R/3) | 8 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
20 | /LIME/LOC_S001 | Shadow Table for LIME - Plant, Storage Location (R/3) | 8 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
21 | /LIME/LOC_S002 | Shadow Table for LIME - Plant (R/3) | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
22 | /LIME/LOC_S003 | Shadow Table for LIME - GLN | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
23 | /LIME/LOC_S004 | Shadow Table for LIME - DUNS+4 | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
24 | /LIME/LOC_S005 | Shadow Table for LIME - APO Location (F&R) | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
25 | /LIME/LOC_S006 | Shadow Table for LIME - Location GUID (ICH) | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
26 | /LIME/LOC_S007 | Shadow Table for LIME - Partner (incl. R/3) | 8 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
27 | /LIME/LOC_S008 | Shadow Table for LIME - Means of Transport, Code (incl. R/3) | 8 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
28 | /LIME/PN_ITEM | Table to Save Prima Nota Item Data | 83 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
TOPGlobal Trade Services |
29 | /SAPSLL/L_IG01 | GTS - Location Table for Customs Warehouse IDs | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |
30 | /SAPSLL/L_SG01 | GTS: Shadow Location Table for Customs Warehouse IDs | 7 | BLOCK_IND | Blocking Indicator | nvarchar | 1 | 0 | | |