| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_ACADEMIC_FAV | User-Specific Favorites for Academic Titles | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
2 | BBP_ACCASSC_FAV | User-Specific Favorites for Account Assignment Categories | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
3 | BBP_ACSTRING_FAV | User-Specific Favorites for Account Assignment Strings | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
4 | BBP_ALLROLES_FAV | User-Specific Favorites for Roles (attribute-dependent) | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
5 | BBP_ASSETCL_FAV | User-Specific Favorites for Permitted Asset Classes | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | BBP_ASSETNO_FAV | User-Specific Favorites for Permitted Assets | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | BBP_ASSETSUB_FAV | User-Specific Favorites for Asset Subnumbers | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
8 | BBP_BOBUSER_FAV | User-Specific Favorites for Requester / Buying on Behalf of | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
9 | BBP_CATALOG_FAV | User-Specific Favorites for Permitted Catalogs | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
10 | BBP_CATEGORY_FAV | User-Specific Favorites for Product Categories | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
11 | BBP_COMMITEM_FAV | User-Specific Favorites for Permitted Commitment Items | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
12 | BBP_COMPCODE_FAV | User-Specific Favorites for Permitted Company Codes | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
13 | BBP_COSTCENT_FAV | User-Specific Favorites for Permitted Cost Centers | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
14 | BBP_COUNTRY_FAV | User-Specific Favorites for Countries | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
15 | BBP_CURRENCY_FAV | User-Specific Favorites for Currencies | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
16 | BBP_DOCTYPE_FAV | User-Specific Favorites for Permitted Document Types | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
17 | BBP_FUNCAREA_FAV | User-Specific Favorites for Permitted Functional Areas | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
18 | BBP_FUNDCENT_FAV | User-Specific Favorites for Permitted Funds Centers | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
19 | BBP_FUND_FAV | User-Specific Favorites for Permitted Funds | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
20 | BBP_GRANT_FAV | User-Specific Favorites for Permitted Grants/Subsidies | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
21 | BBP_GRCPLANT_FAV | User-Specific Favorites for Permitted Plants | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
22 | BBP_GRCUSER_FAV | User Spec. Favorites for Goods Recipient (Person) | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
23 | BBP_INDUSTRY_FAV | User-Specific Favorites for Industry Sectors | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
24 | BBP_KNT_ATTR_FAV | User Specific Favorites for Acct Assgmt Categ. (Attribute) | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
25 | BBP_LANGUAGE_FAV | User-Specific Favorites for Languages | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
26 | BBP_LEGAL_FAV | User-Specific Favorites for Legal Forms | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
27 | BBP_LOCATION_FAV | User-Specific Favorites for Permitted Locations | 7 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
28 | BBP_LOGSYS_FAV | User-Specific Favorites for Logical Systems | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
29 | BBP_NAMEFORM_FAV | User-Specific Favorites for Name Formats | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
30 | BBP_NETWORK_FAV | User-Specific Favorites for Permitted Networks | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
31 | BBP_OPI_CAT_FAV | User-Specific Favorites for Permitted Vendor List | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
32 | BBP_ORDERNO_FAV | User-Specific Favorites for Allowed Orders | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
33 | BBP_PAYMENT_FAV | User-Specific Favorites for Terms of Payment | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
34 | BBP_PAYMTERM_FAV | User-Specific Favorites for Terms of Payment | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
35 | BBP_PCARD_FAV | User-Specific Favorites for Procurement Card Companies | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
36 | BBP_PGRPCOMP_FAV | User/Company-Spec. Favorites for Purchasing Groups | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
37 | BBP_PLANT_FAV | User-Specific Favorites for Permitted Plants | 6 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
38 | BBP_PORGCOMP_FAV | User/Company-Spec. Favorites for Purchasing Organizations | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
39 | BBP_PRODUCT_FAV | User-Specific Favorites for Products | 13 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
40 | BBP_PURCHGRP_FAV | User-Specific Favorites for Purchasing Groups | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
41 | BBP_PURCHORG_FAV | User-Specific Favorites for Purchasing Organizations | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
42 | BBP_QMSYSTEM_FAV | User-Specific Favorites for Quality Management Systems | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
43 | BBP_REGION_FAV | User-Specific Favorites for Regions | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
44 | BBP_RFC_LOGS_FAV | User-Specific Favorites for RFC Destinations | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
45 | BBP_ROLE_FAV | User-Specific Favorites for Permitted Roles | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
46 | BBP_SDDOCPOS_FAV | User-Specific Favorites for Customer Order Items | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
47 | BBP_SDDOC_FAV | User-Specific Favorites for Permitted Customer Orders | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
48 | BBP_STORAGE_FAV | User-Specific Favorites for Permitted Storage Locations | 7 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
49 | BBP_TAXCODE_FAV | User-Specific Favorites for Tax Types per Country | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
50 | BBP_TAXGROUP_FAV | User-Specific Favorites: Tax Groups for Tax Type | 7 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
51 | BBP_TAXNUMT_FAV | User-Specific Favorites for Tax Number Types | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
52 | BBP_TAXTYPE_FAV | User-Specific Favorites for Tax Types per Country | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
53 | BBP_TENDTYPE_FAV | User-Spec. Favorites for Trans. Types (Bid Invitation) | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
54 | BBP_TIMEZONE_FAV | User-Specific Favorites for Time Zones | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
55 | BBP_UNIT_FAV | User-Specific Favorites for Units of Measure | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
56 | BBP_VENDOR_FAV | User-Specific Favorites for Vendors | 4 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
57 | BBP_WBSELEM_FAV | User-Specific Favorites for Permitted WBS Elements | 5 | LAST_USED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPAppointment Calendar |
58 | SCLASTUSED | Last user whose calendar was displayed | 3 | LAST_USED | Name of the last calendar to be processed | nvarchar | 12 | 0 | | |
TOPBusiness Context Viewer |
59 | /BCV/D_LCNS | License Audit Data | 4 | LAST_USED | Date | nvarchar | 8 | 0 | | |